su - informix
Change user role to 'informix' which is a built in Linux user to access the Informix database.
dbaccess $(dblutil -c) -
dbaccess is a SQL client to access Informix database. 'dblutil' is a DB role.
select * from licenseinfo
A standard SQL command to view all records in 'licenseinfo' table.
- Press Ctrl-D to execute SQL commands
- Press Ctrl-C to exit
- On some terminals, you may have to press Delete to Backspace
To list all tables:
select tabname from systables where tabid > 99 and tabtype = "T"
Grab a some books like "SQL for Dummies" and test in your lab.
I wondered what does this do? ;)