Hi,

    I would like to send some select statement by using dbisql command. In
turn by using that command I would like to open the ISQL window by running
the SQL what I am sending as argument.

   When I try to run the DBISQL command it is running in command prompt
itself and result set is displaying in the command prompt. Could someone
tell me how to open the ISQL window and run the passing statement

   Any hint will be appreciated
Karthik

What database? For ASA, you can just launch dbisql with -c {connection info}
<sql statement>

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
iAnywhere Solutions  http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

"Karthik" <kpanc@laborfinders.com> wrote in message
news:uPk1ui9EDHA.342@forums-2-dub...
> Hi,
>
>     I would like to send some select statement by using dbisql command. In
> turn by using that command I would like to open the ISQL window by running
> the SQL what I am sending as argument.
>
>    When I try to run the DBISQL command it is running in command prompt
> itself and result set is displaying in the command prompt. Could someone
> tell me how to open the ISQL window and run the passing statement
>
>    Any hint will be appreciated
> Karthik
>
>
>
>

I am running Sybase SQL Anywhere 8. If I try to run DBISQL -c (connection
info) <sql statement> then it showing the record set in the command prompt
itself.

But I want the ISQL window to get open and to show the record set in the
ISQL window.

If possible could u please send me the exact command

Thanks
Karthik

"Chris Keating (iAnywhere Solutins)" <keating@iAnywhere.com> wrote in
message news:eamzfk9EDHA.331@forums-1-dub...
> What database? For ASA, you can just launch dbisql with -c {connection
info}
> <sql statement>
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
> iAnywhere Solutions  http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> "Karthik" <kpanc@laborfinders.com> wrote in message
> news:uPk1ui9EDHA.342@forums-2-dub...
> > Hi,
> >
> >     I would like to send some select statement by using dbisql command.
In
> > turn by using that command I would like to open the ISQL window by
running
> > the SQL what I am sending as argument.
> >
> >    When I try to run the DBISQL command it is running in command prompt
> > itself and result set is displaying in the command prompt. Could someone
> > tell me how to open the ISQL window and run the passing statement
> >
> >    Any hint will be appreciated
> > Karthik
> >
> >
> >
> >
>
>

dbisql is a non-gui implementation. Have you tried dbisqlg if you want the
gui window to get displayed.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
iAnywhere Solutions  http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

"Karthik" <kpanc@laborfinders.com> wrote in message
news:uEvu0x9EDHA.331@forums-1-dub...
> I am running Sybase SQL Anywhere 8. If I try to run DBISQL -c (connection
> info) <sql statement> then it showing the record set in the command prompt
> itself.
>
> But I want the ISQL window to get open and to show the record set in the
> ISQL window.
>
> If possible could u please send me the exact command
>
> Thanks
> Karthik
>
> "Chris Keating (iAnywhere Solutins)" <keating@iAnywhere.com> wrote in
> message news:eamzfk9EDHA.331@forums-1-dub...
> > What database? For ASA, you can just launch dbisql with -c {connection
> info}
> > <sql statement>
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> > iAnywhere Solutions  http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> > "Karthik" <kpanc@laborfinders.com> wrote in message
> > news:uPk1ui9EDHA.342@forums-2-dub...
> > > Hi,
> > >
> > >     I would like to send some select statement by using dbisql
command.
> In
> > > turn by using that command I would like to open the ISQL window by
> running
> > > the SQL what I am sending as argument.
> > >
> > >    When I try to run the DBISQL command it is running in command
prompt
> > > itself and result set is displaying in the command prompt. Could
someone
> > > tell me how to open the ISQL window and run the passing statement
> > >
> > >    Any hint will be appreciated
> > > Karthik
> > >
> > >
> > >
> > >
> >
> >
>
>

Hi Chris,

I tried that also. But the ISQL window is not opening to run the command.
Following is the command that I tried.

dbisqlc -c "dsn=dsnname" "select * from temp_table"

If there is any idea to work around with, Please let me know. All I want is
run the command in command prompt then automatically ISQL has to launch and
to run the passing sql in the ISQL window without interruption

Thanks
Karthik

"Chris Keating (iAnywhere Solutions)" <keating@iAnywhere.com> wrote in
message news:OoAg0d#EDHA.331@forums-1-dub...
> dbisql is a non-gui implementation. Have you tried dbisqlg if you want the
> gui window to get displayed.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
> iAnywhere Solutions  http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> "Karthik" <kpanc@laborfinders.com> wrote in message
> news:uEvu0x9EDHA.331@forums-1-dub...
> > I am running Sybase SQL Anywhere 8. If I try to run DBISQL -c
(connection
> > info) <sql statement> then it showing the record set in the command
prompt
> > itself.
> >
> > But I want the ISQL window to get open and to show the record set in the
> > ISQL window.
> >
> > If possible could u please send me the exact command
> >
> > Thanks
> > Karthik
> >
> > "Chris Keating (iAnywhere Solutins)" <keating@iAnywhere.com> wrote in
> > message news:eamzfk9EDHA.331@forums-1-dub...
> > > What database? For ASA, you can just launch dbisql with -c {connection
> > info}
> > > <sql statement>
> > >
> > > --
> > >
> > > Chris Keating
> > > Sybase Adaptive Server Anywhere Professional Version 8
> > > iAnywhere Solutions  http://www.iAnywhere.com
> > >
> > > ** Please only post to the newsgroup
> > >
> > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > >
> > > "Karthik" <kpanc@laborfinders.com> wrote in message
> > > news:uPk1ui9EDHA.342@forums-2-dub...
> > > > Hi,
> > > >
> > > >     I would like to send some select statement by using dbisql
> command.
> > In
> > > > turn by using that command I would like to open the ISQL window by
> > running
> > > > the SQL what I am sending as argument.
> > > >
> > > >    When I try to run the DBISQL command it is running in command
> prompt
> > > > itself and result set is displaying in the command prompt. Could
> someone
> > > > tell me how to open the ISQL window and run the passing statement
> > > >
> > > >    Any hint will be appreciated
> > > > Karthik
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Karthik

dbisqlc -c "dsn=ASA 8.0 Sample" select * from dummy

HTH
Alex Osin

Hi All,

        Thanks for the suggestions. But as u all suggested when I try to run
the command as shown below still DBISQL window is not staying as permanent.
It gets closed immediately once it get closed.

Thanks
Karthik

<Alex_Osin> wrote in message
news:D8A28188D1B29D1F006E550985256D1E.006CC75685256D1E@webforums...
> Karthik
>
> dbisqlc -c "dsn=ASA 8.0 Sample" select * from dummy
>
> HTH
> Alex Osin
>