What is the best way to go about connecting to multiple databases and having multiple schema files? I have been testing some things out connecting to multiple databases simultaneously and it seems to be working well, but is there anything to watch out for in this situation? As of now, I am using 2 schema files (.sch) and 2 header files referencing those schema files.
Are there any functions that are limited to use referencing only 1 of the header files?
Are there any conflicts if I reference both header files from the same source file?
The only think to watch for is that there is only single SQL....
Tom has added NOAPPSQL flag that you can to main config - then there will be no SQL
In fact, even 1 schema files (but included for two dialects) could be OK (depends on how much DB specific stuff you put in).