A bug was filed against RDO for the installation of Keystone v3. This guide is designed to walk you through the configuration for using Keystone v3 with Packstack. You will accomplish this using various repos and the Answers file.
UPDATE imports SET imports.AMIPartNumber = coalesce(AMIA.Item,AMIB.Item,AMIC.Item,AMID.Item,AMIE.Item,AMIF.Item,AMIG.Item,AMIH.Item,AMII.Item,AMIJ.Item), Imports.AMIDescription = coalesce(AMIA.Description,AMIB.Description,AMIC.Description,AMID.Description,AMIE.Description,AMIF.Description,AMIG.Description,AMIH.Description,AMII.Description,AMIJ.Description) FROM imports as I LEFT JOIN JD as JDA ON I.OEMPartNumber = JDA.OEMPartNumber LEFT JOIN amipartnumbers as AMIA ON JDA.OEMPartNumber = AMIA.OEMItem LEFT JOIN JD as JDB ON I.OEMPartNumber = JDB.OEMSubNumber LEFT JOIN amipartnumbers as AMIB ON JDB.OEMSubNumber = AMIB.OEMItem LEFT JOIN JD as JDC ON I.OEMPartNumber = JDC.OEMSubNumber2 LEFT JOIN amipartnumbers as AMIC ON JDB.OEMSubNumber2 = AMIC.OEMItem LEFT JOIN JD as JDD ON I.OEMPartNumber = JDD.OEMSubNumber3 LEFT JOIN amipartnumbers as AMID ON JDB.OEMSubNumber2 = AMID.OEMItem LEFT JOIN JD as JDE ON I.OEMPartNumber = JDE.OEMSubNumber4 LEFT JOIN amipartnumbers as AMIE ON JDB.OEMSubNumber2 = AMIE.OEMItem LEFT JOIN JD as JDF ON I.OEMPartNumber = JDF.OEMSubNumber5 LEFT JOIN amipartnumbers as AMIF ON JDB.OEMSubNumber2 = AMIF.OEMItem LEFT JOIN JD as JDG ON I.OEMPartNumber = JDG.OEMSubNumber6 LEFT JOIN amipartnumbers as AMIG ON JDB.OEMSubNumber2 = AMIG.OEMItem LEFT JOIN JD as JDH ON I.OEMPartNumber = JDH.OEMSubNumber7 LEFT JOIN amipartnumbers as AMIH ON JDB.OEMSubNumber2 = AMIH.OEMItem LEFT JOIN JD as JDI ON I.OEMPartNumber = JDI.OEMSubNumber8 LEFT JOIN amipartnumbers as AMII ON JDB.OEMSubNumber2 = AMII.OEMItem LEFT JOIN JD as JDJ ON I.OEMPartNumber = JDJ.OEMSubNumber9 LEFT JOIN amipartnumbers as AMIJ ON JDB.OEMSubNumber2 = AMIJ.OEMItem ; select * from imports
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.