Exporting to CSV

EXPORT TO result.csv OF DEL MODIFIED BY NOCHARDEL STRIPLZEROS SELECT col1, col2, coln FROM testtable;

Connecting to Oracle 11G from VB 6

The steps are the same as to connect to Oracle 10G, except for one matter - we have to set the current schema before running any queries through - ALTER SESSION SET CURRENT_SCHEMA=<SCHEMA_NAME>

In DB2 listing all the tables in a schema

Type db2cmd, connect to a database and type - db2 list tables for schema <name>

Creating a database in DB2

To create a database in DB2 you open a DB2 Command Line Processor using the command db2cmd, and enter the command - db2 create database <name> automatic storage yes