Originally posted by: SystemAdmin

I am unsing the Database Interface designer in 6.7 for the first time.

Everything worked fine in our Dev enviroment . Now I am preparing to move the maps into our Application testing Env. In the mdq file if I am changing the database name and the connect strings to point to AT it does not reflect the changes in the maps. If I go into the output card from which I am writing the data into the oracle database and change the database name in the Database Query file to point to AT and click OK everything is fine. But if I open the same card in edit mode to check if my AT name has been accepted I see that the name is getting rolled back to the previous one. any ideas why this is happening.

Should I create one databse for dev, at and Production in the mdq?

Any help would be greatly appreciated.

Thanks,
suma.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

You should specify your database overrides in the command options for the output card such as
-dbname KFIData -mdq KFIData.mdq -table BATCH_COUNT -update -T+

You need an mdq file in each environment pointing to a different database.
Alternatively if you are running everything from the same server you could specify different databases with different connect details in the same mdq and change the name of the database in the command option and save the msl with a different name
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Thnaks Jan for the input. I'll try what you have suggested.

Thanks,
Suma.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange