You can save a .sql file to your hard drive, and execute it using the DB2 command line using:
db2 -vtf C:\path\to\test.sql
-v echoes the command text back to the command line
-t sets the statement terminator to ;.
-f tells the command line to load the commands from the file.
See other command line options, http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010410.html.
from: http://stackoverflow.com/questions/17834343/how-to-create-batch-file-to-execute-multiple-db2-queries
SQL → DB2 reference
Type mapping
| Value kind | in SQL | in DB2 |
|---|---|---|
| Int | INT | INTEGER |
| Float | DOUBLE PRECISION | DOUBLE |
| Long text | TEXT / CLOB | CLOB |
| Binary | BLOB / BYTEA | BLOB |
| Boolean | BOOLEAN / SMALLINT | SMALLINT |
| JSON | JSON / TEXT | CLOB |
Dialect differences
SQL is a file format and DB2 is a database server, so the target has to be told the types the file never carried – the rows below are where the two sides diverge.
| Property | in SQL | in DB2 |
|---|---|---|
| port | — | 50000 |
| identifiers | Two competing conventions: single-quoted literals and diale... | "double quotes" |
| row limit | — | FETCH FIRST n ROWS |
| dates | Depends on the dialect: DATE literals, TO_DATE(), or plain ... | DATE, TIME, TIMESTAMP |
| long text | — | CLOB |
| binary | Dialect-specific: X-quoted literal, 0x hex, or decode() | BLOB |
| separator | Statement terminators (;) | — |
| encoding | No declaration | — |
| typing | Types belong to the target database, and they differ betwee... | — |
| shape | Statements; a dump usually means CREATE TABLE plus INSERT rows | Tables of rows and columns |
| ceiling | No formal limit, but a single INSERT statement has to fit i... | — |
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.
