View previous topic :: View next topic
|
Author |
Message |
rguhanath
New User
Joined: 16 Oct 2006 Posts: 81 Location: chennai
|
|
|
|
Hi,
I am using IKJEFT01 tool for extracting the data from DB2 Table. In IFJEFT01 JCL STEP, i have given the query with alias Column names which i want to display it as Header in output file. But after ran the JCL i can able to see only Table data and got CC=4 Error message. Any one please help me that how to include Table column names along with data using IKJEFT01 tool in JCL to avoid another step for creating Header in the output file.
Thanks in Advance.
Regards,
Nath. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Line 3 of the control statements is the problem |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
I am using IKJEFT01 tool for extracting the data from DB2 Table |
isn' t it nice to see IT professionals use such a lousy terminology |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
IKJEFT01 is the TSO/E program. You use it whenever you wish to perform a TSO function within a batch job - so you can say, IKJEFT01 is TSO in Batch but calling it as "tool" is over simplification of terminogies if not nonsense.
Quote: |
i have given the query with alias Column names which i want to display it as Header in output file. But after ran the JCL i can able to see only Table data and got CC=4 Error message. |
I don't understand it much, as expat has also showed it in symbolic way. A Completion Code of 4 is not error, why do you think so it's an error? And what is "alias Column names"?
Suggest you show the Job you've used, the message you think is an error-mesage and what you expect as output and what are you getting already. |
|
Back to top |
|
|
|