Inline DB2/SQL ?



Inline DB2/SQL ?

Postby ursmdnpavan » Thu Jul 19, 2012 9:53 pm

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.
ursmdnpavan
 
Posts: 2
Joined: Mon Jun 18, 2012 7:54 am
Has thanked: 0 time
Been thanked: 0 time

Re: Inline DB2/SQL ?

 

Re: Inline DB2/SQL ?

Postby Akatsukami » Wed Jul 25, 2012 1:22 am

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).
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1052
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to Interview Questions