Link to home
Create AccountLog in
Avatar of ratna1234
ratna1234

asked on

DB2 Data extraction.

Hi ,

  I am new to DB2 , can you tell me how can i extract the data from a table like

  select field1,field2 , field3 from XXXXX

  The SQL has to be automatically executed and to be stored in a file.

Thank You.
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

depends on your platform but you can run an export command to output the result of a query to a csv file
Avatar of ratna1234
ratna1234

ASKER

Can you get more light on using the export.

Export to CSV is fine and my platform is AIX. DB2.
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks.