DSXchange

So what is the problem?

If you mean to say that, it does not run while scheduled, and runs ok when triggered manually, then check the paramter value that been passed when it is scheduled.
You can find the reset button in DS Director, next to run and Stop button. Looks like rewind button.

Check the date format that you have entred. "CCYY-MM-DD"
Instead you can convert to julian date, which also gives you integer as output.

If both the fields are defined as varchar, the whitespace are automatically striped off. You can then get the join.

Decimal datatype has maximum of 38,10. Try using double if required.

Do you get any other messaage related to Section Leader or node player?
What is the volume of the data?

Welcome to Dsxchange!!! :D What is your job design? When your job run sucessfully? This might be due to a reason, that the disk space available for the Hash file creation will be full. When it failed, Reset the job, you will find "From Previous run..." event. Check for it. You may get more detials.

Welcome to Dsxchange!!! :D
Check whether the table has the load previlage for that user. Also try to load from command prompt and check the state of the table. So that you can handle it in database prespective.

Flat file cannot change Null into a space " ", unless a conversion is used or an internal property is assigned.

Avoide column name as Keyword. Is tehere a way you can create a view for that table with different column name.
Pls post the exact message you get when you handle this.

It should behave the same unless you the required variables are set to diffrent values.
Try to print the value of the variable and also check the actual row count for that run.

You job might have serveral stages, and each stage will require its own memory for proper function. Each stage can be represented as one or many operators. And there will be one player per stage per job for each node you have in your config file for that particular run. Hence thourgh the variable, t...

Can you delete the other duplicate post.

You can use Trim function in Transformer, but you can directly map Integer column into varchar via transformer. DataStage will do the implicit conversion for you.

What is the exact error message? Check for nullability in the target table as well as the Load stage. By the way, why do you need to check for Null if you need to load Null based on the availablility of null in input?