Re: Getting started ...
From: "newswest.sybase.com" <spamoff_fishburn@sybase.com>
>
>Unfortunately, after I installed informix on my laptop to learn how to use
>it, it appears that none of the Help files were installed. I have lots and
>lots of release notes, but nothing that tells me how to use it.
>
>Could some one problem me with 1 or 2 line answer to some of these really
>simple questions (which will be a really good headstart).
>
>1. Online documentation
> I went here: http://www.informix.com/documentation/
You should have gone here: http://www.informix.com/answers/
>But I got lost in install pages, can somebody provide a link to the online
>docs (for example, admin guide, getting started, ...)
>
>2. I am very familiar with databases, have used Oracle, Sybase, IBM and
>Microsoft.
>How do I write a SQL script and run it against the database?
>MSS has ISQL.exe -i file_name
>IBM - db2 command
>
>How do you call the command line tool to run a script for Informix?
dbaccess dbname scriptname
>3. How to to embedded multiple statements...
>Some tools use semi-colons, Sybase and MSS use "go"
>creat table dave (c1 int);
>insert into dave values (1);>commit
;
>4. Are stored procedures and triggers supported, does anyone have a quick
>example (or help file location).
Yes. Check out the sql syntax guide.
>5. How do you specify column defaults...
>create table dave (
>id integer default autoincrement,
>last_modified timestamp default timestamp,
>primary key (id)
>);>
>How would you do the above in Informix, autoincrement will insert a (MAX +
>1) automatically for you.
>last_modified will automatically default to todays date.
Serial and current, respectively...
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com