DSXchange

Looking at your original list of parameters, I think they should look like this : '$APT_CONFIG_FILE'=/opt/Ascential/DataStage/Configurations/2Node.apt 'InputDir'=/home/source/ 'InputFileName'=emp.dat 'OutputDir'=/home/target/ 'OutputFileName'=emp.out 'RejectDir'=/home/reject/ 'RejectFileName'=emp.re...

In your parameter file you need something like this for all your parameters :

t_config_file=/opt/Ascential/DataStage/Configurations/2Node.apt

Then in your script, you need something like this :

-param '$APT_CONFIG_FILE'=$t_config_file

Hope this helps

Are you using sequences ? If so, you could always create a sequential file in one job containing just the file name. Then in the sequence, you use the 'execute command' to perform a unix cat on that file to retrieve the contents. The next job in the sequence can pick up the output from the cat comma...

Further to my last note: I'm using the 'user generated sql' option but I'm wondering if this is being ignored as I can't get anything to work.
Could there be a bug here that ignores that option and just uses the generated sql ?
thanks

Thanks for your reply. However, the union still says 'data source is empty' via datastage and native sql fails saying that a UNION requires a table. I do have a sort of workaround for this but it involves using the row generator to generate 1 row with my default timestamp; this then gets filetered w...

Can somebody help please. I'm trying to use the Teradata API stage to select a max timestamp as follows : select max(#TDREJDATECOL#) from #TDDBASE#.#TDREJTAB#; However, the table is actually empty. I want to be able to return a default value in these circumstances. Whatever I try I just get the mess...