: !/bin/sh

runisql >$0.out 2>&1 <<SQLCMD0
select dc.surname, dc.firstname, dt.extension, dc.empid
from directtemplate dt, directcustom dc, wbdconf
where dt.recordno = dc.recordno
  and dt.recordno = wbdconf.recordno
  and wbdconf.passwd[1,2] != "0x"
  and wbdconf.edate is NULL
order by 1
SQLCMD0