Export DB2 query to TXT using dynamic filename with current date

Want to export data from DB2 query result to TXT using current date as file name?

Try Withdata DBToFile, a DB2 to TXT converter for Windows, Linux, and macOS, Export DB2 data to TXT, Easy and Fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Support Windows, Linux, and macOS.

Download Withdata DBToFile
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Export DB2 query result to TXT file using dynamic filename with date and time

Login to DB2 -> Enter DB2 SQL statement -> Set TXT filename template including date -> Export DB2 query to TXT using current date as file name

Choose DB2 and logon.

“Export From Query” for “TXT to DB2“.

Select TXT file type.

1. Enter DB2 SQL query.

2. Set TXT file options. Enter filename template, including date, #yyyy# is for current year, #mm# month, #dd# day, #hh# hour, #mi# minute, #ss# second.

3. Set rows options.

4. Export DB2 query results to TXT file. Dynamically created TXT file name using present system time.

After exporting, you can view output TXT files.

---

More about DB2 to TXT converter

DB2 → TXT reference

Type mapping

Value kind	in DB2	in TXT
Int	INTEGER	1234, or right-aligned in a fixed-width column
Bigint	BIGINT	9007199254740993
Decimal	DECIMAL(p,s)	1234.56
Float	DOUBLE	1.234e+10
Text	VARCHAR(n)	written as-is; padding depends on the chosen layout
Long text	CLOB	written as-is
Date	DATE	whatever the writer chose
Datetime	TIMESTAMP	whatever the writer chose
Binary	BLOB	not representable
Boolean	SMALLINT	Y / N, or 1 / 0, or TRUE / FALSE

Dialect differences

DB2 is a database server and TXT is a file format, so the gap is wider than a dialect difference - the rows below are where values and structure stop lining up.

Property	in DB2	in TXT
port	50000	—
identifiers	"double quotes"	None by convention
row limit	FETCH FIRST n ROWS	—
dates	DATE, TIME, TIMESTAMP	Whatever the writer produced; no convention is guaranteed
long text	CLOB	—
binary	BLOB	Not supported
separator	—	Whatever was chosen - often fixed column widths
encoding	—	No declaration - UTF-8 works only with a BOM
typing	—	None - every field is text
shape	Tables of rows and columns	Free form; a parser has to be told the layout
ceiling	—	No formal limit

Command line

Side	Command
DB2	EXPORT TO out.csv OF DEL
DB2 (load)	db2 IMPORT FROM file OF DEL

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.