[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?
thanksThis 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.