Information Systems:CSV
(Redirected from CSV)
Jump to navigation
Jump to search
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.