|
View previous topic :: View next topic
|
| Author |
Message |
Pavan kumar chauhan
New User
Joined: 05 Dec 2017
Posts: 6
Location: india
|
|
|
|
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 |
|
 |
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1292
Location: Vilnius, Lithuania
|
|
|
|
| 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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10845
Location: italy
|
|
|
|
| Quote: |
| when we unload data thru IKJEFT01 |
bullshit  |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 2973
Location: NYC,USA
|
|
|
|
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 |
|
|
|
|
