IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is different between variable length and fixed length?

TCS,

2 7358

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;

2374

what is the alternative to model parameter?

1686

can we read records in a file from botom to top. if possible how can we read

ACS,

12 17073

01 a pic s9(5) value '-12345' how it will be stored

ACS,

7 13091

how we can edit records in vsam data set and non vsam data sets

ACS,

2 7024

what is the advantage of sync class

ACS,

3 9664

01 a pic x(4) value 'abcd' 01 b pic 9(3) can we move from a to b.if possible what would be stored in b.

ACS,

15 16913

after submiting the jcl.how do you know that the job has been completed.

ACS,

4 7642

how do you resolve for soc7 error

ACS, iGate,

6 19564

I have a PDS and want to omit few rows of all members of a PDS. How to do it?

Accenture,

6 11714

At which situation we need to use the push and pop conditions...pls tell me with exampls.

Xansa,

2 11547

pls tell me abt the normalization five types....

2 4134

I have a Symbolic Parameter which can have a value say 01 or 02 etc. Now consider i have another Symbolic parameters which is used to get 3 digit code of months (JAN, FEB, etc) but for that i need to check the first symbolic parameter's value and provide its corresponding month's name in the second symbolic parameter. Say IF sym1 = 01 then sym2='Jan' ENDIF etc... In JCL, IF condition is used for RC, ABEND purposes of a step etc. When i use Symbolic parameter in IF clause it is showing Error message. Is there a way to get the above result possible in JCL. If you could provide me with an example, i would understand it better.

2621

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

Cap Gemini, Verizon,

4 9832


Un-Answered Questions { IBM MainFrame }

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

487


What happens when you issue a escape routine in a program? Will there be any compilation /run time erro?

539


Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.

5049


What is an instance in db2?

558


Particular area has been affected in cics screen, what is the process to find?

8516






What is the use of trt instruction?

576


List out the buffer pools in db2

619


How do you create a like table?

524


Define the necessity of run stats among the environment test?

515


What is the binary search?

533


In sms datasets, what is the function of the dd avgrec keyword?

644


how to get the last record in vsam file in cluster? And how can u get the ksds file records into ur cobol program?

536


what is need of start 0? In steed of

669


What is the max length of sqlca?

755


What is the facility that allows mainframes to be partitioned into lapars?

596