use

Select columns in the view/table

'use' keyword is used to select columns that needs to be selected by joining the referencing table/view to the current entity table/view.

Syntax:

use [ ColumnName ] [ as ColumnAlias ] [ labelText NameOfLabel ] ; 

use Company AS CompanyNo implementation "nvl(Company,10)"

Note:   Only for Performance Project.

ColumnName

Column name

Syntax:

<Identifier>

ColumnAlias

Column Alias

Syntax:

<Identifier>

NameOfLabel

Name of the label text

'labelText' keyword is used to provide a different name for the label which will appear in the prompt.

Syntax:

<String>

This page is generated from IFS Developer Studio at 2021-08-13 08:40.