DSXchange

Yes, deleting the job deletes everything associated with them, including the logs.

Gack... I SO do not have time for this, trying to get out the door and to *my* job. Like a moth to a flame... still... quickly... untested!

Field(Field(DSLink5.Col_D,'&',2,1),"=",2,1) should get you ZZ

Etc.

Shah_h wrote:the problem is we are using DataStage 7.5 which does not have a BASIC transformer

It does.

YES. It's just that you'll need two calls for each - first one as I noted then embed / inline another and tell it the result is "equal sign" delimited and take the second field.

Care to post it? Would help future searchers with the same question.

Column names do not support spaces. What the heck 8.x release are you on? What fixpacks are installed? You shouldn't have to be going through any kind of Index shenanigans like that. :? [shudder] I'm assuming your Col_D value actually is what you've said it is, quote as data and all. One example fro...

I have no clue... an article of clothing? Quick check found this...

http://www.thesarkcollection.co.uk/

Clothing, at least.

Wow.. epic funny FAIL.

1) Seems to me you just include all ten and sometimes (as needed) leave any of the last four empty.

No worries, that's why we're here.

Oh, and - When a thread is resolved to your satisfaction, we ask people to mark it as Resolved using the big button at the top of the screen so people know. Thanks!

That looks fine, as long as you remove the "(concat)" part as the semi-colon is the concatenation operator: if itm_cd < 1000 then '0' : itm_cd else itm_cd You said something about needing to trim it and oddly enough there's a trim function! :wink: if itm_cd < 1000 then '0' : trim(itm_cd) e...

Welcome! Let's start with what you've tried so far and we'll go from there. One thing... please clarify what "add zero" means - append a "0"?

Examples are always a good idea, too. And they are "stage variables" (two words) by the way.

Yup, that or get one installed... it's rather painless and well worth the effort! IMHO, of course.

No worries but it's not. That's a question for IBM. Or maybe Vincent.