DSXchange

Why are you using an aggregator stage? Why not turn your Universe select statement into a group by statement and send this directly to the transformer. This should be far more robust than DataStage Aggregator. Ive had problems before with large aggregations, it can run into memory problems on large ...

There are only 3 columns being pulled and they are pretty straight forward numbers. The 3rd column is being counted in the aggregator stage and grouped by the 2nd and 1st columns. Thanks "Himanshu" on 01/09/2003 05:07:19 PM Please respond to To: cc: Subject: RE: Aborts check the data coming in from ...

check the data coming in from the universe file. i had run into this problem before and i turned out to be control characters in the KEY and/or certain data fields. himanshu -----Original Message----- From: lhamilto@ncshealth.com [mailto:lhamilto@ncshealth.com] Sent: Thursday, January 09, 2003 4:52 ...

I am running a job that is using parameters, an AGGREGATOR & TRANSFORMER Stage, pulling from Universe to a text file. I was able to run this job several times successfully. The job is now aborting with the following error message: ActivePatientCounts010903.AGGREGATOR34: Premature EOF reading stream ...

I guess you asked what OS I am using..right? I am using WIndows 2k server. Datastage version 5.1.0 Thx, -----Original Message----- From: salvatore.serra@ascentialsoftware.com [mailto:salvatore.serra@ascentialsoftware.com] Sent: Thursday, January 09, 2003 4:11 PM To: datastage-users@oliver.com Subjec...

Which is the S.O. ? Bye -----Original Message----- From: Bhattacharya, Abhijit [mailto:abhijitbhattach@att.com] Sent: Thursday, January 09, 2003 4:08 PM To: datastage-users@oliver.com Subject: how to kill a DS job.. Hello Everyone, I have a DataStage job running for long and want to kill it. I have ...

Hello Everyone,

I have a DataStage job running for long and want to kill it. I have been trying to stop it using the Director tool. But it does not work. Is there any other way to kill the job?

Thanks

Hi Everyone, I have a question on privileges for datastage users. Is there any way we can give Manager access to users to "import only" and "not to export" between two projects? This is similar to read-access and no-write permission. Any ideas ? Could you please share your experiences on this kind o...

Kindly pls unsubscribe me (chingkaisern@yahoo.com) from the mailing list with immediate effect. Thank you very much. ____________________________________________ Ching Kai Sern HP ..+65 9878 4604 Email ..chingkaisern@yahoo.com " To see a World in a grain of sand And Heaven in a Wild Flower; Hold Inf...

Tom, if you have checked the date if exists in the calendar as it was given in, you still have options to deal with this date. Normaly an operating system should check in advance if a date exists and not let a user enter the input before a correct date is given. But such things happen. Im in an insu...

I needed to check if the date exists in a normal calendar. 31th June is not a correct no matter how people look at it. Naturally you could just convert it to be 1st of July, but if the user that enters the data expect it to be effective on the last day of June then this approach doesnt work. Ive fou...

Hi Tom, what do you want to get as answer? (1) Error (2) last day of February (3) else In our company, we have written a routine, which changes all wrong 29-31 Dates to last day of this month because people wanted it so. DataStage continues, which is also in my opinion okay, you can catch it via the...

Looks like your locale is expecting something other than "YMD" as the sequence in a date. Try specifying "YMD" specifically with the Iconv() function. For example: Iconv(TheDate, "DYMD"). Then test the value returned by the Status() function. If it is zero, then the conversion was valid. Create a ro...

Sorry - I meant of course ..... a "possibly invalid" date string such as "2002-02-30" .... below...........Len > -----Original Message----- > From: len.greenwood@ascentialsoftware.com > [mailto:len.greenwood@ascentialsoftware.com] > Sent: Thursday, January 09, 2003 9:27 AM > To: datastage-users@oliv...

One way is via ICONV() followed by a call to the STATUS () function. >From the BASIC manual on ICONV(): The STATUS function reflects the result of the conversion: 0 The conversion is successful. 1 string is invalid. An empty string is returned, unless string is the null value, in which case null is ...