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
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 |
State the various causes of s0c1, s0c5 and s0c7.
have in 100 records in a file i want to move only matched records to one output_file1 and nonmathed records are moved to another output_file2 ... any one can provide logic code
what is the use of outrecord?
Explain how will you differentiate between an internal and an external sort, the pros and cons, internal sort syntax etc
u have passed sme charecters thru parm parameter in jcl. how do u code in cobol to recieve the values u gave in parm ?
wht is structured cobol pgm and non structred cobol pgm ?
How do you compile cobol program..?
How do you define a table/array in COBOL?
What divisions, sections and paragraphs are mandatory for a COBOL program?
give the examples of strings in cobol
In a COBOL II PERFORM statement, when is the conditional tested, before or after the perform execution?
consider the following FD FILE-1 01 REC-1 PIC X(80) ...... WORKING-STORAGE SECTION 01 W-REC PIC X(90) ........ PROCEDURE DIVISION FIRST-PARA ....... READ FILE-1 INTO W-REC AT END MOVE 1 TO EOF-FLAG which of the following is true with respect to the above? a.REC-1 will contain nothing and W-REC will contain the contains of the record read b.REC-1 and W-REC contain the same data c.syntex is invalid and error will occur d.REC-1 and W-REC must be of same size