MVSFORUMS.com

hemavati · Beginner Joined: 12 Sep 2005 Posts: 1 Topics: 1

Hai,

I am trying to bind a new COBOL-DB2 program after successful compilation but i am not able to bind it as i am getting -204 error.Actually i am giving the program name as well as plan name also in the JCL correctly but i am getting finally as

BIND NOT SUCCESSFUL as well as the statement NO,SQLCODE & SQLSTATE with error values .

According to the manual of SQLCODES -204 says : -204 name IS AN UNQUALIFIED NAME.I am not able to figure out the actual meaning as does the plan name is invalid ? Can anyone help me out with my problem ?

kolusu · Posted: Mon Sep 12, 2005 10:07 am Post subject:

haqshaik · Beginner Joined: 11 May 2005 Posts: 49 Topics: 19

Hi,
Can you check the Bind Parameters and the query. if you are referencing a table with out a qulifier, in the bind parameter you need to specify the qulifier. -204 says
in qw Explanation: The object identified by name is not defined in the DB2
subsystem. This SQLCODE can be generated for any type of DB2 object.

Hope this will help..

Reagrds,
Salauddin

programmer1 · Beginner Joined: 18 Feb 2004 Posts: 138 Topics: 14

It might be worth checking that the column names used in the cobol program exactly match with columns of the table defined.
_________________
Regards,
Programmer