DSXchange

harikhk wrote:PAD_CHAR helps for right padding. I am looking for a left padding option

I was specifically responding to a scenario where the field was only populated with pad characters - your NULL string. In that case left vs. right makes no difference.

you would not want to find out after a physical failure that all such LPARs were running on the same physical unit. That never happens. :wink: We recently found out that our wonderful hardware partner has almost all of our virtual servers - dev, test *and* production - on a single physical server. ...

An actual NULL field would be just two quotes with nothing between them. If you want a string of equivalent size filled with spaces for your fixed-width file, there is a Spaces() function from what I recall so Spaces(6) would work for your example. Or a CHAR field with the PAD_CHAR set to 0x20 shoul...

The performance of B has already been answered, did you click on the link in my earlier reply?

Was wondering if being an Integer made a difference. Could you make it a decimal with a scale of zero? But then you'll also get a space reserved for the sign, from what I recall, maybe even one of them pesky decimal points.

New thread? No. I would prefer this goes back to the original thread where your data examples and requirements are...

B is more efficient. This should only be an issue with string fields, for numeric values the 'padding' with zeroes should be happening automatically. Are you not seeing that?

Then you need to explain in gory detail with examples what exactly that means. Your exact syntax, what you get, what you want to get, etc. I'm sure the expression itself is working fine, I'm assuming it is just not working as you'd like it in the grand scheme of things. We should probably be having ...

Why not sort the data appropriately?

However, that wouldn't stop your if-then-else derivation from 'working'.

Let's get you off into the proper forum for this... here we are.

When you say "use" you actually mean "deploy", yes?

Not a DataStage change at this point, he is asking about the characterset your PC is set to. What Windows version are you running? From what I recall, different versions hide that NLS_LANG setting in different places...

ps. Use code tags for your job designs, not quote tags. Code preserves whitespace and keeps everything lined up, everything else removes 'extra' whitespace and all text gets trimmed and left justified.

I fixed your example for you.

First question in this situation is always have you done anything to 'size' the hashed file properly for that volume - meaning not left it with the default Minimum Modulus value of 1? You should have something called the Hashed File Calculator that Ray wrote somewhere in an 'Unsupported' directory w...

As noted, sounds like you are getting bad date values. You might want to use an IsValid check before you do the conversion and only convert good dates.

Funny, saying "bad dates" always makes me think of Indiana Jones and that poor monkey. Ok, maybe not all that funny.

Trick question?

Sure look to be some, they are the issue with their relative paths it would seem.