DSXchange

Do you have top installed or did you do a sar 5 5 to see if there are any other processes that may be hogging cpu resources?

We need to be able to put DataStage in a restricted mode when we perform upgrades and/or import/exports. This will lock all users out except for the "admin" user.

The Plugin/OCI stages offer Native connectivity to the dbms which usually means greater control over commit points and select array sizes. Typically the OCI stages will outperform ODBC if configured correctly. Also the OCI stages often do not require the overhead of creating and maintaining ODBC DSN...

Except for the fact that the original poster is running on a Windows server, hence my comments about doing it in a 'batch' file. MS-DOS doesn't by default have this capability. There are some "freeware" utilities that will to it (i can remember using test -s). The best and most robust sol...

A unix shell script is certainly viable but not platform independent.

The above code has a spelling error and a missing include, the code below is both fixed and tested: """purgezero.py purge zero-byte files usage: purgezero.py Directory """ import sys, os from os import listdir from os.path import isdir, isfile, getsize, join for char in...

This is an important problem that we solved using Python. You will need to install the python interpreter from www.python.org. This script is callable from within a DataStage Batch. """purgezero.py purge zero-byte files usage: purgezero.py Directory """ import sys, os f...

Just use real database triggers for what you're trying to do... a little bit less nice but much faster. I would not recommend this approach. The DataStage engine is designed to be truly multi-threaded and having 2 outputs from the transformer are much easier to control than an INSERT/UPDATE trigger...

you need to log into your unix server and look at the log, or ftp it to your windows client.

I actually built a DataStage Batch with a Before and After subroutine to clear the &PH& and &COMO&. I then imported that batch in to every project so I can schedule them independently.

Is there a way to rework the code to not use a loop?
I'm looking for something like the python dict/list index.

I have a routine which searches an attribute list and then returns the same field position from the data field. e.g. AttrList="PartType|Description|Thkmin|SpecGrav|..." AttName="Thkmin" AttValues="FILLERBAR|FILLERBAR OD 3/4|3.433|.9905|..." The function accepts 3 params...

This is always an interesting problem. Condition: A sqlloader.DAT file that contains duplicates will cause indexes to be disabled. I wrote a [platform independent] python script that: 1. sorts the inputfile 2. removes duplicate rows from input while writing the outputfile Assumptions: the entire row...

If IsNull(trim(Oracle_br.ENDDATE)) Then @NULL Else Oracle_br.ENDDATE

You may want to replace @NULL with @DATE.

Basically the dsjob will do what you want.
To get more elaborate you can create a DOS Batch file since you are on windows.