DSXchange

Welcome.

I'm not sure why you'd have NLS issues like that during install... if no-one else chimes in here with specifics I'd make sure you contact your official support provider to get some help with this error.

That's been discussed here quite a bit already so I'm not going to repeat it all. First suggestion would be to do an exact search here for "ETLStats" as it always comes up when someone asks this question. Secondly, you don't have to use a script to do what you are needing to do although yo...

I tend to shy away from date specific solutions like that as you have no ability to 'catch up' if for whatever reason you miss a day or files arrive late with a different date on them. Better to have a mechanism to take whatever is there regardless of date and then ensure they are archived / moved /...

Not sure how anyone can help, you know what you need to do. As noted, either restore it from backup or pull the file out of your anti-virus quarantine. If you need to, contact the AV maker for help with that. Note that you don't necessarily need to stop running AV all together, most support an exclu...

I have the power now so off we go!

In case anyone else has the same issue and comes looking for an answer it should be a little easier to find in the correct forum.

So this happens with any user-defined SQL? Can you give us an example of one that generates this warning?

... and a Server job would probably be faster because there isn't all of the startup / overhead that the parallel framework carries with it.

Sorry, but it is abbreviated as the WFF stage, the WTF stage would be something else entirely. :wink: And you're correct in tha the WFF stage does not support wildcards, as has been discussed here a number of times. You are better off writing a script or routine to ensure that "all files" ...

Or a Sever Shared Container with the Folder stage in your Parallel jobs. And I sincerely doubt you really need a PX job just to dump Oracle data to files.

Sourcing a file is a pretty common term & technique in the UNIX world.

Just wanted to double-check before I moved it. Most 'Server' posts are marked with the wrong job type nowadays. :wink: I'm curious where you found reference to LOB handling in the 7.x documentation, can you post the text here? I've got some 7.x pdf manuals at home and haven't found any such thing ye...

Welcome.

Can you please confirm for us that you are indeed talking about having this issue with Server jobs? Something else to note - they added support for LOBs somewhere in the 8.x release, something which was never officially supported in 7.x from what I recall...

Don't see anything obviously wrong... what exact 8.x release is this?

You need to "source" your dsenv file first to setup the environment properly:

pii@ptseelm-ax4008:/opt/IBM/InfoSphere/InformationServer/Server/DSEngine: . ./dsenv
pii@ptseelm-ax4008:/opt/IBM/InfoSphere/InformationServer/Server/DSEngine: ./bin/uvsh

Meaning, can you tell us what date "1070831" should be converted to?