DSXchange

felixyong wrote:DRS will need RDBMs client to work. What you can use by setting up the ODBC is to use the ODBC Enterprise Stage.

No, the DRS stage can be set to ODBC as well. But you are correct that in PX you should use the Enterprise stage instead.

It means the same thing in DataStage that it means outside of it. The Help for that option explains how to set it up, from what I recall.

Actually, techincally you can if you use a Server Shared Container, but it's not a very good idea.

I don't see how the 'script ran fine' with those error messages.

Can you post the contents of your 'breakout log' file?

Sorry, not really sure what you need help with or are looking for. Can you rephrase, please?

No such thing in a Sequence job, use an Execute Command stage to do that.

Was wondering. Sorry, you'll need to wait for others as I'm strictly a Server guy. Or start wading through those 523 other posts...

How to do what, search?

Below the Search Query box are radio buttons, the default is 'Exact Match' which means you are looking for that exact phrase. The last option, from what I recall, is 'Search for all terms'. Try that.

Hmm... I got 523 matches for "build px stage". Hint - don't use an 'Exact Match' (the default) for a phrase like that, try 'All words' instead.

And then there's your assumption that tini is in the USA... Well, yah... duh, isn't everyone? In my defense, I popped open my Windows Time Zone dialog on my PC and pulled down the entire list of time zones. There was only one labelled as Central, so thought the assumption was safe. Unfortunately, i...

edwds wrote:Reason I ask is why would this same sequence run fine later on and not give the error above.

It's a resource constraint and is all about what is running in total at the time the error occurs. That's why it 'runs fine later on' and why changing the parameter, as Ray notes, is needed.

And eschew 'messing around with' or 'playing around with' as performance improvement techniques.

You can also use uuencode for the attachment file and pipe the output to a mail function like mailx for example.

D'oh! If you were on UNIX, that is.

For Windows, I'd stick with blat.

Something like that I would simply Google for. GMT is 'Greenwich Mean Time' and is basically the zero point for all timezone offsets. 'Central' is defined as GMT-6 so you subtract six hours from GMT to get Central.

And then there's Daylight Saving Time...

What does your ".bad" file show? Anything?