Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Compilation error
This is a discussion on Compilation error within the SQL forums, part of the Databases category; We are using dynamic SQL to built in a COBOL-CICS program. The dynamic SQL max length is 34000 (i.e 5 digits). But when we are PREPARING the dynamic SQL. The ...
|
|||||||
11-28-2006
|
|||
|
|||
|
Compilation error
We are using dynamic SQL to built in a COBOL-CICS program. The dynamic SQL max length is 34000 (i.e 5 digits). But when we are PREPARING the dynamic SQL. The variable length has to be defined in Length field which is S9(04) COMP field (i.e 4 digits max length)
01 DYN-SQL-STMT. 49 SQL-STMT-LEN S9(04) COMP. 49 SQL-STMT-TXT 34000. The statement S(04) comp can not store 5 digits? If I increase to s (07) COMP, Iam getting compilation error implying to use VARCHAR. Kindly can you please suggest, what to do, to accept 5-digit length? Note : This is the question asked by a visitor Vinuthna. I am posting this in proper forum. 
|
| Sponsored Links |
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Customized error in coldfusion | norman | ColdFusion | 1 | 4 Days Ago 03:26 PM |
| Error While Recording in QTP | Shivanna | QTP | 4 | 06-23-2008 03:44 PM |
| What is Just-In-Time (JIT) compilation | GeekAdmin | VB.NET | 1 | 12-12-2007 06:43 AM |
| Error in webtesting | bharathi_ark | Web Testing | 2 | 09-11-2007 07:57 AM |
| 500 Server Error in PHP | Martin Lucas | PHP | 1 | 05-30-2006 07:04 PM |
All times are GMT -4. The time now is 02:51 PM.
