DSXchange

All I get is blanks when I use StringToDecimal. It was the first thing I tried.

What I meant was, I did something similar and it worked when I used to DecimalToDecimal. Would appreciate any help. Thanks.

I tried that. It doesn't work. I have a previous situation where DecimalToDecimal made it work. Without DecimalToDecimal, I get all blanks. By the way, my incoming columns are CHAR data types.

I am trying to do a decimal calculation and write to a decimal and/or char column (I have tried both types). I get a value of all 0s. My incoming column values are IncomingCol1 =1 and IncomingCol2=1000. I have tried with other values as well such as 2,7 and 12. I still get all 0s. I also tried: Deci...

Let's say I have 100+ columns in a sequential file and I want to view just 2 columns every time. Instead of displaying and scrolling through all columns, is there a way to set a default of the columns I want to see?

Thanks.

I need all digits after the decimal. With "trunc_zero", it seems like it discards stuff after the decimal.

According to the Help, StringToDecimal has the following options with "trunc_zero" being the default: ceil, floor, round_inf and trunc_zero For all of these options, the decimal part is cut off, according to the Help. I am pasting the entire text here. How can this be true? Thanks. -------...

I would like to convert a char number such as:

12345 to 123.45

I know I can do it using Left and Right functions but I was wondering if there is a better solution.

Thanks.

balajisr, your solution worked. However, can you tell me why:

StringToDate(IncomingCol, "%yyyy-%mm-%dd")

returns all *

My incoming column has data such as "19950301" and it is char(10). I am trying to do: StringToDate(IncomingCol, "%yyyy-%mm-%dd") (this by ltself returns all *) and then I am trying to do: Isvalid("date",StringToDate(IncomingCol, "%yyyy-%mm-%dd")) I also tried:...

NowStr = TimeDate() ;* e.g. "09:59:51 03 JUN 1997"
NowDateStr = Field(NowStr, " ", 2, 3)

This returns: 03 JUN 1997

Can anyone explain why this is being returned? I would think that

Field(NowStr, " ", 1, 3)

should return 03 JUN 1997

Kim, can you explain little bit as to what you have in DataStageBackup.bat? Also, what do you have in the Datastage wrapper script? Thanks.

Can anyone share their experiences with Datastage 8.0 installation, developement and use of the QualityStage stages? I searched through the posts in this forum. I found that Raftsman had problems. I am seeing a lot of posts from people using 8.0 so I think Raftsman's situation is rare. Please share ...

Raftsman, can you tell me if you resolved your issues? If you did, what steps you took? We are thinking of migrating as well but this post is scaring me.

Thanks.

It seems to have more options to do things. Also, there is a way around this last character cutoff. There are certain drivers that you need to install (IBM has them) or you can add a space and increase output column length by 1 in a transformer right before writing to the table.