Hi,
I want to create alternate index on VSAM file.my file
structure is ex:
RoomID pic x(7) R000001
Floor pic a((6) First
RoomNo pic x(2) FA1
Occupied(yes/no) pic a(3) Yes
Occupied Batch pic x(10). Maths
i want to create alternate index on floor,roomno fields.can
i create alternate index on both the fields.and tell me how
to create.
How to create a link between multiple maps in a mapset? How
to make use of Transid in this case?
196
What is the error condition that is set when the file
specified in the NAME option is not in the FCT?
146
If I want to execute Sftp commands(LS & GET) stored in
Physical file from CL program automatically...Can u Plz
tell me how can I do this?...How the script will look??
THANX FOR NY HELP...
23
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;
187
How much memory does variable of 6 decimal (15, 2) take in
PL/1?
can anybody help me to solve this problem. the program that
i m checking display error message saying "Record format
for file AJDSPFFD does not match model file and decimal
error. how to solve this problem. The AJDSPFFD is snapshot
the AJTLOG that is the audit trail list.
124
I want to set position for a particular text in a certain
position in several of my cics maps.Please provide me with
a solution.
Ex: If "F1-Help" has to be set to pos(4,27) always in all
the maps within a PDS.
79
Name some translator and compile options and explain their
meaning?
what u mean by csrloc and rtncsrloc in rpgIV in as/400.Give
an eg? to do...give some coding...what is row no and column
no ???..if possible...give a no of lines coding....please
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)?
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.
226
Tell me abt any another framework which is challening for
Ibm framework