Hi,
I set the environment variable as
LoadFiles --> C:\DSJOBS\LoadFiles\
In the project level i set the default value as $PROJDEF for $LoadFiles.
When i tried to read the data i am getting the below error.
##I TOSH 000002 09:08:40(001) <main_program> orchgeneral: loaded
##I TOSH 000002 09:08:40(002) <main_program> orchsort: loaded
##I TOSH 000002 09:08:40(003) <main_program> orchstats: loaded
##W TCOS 000049 09:08:40(004) <main_program> Parameter specified but not used in flow: _APT_CONFIG_FILE
##W TCOS 000049 09:08:40(005) <main_program> Parameter specified but not used in flow: _LoadFiles
##W TCOS 000049 09:08:40(006) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TFSC 000001 09:08:40(011) <main_program> APT configuration file: C:/Ascential/DataStage/Configurations/default.apt
>##E TOIX 000049 09:08:41(000) <Sequential_File_0,0> Unable to open $PROJDEFLoadFile.txt
>: No such file or directory
>##E TOIX 000000 09:08:41(001) <Sequential_File_0,0> Operator's runLocally() failed.
##I TOIX 000000 09:08:41(002) <Sequential_File_0,0> Output 0 produced 0 records.
>##E TFCI 000000 09:08:42(000) <APT_CombinedOperatorController,0> Operator's runLocally() failed.
>##E TFPM 000040 09:08:42(001) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E TFSR 000011 09:08:48(000) <main_program> Step execution finished with status = FAILED.
##I TCOS 000026 09:08:48(001) <main_program> Startup Time 0:06 Production Run Time 0:01.
Please help me to find the reason.
Regards,
Sura
Problem while using $PROJDEF
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You don't refer to $PROJDEF in your job design. You set up a regular job parameter (environment variable). Let's assume it's called $MYDIR. It is set up in the Administrator client and given a default value there.
In your job, you add $MYDIR environment variable as a job parameter, and set its default value to the special token $PROJDEF.
In the stage that needs it, you create a reference to that job parameter, enclosed in "#" characters if it's a passive stage. For example #$MYDIR#/LoadFile.txt
In your job, you add $MYDIR environment variable as a job parameter, and set its default value to the special token $PROJDEF.
In the stage that needs it, you create a reference to that job parameter, enclosed in "#" characters if it's a passive stage. For example #$MYDIR#/LoadFile.txt
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.