is it possible to pass an SQL query inside a jcl which is
inside a cobol program?
- 5 Answers
- 12437 Views
- CTS, I also Faced
- E-Mail Answers
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 |
can u plz expain me how to declare dynamic array? what is the meaning of depending on clause in dynamic array?
01 ws-p pic 9(2). 01 ws-q pic 9(2) value 01. 01 ws-r pic 9(2) value 99. p.d. compute p = q + r what will be result of p ans(00) but my question is that how i got 10 on the place of 00. (truncation will ocuure on right side not left). please tell me ?
how do you reference the variable block file formats from cobol programs
what are decleratives in cobol?
If you are current on the owner of a set, what is the difference between an obtain next and obtain first? Actually in which topic will we use dis???Plz explain it clearly
How can you declare the file ?
what is the advantage of sync class
what are the diferences b/w sub-script and index?
give the examples of strings in cobol
how we can reverse the string in the cobol for example satheesh can be reveresed as hseehtas
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
What is the Purpose of POINTER Phrase in STRING command
COBOL 
