MainFrame Interview Questions
Questions Answers Views Company eMail

What does a status return code of nn29 mean in relation to record locks?

1 1703

Why would you use find and get rather than an obtain?

2 2220

What is a bind?

1 2235

Is there a application program coding difference between local and central version mode?

1 3427

If you are current on the owner of a set, what is the difference between an obtain next and obtain first?

2 2211

How many types of queries does QMF offers?

1 2126

What is Structured Query Language (SQL)?

1 2002

What is Prompted Query?

1 2171

What is Query By Example (QBE) ?

1 2657

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

1128

What is the use of ERROR Log ?

1 2183

How to run a query using Run Query?

1 1835

How to view the Results of a Query?

1 1871

How to Clear a Query Using the RESET Command ?

1214

How to Provide Column Names Using the DRAW Command ?

1111


Un-Answered Questions { MainFrame }

what is service program?

603


Explain how do you control cursor positioning?

569


What is RRange and ARange?

1665


How gdg are concatenated?

672


can you explain the difference between spacea,spaceb,skipa and skipb. I'm new to learning about as400 and printer files. can any one give me an example using source code showing the difference that occurs between using these 4 keywords. A-Physical file PF004 source UNIQUE R RR STUNAM 10 ROLLNU 5 0 MARKS 3 0 SEX 6 K ROLLNU 4 records present in PF004 are STUNAM ROLLNU MARKS SEX KAVYA 12,344 55 FEMALE MADHAVAN 14,579 60 MALE RAMYA 14,785 70 FEMALE KRISHNAN 14,988 72 MALE B-Printer File PRINT1 source A R HEADER A 10 3'STUNAM' A 10 20'ROLLNU' A 10 30'MARKS' A 10 40'SEX' A R DETAIL A SPACEB(1) A STUNAM 10 3 A ROLLNU 5 0 20 A MARKS 3 0 30 A SEX 6 40 A R FOOTER A SPACEB(1) A 20'END OF REPORT' C-RPG/400 Program PRTTPG source FPF004 I F E DISK FPRINT1 O E PRINTER C WRITE HEADER C READ PF004 60 C *IN60 DOWEQ *OFF C WRITE DETAIL C READ PF004 60 C ENDDO C WRITE FOOTER C SETON LR D-spooled file result set Display Spooled File File . . . . . : PRINT1 Page/Line 1/10 Control . . . . . Columns 1 - 130 Find . . . . . . *...+....1....+....2....+....3....+....4....+....5....+.... 6....+....7....+....8....+....9....+....0....+....1....+.... 2....+....3 STUNAM ROLLNU MARKS SEX KAVYA 12344 055 FEMALE MADHAVAN 14579 060 MALE RAMYA 14785 070 FEMALE KRISHNAN 14988 072 MALE END OF REPORT Bottom F3=Exit F12=Cancel F19=Left F20=Right F24=More keys I have changed from SPACEB to SPACEA now in my printer file source E-Changed PRINT1 Source A R HEADER A 10 3'STUNAM' A 10 20'ROLLNU' A 10 30'MARKS' A 10 40'SEX' A R DETAIL A SPACEA(1) A STUNAM 10 3 A ROLLNU 5 0 20 A MARKS 3 0 30 A SEX 6 40 A R FOOTER A SPACEA(1) A 20'END OF REPORT' F-Spooled file Result Set after keyword change Display Spooled File File . . . . . : PRINT1 Page/Line 1/10 Control . . . . . Columns 1 - 130 Find . . . . . . *...+....1....+....2....+....3....+....4....+....5....+.... 6....+....7....+....8....+....9....+....0....+....1....+.... 2....+....3 KAVYAM 12344U 055KS FEMALE MADHAVAN 14579 060 MALE RAMYA 14785 070 FEMALE KRISHNAN 14988 072 MALE END OF REPORT Bottom F3=Exit F12=Cancel F19=Left F20=Right F24=More keys Overprinting not displayed.

10263






What is next sentence and continue unique?

576


what is the clp command to access a query/400?

1368


What are the advantages of vsam over isam?

694


What do you understand by the term “keyword” with respect to jcl and what is the opposite of the term?

682


In which area will you utilize 88 level items in cobol?

724


Write a program that uses move corresponding.

674


Which Search verb is equivalent to PERFORM…VARYING?

688


Can I cleanly uninstall oorexx?

583


Which isolation level provides maximum concurrency?

668


What are various search techniques in cobol? Explain.

650