DSXchange

Come now.

First off, a stage variable seems overkill for something as simple as this. All you need to do is check @OUTROWNUM to see if it is one or greater than one and set the value in the derivation of the column accordingly.

Are you saying you can't work out the "If Then Else" syntax?

Sunshine - That should have worked - provided you did not include SURR_KEY in the Column list in the stage. When you have 8 parameter markers in the query, you must have 8 columns defined in the stage as well, no more no less.

You join two database tables - if they are in the same database - in the database. Any other combination either involves hashed files or getting them together in the same database. This choice could also depend on the structures involved - do they lend themselves to direct joining or does the data n...

Ok, nevermind... I am an idiot. This is what happens when you change a script on one server and then don't see any changes when you execute it in a job on a completely different server. Jeez.

I need to get more sleep. And a day off.

Right now, when I run UNIX shell scripts via the DSExecute function and capture the 'System Return Code' I only seem to get back two values: either a zero for a successful completion or a 255 when the script passes back an error status. No matter what I pass back as the exit status of the script (ot...

Sometimes it doesn't matter what the database expects, it's all about what the DataStage stage for that database expects.

You should have removed the second post then.

Only you can do that. However, now that there is a reply after it (yours!) that option is no longer possible. Something to remember for the future.

i have tried this code but error messages is comminhg like can not covert string 00.00.00.000000 into timestamp More than likely, that's an entirely different problem. You asked how to take one date format and change it into another, which was answered. Naveen and my answers are virtualy identical ...

It's a simple matter of pairing up Iconv and Oconv. Use Iconv to first take your date from its current format to 'internal' format and then use Oconv to produce the output or 'external' format that you need from that. The time portion would be simply appended to the result. Try something like: Oconv...

Sure. The actual running of a job is completely separate from any client connect that may have kicked it off. Besides, once you schedule the job via the Director, the actual starting of the job has been handed off to the underlying O/S mechanism - 'at' on Windows or cron / at on a UNIX server. You c...

You've also got access to all the vendor supplied routines via the Manager. Open up the 'Routines' branch by clicking on the plus sign next to it and then double-click on any of the routines there. They are typically well documented in their Long Description and the BASIC source code is available fo...

If you have defined it as a Timestamp in the OCI stage then you've already got the data in the right format for that. Verify that by checking the generated SQL and the TO_DATE conversion mask.

Search. The. Forum.

As noted - you can't, and that's pretty obvious from the error message. So... do you have both a 7.5 and a 7.5.1A server installed somewhere? If so, and you need access to both, you will need to do as Arnd noted: 1) Install the 7.5.1A client in a different location from the 7.5 client 2) Install the...

Have you... tried it? What happens when you do?