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



is it possible to pass an SQL query inside a jcl which is inside a cobol program?..

Answer / sk

Hey Rajesh,

this is the joke of year. :0) cheers!!!.

-SK.

Is This Answer Correct ?    3 Yes 0 No

is it possible to pass an SQL query inside a jcl which is inside a cobol program?..

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

is it possible to pass an SQL query inside a jcl which is inside a cobol program?..

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

is it possible to pass an SQL query inside a jcl which is inside a cobol program?..

Answer / jswan

Yes you can, as long as your project manager don't find out about your silly movements :-)

Is This Answer Correct ?    0 Yes 0 No

is it possible to pass an SQL query inside a jcl which is inside a cobol program?..

Answer / rajesh

Yes. We can move the sql statements from COBOL to JCL using
HPUNLOAD utility.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More COBOL Interview Questions

what is rediffine clause?in what situation it can use?give me real time example?

1 Answers   IBM,


What is the utilization of copybook in cobol? Could we utilize a similar copybook?

0 Answers  


How do u initialize an array?

2 Answers   CTS,


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)

1 Answers   Cap Gemini,


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

2 Answers   IBM,


what is difference between cobol and cobol/400

1 Answers   HCL,


What is the Importance of GLOBAL clause According to new standards of COBOL?

2 Answers   Infosys,


Can anyone please give the example of Inline Perform.

6 Answers   TCS,


What is the difference between comp and comp-3 usage?

0 Answers  


How may divisions are there in JCL-COBOL?

5 Answers   IBM,


What is diff between vsam and db2?what is advantage of db2 over vsam?which is best suited one?

1 Answers   Fidelity,


how to display the dataset information?

2 Answers  


Categories