WAM095 - LOB Data Types and Stream Files
1. Create a new WAM:
Description: Display Employee Documents
Layout Weblet: iiilay01
2. Define your WAM based on the following logic:
PRIFILRRN should be a hidden field.
- Clear list DOCLIST
- Fetch fields for group_by EMPDATA from file PSLMST with the key EMPNO
- FULLNAME = GIVENAME + ', ' + SURNAME
- Select field DF_ELFNAM from the file DXDOCS with the key 'DEM_ORG_SEC_EMP', DEPTMENT, SECTION, EMPNO and return relative record number to PRIFILRRN
Add entry to DOCLIST
- End of select
Note: The field DX_ELBLOB returns the file into a local temporary directory, using an 8.3 filename. For example:C:\DOCUME~1\pcuser\LOCALS~1\Temp\lobuser\pcuser\5152\dxdocs\dx_elblob\contract.pdf
This path may be defined by the LPTH=directory run time parameter. If the LPTH parameter is not defined, the path used will be the TPTH setting. The default value for this path is the user's temporary path, for example: C:\Users\John\AppData\Local\Temp
This can be quickly found using %temp% in the Explorer address bar.
For further information, refer to the Standard X_RUN Parameters in the Technical Reference Guide.
3. Compile iiiDspEmpDocs and open the WebRoutine BEGIN in the Design view. It should look like the following:
4. Drop a Push Button weblet alongside the employee number field.
Set up the push button properties:
5. Save your changes.
6. Select the column heading "Document long file" and delete it.
Type in a new the column heading "Employee Documents".
You may need to click somewhere else in the layout, to refresh the column heading with your changes.
7. Save your changes.
Your design should look like the following:
8. Drop an Anchor weblet into the file name column of the list (the left hand column). Ignore the increase in width of this column. At run time it will display with the width of the actual file names.
Set up the Anchor weblet properties:
Save your changes.
9. Execute and test your WAM in the browser.
a. Enter employee number A0070 and select the Details push button. Your web page should look like the following:
b. Select one of the documents shown in the list. The document should be displayed in a new browser window.