View previous topic :: View next topic
|
Author |
Message |
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. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Chandan,
Check the QUALIFIER for the plan or package.
Sushanth |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
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. |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
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 |
|
|
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? |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
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 |
|
|
Lijo
New User
Joined: 24 Aug 2008 Posts: 41 Location: Cochin
|
|
|
|
Chandan,
You didn't confirm on below point:
Quote: |
1) Check whether UTE02401_AMNHLDLOG is existing under TE qualifier. |
|
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
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. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
What resolved the problem? |
|
Back to top |
|
|
|