DSXchange

I could see its been taken care. But in my PC the Date variable is not been set with the value and hence the subdirectory was not created. When I change the delimiter from '/' to '.', FOR /f "tokens=2-4 delims=. " %%a in ('DATE/T') do SET DsxDate=%%c%%a%%b it creates the directory but, giving out so...

Kim, If I wish to hardcode all the parameter values, is there any simple way to backup the projects in different versions with out overriding.
May be each folder for each schedule or something.

Not routines alone. And not using DSExport.exe but using dscmdexport.exe for the project as a whole.

Now in DataQuality!!! They have become real challenge to Webmaster, aren't they?

You can build the generated SQL by given two tables sperated by comma. And the join condition in the Where clause.
Else give the lookup condition as
in and clause.
Where the :1 represents the key from Master table if the key column is in first place.

You are not liking the Main stream lookup key to reference stream lookup field. Other than constraints, have you liked up the keys in Key Expression of the Lookup stream?
Use Column-Generated query in reference table.

Is there any way to validate Datastage License if that been entered during process of registration. That will allow only those who have access to Datastage.

Cant you browse to the path and select the dataset?

What is the data type?
You are trying to insert data "BADDER" to Long type of field..

Do you mean "INCLUDE DSINCLUDE JOBCONTROL.H"?
Abort the sequence, you get "From Previous run log" information.

Try by inserting a sort stage before Change capture and sorting the key.
Btw; You should be haveing the option to have you Custome code in Change capture stage itself.

Its all real worthy wishes. Its good if we able to edit/set the value of JobProperty within the job. And you expecting, View data to be a simple Text editor rather a data viewer. Yes defaults for Char data tyeps, pains. I go for Varchar just for this reason. 12. What you expect for non matched recor...

Kim, all these will give the list of jobs and stages based on jobs and vise versa. But OP is looking fetch the Stages or Jobs based on the Table that been used, isn't?

You can alternatively use DB2 stage to call SP. You can mark the topic as you found a workaround.

Is LANGU marked as Key? Is it available in both the stream? What is the job design?