DSXchange

Does it help if you fully qualify the server name?

Time to mark the post as Resolved using the big button at the top of the page!

Neither SHLIB_PATH nor LD_LIBRARY_PATH should be set to a "bin" directory, but rather need to be set to a "lib" directory. And you set one or the other, depending on your O/S, never both. HP/UX uses the former from what I recall, but it can depend on the chipset I believe. Been a...

I am eager to know the type of SQL operation performed by "Clear table and insert rows". :? I assume the action "Replace existing rows completely" satisfies your requirement.It is written that Before SQL commit or rollback is performed on per-link basis. Sorry, but wrong on both...

swerajan wrote:My question is how the statement above behave? will it delete the table and only then load the current day's data?

Yes.

And? Details, man, details. Are you purposefully trying to make it as hard as possible for anyone to help you?

Right, the 'Concurrent' part is a big clue and the long descriptions of each explain the difference between the two.

Look for a file called dsapi.h in (from what I recall) your DSEngine/include folder, it will list all exit / status codes for a job, amongst other things.

Right, using that routine won't somehow make your jobs run forever.

And if you search for that phrase here, you'll find quite a number of conversations on the topic.

There's been no mention of selecting being done yet, or anything re: every time, just a question regarding refreshing a MV probably as a standalone activity.

You can't be having "the same problem". Please start your own post with the relevant details of your issue.

The environment isn't correctly setup. You should be executing a script that first sources from dsenv to setup the environment and then executes dsjob.

It's not about selecting from it, it's about issuing the command to refresh / rebuild it. And thanks to the OP for editing your first post and making my initial responses look much less valid. You really should have just replied with that additional information. What you posted as the syntax the DBA...

It ships with NullToZero and NullToEmpty but many people (myself included) have rolled their own NullToValue transform to emulate the NVL functionality of Oracle.