DSXchange

Return Receipt Your Multiple instances document : was Craig Hulett/Englewood/GNIC received by: at: 03/26/2003 03:09:35 PM MST

Hi Kenny... Each "instance" when multiple instances are enabled, is established at runtime, when the InvocationID is applied. There is only one actual "job" containing meta data (GenericJob), and any invocations, such as GenericJob.1, .2, .3, or .FRED are simply run-time "images" of that job with po...

I have a job (GenericJob) that has multiple instances enabled. I have it scheduled to run multiple times as GenericJob1, GenericJob2, GenericJob3, etc. When I change the original job GenericJob do I need to unschedule and reschedule the multiple instances that are already set up, or will they automa...

I made a mistake 3 and 4 should be ODBC. -----Original Message----- From: Shawn Ramsey Sent: Tuesday, March 25, 2003 8:14 AM To: datastage-users@oliver.com Subject: Poor perfomance with OLEDB stage All, I am having performance concerns with the OLEDB, we have a straight select from a single table an...

Tom, Thanks for the response to my ORAOCIBL questions. I am running DataStage 5.2.1 on Unix 11.11. We recently upgraded from DataStage 3.6.3. It was long overdue. We do have one similar situation with truncating the table first. I was thinking subroutine at first prior to the job running but instead...

Jean-Pierre, We also use similar coding to access Oracle via ODBC in our job control routines. We had no problems when we migrated from 4.2.1 to 5.2. What exactly do you mean when you say the command doesnt work? Does it return an error? If so, what is the error? Otherwise, what are the symptoms tha...

** Reply Requested When Convenient ** Hello all We just moved to DataStage V5.2 from V4.3. I have several routines based on the code supplied in the standard DataStage documentation for "Execution of an SQL statement from a Basic program using ODBC client interface". The routines perform SQL command...

Theres a known problem whereby transferring very large packets across a LAN Manager connection can cause the DS client/server link to fail in a way similar to this error. The large transfer will occur when saving the object that represents the link of your CFF stage that has 2K+ column definitions. ...

Oops, not DS_JOBOBJECTS. Its DS_METADATA. Mind was elsewhere. "We apologise for any inconvenience caused." ----- Original Message ----- From: "Ray Wurlod" Date: Wed, 26 Mar 2003 14:11:01 +1000 To: datastage-users@oliver.com Subject: Re: Datastage 6 and max columns > Im not aware of any documented li...

Im not aware of any documented limit, but 2100+ columns? Sheesh! Its possible that one of the memory arrays into which the columns are mapped within DataStage is running out of space. Or simply that the size of the generated code is becoming too big (though this would tend to happen on compile rathe...

Thank you! Fuller Chris - Sydney-MRA wrote: >John > >All you need is the COBOL copybooks from your source system in ASCII format >with a file extension of .csd. As our source system is a mainframe, I just >download the COBOL copybooks to a target directory on the LAN that the >DataStage server can s...

Does anyone know of limitations ( if any ) on the max number of columns that can appear in a CFF stage ? Im getting this error when saving a job that has 1 CFF as input ( about 2100+ columns as input ) being blown out into 20+ sequential files ( flat files ) for further downstream processes. I even ...

Hi Mir, Weve been using the "2nd generation ETL tools" for years. The evaluation you have is very general and not in depth. They even compare tools that arent typically compared with each other. Our preference is DataStage. We did our own evaluation of ETL tools years ago and weve updated it periodi...

Hi Prasad, About 2 years ago (correct me if Im wrong Ray!), a course was developed in Ascential Australia on DataStage BASIC Programming, which convers in depth all of the topics pertaining to error handling that you are interested in. We, here in US, are in the process of offering a similar course ...

Oh yeah! Ofcourse www.Ascentialsoftware.com is DA place for all the info on DataStage. I was referring to Gartner and others for evaluation on all ETLs (btw, which constantly rank Ascential Data integration platform in the top right quadrant) Pavan -----Original Message----- From: Ray Wurlod To: dat...