Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Bind Error Sql Code -204

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Thu Dec 17, 2009 10:51 am    Post subject: Bind Error Sql Code -204
Reply with quote

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.
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Dec 17, 2009 11:20 am    Post subject:
Reply with quote

Chandan,

Check the QUALIFIER for the plan or package.

Sushanth
Back to top
View user's profile Send private message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Thu Dec 17, 2009 11:34 am    Post subject: Reply to: Bind Error Sql Code -204
Reply with quote

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.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Dec 17, 2009 11:42 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Thu Dec 17, 2009 11:56 am    Post subject: Reply to: Bind Error Sql Code -204
Reply with quote

Sushanth,

These are newly created tables and this is the new program which will access these tables.
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Thu Dec 17, 2009 11:59 am    Post subject:
Reply with quote

the qualifier is already displayed in your error message.
Code:
TOKENS=TE.UTE02401_AMNHLDLOG

TE is the qualifier. Validate if the table UTE02401_AMNHLDLOG is created in the region TE.
Back to top
View user's profile Send private message
Lijo

New User


Joined: 24 Aug 2008
Posts: 41
Location: Cochin

PostPosted: Thu Dec 17, 2009 12:12 pm    Post subject: Reply to: Bind Error Sql Code -204
Reply with quote

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?
Back to top
View user's profile Send private message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Thu Dec 17, 2009 2:24 pm    Post subject: Reply to: Bind Error Sql Code -204
Reply with quote

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
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Thu Dec 17, 2009 4:13 pm    Post subject:
Reply with quote

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 .
Back to top
View user's profile Send private message
Lijo

New User


Joined: 24 Aug 2008
Posts: 41
Location: Cochin

PostPosted: Thu Dec 17, 2009 4:38 pm    Post subject: Reply to: Bind Error Sql Code -204
Reply with quote

Chandan,

You didn't confirm on below point:

Quote:
1) Check whether UTE02401_AMNHLDLOG is existing under TE qualifier.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Dec 17, 2009 6:52 pm    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Fri Dec 18, 2009 10:02 am    Post subject: Reply to: Bind Error Sql Code -204
Reply with quote

Thanks all,

That issue has got resolved now, The program has got compiled succesfully.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 18, 2009 10:09 am    Post subject:
Reply with quote

Hello,

What resolved the problem?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us