Last Updated on 7 September 2019 by Roberto De Pedrini
iDB2-FAQ-011 – How to get a CSV file from a SQL statement?
As you know, you can get a CSV file (or a TXT, XLS and so on file) from the result of a query with ACS SQL Script… but if you need to generate a CSV directly from a SQL script you could mix SQL and CL command, as in the following example where we get a CSV file an IFS directory from a query on a NETSTAT system view:
create table qtemp.netstat as
(SELECT *
FROM qsys2.netstat_info)
with data;
cl: CPYTOIMPF FROMFILE(QTEMP/NETSTAT)
TOSTMF('/home/faq/netstat.csv')
STMFCCSID(PCASCII) RCDDLM(CRLF) ADDCOLNAM(*SQL);
And if you want schedule or call this script from another program you could execute it with RUNSQLSTM, as in this simple CL program
PGMRUNSQLSTM SRCFILE(FAQ400/SRC) SRCMBR(XNETSTAT) COMMIT(*NONE) OUTPUT(*PRINT)ENDPGM
Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more
Database DB2 e SQL ... forse lo strumento più potente e completo che abbiamo sulla piattaforma IBM i: ecco una Read more
Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more
Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more
