Query Files

A query file is a file that contains view definitions using SQL language, as an alternative to the standard dataset definition approach: DEFINE VIEW DATASET.

Query files have a .qry extension.

You can create multiple .qry files.

Example: To perform a channels.qry, enter:

SELECT

CHANNELS_D.CHANNEL_CLASS,CHANNELS_D.CHANNEL_CLASS_ID,CHANNELS_D.CHANNEL_DESC,

CHANNELS_D.CHANNEL_ID,TRUNC(SYSDATE) AS CURDATE 

FROM DW_LOCODE_X_APP_CHANNELS_D CHANNELS_D