DB2 - Load command

Thread view:

lm - 21 Feb 2006 18:21 GMT

Hi,

How can i use the Load Command with JDBC driver to load a text file with a
specific delimiter
into DB2 delimiter ?

Can u give me a sample ?

Best regards.

Reply to this Message

IchBin - 21 Feb 2006 21:30 GMT

> Hi,
>
[quoted text clipped - 5 lines]
>
> Best regards.

No example, but as far as I can tell it looks like you specify it by the
FORMAT command:

FORMAT CSV TERMINATEDBY '^' ENCLOSEDBY '' AND ''
NULLSTRING ''

Signature

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...