CUCCX - Learning Informix and SQL Database queries

[shikamarunara]

Hello,

     I'm currently working on expanding my knowledge outside of CUCCX programming and administration and would like to work more on the database side of things.  CUCCX uses Informix and I would like to learn exactly how I can do queries off of it.  My hope is to eventually take the output of those queries to generate stats on a wall board.  Frankly, I don't know much about databases besides what people tell me (that they're basically just really big spreadsheets).  I would like to know what kind of resources I should read and use to learn more about Informix queries from a newbie's point of view and hopefully be able to expand that into SQL.  Any guidance or direction is greatly appreciated.

[Gergely Szabo · Accepted solution]

Hi,

first, download a copy of MySQL server. Read and understand the tutorial. Try to create and populate some database tables with the INSERT statement. Try to do some simple queries using SELECT. Then UPDATEs. Then JOINs.

Then grab a normal IDE, for example, Eclipse or anything that is able to communicate using JDBC with Informix. Connect to the UCCX database. Read and understand the "Database Schema Guide" document for your UCCX version, available on the Support subspace of cisco.com.

It'll take a couple of weeks. Don't get scared, if you want to understand things, it usually takes some time.

G.

[shikamarunara]

Thank you very much, kind sir.  I appreciate the feedback and will definitely try this.  Thanks again.