DSXchange

What are you talking about?

The unix sort command? The plugin? Are you attempting to use "sort" on a file and want to use a field that contains a "date" as a key?

Please be more specific.

The main benefit of this routine was to address directly a table in Oracle 9 and extract the data returned by a SELECT statement, for further usage in a Basic program. The same effect can be achieved thru a system command call to sqlplus. It's a whole lot cleaner, uses Oracles client software to ma...

Create an output link to a sequential text file. In the constraint, put the check that determines if the fatal condition is met. Set the Abort After Rows value on that link to 1. The first row to meet the fatal condition will go down that link, causing the job to abort.

Only thru an after-routine/job call to edit the control file programmatically. You're better off spooling to a sequential file and loading thru a hand-written ctl file anyway.

You need to look at the explain plan. If it's a full table scan of a partitioned table and you're not supplying the partitioning key with a parallel query, then you are in the worst situation possible on the database side. Start with the database and have a DBA look at the activity.

First of all, is this a new installation?

Second, what do you mean by recover? What did you do?

Just use DSLogFatal to abort a job by writing a RED message to the job log. That will leave the job in an unusable state, just the same as if another job issued the STOP call.

If you have a directory structure:



You can make a symbolic link represent the directory:



If you do a

you actually see the same results as doing


You can change symbolic links on demand.

The error message exactly states the problem. The stage is deficient in that you cannot use parameters in the path to the command (kind of irritating, do you agree?). The only solution for you is either environment variables or symbolic links. We've been asking for years to allow this functionality,...

What about giving the users the director priviledge but do not say the important user/pass info (apart from those required to login to DS Server). No, the server login is the DataStage user login. There are no abilities within DataStage to do what was asked. You can setup programmatic solutions tha...

No.

I will implement this. Do i have to check on Allow multiple instance? How do you I give a name to an instance Concatenating the sequential files after using the MOD function, will that not disturb the original sequence? Or does that not matter? I have never done this before, can you please tell in ...

In the source query, add a where clause to divide the source data into even pieces. I like using the MOD function. Add 2 job parameters, PartitionCount and PartitionNumber. Put #PartitionNumber# into the output sequential file name. select col1, col2, col3, col4 from your_table where mod(colx, P...

ArndW wrote:Ken,

sweet :D Short, simple and to the point. I bet you have some Prussian ancestors...

My ancestral family names are Jung, Leviso, Schuh, and Krause, immigrants from Germany and Norway in the late 1800's.

All I am doing is selecting all rows from a table in one Schema and inserting it into another table in a different schema "Update action being -Truncate table then insert rows" If this is on the same intance, why not use an efficient script that can utilize parallel query and parallel dml and sqlld...