Calling a Program from a UDF

Hey, Howard:

I have a service program on my AS/400 that I want to call that evaluates data and returns a description. I want to call the program each time a record is read from a physical file when I am doing a select statement. If fact, what I want to do is create a view so that each time the user reads the records, the program is called to return the value of the specific column so that that field in the view is calculated on the fly by the program. I know I can do this in Oracle, but can I do it with DB2 on the AS/400?

-- Dave

READ MORE >

Creating HTML Subfiles

Hey, David:

I am writing a CGI application that displays a list of purchase orders that need approval in a Web browser. I would like to show the purchase orders in a scrollable area without using HTML frames. In addition, when the user clicks on a purchase order, I want to display the detail lines for the purchase order in the same browser window. I would like to keep the purchase order list on the screen so that the next purchase order can be selected. Can this be done?

-- Mark

READ MORE >

Reader Feedback and Insights: Confirm File Deletions in Qshell

I liked the recommendation about creating an alias. However, in the past I have burned myself by creating an alias with the same name as the command. I would get used to the alias version of the command, and when I used the command on a machine without the alias, there was no prompt.

-- John