DSXchange

There are several other solutions, it's just preference I think. If the DataStage server crashes unexpectedly our operators do a category by category check on the jobs anyway and they didn't need to do this for the last year. The advantage of keeping it in DataStage is that it's simpler for the oper...

If the file only appears a single time every day schedule your job once every day. If the file can appear multiple times you'll have to write your own BASIC sequence job to get it done by looping (wait for file... do run... wait for file... do run...). Some hints: * Use DSWaitForFile instead of slee...

1) No 2) No "recently looked up" cache 3) No :D, the usual advise is to preload your lookup data to a hash file and do the lookups from there. Since I don't like hash files that much, I usually move the "lookup table" to the database where the main query is executing in (if it's ...

Don't use IXF, export to DEL. Then if you want to do the loads via DataStage use a "sequential file stage". I'm not familiar with SQL server but there should also be 1 or 2 tools to load tables from ASCII files.

Ogmios

Did anyone already fully "crack" the 2-way encryption algorithm used in "Encrypted" parameters? At first sight the encryption looks pretty weak, but I haven't been able to figure out the full algorithm. So far: * every character gets encrypted to 3 characters * the third characte...

Has anyone noticed the following problem (and fixed it): The UNIX server uses "winter time". The following 3 points are done with the same user id: - When I ask the time of the system with the UNIX command "date" I get the correct time. - When I look in Director all of the times ...

Can someone point me in the right direction. I'm trying to do the following in uv:

UPDATE RT_LOG1111 SET TYPE = 0 WHERE @ID LIKE '//SEQUENCE.NO%';

The problem is that I can't seem to use LIKE on @ID ("DataStage/SQL: The LIKE operator may only be used with character data")

Ogmios.

You're only allowed to use the ODBC via a GUI job, not via a BASIC job, or you have to buy ODBC licenses (which are not cheap on UNIX machines). People have given an extensive explanation on it before on this site. The trick we use is to either use OCI or transform our data to an ASCII file and then...

I'm using DataStage version 6.0 on Solaris and I'm seeing something strange happening with my log files in the RT_LOGXXX directories: they don't seem to shrink anymore, only grow. The behaviour seems to be that the size of the hash file always remains the largest as it ever was (and yes Autopurge is...

I'm using DataStage 6.x on Solaris, OCI8 to an Oracle 9 database. One datastage job will load rows from one source system, while the update job only updates information in the same table but this information is from another source system (as a kind of an override). The source system for which I do t...

Is there a clean way to suppress warnings in Director? I'm using DataStage 6.x and am updating information in an Oracle table (using OCI plugin). Not all of the rows that I currently send to the update stage is present in the target table so these rows generate warnings in the logfile (if the data i...

I know the distinction between operator and developer in DataStage, but if I put a user (actually the group the user is in) to operator he can only see released jobs. And since we're not releasing jobs the operator rights are pretty useless. Hence the id of giving both developer rights, but putting ...

Does anyone have a solution for the following: in DataStage v6.0 running on Unix. We have 2 (unix) groups, one group would have full access, the other group would only be allowed read access in DataStage. We're not using releasing of jobs (this would make it possible to differentiate between operato...

Also normal users can't kill processes started by other users.

So unless you're running as root or all DataStage jobs are started as the same user id "kill" will normally not work.

Ogmios

You can open ASCII files from DataStage with OpenSeq, write to them, close them. But is there also a function to delete files from within a BASIC program? I haven't found any so far.

Ogmios