Re: CCSID and SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Michel-Claude

Great question.

My guess is that SQL uses intermediate results, translating the fields in 
question as needed. DDS files need to match - is there a keyword for CCSID 
at field level - I forget.

Of course, a multi-format logical is not the same as JOIN in SQL - the 
logical is more like an SQL UNION. My assumption fits the UNION scenario 
better.

Regards

Vern

At 10:56 AM 8/5/2003 +0200, you wrote:
> We encountered the following problem:
>
> We try to create a logical file with multi-format (I know, it is not the
> best way). The first physical file referenced by the logical one, has a
> CCSID of 500, and the second one has a CCSID of 297. So the creation abort
> with a CPF or CPD error. That's normal. To be able to create the
> multi-format, we have to accord both physical file CCSID first. That's what
> we do now.
>
> My question is the following:
> SQL join request is able to work on two different CCSID physical file, if
> the join fields are identical. Why is it not possible with DDS multi format?
>
> Michel-Claude Ducrest
> tel. +41 21 924 16 14
> fax +41 21 924 2882