soliddb db2 sql conformance?

This is a discussion on soliddb db2 sql conformance? within the ibm-db2 forums in Other Databases category; Has anyone any experience in using SolidDB as a cache for DB2? I'm mostly interested in how much - if any - sql that had to be rewritten because it was not supported. The database I'm considering is small, but the queries against it involves CTE's, OLAP functions etc. I'm in the process of installing a try-out version, but if anyone already have some experience on the subject it would be great. /Lennart...

Go Back   Database Forum > Other Databases > ibm-db2

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-27-2008, 03:15 AM
Default soliddb db2 sql conformance?


Has anyone any experience in using SolidDB as a cache for DB2? I'm
mostly interested in how much - if any - sql that had to be rewritten
because it was not supported. The database I'm considering is small,
but the queries against it involves CTE's, OLAP functions etc. I'm in
the process of installing a try-out version, but if anyone already
have some experience on the subject it would be great.


/Lennart
Reply With Quote
  #2  
Old 08-27-2008, 05:49 AM
Default Re: soliddb db2 sql conformance?

On Aug 27, 8:15*am, Lennart wrote:
> Has anyone any experience in using SolidDB as a cache for DB2? I'm
> mostly interested in how much - if any - sql that had to be rewritten
> because it was not supported. The database I'm considering is small,
> but the queries against it involves CTE's, OLAP functions etc. I'm in
> the process of installing a try-out version, but if anyone already
> have some experience on the subject it would be great.
>


I've found an sql reference:

http://www.solidtech.com/developers/...de.html#select

/Lennart
Reply With Quote
  #3  
Old 08-27-2008, 06:12 AM
Default Re: soliddb db2 sql conformance?

Documentation:

http://www-01.ibm.com/support/docvie...=utf-8&lang=en

Sincerely,
Mark B.
Reply With Quote
  #4  
Old 08-27-2008, 12:50 PM
Default Re: soliddb db2 sql conformance?

On Aug 27, 11:12*am, 4.s...@mail.ru wrote:
> Documentation:
>
> http://www-01.ibm.com/support/docvie...xt=SSPK3V&dc=D...
>


Thanks, I looked through both this and the link in my last post and it
appers as if I will have to rewrite a bunch of queries if I'm going to
use SolidDB as a cache.

/Lennart

Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 01:17 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.