How to export SQL results to CSV from an SQL script using DB2 database?

Question

I want to store my Query results in an csv outfile using SQL script. Can someone help me with an SQL script which can store the results in an CSV file. I'm using db2 database.

Thanks in advance!

Possible duplicate of [Exporting result of select statement to CSV format in DB2](http://stackoverflow.com/questions/1058433/exporting-result-of-select-statement-to-csv-format-in-db2) — Stavr00, Nov 17 '16 at 18:35

Esperento57 · Accepted Answer · 2016-11-17T18:24:05.477

0

if you are on iseries (older name AS400), you can use CPYTOIMPF and specify the TOSTMF option to place a CSV file on the IFS directory

do and sql create table :

create table yourlib/yourfile as (  ---- your query ----) with data

like this :

CPYTOIMPF FROMFILE(yourlib/yourfile ) TOSTMF('/outputfile.csv') STMFCODPAG(*PCASCII) RCDDLM(*CRLF)

you can use this command into script sql like this

CL: CPYTOIMPF FROMFILE(yourlib/yourfile ) TOSTMF('/outputfile.csv') STMFCODPAG(*PCASCII) RCDDLM(*CRLF)

edited Nov 17 '16 at 18:24

answered Nov 17 '16 at 17:58

Esperento57

16,521
3
39
45

Any simpler way like below? – Tech Guy Nov 17 '16 at 18:03
SELECT A,B,C FROM ABCD INTO OUTFILE 'textfile.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; – Tech Guy Nov 17 '16 at 18:04
i have modify my answer for you can in same script sql create table and export. I dont know other solution, only write into ifs – Esperento57 Nov 17 '16 at 18:29

score 0 · Answer 2 · answered Nov 18 '16 at 07:20

0

I suggest you just use a database client. If it's possible in your case of course. For example SQuirreL SQL Client has an ability to export SQL result as CSV, Excel spreadsheet or XML. It's free and open source

answered Nov 18 '16 at 07:20

siarheib

159
1
8

How to export SQL results to CSV from an SQL script using DB2 database?

2 Answers2