Oninit cdi / Archive
Talk to an expert →

Column name using keyword.

Posted in 2018

Topics: Data Types & Schema Design, Migration, Import/Export & Data Conversion, Platform-Specific Issues, Versions, Editions & End-of-Life

KERNOAL STEPHENS — — source: IIUG Forums & Mailing Lists

IBM Informix Dynamic Server Version 12.10.FC8 7.1.3.45 TL03 - AIX Kernel Version I have a table already created in one of the databases with the following. create table "informix".t_table_1234 ( rowid integer, dateid varchar(8), divisionnum integer, sellingbranchnum integer, ordernum integer, orderbonum integer, trancode varchar(4), orderdate varchar(8), . . . Notice the first column is named "rowid". HTF did they get this to create? I have tried "rowid" integer, 'rowid' integer, used \\\\" \\\\' I am wanting to dbexport this database and fix the underlying storage, but I am not able to recreate the table with the column name "rowid". Also wondering how they are selecting the column? No matter how I run the select it always returns the internal rowid hidden column value. See you at the conference! Thanks.

↪ replying to KERNOAL STEPHENS
LUIS MARQUES — — source: IIUG Forums & Mailing Lists

You need to use the DELIMIDENT environment variable. Check the online documentation: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqlr.doc/id s_sqr_233.htm https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/id s_sqs_1614.htm https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/id s_sqs_1616.htm#ids_sqs_1616

Glossary