Assuming you are using a SQL database and a Flex2SQL driver, the Flex2SQL driver has a feature, SQL_Set_Constraint, that automatically adds a constraint to find all operations.
Archive for February, 2008
Increase Performance Using Set_SQL_Constraint from a Large Table
Wednesday, February 27th, 2008Open Tables Directly
Wednesday, February 27th, 2008Using this method you don’t need to have a INT file but the FD is still needed.
Using ACTIVATE TIME STAMP
Wednesday, February 27th, 2008You must change the FD (field definition) files and insert the macro command.
Running Flex2SQL for Oracle in a HP-UX
Monday, February 25th, 2008To run Flex2SQL for Oracle in a HP-UX, set the environment variables below:
Rights for an Oracle User to Migrate With Flex2SQL
Monday, February 25th, 2008These are three user rights an Oracle user needs in order to migrate data with the Flex2SQL migration tool. They are as follows:
- CONNECT
- RESOURCE
- DBA