rp_sqlredirect: A Practical Example
As a practical example, to copy all the student course data that
``fred'' normally has access to, execute:
1> exec open_acs_dds...rp_sqlredirect
2> regstr_ext,
3> "select * from stu_crs_vue",
4> acs_dds,
5> fred,
6> mypassword,
7> sybase1,
8> wilma,
9> herpassword,
10> 'student..courses'
The Open Server would login to acs_dds as user fred, change database
context to regstr_ext select the contents of a view (in this case,
stu_crs_vue) and return the result to student..courses on sybase1.
Note that if student..courses exists in sybase1, it will be overwritten!
Back to the SQL-Redirect Index Page