How to insert data pass by parameter

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=3D00000, DBMS.CODE=3D-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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: How to insert data pass by parameter

Hi.

From:


> 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 "

I do not use IBM Datastage...
However, For example, a parameter can be used as follows.

--
Set cmd = New ADODB.Command
cmd.ActiveConnection = cn
cmd.CommandText = "insert into MYTABLE(main,object) values(?,?)"
cmd.CommandType = adCmdText

' The main parameter
Set main = cmd.CreateParameter("main", adInteger, adParamInput)
main.Value = 100 '' a random integer value ''
cmd.Parameters.Append main
--

I want this to be help you.

Regards,
Hiroshi Saito

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org