Re: Getting started ...

>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 [snip]can somebody provide a link to the online docs [snip] Try Informix answers online: http://www.informix.com/answers/english/subject.htm Sorry but that's the only one I can help with. >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? > >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). > >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.