DSXchange

Hi All, I have a requirement where in I need to set the format for all the values in a column to the following.. Input : 1 1.95 1.2 Output: $1.00 $1.95 $1.2 Append with a $ symbol in the start and append decimal with two zeros I looked for FMT function which is available in Sequence User Variable st...

In our DEV environment the Assembly Editor fails to open from the XML Stage - no error just never responds. This occurs across multiple Datastage projects in DEV. It happens on different client machines. In our SIT environment we do not have the same issue. Wondering if anyone has had a similar expe...

Hi All, We have encountered an issue with one of our Data Stage jobs in our Production environment... The job does a looping in the transformer by comparing the date values between Start and End.... Ideally the start date should always be less than end date.. We have identified few instances in the ...

Hi All,

Can some one please let me know if we have a XSD file for a DataStage export in XML format.

Regards
Coles

Hi All, I am using surrogate key Generator in Transformer defined in a test file.. Can someone let me know if there is an option to set the max value.. Once the max value is reached I need to reset the file. I don't see an option to pre-set the max value in properties tab of Surrogate key in Transfo...

Hi All, We have a Datastage job sequence which is scheduled to run every hour through Control-M. The job is running successfully without any issues but the sequence throws a warning message Job EX12_OPTED_OUT_SEQ must be reset before it can run. The warning happens to be occurring very random. I do ...