[U2] U2UG Elections

2009-12-10 Thread Brian Leach
All Just a reminder to all U2UG members, that we are seeking nominations for the next board. We are looking for a new Vice President and three Members at Large. You can nominate either yourself or another U2UG member for these positions. With the sale of U2 to Rocket, we have a wealth of new oppo

Re: [U2] [UV] BCI Connectivity

2009-12-10 Thread Brian Leach
Hi Bill You don't need CONNECT privileges to use BCI, unless you are making a BCI connection back into UniVerse. The BCI demo program supplied with UniVerse does that, which is why it asks for the privileges. If you are accessing e.g. SQL Server, it's down to the role of the user you specify in th

[U2] SYSTEM.RETURN.CODE

2009-12-10 Thread Babic Marinko
EXECUTE commands [CAPTURING variable] [PASSLIST [dynamic.array] ] [RTNLIST [variable] ] [ {SETTING | RETURNING} variable] Using the SETTING or RETURNING clause causes the @SYSTEM.RETURN.CODE of the last executed command to be placed in variable. Does that mean, that if the value of the RET

Re: [U2] SYSTEM.RETURN.CODE

2009-12-10 Thread Glenn Sallis
Hi Marinko It depends on whether you are executing a TCL command or a Query within the EXECUTE statement. For a TCL command, if the RETURNING or SETTING variable returns 0 then I believe the command was successful, if however -1 is returned, the command did fail. However, if you are performing

[U2] Uniobjects and login paragraph

2009-12-10 Thread jpb-u2ug
Did I see that someone said Uniobjects bypasses the login paragraph? What else bypasses the login paragraph? Is this on both 'nix and Windows? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users

Re: [U2] Uniobjects and login paragraph

2009-12-10 Thread Brian Leach
Jerry Anything that can't be interactive. If that were not the case, and you started e.g. a menu system from your LOGIN paragraph, it would try to run that whenever you logged in through UniObjects and you would be stuffed. Brian -Original Message- From: u2-users-boun...@listserver.u2

[U2] [UD] Security and Permissions

2009-12-10 Thread Bill Haskett
A client of ours is running UD. The client has a corporate dbms account that they only want two people to have access to. Their regular dbms account is defined, via Windows permissions, to allow access to their UniData users and Windows administrators. There are several administrators for th

Re: [U2] Uniobjects and login paragraph

2009-12-10 Thread u2ug
Not true - phantoms execute the login paragraph - in which case you have to have the logic in your PA to skip the menu for phantom processes. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Decembe

Re: [U2] Uniobject.NET -Unable to load subroutine

2009-12-10 Thread Leimer, Thomas (SVW)
Thank you Ray. I did not have the subroutine catalogued globally. Now it works perfectly. Thanks, Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Raymond P. de Bourbon Sent: Wednesday, December 09, 2009 12:59 P

[U2] A readnext within a VOC?

2009-12-10 Thread George Gallen
I'd like to setup a VOC to select a list, then run a program for each entry in the list (like below...) PA GET-LIST LISTNAME LOOP READNEXT ID ELSE EXIT DATA ID RUN LIB PROGRAMNAME REPEAT I Thought there was a way to do this...but just can't remember how. In the meantime, I pass

Re: [U2] A readnext within a VOC?

2009-12-10 Thread Jeff Schasny
OK, I'll bite. Why not just write and catalog a program. Seems like a paragraph is the wrong tool. Seriously, you could probably cobble something together using editor macros too but why? George Gallen wrote: I'd like to setup a VOC to select a list, then run a program for each entry in the

Re: [U2] A readnext within a VOC?

2009-12-10 Thread George Gallen
The program doesn't normally process lists, it just does an input. for a 1x reason, we need to batch-run this program with the contents of the list. George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Jef

Re: [U2] A readnext within a VOC?

2009-12-10 Thread Jeff Schasny
OK, so you write a driver program: PROGRAM PROGRAMNAME.DRIVER GET-LIST LISTNAME LOOP READNEXT ID ELSE EXIT DATA ID EXECUTE "RUN LIB PROGRAMNAME" REPEAT END George Gallen wrote: The program doesn't normally process lists, it just does an input. for a 1x reason, we need to batch-

Re: [U2] A readnext within a VOC?

2009-12-10 Thread George Gallen
Which is what we did. Except put the GET-LIST into the VOC which run the driver program. I just thought there was a way to do this from a VOC without having to have gone the driver program route (kinda like xargs in unix) George > -Original Message- > From: u2-users-boun...@listser

[U2] UOJ & Eclipse 3.5 Galileo

