Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an in line perform? When would you use it? Anything else you wish to say about it.

1137


what is search and searchall?what is the diffrence between them?give an best example?

6910


What is a SSRANGE and NOSSRANGE?

1519


IF I mention stop run in CICS what happens?

2421


What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?

1261


Can we redefine the field of x(200) to less than 200?

1429


What kind of error is trapped by on size error option?

1286


Explain how you can characterize tables in cobol?

1110


How to use the same COBOL program in Batch and CICS on lines? explain with an example

2433


if we have " ibm mainframe ",in that how to remove first and last leading space eg:"ibm mainframe" like that the answer we need

1378


Differentiate between structured cobol programming and object-oriented cobol programming.

1208


Name the sections present in data division.

1302


How to remove the spaces at the end of each record in the output file of variable length, via cobol program?

1213


Difference between cobol and cobol-ii?

1335


What is amode(24)?

1288