DSXchange

I need to ftp a few compressed .Z files I create to a client box. Currently I have a batch which calls a few jobs that get the files created. I run unix commands using DSExecute to compress the files. I can create a temporary ftp file with the ftp commands and call ftp from unix to send the files bu...

You could try setting the "minimum modulus" closer to the value shown in the analyzer output. Also, if there are relatively few records looked up each time (compared to the size of the table) why not use an OCI lookup but output the data to a seq. file, then insert or bulk insert in a sub...

We are building some very large hash files which are then used for lookups in some jobs. It reads from an Oracle table around 4 million rows and it does a self referencing lookup to concatenate strings for the same key. The question is with the current hash algorithm of Type 30 Dynamic, Group 2, Spl...

Hi Everyone, Is there a way to use the Oracle SYSDATE function when populating a date field in a Oracle target table? I have tried to use syntax such as Oconv(date(), "D4-DMY") in stage variables, but I can't get the format right for Oracle. Even when I just use a string such as "01-...