MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 2014

Re: SQL Merge vs. CPYF MBROPT(*UPDADD)



fixed

On 03-Feb-2014 13:30 -0800, Charles Wilt wrote:
<<SNIP>> If SQL offered a *MAP *DROP <<SNIP>>

The SQL offers mapped data, implicitly. There is little difference between what native and SQL provide for mapping, as I recall.

Seems the lack of an ability for the SQL to ignore unmatched fields [by name] is the conspicuous problem. Even for that however, a dynamically built statement can easily enough resolve, given the provision of the SQL catalogs.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact