Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

How to insert data pass by parameter


  • From: usanee(at)mfec(dot)co(dot)th
  • To: pgsql-odbc(at)postgresql(dot)org
  • Subject: How to insert data pass by parameter
  • Date: Wed, 8 Aug 2007 15:08:54 +0700 (ICT)
  • Message-id: <46854(dot)203(dot)148(dot)220(dot)220(dot)1186560534(dot)squirrel(at)203(dot)148(dot)220(dot)220>

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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group