When a job is deployed,
the file that was entered in the Raw data file or directory field
of the Staging Parameters tab of the staging
transformation (or in the Adapter Setup wizard)
appears in the generated code as part of a macro assignment (a %let statement).
In a production environment, it is possible that the raw data file
changes from day to day. The raw data file might also need to be allocated
externally, such as in the JCL of a z/OS batch job.
Note: For adapters that accept
files or directories as input, the code is %LET RAWDATA=raw-data-assignment.
If the raw data file
or directory is allocated externally, it is used in preference over
the location referred to in the %let statement.
For completeness, the %let statement
can be removed, but this is not necessary.
CAUTION:
Do not
remove or comment out the %let statement for adapters that do not
have a raw data file or a directory.
For some adapters
such as the SAP ERP, SAS EV, MS SCOM, HP Reporter, VMware Data Acquisition,
and VMware vCenter adapters, the %let statement
is present in the code. However, that statement does not specify a
file or a directory. Instead, the %let statement
points to the libref of the SAS library that is associated with the
raw data. (The location of the input library typically remains fixed,
unlike the name or location of individual raw data files.)
If the job is redeployed,
the raw data assignment is reset and needs to be removed again, unless
the raw data parameter in the Staging Parameters tab
is removed beforehand.
When allocating the
raw data file externally for adapters that are based on MXG, the correct
fileref must be used. (On z/OS, the fileref is assigned with a DD
JCL statement.)
For adapters that are not based on MXG, use a fileref
of RAWDATA. For adapters that are based on MXG, use the filerefs in
the following table:
Table of Filerefs for Adapters That Are Based on MXG
|
Adapter
|
Fileref
|
|
IBM DCOLLECT
|
DCOLLECT
|
|
IBM EREP
|
EREP
|
|
BMC Mainview IMS
|
IMSLOG
|
|
DT Perf Sentry with
MXG
|
NTSMF
|
|
IBM SMF
|
SMF
|
|
ASG TMON2CIC
|
MONICICS
|
|
ASG TMONDB2
|
TMDBIN
|
|
ASG TMONDB2 V5
|
TMD2BIN
|
|
CA TMS
|
TMC
|
|
IBM TPF
|
TPFIN
|
|
IBM VMMON
|
MWINPUT
|