MainFrame Interview Questions
Questions Answers Views Company eMail

What is db2 optimizer?

759

What are db2 objects?

630

How to find the number of rows in a db2 table?

638

How to take backup of table in db2?

587

How to get the ddl of a table in db2?

664

What is a db2 tablespace?

585

How to find primary key of a table in db2?

596

What are db2 tables?

635

What is db2 stogroup?

664

What is a db2 schema?

748

What db2 400?

665

What are packages in db2?

584

What is db2 look?

565

What is db2 bind process?

741

Is db2 a mainframe?

577


Un-Answered Questions { MainFrame }

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;

2370


What is runstats db2?

571


Explain what is the massinsert option?

622


How many minimum number of line codes does PL/1 DB2 program requires?

2576


can you specify some the distinctive features of a ksds, key sequenced dataset?

584






Tell me can we update with histogram?

594


How to define a directory?

487


What are the cics commands associated with task control?

521


What is RETURN CURSER LOCATION in subfile?

1066


what is full form for dds?

724


What do you mean by monitor block?

1343


How many program bind in one module....

2100


We can allocate memory dynamically by using GET MAIN command my question is at what scenario we can't release this memory and reuse this same memory??

2704


In a CICS program, how will you read a VSAM file?

640


Define cobol coding sheet?

557