DSXchange

I agree that the algorithm used needs to satisfy the business requirements, and that my rework of Barries algorithm makes an assumption relating to its behaviour on March 31, May 31, and August 29-31 which has not been stated in the rather scant documentation. Im going to make the following definiti...

Hi All, I was just wondering what are the implications of installing NLS on UniVerse (9.6.iforget on AIX 4.3.3). Has anyone had any horrific problems? Do we need to regression test existing code? Will there be a performance hit for existing code? Are there any problems interfacing existing code with...

Find out the job number (lets say 42 for arguments sake) from DS_JOBS. Inspect the contents of JOB.1654423859.DT.1230729608.V0S2 in the RT_BP42 directory in your project. Identify the code at line 53. Match this with the same line of logic in your job design (its almost certainly in the first Transf...

It will work, but it will not be fast. It *might* be improved by creating an index on the lookup_code column of "HashFile". -----Original Message----- From: Alexandre Stoulov [mailto:alexs@tern.ru] Sent: Thursday, 18 October 2001 17:27 To: Tony Curcio Subject: Re[2]: Lookup question Hi guyes! What d...

Hi, Ive got the following problem : in the input of a transformer ive got a char(1) column, in the output the destination column is also char(1) but datastage reject the row with a warning specifying that data has been truncated ("P" was changed to ""). Apparently it works like if the output was add...

Hi Lisa, Apparently according to the message, youve made a division by zero, but without the job detail its difficult to be sure. Perhaps you should modify your transformer by putting a test like if DSInputPin.Quotient ="" or DSInputPin.Quotient = 0 then 0 else DSInputPin.ToBeDivided / DSInputPin.Qu...

I imagine that this is happening during a transformer derivation or a routine. You need to code around this... probably something like the following: If IsNull(Arg1) or Arg1 = 0 then 0 else Arg2/Arg1 lhamilto@ncshealth.com wrote: Does anyone know why this job is aborting rather than just returning a...

Does anyone know why this job is aborting rather than just returning a null value? And how to correct this??


DataStage Job 115 Phantom 18547
Program "JOB.1654423859.DT.1230729608.V0S2": Line 53, Division by zero, zero returned. DataStage Phantom Finished


Thanks
Lisa

Yes, the aggregator expects the records to be presented in the order that matches the grouping performed by the aggregator. Either add a sort clause to your input query or add a sort plug-in stage between your input and the aggregator stage. -----Original Message----- From: Nuno Pimenta [mailto:nuno...

No, but the source table have 70 milions of records. Do i have to order 70 milion of records? Do you mean order in DS Aggregator? Thanks Giovanni. NP -----Original Message----- From: Giovanni Boccia [mailto:boccia@datamat.it] Sent: quinta-feira, 18 de Outubro de 2001 12:33 To: datastage-users@oliver...

Hi all, I have a process that aggregates some data from a table A. This table is the source for three aggregates: Table A ----> Transform A ----> AggregateA1 ----> Table A1 ----> AggregateA2 ----> Table A2 ----->AggregateA3 ----> Table A3 But the process abort when he has 21.703.032 in each aggregat...

Hi Nuno, Is the record sorted on the field where you apply the "Group By"? If arent try to sort it. Ive had similar problem and Ive solve it in this way. Best rgds Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: "Nuno Pim...

Once the DataStage Manager has imported the MetaDate, it is no longer depenant on the actual file. However the the data content of the file (records) will be lost. Regard Adele McClue -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: 18 October 2001 11:55 To: datastage-u...

Thank you ! -----Original Message----- From: David Barham [mailto:David.Barham@Anglocoal.com.au] Sent: Thursday, October 18, 2001 12:39 PM To: datastage-users@oliver.com Subject: RE: File definitions Right. Although, DataStage will remember in the metadata where the file was (I think). -----Original...

Right. Although, DataStage will remember in the metadata where the file was (I think). -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Thursday, October 18, 2001 8:37 PM To: Datastage List Subject: File definitions Just a silly question - when I import a sequential fil...