DSXchange

Hi ,
I have some 100 jobs designed .My database is oracle .But , I am using DRS stage instead of oracle enterprise stage because oracle enterprise stage is giving some sql loader error .
with DRS stage , all jobs are working fine . But , If the usernaame and password is getting changed i need to change all 100 jobs .Is there anyway to parameterise the username and password in DRS stage ??
I tried using DATA CONNECTION .But , I heard that it will get locked if one is running .I dont know whether i am viewing it in a right angle .Could someone suggest anything regarding this ??

Not familiar with 8.x connectors yet, but you should always parameterize all of your connection information. A set of Job Parameters would do the trick.

Thank you chulett for your response .But , In DRS Stage there is no provision for giving job parameters to username and password .Thats where entire problem came

Thank you chulett for your response .But , In DRS Stage there is no provision for giving job parameters to username and password .Thats where entire problem came

You CAN use job parameters in the connection options in a DRS stage. The only thing is that you don't get a neat right click option to insert it.
You can use job parameters in the username or password by enclosing the job parameter in #(as in most of the stages)
Moreover in 8x there is this beautiful parameter set which takes care of bundling the parameters you regularly use.

Minhajuddin wrote:You CAN use job parameters in the connection options in a DRS stage. The only thing is that you don't get a neat right click option to insert it.

Ah... not only can you use parameters practically everywhere just by typing them in by hand, you CAN get the 'neat right-click option to insert it' in any database stage... you just have to know how.

Right-click on the DRS (or pretty much any stage) and select 'Grid style'. If the option is there, that will get you the older interface to the stage. There you'll find there the 'Insert Job Parameter' option on the Properties page you can use so you don't have to do all that pesky typing.

I use that all the time, but only for that purpose. So, right-click grid style, click click paramater parameter, get out. Then switch back to the normal view for the rest of your work.

Thanks for this tip Craig :D

Sorry for the late reply.....Chulett its working ...Thank you for your solution.Now i will mark this topic as resolved