Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
IKJEFT01

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: IKJEFT01
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: 1109
Location: Oostende, Belgium

PostPosted: Fri Apr 06, 2018 9:39 pm    Post subject:
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

Senior Member


Joined: 14 Mar 2007
Posts: 10478
Location: italy

PostPosted: Fri Apr 06, 2018 11:57 pm    Post subject: Reply to: IKJEFT01
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

Senior Member


Joined: 21 Sep 2010
Posts: 1906
Location: NY,USA

PostPosted: Sat Apr 07, 2018 12:47 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 8 Wed Nov 15, 2017 4:27 pm
No new posts "DFSRRC00 vs IKJEFT01" for ... arunsoods All Other Mainframe Topics 5 Fri Aug 12, 2016 9:54 pm
No new posts Overriding SYSOUT of IKJEFT01 to a da... enrico-sorichetti IBM Tools 8 Sun Apr 07, 2013 5:19 am
No new posts Using IKJEFT01 in Xpeditor. expat Compuware & Other Tools 15 Wed Dec 07, 2011 3:21 pm
No new posts Paging multiple lines using IKJEFT01 hemu88 TSO/ISPF 3 Mon Sep 12, 2011 5:23 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us