Re: [U2] SB.SMART.QUERY

2012-08-20 Thread Dave Davis
You need to go to AdminSB+ SetupSB+ Configuration PatternsF5-System Defaults 
and set the SB+ Subroutines in Dictionaries field to Y

After that you would need to regenerate the dictionary entries so that the 
default ERROR i-type gets replaced with an i-type that uses the 
SB.SMART.QUERY function.  Try re-saving one or two fields you are interested in 
after you set the flag above.

What SB.SMART.QUERY does is use the executable expression of your SB+ 
expression to return a value that can be used in query statements.  What the 
flag does is tell SB+ to generate the executable expression and create the 
i-type that uses it with SB.SMART.QUERY, after you save a field definition.

I did a similar thing myself before they made SB.SMART.QUERY available.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett
Sent: Sunday, August 19, 2012 8:00 PM
To: U2 Users List
Subject: [U2] SB.SMART.QUERY

Hi

Does anyone know how I can get SB.SMART.QUERY documentation? Alternatively (or 
maybe in addition) do you know how to call SB.SMART.QUERY to decifer DICT items 
much like ITYPE(xx) does in BASIC?

The IBM release notes talk about SB.SMART.QUERY being IBM's response to people 
wanting to use SB reporting outside of the SB+ environment - now this is 
EXACTLY what I need, but I can't figure out how to do it. I've written my own 
half-blown version, but it would be oh-so-easy to simply use theirs..

Thanks

Dennis Bartlett
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, RD

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] XLr8Editor supports Off Line Editing [ad]

2012-08-20 Thread Doug Averch
We have just released the our flag ship product called XLr8Editor version
3.5.8.  We have always allowed editing of U2 UniBasic code in offline mode
so that if you were at the hotel or on a plane you could change the code
and sync up later.  However, several of our clients wanted to use the same
editor to edit other Basic source code (D3) with our XLr8Editor.

This simply can be done by creating a General Project in Eclipse and
pointing the project folder to the appropriate area on your network or
workstation.  The documentation is at
http://www.u2logic.com/pdfs/XLr8EditorOffLine.pdf. All current users of our
XLr8Editor can upgrade to this release at no cost.  The rest of you can try
it out by emailing supp...@u2logic.com your installation id, see installation
instructions http://www.u2logic.com/pdfs/XLr8Installation.pdf.

Regards,
Doug
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Mysterious UV Error

2012-08-20 Thread Jeff Fitzgerald
Rick,

Your response was spot on - the site does use device licensing and it
appears uv is outputting some characters that result in the error.  Using
uvsh seems to be a viable workaround.

Thanks all for the help!  it's much appreciated!

Jeff Fitzgerald
Fitzgerald  Long, Inc.
www.fitzlong.com

On Fri, Aug 17, 2012 at 4:22 PM, Rick Nuckolls r...@lynden.com wrote:

 Starting the COMO from UV might be a trial under the circumstances; but
 the Unix script command could fill in.

 btw, using .../uv/bin/uvdls COUNT VOC gives me

 Verb 6 is not in your VOC

 Uvdls is the device licensing version of uv, and it does send a sequence
 of characters (and backspaces) to the terminal, in an attempt to retrieve
 the device IP address. Of course, this only works on wintegrate and
 Dynamicconnect (I think).

 The actual resulting visible message seems to have some variance in it,
 and 60 is certainly within scope.

 At uv 10.2, the uvdls executable is about 900 bytes longer than the uv
 executable. If the client has device licensing, odds are good that uv was
 replaced with the uvdls executable.

 -Rick


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Sockets programming on Unidata

2012-08-20 Thread Rutherford, Marc
Unidata 7.1.8
HP-UX 11.11i

I am attempting my first sockets programming project.  It appears that 
'initServerSocket' and 'openSocket' are working OK.  'getSocketInformation' 
returns info.

But 'acceptConnection' only seems to timeout, yet it returns a RESULT of '0' 
(no error).   The SocketHandle3 variable is not set.  

