DSXchange

Hi, I need to call a Routine in the Before-Job Subroutine to create the hashfile,if it does not exists in the specified path.If exists then dont need to do any thing. Planning to pass hashfilename as a parameters to the routine. Only one column need to be in the hashfile with data type Char(100). n...

Hi, I need to call a Routine in the Before-Job Subroutine to create the hashfile,if it does not exists in the specified path.If exists then dont need to do any thing. Planning to pass hashfilename as a parameters to the routine. Only one column need to be in the hashfile with data type Char(100). n...

Philosophical Observation One cannot with confidence answer any question containing the word "all". ... Ray, by your own logic, Practical Observation One can always answer "maybe" with confidence to any question containing the word "all" and get away with it :wink:

Tech Tip # 402 Become aware of what's available - doing so can prevent unnecessary re-invention of many different wheels! ... Ray, do you have patent for these tech tips and is it published somewhere. On the lighther side, if weels have not been re-invented we would have struck with [img]http://pat...

thanks vmcburney & Craig, loking forward to Hawk, especially for the metadata part of it :D

Craig, Can you please share top 3 reason why you don't want to do that ? I can think of few like validating parameter files, hard coding lot of directories/variables and capturing the log... Thanks please share your reasons of why don't want it get sheduled with the in-built datastage scheduler, th...

Craig, Can you please share top 3 reason why you don't want to do that ? I can think of few like validating parameter files, hard coding lot of directories/variables and capturing the log... Thanks please share your reasons of why dont want it sheduled with the in-built datastage scheduler, then???

What is the db you use[try merge statement if you do], hanging issues cannot be answered without tracing your design

Hi, Job was hung and tried to reset the job. Still it was running so tried compiling the job. However, I am getting the following error while compilation and its not getting compiled: Error compiling generated subroutine for stage CheckIpDatJob.CheckValidStep Any idea? Thanks, Check with your ds ad...

Hi Do you know of any third party schedulers(like Autosys, Control M etc...) which is integrated with DataStage meaning that we can kick of the DataStage Jobs directly from Scheduler without having to write a shell or windows bat scripts. Thanks Kaps, You need to pass on the parameters when you run...

Could someone please point to me the document which lists the datastage background processes [URL or document reference].

i know ps command will give me an overview

thanks,
prabu

i believe the Subject is non-editable after publishing..

please read the subject as
Open -> "Good to have" Features in DataStage next edition

i tried editing it, but its not allowing me to change

any volunteers to close it once and for all

regards,
Prabu

Hello folks, This is a open thread to list out some of the DataStage features, we feel like lacking in the currently available versions. Please share your knowledge if you feel some of the features listed are already available [or there is an alternative approach] :wink: :- your contributions/sugges...

As ArndW suggested , search for "TNS" entry in .dsenv file and set it to the new tnsnames.ora file. open the .dsenv file in vi and do /TNS 1)But my suggestion is .dsenv file should be belonging to the group dsadm too in addition to oracle. So , request your sys admin to make the change or ...