DSXchange

Please re-post this in the correct forum - the Server forum - and then we'll be happy to get you an aswer to this.

Right, those two tag styles are equivalent.

Escape the quotes.

Explain to us what "supress the '00' or 'ZZ'" means. If you want the elements to be empty, you need the data values to be null.

Wrong forum.

Welcome aboard. I split your post out into its own post so you can control the destiny of your issue rather than piggy-backing on someone else's old topic... which is frowned upon.

That's what I thought, so we'll just lock this one and you can continue the discussion over there.

Or that.

How is this any different from your ongoing "Help regarding RANDOM data selecting" post?

Split from 'this older post' so you have control of your own destiny.

ps. Had to guess on the particulars, please correct if needed.

Oooo, oooo, I know! It's... wait, what? It's not?

Perhaps you can illustrate for us what exactly it is you mean by "shuffling the data" in this context rather than making us guess.

You should be able to help yourself on the second question by doing an exact search for nillable here. I posted the same question some time ago.

Sorry, didn't look close enough at your actual code. I don't think you actually have to convert the time at all, I meant just cat it on the end of the converted date.

The plus sign does math, the concatenation operator in DataStage is a colon. And yes, you'll need the space.