DSXchange

If you execute LIST.READU instead you can get more information. Each connected client has a type "RL" lock on an artificial record called !&DS.ADMIN_project&! and a type "RU" lock on a record whose name is made up of the Windows identifier of the client machine then the host name of that mac...

Don't rely on this into the future. There are substantial changes to the Repository in the next ("Hawk") release, scheduled for September 2005.

A typo, thanks for catching it. I have edited the original code so that LineCount is correctly initialized to 0. (I was doing it in a noisy airport lounge!)

Think about how you would do it in a query. You'd almost certainly need a temporary table (virtual or physical) in which to store the keys and associated sums, so that you could join this with the original result set. Well, no surprise, the processing isn't really any different in DataStage; you jus...

Given that the helper subroutine was DSR_SELECT, check also that the indexing in the Repository is completely up to date. At a time when you have exclusive access to the project, execute DS.REINDEX ALL (from a dssh environment on the server or through the Administrator client Command window).

DataStage's engineers' philosophy is to log every warning generated by anything anywhere, the argument being that if it was important enough to generate it's important enough to log. DataStage, therefore, has no mechanism for ignoring specific warnings (or even informational messages, like Informix'...

Can you start a new thread for ODBC connectivity to Sybase? No-one would expect to find it under topic "connecting to DataStage server failed".

365.25 or 365.249 as the divisor might get even closer (allows for leap years).

Your posts count and points are to the left of every post you've made.

Provided everything is restored to exactly the same location (including hidden files) it should work OK.

Don't know if you can do this in Sybase.

In DataStage you will need to select the contents of the VarChar column, load this into a job parameter, and use a reference to that parameter in the WHERE clause in a controlled job.

You seem to have three threads going on this problem. My bet is that your "migration" was performed with UNIX utilities, and therefore that there is a lot of repair needed. See other thread for details that are as complete as I can manage out of my head.

You could try the find command (with exec of rm ) through remote shell. Your UNIX administrator will have a heart attack when you ask for authority to do this, but you merely need to convince her or him that your UNIX skills are sufficiently up to scratch! It may be better to create such a shell scr...

If you can't find .dshome in the root directory, your installation is incomplete and you will probably need to reinstall the server. Use ls -al /.dshome to determine whether you really can not find this file. If you believe that the installation is successful otherwise, you could try to create /.dsh...

Stage variables svRecType init @NULL derivation Left(InLink.Column, 1) svTest init 0 derivation If (svRecType = "X") And (@INROWNUM > 1) Then (svYCount = 0) Or (svZCount = 0) Else @FALSE svYCount init 0 derivation If svRecType = "X" Then 0 Else svYCount + 1 svZCount init 0 derivation If svRecType = ...