$PROJDEF

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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]
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rajee
Participant
Posts: 46
Joined: Thu Mar 13, 2008 7:06 am
Location: India

Post 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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply