IBM MainFrame Interview Questions
Questions Answers Views Company eMail

How do you filter out the rows retrieved from a Db2 table ?

1 8405

What is a clustered index?

1 11356

When will you chose to run RUNSTATS?

1 8417

What does DML stand for and what are some examples of it?

IBM,

3 8026

What is meant by a unit of recovery?

1 5379

What is CHECK PENDING ?

5 17690

What is a thread?

3 6477

What is filter factor?

2 9484

What's the maximum number of volumes that can be added to a STOGROUP?

IBM,

1 8161

What are PACKAGES ?

3 7764

Which catalog tables contain authorization information?

1 5277

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 8322

How does one remove entries from the SCT02 table?

1 3859

what is the difference between join and union?

IBM,

4 17019

I use CS and update a page. Will the lock be released after I am done with that page?

2 8617


Un-Answered Questions { IBM MainFrame }

What is amode(31)

714


can oorexx run ibm object rexx programs?

600


Explain identify whether a call statement is a static or dynamic call?

546


What is the physical storage length of the data types date, time, and timestamp?

600


What does a ROLLBACK do?

1119






What do you mean by between and in? Is between inclusive of specified range values?

662


Can I send output of job to my remote device careerride123?

661


how to define a directory and what is the structure and definition for the same?

620


Explain the use of the where?

586


How to get the last record in vsam file in cluster?

568


WORKING-STORAGE SECTION. 01 GROSS-PAY. 05 BASIC-PAY PIC 9(5). 05 ALLOWENCES PIC 9(3). PROCEDURE DIVISION. MOVE 1000 TO BASIC-PAY. MOVE 250 TO ALLOWENCES. DISPLAY GROSS-PAY. STOP RUN. 77 W-A PIC 9(3)V99 VALUE 23.75 77 W-B PIC ZZ9V99 VLAUE 123.45 after the statement MOVE W-A TO W-B what will be W-B's value? a.123.75 b.b23.75 (where b indicates space) c.023.75 d.invalid move

850


What are union and union all?

537


What parameters can be used to limit the number of records written to a sysout dataset?

741


What do you mean by CEMT?

771


Hi, While I am trying to produce a html report from SAS interactive screen, I am always getting an error. I have attached the result of interactive execution with this. Please help me on this. NOTE: All profile changes will be lost at the end of the session. 1 *libname ia 'U19K.CAPS.SAS'; 2 3 /*Data declaration*/ 4 data work.staff; 5 infile 'U19K.CAPS.SAS (RAWDATA1)'; 6 input LastName $ 1-10 FirstName $ 11- 20 7 JobTitle $ 21-23 Salary 24- 28 8 BirthDat $ 29-37 Gender $ 38 9 run; 10 11 /*Basic "format" statement*/ 12 /*assign range of values to a variable and use it*/ 13 /*'$' should be used for a alphanumeric manipulation*/ NOTE: The infile 'U19K.CAPS.SAS(RAWDATA1)' is: Dsname=U19K.CAPS.SAS (RAWDATA1), Unit=3390,Volume=XTD007,Disp=SHR,Blksize=6160, Lrecl=80,Recfm=FB NOTE: 20 records were read from the infile 'U19K.CAPS.SAS (RAWDATA1)'. NOTE: The data set WORK.STAFF has 20 observations and 7 variables. NOTE: The DATA statement used 0.01 CPU seconds and 7537K. NOTE: The address space has used a maximum of 3676K below the line and 15196K above the line. 14 proc format; 15 value Salrange low- 10000='Below' 16 10001- 20000='Medium' 17 20001- High='Above'; NOTE: Format SALRANGE has been output. 18 value $Gender F='Female' 19 M='Male'; NOTE: Format Ă…GENDER has been output. 20 run; NOTE: The PROCEDURE FORMAT used 0.00 CPU seconds and 7523K. NOTE: The address space has used a maximum of 3676K below the line and 15196K above the line. 21 22 /*ODS-Output delivery system to create html file*/ 23 ods listing close; 24 ods html file='C:\Documents and Settings\u19k\Desktop\html1.html'; NOTE: Writing HTML Body file: C:\Documents and Settings\u19k\Desktop\html1.html ERROR: Invalid file, C:\DOCUMENTS AND SETTINGS\U19K\DESKTOP\HTML1.HTML. WARNING: No body file. HTML output will not be created. 25 26 /*Basic "label" statement*/ 27 proc print data=work.staff split=''; 28 label LastName='Last Name' 29 FirstName='First Name' 30 JobTitle='Job Title' 31 Salary='Annual Salary'; 32 format Salary Salrange. Gender $Gender.; 33 var LastName FirstName JobTitle Salary Gender; 34 title 'Employee database'; 35 run; WARNING: No output destinations active. NOTE: The PROCEDURE PRINT used 0.00 CPU seconds and 10275K. NOTE: The address space has used a maximum of 3676K below the line and 15196K above the line. 36 37 /*ODS-html closing*/ 38 ods html close; 39 ods listing;

2378