Without this SocketHandle3 variable I cannot read ('readSocket').  I am doing a 
'readSocket' after I have done a 'writeSocket' I am expecting a reply from the 
remote application (Oaisys call recording).

What am I missing?  The Unidata manual is pretty sparse.  Maybe I have an issue 
with network permissions/firewalling?

Any ideas on what may be going on with 'acceptConnetion' ?   Maybe you have 
links to deeper Rocket documentation?

Thanks, 

Marc Rutherford
Principal Programmer Analyst
Advanced Bionics LLC
661) 362 1754

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Virtualizing a Universe server of 100+ users

2012-08-20 Thread Eric Armstrong
Has anyone virtualized a Universe server of 100+ users, and if so, could you 
share how it went?


Eric Armstrong 
Programmer/Analyst 
Lobel Financial 


LOBEL FINANCIAL PRIVACY NOTICE: 
This communication may contain confidential company information that is 
protected by federal law. Federal regulations prohibit the disclosure (or 
re-disclosure) of confidential information without the written consent of the 
person(s) to whom it pertains. Additionally, the views or opinions presented in 
this email are solely those of the author and do not necessarily represent 
those of the company.


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Sockets programming on Unidata

2012-08-20 Thread larryh
Are you the client or the server?  acceptConnection is only used by the
server to accept incoming socket connection requests.  If you're trying to
communicate as a client to a remote server, you won't use
acceptConnection, you'll just open the socket, write the request, read the
response, and close the socket.

Larry Hiscock
Western Computer Services


 Unidata 7.1.8
 HP-UX 11.11i

 I am attempting my first sockets programming project.  It appears that
 'initServerSocket' and 'openSocket' are working OK.
 'getSocketInformation' returns info.

 But 'acceptConnection' only seems to timeout, yet it returns a RESULT of
 '0' (no error).   The SocketHandle3 variable is not set.

 Without this SocketHandle3 variable I cannot read ('readSocket').  I am
 doing a 'readSocket' after I have done a 'writeSocket' I am expecting a
 reply from the remote application (Oaisys call recording).

 What am I missing?  The Unidata manual is pretty sparse.  Maybe I have an
 issue with network permissions/firewalling?

 Any ideas on what may be going on with 'acceptConnetion' ?   Maybe you
 have links to deeper Rocket documentation?

 Thanks,

 Marc Rutherford
 Principal Programmer Analyst
 Advanced Bionics LLC
 661) 362 1754

 ___
 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] Sockets programming on Unidata

2012-08-20 Thread Rutherford, Marc
Got it, I am the client - so the 'init' and 'accept' not applicable.

So I should both  'write' and 'read' using the same SocketHandle?

Marc Rutherford
Principal Programmer Analyst
Advanced Bionics LLC
661) 362 1754


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com
Sent: Monday, August 20, 2012 9:12 AM
To: U2 Users List
Subject: Re: [U2] Sockets programming on Unidata

Are you the client or the server?  acceptConnection is only used by the server 
to accept incoming socket connection requests.  If you're trying to communicate 
as a client to a remote server, you won't use acceptConnection, you'll just 
open the socket, write the request, read the response, and close the socket.

Larry Hiscock
Western Computer Services


 Unidata 7.1.8
 HP-UX 11.11i

 I am attempting my first sockets programming project.  It appears that 
 'initServerSocket' and 'openSocket' are working OK.
 'getSocketInformation' returns info.

 But 'acceptConnection' only seems to timeout, yet it returns a RESULT of
 '0' (no error).   The SocketHandle3 variable is not set.

 Without this SocketHandle3 variable I cannot read ('readSocket').  I 
 am doing a 'readSocket' after I have done a 'writeSocket' I am 
 expecting a reply from the remote application (Oaisys call recording).

 What am I missing?  The Unidata manual is pretty sparse.  Maybe I have 
 an issue with network permissions/firewalling?

 Any ideas on what may be going on with 'acceptConnetion' ?   Maybe you
 have links to deeper Rocket documentation?

 Thanks,

 Marc Rutherford
 Principal Programmer Analyst
 Advanced Bionics LLC
 661) 362 1754

 ___
 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Sockets programming on Unidata

