Changes in PCSACC/400 as from march, 3th. 2003
Please use the below shown Drop-Down Menue.
back to topChanges in PCSACC/400 V3R2M1 dated march, 3th. 2003
Subexit
programs
Subexit programs are possible for all interfaces. QPCS/QRPGLESRC contains
sample programs, all programs are also available as object. Changes will
be active immediately if the corresponding program of PCSACC/400
is active for the interface.
SQL/ODBC
The maximum string length has been enhanced from 4096 Bytes (4K)
to 32512 Bytes (31 3/4K) . This eliminates existing restrictions.
The corresponding field in the user recordfor controlling of records being
too large has been removed. As soon as the SQLstring exceeds 4096 Bytes,
a follow-on record will be created in file PCOUT2. A maximum of 8 records
can be used to represent an SQL string.
Starting with OS/400 V4R3 support is provided for file names of up to 128 Bytes.The short name that automatically is being provided by OS/400 will be stored. Upper and lower cases will be considered. A select * from test."ITEMM" file TEST/ITEMM will be processed, for select * from test."itemm" the original OS/400 name will be searched. If the file has been created like that, the OS/400 name could be .:TEST/"ite0001". Up to now the programs did not recognize these special details.
If a new file is being created via e.g. CREATE TABLE QGPL."This is a fine new file", PCSACC/400 does not automatically create a record in file QPCS/PCFUNC. At this point of time the new short file name has not yet been created by OS/400, and the WRITE operation is being deferred via a new work file. The WRITE will be executedat the following operation, like e.g. an INSERT INTO. This allows to process longfile names without limitations. If no text is being used, the long name will be written into this field. The long name will also be displayed on the second page for file maintenance. OS/400 does not support long library names.
OS/400 release V5R1 and iSeries Navigator
The following program CALL's will be removed from all users and only be
stored at user QDEFAULT.
QGY/QGYSETG QSYS/QSYRTUFI QSYS/QSYRTVFI
Additionally, a bypass flag has been implemented for CALL records. These CALL's will be allowed in the future and will not be logged. If a user is not registered he will not be created when performing these commands. Thus, pure 5250/TELNET users will no longer appear in the file. As user names without data authorities are being displayed in green and can separately be selected via F5 = Update, pure Telnet user can now be identified and removed.
In case further unnecessary CALL's appear, they can be added to user QDEFAULT and can then be ignored.
Group profile QNEW
QNEW is intended for marking of new users. This name is no longer
being controlled as group from the maintenance as well as from all exit
programs. QNEW will be removed at activation via option A.
Thus, there are no longer performance disadvantages if this name is contained
in the group field.
Maintenance program CHGPCS
All fields from row 24 have been removed from all important displays of
base program CHGPCS (user, library, file and subfile) where error messages
are being displayed.An error subfile has been created to display the messages
on the normal screen area and no longer on the status display of the emulation.
Additionally, the display willno longer be locked. This function will
be provided for all displays with PCSACC/400 V4.
Command CHGPCS does no longer contain parameter. All displays have been redesigned and colours have been reduced. Colour red will nowbe used for important functions only. Unnecessary notes have been removed from thepages. Fields: change class and change authority now contain values 0/1 only.The values have been changed. Change class 0 = none, 1 = all users. Change authority 0 = Display, 1 = update. A new field is being provided for locking of users. The values will be adjusted during installation.
On the screen for displaying all users the colouring has been changed. The user and group will be displayed in white or green, these colours are of importance.
If the user is being displayed in green he does not have any data authority. If he is being displayed in white data authority exist. The same logic has already been used on the userdisplay for access fields. If a group is being displayed in green, all accesses will be performed via the group. If the group is being displayed in white, additional authorities exist. Character + will no longer be used.
Additional controlling has been added. A green user should be member of green group, a white user of a white group. Deviating combinations are not logical and should be corrected. Either a white user has data authorities that will not be considered for a green group or a green user will be checked for existing data authorities for a white group but does not have any authorities.
Underscored users are administrators of PCSACC/400.
New display options are being provided for F5 Update.
The change date will now be updated for options: A, T and U. Option U can be performed once only, if R is active, the option will be ignored.
The limited maintenance functions have been enhanced in order to only allow displaying of all, including log data. Telnet maintenance is excluded here.
Maintenance
of commands (CHGCMD) and IP addresses (CHGIPA)
Screen layout for single records has been adjusted according to other
programs. Now all programs have a similar layout.
Conversion of access informations into access authorities
The new command CVTPCSLOG can now be executed on a regular basis
via ADDJOBSCDE, e.g. every day at 6 p.m. Access authorities of
all users having value 1 in the new field Automatic conversion
of log data via CVTPCSLOG ? will be considered. Additionally,
the users will be set into test mode. This command is intended for new
automatically created users only. This field can only be set to 1
if the user is in test mode or none of the following fields does contain
the specified values:
PTRER
2/3 SQL/ODBC
PDDM 2/3 DDM
PDTQ 2 Data queues
PORD 2/3 PC IFS accesses
PQSYS 2 PC IFS: QSYS.LIB
PFTPF 2/3 TCP/IP FTP database accesses
PORDF 2/3 TCP/IP FTP IFS accesses
PIPAS 2 TCP/IP FTP/TFTP/REXEC server accesses
PIPAC 2 TCP/IP FTP client accesses
PFTPC 2 TCP/IP FTP commands
PREXEC 2 TCP/IP REXEC commands
PRMCMD 2 PC remote commands/iSeries Navigator
PSBCMD 2 DDM SBMRMTCMD
If one of these fields is being changed or the user is being activated, field Automatic conversion of log data via CVTPCSLOG ? will automatically be set to 0. This ensures that rejected accesses of a user will not be converted into access authorities automatically if this user is in production, that means he is a controlled user. This field may also be set via the quick maintenance menu, including checking if changes are being allowed.
Users with 1 in the field for automatic conversion via CVTPCSLOG will be marked with V on the display.
Reorganization
Command RGZPCS does now contain a new parameter.
Type of records to be deleted . . . . . TYPE with *ALL,
*ALLOWED or *REJECTED, default value is *ALL. This
allows to keep e. g. all rejected accesses (*ALLOWED=delete allowed
accesses).
If RGZPCS cannot be performed as the system is in production for 24 hours, command CLRPCSLOG can be used with the same parameters as RGZPCS in order to delete log data during daily operations. This command should be submitted to batch or executed on a regular basis via ADDJOBSCDE.
Command RGZPCS does perform a RGZPCS CLRPFM(*YES) TYPE(*ALL) while command CLRPCSLOG will delete each single record.
Both commands do now consider TELNET log data.
Command
ADDPCSOWN
It is possible to add a new user as owner of PCSACC/400 with the
new command ADDPCSOWN or to change an existing user record.
Changes
in PCSACC/400 V3R2M2 dated april 20th. 2003
New commands
Command GETUSRTXT can be used to adopt the descriptions of OS/400
user profiles.
Command CHKUSRPRF can be used to delete users without user profiles and should always be performed in batch.
Commands CVTPCSLOG, PRTSPC, GETUSRTXT, CHKUSRPRF and CLRPCSLOG should be performed via job scheduler on a regular basis. A new menu CHGWRK simplifies the use of ADD/WRKJOBSCDE for this kind of actions.
Application
menu instead of F24
Entry is via the new application menu which can be called by using F16
and which also contains the existing TELNET calls. All program calls via
function keys have been transferred into this menu, function key F24 is
no longer necessary.
Format
control on file level
Controlling of file creation date CJJJJMMDDHHMMSS or level check format
on file level ist new. One level check format is allowed only.
If a query user produced an output to a file and this file has been transferred into Excel with authority of PCSACC/400, this query could later be changed and access to confidential data has been possible. With the active format control an error message will now be issued: No access to this file as file format has been changed. A new field exists for format control on the second page of file maintenance, also allowing controlling via radio button.
Reorganization
Command CHKUSRPRF now is also parameter in command RGZPCS.
The new command RGZMASTER should now be used instead of command
RGZPCS in the STRUP-program in order to gain better control about
the execution of reorganization. Command RGZMASTER retrieves the
command from data area RGZPCS and additionally contains an action
field and status informations.
Command RGZSET and *RUN, *BYPASS or *NEXTRUN allows to externally control execution of reorganization via command RGZPCS. A new maintenance program exists in the new application menu.
TELNET
Display of TELNET-IP address records now is also possible in generic name
sequence. This can be helpful if generic names have been assigned for
all users
Maintenance programs
Sveral small problems are removed in the maintenance programs.
A problem in the installation program for a first time installation was removed.
Changes in PCSACC/400 V3R2M3 dated august 19th. 2003
Reorganization
and Open problems
New system values can now be used to specify whether access shall be rejected
or allowed by the exit programs for open problems and whether a message
shall be issued about the problem. shall be issued about the problem.
If command RGZMASTER/RGZPCS is being executed in the QSTRUP
program problems may occur with automatic starting of TCP/IP from
OS/400. If TCP/IP has been started before completion of reorganization,
client accesses e.g. netserver accesses, DDM accesses cannot be performed
properly as the exit programs yet cannot access the PCSACC/400 files.
It is recommended to include command STRTCP into QSTRUP program
after reorganization and to prohibit automatic start via CHGIPLA for
V5Rx.
For V4R4 and V4R5 the autostart job for automatic starting
of TCP/I from subsystem QSYSWRK via command RMVAJE SBSD(QSYS/QSYSWRK)
JOB(STRUPTCPIP) has to be removed.
Email addresses for anonymous accesses
Entry is now limited to 32 Bytes as only 32 Bytes are being transferred
to the exit program for TCP/IP login control. A validit check will also
be performed. Information is being stored in lower cases. Adjustment is
being performed automatically during installation.
CHGPCS - Display user text
Via update function selection is now possible whether a part of thet ext
shall be overlayed with DB, IFS, CMD, IP and/or
MAIL informations These values will be displayed if corresponding
data records are stored with the user. Additionally, selection can be
made which records shall be displayed, e.g. only users with database records.
All values set to = 1 per default, will be saved at program exit.
A reset key is being provided in the refresh window.
Exit programs - sending of error messages to user
For SQL/ODBC (programs PCSSQ2 and PCSFIL) no messages will be sent to
the user. In all other exit programs, SNDBRKMSG can be sent to
the users workstation instead of SNDMSG, if the user is signed
on with a 5250 session.
System values have been resorted
For all submitted jobs, job description QPCS/QBATCH will be used
instead of job description QDFTJOBD. The job queue and out
queue can be changed via new system values. This allows to route all
print output in a specific out queue. *USRPRF is default. An out
queue QPCS/QPRINT has been added.
Print
formats
Print formats can be selected via a new system value. The following
will be supported:
1 = Format Din A4 - 21 x 29,7 mm
2 = Format Letter - 21,59 x 27,94 mm
3 = Format Legal - 21,59 x 35,56 mm
4 = Format Executive - 18,41 x 26,67 mm
5 = Format B5 (JIS) - 18,2 x 25,7 mm
Print all user data
Program PRTPCS now received a shortened list, each data record
creates a single line only. Field contents will not be displayed. This
allows easier comparison of different users.
On the Homepage, value TYPE of command PRTPCS will be saved, for
option 6 = Print user record this value will be used.
Controlling
of IP addresses
IP address maintenance of TCP/IP FTP and display of TELNET log data now
uses the IP address checking of the TELNET maintenance program. If an
invalid value is being entered for refresh, the refresh will start with
*BLANK.
Work with directories
The file PCFLR for folder access type 0 was removed.
This folder are used by DOS 640 K client. At installation
time the data are transfered to the file PCIFS. Exitprogram
DDMACC and transfer program LOGPCS are still supporting folder
type 0 - /QDLS/ was added to the data.
The maintenance program für directories was refreshed. You can get
information direct from IFS in OS/400 like command WRKLNK using
option 7 on record level or function key F7. User profil
QPCSFLR is no longer needed.
All text for IFS information was changed, only directories and
streaming files is used instead of path, folder, PC file etc..
Changes in PCSACC/400 V3R2M3 dated september 10th. 2003
Problems
with exit programs
With V5R2 problems existed with authority list QPWFSERVER
and the IFS exit program PCSIFS. Additionally, an unknown defect
Ptf from Cumm C03161 caused problems. Other exit programs ended
abnormally when retreiving the system value QDATE via API. With this version
all exit programs have been converted for use of an MI-API. Thus, these
errors don't occur any longer.
SQL/ODBC
and OVRDBF
If the library is missing in an SQL/ODBC command, checking
is being performed if an active OVRDBF exists. These values
have been adopted, even if *CURLIB or *LIBL
has been specified for the library. The correct library has not been
determined via *LIBL.
Now, only names from an OVRDBF will be adopted, *LIBL
or *CURLIB for the library or *FIRST
for the file member will be ignored. If the library then is still
missing the previous search will be performed.
If a file with an active OVRDBF is being rejected, it has been ignored
during conversion into access authorities as data have no longer been
available. Now these values will be saved and incorporated - for 1 file
with rejected access.
Access to QSYS/QADBXFIL with WHERE DBXLIB=?, that means
with a variable will now be allowed and ignored.
Various little errors have been corrected.
Changes in PCSACC/400 V3R2M3 dated september 29th. 2003
Error
in exit program PCSSQ2
An error in the date routine for new test installations has been eliminated.
Support
for long file names
File name QGPL.Thisismyfile is not being converted as file
name, Thisismyfile has been used instead of THISISMYFILE.
Error
in installation program
During conversion of PCSACC/400 V3R1M0 or V2 versions, file
EXITPP has been cleared. Program PCSNETA will then run into a subfile
error.
Documentation
All documentation from September 10th 2003 is still valid.
Changes in PCSACC/400 V3R2M4 dated december 12th. 2003
Enhancements
in SQL/ODBC programs PCSSQ2 and LOGPCS
Now, very complex SQL commands with imbedded sub-SELECT's between SELECT
and FROM-parameter and A SELECT used instead of a file name after a FROM
or JOIN verb are supported.
Example
SELECT pomhst.ponumb, pomhst.pobuyr, apsupp.asnum,
apsupp.asname,
Sub1.istyl#, concat(concat(
concat(Substr(Digits(Value((select min(efdat.invzza.ibald6)
from efdat.invzza where efdat.invzza.inumbr in (select invmst.inumbr
from invmst where invmst.iponum = :OrderNr)), ----> from
SELECT * FROM (SELECT * FROM
SELECT * FROM TEST.ARTIKLL LEFT INNER JOIN (SELECT * FROM
CREATE SCHEMA is also being supported CREATE with nested commands.
The
new field PWRK3 can be used for release of
CALL QCMDEXC(?, ?)
with variable parameters. This function sometimes is required for Java
applications.
User QDEFADD: Default values for IFS records
Three new default values are now being used for adding of new records
in maintenance program CHGPCS, for calling of program OBJIFS, for function
key F7 and for exit programs PCSIFS and PCSFTP for adding of directories
on systemdrive level.
Some errors have been eliminated in the maintenance program for default
values. Exit programs PCSIFS and PCSFTP now allow deletion of directories
on systemdrive level and add records withing PCSACC/400 at creation.
Maintenance program CHGPCS
When refreshing via command key F5=Refresh, use of a wildcard '*10*' or
'*10 *' now is being allowed.
Commands
RGZPCS and CLRPCSLOG
If parameter CLRPFM(*YES) is being used and parameter CLRFROM is not equal
00, processing will be cancelled.
Conversion of log records with option S for a user in program DSPLOG
Display log records
If the user is part of a group and field Check additional own authorities
is = 0 and if he is getting data authorities thru the conversion, this
field will now automatically be set to value 1 activate the authorities.
For option U and the entered user is QNOCHECK the values from the user record QNOCHECK will be taken. The group QNEW was removed, no reset sign was set. If the user has information records then a window like Option D and function key F22 is displayed. A job to delete information records in batch can be submitted.
This us usefull for automatic batch job user profiles to deactivate
all control and write no more records to information files.
Program CHGTEL of TELNET maintenance
If a user name is specified for controlling of autosignon in an IP record
checking will be performed whether a user profile exists. If a weekly
calendar name is specified in an IP record checking will be performed
whether a calendar record exists.
Deletion of useres via CHGPCS and CHKUSRPRF
Both programs can be used to delete user records if required. Deletion
of log data will be submitted to batch via SBMJOB. Up to now this did
not function correctly. At installation of this version, a job is submitted
to batch eliminating the problem.
Fields PORD and PORDF - generic access to IFS
Now, generic search will always be performed if the complete path has not been found. This eliminates option 3. The fields will be adjusted at installation. Thus, generic control can only be performed in IFS records.
IP addresses for TCP/IP FTP and REXEC
The IP addresses have been adjusted to TELNET. That is, internally they
will be stored in 15 digits and will be filtered for display.
The wildcard character has been changed from 0 to *. Complete wildcard
now also is possible as new fields have been added.
A new, additional key now allows to have separate records for FTP server accesses, FTP-SERVER, for FTP client accesses FTP-CLIENT and for REXEC server accesses REXEC-SERV. Data will be adjusted at installation.
This allows for differentiation between the separate access types per
IP address.
Additionally, a weekly calendar can be selected. If then wildcard *.*.*.*
is being used, a general weekly calender for e.g. all FTP server accesses
is possible.
Crossover function for TCP/IP FTP and REXEC
In addition to the current Anonymous support, which is based on
entry of an Mail address, now a Crossover function is being provided.
This prevents that an FTP user knows about OS/400 user names and passwords
that might be missused for TELNET access. It is now possible to create
a user record, e.g. SMITHFTP in PCSACC/400 that is not allowed
to exist within OS/400. 3 can now be specified in the field for server
IP control for the crossover function. In the IP address record e.g. password
SMITH2003 will now be stored encrypted for user SMITHFTP and
the OS/400 user specified e.g. SMITH. Now the FTP user signs
on with SMITHFTP and SMITH2003 PCSACC/400 will control
the values and signs on the user within OS/400 as user SMITH. The
FTP user will only see the messsage User SMITH signed on and does
not know the password of SMITH. This provides enhanced access
security for FTP/REXEC.
Changes in PCSACC/400 V3R2M4 dated december 19th. 2003
Program
LOGPCS - bugfix
TELNET info data are not correct converted into access rights.
Program PCSFTP - bugfix
FTP client access to FTP server from 5250 emulation or from batch was
allways rejected if ip address control was defindes with option 2.
Program CHGPCS - new function
Option U: with QNOCHECK can now delete all stored user data.
Changes in PCSACC/400 V3R2M4 dated january 6th. 2004
Program
PCSSQ2 - Bug fix
The following SQL commands now also are being supported:
SELECT
SL851PF.CONTNUM Col1002,SL851PF.UNDYEAR Col1003,Col1007,
Col1008 FROM NLSNAS04.SLTEST.SL851PF SL851PF,(SELECT
SL236JF.UNDYEAR Col1005, SL236JF.ENDTNUM Col1006,
SL236JF.COVEXTN Col1008,SL236JF.LINENUM Col1007 FROM
NLSNAS04.SLTEST.SL236JF SL236JF WHERE
SL236JF.COVEXTN<>'') Qry1009 WHERE Col1006=SL851PF.ENDTNUM
AND Col1005=SL851PF.UNDYEAR
Program LOGPCS - Bug fix
Conversion of DDM commands (SBMTMRCMD) into access authorities did not
work since long time.
Program PCSIFS - Bug fix
Netserver accesses to IFS - MOVE/RENAME of directories generally
is allowed below generic paths. This function has been deactivated with
the last adjustment.
Program PCSCMD - Bug fix
Processing of remote commands and iSeries Navigator: If field PRMCMD does
not contain value 1 or 2, value 2 will always be adopted (when 0 or blank).
Program CHGPCS
If invalid values exist in fields of a user record, they will be corrected
when being displayed. These changes will now be updated
automatically before being displayed.
Changes in PCSACC/400 V3R2M4 dated january 19th. 2004
Programs
RGZPCS and CLRPCSLOG - Bug fix
Problems are fixed in both programs.
Program CHGCAL - Bug fix
Wrong display of subfile after change of calendar record.
Sample program for installation in batch
For installation of PCSACC/400 from CD or from savefile QGPL/QPCS
sample code was added to QPCS/QCLSRC.
This code must be individually adapted.
Changes in PCSACC/400 V3R2M5 dated march 23th. 2004
OS/400
Start release
OS/400 Start release has been changed from V3R7 to V4R3.
PCSACC/400
V3R2M5 was tested up to OS/400 V5R3.
Date- and time operations
All exit and update programs now operate with time fields. Thus, these
programs are now independent from system values.
Program CHGPCS - Bugfix
Error when scrolling in group selection.
Program CHGPCS
F5=Update: Field group will no longer be deleted.
When displaying mail etc. the whole area will be deleted, text will no
longer be overlayed.
F5=Update: The default value of the reset function for display
of text field has been changed from 0 to 2
Program CHKUSRPRF - Bugfix
No deletion of user QNOCHECK .
Programs PCSCMD and LOGPCS - Bugfix
Distributed program CALL with QCMDEXC will not be resolved, possible
with bei VA RPG.
Program DSPLOG
More text added to screen.
Command
CLRPCSLOG - Bugfix
Records
in file PCOUT2 will not be deleted. During installation, a clearing program
will be submitted to batch.
Program PCSTEL - Bugfix
If
test periods expire, TELNET requests have been rejected.
Program LOGPCS - Bugfix
No
device records are created, if TELNET log data are converted.
Program PCSNETA - Bugfix
V5R3 was
added to the release table, to run program under
OS/400 V5R3.
Exitpoint PCSACC was removed from network attributes and moved to WRKREGINF.
Changes in PCSACC/400 V3R2M6 dated june 11th. 2004
Program
PCSNETA - Bug fix
The program DDMACC could not be activated.
Programs PCSDTQ and LOGPCS - new function
Access to data queues is now also permitted via * LIBL. Pseudo-library
#BLANK can now also be used.
Programs DSPLOG and LOGPCS - Bug fix
Long log records often have not been deleted. Incorrect data will be corrected
during installation via SBMJOB of program QPCS/KORRPCOUT2. Programs
DSPLOG and LOGPCS are now working correctly.
Programs PCSFTP and LOGPCS - new function
For FTP accesses, library-, file- and file member names are being determined.
If the member name is not valid, like e.g. 1.MBR the
complete request for conversion into access authority has been ignored.
Now, an invalid member name will be ignored by exit program PCSFTP
as well as by conversion program LOGPCS.
Programs
PCSSQ2 and LOGPCS - Bug fix
When displaying columns with SQL/ODBC, a SELECT ... DBXFIL=
is being initiated. This access is being allowed even without read authority
for file record in PCSACC/400.
Program CHGPCS - Bug fix
If multiple library records are being added in a loop and no text is being
entered, up to now the text has been determined from the object at the
first ADD only. Now the program can identify if the text remains unchanged
but the name has been changed and the text will be determined new from
the object.
When copying all files of a library, only the first has been copied if
the target library already exists.
Program DDMACC - Bug fix
In the test mode no more messages are sent to the remote system
Programm
PCSTEL - Bug fix
The second IP address has not been edited in an error message.
Program OBJPCS - new function
When displaying files, now DDM files will also be shown.
Programs
PCSSQ2 and LOGPCS - new function
For SQL/ODBC, temporary work files in a WITH - statement
are being ignored. A WITH will also be identified in an INSERT
INTO.
Program
PCSSQ2 - Bug fix
In SQL/ODBC, library #BLANK is being preferred if the searched
file name is stored there. The record has not been read due to an error.
Now the record will be identified at user, group or QDEFAULT.
Program LOGPCS - new function
For SQL/ODBC, no file record will be created during conversion
of log records in batch if the file is being stored in library #BLANK.
When converting single records via options S + G on the display
of log records (program DSPLOG), no checking will be performed
for the file in library #BLANK. As yet, a file record and eventually
a library record will be created or supplemented.
Program
CHGPCS - new function
User displays page 1,2 and 3 and library display have been rearranged
in table form. Affiliation of fields can now be
identified more easily.
Changes in PCSACC/400 V3R2M7 dated july 14th. 2004
Program
LOGPCS - Bug fix
If convert of protocol records into access rights runs in batch,
database records are ignored in V3R2M6 of PCSACC/400.
Converting runs in batch with command CVTPCSLOG. Converting
into batch was submitted from program CHGPCS option S/G
with cmd key F17 and program DSPLOG displaying protocol
records with cmd key F7.
Program DSPLOG displaying protocol records: Converting single
records with option S/G works correct.
Program DDMACC - Bug fix
Generic access to IFS subsystem QDLS with shared folder
type 0 client DOS 640 k was not supported. This client is 15 years
old and not very often in use.
Display file formats - Bug fix
2 formats are not converted to multi language support and still in german.
Programs PCSFIL and LOGPCS - Bug fix
Library #BLANK is now also supported for *NDB file operations
via SQL/ODBC client access file transfer (ADDPFM, CLRPFM
etc.)
All
exitprograms - new function
If an error message was send to an external message queue, now the message
id for example MSG0102 was added to the end of the message text.
Applications like Tango can now handle PCSACC/400 messages.
Changes in PCSACC/400 V3R2M8 dated january 12th. 2005
Programs
PCSSQ2 and LOGPCS - Bugfix
At a CREATE TABLE without library,
the default library has not been taken into considerations.
If, e.g. a requested file has not been found in *CURLIB or *LIBL for a SELECT without library, the Default library up to now has not been searched.
For completion of a FROM verb, searching has been performed in a specified sequence. Now, verbs following a JOIN will be ignored and the verb found next will be considered. A WHERE positioned in the rear part of a string has overlayed a previous GROUP BY. Thus,field names have been processed as file names.
A FROM n FOR n will now be ignored.
A SELECT * FROM TEST . ARTIKLL will now be accepted.
This means, blank spaces within a name between library and file are allowed
now.
Program CHGPCS - Bugfix
Command PRTLOG only once could be submitted to batch.
When updating a user record without OS/400 user profile, an existing text
has been deleted.
Program DSPLOG - Bugfix
Display of *CURLIB and *LIBL generally has been wrong. Values of the previously
read record have been displayed.
Program PCSNETA - Bugfix
File EXITPP has been changed. Exitpoint PCSACC in OS/400 V5R3 is now supported
as from OS/400 V4R2 to V5R2.
If command PCSNETA is called, language library QPCS.... is up now removed from *LIBL, when command ends.
Documentation
Chapter Frequently asked questions and answeres
now only is available via http://www.pcsacc400.com/first.htm.
Email
address for support
Email address busch@ewetel.net has been replaced by busch@pcsacc400.de.
The former address is no longer avilable, as it is being misused by spams.