Associated Multi-Valued Fields from Thin Air

[ray.wurlod]

Hope the subject doesn't scare anyone away.

Here's a useful query in RetrieVe, using generated field names and on-the-fly of field names temporarily declared to be multi-valued. I'll post the SQL equivalent tomorrow.

Code: Select all

LIST VOC 'DSR_LAST_UPDATED' ID.SUP F3 AS JOB_NAME MULTI.VALUE FMT "32L" F4 AS LAST_RAN MULTI.VALUE FMT "24R" ASSOC.WITH JOB_NAME HEADING "Last run times of jobs in this project 'G'Page 'SGLL'"

[kduke]

Very cool Ray.

[ray.wurlod]

SQL figures out the relationship somehow within the query engine, so one does not need to declare the columns to be temporarily multi-valued.

Code: Select all

SELECT F3 AS JOB_NAME FMT '36L',
       F4 AS LAST_RAN FMT '23R'
FROM   VOC
WHERE  F0 = 'DSR_LAST_UPDATED';