Re: dbaccess problem
Posted in 2000
--- pamela <pamela_tw@hotmail.com>
> wrote:
>Hi there,
> My dababase is Informix IDS7.3. I usually use dbaccess to create table.
>There's no trouble most of the time, but sometimes I found that if I stay
>in "create table" menu for a longer period(say 5 minutes), the database
>became exclusively locked.
>
> Could anybody help me to avoid this happening again?
>
> Any message from you will be appreciated
Gee. You don't know some of us......
You have two options, one of which involves a three minute egg timer at your desk.
The better solution would be to edit a file 'tablename.sql' or something and do your table creation there. Then you can run it from the command line:
dbaccess databasename tablename.sql
or interactively from dbaccess if you wish.
I can't comment on why it might be hanging in interactive mode.
>
> best regards
Beauregards
>
>
>
>
>--
>Posted via CNET Help.com
>http://www.help.com/
==
Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be.
_____________________________________________________________
Want a new web-based email account ? ---> http://www.firstlinux.net