DSXchange

HOW can you use a Wait For File activity?

That's been my point. Unless you can "see" the Windows folder where the zip file will arrive from your UNIX machine on which DataStage is running, you will wait in vain.

It's not done in the Sequential File stage, because both NULL and spaces are valid for VarChar.
Follow the Sequential File stage with some other stage (such as Modify or Transformer) in which you can perform these conditional substitutions.

Three Make Vector stages.

Get some training!! It's definitely not a DIY product.

Lots of hits on Search 30107 decodes as "subroutine failed to complete successfully". This is not a lot of help, since DSD.RUN and DSD.StageRun, and the code generated by compiling Transformer stages, and before/after subroutines, and job control routines, and lots of other things are ALL subroutine...

Is this a server job or a parallel job? You specified server job but posted in the parallel forum.

Hawk is due to be released when beta testing is completed. Currently it's in Beta 2 (whatever that means). IBM was aiming at "second quarter" but don't be surprised if that slips again. I'm aware that your site was part of the Beta 1 program - are you participating in the Beta 2 ?

Substantial changes. This is now a completely different requirement. You need to incorporate some algorithm (additional stage variables) to determine whether B is missing (and, presumably, whether A, C and D are missing). See if you can design the algorithm on paper (in words - ignore the fact that ...

Is the column rel_name_rel_key defined as NULL in the actual table, but as NOT NULL in your column definitions in the Oracle Enterprise stage?

This question will not be answered until it has been moved to the correct forum.

This question will not be answered until it has been moved to the correct forum.

Except on those UNIX platforms where the Sys Admin elects not to enable large file support.

Incidentally, it's "hashed" file, not "hash" file.

I'm not aware that any of the putty command line utilities gives you a Wait For File capability. You could, I guess, script a ptcp command to attempt to copy the file, and only proceed if it succeeds, otherwise sleep for a while and try again, but it's not a pretty solution.

I don't understand why you started a new thread when you already have this one active.

I'm looking for any numbers or a kind of benchmark comparison for my rows/second number. As I have posted many times, rows/sec is an almost meaningless metric. It's only valuable if you can guarantee homogeneous row sizes and you can guarantee that "all else is equal". It never is. Prefer elapsed t...