This page contains a short description of each utility included in this download. Some utilities will have a link to a more detailed description of that utility.
| Utilities Included: | Bottom |
| CHKLVLS Command | Back to list |
The CHKLVLS command checks for and lists any potential level checks within a given
library list.
The word "potential" is used because the library list used is assumed to be complete
and overrides are not taken into effect.
The command prompted appears as follows:
Check for Level Checks (CHKLVLS)
Type choices, press Enter.
Submit job to batch . . . . . . *YES *YES, *NO
Job description . . . . . . . . *USRPRF Name, *USRPRF
Library . . . . . . . . . . . Name, *LIBL, *CURLIB
Hold on job queue . . . . . . . *JOBD *JOBD, *YES, *NO
Enter the values to submit the job with and press Enter.
You will be prompted to edit your library list.
Edit the library list that you want to check for level check errors and press Enter.
| CRTASCHM Command | Back to list |
The CRTASCHM command creates an "ASCII schema file" in a shared folder for use with
some PC programs that use this to perform ASCII comma-delimited file conversions.
The command prompted appears as follows:
Create ASCII Text Schema File (CRTASCHM)
Type choices, press Enter.
From file . . . . . . . . . . . __________ Name
*LIBL LIBRARY
To folder . . . . . . . . . . . ____________________________________________
____________________________________
To document . . . . . . . . . . *FROMFILE Character value, *FROMFILE...
Enter the file and library name of the file you want defined, the folder name where
you want the schema file placed, and optionally the schema file name.
| CRTPCOVL Command | Back to list |
The CRTPCOVL command can be used to create forms overlays for an IBM Intelligent Printer Data Stream (IPDS) printer.
This overlay can be created from any Windows ® application that can print to a Windows printer (such as Microsoft Word ®)
Create Overlay from PC Doc (CRTPCOVL)
Type choices, press Enter.
Overlay . . . . . . . . . . . . __________ Name
Library . . . . . . . . . . . QGPL Name, *LIBL
From folder . . . . . . . . . . OVERLAYS____________________________________
____________________________________
From document . . . . . . . . . *OVL Character value, *OVL
Text 'description' . . . . . . . *OBJTXT_____________________________________
______
Enter the resulting overlay object and library names, the folder name for the PC generated
overlay image, the document name, and the object text (if this is the first time created).
| CVTTOPCD Command | Back to list |
The CVTTOPCD command can be used to convert AS/400 ® data files to an ASCII
comma-delimited file in a shared folder for use by any PC program.
This command was featured in the March 1995 NEWS/400 by Peter Clifford and I use it all the
time.
Convert to PC Document (CVTTOPCD)
Type choices, press Enter.
From file . . . . . . . . . . . __________ Name
*LIBL LIBRARY
To folder . . . . . . . . . . . ____________________________________________
____________________________________
From member . . . . . . . . . . *FIRST Name, *FIRST
To document . . . . . . . . . . *FROMFILE Character value, *FROMFILE...
COPYRIGHT (c) 1995 Duke Communications International
Enter the file and library name of the file to convert, the folder name to place the ASCII
text file into, the member name, and resulting PC file name.
| GETRMTF Command | Back to list |
The GETRMTF command can be used to obtain AS/400 ® and non-AS/400 data files from an
AS/400 ® or a connected server to another AS/400 ® or server, using FTP over TCP/IP connections.
The first parameters displayed on the command prompt are the Remote User ID, Password, and
System Name, as well as the From and To file types.
These are as follows:
GET Remote File (GETRMTF)
Type choices, press Enter.
Remote user profile . . . . . . __________ Name, *CURRENT
Remote user password . . . . . . Character value
Remote system . . . . . . . . . ____________________________________________
________________________________________________________________________________
________________________________________________________________________________
____________________________________________________
From file type (AS/400 / IFS) . *AS400 *AS400, *IFS
To file type (AS/400 / IFS) . . *AS400 *AS400, *IFS
This command is too complex to describe here. For a detailed description see the GETRMTF manual.
| OFF Command | Back to list |
The OFF command is simply an abbreviated SIGNOFF command.
Sign Off (OFF)
Type choices, press Enter.
Job Log . . . . . . . . . . . . *NOLIST *NOLIST, *LIST
Drop Line . . . . . . . . . . . *DEVD *DEVD, *YES, *NO
End Connection . . . . . . . . . *NO *YES, *NO
Simply enter the same parameters as you would for the SIGNOFF command.
| PUTRMTCMD Command | Back to list |
The PUTRMTCMD command can be used to execute an AS/400 ® command on a remote
AS/400 ®, using FTP over TCP/IP connections.
The first parameters displayed on the command prompt are the Remote User ID, Password, and
System Name, as well as the Command string and whether to submit the job to batch or not.
These are as follows:
PUT Remote Command (PUTRMTCMD)
Type choices, press Enter.
Remote user profile . . . . . . Name, *CURRENT
Remote user password . . . . . . Character value
Remote system . . . . . . . . . ____________________________________________
________________________________________________________________________________
________________________________________________________________________________
____________________________________________________
Command to execute . . . . . . . ____________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
____________________________________________________________________ ...
Submit job to batch . . . . . . *YES *YES, *NO
This command is too complex to describe here. For a detailed description see the PUTRMTCMD manual.
| PUTRMTF Command | Back to list |
The PUTRMTF command can be used to send AS/400 ® and non-AS/400 data files from an
AS/400 ® or a connected server to another AS/400 ® or server, using FTP over TCP/IP connections.
The first parameters displayed on the command prompt are the Remote User ID, Password, and
System Name, as well as the From and To file types.
These are as follows:
PUT Remote File (PUTRMTF)
Type choices, press Enter.
Remote user profile . . . . . . Name, *CURRENT
Remote user password . . . . . . Character value
Remote system . . . . . . . . . ____________________________________________
________________________________________________________________________________
________________________________________________________________________________
____________________________________________________
From file type (AS/400 / IFS) . *AS400 *AS400, *IFS
To file type (AS/400 / IFS) . . *AS400 *AS400, *IFS
This command is too complex to describe here. For a detailed description see the PUTRMTF manual.
| PUTRMTLIB Command | Back to list |
The PUTRMTLIB command can be used to send an entire AS/400 ® library to a remote
AS/400 ®, using FTP over TCP/IP connections.
The first parameters displayed on the command prompt are the Remote User ID, Password,
System Name, Library to send, and Save File to use, as well as the Command string and
whether to submit the job to batch or not.
These are as follows:
PUT Remote Library (PUTRMTLIB)
Type choices, press Enter.
Remote user profile . . . . . . Name, *CURRENT
Remote user password . . . . . . Character value
Remote system . . . . . . . . . ____________________________________________
________________________________________________________________________________
________________________________________________________________________________
____________________________________________________
Library name to copy . . . . . . Name
Save file on target system . . . Name
Library . . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB
Submit job to batch . . . . . . *YES *YES, *NO
This command is too complex to describe here. For a detailed description see the PUTRMTLIB manual.
| PUTRMTOBJ Command | Back to list |
The PUTRMTOBJ command can be used to send an AS/400 ® object from an AS/400 ® to
another AS/400 ®, using FTP over TCP/IP connections.
The first parameters displayed on the command prompt are the Remote User ID, Password,
System Name, Object name and type to send, Save File to use, Target Library name, as
well as the From and To file types.
These are as follows:
PUT Remote Object (PUTRMTOBJ)
Type choices, press Enter.
Remote user profile . . . . . . Name, *CURRENT
Remote user password . . . . . . Character value
Remote system . . . . . . . . . ____________________________________________
________________________________________________________________________________
________________________________________________________________________________
____________________________________________________
Object name to copy . . . . . . Name
Library . . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB
Object type to copy . . . . . . *ALRTBL, *AUTL, *BNDDIR...
Save file on target system . . . Name
Library . . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB
Restore to library . . . . . . . *SAVLIB Name, *SAVLIB
Submit job to batch . . . . . . *YES *YES, *NO
This command is too complex to describe here. For a detailed description see the PUTRMTOBJ manual.
| PRTRFD Command | Back to list |
The PRTRFD command allows you to print record format information of one or many database
files.
The prompted command appears as follows:
Print Record Formats (PRTRFD)
Type choices, press Enter.
File . . . . . . . . . . . . . . *SELECT Name, generic*, *SELECT, *ALL
Library . . . . . . . . . . . __________ Name, *LIBL
File type . . . . . . . . . . . *DBF *DBF, *PF, *LF
Print extended layout listing . *NO *YES, *NO
Enter the file and library name to print. You can enter a single or generic name or you can enter *ALL or *SELECT.
If a generic or selection value is entered, a selection screen will be presented to select
further the files you wish to include.
You can include all database files, or select only physical or logical files.
Also included is a parameter to print the extended layout which includes field column
headings.
| RSTFRMPCD Command | Back to list |
Restore from PC Document (RSTFRMPCD)
Type choices, press Enter.
From folder . . . . . . . . . . ____________________________________________
____________________________________
From document . . . . . . . . . *SAVEFILE Character value, *SAVEFILE
Save file . . . . . . . . . . . SAVPCDTA Name
Library . . . . . . . . . . . QTEMP Name, *LIBL
Restore objects . . . . . . . . *NO *YES, *NO
| RUNSQL Command | Back to list |
Process SQL commands (RUNSQL)
Type choices, press Enter.
SQL request . . . . . . . . . . ____________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
____________________________________________________________________ ...
Output . . . . . . . . . . . . . * *, *PRINT, *OUTFILE
COPYRIGHT 1991 Duke Communication, Int'l AS/400 Power Tools
| SAVTOPCD Command | Back to list |
Save to PC Document (SAVTOPCD)
Type choices, press Enter.
To folder . . . . . . . . . . . ____________________________________________
____________________________________
Objects . . . . . . . . . . . . *SAVED *SELECT, *SAVED
To document . . . . . . . . . . *SAVEFILE Character value, *SAVEFILE
Save file . . . . . . . . . . . SAVPCDTA Name
Library . . . . . . . . . . . QTEMP Name, *LIBL
Add bit-level integrity check . *YES *YES, *NO
| SQL Command | Back to list |
The SQL command provides you with a command interface to SQL functions without using SQL,
similar to the ever familiar CPYF (Copy File) command.
This allows users and programmers with little knowledge of SQL syntax to perform simple to
fairly complex SQL functions.
The first parameter displayed on the command prompt is the SQL type.
This is as follows:
Prompt SQL commands (SQL)
Type choices, press Enter.
SQL type . . . . . . . . . . . . *LIST *LIST, *UPDATE, *INSERT...
This command is too complex to describe here. For a detailed description see the
SQL manual.
| Z@LOAD Command | Back to list |
Load and Compile Utilities (Z@LOAD)
Type choices, press Enter.
Library utilities came from . . *ANY Name, *ANY
Library to create utilities in QGPL Name
From folder . . . . . . . . . . SPFX_UTL
| ZCPYFRPC Command | Back to list |
Copy Source from PC Document (ZCPYFRPC)
Type choices, press Enter.
From folder . . . . . . . . . . ____________________________________________
____________________________________
Copy from library . . . . . . . *SAVLIB Name, *SAVLIB
Copy to library . . . . . . . . *FROMLIB Name, *FROMLIB
Delete PC documents . . . . . . *NO *YES, *NO
Get PC load file first . . . . . *NO *YES, *NO
Get Message file data . . . . . *NO *YES, *NO
| ZCPYTOPC Command | Back to list |
Copy Source to PC Document (ZCPYTOPC)
Type choices, press Enter.
Source file . . . . . . . . . . __________ Name
Library . . . . . . . . . . . *LIBL Name, *LIBL
Source member . . . . . . . . . __________ Name
Source type . . . . . . . . . . *SRCMBR Name, *SRCMBR
Text 'description' . . . . . . . *SRCMBRTXT__________________________________
______
To folder . . . . . . . . . . . *USRPRF_____________________________________
____________________________________
Clear data log file first . . . *NO *YES, *NO
Put PC load data into folder . . *NO *YES, *NO
Put PC MSGF data into folder . . *NO *YES, *NO
| ZLODDOCD Command | Back to list |
Load Documents to PC file (ZLODDOCD)
Type choices, press Enter.
From folder (document list) . . ____________________________________________
____________________________________
To folder . . . . . . . . . . . *USRPRF_____________________________________
____________________________________
Clear data log file first . . . *YES *YES, *NO
Put PC load data into folder . . *YES *YES, *NO
| ZUPDDOCD Command | Back to list |
Update Documents from PC file (ZUPDDOCD)
Type choices, press Enter.
From folder . . . . . . . . . . ____________________________________________
____________________________________
Delete PC document (load file) *YES *YES, *NO
Get PC load file first . . . . . *YES *YES, *NO
| Miscellaneous copy source members | Back to list |
This is a few RPG source members for quick copying into your programs. They include quick code references, techniques, File Information Data Structure (INFDS), Program Status Data Structure (SDS), etc.
Notice
The information in this Guide is subject to change without notice.
BlackGold Systems Group Inc. makes no warranty of any kind with regard to this material,
including, but not limited to the implied warranties of merchantability, performance,
or fitness for a particular purpose.
BlackGold Systems Group Inc. shall not be liable for errors contained herein or for any
direct, incidental, or consequential damages resulting from the use of this material.
Copyright 1996 by BlackGold Systems Group Inc. All rights reserved.
No part of this publication may be reproduced, transmitted, transcribed, stored in a
retrieval system, or translated into any language in any form by any means, without
written permission of BlackGold Systems Group Inc.
Printed in Canada (June 1996, revised April 1997).