Hi
While doing migration of project from one database schema of the tables (i.e. SCHEMA=A)to another database schema(i.e. SCHEMA=B), the corresponding jobs that uses these schemas should be changed accordingly.
We found that the way is about to do export and do replace all from old schma to new schema (A. to B., assuming no A.'s found other places).
But we would like to know whether the schemas that are imported from the database to DataStage...will aslo affect automatically by this change or not?
Also, please let us know if there is any other best approach than this.
Thanks
Sai
Changing schema name of the tables in entire DS project
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
As Chullet Said,Set schema name as Project level parameter ($Schema name) and repalce this in every job in every sql statement.
Assign the schema name as the default value and set This value to PROJDEF in job parameters..
Then you can export and import this code where ever you want, and just add Project level parameter with the same parameter you have used in th eprevious project..
Assign the schema name as the default value and set This value to PROJDEF in job parameters..
Then you can export and import this code where ever you want, and just add Project level parameter with the same parameter you have used in th eprevious project..
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: