Frequently Asked Questions
Posted in 1996
Topics: Performance & Tuning, Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design, Triggers, Constraints & Referential Integrity
Frequently Asked Questions: Q) Can QueriX 4GL Compiler cope with TEMPORARY TABLES when connecting to Oracle RDBMS. A) The Simple answer is YES Though the concept of TEMPORARY TABLES does not exit on ORACLE and is only an INFORMIX feature, no change is needed to your 4GL code when you use QueriX Compilers to port you Informix Application to Oracle. Q) Dose QueriX cope with SERIAL column types. A) Yes, QueriX automatically creates the correct sequences and triggers on an Oracle Engine. Q) Can I go on defining my programs data types as LIKE table_name.column_name when working with Oracle. A) Yes very much so. There is an example of code which works with both Oracle and Informix on: http://www.querix.co.uk/ora_man/appdx_d.html QueriX Compilers can analyse Informix 4GL syntax and produce executables which can interface with either Oracle or Informix. Creating a UNIQUE OPPORTUNITY to Connect to an Oracle data base as well as IMPROVING PERFORMANCE for Informix applications. And at lower prices. For More Information please call me: Best Regards Ali Afshar ___________________________________________________________ QueriX (UK) Ltd Tel: +44 1703 232345 10 Bellevue Road Fax: +44 1703 399685 Southampton email: ali@querix.co.uk SO15 2AY www: http://www.querix.co.uk __________________________________________________________