DSXchange

yes we do have those options and we did check that. Once after running this i can confirm the result. thanks for all your replies

We are using 7.5.1

chulett wrote:What 7x version of DataStage, exactly? ...

I have a sequence of jobs in my main job named "abc". I if any one of my job in my main job aborts, i want the main job to run from that particular point it got aborted, if i restart the main job. is this possible. if so please let me know the solution.

I did change the type of my routine to transform. But this routine doesnt serve my purpose. Is there any other way of doing this

arnabdey wrote:By the way it is not ans..... It is Ans.

What do you mean by transform type routine? I did set ans=1 inside my routine. but i was not able to get this value outside. Hi From the routine you can retrun a value by giving the following Ans=..... at the end The value is returned only if it is a transform type routine. Now it's output trigger s...

Inside jobsequence i have a routine activity which calls a routine. I want to set a value inside this routine and in the next nested conditional stage i want to get this value and do a comparison. How can I get the value outside the routine.setting userstatus dont work out here.Can i use return to s...

I have a sequence of jobs.In this sequence one of the job have an ODBC stage which executes a select statement and gets a single out put value.WIth out storing this value in a sequential file I need to store this value in some variable and want to use it in some other job of the sequence. How can i ...

:) thanks a lot...It did work You may want to consider using a Execute Command stage instead as that's what it is for after all. Unless there's more going on than just the script call, of course. In any case, the answer is 'go ahead'. :wink: There's an actual trigger Expression Type built in for Ret...

I am running a unix script by using EXECSH in routine activity. after running the script it returns a value 1. I want to get this value in my sequencer, so that after getting this value i can do a conditional check before proceeding ahead

Frist I do set the value for environmental varialbe OFL_ENV in admininstrator as DEV. Then in my job properties i set the value of this variable as $PROJDEF. After that i did invoke this variable in transformer stage from expression editor. AFter invoking the value the transformer stage field has va...

No, I am not typing in the environment variable. I am using expression editor to insert the job parameter. But still its not working. I am getting compilation error in transformer stage. Are you typing in the environment variable name or using the Expression Editor? I have seen folks have this probl...

I am keeping the variable as $OF2_ENV.

DSguru2B wrote:How are you passing the environmet variable inside the transformer, remember, no surrounding hashes are required for a parameter/env. variable inside the transformer. ...

I am setting an environmet variable at datastage administrator level. I am using that variable in transformer stage. after transformer stage i am having sequential file stage. when i compile my job i am getting compilation problem with transformer stage. if i remove environment variable it works fin...

Even I am getting this problem. I am having a transformer stage and then an FTP enterprise stage. What ever comming from transformer is directly FTP'd. The FTP'd file is havin NL[newline] character at the end. I did specify fixed length for record length but isuue is till the same. please help me. I...

My parallel job is having a transformer stage and what ever comming from this transformer stage is directly FTP'd to a remote vista server.The file FTP'd is having newline charters at the end of the record. I am FTP'ng the file with content "AB" and when i open the FTP'd file in vista I am...