DSXchange

That's not how one uses variables like that in DOS. For now just do this:

C:\Ascential\DataStage\Engine\bin\dsjob -run (etc etc)

I meant next time as I'd already done the dirty work for you here. Ah well, that works too. If people want to help, please respond there not here.

Thanks.

Join the two, sort the result by the amount descending and constrain the output to the first five records. Note you'll need to run sequentially or on one node for this to work properly.

No. UNIX uses a LF for a record delimiter while DOS uses a CR/LF pair. To implement a DOS newline, use the Record delimiter string property set to ″\R\N″ or chooseFormat as → DOS line terminator from the shortcut menu. This is straight from the docs.

So, actually a QualityStage question? Just trying to determine what the proper forum is to move this to...

Use a Record Delimiter String as that DOS 'newline' is actually two characters.

[split from this topic] First let's start by not hijacking someone else's old post and start your own. Post a link to the other post if you think it will really be helpful, but we need your particulars - version, O/S, etc - and an example of your issue/question in order to help you. Also, that way y...

Sorry, but what were you trying to accomplish here? Other than make my eyes bleed. I don't see anything other than a quote of the original post...

Set $APT_ORACLE_PRESERVE_BLANKS to true to override that default sqlldr behaviour.

As long as 'some piece' means 'the whole statement' then yes, you should be able to do that. The mechanism is documented, from what I recall off the top of my head there's either a specific "SQL File" option or you use custom sql with a {FILE} or [FILE] prefix before the pathname.

Please don't hijack old posts, when you have a problem no matter how "similar" it may be to something you've found, start your own post. Then you have control over its fate.

Also, please edit your post and add the required information we're missing - O/S, version, etc.

Whitespace (i.e. formatting) is preserved only in 'code', otherwise the forum software removes all those silly extra, unneeded spaces it thinks you accidentally put in.

Yup, don't think anyone but Mr Enthusiasm could have figured that one out.

(I kid, I kid, put away the torches)

So... do you have a problem compiling any job with a Transformer, or just this particular one?

That or fix your PATH environment variable to now include the new path to the Datastage bin directory.