DSXchange

Put them on one line and separate by semicolon.

Suresh - could you post your exact error message, there are many possible causes for failure.

That is not the correct way to do this, even though it is allowed. There is a modify stage which is designed to do conversions such as this.

shyamrai wrote:...it gave a return as "''D:Ascential\DataStage\Engine\bin'...

You are missing a "" in the 3rd position

Could it be that the parameters aren't being passed the way you expect when you call the script from DS instead of running it manually? Try hardcoding everything so that the script doesn't use parameters, or perhaps you could echo your parameters in the script to see if that is where your problem li...

What is the data type you used and how did you try to hardcode the date?

Suri, welcome to DSXchange.
The first thing to do is to read this FAQ, and then use the "Search" button in the menu above and look for creating 64 bit files.

hint: The command in DS is "RESIZE {filename} * * * 64BIT" assuming a local hashed file.

This is a completely new topic, please post it into a new thread with an appropriate subject line.

What datatypes are EMPNO_SRC and ENAME_SRC (both your actual database definition and that which you are using in your job)?

This complex logic is too much for me. Could you please explain the rules in text as well?

What type of load are you doing to Oracle? Automatic or user defined?

That would only work for objects called "sharedcont". Shared containers are actually in the class 24 so the original SQL wouldn't find them.

The BASIC Programmer's Guide documents the syntax for the DSSetUserStatus() function call, and you can query the value with the DSGetJobInfo() function.

The after job subroutine does not have a separate status, it's return status sets that of the job. If you need to use the return value of the script from the after job subroutine you could look into setting the user status.

Aakash - I am sure about the 000 and 255 Put a test transform stage in the job with the constraint of CONVERT(CHAR(000):@FM,'??',In.ColumnName)=In.ColumnName . If you have 000 or Field Marks in the key column then the number of input rows will be greater than the number of output row...