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

i was faced one question- i have value -00001234.56 Suppress the zeroes and the output should be -1234.56 But Not - 1234.56 spaces should not be available after suppressing the zeroes. logic in jcl and cobol?

0 Answers  


1.What is the limit of linkage section?

4 Answers  


When and how can we use index & subscript ?

2 Answers  


Describe the difference between subscripting and indexing ?

2 Answers  


what is the use of comp2 ? where can we use it with example ?

3 Answers   Covansys,


how we can edit records in vsam data set and non vsam data sets

2 Answers   ACS,


if one main program ,n -subprograms are then which call you follow ?why reasonuhg

4 Answers   UHG,


If i have a variable A pic 9(2) value 10 Compute A = a - 100 what will be the value of A and will there be any error becoz of the Negative value

3 Answers   CTS,


what is label record is standard or omitted in file description of data division?

3 Answers   IBM, TCS,


What is LENGTH in COBOL II?

2 Answers   CSC,


How to read a record from bottom of a file which is indexed by 'A'.

4 Answers   Oracle,


When search all is used in cobol program without sorted input data?

6 Answers   CGI, Principal Finance,


Categories