IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is Query By Example (QBE) ?

1 2630

How the interaction between DB2, SQL, and QMF takes place?

1118

What is the use of ERROR Log ?

1 2155

How to run a query using Run Query?

1 1805

How to view the Results of a Query?

1 1838

How to Clear a Query Using the RESET Command ?

1199

How to Provide Column Names Using the DRAW Command ?

1097

How to Save a Query?

1176

What are Naming Conventions in QMF?

1421

What are Naming Standards in QMF?

1216

How many Query Options are there?

1 1972

What is the purpose of RUN Command?

1 1866

How to Add Comments to a SQL Query?

1 2009

How to Display the Names of Your Saved Queries?

1 2011

How to Erase a Query?

1 1918


Un-Answered Questions { IBM MainFrame }

What is the difference between structured cobol programming and object alternativelyiented cobol?

737


Explain the function of //cntl statement?

636


Can you define an alias?

565


How many registers we are using in mvs?

632


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

697






What is the use of disp parameter?

636


How can the duplicate values be eliminated from db2 select?

613


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

686


What is a page in db2?

596


List in order the hierarchical levels of jcl?

652


explain in brief how you can create a vsam file?

646


How can you quickly find out the # of rows updated after an update statement?

620


How do you write from PL/1 code to JCL?

1816


Explain the difference between cics program control table (pct) and cics processing program table (ppt)?

596


Is db2 a mainframe?

577