none
Microsoft Visual Studio IBM DB2 Load Utility — optionally enclosed column by double quotes RRS feed

  • Question

  • 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

    Wednesday, January 29, 2020 1:28 PM

Answers

All replies