2012-08-20 Thread larryh
Yes, the same SocketHandle that openSocket returns.


Larry Hiscock
Western Computer Services
Santa Clarita, CA

 Got it, I am the client - so the 'init' and 'accept' not applicable.

 So I should both  'write' and 'read' using the same SocketHandle?

 Marc Rutherford
 Principal Programmer Analyst
 Advanced Bionics LLC
 661) 362 1754


 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
 lar...@wcs-corp.com
 Sent: Monday, August 20, 2012 9:12 AM
 To: U2 Users List
 Subject: Re: [U2] Sockets programming on Unidata

 Are you the client or the server?  acceptConnection is only used by the
 server to accept incoming socket connection requests.  If you're trying to
 communicate as a client to a remote server, you won't use
 acceptConnection, you'll just open the socket, write the request, read the
 response, and close the socket.

 Larry Hiscock
 Western Computer Services


 Unidata 7.1.8
 HP-UX 11.11i

 I am attempting my first sockets programming project.  It appears that
 'initServerSocket' and 'openSocket' are working OK.
 'getSocketInformation' returns info.

 But 'acceptConnection' only seems to timeout, yet it returns a RESULT of
 '0' (no error).   The SocketHandle3 variable is not set.

 Without this SocketHandle3 variable I cannot read ('readSocket').  I
 am doing a 'readSocket' after I have done a 'writeSocket' I am
 expecting a reply from the remote application (Oaisys call recording).

 What am I missing?  The Unidata manual is pretty sparse.  Maybe I have
 an issue with network permissions/firewalling?

 Any ideas on what may be going on with 'acceptConnetion' ?   Maybe you
 have links to deeper Rocket documentation?

 Thanks,

 Marc Rutherford
 Principal Programmer Analyst
 Advanced Bionics LLC
 661) 362 1754

 ___
 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
 ___
 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] Sockets programming on Unidata

2012-08-20 Thread Rutherford, Marc
Works like a charm, Thanks Larry.

Marc Rutherford
Principal Programmer Analyst
Advanced Bionics LLC
661) 362 1754


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com
Sent: Monday, August 20, 2012 9:48 AM
To: U2 Users List
Subject: Re: [U2] Sockets programming on Unidata

Yes, the same SocketHandle that openSocket returns.


Larry Hiscock
Western Computer Services
Santa Clarita, CA

 Got it, I am the client - so the 'init' and 'accept' not applicable.

 So I should both  'write' and 'read' using the same SocketHandle?

 Marc Rutherford
 Principal Programmer Analyst
 Advanced Bionics LLC
 661) 362 1754


 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
 lar...@wcs-corp.com
 Sent: Monday, August 20, 2012 9:12 AM
 To: U2 Users List
 Subject: Re: [U2] Sockets programming on Unidata

 Are you the client or the server?  acceptConnection is only used by 
 the server to accept incoming socket connection requests.  If you're 
 trying to communicate as a client to a remote server, you won't use 
 acceptConnection, you'll just open the socket, write the request, read 
 the response, and close the socket.

 Larry Hiscock
 Western Computer Services


 Unidata 7.1.8
 HP-UX 11.11i

 I am attempting my first sockets programming project.  It appears 
 that 'initServerSocket' and 'openSocket' are working OK.
 'getSocketInformation' returns info.

 But 'acceptConnection' only seems to timeout, yet it returns a RESULT of
 '0' (no error).   The SocketHandle3 variable is not set.

 Without this SocketHandle3 variable I cannot read ('readSocket').  I 
 am doing a 'readSocket' after I have done a 'writeSocket' I am 
 expecting a reply from the remote application (Oaisys call recording).

 What am I missing?  The Unidata manual is pretty sparse.  Maybe I 
 have an issue with network permissions/firewalling?

 Any ideas on what may be going on with 'acceptConnetion' ?   Maybe you
 have links to deeper Rocket documentation?

 Thanks,

 Marc Rutherford
 Principal Programmer Analyst
 Advanced Bionics LLC
 661) 362 1754

 ___
 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
 ___
 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Mysterious UV Error

