Depending on the amount of data I would take a brute force approach...
* Manually create all the DB spaces in Infx 11.7
* dump the schema to file using
- dbschema -d <dbname> -ss ( I assume that command is in Infx 5)
* Then take the sql file generated and try to create the schema in Infx 11.7 and see what happens.
If you can create the schema then...
* Do a dbexport of the data from Infx 5
* Make whatever modifications to the schema you need
* The do a dbimport.
I have done on end of messing around with DB using that approach... of course the down side is potentially loads of down time.
But I only started using Infx from version 7 so not sure what the differences are... may be there is a hidden major show stopper.... You could have reserved word issues.. eg Sysdate is now a reserved word in Infx 11.7, it was not before.
I've gone from Version 2SE to 11.70 IDS (Informix 4GL to Informix 4GL) and (Informix 4GL to Genero 2.40).
The Database is the easy bit. I do not remember needing to change any data items. So the suggestion of exporting and re-importing is the way to go.
There are a few catches to consider if you use I4GL from SE to IDS.
The new I4GL Language is a bit more particular on some of the Gramma in the .per files and returns from functions.
If your application attempts to reference data by RowID. RowID's do not start at 1 from memory they start at 257 however this bad code should be re-worked to utilse primary keys.
If you expect to use Database Logging then you may need to add begin and commit's to your code and if you had ugly syslog inserts into systables these need to be removed.
If you use USER from an SQL query to obtain the actual user this may not have the expected result dependant on the meathod used to connect to the database.