"Any" valid command can be executed as a stored procedure via SQLExecDirect (eg., "CALL LIST.READU" - you need the "CALL" to specify a store procedure call). Just don't call anything requiring terminal keyboard input.. including anything that pages the output (eg. 'press any key to continue') - other it will crash and return no output.
We've done this quite extensively before with UV and it works quite well. Regards David -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John J. Wahl Sent: Tuesday, 11 May 2010 9:10 AM To: U2 Users List Subject: [U2] Listing via the SQL Interface... Greetings All, Platform: UniVerse Version: 10.2.x O.S.: Windows Server 2008 (x86) 32-bit I'm wondering if there a way to get a listing of READU locks (exactly like the Verb LIST.READU, but via an SQL interface? I was going through the documents and old forum posts, but I do not see anything. Thank you for your time, ------------------------------ John J. Wahl Employee Owner Programmer / Analyst Tel: (888) 465-6737 Ext. 120 Fax: (330) 342-3896 Email: jw...@joseph.com Web: http://www.Joseph.com/ ED VOC Record name = LIST.READU 4 lines long. ----: 0001: V ----: 0002: list_readu ----: 0003: E ----: 0004: BG Bottom at line 4. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