2012-08-20 Thread Phil Walker
Jeff,

My understanding from when I worked at VMARK, long ago, is that you should be 
using uvsh rather than uv anyway. Cannot remember the reason why but there was 
a reason back then anyway  (1992-1995).

Phil

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of Jeff Fitzgerald
 Sent: 21 August 2012 2:09 a.m.
 To: U2 Users List
 Subject: Re: [U2] Mysterious UV Error
 
 Rick,
 
 Your response was spot on - the site does use device licensing and it
 appears uv is outputting some characters that result in the error.  Using
 uvsh seems to be a viable workaround.
 
 Thanks all for the help!  it's much appreciated!
 
 Jeff Fitzgerald
 Fitzgerald  Long, Inc.
 www.fitzlong.com
 
 On Fri, Aug 17, 2012 at 4:22 PM, Rick Nuckolls r...@lynden.com wrote:
 
  Starting the COMO from UV might be a trial under the circumstances;
  but the Unix script command could fill in.
 
  btw, using .../uv/bin/uvdls COUNT VOC gives me
 
  Verb 6 is not in your VOC
 
  Uvdls is the device licensing version of uv, and it does send a
  sequence of characters (and backspaces) to the terminal, in an attempt
  to retrieve the device IP address. Of course, this only works on
  wintegrate and Dynamicconnect (I think).
 
  The actual resulting visible message seems to have some variance in
  it, and 60 is certainly within scope.
 
  At uv 10.2, the uvdls executable is about 900 bytes longer than the uv
  executable. If the client has device licensing, odds are good that
  uv was replaced with the uvdls executable.
 
  -Rick
 
 
 ___
 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] Sort the LISTU output

2012-08-20 Thread Wjhonson

http://www.pickwiki.com/cgi-bin/wiki.pl?WLISTU

If more people would use the Pickwiki, we wouldn't need to each reinvent the 
wheel



-Original Message-
From: Wjhonson wjhon...@aol.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Fri, Aug 17, 2012 7:28 pm
Subject: Re: [U2] Sort the LISTU output


