DSXchange

i have given decimaltodecimal(field) and give metada as 10,2

But it is giving sama like 100

i need 100.00

i dont need to it to be in decimal format can be any, so anybody give me suggestions

Use a Remove Duplicate Stage, Set col1 as key and Duplicate To Retain option to First...


It will 100% work ....

Hi All

I am new to datastage!!!

I want to know How to remove/move/truncate the Dataset ?

And How to see the descriptor file for a perticular dataset ?

Hi All

I have a job like below

Dataset---->Transformer---->DB2

When i run the job it's got aborted after 500 rows .(total rows were 2000)

Is it possible to start from 501 row??

Hi All

I have a job sequencer
In that i have 10 job activities
when i tried to run the sequencer it's got aborted after 5th job completion

So now i want to run the sequencer from 6th onwards ?? ( without running first 5 jobs)

Please help me to do this ?

Hi All
I am new to datastage? I would like to know that How to use Modify stage?
Diff between transformer and Modify ? And the syntax of Modify stage ?

Thanks for your reply Chulett, I am opening it in the notepad and Editplus that is the reason it is showing me improper format. unknowingly i have opened it in Internet Explorer, it has shown in proper way even i checked Generate output format option. I checked it by unselecting this option as per y...

Hi I am generating output in XML file. I have created the job and working fine. But there is a format issue. in XML data is coming like <field> value </field> I need the format like <field>value</field>. I am using XML Output stage in the middle and using sequential stage to load in to file but it i...

I have done this using decimal_from_decimal [round_inf]() in modify stage. But the result is same as earlier.

Can anyone tell how to do this?

Do we have any other way to resolve the warning Actual warning: Import consumed only 39bytes of the record's 40 bytes (no further warnings will be generated from this partition) input file is CFF file and CR/LR format. I am not sure whether we can use this routine in this situation. If yes, what wou...

Thanks Ray, I did in modify stage as below I am using below syntax in modify stage to keep 2 decimal places as scale. Even it is 00 it should as 00.00 I used syntax as: Total_Record_Count = DecimalToDecimal(Total_Record_Count,"round_inf") I am getting error like: Error parsing modify adapt...

Or use pxEreplace() function, documented on DSXchange. Hi ray, I tried searching in this forum for this routine. I could not find it. Can you please tell me where it is? As i am getting warning messages while reading files with CR/LF format(Cobol files) Warning message is like we are reading the le...

Hi

How do we know Error Message ID to handle Message such as Suppress from log.

I tried in Message Handler in Designer, but i was asked to give Message iD.

I have changed it in Transformer and not its fine. But i am facing one more issue that After Aggregation i used modify stage to convert double to decimal using default like Column_Name=Column_Name. It is giving the proper result, but its not adding zeros after decimal point if the data is rounded eg...

I used modify stage before aggregating the data.