View previous topic :: View next topic |
Author |
Message |
Tanuj Beginner
Joined: 27 Feb 2004 Posts: 5 Topics: 3
|
Posted: Thu May 20, 2004 12:17 am Post subject: Dynamic Sql Error Code -107, please help how to resolve this |
|
|
Hi, I have encountered error code -107 in a dynamic sql. As per the description of this error code, the actual problem can be anywhere in table or column or plan or package.
I am very new to usage of dynamic sqls, so please help me out how to pin-point this error and how to resolve it.
Thanks,
Tanuj |
|
Back to top |
|
 |
Tanuj Beginner
Joined: 27 Feb 2004 Posts: 5 Topics: 3
|
Posted: Thu May 20, 2004 12:53 am Post subject: |
|
|
Thanks Ravi, Let me see the token value and I'll definitely get back to you with the actual query and all the error codes. |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Thu May 20, 2004 4:43 am Post subject: |
|
|
Tanuj,
I am guessing that you might have missed a comma between one or more columns which makes DB2 assume that you are referring 1 column instead of 2 or 3 columns. so check your sql to make sure that you are not missing any comma
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
|
|