DB2/400 - business objects 
Author Message
 DB2/400 - business objects
I heard about some problems of compliance between SQL400 and SQL
standard of Business Objects, where could i get some informations ?
I have to build a datawarehouse based on AS400/DB2_400, in our
databases, it's like a garbage, we don't know what we have, and how the
databases are supplied.
I think tu rebuild a new database. This new database could supply my
datawarehouse, but i don't know what database choose for that (IBM
Universal database, Oracle, SQL Server...). I need some advice.
Thank you to reply on the forum.


Thu, 15 Feb 2001 03:00:00 GMT
 DB2/400 - business objects

The SYS* system catalog views (SYSTABLES,SYSCOLUMNS, etc)
in library QSYS2 have all the information on your current DB2/400
table objects, so you should be able to tell what you have.

The only incompatibility between DB2/400 and Business Objects that I'm aware
of is that occasionally Business Objects will generate RIGHT OUTER JOIN
syntax that DB2/400 does not yet support.  However, I was also told that the
latest version of Business Objects will not request a right outer join
from DB2/400.

Kent Milligan, DB2/400 Solutions Team
AS/400 Partners In Development

(opinions stated are not necessarily those of my employer)

Fri, 16 Feb 2001 03:00:00 GMT
 [ 2 post ] 

 Relevant Pages 

1. Business Objects with AS/400

2. AS/400 DB2/400

3. AS/400 - Seeking info on using VB to access DB2/400

4. AS/400, anyone used Delphi to access DB2/400

5. Rexx/400-DB2/400 ExecSQL/SQLCode -5032

6. Dynamic SQL for DB2/400 from RPG and/or Rexx/400

7. desire to move data from OS 390 DB2 to AS/400 DB2 using DTS

8. DB2 Newbie: Connecting to AS/400 DB2 with JDBC problems

9. db2/400 vs. db2/Solaris

10. DB2 UDB 7.2 and DB2 UDB for AS/400 V5R1

11. Difference between DB2 UDB 7.2 and DB2/400

12. DB2/400 to DB2 for Linux

Powered by phpBB® Forum Software