Re: Getting started

Alex wrote: > > I just loaded Informix SE for Linux and now I'm stuck. I can't make a > connection form Informix to ApplixData. Under dbaccess I created a > couple of different database names, but don't have the foggiest idea of > how to create fields within the new database. By the way, I know nothing > about SQL . My only experience with a database is Lotus Approach. > Also, is there someone out there that could design the database I need? Others are helping you with your connectivity problems so I'll concentrate on your perceptual problems. First is nomenclature. What you called a database in Approach is known as a table in Relational Database parlance. A database is a collection of tables containing related data entities. A table is a collection of rows, or tuples, (or records in older parlance) representing a single data entity and containing related columns (or fields). So the demonstration database 'stores', included in your Informix SE distribution, contains tables representing orders, item detail for each order, customers, etc. Download the online documentation from the Informix WEB site and start with the SQL Tutorial which will explain much. You basically build new tables with the create table statement: create table <tablename> ( colname1 coltype, colname2 coltype,...); Art S. Kagel