nocolumnlist

Enables or disables the column list in the SQL INSERT statement in the export file.

The column list is not necessary for the INSERT statement if the order of the columns in the table match the order of the elements in the INSERT statement. If this is known to be true, using the nocolumnlist option could reduce the size of the output file contents.

For example, an optString set to "type=sql" would create the following statement samples on the BOOKSHOP database:

-- Exporting table [ACCTMGR]...
INSERT INTO acctmgr (MGRID, NAME, HIRE_DATE, COMMISSION) VALUES 'ALFRED', 'Kralik, Alfred', '1997-07-02', 0.025;
INSERT INTO acctmgr (MGRID, NAME, HIRE_DATE, COMMISSION) VALUES 'AMY', 'Zonn, Amy', '1994-07-06', 0.025;
INSERT INTO acctmgr (MGRID, NAME, HIRE_DATE, COMMISSION) VALUES 'BARNEY', 'Noble, Barney', '1972-05-08', 0.035;
INSERT INTO acctmgr (MGRID, NAME, HIRE_DATE, COMMISSION) VALUES 'FRANK', 'Doel, Frank', '1987-02-13', 0.030;
INSERT INTO acctmgr (MGRID, NAME, HIRE_DATE, COMMISSION) VALUES 'JOE', 'Fox, Joe', '1998-12-18', 0.025;
INSERT INTO acctmgr (MGRID, NAME, HIRE_DATE, COMMISSION) VALUES 'KATE', 'Kelly, Kathleen', '1998-12-18', 0.025;
INSERT INTO acctmgr (MGRID, NAME, HIRE_DATE, COMMISSION) VALUES 'KLARA', 'Novac, Klara', '1990-01-02', 0.025;

If the optString is set to "type=sql;nocolumnlist=True", the following sample of statements would be created in the output:

-- Exporting table [ACCTMGR]...
INSERT INTO acctmgr VALUES 'ALFRED', 'Kralik, Alfred', '1997-07-02', 0.025;
INSERT INTO acctmgr VALUES 'AMY', 'Zonn, Amy', '1994-07-06', 0.025;
INSERT INTO acctmgr VALUES 'BARNEY', 'Noble, Barney', '1972-05-08', 0.035;
INSERT INTO acctmgr VALUES 'FRANK', 'Doel, Frank', '1987-02-13', 0.030;
INSERT INTO acctmgr VALUES 'JOE', 'Fox, Joe', '1998-12-18', 0.025;
INSERT INTO acctmgr VALUES 'KATE', 'Kelly, Kathleen', '1998-12-18', 0.025;
INSERT INTO acctmgr VALUES 'KLARA', 'Novac, Klara', '1990-01-02', 0.025;
Note
This option is only applicable for SQL export types.
Default Value
If the nocolumnlist option is not defined, the default value of OFF is used.
Example
nocolumnlist=OFF
Boolean Values Accepted

The following values can be accepted boolean values:

TRUE Values FALSE Values
1 0
On Off
True False
String values above are not case-sensitive.