IBM MainFrame Question:

Download Job Interview Questions and Answers PDF

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?

IBM MainFrame Interview Question
IBM MainFrame Interview Question

Answer:

If table is empty then we alter this column to any length,
but if some data got inserted into the table then we can
also decrease the column length upto largest data size
available in that perticulat column.

Download IBM MainFrame Interview Questions And Answers PDF

Previous QuestionNext Question
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?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?