DSXchange

Hi, Ray So nice to talk to you here, I am just fine if you help me get this issue resolved. here is my answer : a) I did log in as a DBA user. b) How can I find a corrupted hashed file, as you know, we've got heaps hashed files. c) As the project creation failed, we don't have project to delete. Tha...

Hi, I was trying to create a new project using DataStage Administrator, it failed along with a error message : DSR.ADMIN: Error creating a schema Some users will not have access to this schema. Read operation failure. Internal file corruption detected. File must be repaired. What does it mean and ho...

Hi,

To apply a complex logic on a transformation, I am able to code in transformer directly, alternatively, I can create a routine called by transformer. I am wondering, from performance perspective, which approach is more efficient.

Thanks in advance

xli

For a single job, it takes 12 hrs to process 9 million rows, I think you'd better do something to improve the performance first.

Since you have stored you data in staging area, I guess your job have many complex lookups, try to reduce the number of lookups, and use hashed files as lookups.

xli

Hi, I have 7 big flat files, each contains 24 million records which have been sorted by the first numeric field delimitered by Ctrl B (002). I want to join them together side by side, for example : File A: 1^Ba^Bb 2^Bx^By .... File B: 1^Bc^Bd 2^Bm^Bn .... After merged, it should look like : File C :...

Hi, I have four huge flat files needed to be merged together. They have the same records number of 24 millions with the same key fields key1, key2, key3. each file has average 50 fields. These files are required to be sorted by key1, key2 and key3 first, and being merged together, then output to app...

Hi, Is it possible to generate a value in one Job Activity and use that value to set the value of a job parameter in subsequent Job Activities in a Job Sequence? It's easy enough to do in code, but my current client wants to avoid code as much as possible. Scenario is that job #1 generates a batch I...

denzilsyb, what I mean is add/minus n months to a given date, it's exactly what the oracle add_months() function does. jclin777, thanks for your post, I know I can created a routine to handle it. I was just wondering if there is a simple built-in funciton I haven't discover to do it. However, it see...

hi

I am wondering if DataStage has a simple function to do the same thing as oracle function ADD_MONTHS()

Thanks

xli

Hi, There is a hash file with 3 keys, cust_id, record_start_date, record_end_date. By using this hash file as lookup, I wonder whether or not there is a way to find cust_id with record_date existing between the record_start_date and record_end_date ? I mean, I want find a cus_id with record_date gre...

I have already noticed this issue even from DataStage version4.0 to version6.0. Also, I noticed that in most of jobs, the NOTFOUND function works. But in some jobs, even very simple jobs, for no particular reason, It produced wicked logic result. Now, I have changed all my jobs to use ISNULL or NOT(...

Hi, experts

I have a job using sort stage, it runs well many times. However, today, it always issued a error message today as below :

SORT: ds_ipcgetnext - timeout waiting for mutex

and stopped at sort stage processing.

Can anybody tell me what this problem is ?

Thanks in advance

xli

Thank you, craig

xiong

Hi, Folks In terms of DataStage document, when we try to restart server, to avoid an open connection, ensure that all client connections are closed before shutting down the DataStage server. the following unix command is used to check: # netstat | grep unirpc this command produces no output when all...

If you just want to identify a blank string containing one or more space, there is a built-in tranform function StringIsSpace under Tranformssdk directory in DataStage Manager. If you cannot find it, the basic code to check a blank string is like : If Not(IsNull(Transform_Full_File.FNAME) or Transfo...