DSXchange

Hi All, I have 1 million records in Txn File and 500 million records in a second table T2 in udb database. I need to do a join between Txn and T2. If I do a join won't it not pull 500 million from the database to ascential memory and do the processing ?. I also saw some features like 'sparse lookup'...

Ray / Ken , Pls share your knowledge of how a "SIMPLE" C function can be called from DataStage. Please explain it in simple terms, so that I can follow your instructions. If I am successful in that I shall plug in encryption code from openssl.org to implement encryption.. Rgds and TIA, CP ...

Hi All, Slightly off topic, but related to sequence number issues We have the requirement of 3 processes running in parallel and needs to generate one up nos for insertion into the same table. I would like to use KeyMgtGetNextValueConcurrent, but it is not available in PX jobs. Any way I can workaro...

Having explored the properties tab, I am getting the feel that CFF stage can handle the cobol file with comp-3 , occurs and redefines properly. It does read values correctly when I cross check using VIEW data button "most of the times". However when I have a comp-3 field inside a OCCURS fi...

Can we handle Variable length records of COBOL (Record format - VB) having OCCURS clause using CFF Stage?

Can I use an index to handle these values which occur multiple times without flatening the OCCURS clause?

Hi Ray, 1. Any sample code snippet from which I can learn the approach and implementation in more depth for "Restart after last commit point" - I have already gone thro the replies posted like 1. "either by capturing process metadata at appropriate points and designing suitable restar...

1. Kindly throw more light on "Linking your C code as shared library to DataStage ". to do my encryption. Can you give me some pointers on how to write a shared library and integrate with datastage.

Rgds, CP

Hi, I would like to implement Encryption in my project. I need to Decrypt data using DES3 algorithm and encrypt using AES before posting them to a UDB database. My source data comes as flat files to my ETL server. (Presently I can only think of writing a C program to read the source file ---> write ...

Hi, I would like to build a robust job scheduler framework using BASIC code using the bunch of dsjob API available. This would also have to take care of restart and recovery logic if any of the jobs had failed in the previous run. I would appreciate if you can share your experience of job scheduling...