IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

IKJEFT01


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Pavan kumar chauhan

New User


Joined: 05 Dec 2017
Posts: 6
Location: india

PostPosted: Fri Apr 06, 2018 8:49 pm
Reply with quote

Hi,
when we unload data thru IKJEFT01 by using select query in a flat file, we mention SYSPUNCH(structure) and SYSREC(actual data). And while loading it again in a table we have to mention both. But in my shop I saw the LOAD JCL where SYSPUNCH is not mentioned and it was throwing error-'ERROR CODE '14 - INPUT IS INVALID FOR DATE/TIME', I don't know it is because of SYSPUNCH or something else . But in production the same job without SYSPUNCH is running fine. can someone please help?
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania

PostPosted: Fri Apr 06, 2018 9:39 pm
Reply with quote

Quote:
Pavan kumar Chauhan
DB2 for z/OS SYSPROG

Don't you think a DB2 sysprog on a forum for experts should be able to open a manual and read it?

And no JCL on z/OS ever "throws" anything!
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Fri Apr 06, 2018 11:57 pm
Reply with quote

Quote:
when we unload data thru IKJEFT01

bullshit icon_evil.gif
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Sat Apr 07, 2018 12:47 am
Reply with quote

Unloading and loading tables
Quote:
'ERROR CODE '14 - INPUT IS INVALID FOR DATE/TIME',
are you using the same load file ? check the other working load jobs in non prod regions and mimic the same instead of writing it from the scratch.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts COBOL D2 program execution without us... DB2 3
No new posts Calling IKJEFT01 program from Rexx CLIST & REXX 8
No new posts "DFSRRC00 vs IKJEFT01" for ... All Other Mainframe Topics 5
No new posts Overriding SYSOUT of IKJEFT01 to a da... IBM Tools 8
No new posts Using IKJEFT01 in Xpeditor. Compuware & Other Tools 15
Search our Forums:

Back to Top