Skip to Content
0
Former Member
May 18, 2010 at 06:26 PM

DBConnect Datasource references old schema from previous connection.

35 Views

Dear Colleagues,

We have an AS/400 source system connected via DB connect. The connection is working but we noticed that when the underlying DBCO entry was edited the old library name was still in use for existing datasources. When new datasources are created they use the new entries in the DBCO table and we have no issues.

When I looked into the generated program for the existing datasource the line l_schemaname = 'HAFTPYDTA'. was visible. This refers to the old schema and previous DBCO entry. It shoud read l_schemaname= 'HBAPRDDTA'. The schema names are harcoded. We tried registering the program and changing l_schemaname = 'HAFTPYDTA' to l_schemaname = 'HBAPRDDTA'. We then ran a load which worked against the correct schema HBAPRDDTA. But when we reactivated the datasource the string in the generated program reverted to l_schemaname = 'HAFTPYDTA'. Does anyone one know where the schema name is stored and how to see where and why it is cached. My team has opened an issue with SAP but I am anxous to see if anyone else has seen this behavior.

Thanks

Keith Jones