This course has been superseded, according to the IBM website, with one that is
more suited to be a hybrid UniVerse/UniData BASIC programming course. (I
haven't seen the new one yet but would not be really surprised if it were
modelled on one we wrote in the Ardent days.) That said, however,
I know a assembler (not mcd but BAL) and PROC. Don't miss them though.
- Original Message -
From: Mark Baldridge [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Sunday, July 24, 2005 11:50 AM
Subject: Re: [U2] THE variable names
Could we not just avoid confusing the old(er)
[EMAIL PROTECTED] wrote on 07/22/2005 10:08:02 PM:
READNEXT ID FROM LIST ELSE ID = @AM
But why do you use an odd convention like ID = @AM ?
because it would be impossible for ID to be an attribute mark via
readnext.
If you later test for ([EMAIL PROTECTED]) there's only one way
READNEXT ID FROM LIST ELSE ID = @AM
But why do you use an odd convention like ID = @AM ?
because it would be impossible for ID to be an attribute mark via
readnext.
If you later test for ([EMAIL PROTECTED]) there's only one way that could
have
happened.
Of course, in
Select question:
Assume that I have 2 files, such as customer and invoice
File1: has 1 attribute, ID
File2: has 2 attributes, ID and FILE1_ID
I have a savedlist with ID numbers from file1.
I want to select all records in file2 which have FILE1_ID matching the
savedlist I already have.
Is
Hello all,
We are trying to connect to MSSQL server from Universe Database Server
(currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody
have experiences in that?
Thanks,
Songying Yang
Johnson County Court, KS
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
I can NAME THAT TUNE in *** 2 *** notes:
LOOP WHILE READNEXT ID DO
blah blah blah
REPEAT
;)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips
Sent: Monday, July 25, 2005 10:59 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2]
Is there a way to capture the specifics of the error using ON.ABORT?
Thanks,
Nick Cipollina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Friday, July 22, 2005 5:02 PM
To: u2-users@listserver.u2ug.org
Subject: RE:
Last week, in their quarterly earnings report, Automobile Dealer Software
manufacturer Reynolds Reynolds announced they were no longer selling their
RGS product - a replacement of their UV based product written using .NET and
SQL Server.
I've seen several anecdotal accounts of failed MV to SQL
Marilyn,
Just phrase it as I do things in a way that is safe, based on long
experience, and consistent. Suddenly, it sounds downright conservative.
- Chuck Talk Like a Radical, Think Like a Liberal, Act like a
Conservative Barouch
Marilyn Hilb wrote:
Quote: These days, I still use
In a message dated 7/25/2005 7:25:53 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
I started to use this syntax (ELSE ID = @AM) several years ago. It
originated, I think, from the Advanced Pick Programming book, circa
1990. The theory went that if you used a separate variable,
Great! That is exactly what I needed.
I forgot about the INTERSECTION option.
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock
Sent: Monday, July 25, 2005 8:18 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UD] Select on an
In a message dated 7/25/2005 9:46:28 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
Just phrase it as I do things in a way that is safe, based on long
experience, and consistent. Suddenly, it sounds downright conservative.
I like that.
How about also this tact
1) Do it my way, and
A lot of specifics seem to be lost flushed by that time. SYSTEM(9001)
is useless.
It's frustrating.
cds
From: Nick Cipollina
Is there a way to capture the specifics of the error using ON.ABORT?
Is there a way to override error handling in Universe to do
something
other than display a
I could write a subr to fetch these, but I don't know how to do it with
uniquery only. I think Noah is saying that he wants to...
SELECT all File2 items if FILE1_ID can be found in the savedlist
containing the IDs from File1.
In this case, won't BLAH still contain IDs from File1?
-Original
Noah,
Not directly, but *if* File2 is indexed by its FILE1_ID attribute there
are a couple ways.
Assume that I have 2 files, such as customer and invoice
File1: has 1 attribute, ID
File2: has 2 attributes, ID and FILE1_ID
I have a savedlist with ID numbers from file1.
I want to select
My thought on this would be to do the following:
1. EDIT-LIST list1
2. add xx at the end (this will force a @am to the end of your last select
list entry)
3. put the following DICT entry in the second file call it MULTIMATCH,
I
TRANS(SAVEDLISTS,listname,-1,'X') ; IF INDEX(@1,ATTR2:@vm,1)=0
If you changed
TRANS(SAVEDLISTS,listname,-1,'X') ; IF INDEX(@1,ATTR2:@vm,1)=0 THEN ELSE
Y
to
TRANS(SAVEDLISTS,listname,-1,'X') ; IF INDEX(@1:@vm,ATTR2:@vm,1)=0 THEN
ELSE Y
you could elminate step 1 and 2, but you will still need to edit the DICT
entry
each time to put in the listname,
I thought you wanted a list of File2 IDs.
Won't the MERGE.LIST INTERSECTION give you a list of File1 IDs?
Great! That is exactly what I needed.
I forgot about the INTERSECTION option.
Noah
-Original Message-
(If BLORP is your savedlist from File1) GET.LIST BLORP TO 1 SELECT
Thanks Shawn,
You have pin pointed the problem. I replied earlier to Jim that it
would work, but of course you are right, I need the FILE2 IDs, not the
FILE1 IDs
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie
Sent: Monday, July 25,
Yes, see followup message
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Monday, July 25, 2005 9:41 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Select on an attribute
I thought you wanted a list of File2 IDs.
There are a few problems with this theory. @AM is only a typical
component
of U2 systems and so would not, most likely, have been included in
the Advanced
@AM might not have been available then, but EQUATE was. Most programs
written before @AM was available usually equated the
In the same note read this article:
http://update.informationweek.com/cgi-bin4/DM/y/hpNU0GTFXz0G6t0DY2x0Encle:
- Original Message -
From: Ross Morrissey [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, July 25, 2005 11:31 AM
Subject: [U2] Large UV VAR abandons Microsoft
On Mon, 2005-07-25 at 13:37 -0500, Jerry Banker wrote:
In the same note read this article:
http://update.informationweek.com/cgi-bin4/DM/y/hpNU0GTFXz0G6t0DY2x0Encle:
Invalid URL.
--
Mike Doyle
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe
I've gotten complaints about the link, try this one:
http://www.informationweek.com/story/showArticle.jhtml?articleID=166401707
- Original Message -
From: Jerry Banker [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, July 25, 2005 1:37 PM
Subject: Re: [U2] Large UV VAR
loop while readnext ID
blah blah blah
repeat
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Monday, July 25, 2005 12:18 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Select Question
I can NAME THAT TUNE in *** 2
The more important problem is that the variables are all mapped into a
contiguous workspace that is referenced so continously that it's
highly unlikely it
would ever get paged from memory, while your process is running, except
perhaps on systems that were so woefully underbuilt that paging
I also work on a PICK system that doesn't have EXIT, and while I had hoped
that this would work there, it doesn't compile saying the LOOP stmt is
invalid
:(
PERFORM 'SELECT ORDER.BACK'
LOOP WHILE READNEXT ID
PRINT ID:;INPUT WAIT
REPEAT
STOP
Ah shucks..
It did work nicely on Unidata
Did you try using DO:
LOOP WHILE READNEXT ID DO
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood
Sent: Monday, July 25, 2005 4:29 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Select Question
I also work on a PICK system
I challenge whatever book made this contention.
Knock yourself out. I think it's in Pick For Professionals: Advanced
Methods Techniques. by Harvey Rodstein. All I was trying to do was
explain where the syntax ELSE ID = @AM originated from. We've already
spent more time discussing the
At the suggestion of an anonymous source I did, and it compiled, but gives
an unassigned variable error during execution. Oh well.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Monday, July 25, 2005 13:50
To:
I challenge whatever book made this contention.
Knock yourself out. I think it's in Pick For Professionals: Advanced
Methods Techniques. by Harvey Rodstein. All I was trying to do was
explain where the syntax ELSE ID = @AM originated from. We've already
spent more time discussing the
We're beating a dead horse. I offered this method around 200 posts or 10
days ago.
Mark Johnson
- Original Message -
From: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, July 25, 2005 12:17 PM
Subject: RE: [U2] [UV] Select Question
I can NAME THAT TUNE in *** 2 ***
Is not 'muscle-memory' phrases what makes for being an effecient programmer.
I can knock off a 5 field file maintenance program in around 10 minutes
without even 'thinking'. No 4gl's or other magic programming need apply.
Just pure code.
my 1 cent
- Original Message -
From: Stewart
Apologies -- we now are back up. A *four day* outage from our ISP. A
circuit problem finally found 100 yards outside the building.
Lee
On Thu, 21 Jul 2005, David Scoggins wrote:
Hey Ralph,
www.indexinfocus.com
Although the site seems to be down right now... :-(
-Original
Is not 'muscle-memory' phrases what makes for being an effecient programmer.
I can knock off a 5 field file maintenance program in around 10 minutes
without even 'thinking'. No 4gl's or other magic programming need apply.
Just pure code.
my 1 cent
I certainly identify with muscle-memory
THREAD CLOSED.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Lee,
Our sympathies. Thanks again for maintaining the archives. Let us
know if you are missing any mails from the down time.
- Charles Barouch
Moderator
Lee Leitner wrote:
Apologies -- we now are back up. A *four day* outage from our ISP. A
circuit problem finally found 100 yards
Read or update? Doesn't matter, my experience is using SQL XML on SQL 2K.
We use http from UniVerse to update MSSQL with updategrams (an MS term).
It works well, no need to install anything that wasn't already installed.
Works across port 80 /or 443 through our firewalls.
Not as fast as but
39 matches
Mail list logo