DSXchange

Can you be more specific as to the nature of the "problems with the filesystem" that you had and how you fixed it?

Could be many reasons.

So... is it returning records very slowly or no rows were returned for a 'long period of time' and then they all flew out? Something else?

The "interim status" is only applicable after job and will show you the status of the main job (and thus the ending status) provided nothing goes wrong 'after job'.

Well... how many nodes did the job run on?

Perhaps APT_PM_PLAYER_TIMING set to True?

What makes you think it supports Oracle syntax? Why don't you spell out in words what it is you are trying to implement?

Then you're not really looking. Here's the first hit from a Google search, lays it all out:

http://www.tek-tips.com/viewthread.cfm? ... 140&page=1

Regardless, build a generic rather than a specific solution. For example, I have a script in my toolkit that will run anything from sqplus and tell me if there were any issues with it. Granted, it can't tell me if an update actually changed any rows or a delete actually removed anything, that's an e...

The only category option is via the GUI, not the command line.

*I* know but there are several solutions for this and you need to learn how to find your own answers, especially when they are easily found with two minutes effort. Teach a man to fish and all that.

Stupid.

Then do something equivalent in a routine.

I would build the lookup using truncated values since all that matters is the hour value. Then no 'range' lookup would be required.

dspradeep wrote:I think you are right srini. I try to load both file into another sequential file using file pattern which is loaded the data perfectly. so we can't view the data using file pattern in sequential file stage.

As already noted, this is completely incorrect. You can.

Post your stage settings. Have you manually added any OPTIONS for the load?

Technically, you can issue the command from anywhere but probably easiest from $DSHOME/bin for you. And make sure you put a "./" in front of the command.