DSXchange

I think you will have to separate out the lookups into distinct stages in order to locate it.

I just did a quickie test with 100 job activities and that worked.

The same number as in Server. I would guess that at least 128 or 256 could be called, if there is a limit at all.

What did you specify as your pad character. If a trim() function doesn't remove spaces from a VarChar() then you can be 100% certain that you don't have spaces in your string but some other character.

add a ";" to the command.

A DataSet isn't a single UNIX object, it is a descriptor that points to data files and those can't be compressed automagically. So compressing the descriptor file doesn't do anything at all. The columns could be compressed, but the gain of compressing a string of 100 is going to be much less than co...

The command line "dsjob -logdetail" provides output (which you can redirect to a text file) with all the information you require and is much easier than writing DataStage BASIC programs to use the builtin routines. If you code this yourself, the main routines that you will use and can read about in ...

It should be self-cleaning. Are the files that are left over from runs that aborted?

Yes, that is correct. If you do find a free ODBC application that will do this, please post that information to this thread as I am sure that many (including myself) would be interested.

A lookup filesets can only be used for lookups, you can never "read" or even view the data from this stage type. Your initial post seemed to indicate that you wanted to use this stage for more than mere lookups.
And yes, you can use a lookup file set as a lookup on a sequential file.

Shane - that kind of INDEX() substring logic cannot be implemented in a lookup. You only have equality or range options, so you would need to pivot the reference data from 1 row with n-columns to n-rows after all.

The location of the "dsjob" executable has nothing to do with the projects and their locations. It is determined by the administrator when installing DataStage and the default locations depend upon which operating system is used. The location is best found by using $DSHOME/bin/dsjob; and the DSHOME ...

I can understand Aakash's worries - they have many, many users!

I used to think that there were only paid products that offerred ODBC connectivity for UNIX (i.e. ConnectDirect) but I've seen some recent threads here where people mentioned freeware ODBC drivers. Perhaps you could search the threads for use Google to find such software, as it is not part of the st...

Aakash, I don't think you can. I've just checked a Version 8 and haven't seen any way to set user roles and privileges.