Can I use RCP for a multi table select

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ep_datastage
Participant
Posts: 24
Joined: Wed Apr 16, 2014 11:11 am
Location: United States

Can I use RCP for a multi table select

Post by ep_datastage »

i would like to use RCP for select statements that gather columns from various tables. Can I do that, and if so, how do i do that.

Thanks

Rick
Mike
Premium Member
Premium Member
Posts: 1021
Joined: Sun Mar 03, 2002 6:01 pm
Location: Tampa, FL

Post by Mike »

Yes. It's not all that different from a single table SELECT. However, you will have to provide the SELECT statement rather than having the stage generate the SQL. Provide the SELECT statement with a job parameter or combination of job parameters.

Mike
Post Reply