Author |
Message |
Topic: -311 on a BATCH SPUFI |
MainframeGal
Replies: 6
Views: 3651
|
Forum: Database Posted: Fri Dec 07, 2007 10:38 am Subject: -311 on a BATCH SPUFI |
MainframeGal,
jsharon1248 is right. Removing the extra delimiter would solve the problem. Try that out.
Yep, jsharon1248 IS right! Thank you all SO much for your help with this! |
Topic: -311 on a BATCH SPUFI |
MainframeGal
Replies: 6
Views: 3651
|
Forum: Database Posted: Fri Dec 07, 2007 8:58 am Subject: -311 on a BATCH SPUFI |
MainframeGal,
What is the allowable length of field B.RECORD_INFO?
I am assuming that the defn of RECORD_INFO is VARCHAR(100)
Use this untested SQL
SELECT A.REPORT_ID, A. ... |
Topic: -311 on a BATCH SPUFI |
MainframeGal
Replies: 6
Views: 3651
|
Forum: Database Posted: Fri Dec 07, 2007 7:48 am Subject: -311 on a BATCH SPUFI |
I'm running a BATCH SQL query using DBG2TEP2, and am getting the following error (NOTE: there are over 5M rows on the DB):
SQLCODE = -311, ERROR: THE LENGTH OF INPUT HOST VARIABLE NUMBER 001 IS NE ... |
|