suppose I have two tables a and b. Both tables are connected with ssn number as foreign key. I want to retrieve a column data from b table. How will you write a query?
No Answer is Posted For this Question
Be the First to Post Answer
File1 has 100 records and file2 has 200 records I want to copy 50 records which are in both file into file3?
Categorize the mainframe manual testing?
Explain lock contention?
what are the parameter we cannot use in procedure? How many instream we can write in single jcl? Can we call instream to catalog and catalog to instream?
Why banking use IBM framework?
How do you create a like table?
what do u write in the impact analysis document (i.e, for a change request)
subscripting can be said as A) subscripting enables us to write a move compact code in the procedure division. B) subscripting enables us to refer to any element of a table by the same data name with the facility of identifying a particular element through the values of subscript. C) Subscripting reduces the no of entries to be included in the data division D) subscripting enables us to use loops in the procedure division
Can any one tell me that how we go for the compare,unit testing after changing requirement as per client request. this is very helpful for me when u give suitable (coading) exmple.
Explain delete-connected tables?
At what point are extension eliminators mandatory?
How do you handle exceptions PL/1?