DSXchange

No way...
There is not Rollback process for DS_JOBS.

Hmm.... His point is... If you change the Environmental Variable at the mid of the execution of a sequence, the chaged value wont be reflected to the main job control, and hence wont refelect to the upcomming called jobs. So you need to use some of the conventional methond of passing values among jo...

Can you uncompress the same file using the mentioned command from command prompt with out any issue?

All the parameters can be stored in a file and BASIC can be used to just read the file and pass the parameter to the job/sequence as required. And if you are requested(If need to trigger only from command prompt after scheduling), you can call this Batch Job (Which has the BASIC code which calls the...

Try loading the database from command prompt with the file which is been exported by datastage using Load command. And check the time difference.

So as suggested, what is your network traffic?
Have you tried to ping with your server, are you able to get the responses less than 10ms (which is most likely the accecptable value).

What sort of parameters you like to pass? If you manage to key in the 'default' in the sequence, it should pass the value to the underlying jobs. So it should be ok to just call the job. If you need to pass some dynamic parameter which vary for each run, you need to store it ina seperate file and yo...

There is nothing more to explain. The pattern you mentioned wont be a Date formet. Hence if it is a char/varchar type you can just get the substring of the month poriton alone. There are many functions available. Or you can just use this method in Transformer. In the expression for that column, use ...

Hi, Search for this topic. You can get some nice code and informations like this. Job ran successfully and here is the new and improve script #!/bin/ksh ################################################################################ # Description : runs DataStage job THIS_SCRIPT="DoSomething.k...

DSguru2B wrote:I think if you are trimming your data in the transformer where you are matching the keys, then probably whats happening is that the composite keys are resulting to be duplicate.

If it is duplicated, the number of match should increse, but here its other case.

How about VarBinary or LongVarBinary ?

I guess the field should be char/varchar/integer.
Just grep the month from the field. Link.Filed[4,2] and check whether it is greated than MonthFromDate(CurrentDate())-36

Welcome Aboard :D
You need to furnish more information. Do you have a date column. Or what is the format of the column based on which you like to retrive.
Besides, you can use MonthFromDate function to retrive the current month.

Is the same two key marked in Sequential file.
Is that the matching between the two file is based on these composite keys?
As mentioned, are those keys which doesnt match, are without any extra leading/trailing spaces or special characters.

From your post, i guess your requirment would be to set a envirnment variable to particual job or to a series of job based on a conditon.
If that is a case, you can use 'UserVariableActivity'.
Built for the same reason.