is it possible to pass an SQL query inside a jcl which is
inside a cobol program?
Answers were Sorted based on User's Feedback
Answer / sk
Hey Rajesh,
this is the joke of year. :0) cheers!!!.
-SK.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / amy
SQL query can be passed in the JCL but not sure of when it
is inside a cobol-program part
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sowjanya
take one file in cobol and write jcl code in it.
let say file1 is the file using in cobol program
working storage section.
01 ws-rec.
05 ws-jobcard pic x(80) value '//jobname job etc'
05 ws-joblib pic x(80) value '//step1 etc'
05 ws-step pic x(80) value'//ddname dd dsn=inpfile1 etc'
05 ws-step pic x(80) value '//ddname1 dd dsn=outfile1
etc'
_
file section.
select file1 assign to intr1.
fd file1.
01 file-rec pic x(200).
procedure division.
open output file1.
write file-rec from ws-rec.
and submit this program by using ddcard -
//intr1 dd SYSPRINT=(*,INTRDR) in jcl.
and write SQl code in inpfile1 file,query result will be
displayed in oufile1.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / rajesh
Yes. We can move the sql statements from COBOL to JCL using
HPUNLOAD utility.
Is This Answer Correct ? | 0 Yes | 1 No |
what is rediffine clause?in what situation it can use?give me real time example?
What is the utilization of copybook in cobol? Could we utilize a similar copybook?
How do u initialize an array?
We know that size of redefine and redefining need not to be same..Then does the below case true 01 ws-date pic 9(6). 01 ws-redf-date REDEFINES ws-date 05 ws-year pic 9(4) 05 ws-mon pic 9(2) 05 ws-day pic 9(2)
I have a seq file with different fields one field is address with pic x(50) as input in a cobol program. In address there is 'PUNE' at any different positions in the address field ( form 1 t0 50) . My requirement is select the fields with address 'PUNE' by using cobol. Please suggest
what is difference between cobol and cobol/400
What is the Importance of GLOBAL clause According to new standards of COBOL?
Can anyone please give the example of Inline Perform.
What is the difference between comp and comp-3 usage?
How may divisions are there in JCL-COBOL?
What is diff between vsam and db2?what is advantage of db2 over vsam?which is best suited one?
how to display the dataset information?