RE: [U2] Connecting SQL server from Universe
We use the SQL connect facilities within UniVerse to talk to SQL Server directly. From a UV Basic program we can read and update SQL tables and call SQL stored procedures with little difficulty. Regards David Jordan ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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] Connecting SQL server from Universe
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 reasonable performance compared with ODBC et al. Convenience overrides. You need MS SQL 2000 with IIS configured with support for SQL XML. On the UV side we just use 'EXECUTE "LIST ... TOXML" CAPTURING XML.UPDATE.DATA' to generate the XML updategrams but I understand recent versions of UV have improved support for generating XML in basic. There are risks using that method as large amounts of data in the capturing variable could blow your workspace. You can also use IIS SQL XML support to read (XML) data from MSSQL. Regards, Stuart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Yang, Songying, JIMS" <[EMAIL PROTECTED]> Sent: Tuesday, 26 July 2005 02:04 To: Subject: [U2] Connecting SQL server from Universe 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 unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2 group archives
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 outside the building. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Select Question
THREAD CLOSED. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Select Question
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 phrases so if what you do is clear and works, more power to you. :-) > Stewart I was agreeing muscle-memory is effective as long as what comes from it works and is maintainable. Stewart -- Stewart Leicester| http://www.ThreatFocus.com V.P. Engineering | mailto:[EMAIL PROTECTED] Threat Focus, Inc. | 925-551-0130 Voice "Knowledge is your best defense" | 509-695-1373 Fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 group archives
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 Message- > > From: Ralph Burton [mailto:[EMAIL PROTECTED] > > Sent: Thursday, July 21, 2005 11:31 AM > > To: u2-users@listserver.u2ug.org > > Subject: [U2] U2 group archives > > > > How do I find the message archives? > > > > Thanks, > > > > Ralph > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Lee J. Leitner, Ph.D. [EMAIL PROTECTED] http://www.leitner.org/~leitnerl The world can only be grasped by action, not by contemplation. The hand is the cutting edge of the mind. -- Jacob Bronowski V.13.0 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Select Question
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 Leicester" <[EMAIL PROTECTED]> To: Sent: Monday, July 25, 2005 6:12 PM Subject: Re: [U2] [UV] Select Question > > > 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 theory than it's currently worth. > > > >Charlie Rubeor > > It's wrong about it being any faster. But OTOH it's no slower either. > > I certainly identify with muscle-memory phrases so if what you do is > clear and works, more power to you. :-) > > Stewart > -- > Stewart Leicester| http://www.ThreatFocus.com > V.P. Engineering | mailto:[EMAIL PROTECTED] > Threat Focus, Inc. | 925-551-0130 Voice > "Knowledge is your best defense" | 509-695-1373 Fax > --- > 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] [UV] Select Question
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: Sent: Monday, July 25, 2005 12:17 PM Subject: RE: [U2] [UV] Select Question > 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] [UV] Select Question > > > > > >> 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 most programs it might be clearer to write > > LOOP >READNEXT ID FROM LIST ELSE EXIT >blah blah blah > REPEAT > > rather than testing a amgic valid of ID. > > > Martin Phillips > Ladybridge Systems > 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB > +44-(0)1604-709200 > --- > 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] [UV] Select Question
> 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 theory than it's currently worth. Charlie Rubeor It's wrong about it being any faster. But OTOH it's no slower either. I certainly identify with muscle-memory phrases so if what you do is clear and works, more power to you. :-) Stewart -- Stewart Leicester| http://www.ThreatFocus.com V.P. Engineering | mailto:[EMAIL PROTECTED] Threat Focus, Inc. | 925-551-0130 Voice "Knowledge is your best defense" | 509-695-1373 Fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Select Question
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: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Select Question 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 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 though :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug Sent: Monday, July 25, 2005 13:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Select Question 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 *** 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] [UV] Select Question > > > >> 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 most programs it might be clearer to write LOOP READNEXT ID FROM LIST ELSE EXIT blah blah blah REPEAT rather than testing a amgic valid of ID. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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/ --- 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] [UV] Select Question
> 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 theory than it's currently worth. Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315 x3498 860.523.3690 fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Select Question
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 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 though :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug Sent: Monday, July 25, 2005 13:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Select Question 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 *** 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] [UV] Select Question > > > >> 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 most programs it might be clearer to write LOOP READNEXT ID FROM LIST ELSE EXIT blah blah blah REPEAT rather than testing a amgic valid of ID. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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/ --- 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] [UV] Select Question
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 though :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug Sent: Monday, July 25, 2005 13:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Select Question 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 *** 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] [UV] Select Question > > > >> 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 most programs it might be clearer to write LOOP READNEXT ID FROM LIST ELSE EXIT blah blah blah REPEAT rather than testing a amgic valid of ID. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Select Question
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 BASIC variables would be the least of your problems. The distinction with using an EOF variable is that it is not referenced, until the next READNEXT. Each new variable that is read into memory will push the EOF variable further to the back. This definitely caused frame faults (I think that's what they were called) on Advanced Pick. On either U2 systems or on properly built systems, I doubt it makes a bit of difference, it might even slow things down. Charlie Rubeor I challenge whatever book made this contention. In the original Pick architecture variable descriptors are 10 bytes each and live together in groups of 50 or more (as was alluded to above). Since the EOF is a single character it would fit in the descriptor itself. In order for the EOF variable to be "swapped out" of memory for lack of reference, all other variables whose descriptors live in the same frame as the EOF variable would have to be unreferenced for the same period of time -- highly unlikely. Stewart -- Stewart Leicester| http://www.ThreatFocus.com V.P. Engineering | mailto:[EMAIL PROTECTED] Threat Focus, Inc. | 925-551-0130 Voice "Knowledge is your best defense" | 509-695-1373 Fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Select Question
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 *** 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] [UV] Select Question > > > >> 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 most programs it might be clearer to write LOOP READNEXT ID FROM LIST ELSE EXIT blah blah blah REPEAT rather than testing a amgic valid of ID. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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] Large UV VAR abandons Microsoft SQL Server/.NET Effort
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: Sent: Monday, July 25, 2005 1:37 PM Subject: Re: [U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort In the same note read this article: http://update.informationweek.com/cgi-bin4/DM/y/hpNU0GTFXz0G6t0DY2x0Encle: - Original Message - From: "Ross Morrissey" <[EMAIL PROTECTED]> To: Sent: Monday, July 25, 2005 11:31 AM Subject: [U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort 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 projects, but this has some firm numbers attached. After almost 2 years, less than 1 percent of their customer base switched over to the new system, and they wrote off the development effort for $67 million dollars. R&R Earnings report: http://biz.yahoo.com/prnews/050721/clth018.html?.v=16 "The company announced the discontinuance of the Reynolds Generations Series Suite DMS software product, installed in over 70 dealership locations since its introduction in September 2003. As a result, in its fourth fiscal quarter ending September 30, 2005, the company will write off about $67 million of capitalized software development. The company is currently evaluating any other potential impacts of this decision and may recognize additional costs in the fourth fiscal quarter." --- 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] Large UV VAR abandons Microsoft SQL Server/.NET Effort
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 please visit http://listserver.u2ug.org/
Re: [U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort
In the same note read this article: http://update.informationweek.com/cgi-bin4/DM/y/hpNU0GTFXz0G6t0DY2x0Encle: - Original Message - From: "Ross Morrissey" <[EMAIL PROTECTED]> To: Sent: Monday, July 25, 2005 11:31 AM Subject: [U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort 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 projects, but this has some firm numbers attached. After almost 2 years, less than 1 percent of their customer base switched over to the new system, and they wrote off the development effort for $67 million dollars. R&R Earnings report: http://biz.yahoo.com/prnews/050721/clth018.html?.v=16 "The company announced the discontinuance of the Reynolds Generations Series Suite DMS software product, installed in over 70 dealership locations since its introduction in September 2003. As a result, in its fourth fiscal quarter ending September 30, 2005, the company will write off about $67 million of capitalized software development. The company is currently evaluating any other potential impacts of this decision and may recognize additional costs in the fourth fiscal quarter." --- 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] [UV] Select Question
> 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 delimiters (FM, AM, VM, SVM, etc) whether you used them or not. Your fingers just typed in the EQUATE statements, even if your brain was not working. > 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 > BASIC variables > would be the least of your problems. > The distinction with using an EOF variable is that it is not referenced, until the next READNEXT. Each new variable that is read into memory will push the EOF variable further to the back. This definitely caused frame faults (I think that's what they were called) on Advanced Pick. On either U2 systems or on properly built systems, I doubt it makes a bit of difference, it might even slow things down. Also, I'm not sure which book this was in. Wasn't there a book called "Pick for Professionals", by Harvey Rodstein? It might have been in that one. Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315 x3498 860.523.3690 fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Select on an attribute
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. 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 > FILE2 SAVING FILE1_ID TO 2 MERGE.LIST 1 INTERSECTION 2 TO 3 SAVE.LIST > BLAH FROM 3 > > "BLAH" will contain the IDs you want, if I understand your question > correctly.) > > > --- Noah Hart <[EMAIL PROTECTED]> wrote: > > > 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. > "...a livable wage is a moral value. Affordable health care is a moral > value. A decent education is a moral value. A common sense foreign > policy is a moral value. A healthy environment is a moral value. The > feeling of community that comes from full participation in our > democracy is a moral value. It is a moral value to make sure that we > do not saddle our children and grandchildren with our debt." > > -Howard Dean (Hmm. I'd swear I've heard either him or his buddies say "you can't legislate morality".) --- 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] Select on an attribute
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, 2005 9:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Select on an attribute 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 Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock > Sent: Monday, July 25, 2005 10:18 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Select on an attribute > > > (If "BLORP" is your savedlist from File1) GET.LIST BLORP TO 1 SELECT > FILE2 SAVING FILE1_ID TO 2 MERGE.LIST 1 INTERSECTION 2 TO 3 SAVE.LIST > BLAH FROM 3 > > "BLAH" will contain the IDs you want, if I understand your question > correctly.) > > > --- Noah Hart <[EMAIL PROTECTED]> wrote: > > > 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 this possible? > > > > Thank you, > > > > Noah > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > "...a livable wage is a moral value. Affordable health care is a moral > value. A decent education is a moral value. A common sense foreign > policy is a moral value. A healthy environment is a moral value. The > feeling of community that comes from full participation in our > democracy is a moral value. It is a moral value to make sure that we > do not saddle our children and grandchildren with our debt." > > -Howard Dean > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Select on an attribute
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 > FILE2 SAVING FILE1_ID TO 2 MERGE.LIST 1 INTERSECTION 2 TO 3 > SAVE.LIST BLAH FROM 3 > > "BLAH" will contain the IDs you want, if I understand your question > correctly.) > > > --- Noah Hart <[EMAIL PROTECTED]> wrote: > > > 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. > "...a livable wage is a moral value. Affordable health care > is a moral value. A decent education is a moral value. A > common sense foreign policy is a moral value. A healthy > environment is a moral value. The feeling of community that > comes from full participation in our democracy is a moral > value. It is a moral value to make sure that we do not saddle > our children and grandchildren with our debt." > > -Howard Dean (Hmm. I'd swear I've heard either him or his buddies say "you can't legislate morality".) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Select on an attribute
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, unless you make it a name that you always use when you save the list. George -Original Message- From: George Gallen Sent: Monday, July 25, 2005 1:38 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Select on an attribute 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 THEN "" ELSE "Y" 4. SELECT FILE2 WITH MULTIMATCH="Y" Of course, you would need to do this for each savedlist you pull from list1 and...I'm not sure if that I-desc will work in Unidata. George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Select on an attribute
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 THEN "" ELSE "Y" 4. SELECT FILE2 WITH MULTIMATCH="Y" Of course, you would need to do this for each savedlist you pull from list1 and...I'm not sure if that I-desc will work in Unidata. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Noah Hart Sent: Monday, July 25, 2005 12:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Select on an attribute Sharyl, That works great if I want all the matches. My specific problem (which I was not clear on before) is that I will only have a small number of ID in my save list. For example: SELECT ALL CUSTOMERS in CALIFORNIA SAVE-LIST CACUST then I want to say SELECT ALL INVOICES WITH CUSTOMER IN SAVE-LIST CACUST Thanks, Noah -Original Message- From: Sharyl Lindsay [mailto:[EMAIL PROTECTED] Sent: Monday, July 25, 2005 8:22 AM To: Noah Hart Subject: RE: [U2] [UD] Select on an attribute Hi Noah, If I'm understanding you correctly, I'd do the following: QSELECT FILE2 (1 SAVE-LIST xxLISTNAME GET-LIST xxLISTNAME SELECT FILE1 This will give you all the items in FILE1 that have the same value as attribute two of FILE2. Sharyl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Monday, July 25, 2005 7:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Select on an attribute 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 this possible? Thank you, Noah --- 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] Select on an attribute
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 all records in file2 which have FILE1_ID > matching the savedlist I already have. > > Is this possible? 1. In basic, something like: OPEN 'File2' to F2.FVAR GETLIST [list of File1 IDs] F2ID.LIST = '' LOOP WHILE READNEXT F1.ID SELECTINDEX 'FILE1_ID', F1.ID FROM F2.FVAR TO 10 READLIST SUBLIST FROM 10 THEN F2ID.LIST<-1> = SUBLIST REPEAT Now F2ID.LIST has what you want. I'll leave it to you to come up with variations on the theme that suits you. My own generic solution is a utility XSELECT verb (with "K"eep active flag in VOC<4>) which takes an active select list of indexed values and generates an active list of corresponding primary ids. In this case: >GET.LIST [list of File1 IDs] >>XSELECT File2 FILE1_ID I wish UV had that verb out of the box. 2. QSELECT, if 1st you set up a voc pointer to the normally hidden type-25 I_File2/INDEX.nnn file (let's call it FILE1.FIE2.IDX in the VOC) : >GET.LIST [list of File1 IDs] >>QSELECT FILE1.FILE2.IDX Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Select on an attribute
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 Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock > Sent: Monday, July 25, 2005 10:18 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Select on an attribute > > > (If "BLORP" is your savedlist from File1) > GET.LIST BLORP TO 1 > SELECT FILE2 SAVING FILE1_ID TO 2 > MERGE.LIST 1 INTERSECTION 2 TO 3 > SAVE.LIST BLAH FROM 3 > > "BLAH" will contain the IDs you want, if I understand your > question correctly.) > > > --- Noah Hart <[EMAIL PROTECTED]> wrote: > > > 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 this possible? > > > > Thank you, > > > > Noah > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > "...a livable wage is a moral value. Affordable health care > is a moral value. A decent education is a moral value. A > common sense foreign policy is a moral value. A healthy > environment is a moral value. The feeling of community that > comes from full participation in our democracy is a moral > value. It is a moral value to make sure that we do not saddle > our children and grandchildren with our debt." > > -Howard Dean > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.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][UV]Error Handling
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 message and halt program execution? What I would > > like is to have Universe send some sort of notification when an error > > occurs. > > Not exactly, but here are a few ideas: > > 2. There is ON.ABORT paragraph available to you to handle > fatal errors. > I trap them and populate another file & send emails. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Select Question
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 I can fix your errors. 2) Do it your way, and I'll be calling you at 2am to fix your own errors. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Select on an attribute
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 attribute (If "BLORP" is your savedlist from File1) GET.LIST BLORP TO 1 SELECT FILE2 SAVING FILE1_ID TO 2 MERGE.LIST 1 INTERSECTION 2 TO 3 SAVE.LIST BLAH FROM 3 "BLAH" will contain the IDs you want, if I understand your question correctly.) --- Noah Hart <[EMAIL PROTECTED]> wrote: > 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 this possible? > > Thank you, > > Noah > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > "...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt." -Howard Dean __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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] [UV] Select Question
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, usually EOF, > in the ELSE clause, the variable would get forced out of memory and would > have to be read back in from disk for each subsequent READNEXT. The > attribute mark, on the other hand, was usually equated. On the systems of > that time, this resulted in a fairly big improvement in larger programs. > In small programs, where everything fit into memory, this would not > provide any benefit. 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 Pick Programming book that was writen using generic code that would run acrost all platforms. I'll have to check my copy later today as I'm not at my office just now. 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 BASIC variables would be the least of your problems. The main argument against it, is that it's not as clear as using True and False, which are nearly universally understood concepts in programming. Coding simply, means less learning curve for your new programmers. I have headed a few programming departments, and in my opinion, in the contest between getting programmers up-to-speed, and getting the machine to run as efficient as possible; the programmers have to win every time. That's my three cents. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort
In a message dated 7/25/2005 9:39:13 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > The company is currently > evaluating any other potential impacts of this decision and may recognize > additional costs in the fourth fiscal quarter." > Hopefully one potential impact is to fire all the people who suggested doing this in the first place. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Select on an attribute
Sharyl, That works great if I want all the matches. My specific problem (which I was not clear on before) is that I will only have a small number of ID in my save list. For example: SELECT ALL CUSTOMERS in CALIFORNIA SAVE-LIST CACUST then I want to say SELECT ALL INVOICES WITH CUSTOMER IN SAVE-LIST CACUST Thanks, Noah -Original Message- From: Sharyl Lindsay [mailto:[EMAIL PROTECTED] Sent: Monday, July 25, 2005 8:22 AM To: Noah Hart Subject: RE: [U2] [UD] Select on an attribute Hi Noah, If I'm understanding you correctly, I'd do the following: QSELECT FILE2 (1 SAVE-LIST xxLISTNAME GET-LIST xxLISTNAME SELECT FILE1 This will give you all the items in FILE1 that have the same value as attribute two of FILE2. Sharyl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Monday, July 25, 2005 7:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Select on an attribute 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 this possible? Thank you, Noah --- 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] [UV] Select Question
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 the syntax because I my fingers can type it from memory, without my brain actually working." I Love that statement. A non-programmer just wouldn't understand and would likely cause fear in them .. especially the bosses.. to know this is part of a programmers inner workings. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort
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 projects, but this has some firm numbers attached. After almost 2 years, less than 1 percent of their customer base switched over to the new system, and they wrote off the development effort for $67 million dollars. R&R Earnings report: http://biz.yahoo.com/prnews/050721/clth018.html?.v=16 "The company announced the discontinuance of the Reynolds Generations Series Suite DMS software product, installed in over 70 dealership locations since its introduction in September 2003. As a result, in its fourth fiscal quarter ending September 30, 2005, the company will write off about $67 million of capitalized software development. The company is currently evaluating any other potential impacts of this decision and may recognize additional costs in the fourth fiscal quarter." --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV]Error Handling
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: [U2][UV]Error Handling > Is there a way to override error handling in Universe to do > something other than display a message and halt program > execution? What I would like is to have Universe send some > sort of notification when an error occurs. Not exactly, but here are a few ideas: 1. Errors (fatal & not) are recorded in $UVHOME/errlog. It's size is limited but configurable by uvconfig's MAXERRLOGENT. I have a phantom that continually polls this text file and populates my own structured hashed file & generate reports emailed to me and others. 2. There is ON.ABORT paragraph available to you to handle fatal errors. I trap them and populate another file & send emails. 3. On case by case basis, WRITE & other basic statements likely to be implicated in errors allow for ON ERROR clauses. Search for ON ERROR in the documentation pdf. I have a utility purpose subroutine that I stick in places like these ON ERROR clauses. The subroutine allows a text argument to be sent from the calling program & it also captures SYSTEM(9001) call stack info, then writes all that to a file, which is monitored. So far I haven't implemented an email from the subroutine, but probably should. cds --- 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] Select on an attribute
(If "BLORP" is your savedlist from File1) GET.LIST BLORP TO 1 SELECT FILE2 SAVING FILE1_ID TO 2 MERGE.LIST 1 INTERSECTION 2 TO 3 SAVE.LIST BLAH FROM 3 "BLAH" will contain the IDs you want, if I understand your question correctly.) --- Noah Hart <[EMAIL PROTECTED]> wrote: > 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 this possible? > > Thank you, > > Noah > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > "...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt." -Howard Dean __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Select Question
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] [UV] Select Question > > > >> 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 most programs it might be clearer to write LOOP READNEXT ID FROM LIST ELSE EXIT blah blah blah REPEAT rather than testing a amgic valid of ID. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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] Connecting SQL server from Universe
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 unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Select on an attribute
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 this possible? Thank you, Noah --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Select Question
Quote: "These days, I still use the syntax because I my fingers can type it from memory, without my brain actually working." I Love that statement. A non-programmer just wouldn't understand and would likely cause fear in them .. especially the bosses.. to know this is part of a programmers inner workings. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Select Question
> > > >> 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 most programs it might be clearer to write LOOP READNEXT ID FROM LIST ELSE EXIT blah blah blah REPEAT rather than testing a amgic valid of ID. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Select Question
[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 that could have > happened. > 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, usually EOF, in the ELSE clause, the variable would get forced out of memory and would have to be read back in from disk for each subsequent READNEXT. The attribute mark, on the other hand, was usually equated. On the systems of that time, this resulted in a fairly big improvement in larger programs. In small programs, where everything fit into memory, this would not provide any benefit. These days, I still use the syntax because I my fingers can type it from memory, without my brain actually working. Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315 x3498 860.523.3690 fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] THE variable names
I know a assembler (not mcd but BAL) and PROC. Don't miss them though. - Original Message - From: "Mark Baldridge" <[EMAIL PROTECTED]> To: Sent: Sunday, July 24, 2005 11:50 AM Subject: Re: [U2] THE variable names > Could we not just avoid confusing the old(er) timers by just using > assembler and PROC? > > Mark A. Baldridge > Principal Consultant > North American Lab Services > DB2 Information Management, IBM Software Group > (607) 351-5666 > --- > 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] [UV] UV903 Course is being offered in New Zealand {Unclassified}
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, even the old UV903 is quite suitable for UniData programmers as well as UniVerse programmers. Subtle differences can be highlighted by the instructor. - Original Message - From: "HENDERSON MIKE, MR" <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Subject: [U2] [UV] UV903 Course is being offered in New Zealand {Unclassified} Date: Mon, 25 Jul 2005 13:02:09 +1200 > > Folks, > > Apologies to the vast majority of the list who don't have the advantage > of living in NZ, but this is the only way I can think of for getting to > the NZ sites. > > > > > Ace Training are advertising the "UV903:IBM U2 Universe Database > Programming" as being available starting on 12th September in either > Wellington or Auckland. > This course is, as usual, subject to their having sufficient numbers. > I have one potential attendee, so if anyone else on the list has one or > more people who would benefit from this training, please let Ace know. > Or if you know of UV sites in NZ that do UniBasic programming who aren't > on the list, please pass it on to them [as well as encouraging them to > subscribe to the list, of course!] > > > The contact person is:- > > Felicity Neate [mailto:[EMAIL PROTECTED] > ACE Training Limited > PO Box 10 721 * The Terrace * Wellington > Tel 04-472 4830 > > > > > Thanks > > > Mike > The information contained in this Internet Email message is intended > for the addressee only and may contain privileged information, but not > necessarily the official views or opinions of the New Zealand Defence Force. > If you are not the intended recipient you must not use, disclose, copy or > distribute this message or the information in it. > > If you have received this message in error, please Email or telephone > the sender immediately. > --- > 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/