Alternative command using i4gl instead of isql

Alternative command using i4gl instead of isql

Post by John T. Fontanil » Fri, 18 Mar 1994 06:16:35



Hello there,

I'm having a problem determining the right command to use in place of isql.
Right now, I'm using this:

$ isql dbase-name file.sql

file.sql contains the following line:
select * from table-name where column1 = 1

Is there another way of doing this command via i4gl from the command
prompt instead of going thru the menu selecting 'Q'uery-language,
selecting the database, selecting 'N'ew? What I need is something similar to:

$ i4gl ??????

We have the I-SQL and the STANDARD ENGINE version 4.00. (C-compiler version)

Pls. email me if you know the answer! Thanks.
--
John Fontanilla       |  Work: (203) 790-9921 AOH: (203) 350-3841

100 Mill Plain Rd.    | Views expressed does not reflect that of my employers.
Danbury, CT 08611     | Maligayang bati sa inyo!!! :)

 
 
 

Alternative command using i4gl instead of isql

Post by Bob Beaulieu - EZ Trav » Fri, 18 Mar 1994 16:10:43



Quote:>Hello there,

>I'm having a problem determining the right command to use in place of isql.
>Right now, I'm using this:

>$ isql dbase-name file.sql

>file.sql contains the following line:
>select * from table-name where column1 = 1

>Is there another way of doing this command via i4gl from the command
>prompt instead of going thru the menu selecting 'Q'uery-language,
>selecting the database, selecting 'N'ew? What I need is something similar to:

>$ i4gl ??????

>We have the I-SQL and the STANDARD ENGINE version 4.00. (C-compiler version)

John,

Its going to be tough using i4gl if you don't have it ;)

Since you have a '$' prompt, I'm assuming you are on a UNIX system. In which
case, you could create a shell script to handle your query:

:
#!/bin/sh
#(#) myfile

echo "Enter a value to search for > \c"
read VALUE

isql database_name - 2>/tmp/trash <<EOF
select   *
from     table_name
where    column_name = "$VALUE";
EOF

You mention a C compiler version. If you have ESQL/C, then you could also
use your own c routines.

Bob

>Pls. email me if you know the answer! Thanks.
>--
>John Fontanilla       |  Work: (203) 790-9921 AOH: (203) 350-3841

>100 Mill Plain Rd.    | Views expressed does not reflect that of my employers.
>Danbury, CT 08611     | Maligayang bati sa inyo!!! :)

--
     -------------------------------------------------------------------

    *   Tel: 408-978-0808                          Fax: 408-978-7024    *
    *                    Corporate Travel Services                      *
     -------------------------------------------------------------------

 
 
 

1. Looking for isql alternative with command line editing...

Sorry this could be considered off topic...

I once had the source to a version of isql which had command line
editing in the same way as ksh. Can anyone remind me what it was
called, or better still, tell me where I can get it.

Thanks in advance....
-----------

IMO Systems Ltd.

2. SQL7 Online Courses!

3. Current Uses of ISQL, I4GL

4. VB 6.0 Access 2.0

5. command line instead of isql

6. Row IDs in v5.x--was Hopeful No-brainer

7. Using char/varchar variable instead of object names when issuing DML commands

8. Bug in GENXTAB... can't call by Reference

9. send params into sql file using isql command?

10. REPLICATION PROBLEM 6.5 USING ISQL COMMAND

11. using switch /c in ISQL command line

12. I4gl Version 1.10.03J Isql Version 2.10.03j

13. i4gl ; isql