Crystal reports and db2 connectivity

Hi,

If anybody has the information and documentation about crystal reports and db2 OS/390 coinnectivity, please share with me.
I am looking for a solution implementation of crystal reports involving DB2 in OS/390 - Mainframes as backend.
Any pointers or information regarding that will be of great help.

Thanks,
Malli.,some cross-posting going on here...

see
http://www.dev-archive.com/forum/showthread.php?t=316498

Dave

Crystal Reports

HI, i am looking for some kind of a gateway where i can query the db2 on os390(mainframe) and then with the resultset i should be able to do reporting through crystal reports,can any one help me acheiving this?are you just wanting to run the report from the Crystal environment, or are you using an application written with VB or .NET??
Also, version of Crystal would be good to know, and the OS.

I can help with ODBC connection in Win OS, if you run into problems, but ideally you should first get your SysOp or DataBase admin to set up your ODBC driver and point it to the correct library files within db2.

I have just done battle with appalling and inaccurate Crystal documentation relating to connecting to AS400 running db2, via a small VB6 application that triggers automatic generation of reports in PDF format to users share on our company site. So I have some immediate experience with this minefield :-)))

Crystal documentation was misleading at best and bloody useless for the rest of the time.

Dave|||Hi,Thanks for your response.I want to use Crystal Reports itself to read the data from the DB2/os390 mainframe system.I am using crystal reports from a unix box.
Thanks
Ravi

Cross referncing databases

Does Referencing databases in queries make queries any
slower
For ex
use DB2
go
select col1 from DB1..Table1
will above be any slower than
use DB1
go
select col1 from DB1..Table1
sanjayI don't think it would make much difference in speed.. But having cross
database references does introduce a level of complexity that you might not
otherwise have... Since each database can be restored independently of the
others, they could get 'out of sync' ... leaving you with big referential
problems... So , I *try* to keep all references local whenever possible... I
have seen some major applications which have 20-30 databases for a single
app and tons of cross database references, these companies are successful in
their products, but it makes my skin crawl...
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Sanjay" <sanjayg@.hotmail.com> wrote in message
news:9a6b01c34636$605f4320$a401280a@.phx.gbl...
> Does Referencing databases in queries make queries any
> slower
> For ex
> use DB2
> go
> select col1 from DB1..Table1
> will above be any slower than
> use DB1
> go
> select col1 from DB1..Table1
> sanjay
>
>