Netcobol with Postgres

Support for OS/VS COBOL, VS COBOL II, COBOL for OS/390 & VM and Enterprise COBOL for z/OS
sam_jj12
Posts: 18
Joined: Sat Nov 21, 2015 12:02 am
Skillset: ASG-ZEKE,CA-JOBTRAC
Referer: WEBSITE

Netcobol with Postgres

Postby sam_jj12 » Fri Mar 05, 2021 7:10 pm

hi all..
Trying to call a stored procedure with 3 inputs of field type as characters (to insert a row) in Postgres from netcobol.
Getting SQLERROR as 42809 and SQLMSG as: [Postgresql]"unknown,unknown,unknown" is a procedure.
But when executing the SQL code as embedded in the program and when executing the stored procedure in Postgres it is executing successfully..
Also could see the values for the var1 x(10), var2 x(10), var3 x(10) are getting passed successfully in the call.

any way to resolve this error.?

User avatar
prino
Posts: 641
Joined: Wed Mar 11, 2009 12:22 am
Skillset: PL/I - CICS - DB2 - IDMS - REXX - JCL, most in excess of three decades
Referer: Google
Location: Vilnius, Lithuania
Contact:

Re: Netcobol with Postgres

Postby prino » Fri Mar 05, 2021 11:33 pm

sam_jj12 wrote:any way to resolve this error.?

Post in a forum for toy computers?
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy