DSXchange

I understand that this is redundant doing it through datastage but the environment here refuses to allow us to schedule independent scripts.

We have the process working quite nicely through datastage and are working on a commercial product.

I created a DataStage batch called ProjectBackup which I would like to schedule. It executes a DOS Batch to run the dscmdexport utility. After that step I use wzzip to compress the file. The problem is that wzzip writes to STDout and hangs the processes.

gzip does work nicely.

Plus winzip can unzip a gzipped file. The problem is that I am mandated to use WZZIP and need some form of workaround because I'm running it through a DataStage batch interface. I tried redirection but it still never returns: Wzzip -ex test *.dsx >null I emailed the winzip dev team and asked for a -...

I created a (DOS) batch file to perform a datastage project backup using (dscmdexport.exe) which works nicely. After the dscmdexport finishes I would like to compress the file to an archive using the WZZIP command line interface. The problem is that when WZZIP executes it writes to STDOUT and that h...

Have you tried doing a Divide or modulo on @INROWNUM?
Also, create a Sequential output and move @INROWNUM to it and see what happens if it gets over say 250000.

This is of course dependent on your business rules for validating each column. You basically interrogate each condition and report the column. Seq File -> Transformer --> Db2 stage (insert/update) --> Log/Errors Stage (constraint contains the business rules for validation). Log/Errors DsJobName DatS...