SQL administration API admin() and task() functions
The SQL administration API consists of two functions: admin() and task() that are defined in the sysadmin database.
These functions perform the same tasks, but return results in different formats. The task() function returns a string that describes the results of the command. The admin() function returns an integer.
By default, only user informix, can connect to the sysadmin database. If user root or a member of the DBSA group is granted privileges to connect to the sysadmin database, user root or a member of the DBSA group can also run the SQL administration API task() and admin() functions.
Run the task() or admin() function in a transaction that does not include any other statements.
BEGIN WORK;
EXECUTE FUNCTION admin("check extents");
END WORK;
EXECUTE FUNCTION admin("create dbspace","dbspace2","/work/dbspace2","20 MB");