DSXchange

I have a source system that gives me a negative value like: 22122-

There is in DataStage, any function/format to convert this value in -22122?

Thanks in Advance,

NP

Try something like

Iconv(input,"ML0M")


I havent tested this, but if it isnt quite right, check ou the help on Iconv

-----Original Message-----
From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
Sent: Thursday, 23 August 2001 8:43 PM
To: LIST-DataStage (E-mail)
Subject: Format a negative number

I have a source system that gives me a negative value like: 22122-

There is in DataStage, any function/format to convert this value in -22122?

Thanks in Advance,

NP

Iconv(number, "MD0-") will do it.

The "MD" conversion (see BASIC Reference Guide) also handles other forms of negative number, such as appended "CR" or "DB", or notation.

-----Original Message-----
From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
Sent: Thursday, 23 August 2001 20:43
To: LIST-DataStage (E-mail)
Subject: Format a negative number


I have a source system that gives me a negative value like: 22122-

There is in DataStage, any function/format to convert this value in -22122?

Thanks in Advance,

NP