[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
Re: [U2] Listing via the SQL Interface...
[ad] I'm not sure what SQL tools you're talking about but with mv.NET you can easily call BASIC subroutines from ADO.NET as though they were Stored Procedures. So wrap LIST.READU in a program, format the output the way you want and call it like a sproc. If you just want this data outside and you're thinking you need to do it with SQL, that's not correct. If you can describe the client-side environment maybe we can provide a more elegant method of delivering the data. Any help? Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno From: John J. Wahl 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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Listing via the SQL Interface...
Remember the LIST.READU INTERNAL format to get a dynamic array... unfortunately it is row based rather than column based otherwise you could have probably created a dictionary to decompose the data as sets of related multivalues ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, 11 May 2010 4:00 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Listing via the SQL Interface... [ad] I'm not sure what SQL tools you're talking about but with mv.NET you can easily call BASIC subroutines from ADO.NET as though they were Stored Procedures. So wrap LIST.READU in a program, format the output the way you want and call it like a sproc. If you just want this data outside and you're thinking you need to do it with SQL, that's not correct. If you can describe the client-side environment maybe we can provide a more elegant method of delivering the data. Any help? Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno From: John J. Wahl 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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Listing via the SQL Interface...
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