dbTalk Databases Forums  

ISQL problem

comp.databases.informix comp.databases.informix


Discuss ISQL problem in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Cats
 
Posts: n/a

Default ISQL problem - 05-12-2011 , 11:15 AM






Am having a problem with isql on a SPARC Solaris 10 box.

If I load isql:
Quote:
isql -v
IBM INFORMIX-SQL Version 7.50.FC4
Software Serial Number RDS#N000000

Quote:
isql lgh
The menu displays correctly:
IBM INFORMIX-SQL: Form Report Query-Language User-menu
Database ...
Run, Modify, Create, or Drop a form.
--------------------- lgh ---------------------- Press CTRL-W for Help
--------

If I select Form then Run (or Report then Run, or Query-Language then
Run) all previous versions have displayed a list of (respectively)
all the .frm files, the .arc files or the .sql files in the
directories listed in $DBPATH, and also from the cwd. None are being
listed.

With Query-Language, Run there is an error message:
SQL: New Run Modify Use-editor Output Choose Save Info Drop
Exit
Run the current SQL statements.
--------------------- lgh ---------------------- Press CTRL-W for Help
--------
823: There are no statements to run.

This doesn't happen with Form or Report.

If they type the name in manually it is fine - it finds and runs the
Form / Report / Query. $DBPATH looks to be set correctly.

Any clues, anyone?

BTW this is a new installation - the machine was wiped, Solaris 10
installed, then IDS11 and ISQL, then we restored the programs which
are Genero.

Reply With Quote
  #2  
Old   
LIGHT SCANS
 
Posts: n/a

Default Re: ISQL problem - 05-12-2011 , 04:33 PM






It has been over a decade since I used isql but I'm guessing the files
only show up when your run isql in the same directory where the files
exist.

Otherwise it might be an isql bug on Solaris 10.

-LS

Reply With Quote
  #3  
Old   
Fernando Nunes
 
Posts: n/a

Default Re: ISQL problem - 05-12-2011 , 05:23 PM



It's probably a known bug in the client SDK that was used to compile that
version.
Installing a more recently version of ClientSDK could solve that but I've
seen reports that may lead to others.
7.50.FC5 should be already available, or if not FC3 will solve your problem.
For more details please contact tech support through a PMR.

Regards.

On Thu, May 12, 2011 at 5:15 PM, Cats <ramwater (AT) uk2 (DOT) net> wrote:

Quote:
Am having a problem with isql on a SPARC Solaris 10 box.

If I load isql:
isql -v
IBM INFORMIX-SQL Version 7.50.FC4
Software Serial Number RDS#N000000

isql lgh

The menu displays correctly:
IBM INFORMIX-SQL: Form Report Query-Language User-menu
Database ...
Run, Modify, Create, or Drop a form.
--------------------- lgh ---------------------- Press CTRL-W for Help
--------

If I select Form then Run (or Report then Run, or Query-Language then
Run) all previous versions have displayed a list of (respectively)
all the .frm files, the .arc files or the .sql files in the
directories listed in $DBPATH, and also from the cwd. None are being
listed.

With Query-Language, Run there is an error message:
SQL: New Run Modify Use-editor Output Choose Save Info Drop
Exit
Run the current SQL statements.
--------------------- lgh ---------------------- Press CTRL-W for Help
--------
823: There are no statements to run.

This doesn't happen with Form or Report.

If they type the name in manually it is fine - it finds and runs the
Form / Report / Query. $DBPATH looks to be set correctly.

Any clues, anyone?

BTW this is a new installation - the machine was wiped, Solaris 10
installed, then IDS11 and ISQL, then we restored the programs which
are Genero.
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list



--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Reply With Quote
  #4  
Old   
Cats
 
Posts: n/a

Default Re: ISQL problem - 05-13-2011 , 01:36 AM



On May 12, 11:23*pm, Fernando Nunes <domusonl... (AT) gmail (DOT) com> wrote:
Quote:
It's probably a known bug in the client SDK that was used to compile that
version.
Installing a more recently version of ClientSDK could solve that but I've
seen reports that may lead to others.
7.50.FC5 should be already available, or if not FC3 will solve your problem.
For more details please contact tech support through a PMR.

Regards.





