DSXchange

So... first check - have you verified that the file does in fact exist with that exact name and you're looking for it in the proper location?

What do you actually need to do with the timezone information? Convert it to a "standard" timezone? Ignore it? For the latter, you could use the Field function to get just the parts that you want. For example: Field("Thu Jan 21 14:20:00 EST 2008"," ",2,3) Gets the three...

I'm not sure, not being all that familiar with everything that's involved in getting buildops to work. If you'd like, you can post the PATH change that you made and we can see if that part looks ok. Otherwise, I'd have to defer to others who have actually done this in the past. Out of curiousity, is...

Me, I would first try reinstalling your client.

I don't believe it is specifically supported yet but I don't know why it wouldn't be "compatible". Have you tried accessing it yet and had issues or are you simply asking at this point?

Well, one has a lot more overhead than the other if literally all you're doing is staging the data.

Wrong path - it says it is a PATH search failure and that is literally the name of the environment variable that you need to update, not LD_LIBRARY_PATH.

Ah, sorry to keep cluttering up a perfectly good thread but my first hit was for something called "Behind the Fridge" in Australia, so made the leap.

Must be an Australian thing... [google,google]... ah yes, it is.

I'd probably worry about that if leaving it blank meant the job still ran without errors but did not produce the correct output. Since it blows up when left empty, seems to me you're already good to go.

DataStage is 32bit so I would assume you'd need to use 32bit NZ drivers with it.

Then the same answer given here applies to you as well... as does the one you got in your own thread. If you still need help, please make sure and continue the conversation in the thread you started rather than here.

Thanks.

Though I'm not sure we have any examples in our repository. I wasn't here when the server was set up but I'm told there were many things that weren't installed, including sample code. Understand that I wasn't referring to specific "sample code" being provided but rather the core set of Se...

Before you ask, I don't know anything about Netezza but for your question about restarting DataStage for ODBC changes, the answer is 'no' - that's not necessary.

OK... double-click on it to see the details and then post them here.