what is the use of UNIQUEUE KEY WORD?
what is the difference between PFILE AND REF?
20
how a varible can be passed to a subfile...accnt1 contain
data in a data area..ie Daccnt1 uds,Daccnt2 3
overlay(accnt1:1),
DNo 4 overlay(accnt1:4)..we want to transfer this dataarea
value from acnt0001 to a subfile..that means to enter each
record we have to incriment account no,,
i normal window we can do
move accnt1 account_no
eval account_no=accnt1
eval no=no+1
exfmt usr_account
how it possible with Subfile????????.Please do answer?
(Thank you for all your answers dear friends!!)
Suppose you are adding a new field in a map, and that field
should also be added as a new column in DB2 table. How do
you implement this? what is the impact analysis u will do?
Can any one tell me that how we go for the compare,unit
testing after changing requirement as per client request.
this is very helpful for me when u give suitable (coading)
exmple.
<CICSFault
xmlns="http://www.ibm.com/software/htp/cics/WSFault">DFHPI10
08 05/13/2009 05:47:14 FSCIBM SOAP message generation
failed because of incorrect input
(INPUT_STRUCTURE_TOO_SMALL ).</CICSFault>
Can anyone suggest how to handle this type of error?
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;
186
How can we increase the size of an existing PDS to include
more no. of modules.
34
Yes. Because the alternate key would first locate the
primary key, which in turn locates the actual record. Needs
twice the number of I/Os.
205
what is OUTFILE?what is the uses and disadvantage?
where we can use this?
24
When you compile a CICS program, the (pre)compiler puts an
extra chunk of code. Where does it get stored
303
How can I find the maximum value of a field in a file while
reading the file dynamically? without using sort function.
Suppose i have a file with fields Timestamp, description,
teamname, teamnumber.. i have read the file till end and
find the maximun value of timestamp which is not in sorted
order.. can we use function max(timestamp)?
what is primarykey?what is difference between primary key
and forign key?
28
I'm new to rexx. How to code rexx in jcl to read in a lpar
cpu usage file and select 1. date, time 2. some system
names 3. cpu usage for each system. The input file has
hourly reporting. The output file (CSV)is for excel use.
Run in batch mode. Output in FB.
To Refer this Site to Your Friends 
Site Map