FFT.BP 'WLISTU' BASIC 77 lines  Level: 3
0001 *
0002 * Writen Aug 2012 by Will Johnson
0003 * This routine sorts the LISTU table by date and then by time
0004 * Builds a multi-sub-valued table, so the times get sorted right
0005 * Then swaps the SVMs for VMs so it becomes a regular table
0006 * Then it also allows you to resort it by PID
0007 *
0008   EQUATE FALSE TO 0, TRUE TO 1
0009   TODAY = DATE()
0010   THIS.YEAR = OCONV(TODAY,'DY')
0011   SWITCH = DATE ; EXIT.PROGRAM = FALSE
0012   LOOP
0013  EXECUTE LISTU, OUT  RESULTS
0014  SELECTV RESULTS TO L.RESULTS
0015  DONE = FALSE ; CNT = 0 ; HEADERS = '' ; TABLE = ''
0016  LOOP
0017 READNEXT LINE FROM L.RESULTS ELSE DONE = TRUE
0018  UNTIL DONE DO
0019 CNT += 1
0020 * Below three lines for debugging only
0021 PRINT CNTR%2:' ':LINE ; PRINT SPACE(3):
0022 FOR J = 1 TO 7 ; PRINT SPACE(9):J: ; NEXT J
0023 PRINT ; PRINT SPACE(3):STR('1234567890',7)
0024 *
0025 T.PID = LINE[16,5]
0026 T.DATE = LINE[62,6]:' ':THIS.YEAR
0027 T.TIME = LINE[69,5]
0028 IF SWITCH = DATE THEN GOSUB BY.DATE.AND.TIME
0029 IF SWITCH = PID THEN GOSUB BY.PID
0030  REPEAT
0031  TABLE1 = HEADERS:@VM:TABLE1
0032  TABLE = CONVERT(@SVM,@VM,TABLE)
0033 *
0034  S.TABLE = DCOUNT(TABLE1,@VM)
0035  FOR I.TABLE = 1 TO S.TABLE
0036 PRINT I.TABLE'R%2':' ':TABLE1,I.TABLE
0037  NEXT I.TABLE
0038  DISPLAY SORT BY (D)ATE, (P)ID, OR (Q)UIT :
0039  INPUT ANYTHING
0040  BEGIN CASE
0041 CASE ANYTHING = 'Q' ; EXIT.PROGRAM = TRUE
0042 CASE ANYTHING = 'P' ; SWITCH = 'PID'
0043 CASE ANYTHING = 'D' ; SWITCH = 'DATE'
0044  END CASE
0045   UNTIL EXIT.PROGRAM DO
0046   REPEAT
0047   STOP
0048 *
0049 BY.DATE.AND.TIME:
0050   I.DATE = ICONV(T.DATE,'D')
0051   I.TIME = ICONV(T.TIME,'MT')
0052   IF STATUS() THEN
0053  HEADERS1,-1 = LINE
0054   END ELSE
0055  LOCATE I.DATE IN TABLE2,1 BY 'AR' SETTING W.DATE ELSE
0056 TABLE = INSERT(TABLE,1,W.DATE;'')
0057 TABLE = INSERT(TABLE,2,W.DATE;I.DATE)
0058 TABLE = INSERT(TABLE,3,W.DATE;'')
0059  END
0060  LOCATE I.TIME IN TABLE3,W.DATE,1 BY 'AR' SETTING W.TIME ELSE 
NULL
0061  TABLE = INSERT(TABLE,1,W.DATE,W.TIME;LINE)
0062  TABLE = INSERT(TABLE,3,W.DATE,W.TIME;I.TIME)
0063   END
0064   RETURN
0065 *
0066 BY.PID:
0067   IF NUM(T.PID) THEN
0068  T.PID = TRIM(T.PID) + 0
0069  LOCATE T.PID IN TABLE2,1 BY 'AR' SETTING W.PID ELSE NULL
0070  TABLE = INSERT(TABLE,1,W.PID;LINE)
0071  TABLE = INSERT(TABLE,2,W.PID;T.PID)
0072   END ELSE
0073  HEADERS1,-1 = LINE
0074   END
0075   RETURN
0076 *
0077END



-Original Message-
From: Wjhonson wjhon...@aol.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Fri, Aug 17, 2012 2:20 pm
Subject: [U2]  Sort the LISTU output


I just wrote a routine to grab the LISTU output (Universe on Windows) and sort 
it by date of logon, and then time of logon.  I'm going to also allow it to be 
sorted by the process id, and by the user name.

Has anyone already done this?  I don't want to reinvent the wheel if someone is 
willing to share their version of this task.

___
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

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] CSV to Array

2012-08-20 Thread Keith Johnson [DATACOM]
No-one seems to have done it, but here's my version of the code.

It's strange, I don't have a problem with CONTINUE and I don't even mind
IF SOMETHING ELSE THIS = THAT
which a lot of people really hate, but I just HAD to reverse the IF/CASE 
statement order.

SUBROUTINE REXY(RECORD,TEXT)
*
 HERE = 0
 QUOTED = @FALSE
 RECORD = ''
 LOOP
HERE += 1
C = TEXT[HERE,1]
 UNTIL C EQ ''
BEGIN CASE
   CASE QUOTED AND TEXT[HERE,2] EQ ''
  HERE += 1
   CASE C EQ ''
  QUOTED = NOT(QUOTED)
  C = ''
   CASE C EQ ',' AND NOT QUOTED
  C = @FM
END CASE
RECORD := C
 REPEAT
 RETURN
  END

Regards, Keith

PS: Remember Messrs Stout and Chapman - Simplicate and add more lightness

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users