 | |||
|
|
||
| |||
| |||
| |
|
Home > AS/400 Tips > iSeries administrator tips > How to save time using the CPYTOPCD and CPYFRMPCD commands |
| |
|
|
|
| iSeries 400 Tips: |
|
|
|
|
|
|
|
|
||||||||||||||||||
|
ISERIES ADMINISTRATOR TIPS How to save time using the CPYTOPCD and CPYFRMPCD commandsRon Turull 10.27.2004 Rating: -3.64- (out of 5)
|
[IMAGE] | ||||||||||||||||||
You can also specify one of the other many standard translation tables loaded on the iSeries. You can even specify your own table to accomplish specialized data conversion.
Format of PC data parameter
Another parameter that plays a part in data conversion is the format of PC data parameter (TRNFMT keyword). This parameter accepts one of two special values, *TEXT or *NOTEXT, and is ignored if *NONE is specified for the translation table parameter.
Use *TEXT to have the data converted to an ASCII text file. ASCII text files on a PC are stored in variable-length records. Trailing blanks are removed from each record and the records are delimited at the end by a sequence of special characters -- a carriage-return character followed by a line-feed character. PC programs know they have reached the end of a record when this sequence of characters is encountered. You can use just about any popular word processor to edit an ASCII text file.
Using the *NOTEXT special value will result in fixed length records being created in the PC file. Trailing blanks are not removed and no special end-of-record characters are added to the end of the records. The length of the records is equal to the record length of the physical file being copied. Use *NOTEXT when copying data into a PC database.
Three other handy uses of the CPYTOPCD and CPYFRMPCD commands
Once you become familiar with these commands you will find other uses for them. Here are three of my favorites.
-----------------------------------
About the author: Ron Turull is editor of Inside Version 5. He has more than 20 years' experience programming for and managing AS/400-iSeries systems.
|
DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk. |
|
|||||
