You can always use a nested SQL in an SQL set fields statement. Select * from ( Select x,y,z from abc )
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Roys Sent: Friday, November 16, 2012 9:32 AM To: arslist@ARSLIST.ORG Subject: 7.6.4 Java Api Trivia - Recursive Query Level Good Friday to you, Is it possible to get the level as output from a recursive query call? There doesn't appear to be, unless I've not found it, a way by which to retrieve it from the results. The sql trace (on ms sql) provides that the sql is establishing level. Alternatively a api getlistsql using recursive query doesn't appear to be productive (requires ";" prior to "with", although providing it ends with no results - ever). Appreciate any thoughts on the subject. Kind Regards, Eric _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"