C
Christopher Robert99
Guest
So, I'm using the IBM DB2 Load utility moving data from SQLSERVER to IBM DB2 z/OS via MICROSOFT VISUAL STUDIO.
I'm encountering an error when loading data due to column delimiters found with column fields(tab delimited file, has tabs, commas,etc within the NOTES column fields)
I have a NOTES field and a details field where any character can be encountered, so is there a command I can use to specify that particular column to be enclosed with "" ?
My current command is below:
connect to myserver user mylogins using mypassword LOAD CLIENT from "pathtoquery" OF DEL MODIFIED BY NOCHARDEL coldel0x09 KEEPBLANKS USEDEFAULTS TIMESTAMPFORMAT="YYYY-MM-DD HH:MM:SS.UUUUUUUUU" MESSAGES "pathtologs" INSERT INTO SCHEMA.TABLE NONRECOVERABLE
Continue reading...
I'm encountering an error when loading data due to column delimiters found with column fields(tab delimited file, has tabs, commas,etc within the NOTES column fields)
I have a NOTES field and a details field where any character can be encountered, so is there a command I can use to specify that particular column to be enclosed with "" ?
My current command is below:
connect to myserver user mylogins using mypassword LOAD CLIENT from "pathtoquery" OF DEL MODIFIED BY NOCHARDEL coldel0x09 KEEPBLANKS USEDEFAULTS TIMESTAMPFORMAT="YYYY-MM-DD HH:MM:SS.UUUUUUUUU" MESSAGES "pathtologs" INSERT INTO SCHEMA.TABLE NONRECOVERABLE
Continue reading...