unload to a file

ahmedwaseem2000 · #1 (**permalink**) 10-06-08, 03:50

Hi - How do I unload data from a table to a pipeline separated file???

Marcus_A · #2 (**permalink**) 10-06-08, 04:14

Use export command with delimited format. You can choose the delimeter. See the Command Reference Manual.

ahmedwaseem2000 · #3 (**permalink**) 10-08-08, 03:27

Would it be possible to copy a table(along with the data) in a new schema? I tried the MQT but that didnt help. it showed me that I cant modify the existing table. any suggestions???

grofaty · #4 (**permalink**) 10-08-08, 04:29

hi,
create table with new schema and then "insert into newtable select * from old_table"
Regards

Internet Services

Web Development

Digital Marketing

Consumer Tech