Focal Point
[CLOSED] SQL inner Select while creating masterfiles

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1537095806

August 19, 2011, 02:25 PM
wf_devloper
[CLOSED] SQL inner Select while creating masterfiles
hi,
we have a requirement where we are converting SQL passthrough query to masterfiles.

As part of that requirement we have an inner select for populating one of the columns in the SQL query. is there a way we can do that same when we create a masterfile?

thanks

This message has been edited. Last edited by: Kerry,


WF 7.7.05 on Linux
HTML, PDF, EXCEL
August 25, 2011, 11:54 AM
Kerry
Hi wf_developer,

From our technicals: starting in WebFOCUS 7.7.02, there is a new feature allowing new syntax in the Master File Description that generates an SQL subquery. To pursue in more details, please open a case with Customer Support Services. You may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.