Add JSON compatibility to databases that were created in 12.10.xC1

Databases that were created in Informix® 12.10.xC1 are not JSON compatible. In 12.10.xC2 or 12.10.xC3 you can run a script to make those databases JSON compatible. You do not have to run the script after you upgrade to 12.10.xC4 or later fixpacks because all databases are made JSON compatible during conversion.

This procedure requires Informix 12.10.xC2 or 12.10.xC3.

You must run the script as user informix or as a user with DBA privileges.

Run the appropriate script against a database that was created in Informix 12.10.xC1 to make the database JSON compatible.

Informix 12.10.xC3: convTovNoSQL1210.sql
Informix 12.10.xC2: convTovNoSQL1210X2.sql

For example, to make the db_name database JSON compatible in Informix 12.10.xC3, you would run the following command as user informix or as a user with DBA privileges:

UNIX: dbaccess -e db_name $INFORMIXDIR/etc/convTovNoSQL1210.sql
Windows: dbaccess -e db_name %INFORMIXDIR%\etc\convTovNoSQL1210.sql