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?
- 5 Answers
- 14156 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sk
Hey Rajesh,
this is the joke of year. :0) cheers!!!.
-SK.
| Is This Answer Correct ? | 3 Yes | 0 No |
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 |
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 |
Answer / rajesh
Yes. We can move the sql statements from COBOL to JCL using
HPUNLOAD utility.
| Is This Answer Correct ? | 0 Yes | 1 No |
Extract only those records from a PS file which are having word 'TEXT' in the records using COBOL? The word TEXT is not present in a particular position in all the records.
What is the linkage section?
What is sqlca and why is it needed in any cobol-db2 program?
Can the OCCURS clause be at the 01 level?
Please let me know how the Eject verb works for page break.. I want to know the code, how it is used.
What are declaratives and what are their uses in cobol?
Give some advantages of REDEFINES clause?
The hierarchy of the execution of logical operators is (a) NOT AND OR (b) AND OR NOT (c) OR AND NOT (d) OR NOT AND
10 Answers Huawei, IBM, TCS,
How to read the last 100 records from a COBOL file. The file contains N number of records.
can we declare occurs in 01 level?
What is Comm?
2 Answers IBM, Kemper Corporation,
WT R TECHNICAL MAINFRAME QUESTION ASKED IIN ANJANASOFTEARE??
COBOL 
