Empty copy from local to temporary table

Anton

Hello.
I try to load csv file in temporary table using ODBC.
For example, i use isql:

SQL> CREATE TEMPORARY TABLE qtest_tmp(id INT PRIMARY KEY, str VARCHAR(250));
SQLRowCount returns 4294967295
SQL> COPY qtest_tmp FROM LOCAL 'file.csv' DELIMITER ';' NULL '';
SQLRowCount returns 3
SQL> SELECT * FROM qtest_tmp;
+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id                  | str                                                                                                                                                                                                                                                       |
+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns 0
SQL>

'file.csv' contents:

0;str0
1;str1
2;str2

I get same mournful result if use ODBC C api.

BUT. If i use vsql, then everything is ok, and i load data successfully.


Please, help me...




 Loading...

Navneet_1

Given that this post is 6 months old, I would hope you have worked past it. But, in any case, try using :

on commit preserve rows