f$SQLBindPG

f$SQLBindPG

Assign a parameter group to table columns. The columns in the result for the SELECT command are evaluated during this and identical names among the parameters in the parameter group are coupled with the column names in the result data. When f$SQLRead is performed afterward, the data from the result data record is copied to this parameter. To read multiple data records, f$SQLRead must be executed in a loop and the result copied to an indexed PG. If, however, f$SQLBindPG is executed and an indexed PG is given in the syntax: PG-Name[], the indexing is automatically altered with every f$SQLRead. Thus only f$SQLRead must be called in the loop and the status evaluated for checking the existence of the data record.