ENGINE SQLMSS SET SERVER [connector name]
-* Where [connector name] is a valid connector in your configuration
-* Check WebFOCUS manuals or consult with your WF administrator
-*
-* Set the engine to the SQL datasource you are going to use
 SET SQLENGINE = SQLMSS
-* Turn varchar recognition off - comment out if not required
 SQL SQLMSS SET VARCHAR OFF
-RUN

SQL
  SELECT *
    FROM people_dim
   WHERE MGR_CORP_ID in (SELECT MGR_CORP_ID
                           FROM people_dim
                          WHERE CORP_ID='&corp_id' AND end_dt is null)
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS anyname
END
-RUN

TABLE FILE anyname
PRINT field ........
WHERE field EQ somevalue
END

  
SQL
  SELECT *
    FROM people_dim
   WHERE CORP_ID='&corp_id' AND end_dt is null
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS anyname
END

quote:

Originally posted by Animesh Verma:
Hi,
I am working with WebFocus for the first time and i dont know how to write the following sql query in Webfocus.I know we can write sql query in WebFocus but i want to know how to write in Webfocus syntax.Here is the query

select * from people_dim where MGR_CORP_ID in

(select MGR_CORP_ID from people_dim where CORP_ID='&corp_id' and end_dt is null )


If anyone can please help me out with this fast.