DSXchange

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

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