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?
Submitted by: AdministratorOne can use Inner Join to get data from two tables.
Submitted by: Administrator
Submitted by: Administrator
Read Online IBM MainFrame Job Interview Questions And Answers
Top IBM MainFrame Questions
| ☺ | How do define Dynamic array in COBOL how do u define single dimensional array and multidimensional array in your COBOL? |
| ☺ | Can 88 level variable be declared in FD section? |
| ☺ | What is difference b/w file-aid tool and file-aid utility? |
| ☺ | How to handle -911 (deadlock) error in a db2 program so that the program will never abend? |
| ☺ | Suppose I have 1000 rows in a db2 table. I want to update first 100 records, How do I do it? |
Top Mainframe Technical Categories
| ☺ | IBM MainFrame Interview Questions. |
| ☺ | IBM AS400 Interview Questions. |
| ☺ | JCL Interview Questions. |
| ☺ | IMS DB Interview Questions. |
| ☺ | CICS Interview Questions. |
