isql with dblib calls

isql with dblib calls

Post by XingChun Zhen » Fri, 28 Jul 1995 04:00:00



I am working on an application using sybase dblibrary within C.

I tried to use: dbcmd(dbproc, "isql -i input -o output");

could any one tell me if I can use isql in dbcmd?

thanks

xingchun Zheng

 
 
 

isql with dblib calls

Post by Ray Ste » Sat, 29 Jul 1995 04:00:00



Quote:>I am working on an application using sybase dblibrary within C.
>I tried to use: dbcmd(dbproc, "isql -i input -o output");
>could any one tell me if I can use isql in dbcmd?

Sure, why don't you try grep, yacc and ls while you're about it!

Geez.
--
----------------------------------------------------------------------
Ray A. Steel - Consultant         || AT&T Global Information Solutions
phone: (619) 485-3986             || San Diego, California.            


 
 
 

isql with dblib calls

Post by Russell Bri » Sat, 29 Jul 1995 04:00:00



Hi,  

Quote:>I tried to use: dbcmd(dbproc, "isql -i input -o output");

>could any one tell me if I can use isql in dbcmd?

Why would you want to do that for ?
isql is a program to run
from the shell level so that you can send SQL queries
to the server and see the results.

dbcmd also sends sql to the server (well you also need
a few more library calls to do the complete thing).

If you want to use isql in a program then use either
sh or csh scripting.

/Russell

>thanks

>xingchun Zheng


--
+----------------------------------------------------------+
| Ericsson Eurolab Deutschland GmbH                        |
| TMOS Development                                         |
| Ericsson Allee 1                 Phone: +49 2407 575-396 |
| 52134 Herzogenrath               Fax:   +49 2407 575-150 |
| GERMANY                          Memo:  EED.EEDRJB       |
|                                                          |
| Ballarat boy running amok in Deutschland.                |
+----------------------------------------------------------+
 
 
 

isql with dblib calls

Post by barry hannig » Mon, 31 Jul 1995 04:00:00



>I am working on an application using sybase dblibrary within C.

>I tried to use: dbcmd(dbproc, "isql -i input -o output");
>could any one tell me if I can use isql in dbcmd?

from the looks of this question, i'd suggest you avoid this subject
altogether.

barry

 
 
 

isql with dblib calls

Post by David Zuckma » Mon, 31 Jul 1995 04:00:00




>>I am working on an application using sybase dblibrary within C.

>>I tried to use: dbcmd(dbproc, "isql -i input -o output");
>>could any one tell me if I can use isql in dbcmd?

>from the looks of this question, i'd suggest you avoid this subject
>altogether.

XingChun,

In other words, No, you can't do that.

The second parameter to dbcmd() must be a character-string of SQL.

For example, this is valid:

    dbcmd(dbproc, "select EmployeeID, EmployeeName from Employee");

If you want to execute some pre-defined SQL, create a stored procedure
and execute that.

If, for some reason, you want your client to execute an ISQL session
(and you're running Unix), you can use the system() command:

    system("isql -U user -P password -i input -o output");

Note that the only way your client will be able to use the output file
will be to open and read the file.

Good luck!

--David A. Zuckman
=======================================================================
How to ride:  Sit on horse.  Listen to your instincts.  Do the opposite
of what they say.

 
 
 

isql with dblib calls

Post by Philippe Vo cong t » Sun, 06 Aug 1995 04:00:00


Dear A.Zuckman,

Many thks for answering nicely to a fellow
next door to you (it's the way I see it,if
I was sitting at a point of view,let's
say, 4 light years from Mother Earth).
Regards,

Philippe Vo cong tri.

 
 
 

isql with dblib calls

Post by Federal Reserve Bank Of Atlan » Tue, 08 Aug 1995 04:00:00



: Dear A.Zuckman,

: Many thks for answering nicely to a fellow
: next door to you (it's the way I see it,if
: I was sitting at a point of view,let's
: say, 4 light years from Mother Earth).
: Regards,

: Philippe Vo cong tri.

Philippe,
    Sorry your questions wasn't received too well.  Hang in there.

 
 
 

1. isql, dblib, netlib for linux?

simply put, do such critters exist?  if so, where might one find them?
if not, are there any plans to give them life? :)

        thanks,
        pat----

--
Patrick R. Sklenar      |             IS Technical Services            |
United HealthCare Corp. |         Database Products and Support        |
450 Columbus Blvd.  6GB | Distributed Database Product Support Analyst |
Hartford, CT 06115-0450 |                                              |
UHC Route No. CT30-1030 | voice: (860) 702-5845    fax: (860) 702-5853 |
-----------------------------------------------------------------------|

2. Referential Integrity Questions

3. use ODBC or dblib calls

4. Unidata ODBC and MS Access

5. Using DBLIB to call sp_executesql

6. Autonumber

7. blocking dblib calls from visual basic

8. Backup & Log Truncation

9. asynchronous dblib calls

10. blocking dblib calls from visual basic

11. Blocking behaviour dblib calls from visual basic