Kbase 20380: How to Perform a Native Data Load Directly on the AS/400
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/10/2008 |
|
SUMMARY:
This solution describes how to perform a native data load directly on a Progress/400 Dataserver Version 9.x.
EXPLANATION:
The Progress/400 Dataserver Version 9.X comes with a utility called Load Progress Data (LODPRODTA) that performs a native load of Progress formatted data or .d files into DB2/400 files.
If an error occurs during processing, it is listed in the .e files.
SOLUTION:
The LODPRODTA utility performs the data load directly on the AS/400. Follow these steps to use the LODPRODTA utility on the AS/400:
1) Load the .d files into the IFS directory.
2) Enter the command LODPRODTA.
3) Hit the F4 key.
4) Enter the following values to execute the Load Progress Data
(LODPRODTA):
a) Progress/400 Dictionary Library (DCTLIB):
Enter the name of the Dictionary Library that contains
the server schema.
b) Load .d(s) from IFS Directory (FROMDIR):
Enter the name of the IFS directory where the .d files
are stored. This directory must exist.
If the IFS directory is not specified, Progress
formatted data is stored in your current working
directory (CURDIR).
c) Progress Table Name(s)(PROTBL):
Enter the name of Progress table names to load or ALL
to load all tables in the Progress/400 dictionary
library that you want loaded.
NOTE: If you need to transfer the .d files from a PC to the AS/400, you can use the FTP or TRANSFIL.P utility. You should understand the following considerations:
- FTP
When you use FTP to transfer a file into an IFS directory a
binary transfer is performed. This means that no conversion
data from CSID 819 to CSID37 is performed.
- Your .d files are now on the AS/400 with code pages 819
(ASCII). You must convert the files manually using the AS/400
Copy Object(CPY) command as follows:
CPY OBJ('/IFS-directory/file.d') TOOBJ(filex.d)
TOCODEPAGE(037)
DTAFMT(*TEXT)
- TRANSFIL.P
This utility is shipped with the Progress product and can be
used to transfer files without having to convert the files
on the AS/400.
It could be time-consuming to transfer larger files. This
transfer utility should be used for smaller files only.
You might consider using the FTP option and convert the
files manually on the AS/400 in the case of larger files.
- No Progress utility is available on the AS/400 to load data
definition natively in Versions 8.x or 9.x.
To load data definition you must use the Progress/400 Data
Dictionary that is available on MS-Windows only. Refer to
the Progress/400 Dataserver Guide for detailed information.
- You can use the native Dump Progress Data to dump data from DB2
files then load these files into a different DB2 file. For more
information about the Dump Progress Data utility on the AS/400,
refer to Progress Knowledge Base Solution 20379.
References To Written Documentation:
Progress/400 Dataserver Guide Version 9.