Hi,

Can JDBC be used to connect to a local (SCO Openserver) SE5, and if so,
can it be done without using I-NET sqlexecd?

Rod
rod@transmit.com.au

----- Original Message -----
From: <Darren_Jacobs@carmax.com>
To: "Keith Simmons" <smiley73@googlemail.com>
Cc: <informix-list@iiug.org>
Sent: Friday, September 29, 2006 4:24 AM
Subject: Re: SQL Server and IDS


> select @sql="some dynamic query with parameters"
> exec sql
>
> example using openquery:
> select @sql = 'select * from openquery(<linked server>,
> ''SELECT col1,
> col2,
> col3,
> ......
> FROM tabname
> WHERE col1 = "' + @<somevariable> +
'"'')'
>
> /* insert into a temp table with results from the remote command */
> INSERT INTO #temptable
> EXEC sp_executesql @sql
>
> You could substitute the openquery with a four part naming convention and
> execute the @sql variable. Four part naming is generally slower than
> openquery but I only believe on the connecting side.
>
>
>
>
> "Keith Simmons"
> <smiley73@googlem
> ail.com> To
> Sent by: informix-list@iiug.org
> informix-list-bou cc
> nces@iiug.org
> Subject
> SQL Server and IDS
> 09/28/2006 10:02
> AM
>
>
>
>
>
>
>
>
> My application programmers have a requirement to run parametised
> queries from SQL Server/Access against an IDS 9.4 engine on AIX. Using
> IBM ODBC drivers isn't working as SQL Server seems to insist on
> pulling entire tables back and filtering itself. openquery() is not an
> option as its queries cannot be parametised or built 'on the fly'.
> Anyone encountered a similar problem? How did you reslove it, any
> product known that handles this type of connection more gracefully
> allowing IDS to do its work and just return the results of a query?
>
> Keith
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>

Nope, you need the Inet connectivity as far as I know

Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com

GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 European Conference.
Vienna, Austria. 2-6 October 2006
Visit http://www.iiug.org/conf for more information.




> -----Original Message-----
> From: Rodney Sheppard [mailto:rod@transmit.com.au]
> Posted At: 28 September 2006 21:23
> Posted To: comp.databases.informix
> Conversation: JDBC and SE5
> Subject: JDBC and SE5
>
>
> Hi,
>
> Can JDBC be used to connect to a local (SCO Openserver) SE5,
> and if so, can it be done without using I-NET sqlexecd?
>
> Rod
> rod@transmit.com.au
>
> ----- Original Message -----
> From: <Darren_Jacobs@carmax.com>
> To: "Keith Simmons" <smiley73@googlemail.com>
> Cc: <informix-list@iiug.org>
> Sent: Friday, September 29, 2006 4:24 AM
> Subject: Re: SQL Server and IDS
>
>
> > select @sql="some dynamic query with parameters"
> > exec sql
> >
> > example using openquery:
> > select @sql = 'select * from openquery(<linked server>,
> > ''SELECT col1,
> > col2,
> > col3,
> > ......
> > FROM tabname
> > WHERE col1 = "' + @<somevariable> +
> '"'')'
> >
> > /* insert into a temp table with results from the remote command */
> > INSERT INTO #temptable
> > EXEC sp_executesql @sql
> >
> > You could substitute the openquery with a four part naming
> convention
> > and execute the @sql variable. Four part naming is
> generally slower
> > than openquery but I only believe on the connecting side.
> >
> >
> >
> >
> > "Keith Simmons"
> > <smiley73@googlem
> > ail.com>
> To
> > Sent by: informix-list@iiug.org
> > informix-list-bou
> cc
> > nces@iiug.org
> >
> Subject
> > SQL Server and IDS
> > 09/28/2006 10:02
> > AM
> >
> >
> >
> >
> >
> >
> >
> >
> > My application programmers have a requirement to run parametised
> > queries from SQL Server/Access against an IDS 9.4 engine on
> AIX. Using
> > IBM ODBC drivers isn't working as SQL Server seems to insist on
> > pulling entire tables back and filtering itself.
> openquery() is not an
> > option as its queries cannot be parametised or built 'on the fly'.
> > Anyone encountered a similar problem? How did you reslove it, any
> > product known that handles this type of connection more gracefully
> > allowing IDS to do its work and just return the results of a query?
> >
> > Keith
> > _______________________________________________
> > Informix-list mailing list
> > Informix-list@iiug.org
> > http://www.iiug.org/mailman/listinfo/informix-list
> >
> >
> > _______________________________________________
> > Informix-list mailing list
> > Informix-list@iiug.org
> > http://www.iiug.org/mailman/listinfo/informix-list
> >
>