Adding a query for a non-AS/400 IBMi source

It is possible for an EXTRACT type of model on a non-AS/400 IBMi source to add a simple or complex query directly. 

The query needs to be in the format of the source database and it is limited to 4096 characters.

You can see the different values of a column by double-clicking it.

The query is shown in the table list as a table called *QUERY.