2009-12-10 Thread Norman Bauer
Is anyone using 3.5 Galileo? I have tried to set my environment up using JDK 6 and Eclipse 3.5 but I get an error about no source files for asjava, even though I have added the asjava.zip file to the project. I am also new to Eclipse and Java so I could be doing something totally armature at this

Re: [U2] [UD] Security and Permissions

2009-12-10 Thread Colin Alfke
Bill; I'd try just giving administrators access to the VOC in this account and if you still have trouble the various UD directories (savedlists, _hold_, _ph_, etc) and see if that does it. Hth Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett A client of ours is running

Re: [U2] UOJ & Eclipse 3.5 Galileo

2009-12-10 Thread Bob Little
You should just be able to add the jar (zip) to your build path within Eclipse and clear up the error. Project->Properties->Java Build Path->Add External Jars... Bob Little UniVerse Developer Market America Greensboro NC -Original Message- From: u2-users-boun...@listserver.u2ug.org [mail

Re: [U2] UOJ & Eclipse 3.5 Galileo

2009-12-10 Thread Norman Bauer
Bob, thanks that fixed it. Total Newb error. Norm On Thu, Dec 10, 2009 at 3:48 PM, Bob Little wrote: > You should just be able to add the jar (zip) to your build path within > Eclipse and clear up the error. > > Project->Properties->Java Build Path->Add External Jars... > > Bob Little > UniVers

Re: [U2] A readnext within a VOC?

2009-12-10 Thread andy baum
George, This was possible in PI/Open using PA GET-LIST LISTNAME LOOP IF <> = "" THEN GO NEXT RUN LIB PROGRAMNAME DATA <> REPEAT NEXT: Unfortunately this never made it in to Universe, don't know about Unidata. I reported this when I beta tested the PI/Open to Universe migration s

Re: [U2] A readnext within a VOC?

2009-12-10 Thread Neil Richards
This capability is in UV 10.2 This example represents a paragraph as it appears in a VOC file: 001 PA 002 RUN BP DUE.LIST 003 DATA <> 004 DATA YES 005 RUN BP VENDORS 006 DATA <> From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug

Re: [U2] A readnext within a VOC?

2009-12-10 Thread andy baum
Neil, The specific request was to be able to process each item in a select list from within a Paragraph which is what the 'L' option of inline prompting did in PI/Open, unfortunately this has not been implemented in Universe. Cheers, Andy - Original Message From: Neil Richards To:

Re: [U2] A readnext within a VOC?

2009-12-10 Thread Neil Richards
yep, you are quite right, must learn to read everything before replying Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum [andyb...@yahoo.co.uk] Sent: Thursday, December 10, 2009 1:22 PM To: U2 Users Lis

[U2] Haydon Bishop is out of the office.

2009-12-10 Thread Haydon Bishop
I will be out of the office starting 10/12/2009 and will not return until 14/12/2009. I will respond to your message when I return. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] ODBC + UPS

2009-12-10 Thread Brutzman, Bill
Once again... John Hester... has knocked me out of my socks. Because John's answer works, we can read and write directly via the UPS-ODBC connection to UniVerse. Thanks a billion John. Thanks also to Brian and Neil on BCI Connectivity. --Bill -Original Message- From: u2-users-boun...

Re: [U2] [UV] ODBC + UPS

2009-12-10 Thread Brutzman, Bill
...and Ross on BCI --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Thursday, December 10, 2009 5:01 PM To: U2 Users List Subject: Re: [U2] [UV] ODBC + UPS Once again... John Hester...

Re: [U2] A readnext within a VOC?

2009-12-10 Thread Bob Woodward
Or you could smarten up the program and check if there is an active select list. If not, INPUT, else READNEXT. I do a lot of my Quick-N-Dirty programs like that, and a few main app programs that it makes sense to. This way you can run it like it now operates, one record at a time, or you make a

Re: [U2] A readnext within a VOC?

2009-12-10 Thread George Gallen
Only problem was this program, and most others, that have inputs would almost rarely be used for batch mode, so it would be dangerous to apply changes to programs and potentially add in bugs just in case you might need to use it in batch mode in the future. It would be far easier if the functional

Re: [U2] Haydon Bishop is out of the office.

2009-12-10 Thread Kevin King
...why is he out of the office? http://www.youtube.com/watch?v=tkBVDh7my9Q ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Run SQL statement through shell script?

2009-12-10 Thread Dattatraya
Dear All How to run sql statement through shell? I am trying following way but no success. /unidata/udt << !!Start SET LINESIZE 290; SET HEADING OFF; SET SPACE 2; SET PAGES 0; como on studentinfo; SELECT ID,LNAME,FNAME from STUDENT; como off; exit !!start Regards Dattatraya -- View this mess