Al Mac Wheel wrote:
My tentative approach plan:
* create logical file join-CJ1
** CMF cost master, only cost set-1 actual, joined to IIM item
master, only items of those raw classes that he wants to have actual
used in the new cost set
* create logical file join-CJ2
** CMF only cost set-2 standard with IIM all other items (than those
in join CJ1)
* in theory all items should be in join CJ1 or CJ2 except any that
lack standard or actual cost

Al,

I'm having a bit of time trying to determine what you say up there, but I
think I have the basics. You should be able to run something similar to
the following SQL:

Insert into newlib/cmf
(Select * from oldlib/cmfl01 c
Where cffac='xx' and cfcset=99 and exists (Select * from IIML01 Where
iprod=c.cfprod and iityp='X')


If you were changing the cost set identifier say from 99 to 98, then you
have to mention every field in the statement, like this:

Insert into newlib/cmf
(Select cfid, cfprod, cffac, 98, cfcbkt, cftlvl, cfplvl from
oldlib/cmfl01 c
Where cffac='xx' and cfcset=99 and exists (Select * from IIML01 Where
iprod=c.cfprod and iityp='X')


Bill



This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].