Select Delimiter for DB2 Export Command

JDionne · #1 (**permalink**) 10-24-07, 11:15

This seems like a simple question, so I must be looking at the documentation wrong. I cannot see where I can set what delimiter will be used when I use the export comand into a regular txt file.

Can someone post an example syntax so that I can match it with the DB2 manual?

Regards

n_i · #2 (**permalink**) 10-24-07, 11:32

Look at the coldel modifier. E.g.

Code:

export to file.txt of del 
modified by coldel0x09
select ...

JDionne · #3 (**permalink**) 10-24-07, 12:20

Is there a chart or list that displays the reprenentation of different delimiters? I need to use the |

n_i · #4 (**permalink**) 10-24-07, 12:47

"|" is usually represented by "|", similarly to other printable characters. As for the non-printable characters... have you heard anything about ASCII?

JDionne · #5 (**permalink**) 10-24-07, 13:26

Wow that was kinda rude...
Just trying to use the comunity to learn...
Sorry I asked

n_i · #6 (**permalink**) 10-24-07, 13:55

I'm sorry if I hurt your feelings. My sarcasm was caused by the fact that the answer to your question could have been easily found in the publicly available manual, if you took time to look.

JDionne · #7 (**permalink**) 10-24-07, 14:38

For anyone that was hopeing to learn from this exchange the code that I used is as following

Code:

EXPORT TO '/export/home/mldwh/tpcint/intdata/POINT1.TXT' OF DEL MODIFIED BY COLDEL| select * FROM RKSA_GSIS_RKEM_POINT1

Hope this helps

Internet Services

Web Development

Digital Marketing

Consumer Tech