Difference between revisions of "Information Systems:CSV"
Jump to navigation
Jump to search
| Line 29: | Line 29: | ||
Press enter to run the command. |
Press enter to run the command. |
||
| − | [[Category: IBM i Utilities]] |
+ | [[Category: IBM i Tools/Utilities]] |
Latest revision as of 09:21, 30 June 2016
On a command line, key in CPYTOIMPF and press F4 to prompt.
Copy To Import File (CPYTOIMPF)
Type choices, press Enter.
From file:
File . . . . . . . . . . . . . test Name
Library . . . . . . . . . . qtemp Name, *LIBL, *CURLIB
Member . . . . . . . . . . . . *FIRST Name, *FIRST, *ALL
To data base file:
File . . . . . . . . . . . . . Name
Library . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB
Member . . . . . . . . . . . . *FIRST Name, *FIRST, *FROMMBR, *ALL
To stream file . . . . . . . . . uwd staging/sheilav/test.csv_________________
Replace or add records . . . . . *replace *ADD, *REPLACE
From CCSID . . . . . . . . . . . *FILE 1-65533, *FILE
Press enter to get more parameters.
Stream file CCSID . . . . . . . *PCASCII 1-65533, *STMF, *PCASCII...
Again, press enter for more parameters.
Stream file authority . . . . . *DFT *DFT, *INDIR, *FILE... Record delimiter . . . . . . . . *CRLF Character value, *EOR... Record format of import file . . *DLM *DLM, *FIXED
Press enter to run the command.