Page 2 of 2

Posted: Sun Mar 23, 2008 11:49 pm
by ray.wurlod
Please verify that the name of your job is BIOS_OUTNA_OWNDELT_FILE_GENERATION, the name of your Sequential File stage is TGT_BIOS_C069_OUTNA_HEADER_PART_OWNDELTFILE, and the name of the input link is TGT_BIOSFILE_DATA (just so we can be sure we're all talking about the same component).

Can you also post the section for this export operator from the generated OSH script?

Posted: Sun Mar 23, 2008 11:55 pm
by chulett
Search for all terms using "$PROJDEF view data". You'll find several posts that note known problems with $PROJDEF and View Data. It didn't work at all in 7.0.1 and was allegedly fixed in 7.5.1A but perhaps it is broken again in 7.5.2. Or you missed a patch. [shrug]

Posted: Mon Mar 24, 2008 1:17 am
by Rajee
ray.wurlod wrote:Please verify that the name of your job is BIOS_OUTNA_OWNDELT_FILE_GENERATION, the name of your Sequential File stage is TGT_BIOS_C069_OUTNA_HEADER_PART_OWNDELTFILE, and the name of the input link is ...
I have checked it,all that are perfect.

Posted: Mon Mar 24, 2008 1:57 am
by ray.wurlod
$PROJDEF is not substituted in View Data, but is substituted when the job runs. I have just proven that - I received the same message that you posted when using View Data but, when I ran the job, the message was

Code: Select all

Message:
EnvVarParamTest..TGT_BIOS_C069_OUTNA_HEADER_PART_OWNDELTFILE.TGT_BIOSFILE_DATA: DSD.SEQOpen Unable to create file Spring\BIOS_C069_OUTNA_OWNDELT_HEADER_PART .


At the beginning of the job, the "job starting" event yielded

Code: Select all

Starting Job EnvVarParamTest.
$SEASON = Spring   [$PROJDEF]
DataStage 7.5.2, Windows platform.