On Thu, May 12, 2011 at 5:15 PM, Cats <ramwa... (AT) uk2 (DOT) net> wrote:
Am having a problem with isql on a SPARC Solaris 10 box.

If I load isql:
isql -v
IBM INFORMIX-SQL Version * 7.50.FC4
Software Serial Number RDS#N000000

isql lgh

The menu displays correctly:
IBM INFORMIX-SQL: * Form *Report *Query-Language *User-menu
Database *...
Run, Modify, Create, or Drop a form.
--------------------- lgh ---------------------- Press CTRL-W for Help
--------

If I select Form then Run (or Report then Run, or Query-Language then
Run) all previous versions have displayed *a list of (respectively)
all the .frm files, the .arc files or the .sql files in the
directories listed in $DBPATH, and also from the cwd. *None are being
listed.

With Query-Language, Run there is an error message:
SQL: * New *Run *Modify *Use-editor *Output *Choose *Save*Info *Drop
Exit
Run the current SQL statements.
--------------------- lgh ---------------------- Press CTRL-W for Help
--------
* 823: There are no statements to run.

This doesn't happen with Form or Report.

If they type the name in manually it is fine - it finds and runs the
Form / Report / Query. *$DBPATH looks to be set correctly.

Any clues, anyone?

BTW this is a new installation - the machine was wiped, Solaris 10
installed, then IDS11 and ISQL, then we restored the programs which
are Genero.
_______________________________________________
Informix-list mailing list
Informix-l... (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...- Hide quoted text -

- Show quoted text -
I have also taken this up with the chap that provided the download for
me. The Client SDK isn't installed on the machine we have this
problem on. Asking here was a long shot incase anyone had had the
problem.

But thanks to all.

Reply With Quote
  #5  
Old   
Cats
 
Posts: n/a

Default Re: ISQL problem - 06-08-2011 , 04:19 AM



On May 13, 7:36*am, Cats <ramwa... (AT) uk2 (DOT) net> wrote:
Quote:
On May 12, 11:23*pm, Fernando Nunes <domusonl... (AT) gmail (DOT) com> wrote:





It's probably a known bug in the client SDK that was used to compile that
version.
Installing a more recently version of ClientSDK could solve that but I've
seen reports that may lead to others.
7.50.FC5 should be already available, or if not FC3 will solve your problem.
For more details please contact tech support through a PMR.

Regards.

On Thu, May 12, 2011 at 5:15 PM, Cats <ramwa... (AT) uk2 (DOT) net> wrote:
Am having a problem with isql on a SPARC Solaris 10 box.

If I load isql:
isql -v
IBM INFORMIX-SQL Version * 7.50.FC4
Software Serial Number RDS#N000000

isql lgh

The menu displays correctly:
IBM INFORMIX-SQL: * Form *Report *Query-Language *User-menu
Database *...
Run, Modify, Create, or Drop a form.
--------------------- lgh ---------------------- Press CTRL-W for Help
--------

If I select Form then Run (or Report then Run, or Query-Language then
Run) all previous versions have displayed *a list of (respectively)
all the .frm files, the .arc files or the .sql files in the
directories listed in $DBPATH, and also from the cwd. *None are being
listed.

With Query-Language, Run there is an error message:
SQL: * New *Run *Modify *Use-editor *Output *Choose *Save *Info *Drop
Exit
Run the current SQL statements.
--------------------- lgh ---------------------- Press CTRL-W for Help
--------
* 823: There are no statements to run.

This doesn't happen with Form or Report.

If they type the name in manually it is fine - it finds and runs the
Form / Report / Query. *$DBPATH looks to be set correctly.

Any clues, anyone?

BTW this is a new installation - the machine was wiped, Solaris 10
installed, then IDS11 and ISQL, then we restored the programs which
are Genero.
_______________________________________________
Informix-list mailing list
Informix-l... (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...- Hide quoted text -

- Show quoted text -

I have also taken this up with the chap that provided the download for
me. *The Client SDK isn't installed on the machine we have this
problem on. *Asking here was a long shot incase anyone had had the
problem.

But thanks to all.- Hide quoted text -

- Show quoted text -
OK, it was a problem with the CSDK it was compilled with, and since I
downloaded that version a newer one has come along that has fixed the
problem.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.