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 

IEFC012I JCL STATEMENT MAXIMUM LENGTH EXCEEDED

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL)
View previous topic :: View next topic  
Author Message
Jamylady
Beginner


Joined: 04 Nov 2004
Posts: 68
Topics: 22

PostPosted: Mon Aug 14, 2006 12:37 pm    Post subject: IEFC012I JCL STATEMENT MAXIMUM LENGTH EXCEEDED Reply with quote

Hi,
Is there any way to overcome the following error..
IEFC012I JCL STATEMENT MAXIMUM LENGTH EXCEEDED

I need to execute a lengthy SQL using JCL and when I submit the job, I am getting the above error message.
I know we can use JOBPARM to alter some default values such as LINES. But not sure whether we can alter this value in a similar way.

Books says the following
Explanation: The system found a statement that exceeded the maximum length allowed. The string text length of the JCL statement exceeds the size of the C/I text buffer.

Any Idea...most appreciated.
Thanks
JA
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Mon Aug 14, 2006 1:00 pm    Post subject: Reply with quote

Jamylady,

I guess you are missing a apostrophe or closing parenthesis in your sql. Also check this post

http://www.mvsforums.com/helpboards/viewtopic.php?p=33151#33151

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Jamylady
Beginner


Joined: 04 Nov 2004
Posts: 68
Topics: 22

PostPosted: Tue Aug 15, 2006 4:42 am    Post subject: Reply with quote

Thanks kolusu,
I was also thinking the same...But this is actually the case. When I shorten the SQL by removing some conditions, it worked. It is actually the size of the SQL. The total number of lines are less than 200 and that is why I am wondering..
Back to top
View user's profile Send private message
Steve Coalbran
Beginner


Joined: 09 Mar 2005
Posts: 22
Topics: 0
Location: Stockholm, Sweden

PostPosted: Thu Aug 17, 2006 6:13 am    Post subject: Reply with quote

It's hard to imagine without seeing the source.
Could you post the full job - original JCL + SQL (pre-deletions)?

Please post it as a...
[code]
:
:
:
[/code]

so its clear to read.

Wink /Steve Smile
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group