How to overcome SAS Parallel Data Set Stage Constraints

[dhwankim]

Hi Gurus.
Yesterdata, We has installed DataStage SAS relative Stoage (SAS Paralle Data Set Stage / SAS Stage).

After the installation. I made Sample Job with SAS Parallel Data Set Stage).

But The Problems is using file xxxx.psds and

Actual File Name and location is written in xxxx.psds Automatically.

PLS See Below.
Orchestrate SAS Dataset
LFile:
crmdm:/SAS/DATA/01/dwtft/dfibiz/sampesas.psds.212416.811013736.1076922129/sampesas.sas7bdat

But Your Need is defined sas file name and location manually (xxxxxx.sas7bdat)
Because of End User'll access xxxxx.sas7bdat in special directory.

So I want to how to define exact location and written sas file.


for additional information.

Actually I do not want use paralle processing for write this file.


Thanks In Advance.


Daehwan Kim

[Teej]

Uh...

DataStage Server jobs (which you indicated your job type to be) are not compatible with PX stages (which Orchestrate is).

Dataset is a PX concept, not Server. They partition over multiple nodes as defined by your job's $APT_CONFIG_FILE. Maybe there's an option within the stage to override $APT_CONFIG_FILE, but I do not recall of any stages capable of doing that. But basically, you have a header file, and a whole set of data files.

Please let us know whether you are using PX jobs, or Server jobs.

-T.J.

[bigpoppa]

.psds files are parallelized SAS datasets that have been "PX"d. You can't use them with native SAS, only with PX. If you do not want a parallel dataset, write the output of the stage to the Sequential File stage and create the dataset as a regular UNIX file.

-BP