DSXchange

Carol, How many new records are you inserting into your 30MM row table when you run the job? How many are updates? You may want to create a small table in your target of just the key fields of the records to be processed, then truncate a load that table, then select that table with an inner join to ...

Access was granted to user1 via the secondary group dstage. Remove user1 from the dstage group entry in /etc/group (or wherever your platform stores the group info) and see what happens.

Alan

Lance, Ray,

I looked at those vector stages in the guide before my earlier response, but didn't think they would work since the incoming data had a variable number of fields. I'd be curious what either of you come up with for using the vector stages.

Alan

Varsha, Lance is correct. EE expects input rows to be of an identical format-- the same number of columns for each row. Since your input rows have different numbers of columns (assuming you use the '|' as a delimiter), you'll need to use a different delimiter ('',' perhaps) to treat each row as if i...

Tom, We have in place a standard Unix script for executing all our DataStage jobs, whether they be individual server jobs or job sequences that call other server jobs. This script grabs the log entries from the last run of the job and places the results in a flat file. Production support needs only ...

There is a document on all the BW Load PACKS included on the release CD. The document name is dsbwloadpack.pdf. Try going through that document first and see if it address your issues.

Alan

Thanks, Ray. I read through what you wrote a few months ago, but I couldn't really apply it to my project. I can generate a UUID via Oracle, but I'd rather not make the database call. I'd like to execute a Unix command, but the ones I found on the Web are not what's available to me right now on my c...

Vince, I've done some zoned decimal processing from flat files out of AS400 iSeries. We wound up writing a transform/routine to convert the zoned decimals to a regular numeric that DS can handle. Here's the DS Basic code from the routine: * Transform zoned/packed numbers to regular decimals * Two ar...

Kim, UUID is a Universal Unique IDentifier. You can do a Google search and browse the topics. The target database I'm loading uses UUIDs as surrogate keys. The Siebel application generates its own UUIDs when loading data via XML. I have to emulate the process for the initial (history) load of the da...

I have a need to generate UUIDs in DataStage 7.x to be used as the key column for new rows in a target Oracle database. Has anyone worked with UUIDs before? The Web has various information on UUIDs and GUIDs, but nothing specific to my AIX 5.1 environment. I can generate a GUID using the SYS_GUID() ...

I am using DataStage 6 (Unix) with Pack for BW 3.0. When I try to load data into BW using PUSH method the job hangs and I receive the following message in SAP BW "saptrng.ZDSPRUEBA not registered" where saptrng.ZDSPRUEBA is the BW Load RFC Server program ID defined in DataStage job and SA...

Has anyone encountered any undocumented issues when upgrading Version Control projects from DS 5.2r1 to DS 7.x? We are on an AIX platform with separate Version Control projects for each development project.

Thanks!
Alan Williams

I think organizing the archives into a knowledge base would be very helpful. I use Apple's knowledge base extensively to research problems and issues I encounter with my PowerBook, especially at the Unix level. Being able to see more topics with a drill-down or search capability would be great for t...