Re: dbaccess: the only SQL option?!
On Mon, 17 Nov 1997, Andreas Zeugswetter wrote:
} Al Wang wrote:
} >=20
} > I've just recently begun to play around with Informix Universal
} > Server, and while I am very impressed with the technology under the
} > hood, I'm kind of dismayed by the interface, in terms of database
} > creation: is the only way to enter SQL statements through dbaccess's
} > menu system? This seems horribly inefficient. Is there no sort of
} > command-line SQL parser like for Oracle? Are there no online help
} > features? Can the SQL error messages be any less helpful?
} >=20
} > I'm probably just missing the boat entirely on how to do this stuff
} > effectively, so I'd appreciate it if someone could set me straight.
}=20
} you can use:
}=20
} dbaccess <database> -
}=20
} which gives you a command line. But I agree it is still horrible.
You could consider using SQLCMD from the IIUG archives, but it hasn't
yet been updated to handle the IUS data types so it probably isn't as
helpful as you'd like.
It is the tool I use for accessing databases from the command line;
it's sole raison d'=EAtre is that DB-Access and ISQL are not suitable
for use in shell scripts and the like.
Yours,
Jonathan Leffler (johnl@informix.com) #include <witticism.h>
PS: But yes, I'm biassed because I wrote it.
PPS: And my name's not Sam, either... :-))