DSXchange

Hi,
performing:

will get you to the installation directory
there you'll find the bin directory under which the uv exceutable is found.
bare in mind you'll probably need to load the environment by:

after the cd command and befor running uv

IHTH,

Hi,
Lookup means build a hash file with keys and do a lookup via transformer stage and reference link to the hash or directly to the DB stage.

ArndW,
It also happened to me once when I thought my IE was stuck went Back and pressed again on the submit,
So I guess it was not intentional

Hi,
It's a program to enter the DS Engine command language

i.e:

it can also be givven argumets

Hi,
In EE there is a difference stage.
taking 2, sorted hash partitioned and with same meta data, data setes resulting in a set with the diff column 0-3 indicating no-change,insert,update,delete options (EE developers guide has exact number=meaning info)

Hi, you need only bring the key columns, that should be smaller in size. the other way would be loading the entire thing to a table in the AS400 side and running a user defined SQL something to outer join hte 2 and load only records not in the existing target table. or something similar you can also...

Hi,
one flaw in goma's method!
you should make shure no one is connected before performing uv -admin -stop.

Alas I have Oracle 8 so can't fully test it till we upgrade to 10g in a few months.
I think it is only ODBC importable.

Hi, look in the installation CD it's there. (under DataStage Packages\Plugin Stages\DOCS\ENU) also as I recall it's usable for Oracle 9 and above (other DBs may not yet be supported). also I think you need to import the procedure definition before using it. you actually must use it only if you need ...

Hi, options: 1. routine getting the info and passing the value as a return code. 2. a job returning the value in a UserStatus. both return code from routine and Usertatus from job can be referenced from the nested condition as long as they are previous activities in the link leading to the nested co...

Hi,
this was already discussed befor.

in short perform a lookup and use a constraint of NOTFOUND on the lookup input link.
this will cause only new data to pass on to the DB stage.

IHTH,

Hi,
I know there is some firewall configurations but not sure they apply to clients, then again I never had to try it.
you can download the doc from the ADN on Ascential's site

IHTH,

Hi,
this sounds like a lookup stage warnings not a difference stage
never seen such warnings from diff stage

Hi,
There is also the DSGetLogSummary() that can give all warnings from the log.
this could be run after any job finishes write to a file and attach in a notification activity.
might be implemented in an after routine.
just for saving the trouble of coding each job with warning captures .

IHTH,

IMHO he ment that, but having a sysadmin at hand performing tasks like this is an advice worth taking.