RE: [U2] UD license counter
Thanks John. Here's what I did with Kevin's help. 1. Created a subroutine that accepts one parameter and returns the value of the user specified system variable. 2. Wrote a glassfish webservice that calls that subroutine and returns the value. 3. Wrote a java desktop gadget that hits the web service every nnn seconds and displays the value. This gadget can be run on many desktops simultaneously. I'll add logging later the capture max/min/avg etc. Thanks again. Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Tab characters in output
Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD license counter
Jeff, That sounds kinda cool. If you are agreeable, would you send me copies of these so I can look at this? While this will not change what we do here, it sounds very interesting and I am always wanting to learn. John Israel [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Friday, September 12, 2008 8:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD license counter Thanks John. Here's what I did with Kevin's help. 1. Created a subroutine that accepts one parameter and returns the value of the user specified system variable. 2. Wrote a glassfish webservice that calls that subroutine and returns the value. 3. Wrote a java desktop gadget that hits the web service every nnn seconds and displays the value. This gadget can be run on many desktops simultaneously. I'll add logging later the capture max/min/avg etc. Thanks again. Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
I have found the tab character to be extremely effective in delineating columns of information. The simple command: SWAP CHAR(9) WITH @VM IN report-table Instantly changes the report to a usable table in UniBasic. Using any 'printing' character (like the pipe '|' or caret '^') is unreliable as to guaranteeing clean column/value marks. David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 12, 2008 9:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Tab characters in output
For what it's worth, the UniBasic LISTUSER() function provides dynamic array of the detail items. Wally Terhune U2 Support Architect IBM Information Management Software Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2/support Mark your calendar! From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: 09/12/2008 08:30 AM Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Anyplace you have to parse output is confounding!! I think most of this is in system() variables - but there are some things that don't seem to be... Listuser is also an .exe in the \bin directory. Have you tried parsing that output? It may be more advantageous if you're close to your user count. There is GETREADU(), it would be nice if there was a GETLISTU() as well. While I'm at it, it would also be nice to dump list/sort output into an array. Hth Colin Alfke Calgary, Canada -Original Message- Bill Haskett Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Tab characters in output
When I need to build an export file, I always build each row as a FM delimited array. This allows me to take advantage of all the basic commands. When I am ready to write the row to disk (via WRITESEQ), I always run a common piece of code to: Convert all tabs to spaces Convert all vms to spaces Convert all sms to spaces Trim the array Convert all fms to tabs Write to disk The other thing I usually do is save the export with a .xls extension. The causes it to automatically fire up in Excel. Of course, each program might have exceptions. If you have questionable data, you could also us the OCONV code to remove these prior to writing the row to disk. John -- Sent using BlackBerry - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Fri Sep 12 10:10:56 2008 Subject: RE: [U2] [UD] Tab characters in output I have found the tab character to be extremely effective in delineating columns of information. The simple command: SWAP CHAR(9) WITH @VM IN report-table Instantly changes the report to a usable table in UniBasic. Using any 'printing' character (like the pipe '|' or caret '^') is unreliable as to guaranteeing clean column/value marks. David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 12, 2008 9:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
If the command is like the one in UV then it actually comes from the operating system (who), at least in the Unix world. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 12, 2008 8:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Colin: !listuser returns tabs too. Oh well. While I'm at it, it would also be nice to dump list/sort output into an array. Sounds like a BB entry (if only I could figure out how). :-) Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin Alfke Sent: Friday, September 12, 2008 8:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Tab characters in output Anyplace you have to parse output is confounding!! I think most of this is in system() variables - but there are some things that don't seem to be... Listuser is also an .exe in the \bin directory. Have you tried parsing that output? It may be more advantageous if you're close to your user count. There is GETREADU(), it would be nice if there was a GETLISTU() as well. While I'm at it, it would also be nice to dump list/sort output into an array. Hth Colin Alfke Calgary, Canada -Original Message- Bill Haskett Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Thanks Wally. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Friday, September 12, 2008 7:43 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Tab characters in output For what it's worth, the UniBasic LISTUSER() function provides dynamic array of the detail items. Wally Terhune U2 Support Architect IBM Information Management Software Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2/support Mark your calendar! From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: 09/12/2008 08:30 AM Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD license counter
Sure, But I'll need to sanitize them first. On Fri, 2008-09-12 at 09:47 -0400, Israel, John R. wrote: Jeff, That sounds kinda cool. If you are agreeable, would you send me copies of these so I can look at this? While this will not change what we do here, it sounds very interesting and I am always wanting to learn. John Israel [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Friday, September 12, 2008 8:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD license counter Thanks John. Here's what I did with Kevin's help. 1. Created a subroutine that accepts one parameter and returns the value of the user specified system variable. 2. Wrote a glassfish webservice that calls that subroutine and returns the value. 3. Wrote a java desktop gadget that hits the web service every nnn seconds and displays the value. This gadget can be run on many desktops simultaneously. I'll add logging later the capture max/min/avg etc. Thanks again. Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Instead of complaining we should send them a thank-you note. Sent from my Windows Mobile. phone. -Original Message- From: Bill Haskett [EMAIL PROTECTED] Sent: Friday, September 12, 2008 7:21 AM To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
While I'm at it, it would also be nice to dump list/sort output into an array. Not exactly what you're asking for, but you may get some help from the TO DELIM UniQuery keywords to create flat, delimited files that can be read in by your program or by Excel and other applications. I use it all the time and it works great. It's one of those features that's been out there almost forever ,but most folks aren't quite aware of its usefulness. Make sure you read up on UDT.OPTIONS 91 before playing around with it. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Change columns from 80 to 132 and from 132 to 80
I am trying to find a way to change the columns on my screen from 80 to 132 and from 132 to 80. Either by scripts or by program. -- View this message in context: http://www.nabble.com/Change-columns-from-80-to-132-and-from-132-to-80-tp19462277p19462277.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Change columns from 80 to 132 and from 132 to 80
I need to add this is from Wintegrate. T Stokes wrote: I am trying to find a way to change the columns on my screen from 80 to 132 and from 132 to 80. Either by scripts or by program. -- View this message in context: http://www.nabble.com/Change-columns-from-80-to-132-and-from-132-to-80-tp19462277p19462889.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Change columns from 80 to 132 and from 132 to 80
Depends on the emulator. What emulator and emulation are you using in that program? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Thanks. Actually, I do use this one. In fact, I have an enhancement request in that it put CRLF after each line instead of just LF on Windows systems. UDT.OPTIONS 91 always seemed backwards to me. If you're using the LIST syntax you would expect things in converted form - not the other way around. It's easy enough to create dicts (or even list statements) without conv codes. Colin Alfke Calgary, Canada -Original Message- Timothy Snyder While I'm at it, it would also be nice to dump list/sort output into an array. Not exactly what you're asking for, but you may get some help from the TO DELIM UniQuery keywords to create flat, delimited files that can be read in by your program or by Excel and other applications. I use it all the time and it works great. It's one of those features that's been out there almost forever ,but most folks aren't quite aware of its usefulness. Make sure you read up on UDT.OPTIONS 91 before playing around with it. Tim Snyder --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
I guess you haven't used Excel 2007. It gives you an error message - although it does still give you the option to open the file. Hth Colin Alfke Calgary, Canada -Original Message- Israel, John R. [snip] The other thing I usually do is save the export with a .xls extension. The causes it to automatically fire up in Excel. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
UDT.OPTIONS 91 always seemed backwards to me. If you're using the LIST syntax you would expect things in converted form - not the other way around. It's easy enough to create dicts (or even list statements) without conv codes. I agree that it seems backwards. My guess is that, when TO DELIM was implemented, it output it as raw, which is pretty much useless for most implementations. So formatted output was added. But, rather than change the default behavior (and possibly screwing up anybody that had built anything around the old behavior), UDT.OPTIONS 91 was added. As we all know, changing behavior (even bad behavior) often causes more problems that it solves - not to mention much wailing and gnashing of teeth. ;-) Like I said, I'm just guessing. But if you look at a lot of the UDT.OPTIONS, they seem backwards; I suspect it's all for the same reason. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Change columns from 80 to 132 and from 132 to 80
I'm not familiar with wintegrate. Does it do multiple emulations? The control sequences to change a vt100 emulator are different than for a Wyse or Adds terminal. Check out the wintegrate programmer's manual. If it's anything like Accuterm, there's probably a private escape sequence that will change the screen size no matter what the emulation. On Sep 12, 2008, at 3:49 PM, T Stokes wrote: I need to add this is from Wintegrate. T Stokes wrote: I am trying to find a way to change the columns on my screen from 80 to 132 and from 132 to 80. Either by scripts or by program. -- View this message in context: http://www.nabble.com/Change-columns- from-80-to-132-and-from-132-to-80-tp19462277p19462889.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Change columns from 80 to 132 and from 132 to 80
Is this universe or unidata? Looks like universe defines the @(-29) function as setting 80 column mode, and the @(-30) function as setting 132 column mode. These may not be defined for all term types, but they work for me in vt420. On Sep 12, 2008, at 3:49 PM, T Stokes wrote: I need to add this is from Wintegrate. T Stokes wrote: I am trying to find a way to change the columns on my screen from 80 to 132 and from 132 to 80. Either by scripts or by program. -- View this message in context: http://www.nabble.com/Change-columns- from-80-to-132-and-from-132-to-80-tp19462277p19462889.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change columns from 80 to 132 and from 132 to 80
I am trying to set the columns in wintegrate from 80 to 132 or from 132 to 80 Tim Stokes [EMAIL PROTECTED] Monolith Corporation Phone: (919) 878-1900 ext 267 Fax: (919) 878-8844 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, September 12, 2008 3:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Change columns from 80 to 132 and from 132 to 80 Depends on the emulator. What emulator and emulation are you using in that program? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Colin, is this the error you're referring to? The file you are trying to open, '[filename]', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? (Yes | No | Help) If so, information is available here: http://blogs.msdn.com/vsofficedeveloper/pages/Excel-2007-Extensio n-Warning.aspx Thanks to Ross Morrissey who provided that link in a Support request. NebulaXLite generates Excel documents as XML files, and Office 2007 users get prompted when opening the docs if the docs are saved and deployed with a .xls extension. The information on that page helps to eliminate the problem. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/products/xlite.htm From: Colin Alfke I guess you haven't used Excel 2007. It gives you an error message - although it does still give you the option to open the file. From Israel, John R.: The other thing I usually do is save the export with a .xls extension. The causes it to automatically fire up in Excel. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
