First of all, there's nothing in your request to prevent MULTIPLE values of Project Num from being stored in the HOLD file. So, assuming the same value of PROJECT_NUM is on each record in the file, here's what I would do. Since this is an SQL SELECT, you don't know the formats of the fields beforehand (you may, but they could change). So, once you've held all the data, I'd create a second HOLD file from the first, with just one project number. To do this, issue the following:


This will write out the first instance of PROJECT_-NUMBER to a file called PROJNUM, and will save it as character format (if it was numeric, you DON'T want it in internal/binary format). The final '-RUN' executes the commands.

Then, issue the following:


This will read the first (and only) value in that file into a Dialogue Manager variable called &PROJECT_NUM. From then on, you can use this value (as !IBI.AMP.PROJECT_NUM;) in your HTMLFORM.

Thank you for your help.  However, is there a way to specifically pull from the table and not have to write to a variable?  The example I provided is very streamlined.  I really need to do this on about 30 fields and was trying to avoid creating variables.

Well, by definition, the values you want to include are variables (they may have differing values). The only other way is to have your output LOOK like an HTML form, and then -INCLUDE that. It's more complex, and using a variable is much easier to create, and modify. Is there any reason NOT to use variables? My example was for a single variable; it could just as well read all 30 variables. You either extract them in a FIXED format, and read them in with a length specification for each field:


or write them out comma delimited, and read them in free-format: