DSXchange

This is a topic for an orphaned message.

Tony, Ed and Raymond, Thanks very much for your advice so far. Ed, Im afraid your code snippet was a little advanced for me at this stage. I have started by trying to read a hashfile. To date I have only read Hashfiles in a hash file stage. I found a Routine UtilityHashLookup and have tried putting ...

Erwan, My apologies. Not being a reader of French, all I saw was "datastage-users@oliver.fr" in the French version of your message and did not do a careful comparison side by side with the English version. It appears you simply made a typographical error and typed ".fr" instead of ".com" when referr...

Pavan, Would it be possible to send them to me also for inclusion in the lists file download area? -- Regards, Clif Friday, July 12, 2002, 1:48:42 AM, Tim Renicar wrote: > Hi, > I am also interested. > Thank you. > Best Regards, > Tim Renicar > ----- Original Message ----- > From: > To: > Sent: Wedn...

Theres nothing explicitly in DataStage for accomplishing this, but you can easily enough do it in code, for example in a job control routine. I would suggest you set this up to check the job to see whether a parameter has been entered (that is, the parameter has a different value than its default va...

Heres code from a routine that is used to trigger sequencer processing based on a date stored in a hash file (H_AGG_Control. You should be able to adapt it to your needs. Move_Date = Xlate("H_AGG_Control",InputArg,4,X) WithCentury = 0:Move_Date l_Move_date = IConv(WithCentury,"DYMD") ErrorCode = @Da...

I have not tried this myself, but your question made me curious so I did a little poking around. It looks like you could code a routine that looks into your hash file and returns the last load date based on the paramater you supply (in this case it would be one of your six databases). This would be ...

Hi, Wonder if anyone can help me. I am fairly new to datastage so please bear with me! I have a job which has a query (OCI stage) which is restricted by date. I have the date as a parameter so I can vary how much data i load in (days worth / weeks worth etc) What I now need to do is store the last l...

Chris, Good idea. I would suggest that for this case that you should code it as a Transform instaed of a routine. Routines are compiled pieces of code that need to be called (ie. they incur overhead) while the Transform is brought in at compile time. So, in this case, since you have a single instruc...

Hi, I am also interested. Thank you. Best Regards, Tim Renicar ----- Original Message ----- From: To: Sent: Wednesday, July 10, 2002 5:42 PM Subject: RE: More info on DataStage Best Practices > Ken Bland put together some excellent documents on ETL methodology and Best > Practices. I can send them o...

Me too please John Leach Database Products Team Leader Polk Leeds Ltd Direct Dial: +44 (0) 113 386 4005 Fax: +44 (0) 113 386 4100 Email: john.leach@polk.co.uk Polk Leeds Ltd N C R House Ring Road West Park Leeds LS16 6TZ -----Original Message----- From: Stewart Bell [mailto:stewbell@optushome.com.au...

Yes please. -----Original Message----- From: pavan.marpaka@ascentialsoftware.com [mailto:pavan.marpaka@ascentialsoftware.com] Sent: Thursday, 11 July 2002 2:43 AM To: datastage-users@oliver.com Subject: RE: More info on DataStage Best Practices Ken Bland put together some excellent documents on ETL ...

Kate, This is a very common issue with data so you may want to consider creating a routine that you can "wrap" around any suspect column. Using Tonys suggested logic, the code for the routine would look something like: Ans = (If IsNull(Arg1) then "" else Arg1) where Arg1 is the column you are testin...

It is possible for routines, but not riskless. It is simply not possible for jobs. In short, you modify the "catalog" entries for invoking the routines, so that they point to a common location. The risk is that, when you delete the routine from one project, it is deleted, but the catalog pointers in...

The concept here is that DataStage classes are delivered by certified instructors. That is, those who have undergone certification as trainers and as specialists with the technical material. Partners are encouraged to nominate people to become certified instructors. I should probably also point out ...