How to move Central Objects to AS400?

I was searching the KG and came across a reference to document OTI-01-0132 which doesn't seem to exist.

Anyone have any procedures/documents for moving COs off SQL 2000 to the AS400?

Thanks, Grant.

In theory, you could setup a Central Objects OCM for another environment, use the UBE that copies objects from one data source to another, and then change your Data source/OCM that used to point to SQL server to point to the tables on the AS/400. That may take about 24 hours to transfer the data over, though. That happens to be the method we used, which is why I know. It might be quicker using a file transfer to the AS/400 and then just change the Data Source/OCM's to point to the right place.

oh, and don't forget to send an update package to clients to update their ODBC's.

Hi List,

I need that docu. also. we are now in SQL 7 and having 10 Environments and wish to move the Central Objects to the AS400.
If anyone have the Docunment "OTI-01-0132" kindly send it to me ([email protected]).

Thanks and regards.
WCH

Xe SP16.1 Update 2, AS400, SQL 7, W2K TSE.

Quick and dirty:
1) Create libraries on the AS/400 (COPYxxxx)
2) Create database datasources pointing to the libraries.
3) Run R98403 to copy from the existing Central Objects to the new one.
4) Repoint your old Central Objects datasource(s) to the AS/400 libraries.
5) Build and deploy an update package as Jean Driscoll suggested.

Hope that helps,
Chris