Bind Error Sql Code -204

CHANDAN KAPOOR · New User Joined: 12 Apr 2008 Posts: 36 Location: NOIDA

Hi , While adding a program in Endevor Im getting the following Bind Error.

DSNX200I _UDB2 BIND SQL ERROR
USING END01 AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=TEARMN
STATEMENT=1601
SQLCODE=-204
SQLSTATE=42704
TOKENS=TE.UTE02401_AMNHLDLOG
CSECT NAME=DSNXOTL
RDS CODE=-500

I have checked the table is exists. Can anybody help regarding this.

sushanth bobby · Posted: Thu Dec 17, 2009 11:20 am

Chandan,

Check the QUALIFIER for the plan or package.

Sushanth

CHANDAN KAPOOR · New User Joined: 12 Apr 2008 Posts: 36 Location: NOIDA

Sushant,

Can you assist me that how can I check the qualifier for the plan as We don't manually bind the program, just we add in endevor and endevor takes care of binding.

sushanth bobby · Posted: Thu Dec 17, 2009 11:42 am

Chandan,

Is this a new program, if so refer to the previous settings of a program which access the same table. That's the only suggestion i can give you.

To be honest, "I haven't worked in ENDEVOR, yet".

Sushanth

CHANDAN KAPOOR · New User Joined: 12 Apr 2008 Posts: 36 Location: NOIDA

Sushanth,

These are newly created tables and this is the new program which will access these tables.

Bharath Bhat · Posted: Thu Dec 17, 2009 11:59 am

the qualifier is already displayed in your error message.

Lijo · New User Joined: 24 Aug 2008 Posts: 41 Location: Cochin

I don't know which Endevor bind process you're using. One of the endevor bind process would pick up the bind qualifier based on endevor system, sub-system and stage ID. Another method is your bind element added to the endevor (or in specified libraries) will have bind details (Plan name, qualifier etc.). In the first method, usually bind element will be blank or dummy bind.

To debug -204,

1) Check whether UTE02401_AMNHLDLOG is existing under TE qualifier.
2) Is this the only table used in your program? If not, what happened to other tables, are they not getting displayed in bind error?
3) Have you used UTE02401_AMNHLDLOG or TE.UTE02401_AMNHLDLOG in the program?

CHANDAN KAPOOR · New User Joined: 12 Apr 2008 Posts: 36 Location: NOIDA

Hi Lijo,

Thanks for the info We are using the first bind process i which the biond element is dummy.

Reg the Debugging of -204.The program is accessing other tables as well but Im getting -204 only for those tables which are newly created. Im using TE.UTE02401_AMNHLDLOG in the program.

Thanks,
Chandan Kapoor

ashimer · Posted: Thu Dec 17, 2009 4:13 pm

What is TE ? What is UTE02401_AMNHLDLOG ?

If TE.UTE02401_AMNHLDLOG is a column, does such a column UTE02401_AMNHLDLOG exists ?
-- Check the column name properly
-- Check the DCLGEN used for this table .

Lijo · New User Joined: 24 Aug 2008 Posts: 41 Location: Cochin

Chandan,

You didn't confirm on below point:

dbzTHEdinosauer · Posted: Thu Dec 17, 2009 6:52 pm

why have this question phrased around Endevor.

endevor has nothing to do with it.

it is a db2 error, simply that.

are you sure you are supposed to be qualifying your tables in your sql?

CHANDAN KAPOOR · New User Joined: 12 Apr 2008 Posts: 36 Location: NOIDA

Thanks all,

That issue has got resolved now, The program has got compiled succesfully.

dick scherrer · Posted: Fri Dec 18, 2009 10:09 am

Hello,

What resolved the problem?