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.