search cancel

DQ805E returned on a query generated by DRAW command on FIELD table

book

Article ID: 258000

calendar_today

Updated On:

Products

Datacom/DB Datacom

Issue/Introduction

During a Dataquery online session, in DQL mode, a DRAW command on the FIELD table of the DataDictionary database creates a simple query without error; however, when that query is executed or validated, the following error is returned:

DQ805E - THE TABLE NAME YOU USED IS UNKNOWN TO DATAQUERY

Environment

Release : 15.1

Cause

FIELD is a Dataquery reserved word

Resolution

In order to use the DRAW command on FIELD table, you have to prefix it with 'DD':
DRAW DDFIELD

The same workaround must be used for KEY table, being another reserved word:
DRAW DDKEY

Note that TABLE and RECORD, which are reserved words too, are instead on AGGREGATE table.
See Using Dataquery to Access Information in the DATA-DICT Database for additional details.

Additional Information

The same error is returned when a query on FIELD or KEY is manually coded (i.e. not using the DRAW command):
FIND     KEY          
PRINT      FROM  KEY …
must be changed to:
FIND     DDKEY          
PRINT      FROM  DDKEY  …