Page 1 of 1

Inline DB2/SQL ?

PostPosted: Thu Jul 19, 2012 9:53 pm
by ursmdnpavan
Recently i attended interview in mnc company f/g r some questions am unable to answer.
1. What is Inline SQL ?
2. Copy particular records from multiple datasets to one o/p dataset.
3. How to send data from JCL to COBOL/DB2 ? am not asking jcl to normal cobol it is db2/cobol.
And rest of the questions i answered and they asked me questions from C, C++, OOPS, SDLC too.

Please someone answer above 3 questions.

Re: Inline DB2/SQL ?

PostPosted: Wed Jul 25, 2012 1:22 am
by Akatsukami
ursmdnpavan wrote:1. What is Inline SQL ?

A LUW thing. I don't think that it is relevant to mainframes.
2. Copy particular records from multiple datasets to one o/p dataset.

Same way(s) as you'd copy particular records from one input data set (remember that concatenated data sets are logically a single data set).
3. How to send data from JCL to COBOL/DB2 ? am not asking jcl to normal cobol it is db2/cobol.

The same way(s) as for a COBOL program (or one written in any other language) that does not use DB2 (I suppose that we could consider a program invoked by the RUN command of background TSO to be significantly different, but I'd just encapsulate it in a teeny bit of Rexx so that looked the same).