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

HOW TO MOVE REDEFINES CLAUSE FROM INPUT TO OUTPUT ?

1 Answers  


why we are using picture clause in the cobol programs?

2 Answers  


for an INITIALIZE and what keyword allows for an override of the default.

2 Answers  


what are the steps to sort in a cobol program?

2 Answers   Patni,


what is difference between the sysabend and userabend?

2 Answers  






Describe the difference between subscripting and indexing ?

2 Answers  


What are different data types in cobol?

0 Answers  


88 class is used for

5 Answers   CTS, EDS,


Explain about level numbers?

3 Answers  


What was removed from COBOL in the COBOL II implementation?

0 Answers  


How to delete leading spaces/blank in COBOL ? Example:- 01 data-name-1 pic x(220) " English is a language". I would like to delete leading spaces.

7 Answers   Financial Services,


Can we put move statement in COBOL copybook

3 Answers   Global Logic,


Categories