Re: CPYF FROMKEY/TOKEY using packed key field

Weird, Carel. I don't ever remember a problem with either of those. But who 
knows? Might have been the stars. But it's good it works now. 

-------------- Original message -------------- 

> Vern, 
> 
> My experience dates from many years ago (about 1998), perhaps on V3R2. So it 
> seems to have improved. 
> 
> Just executing a simple SELECT did not work that way. 
> 
> SQL/400 (interactive) and Query/400 would not put data in a DDS based file. 
> QMQRY and CPYFRMOPNF would. 
> 
> Just for your information. 
> 
> Regards, 
> Carel Teijgeler. 
> 
> *********** REPLY SEPARATOR *********** 
> 
> On 2-11-05 at 5:54 Vernon Hamberg wrote: 
> 
> >Unless you mean interactive SQL when you say SQL/400, there should be 
> >no difference. QM queries are simply SQL statements encapsulated in 
> >an object, so there is really no distinction here. Of course, the 
> >settings in F13 can affect things. But not because a file is built 
> >from DDS instead of SQL DDL. 
> > 
> >OTOH, there might be an issue with multiple member files, but not 
> >much - I can't say for sure, as I don't remember and can't try 
> >anything right now. 
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>