From: | usanee(at)mfec(dot)co(dot)th |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | How to insert data pass by parameter |
Date: | 2007-08-08 08:08:54 |
Message-ID: | 46854.203.148.220.220.1186560534.squirrel@203.148.220.220 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi support
I have problem about insertion into postgres db and details
like below;
1. I use IBM DataStage as client connect to Postgrest db 8.2.4 via
psqlOdbc 8.0.4
2. I can read data from table but I cannot insert data in to target table
on Postgrest DB and I 've got error message like this
"SQL statement:INSERT INTO a(emp_id) VALUES (?)
SQLSTATE=00000, DBMS.CODE=-1
[DataStage][SQL Client][ODBC][unixODBC]Error while executing the query
(non-fatal);
ERROR: syntax error at end of input at character 47 "
Table name : a
Col Name :emp_id char(10)
Sql Statement : insert into a (emp_id) values (?);
I use (?) for passing data by parameter.
Please give me a suggestion for using insert data by pass parameter
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | lothar.behrens@lollisoft.de | 2007-08-08 14:24:52 | SetPos with data_at_exec not yet supported ? |
Previous Message | lothar.behrens@lollisoft.de | 2007-08-07 22:40:37 | Long data and SQLPutData ? |