keywordfile="keyword.txt"
/usr/xpg4/bin/awk    'BEGIN          {CAT["rdf"]="REPORT"                
                         CAT["fmb"]="FORM"                 
                         CAT["sql"]="SQL FILE"                 
                         CAT["pll"]="Library File"                 
                         CAT["ctl"]="Control File"                 
                         CAT["sh"]= "Shell script"                
                        }
         FNR == NR      {KY[$0]; next}                                  # read in all the keywords
         FNR == 1 && FN {EXT = FN; sub (/.*\./,".", EXT)                # if new file, obtain the extension
                         for (i in MCNT)                                # for all matches,
                           print FN, i, MCNT[i], EXT, CAT[EXT]          # print out the old values 
                         FN = FILENAME                                  # retain FILENAME for next loop
                        }
                        {for (i in KY) if ($0 ~ i) MCNT[i]++}           # find matching keywords in each line
         END            {EXT = FN; sub (/.*\./,".", EXT)                # same as above for last file
                         for (i in MCNT) 
                           print FN, i, MCNT[i], EXT, CAT[EXT]
                        }
        ' $keywordfile `/usr/xpg4/bin/find /usr/tmp/SB -type f -name "*.rdf" -o -name "*.fmb" -o -name "*.pll" -o -name "*.ctl" -o -name "*.sh" -o -name "*.sql" -o -name "*.prog"`

/usr/xpg4/bin/awk: line 16 (NR=7758): /DR$PV_ENTY_ATTR_TEXTS_U2$R/: unknown regex error