IBM MainFrame Question:
Download Questions PDF

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?

IBM MainFrame Interview Question
IBM MainFrame Interview Question

Answer:

One can use Inner Join to get data from two tables.

Download IBM MainFrame Interview Questions And Answers PDF

Previous QuestionNext Question
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?How can we increment subscript and index?