DSXchange

If <Not(IsNull(Trim(filed name)))> is not working, then it is probably because you have empty strings rather than NULLs.

Try Trim(filed name) <> "" and see if that works.

Just thought I'd share an upgrade experience. We have recently upgraded from 7.5 to 7.5.1A. Contrary to voluminous advice in this forum (and much to my chagrin) we have been using Fully Generated SQL in our ORAOCI source stages (long story, but another day...). We upgraded, started building/updating...

You don't even have to monitor the email. Talk to your Unix sysadmin about setting up a mail alias that passes incoming email to a shell script rather than a mail box.

The shell script strips off the email header, finds the job name in the email body, and executes dsjob.

Just to make sure, you did check the KEY attribute on each output link matched the input link, didn't you (sorry - just me being pedantic). Just to be doubly sure, use right-click / propogate columns / {input link} / All links (if avail. in your version). Also, make sure that the Derivation is popul...

Make sure that the key columns in all of the Output links of the Link Partitioner match those of the Input columns. Do the same for the Link Collector.

This has caused me grief in the past by producing unpredictable results.

Tell us if it works.

I don't think it's a good idea in your case, but with Oracle 10g you can perform point-in-time SELECTs (I think they are called FLASHBACK). They rely on the Archive/Redo log functionality in Oracle that supports backups.

Or, you could write all of your results to files and then load them afterwards.

I converted the Shared Container to Local and was able to change the value to 250. I converted it back to shared and it was stuck on 250 - I couldn't change it to any other value!!! It seems that the Rows Per Transaction attribute (unlike all of the other OCI attributes) is bound to the container ou...

I have a shared container with two outputs. In one job that uses the shared container, one of the outputs goes straight to an OCI stage. The OCI is set to " Insert Rows Without Clearing ", array size =250, rows per transaction =0. I want it to commit regularly, so I change the Rows Per Tra...

In a recent thread http://www.dsxchange.com/viewtopic.php?t=96063 , Nag teased us with a primer on using the Normalizer options in a Hashed File stage. Intrigued, I took a look at the online help and the DS Server Job Developer manual. The information there amounted to "yes, you can normalize&q...

Beeram, I think you will have to do it with a Unix command. You can call the Unix command from a before-job-subroutine, or from a Shell Exec activity that precedes the Job Activity in a Job Sequence. Two options for the Unix command are: 1. Find the lastest file and move it to a static file name. 2....

To be thorough, it could be done with a SQL like:
But the advice above is the right way, so do that.

I wouldn't be so quick to dismiss this one, it's actually an interesting question. What Mahi is trying to do is (in database terms) a CROSS JOIN, or cartesian join. There's a little more to it than that, since he wants the ability to filter out some of the result rows, but worst case scenario would ...

Are you certain you set the output type to Binary?

Also, make sure you summarise everything you have already tried when you post a question. That way we don't waste our time and you don't have to go through the same solutions one-by-one again.

In the online help, search on OCONV . Go to the Conversion Codes link and look at the MP conversion code. It could be as simple as Oconv(LK_in.my_integer, "MP") You would probably need to set the output type to binary with a length of the number of bytes required. In case you hadn't guesse...

If you're still having problems, could you post the error message into your next reply. Try connecting to the userid/password using a SQL client like TOAD or SQL*Plus and issue the command: INSERT INTO table_name SELECT * FROM table_name WHERE 1=0; One of three things will (ok, should) happen: - ORA...