Difference between revisions of "Information Systems:CSV"
Jump to navigation
Jump to search
(Created page with "On a command line, key in CPYTOIMPF and press F4 to prompt. Copy To Import File (CPYTOIMPF)...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 28: | Line 28: | ||
Press enter to run the command. |
Press enter to run the command. |
||
| + | |||
| + | [[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.