Hi all the u2oers,
Is anyone out there using uvreplicate on any platform will be appreciated for
background information, but specifically AIX/Unix? I personally do not think
this will be different between the operating platforms.
I have a few questions before I start looking into testing this
No problem. Glad to have help.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, October 17, 2012 3:00 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Universe 11 on Windows; BASIC
Well you got it in one Dan.
Some person (not me) removed a user from the user's table, who had
ownership of several files.
Most of them were old temp junk so I just deleted them.
But one was an actively used file, so I was able to reset the owner of that
file to be myself, and my process
It appears there may be a fix coming out in 11.1.10 later this year.
Take my words with a grain of salt however, as I don't primarily deal with the
current UniVerse releases.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On B
UV 10.2.13
On my Linux system writing items with an id that contains an asterisk (*)
on a Type 19 file causes the id to be converted.
Example: If BP.LIB is a type 19 file and I save an item named aaa*10
the Linux file name written is A0JL64~D
I am familiar with the fact that Universe on windows
When you say "was", is there a patch?
-Original Message-
From: Daniel McGrath
To: U2 Users List
Sent: Wed, Oct 17, 2012 1:38 pm
Subject: Re: [U2] [UV] Universe 11 on Windows; BASIC STATUS command aborting
process
There was a known issue whereby doing a STATUS call on a file th
There was a known issue whereby doing a STATUS call on a file that no longer
has a valid owner will cause an access violation.
As you are iterating over every file, this seems like a plausible cause.
Tom's Hardware seems to have some help in finding files with invalid owners:
http://www.tomshar
I have a verb I wrote, which select all files in an account, including those
which are just pointers to OS level directories, and for each run it runs the
BASIC STATUS command to retrieve the INODE (and other things).
The process aborts part way through with no message, it just kicks my session
http://jobs.geekzone.co.nz/Jobs/View/24957
I had to look up BAU. I have never heard of that acronym.
I'm *guessing* from this
http://en.wikipedia.org/wiki/Bau
of those choices I suppose it must be "the normal execution of standard
functional operations within an organisation" ?
So are they s
You don't need the "PA" in field one when you execute the stack. You can
create a multi-field record and execute it and UniVerse treats it as a
paragraph.
Tom
RATEX Business Solutions
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2u
I like it!
Once improvement: if the 2nd select fails, you should clear select list #1.
Something like this:
CMD = ""
CMD<-1> = "PA"
CMD<-1> = "SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1"
CMD<-1> = "IF @SYSTEM.RETURN.CODE < 1 THEN GO THE.END"
CMD<-1> = "SELECT PEOPLE TO 2"
CMD<-1>
That's a neat trick, I always assumed that you would have to write the
paragraph out to the VOC and then execute it. I like this! Thanks.
-Dianne
On 10/17/2012 2:45 PM, David A. Green wrote:
And to do this from UniBasic:
CMD = ""
CMD<-1> = "PA"
CMD<-1> = "SELECT REGISTRATION WITH EID = '1'
Hmm it never occurred to me that you can BASIC EXECUTE a paragraph which
doesn't actually exist in the VOC but is just created on-the-fly like this. I
wonder if I should try this on Universe 11.
-Original Message-
From: David A. Green
To: 'U2 Users List'
Sent: Wed, Oct 17, 201
And to do this from UniBasic:
CMD = ""
CMD<-1> = "PA"
CMD<-1> = "SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1"
CMD<-1> = "IF @SYSTEM.RETURN.CODE < 1 THEN GO THE.END"
CMD<-1> = "SELECT PEOPLE TO 2"
CMD<-1> = "IF @SYSTEM.RETURN.CODE < 1 THEN GO THE.END"
CMD<-1> = "MERGE.LIST 2 DIFF 1"
C
select registration with EID = '1' saving unique PID to 1
select people to 2
merge.list 2 diff 1
Larry Hiscock
Western Computer Services
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday,
Why not post it to the PickWiki
That way we can all use it.
-Original Message-
From: Bill Haskett
To: U2 Users List
Sent: Wed, Oct 17, 2012 10:35 am
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL
This is actually some code I put together from a Rock tech
This is actually some code I put together from a Rock tech note. It's
come in handy at various times. :-)
I'd be happy to share the code with you; I use UD but I suspect it
wouldn't be too hard to get it running on UV.
Bill
Untitled Page
---
Looks like either UV doesn't have LSELECT, or UV 10.0.2 does not.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Wednesday, October 17, 2012 1:16 PM
To: U2 Users List
Subject: Re: [U2] Sel
George:
How about something like:
3 Dev (0)-> LSELECT ?
This will create a list of {FileName} keys for records whose
field definition value appears in a defined list.
Syntax:
LSELECT File_Name WITH Dict_Name IN LIST1 TO LIST2 [VERBOSE| -V]
Example: SELECT CUSTOMERS SAMPLE 500
SAVE.LIST MY.
It looks like you have hit the point where code is needed because the SELECT
just cannot handle all the conditions cleanly.
My rule of thumb is: if I am going to need ANY code, do the whole thing in a
program. Experience has taught me that at some point, someone will want to
tweak things, and
Meant to have left outer join, not inner join.
BUT.I hit a snag.
If someone has entries in REGISTRATION with EID = '1' and an EID = '2' - they
still get selected,
since the it passes The <> '1' test, but the outer join also pulls in the EID =
'2'. So I'm going to have
To do a loop through,
How would I get the contents of the Index?
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Wednesday, October 17, 2012 11:38 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Selection Su
On 17/10/12 14:59, George Gallen wrote:
> Ok.
>
> I have file1 - "people" that has @ID of PID
> I have file2 - "registration" that has @ID of PID+EID+RID (EID = event id,
> RID = registration id)
>
> I want to select people who are not in the registration file with an EID of
> "1".
>
> With
Yea, MERGE.LIST does work, but sometimes I have issues with it using it in an
EXECUTE from BASIC.
George
Actually, you could leave off the TO 3, and the FROM 3 and it would still work.
The only disadvantage, is MERGE.LIST ALWAYS does a distinct, and you can't use
it to merge on
More than on
This gets a little trickier, but how about:
1) SELECT PEOPLE TO 1.
2) SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID.
3) SELECT PEOPLE TO 2.
4) MERGE.LIST 1 DIFF 2 TO 3.
5) SAVE.LIST XXX FROM 3.
This does assume that steps 1 and 2 actually return at least 1 key.
MERGE.LIST is an amazingly
I'm OK with using SQL - just wondering how you could use UV native.
select distinct PEOPLE.PID from PEOPLE inner join REGISTRATION
on (PEOPLE.PID = REGISTRATION.PID) where EID <> '1';
I will admit, UV could use a join clause.
George
-Original Message-
From: u2-users-boun...@listse
That was my first try, but the NSELECT only checks PEOPLE for those that are in
the list returned by the first
That are not in PEOPLE, it doesn't check for those in PEOPLE that are not in
the list returned.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2
Do it in more than one command?
SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID
NSELECT PEOPLE
Or am I missing something?
John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, Oc
Ok.
I have file1 - "people" that has @ID of PID
I have file2 - "registration" that has @ID of PID+EID+RID (EID = event id,
RID = registration id)
I want to select people who are not in the registration file with an EID of "1".
With an SQL statement - I could join the two, then do the select o
29 matches
Mail list logo