Routines with RCP

asyed · Post by **asyed** » Thu Apr 03, 2014 8:11 am

Hi,

I want to create a generic job which executes routines for each field in the source with RCP enabled.

Is there any way to do this ?

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Apr 03, 2014 3:09 pm

No.

Arguments to be passed to routine must be named input columns.

Of course, RCP will take care of any column that you don't want to process, which in your case is none of them.

asyed · Post by **asyed** » Thu Apr 03, 2014 11:54 pm

Hi Ray,

It is not necessary that I use RCP, basically I need to use a generic job which calls routine on every column. Is there any such option.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 04, 2014 12:12 am

Only to call the routine for every column.

There are technically illegal hacks via which you can find the name of each column in the record schema, and then obtain the value of each, but these are undocumented and - under the reverse engineering prohibition in your licence - illegal.

chulett · Post by **chulett** » Fri Apr 04, 2014 7:04 am

Unfortunately, the job isn't really "generic" unless it uses RCP and the need to call a routine for every column rules that out, as noted.

I'm guessing about as generic as you could get would be to build a template and leverage that as you build each job. Something like FastTrack comes to mind or a home grown solution. Back in the day we built a process that combined a table's metadata with just such a template which generated the completed job in "raw dsx" format which could then be imported. Of course, that took some effort and detailed knowledge of what the end result needed to be but it helped us in the long run as we had almost 1000 to generate.