different index types

[mverdera]

I am trying to combine into a query a DB2 table that has different field type for its index than the one I am joining to it in Oracle. How do I convert indices in Crystal so I can make a proper join.

thanks,

 

[Turkbear]

Hi,
I do not believe it is possible..Insted of using indexes to link, use the field names instead.
If the actual fields are different types, the link may still fail so you may have to find a way to combine the tables in one or the other databases prior to using the data.

 

[synapsevampire]

Why does the field type of an index matter?

Details such as your Crystal version, data types, how you are creating the query are all omitted.

A one line posting generally results in numerous posts, try providing the basics up front.

The way that most end up using disparate data is by creating Links (not imports) to the disparate databases from within MS Access, and then provide a Query in Access as the report datasource.

You'll find it a good deal faster than Crystal.

I've seen SQL Server->Oracle and DB2 in a Link Server environment working.

-k

 

[mverdera]

To clarify my original question,
we have fld1 in an table in DB2,
which we want to join to a field (say fld2) in an oracle table. One is numeric (Oracle) and the other is character. Can we use the formula command in Crstal to convert the character to numeric and join on the formula. Will this have performance issues?

thanks,

 

[synapsevampire]

To elaborate on what should have been the obvious initially, solutions depend upon the edition and version of Crystal and how you are joining these tables. Within Crystal? Standard table joining? External Code?

The worst case scenario approach would be to have the Oracle database in one report, and then in a subreport join to the db2 table, in which case you can convert the data types.

-k