C
Christopher Robert99
Guest
Good Morning, I'm curious if anyone can help me with the IBM DB2 Command that would enclosed a column with double quotes. I am having difficulty with tabs/commas being within the column fields of certain columns in my tables I'm trying to load.
Here is a sample load command, I can upload more details/configurations if needed just didn't want to make the post too lengthy.
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...
Here is a sample load command, I can upload more details/configurations if needed just didn't want to make the post too lengthy.
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...