|
View previous topic :: View next topic
|
| Author |
Message |
Pavan101
New User
.jpg)
Joined: 09 Mar 2009
Posts: 13
Location: Bombay
|
|
|
|
Hi,
I need to use SQL Query through the control card to execute the job, Plz help me on same, How can i use it. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| I need to use SQL Query through the control card to execute the job, Plz help me on same, How can i use it. |
Ok for the language barrier, but really it is impossible to parse the above sentence in any understandable fashion!
think carefully what You requirements are and post/reword them in a more understandable way
please help those willing to help You |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Control-card is a very generic term - different individuals will anticipate it differently. I need to agree with enrico, however, being from a non-english back-ground I hear that jiberish every day so will try to answer...
If you are using DSNTIAUL with IKJEFT01 and because PROCs can not have in-stream data and some oen asked you to write the query in some member of PDS (control-card) then you can write your-query statements in a member of PDS (LRECL=80) and refer that to in sysin for a JCL of this nature. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| And if that is not what you are looking for - GO TO post from enrico. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| It is very possible to read a select statement from a file or sysin (no difference which you use), prepare it as a dynamic sql statement and execute it. I have a program that does just that to produce comma and tab delimited files for our use. It takes a very deep understanding of COBOL and data formats to do it. I wrote the program several years ago and we use it a hundred times a day in production and test. No i will not share it, my employer pays me for my knowledge and skills. |
|
| Back to top |
|
|
|
|
