Re: SQL files not visible in DB-ACCESS
Posted in 1996
wombn@sprynet.com wrote:
>
> > John Prideaux <alastl@ix.netcom.com> wrote:
> >. We recently upgraded from SCO 3.2.4.2 to SCO
> > }5.0, and upgraded our Informix from SE 7.10 to SE 7.12.UC1. When we enter
> > }dbaccess and attempt to select a previously saved .sql, not all of them
> > }are visible. If we enter the name of a script we know is there, it will
> > }then find it, but it still will not show up on the list (even if we then
> > }re-save the script). I am guessing that this is a problem with the SCO port
> > }of dbaccess, because our ISQL (6.03.UC1) does not behave in this manner.
> >
> >>>>
> In my environment, we've had problems with long .sql file names. Have you tried
> shortening the names?
Our file names are all 14 characters or less. In fact, all of the "missing"
files were created before our upgrade and appeared fine under our previous
Informix version.
--
-------------------------------------------------------------------------------
John Prideaux e-mail: alastl@ix.netcom.com Phone: (217)839-2121
Aladdin Steel, Inc. Fax: (217)839-4327
-------------------------------------------------------------------------------