DSXchange

What version DS you are using. in DS 7.5 Job properties window >> Parameters tab>> you have Button called "Add Envrionment Variables". you can use this to add job parameters . and in Transformer stage expression window when you right click you can see popup window and you can able to sele...

cmmurari wrote:hi

you have to use only $FLAG . don't use # # for environment variables.

Cheers,
krish

Hi chris,

$FLAG also not working...

Well, $FLAG tells me its a user-defined enviornment variable you set vs. a Job parameter.....did you create a user-defined enviornment variable? I ask because when you say #$FLAG" this presumes its a user-defined environment varaible.....If its #FLAG# then its not a user-defined environment va...

In the transformer stage your right mouse click menu is your friend and guide. On it you will see the "Job Parameter" option and selecting the job parameter will show you that it gets inserted into the derivation or constraint field without any surrounding characters. Eg. $FLAG If I use $...

Hi,
Can any one help me the syntax of passing the job parameters in parallel transformer stage ..

Ex $FLAG defined as job parameter in the job

in parallel transformer if I use the same #$FLAG# i am getting error.

Thanks in advance

You can use control ( email - notifier ) which directs the control of main flow depending upon the trigger value ( Success or fail )

Hi, One question...............I defined some user defined variables through Data Stage Administator ..........I am using the same variables in DataStage jobs.....My question is how to define the dynamic variables in Administrator... when ever I change the variable value in Administrator That should...

Latesh,,

Thank you very much....
Ram

Hi,

I am getting the following error while compiling a job which has a transformer ..........

APT_CONFIG_FILE must be set up to compile parallel transformer job

but.... i have defined the $APT_CONFIG_FILE with proper configuration..

can any one help

thanks
ram

Hi ,


How to submit a Datastage job ( Datastage 7.0 ) from UNIX command line?

Thanks
Ram

Hi, I am getting the following error while reading the data with teraread after processing 90million records ..... total records in the table is 200 million records Teradata_Enterprise_3,6: Caught exception from runLocally(): APT_BadAlloc: Heap allocation failed. Teradata_Enterprise_3,4: Operator te...

Hi , When I use a teraread through datastage I am getting the following error after processing some records ##I TOSH 000010 18:28:34(000) <main_program> orchgeneral: loaded ##I TOSH 000010 18:28:34(001) <main_program> orchsort: loaded ##I TOSH 000010 18:28:34(002) <main_program> orchstats: loaded ##...

Hi ,, I am getting following error when I compile the Data stage Job ( Transformer ) Output from transformer compilation follows: ##I TFCN 000001 23:28:59(000) <main_program> DataStage XE Parallel Extender V7.0.0 Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc. All Rights Reserved ##I TOSH 0...

Vitali,,

How can I define the inRec :*; in Data stage schema

thanks
ram

Hi, I have a question.... I have to import a Orchestrate schema definition to Data Stage Example : record ( npa : string; nxx : string; tel_ln_no : string; inrec : *; ) In the above example How can I handle the inRec: *; portion while importing it to Datastage ?????.... Thanks in advance Ram