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?

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 wrong with the following data declaration? 01 W-DATE PIC X(6). 05 DD PIC 99. 05 MM PIC 99. 05 YY PIC 99. (a) Nothing is wrong. (b) Under W-DATE all level 05 items are having a PIC 99 but level 01 has PIC X(6). (c) PIC can't be specified for a group item. (d) DD, MM, and YY are invalid datanames.

6 Answers   Mphasis, TCS,


which one is the best of com and com-3.using of real time ?

7 Answers   Cap Gemini,


I want ALL ERROR codes in VSAM

3 Answers   American Express, TCS,


how to transfer the file from pc to mainframe??

4 Answers  


what is the difference between perform varying and perform until

4 Answers   TCS,


. How do we cast a variable in COBOL

1 Answers   HSBC,


period is missing in the cobol program which error we getting

5 Answers   TCS, Tesco,


how can count the number of character in feild ?? suppose for instance i have a feild with value ' rajesh sarkar' then how can v count the number of characters whitout spaces...........

4 Answers   Wipro,


How can we find out wether to declare the data items like Integer, Char,Comp? If comp types how can we decide wether it is Comp and Comp3.How it is? Please Explain... Cheers.

1 Answers   Syntel,


How we copy a program from production region to development region.What is the process & syntax ?

3 Answers   CTS,


SSRange is used to do a range check on which of the Following. SUBSCRIPT,INDEX,REFERENCE MODIFICATION,Run-time option.

3 Answers   Lehman Brothers,


What are the divisions in a cobol program? Which one is the mandatory division among them?

1 Answers  


Categories