|
PSPUTIL Release History
|
| |
| 01Jul2011. Decided to make source code library
PSPUSRC available to all current and future PSPUTIL users.
PSPUTIL is still not freeware or open source. Users may use
the source only to support their own use of PSPUTIL.
Recompiled all PSPUTIL objects to verify source in PSPUSRC
works OK. No functional change to PSPUTIL since earlier
release on 22Jan2011, but earliest target release changed
from V5R1M0 to V5R2M0. |
| 22Jan2011. Changed PCPYFRMCSV command to silently
ignore extra characters in input CSV fields. For example if
a value "ABCD" is copied to a 3-character database field,
the value "ABC" is derived. |
| 11May2009. Changed the way alphanumeric values are
reported in the RSAV1 and RSAV2 fields in the PCMPDBRS file
used by the PCMPDBF command. Also added a new field RSAVDP
to record the position of the 1st character in the source
data field where a difference was detected. See PCMPDBF
documentation for guidance on how to deal with the
change to the PCMPDBRS record format. |
| 16Apr2009. At request of current user, increased
the number of fields catered for by PCMPDBF command from 999
to 2048. |
| 07Mar2009. Extend PCPYFRMCSV command to correctly
initialise extra fields in database file (where CSV has less
field values than database file). |
| 29Jan2008. Fix to PCMPDBF command for comparison of
non-keyed files. |
| 27Dec2007. Enhancements to PCMPDBF command. New
fields in PCMPDBRS results file for 1) audit date/time the
record created, 2) field type - A = Alphanumeric etc., 3)
calculated difference for numeric field values. New MBROPT
command parameter allows results records to replace - the
previous default - or append to existing records. MBRRS
parameter allows new values *FILE1 and *FILE2. The command
now automatically creates the results file (RSFILE
parameter) if it does not already exist. It also supports
compare of DDM files in addition to physical and logical
files. See PCMPDBF
documentation for guidance on how to deal with the
change to the PCMPDBRS record format. |
| 29Oct2007. Enhancements to PCMPDBF command.
Increased size of any one alphanumeric field from 500
characters to 4096. This provides more flexibility in
comparing non-keyed files where the whole record has to be
defined as a key field. Also introduced new parameter RSFILE
to command. This makes it easier to store compare results in
your own compare results file. |
| 15Nov2006. Extended PCMPDBF to cater for Binary and
Hexadecimal fields. |
| 11Sep2006. Added new PCLRPFM and PRGZPFM commands. |
| 13Jul2006. Added new PRTVPFSZ comand. Extended
PRTVMSF command to build temporary file in QTEMP with same
SIZE() as the target file. This provides better control over
the number of records retrieved. |
| 27Mar2006. New parameters on PCPYTOCSV command.
More flexibility in the characters used to 1) separate
fields and 2) delimit alphanumeric fields. If those
characters occur in source data, they may also now be
replaced or dropped. This makes it less likely the target
platform will misinterpret the generated CSV records. |
| 21Feb2006. Fixed bug in PCMPDBF command. RRN
(Relative Record Number) was not being correctly reported in
PCMPDBRS results file when non-keyed files were being
compared. |
| 22Dec2005. Introduced checking of per-CPU licensing
on all utility commands/programs. Dropped the PCVTPFSAV and
PCVTSAVPF commands. |
24Nov2004. Several enhancements to PRTVMSF command:
- Allow communication with MS SQL Server on any port -
not just the one (1433) that it normally listens on.
- Use field definition of target ISeries file to
determine length of character fields imported from MS
SQL Server table.
- Allow replacement of CR and LF commands in source data
with alternative characters - makes it easier to deal
with CSV records that may have embedded CR and/or LF
characters in field values.
|
| 13Nov2004. PCPYFRMCSV, PCPYTOCSV and PRTVMSF
commands were previously limited to fixed characters for EOR
(end-of-record) marker i.e. CarriageReturn, Linefeed, or
CarriageReturn/LineFeed. All 3 commands now extended to
provide a way to identify any single character for EOR. |
11Sep2004. Significant enhancements to PCMPDBF
command at request of 2 new users:
- Larger range of field types that can be compared .
- Improved messages for compare errors/differences.
- Numeric field values compared increased from 9 to 15
decimal places.
- More detail reporting in PCMPDBRS results file.
- User can now specify up to 20 fields to ignore in each
file comparison e.g. timestamps where unimportant
differences highly likely.
See PCMPDBF documentation
for guidance on how to deal with the change to the PCMPDBRS
record format. |
| 25Jul2004. PRTVMSF command added. Minimum OS/400
release level now V5R1M0 (was previously V4R5M0). |
| 10Apr2004. PCPYTOCSV and PCPYFRMCSV commands
extended to allow any character as field delimiter (not just
a comma). |
| 2003. PFNDBADLF command added. |
| 1999. PCVTCLSRC command added. |
| 1998. PCHKACT, PCMPDBF, PCMPOUTQ, PCMPSPLF,
PCPYTOCSV, PCPYFRMCSV and PFIXDBF commands added. |
| 1995. First release: PCMPFMT, PCMPJRN, PCMPLIB,
PCMPSRC, PCVTPFSAV, PCVTSAVPF commands. |
