DF_FILE_RETRIEVE_RECNUM

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

When creating records on a table with RECNUM support, the record number is returned after creation. When this attribute is false, the newly created record’s RECNUM is not returned from the server. This could result in a slight performance improvement when many records are being created in a loop. The optimization, however, is negligible. Having this attribute set to false can have detrimental effects if used improperly; i.e. DD-based saves or UI-based operations. Thus, this should almost always be set to true unless there is a compelling reason to do otherwise.

Default Value: True

Syntax

Get_Attribute DF_FILE_RETRIEVE_RECNUM of {FileNumber} to {variable}
Set_Attribute DF_FILE_RETRIEVE_RECNUM of {FileNumber} to {variable}

Parameter

Description

FileNumber

Number of the file

variable

Boolean variable. false to not retrieve record number, true otherwise.