DFETCH From SQL Optimizer for IBM DB2 z/OS previous page next page DFETCH Represents a direct fetch data using ROWID. ROWID is used as a search condition. This is the most efficient was to access a base table if a ROWID-type column is defined within the table. previous page start next page