Listing 1

table(
column=(type=char(20) updatewhereclause=yes name=emp_lname dbname="employee.emp_lname" )
column=(type=char(20) updatewhereclause=yes name=emp_fname dbname="employee.emp_fname")
column=(type=decimal(3) updatewhereclause=yes name=salary 
dbname="employee.salary")

retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"employee~" )
COLUMN(NAME=~"employee.emp_lname~") 
COLUMN(NAME=~"employee.emp_fname~") 
COLUMN(NAME=~"employee.salary~")
WHERE( EXP1 =~"~~~"employee~~~".~~~"state~~~"~" OP =~"=~" EXP2 =~"'TX'~" ) )
ORDER(NAME=~"employee.emp_lname~" ASC=yes ) "
)




Listing 2

text(band=header alignment="0" text="Emp Fname" border="0" color="33554432"
x="654" y="172" height="56" width="576" html.valueishtml="0"
name=emp_fname_t visible="1" font.face="Arial" font.height="-8" font.weight="700"
font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )

column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="33554432"
x="73" y="4" height="60" width="576" format="[general]" html.valueishtml="0"
name=emp_lname visible="1" edit.limit=20 edit.case=any edit.autoselect=yes
edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-8" font.weight="400"
font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )

line(band=header x1="73" y1="248" x2="1559" y2="248" name=l_1 visible="1" pen.style="0"
pen.width="5" pen.color="33554432" background.mode="2" background.color="1073741824" )




Listing 3

compute(band=header alignment="1" expression="'Page ' + page() + ' of ' + pageCount()"border="0"
color="33554432" x="1157" y="24" height="88" width="466" format="[general]"
html.valueishtml="0" name=page_1 visible="1" font.face="Arial" font.height="-10"
font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )




Listing 4

dw_1.Modify("create compute(band=header alignment=~"1~" expression=~"'Page ' + page() + ' of '
+ pageCount()~"border=~"0~" color=~"33554432~" x=~"1157~" y=~"24~" height=~"88~"
width=~"466~" format=~"[general]~" html.valueishtml=~"0~" name=page_1 visible=~"1~"
font.face=~"Arial~" font.height=~"-10~" font.weight=~"400~" font.family=~"2~" font.pitch=~"2~"
font.charset=~"0~" background.mode=~"2~" background.color=~"1073741824~" )")




Listing 5

dw_1.Modify("destroy compute(band=header alignment=~"1~" expression=~"'Page ' + page() + ' of
' + pageCount()~"border=~"0~" color=~"33554432~" x=~"1157~" y=~"24~" height=~"88~"
width=~"466~" format=~"[general]~" html.valueishtml=~"0~" name=page_1 visible=~"1~"
font.face=~"Arial~" font.height=~"-10~" font.weight=~"400~" font.family=~"2~" font.pitch=~"2~"
font.charset=~"0~" background.mode=~"2~" background.color=~"1073741824~" )")