MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 3 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: -311 on a BATCH SPUFI
MainframeGal

Replies: 6
Views: 3651

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group