PHP Code:
EXEC SQL
INSERT INTO ENTPART (IRS#,ITEM#,OKAYTOUSE,HTS#1,HTS#2,HTS#3,
DESC,UNT$,WGTLN,PCLS,PRDCD,COMM1,COMM2,COMM3,COMM4,COMM5,
COMM6) SELECT DISTINCT (SELECT IRS#CS FROM CUSTHEAD
where CUS#CS = $S_CUSTF
EXEC SQL
INSERT INTO ENTPART (IRS#,ITEM#,OKAYTOUSE,HTS#1,HTS#2,HTS#3,
DESC,UNT$,WGTLN,PCLS,PRDCD,COMM1,COMM2,COMM3,COMM4,COMM5,
COMM6) SELECT DISTINCT (SELECT IRS#CS FROM CUSTHEAD
where CUS#CS = $S_CUSTF
INSERT INTO ITEMS2 (PROGRAM, VLDFILE, VLDFLD, SELFILE, SELFLD) VALUES(:SCAPP , 'CSTMR', 'CYC', 'BYC', 'BYCC');