Re: how do i load the data into a informix db table name with case sensitive and column name with space?

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqlr.doc/sqlrmst198.htm ----- Original Message ---- From: jeffhan <hanzhefeng@gmail.com> To: informix-list@iiug.org Sent: Monday, July 7, 2008 7:27:32 PM Subject: how do i load the data into a informix db table name with case sensitive and column name with space? i have a database which has sensitive table name and column name (some columns name even have space in it), like xtreme."Account" column: "Account Heading Number", "Account Number" i was trying to use dbaccess to load the data into 1 table but failed, here is what i did: $cat test.sql LOAD FROM 'test.data' DELIMITER '|' INSERT INTOxtreme2003."Account"("Account Number" ,"Account Heading Number" ,"Account Type ID" ,"Account Class ID" ,"Account Name" ,"Description" ,"Account Balance" ); bash-3.1$ head -3 test.data 1060|1000|1|2|Chequing Bank Account||893260.5187| 1200|1000|1|4|Accounts Receivable||513702.3068| 1510|1500|1|5|Gloves Inventory||49078.35| And then i run dbaccess, database name is xtreme2003: $ dbaccess xtreme2003 test.sql Database selected. 404: The cursor or statement is not available. 404: The cursor or statement is not available. Error in line 1Near character position 1 Database closed. $ i just can't understand why i got this error, please help me thanks. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list