We have multiple instances of our data. I am needing to compare data between two of these instances. Is there a way to use the connection string to point to a different instance within the same fex? If there is, can I also get the connection string to use?

Amy, there are JOIN commands as well as the MATCH FILE approaches.
If you read those sections in your manuals, you'll have a better idea of the best way to approach your situation.
A JOIN is virtual
A MATCH produces a physical entity.

I think this is what your asking for:

SET SQLENGINE=SQLORA
SQL SQLORA SET ORANUMBER DECIMAL
-RUN

-SET &TEXTSIZE = 'A' | &DB_NAME.LENGTH;
-SET &DB_NAME = LOCASE(&DB_NAME.LENGTH,&DB_NAME,'&TEXTSIZE.EVAL');
-RUN

-SET &TEXTSIZE = 'A' | &DB_USER.LENGTH;
-SET &DB_USER = UPCASE(&DB_USER.LENGTH,&DB_USER,'&TEXTSIZE.EVAL');
-RUN

-SET &TEXTSIZE = 'A' | &DB_PASSWORD.LENGTH;
-SET &DB_PASSWORD = UPCASE(&DB_PASSWORD.LENGTH,&DB_PASSWORD,'&TEXTSIZE.EVAL');
-RUN

SQL SET SERVER &DB_NAME
-RUN

SQL SET CONNECTION_ATTRIBUTES &DB_NAME/&DB_USER,&DB_PASSWORD
-RUN
-TYPE SQLENGINE: SQLORA
-TYPE Server Name: &DB_NAME
-TYPE Database User: &DB_USER
-TYPE Database Password: &DB_PASSWORD

This work great for our system, the server name, database user and password are passed in via the GUI and we use this to switch between 8 different environments. Also I only call data via SQL pass-through and I don't use any Access or Master files.

Hope this helps.

This message has been edited. Last edited by: <Maryellen>,