[U2] Help with REVISE (AKA ENTRO/ENTROC)

2013-01-23 Thread Clifton Oliver
Apparently somewhere through the years, my brain has dropped a few bits about 
using REVISE.

In a multivalue association on screen 2 (or 3, 4, etc.), you can delete a row 
by selecting the row, choosing the first field, and entering ##. No problem.

I *thought* to insert a row, you selected a row, chose the first field, and 
entered a . But when I do that, I get Line 0 has not been defined.

Can someone please tell me what I've mis-remembered? How do you insert a 
value (not add to the end, it has to be inserted between two exiting values) in 
REVISE/ENTRO?

Your help will be greatly appreciated!

Regards,

Clif

--  
W. Clifton Oliver, CCP  
CLIFTON OLIVER  ASSOCIATES  
Tel: +1 225 341 1778Web: www.oliver.com  

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


Re: [U2] Another job ad written by people who have no clue

2012-11-01 Thread Clifton Oliver
So me a person who wants* to work in RPL, and I'll show you desperate.


On Nov 1, 2012, at 10:46 AM, Wjhonson wjhon...@aol.com wrote:

 http://simply.engcen.com/JobAdCareerJet.asp?JobID=1253361
 
 Really don't these people get actual... you know... specs?
 What did they do skip some words?
 
 Show me a single person in the world who has all of : Universe, Unidata, D3, 
 Jbase, Revelation AND RPL
 and I will show you a liar
 
 Clearly they meant something like either/or
 ___
 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] Command that turns off default command stacker

2012-05-05 Thread Clifton Oliver
ED VOC STACKWRITE

Change ON to Off

I think that's what you are looking for. 



On May 5, 2012, at 12:11 PM, Wjhonson wjhon...@aol.com wrote:

 
 The users arent getting to TCL
 The stack is created simply by logging in.
 It doesn't matter if you are at TCL or not.
 
 
 
 
 
 
 -Original Message-
 From: Bill Haskett wphask...@advantos.net
 To: U2 Users List u2-users@listserver.u2ug.org
 Sent: Sat, May 5, 2012 12:06 pm
 Subject: Re: [U2] Command that turns off default command stacker
 
 
 ok, well...  a reasonably written replacement is a shell.  You never get 
 to real tcl, so you don't have that problem.
 
 Bill
 
 - Original Message -
 *From:* wjhon...@aol.com
 *To:* u2-users@listserver.u2ug.org
 *Date:* 5/5/2012 12:04 PM
 *Subject:* Re: [U2] Command that turns off default command stacker
  It isn't, that's the point.
 It's turned on by default when you load Universe
 It sits there in the background creating thousands of savedlists since it 
 makes one for every user and port combination
 
 We have thousands of ports and dozens of users and it's been this way for 8 
 years now
 
 Times every account they may log to and some of our users log into multiple 
 accounts during the day
 The 40,000 lists i mentioend was for just *one* account.
 The users dont use the stacker, but that doesnt matter it merrily creates a 
 stack that just says LOGIN ove and over and over
 
 
 
 
 
 -Original Message-
 From: Bill Haskettwphask...@advantos.net
 To: U2 Users Listu2-users@listserver.u2ug.org
 Sent: Sat, May 5, 2012 11:50 am
 Subject: Re: [U2] Command that turns off default command stacker
 
 
 After all of these years, it's hard for me to digest the fact that the
 porcine U2 stacker is even in use!  :-)
 
 Bill
 
 
 - Original Message -
 *From:* wjhon...@aol.com
 *To:* u2-users@listserver.u2ug.org
 *Date:* 5/5/2012 8:43 AM
 *Subject:* Re: [U2] Command that turns off default command stacker
 Well you have to do it at least once!
 In a single one of our accounts we had 44000 of these buggers
 
 
 -Original Message-
 From: Allen Elwood RRaelw...@socal.rr.com
 To: U2 Users Listu2-users@listserver.u2ug.org
 Sent: Sat, May 5, 2012 1:02 am
 Subject: Re: [U2] Command that turns off default command stacker
 
 
 or you could just write a program to purge the file of those entries and
 run it from time to time :-)
 
 On 5/4/2012 5:35 PM, Wjhonson wrote:
 I found the answer
 
 In the VOC is an item called STACKWRITE
 the first attribute is an X
 the second attribute says ON
 
 If you change that second attribute to OFF
 then universe will stop creating all these thousands of savedlists entries
 which are keyed to user combined with port number
 
 ___
 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] SQL Equiv to Save-list?

2010-04-08 Thread Clifton Oliver
How about

SELECT CUSTNAME, CUSTADDR, CUSTCITY FROM CUSTOMERFILE SLIST 'saved_list-name';

Regards,

Clif

-- 
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com


On Apr 8, 2010, at 1:28 PM, Perry Taylor wrote:

 You might try...
 
   select custname, custaddr, custcity from customerfile where
 custid in (select EVAL @RECORD from SAVEDLISTS
 'the_saved_list_name');
 
 Perry
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
 Sent: Thursday, April 08, 2010 8:09 AM
 To: U2 Users List
 Subject: [U2] SQL Equiv to Save-list?
 
 Is there a way in SQL without resorting to subqueries to select a table,
 then save the resulting field,
 Then use that list for a future SQL query?
 
 ex. select customerid from invoicefile;
   save the list of customerid for later use
 
 later
 
  get that list of customerid
  select cust.name , cust.addr , cust.city, etc  from customerfile
 where cust.id=(list of customerid) and cust.st='ny'
 
 
 Or is this one of those pick ain't it great we can do this features?
 
 
 George Gallen
 Senior Programmer/Analyst
 Accounting/Data Division, EDI Administrator
 ggal...@wyanokegroup.com
 ph:856.848.9005 Ext 220
 The Wyanoke Group
 http://www.wyanokegroup.com
 
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 CONFIDENTIALITY NOTICE: This e-mail message, including any 
 attachments, is for the sole use of the intended recipient(s) 
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is 
 prohibited. ZirMed, Inc. has strict policies regarding the 
 content of e-mail communications, specifically Protected Health 
 Information, any communications containing such material will 
 be returned to the originating party with such advisement 
 noted. If you are not the intended recipient, please contact 
 the sender by reply e-mail and destroy all copies of the 
 original message.
 ___
 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] Pick Pocket Guide

2010-03-23 Thread Clifton Oliver
In Spectrum magazine, we use the term MultiValue Basic to talk about the 
programming language in articles that are not platform specific. I put it in 
the style and usage guide for just the reasons being brought up here. I don't 
see any reason not to add other MultiValue generic terms. MultiValue Query 
comes to mind. I'm open to suggestions about that and other terms. Post them 
here, or if you'd rather not, just send them to me at edi...@intl-spectrum.com 
(or my regular e-mail address).


Regards,

Clif

-- 
Clifton Oliver, Managing Editor
International Spectrum Magazine
Spectrum Tel: +1 720 259 1356
Clif's Direct Tel: +1 619 460 5678



On Mar 23, 2010, at 10:40 AM, Brian Leach wrote:

 Tony
 
 As always you make some good points.
 
 1/ It's not the term MultiValue I have a problem with - that we should
 continue to support since it already has a meaning and a presence, and one
 worth building on. For one thing, MVDBMS is a nice abbreviation!
 
 It's the terminology used within that, that is the problem: for example, I
 want to put some web pages out giving an introduction to the query language.
 What do I call it? If I use the word 'RetrieVe' that alienates every other

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


Re: [U2] Pick Pocket Guide

2010-03-23 Thread Clifton Oliver
Well, the terminology issue is something we (Spectrum magazine in particular) 
can promote since we are already committed to promoting the term MultiValue 
(note the mid-cap casing) and the MultiValue Logo. We just add such terms to 
our Style and Usage Guide and use them in the magazine.

Side note: Is there any interest in us having our Style and Usage Guide 
available online?



I'm interested in hearing what folks would find an acceptable term for 
TCL/ECL/etc.

As to the idea of of a generic book, groups of experts, etc., that sounds like 
a fame and glory no profit Open Source kind of thing. A lot of the experts you 
might want to attract are dudes and dudettes trying to make a living. That goes 
back to some of Tony's comments. How could that be made worthwhile for said 
experts to forgo revenue producing time to produce a non-profit book?

Considering some other Open Source documentation efforts, I'm not saying it 
can't be done. I'm just challenging everyone to present detailed ideas for how 
it could be made to work.


Regards,

Clif



On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote:

 I think it would be great do something like this.
 
 Multivalue Query [mvQuery]
 Multivalue Basic [mvBasic]
 Multivalue PROC  [mvPROC]
 
 I also think it would be great if someone could write a piece of a book that
 is very generic (keep it at a 20,000 foot view) which covers each major
 topic area.  Once complete, a group of experts-at-large in the various
 flavors add platform specific details.  When complete, one or more of the
 know-it-alls [like some of the gurus on this list] combine the common parts,
 while leaving the unique areas in place.  Basically, a wiki to book
 transformation.  Many of the books sold today have two, three, and even more
 authors (especially the technically oriented books).  Something like this
 could reduce the work required (just doing a piece of the whole) and
 increase the potential market (supports most platforms) for sales.  I see a
 lot of talent on this list that can pull something like this off, it just
 needs a great leader (and I see many of them here too).
 
 Regards,
 
 Jim
 
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver
 Sent: Tuesday, March 23, 2010 6:39 PM
 To: U2 Users List
 Subject: Re: [U2] Pick Pocket Guide
 
 In Spectrum magazine, we use the term MultiValue Basic to talk about the
 programming language in articles that are not platform specific. I put it in
 the style and usage guide for just the reasons being brought up here. I
 don't see any reason not to add other MultiValue generic terms. MultiValue
 Query comes to mind. I'm open to suggestions about that and other terms.
 Post them here, or if you'd rather not, just send them to me at
 edi...@intl-spectrum.com (or my regular e-mail address).
 
 
 Regards,
 
 Clif
 
 -- 
 Clifton Oliver, Managing Editor
 International Spectrum Magazine
 Spectrum Tel: +1 720 259 1356
 Clif's Direct Tel: +1 619 460 5678
 
 ___
 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] Pick Pocket Guide

2010-03-23 Thread Clifton Oliver
Got it. grin

I'll get it updated with our latest revisions and get an html version up 
shortly. (Read: It's my part-time job. I'll get to it--promise)


Regards,

Clif



I'll post here and elsewhere when it available.
On Mar 23, 2010, at 10:34 PM, Dan McGrath wrote:

 My apologises,
 
 I'd be interesting in reading should have been I'd be interested in
 reading the Style and Usage Guide
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
 Sent: Wednesday, 24 March 2010 4:31 PM
 To: U2 Users List
 Subject: Re: [U2] Pick Pocket Guide
 
 Hi Clif,
 
 I'd be interesting in reading. I write the occasional piece and probably
 should use more encompassing terms to enhance future search-ability and
 to promote the database style.
 
 Regarding ECL/TCL/etc, since I'm normally in Unix/Linux land, I normally
 think of them as shells, which brings MultiValue Shell (MVSH) to mind.
 
 ###
 The information transmitted in this message and attachments (if any) is 
 intended only
 for the person or entity to which it is addressed. The message may contain 
 confidential
 and/or privileged material.  Any review, retransmission, dissemination or 
 other use of
 or taking of any action in reliance upon this information by persons or 
 entities other
 than the intended recipient is prohibited.  If you received this in error, 
 please
 contact the sender and delete the material from any computer.
 
 The intended recipient of this e-mail may only use, reproduce, disclose or 
 distribute
 the information contained in this e-mail and any attached files with the 
 permission of IMB.
 ###
 ___
 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] Pick Pocket Guide

2010-03-22 Thread Clifton Oliver
Well, when the best known providers can't even get correct documentation in 
their manuals or examples that actually work, one wonders how suited they are 
to producing such literature. I'm not arguing against your point that they 
*should* be the leaders--like Sun, Microsoft, etc.--in literature. But really, 
when their own manuals have gross errors that have gone uncorrected for 5 to 10 
years, who would trust them?

Several years ago, I offered one of the major providers that I would re-write 
their course material for free just to make sure we had something to teach from 
that was at least correct. No charge.

They weren't interested.

Go figure.


Regards,

Clif


On Mar 22, 2010, at 1:20 PM, Symeon Breen wrote:

 There is none of this
 in the MV world - the providers are the best suited to producing such
 literature, and in my opinion should be taking the lead in this 

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


Re: [U2] Terminal Emulator and Telnet Client for a MacBook Pro

2010-03-21 Thread Clifton Oliver
Yes. Parallels only runs on the Intel Macs. For the PowerPC Macs the option was 
VirtualPC. (Before Microsoft acquired it. Don't know if they kept it available 
for Mac after that.) It was slow, but for the most part worked. 

Regards,

Clif

-- 
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com


On Mar 20, 2010, at 8:42 AM, Anthony W. Youngman wrote:

 In message 005901cac75f$0852b8e0$18f82a...@com, Kevin Gusler 
 kgus...@mortgagebuilder.com writes
 Has anyone tried running SBClient 5.3.4 - 5.4.4 in Parallels on a Mac? Are
 there any issues? We are running (windows) SB+ 5.3.4 and Universe 10.3.3 and
 have a few users that wish to use Macs for their client pc's. Just wondered
 if there was a downside.
 
 How new are the Macs? Does parallels only run on the new Intel Macs? (Sorry, 
 I don't use a Mac, don't know when the switchover was. But there are probably 
 still a fair few Power Macs still in general circulation.)
 
 Thanks in advance.
 
 Cheers,
 Wol
 -- 

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


Re: [U2] Terminal Emulator and Telnet Client for a MacBook Pro

2010-03-17 Thread Clifton Oliver
Hi, Dave.

I use iTerm. It's free (in both senses of the word). 
http://iterm.sourceforge.net/

Regards,

Clif

-- 
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com


On Mar 17, 2010, at 2:32 PM, Dave Taylor wrote:

 Does anyone have a recommendation for a terminal emulator and telnet client 
 for a MacBook Pro or any MAC OS X operating system that will connect to 
 Universe/Unidata?
 
 Thanks,
 
 Dave Taylor
 Sysmark Information Systems, Inc.
 49 Aspen Way
 Rolling Hills Estates, CA 90274
 (O) 800-SYSMARK (800-797-6275)
 (F) 310-377-3550
 (C) 310-561-5200
 www.sysmarkinfo.com
 ___
 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] Terminal Emulator and Telnet Client for a MacBook Pro

2010-03-17 Thread Clifton Oliver
Aw, you're just jealous 'cause we get to use a real operating system.

;-)


On Mar 17, 2010, at 2:57 PM, Symeon Breen wrote:

 I recommend you buy a pc and use that instead 
 
 
 
 Sorry - i just don't like apple .
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor
 Sent: 17 March 2010 21:33
 To: u2-users@listserver.u2ug.org
 Subject: [U2] Terminal Emulator and Telnet Client for a MacBook Pro
 
 Does anyone have a recommendation for a terminal emulator and telnet client
 for a MacBook Pro or any MAC OS X operating system that will connect to
 Universe/Unidata?
 
 Thanks,
 
 Dave Taylor
 Sysmark Information Systems, Inc.
 49 Aspen Way
 Rolling Hills Estates, CA 90274
 (O) 800-SYSMARK (800-797-6275)
 (F) 310-377-3550
 (C) 310-561-5200
 www.sysmarkinfo.com
 ___
 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] Spectrum

2010-03-08 Thread Clifton Oliver

I'll be there.

Regards,

Clif

--  
W. Clifton Oliver, CCP

CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com


On Mar 4, 2010, at 12:55 PM, Kevin King wrote:


Anybody?  Bueller?  Bueller?

On Wed, Mar 3, 2010 at 9:55 AM, Kevin King precisonl...@gmail.com  
wrote:



Spectrum is just over a month away.  Who's in?

-Kevin
http://www.PrecisOnline.com





--
-Kevin
http://www.PrecisOnline.com
___
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] Unidata PE Linux

2009-11-13 Thread Clifton Oliver

Would you mind sharing what those tweeks were?

Thanks.


Regards,

Clif


On Nov 13, 2009, at 9:46 AM, Douglas Hedges wrote:


I got a PE for Linux (RHat) from IBM before Rocket took over.  I
installed it on Ubuntu and am just now testing it (so far, so good).
There are a few tweaks but nothing major to getting it installed.
I


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


Re: [U2] Agile and Scrum

2009-10-15 Thread Clifton Oliver
Agreed. An excellent post. And at 769 words, it's half an article.  
(Hint, hint.)


David, if you (or anyone else reading this thread) would like to  
contribute an article to Spectrum magazine on this or related topics,  
please contact me.


You can reach me at my part-time address, edi...@intl-spectrum.com,  
or at my regular address or phone number in the sig block below.


An Agile Anecdote: I was going to try a simple form of XP (Extreme  
Programming) on a project several years ago. The client loved the idea  
and agreed to it with few reservations. I knew they just didn't get  
it when the next meeting they asked me to provide them with a Gantt  
chart showing the iteration milestones and what features would be in  
each iteration.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com


On Oct 15, 2009, at 1:36 PM, Boydell, Stuart wrote:


Good post!

Stuart Boydell

-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org 
] On Behalf Of David A Barrett

Sent: Friday, 16 October 2009 07:01
To: u2-users@listserver.u2ug.org
Subject: [U2] Agile and Scrum

As a Scrum practitioner in an MV environment for the past 5 years or  
so, I

think I can shed some light on this.  First, the Agile Manifesto:




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


Re: [U2] Indexing

2009-09-14 Thread Clifton Oliver
I seem to recall that they added the CONCURRENT option to BUILD.INDEX  
several years back but didn't document it except in the patch file for  
that release.


Does anyone else remember this?

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com


On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote:

Building indices means exclusive locks on the file, i.e., downtime.  
The

good news is that the builds are usually very quick.


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


Re: [U2] which files have triggers

2009-07-22 Thread Clifton Oliver

November/December 2007.

www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx

Regards,

Clif


On Jul 13, 2009, at 12:23 PM, Brian Leach wrote:


Hi George

I wrote about this in one of the back issues of Spectrum (you can  
download

these from www.intl-spectrum.com).



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
George Gallen
Sent: 13 July 2009 19:51
To: U2 Users List
Subject: [U2] which files have triggers

Is there a way to list which tables have active triggers?

I know about LIST.SICA tablename, but if I make a change to
the trigger program,
  and I need to DROP the trigger from all the TABLES usings
it, how would I find
  out all the TABLES that are using that trigger?



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


[U2] [UV] UniDebugger FTP mode

2009-05-21 Thread Clifton Oliver

Does anyone know a way to change the UniDebugger's FTP mode to Passive?

Thanks.

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] International Spectrum Conference - Twitter?

2009-03-20 Thread Clifton Oliver
As the Managing Editor of International Spectrum magazine (one of my  
Part-Time jobs), I'm thinking of Twittering from the Conference next  
week. Being new this social media, I have to wonder if this is of any  
interest to people or just adding to the Noise of the Internet.


I'd like to hear your opinions.

Regards,

Clif

Twitter: @clifolliver

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] International Spectrum Conference - Twitter?

2009-03-20 Thread Clifton Oliver
My last comment on this before suggesting we now move over to the u2- 
community list if there are further ideas of a non-technical nature.  
(I found Symeon's idea of using Twitter to pass along alerts from  
phantoms rather clever.)


I want to thank everyone who shared their comments, both on list and  
off.


There are some other attendees who responded and are now following,  
so I've created a hashtag #intlspec and defined it on tagal.us. If  
other's tweet from the Conference and include that (including the #)  
in their note, anyone interested can see a multi-person commentary on  
twitter.com (login required) or hashtags.org (no login required).


I, for one, am not going to be attempting to blog all the day's  
events; I don't think Twitter would work very well for that. You won't  
be hearing (from me, anyway) what I had for breakfast. Like others, I  
can't wonder why anyone would think anybody but their cardiologist  
would care. I have in mind observations, notes, comments, and ideas  
for articles for those who might want to be published. Hopefully some  
other attendees will join in so there is a variety of opinions and  
ideas.


This is an experiment. Could be fun, might prove useful, may be a flop.

As to a blog--I've talked with Nathan Rector and passed your comments  
and requests along.


If anyone wants to continue a discussion of this or other social  
media has a place in business, let's take it over to u2-community list.


Looking forward to seeing some of you at the Conference!

Thanks again.


Regards,

Clif


On Mar 20, 2009, at 12:28 PM, Tony G wrote:


From: Glen Batchelor

Clif,
Why don't you just set up a new category in the
Spectrum blog for conference happenings? It has an RSS
feed built-in and anyone can check on it from the
intarweb. You can post video segments, if equipment is
available, and sound bytes.


I think the point is that there isn't a blog or other mechanism
setup, but he already twitters and almost anyone can just visit
that one web page.  Like I said, I don't personally like the idea
of Twitter (social blogs tell you what someone had for breakfast
but now twitter allows them to tell you about every bite) but it
_is_ a popularly accepted phenomenon and can probably be used for
non-silly purposes (like trade shows) if given the chance.  I'd
say if he has it, do it, and if people aren't interested, tough.
Ya can't please everyone all the time.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] U2.NET question

2009-03-19 Thread Clifton Oliver

Hi, all.

Is U2.NET included with (in this case) UniVerse like UniObjects.NET  
is, or is it a separate priced product like U2 Web DE (aka Redback)?


Thanks.

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe Triggers

2008-10-15 Thread Clifton Oliver
Which can get interesting if you have some of that old pre-EXECUTE  
legacy code that generates a Proc, writes it to the VOC, and CHAINs to  
it. Or that executes CREATE.FILE. Or that...


Of course, you can put a trigger on the VOC to log changes.


Regards,

Clif


On Oct 15, 2008, at 5:40 AM, Anthony Youngman wrote:

But IF you can update VOC, you CAN bypass remote voc, which is what  
David said!


As part of your security you need to make sure that users CAN'T  
update VOC (which is rather harder than it seems at first glance).


Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
] On Behalf Of Susan Joslyn

Sent: 15 October 2008 12:36
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers

David,
With the use of remote voc you really can prevent by-pass of  
wrapped TCL

commands.  Completely, unequivocably.

Regards,
Susan Joslyn
SJ+ Systems Associates, Inc.
PRC(r) Real software configuration management for U2!


--

Date: Wed, 15 Oct 2008 08:26:00 +1100
From: Hona, David S [EMAIL PROTECTED]
Subject: RE: [U2] Universe Triggers

You can by-pass them if you can update the VOC.
---
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] Universe Triggers

2008-10-08 Thread Clifton Oliver

Why not just test it?

Create a file with some number of records. Write a simple program to  
select the file and change one character in the record. Write it back  
to the file. Time it.


Add an AFTER UPDATE trigger calling a subroutine that does *nothing*  
but a RETURN. Run the program again. Time it.


You have your overhead answer.

Don't ask opinions of pontificators when the machine will tell you the  
truth.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Oct 7, 2008, at 8:22 PM, Mike Roosa wrote:

We are getting ready to implement triggers on a universe system  
running
under Windows Server 2003.  I created a trigger and tested it out  
and it
appears to do exactly what we need.  My question is are there any  
gotchas or

issues we should be concerned about with triggers?  Are there any
performance issues that anyone has seen related to triggers?

Thanks,
Mike Roosa
---
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] Universe Triggers

2008-10-08 Thread Clifton Oliver
Brian wrote an excellent article about UniVerse Triggers in the Nov/ 
Dec 2007 of International Spectrum magazine (p. 12). You can download  
that issue from


http://www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Oct 8, 2008, at 1:54 AM, Brian Leach wrote:


One gotcha is that once a trigger is on there, you can't easily
change/extend it unless your system has a downtime period in which  
everyone
is logged out. For this reason on 24x7 sites I use a master trigger  
that can
call subtriggers, held as a list in a parameter file. This means  
that a new
subtrigger can be inserted, old subtriggers removed etc without  
having to
log everyone out. Yes, it means an extra read and yes it is an  
imperfect

solution in an imperfect world..

And of course remember you are running under transactional  
constraints when

using triggers.

Brian

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe Triggers

2008-10-08 Thread Clifton Oliver

Mike:

Another thing to watch out for is the transaction constraints Brian  
mentioned. Where I've seen this most often is if your application has  
programs that add new records to a file without first getting a record  
lock with a READU. UniVerse lets you write in the dark if you want  
to. (Whether that is right or wrong is a different debate, but it  
happens.) Since triggers force transaction constraints, this will then  
fail. I don't remember the exact wording of the error message,  
something about ISO isolation level.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] .net uniobjects error 39204

2008-09-19 Thread Clifton Oliver

Now why couldn't the manuals have said that? laughing

Great explanation, Ray. Thank you very much.


Regards,

Clif

On Sep 19, 2008, at 12:57 AM, Ray Wurlod wrote:

The slave referred to here is the process that needs to log in to  
do the work.


When you connect via uvcs (which you do from UniObjects to  
UniVerse) the listener is unirpcd (or uvrpcd on older versions),  
listening on port #31438 (by default).
A request to connect has unirpcd consult its services file  
(unirpcservices) for the name of the service that you have  
requested (that is, uvcs, the UniVerse common server), checks from  
the services file that your IP address is eligible to request that  
service and, if so, starts an instance of the associated  
executable, in this case uvapi_server.  The uvapi_server is then  
your connection's agent process on the server, looking after such  
things as maintaining communications, monitoring the inactivity  
timeout interval, and so on.


When some work needs to be done, such as executing a query, a child  
process uvapi_slave is logged in to do the actual work.  Its stdout  
and stderr are redirected back to its parent (uvapi_server) so that  
the results may be returned to the client.  It is this slave  
process that has failed to start correctly.


Many reasons exist why this might be so.  The most common, in my  
experience, is that there is no clean path to TCL - that is, the  
LOGIN process in the account puts unexpected text on stdout.  All  
uvcs processes must be guaranteed a clean path to TCL.  You can  
test @TTY = uvcs in the LOGIN paragraph in a similar way that you  
might test @TTY = phantom to bypass application startup for  
PHANTOM processes.  (This might not be your actual problem, of  
course, and I'm not suggesting that it is, but it's something  
that's definitely worth investigating.)




- Original Message -
From: Clifton Oliver [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] .net uniobjects error 39204
Date: Thu, 18 Sep 2008 16:19:26 -0700


Here's the error. I got this from the UniDK/include/Uvoaif file.

UVE_SR_SLAVE_EXEC_FAIL = 39204' The slave failed to start  
correctly


Unfortunately, just as an out of context error message, I don't
know  what it means. Maybe someone else can pick it up from here.

Regards,

Clif

-- W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.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] .net uniobjects error 39204

2008-09-18 Thread Clifton Oliver

Here's the error. I got this from the UniDK/include/Uvoaif file.

UVE_SR_SLAVE_EXEC_FAIL = 39204' The slave failed to start correctly

Unfortunately, just as an out of context error message, I don't know  
what it means. Maybe someone else can pick it up from here.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Sep 18, 2008, at 11:34 AM, Doug Chanco wrote:


I cannot seem to find any reference to this error number, the
documentation goes from 39204 to 39210



Does anyone know what this error means?



Thanks



Dougc
---
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] Next UniVerse Release

2008-09-17 Thread Clifton Oliver
From the UV account, you can use the TCL command SUSPEND.FILES {ON |  
OFF}. From the OS level use


uv -admin -L

and -U to resume.

SUSPEND.FILES by itself or uv -admin -R will report whether suspend  
is on or off.


UVSUSPEND.B source is in the UV account's APP.PROGS, if you want to  
have a look.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Sep 17, 2008, at 6:28 AM, doug chanco wrote:


Clifton Oliver wrote:
Based on the posting on this topic from Steve O'Neal, it appears  
we have our answer. Always do a sync after pausing the database.



how does on pause the database in universe?

thanks

dougc
---
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] Next UniVerse Release

2008-09-16 Thread Clifton Oliver
Based on the posting on this topic from Steve O'Neal, it appears we  
have our answer. Always do a sync after pausing the database.


I wonder if that is true for UniData, too. Wally? You following this  
thread?


Thanks for pointing out the issue, Brian!


Regards,

Clif


On Sep 15, 2008, at 2:06 AM, Brian Leach wrote:


Clif

I've asked the question before and received no solid answer. Hence  
the word

'assurance' grin

If someone could confirm that it does, I'll knock that off my list.

Regards

Brian


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Clifton Oliver
Sent: 15 September 2008 09:36
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Next UniVerse Release

Are you saying the db pause (uv -admin -L (if I recall)) we
have been told to use does NOT commit T30 file headers? And
the backup of the mirror is NBG?


Regards,

Clif



On Sep 15, 2008, at 12:49 AM, Brian Leach wrote:


All

I'm canvassing some opinions here.. as IBM sit down to work

out their

priorities for release 11 of UniVerse, what do you want to see
included?

As an example, here is my first wishlist item: better backups for
24x7x365
sites. That means either/both of a backup agent (or API)

that can be

used by third party storage tools (such as IBM's own Tivoli - so a
business opportunity for them) and the assurance that pausing a
database to split a mirror will commit all type 30 file headers to
disk before the pause completes.

Brian
---
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] Triggers

2008-08-28 Thread Clifton Oliver
Chapter 5 of the 10.2 SQL Reference manual is correct. The file does  
not have to be SQLized, but you still have to use valid SQL syntax  
for the TCL commands used to CREATE and DROP them, ie., ' for  
literals (not ) and you must end the command with a semi-colon (;).


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com




The information in the System Description manual is inaccurate.
On Aug 27, 2008, at 8:32 AM, Tom Dodds wrote:


Universe SQL Reference if I remember correctly.

HTH

Tom Dodds

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alspach,  
Vance

Sent: Wednesday, August 27, 2008 8:54 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Triggers

What manual contains information on creating Universe triggers for
non-SQLized
files? I cannot seem to find it in any manual

UV 10.2.4 Pick format
IBM RS6000

Vance Alspach



CONFIDENTIALITY. This electronic mail and any files transmitted  
with it may

contain information proprietary to Deere  Company, or one of its
subsidiaries
or affiliates, and are intended solely for the use of the  
individual or

entity
to whom they are addressed, shall be maintained in confidence and not
disclosed to third parties without the written consent of the  
sender. If you
are not the intended recipient or the person responsible for  
delivering the
electronic mail to the intended recipient, be advised that you have  
received
this electronic mail in error and that any use, dissemination,  
forwarding,
printing, or copying of this electronic mail is strictly  
prohibited. If you
have received this electronic mail in error, please immediately  
notify the

sender by return mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

__ Information from ESET NOD32 Antivirus, version of virus  
signature

database 3392 (20080827) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.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] Unidata to Universe port

2008-08-16 Thread Clifton Oliver
The problem is that both Dave and I have spooler products that try to  
intercept the output and direct it to a HOLD file. This involves  
using an interlude to the SP.ASSIGN/SETPTR verb. Many times, this  
only gets executed once per login.

While we both have developed work-arounds to this issue, expanding  
that number from  has been requested FOR YEARS. One UV product  
manager even thought it had already been done.

We've been asking for this to be corrected  for almost a decade, but  
the request falls on deaf ears.

Fer gods sake, it's not Rocket Science! It would take, what, 2 hours  
to code and one automated regression run to verify?

Regards,

Clif

-- 
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Aug 15, 2008, at 9:20 PM, JPB-U2UG wrote:

 I didn't realize you were referring to the HOLD file. In that  
 case you are correct about the numbers being only 4 digits.  
 However, you can expand the usage by giving the hold entries names  
 as well as numbers by using the BANNER option. Here is from the  
 manual:
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET

2008-08-14 Thread Clifton Oliver
International Spectrum magazine, March/April 2008, page 26.

Available at:

http://intl-spectrum.com/mag/MARAPR.2008/default.aspx

also via

http://tinyurl.com/63guo7


Regards,

Clif




On Aug 14, 2008, at 9:58 AM, Brian Leach wrote:

 The other main option is the IBM ADO.NET provider, which exposes a
 mainstream relational view of UniVerse, but with better handling  
 for stored
 procedures (AKA Basic subroutines) than some previous APIs. For  
 details,
 take a look at my article in a recent Spectrum (can't remember  
 which one).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Editing Paired Value Marks

2008-08-13 Thread Clifton Oliver

Bill,

The assumption is that you are using the standard UniVerse ED editor.  
What editor are you using?


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Aug 13, 2008, at 5:13 PM, Brutzman, Bill wrote:


Ray:

Thanks for writing but the double-carat technique did not work on  
what I

have here.

--Bill

-Original Message-
[mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod

C/^^253^^253/^^253/
---
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] UniData PROC tip: DB command

2008-08-02 Thread Clifton Oliver
UniVerse has a Proc manual, except they call it ProVerb these days.  
It is available for free from the IBM web site in the 10.2 (and   
before) documentation set.

Not vouching for the quality, completeness, or accuracy, however.

Regards,

Clif

-- 
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com




On Aug 2, 2008, at 10:46 AM, Susan Lynch wrote:

 Now, not only are there no Proc manuals (
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN fname ... ELSE STOP 3000, fname

2008-07-31 Thread Clifton Oliver
Could it be a user (site) created ERRMSG file item? I knew one VAR  
that did that kind of thing for most of their packages error messages.



Regards,

Clif



On Jul 31, 2008, at 12:20 PM, Stevenson, Charles wrote:


I've got old, old code riddled with STOP 3000, filename.
ERRMSG 3000 does not exist on UV 10.2.6.
Did it ever exist on UV?
What version of Pick did this come from.

Just curious, more than anything else.
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] UniData PROC tip: DB command

2008-07-31 Thread Clifton Oliver
Just as a point of history, EXECUTE was invented by the Devcom team  
who wrote what became Prime INFORMATION. Our in-house motto was  
PROCs are Crocks.


Regards,

Clif

On Jul 31, 2008, at 8:22 PM, MAJ Programming wrote:

 Microdata advanced PQ proc to PQN while regular Pick was advancing  
 with
 EXECUTE. IMHO, EXECUTE won and Microdata faded into the sunset.  
 (They had a
 few other programming shortcomings that are clearly deficient by  
 comparison
 today).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OT - Pick mentioned in letter to the editor... [not-secure]

2008-07-08 Thread Clifton Oliver
laughing

That was my first reaction, too. Doesn't seem to know the difference  
between virtualization and platform independence.

My second thought, when the editor lobe of my brain kicked in, was,  
My. What an 'interesting' attitude and tone to use to try to win  
over an editor to your viewpoint and get favorable mention in that  
publication.


Regards,

Clif


On Jul 8, 2008, at 12:18 PM, George Land wrote:

 Interesting, it's a shame that what he says isn't really true.

 George

 On 08/07/2008 19:59, Hennessey, Mark F. [EMAIL PROTECTED]  
 wrote:

 This appeared in the letters to the editor section of the July 1
 Software Development Times



 HIS PICK FOR AN OS IS CLEAR
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UVODBC Account Activation {unclassified}

2008-06-26 Thread Clifton Oliver
I agree with the advice given in a previous post by Kathleeni and  
this one by Andy.


NEVER try to use UV/ODBC against the standard production account!  
ALWAYS create another account with F pointers that point to the  
product account data sections but have local CLEAN dictionaries. I  
also advocate these local dictionaries use IDEAL flavor D and I type  
descriptors, especially if you want to have any chance of associated  
multivalued fields getting properly handled through dynamic  
normalization.


In defense of the product, Andy's comment is correct, but I wouldn't  
state it as ODBC is very picky. Rather, Pick programmers are  
notorious in loading up the dictionaries with multiple definitions  
(failure to use just ONE A definition and using S for all  
redefinitions) or multiple D definitions etc.


It is not UV/ODBC's fault it can't read everybody's mind and make  
sense out the twenty to thirty year's worth of crap people have  
lazily slopped into the dictionary.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Jun 25, 2008, at 1:11 PM, MACK ANDREW, MR wrote:


Hi,

A clean account is almost necessary. ODBC is very picky and we found
that our data was OK but that the dictionaries were full of 10 years
worth of difficulties :)

It was easier to create a new account, populate the VOC with file
pointers to the data files but create the dictionary locally. Then we
could put only the data items we wanted to expose into the dictionary.
This allowed us to format data differently from what the users  
needed to

see and ensure that clean dictionaries were presented.

Andy



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: Thursday, 26 June 2008 2:34 a.m.
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] UVODBC Account Activation

Okay.

Firstly, do you need this file in your account? Oddly enough, most  
of my

hard to fix problems with ODBC have been caused by the various
preparation/export programs crashing on system files we've never
touched. If you don't need it, delete the VOC entry. I had it crash on
PTERM.FILE - a system-supplied multi-part file.

Secondly, go to pickwiki, find the page on Universe, and then look at
the page on ODBC. You might find it useful as it describes my
tribulations with 9.6.

Bear in mind that these export routines process EVERYTHING, so the
entire account needs to be nice and clean, not just the files you're
exporting :-(

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat
Sent: 25 June 2008 14:44
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC Account Activation

Hi,

I know it's a very old version of uv - maybye 9.5 or possibly even 9.4

Mac



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: 25 Jun 2008 12:41
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] UVODBC Account Activation

Not that I know much about this error but ...

What version of UV are you running? I've set up ODBC on both 9.6 and
10.2, and the later version seems to be a lot more robust ...

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat
Sent: 25 June 2008 10:59
To: u2-users@listserver.u2ug.org
Subject: [U2] UVODBC Account Activation

Hi,

I have a friend who is try to activate ODBC access in an account  
running

on a unix based server and is getting the following:

DICT UV_ASSOC   /uv/sql/catalog/ 
D_UV_ASSOC2

1
CRITICAL ERROR! Notify the system administrator.

Abnormal termination of UniVerse.

Fault type is 11.  Layer type is BASIC run machine.

Fault occurred in BASIC program *LISTFILES at address 520.




Any suggestions ?

Thanks

mac







Mac Bhyat
Software Engineer - Special Projects
Unibase Solutions (Pty) Ltd.

URL: http://www.unibase.co.za http://www.unibase.co.za/
Email: [EMAIL PROTECTED]
Tel: 011 621 7000
Cell: 079 181 3266
Fax: 011 621 7029

DISCLAIMER AND CONFIDENTIALITY
This message and any attachment contain information intended solely  
for
the addressee which is confidential or private in nature and  
subject to
legal privilege. If you receive this message in error please notify  
the
sender immediately by email and thereafter delete the message and  
do not

disclose the content in any way. Unibase Solutions (Pty) Ltd cannot
assure the integrity of this communication, nor that it is free of
errors, virus, interception or interference, and disclaims all  
liability

for any such.
Views and opinions are those of the sender unless clearly stated as
being that of the company. The authority of the sender to bind the
company should be verified by the recipient and not assumed. For  
contact

and address information regarding the company please go to
http://www.unibase.co.za/ www.unibase.co.za
--
This message

Re: [U2] Printer errors in the error log

2008-05-24 Thread Clifton Oliver

** Comments embedded below. **


On May 24, 2008, at 2:22 PM, Stevenson, Charles wrote:


From: [EMAIL PROTECTED]

We're logging many errors in the UV error log that say
 Too many PRINTER channels open.
I know the channel numbers themselves are limited to 0-255,
but I didn't know there was a limit on how many could be
open at one time.  What is the limit?
Is there a configuration parameter somewhere that I'm missing?


I vaguely remember encountering this about 10 years ago in a  
Sequoia/UV

conversion.
I think there is/was a limit of 14 or so that can be open at one time.


I believe the number is 16, which includes the default unit 0, so you  
can use up to 15 with the numbers selected from the range of 1-255.




I don't think there is/was a config param work around.


There is no parameter that I have ever heard of. It is my  
understanding that the limit is hardcoded into both the UV run- 
machine and the external usp spooler daemon.



Or Clif Oliver's.  I think he sells a print environment handler  
designed

to make up for UniVerse's inadequacies.



Unfortunately, my package (ESP) will not help in this situation. It  
is more of a print job manager. But thanks for thinking of it!


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] locking code question

2008-05-15 Thread Clifton Oliver
BP files have to be either type 1 or type 19 (directories). Not  
having a file header, you can't have a SICA, can you? Same reason you  
can't have indexes or transaction logging on them. At least that's my  
understanding. I'd love to find out there is a way to do it.



Regards,

Clif



On May 15, 2008, at 4:14 PM, David Jordan wrote:

You could look at SQLising the BP file.   Having a SICA, you could  
restrict

read and update to all users and have a BASIC program manager with the
AUTHORIZATION command, handle check out, check in, compilation,  
etc.  This
means that programs could only be accessed through the program  
manager and

not directly.

This would only work on UniVerse as I believe UniData does not have  
the

AUTHORIZATION Command.
Regards

David Jordan
---
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] Global Catalog - Recovery

2008-05-15 Thread Clifton Oliver

Was the copy done with the COPY verb, or with the host O/S file copy?


Regards,

Clif


On May 15, 2008, at 6:01 PM, Tom Dodds wrote:

My experience says that you have to be careful copying the catdir  
directory.
You can get some corrupt data because of the funny characters in  
the object

code stored in catdir.  Be careful and verify the content, maybe with
VCATALOG, before you stash it away.  You will have to verify it  
each time to

copy it because the object may change.

I lost a migration weekend because of copying catdir and getting  
corrupt

data.

Tom Dodds
[EMAIL PROTECTED]
630.235.2975


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Clifton  
Oliver

Sent: Thursday, May 15, 2008 4:55 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Global Catalog - Recovery

Cataloging locally might not be an option if there are a lot of
programs that

  CALL *XYZ(...)

or the old Prime way of

  XYZ = *XYZ
  CALL @XYZ(...)


Bill, Globally cataloged programs (the ones with the * as the first
character) are stored in the catalog space which is really a
subdirectory in the UV account called catdir. If you copy the catdir
directory, I believe you will have what you need.

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On May 15, 2008, at 1:51 PM, Israel, John R. wrote:


Catalog locally and you will never need to re-catalog (assuming local
cataloging is acceptable).
or
Catalogging hundreds of pgms should not be a big deal.

SELECT BP (or SELECT BP_O)
CATALOG BP FORCE

John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman,
Bill
Sent: Thursday, May 15, 2008 4:36 PM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Global Catalog - Recovery

I am trying to validate an emergency recovery scenario.  I want to
install
UV on a disk and lock the disk (unpowered) in a safe.

So, if our main disk has a problem, I would just insert the (cold)
hot-plugable disk, copy the latest data to this disk and then we are
LIVE
again... rapidly.

To do this, it appears that I need to reCatalog all 100 of our global
subs
on the new disk.  Is there any way around this reCataloging hitch?
Suggestions would be appreciated.

We are using HP-Ux 11i v2 and UV v10.1.  This scenario would also  
help

with
smoothly upgrading HP-Ux and UV versions.

--Bill

Bill Brutzman
Manager, IT
HK MetalCraft Mfg Corp
PO Box 775
35 Industrial Road
Lodi  NJ  07644-0775

973.471.7770 x145 .voice
973.471.9666  .fax

[EMAIL PROTECTED]

[demime 1.01d removed an attachment of type application/octet-stream
which had a name of Brutzman, Bill.vcf]
---
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] UniObjects.NET: populating ListBox from XML

2008-05-14 Thread Clifton Oliver

I deleted the line

 ListBox1.DataSource = DS

I got the error Cannot bind to the new value member thrown on the line

 .ValueMember = CUSTOMER

I deleted that line, and now things work as expected.

Thank you very much for the help, David. Now I need to hit the books  
about data bindings and figure out what I just did grin.


If anyone has the title of a favorite must have VB.NET book, I'd  
like hearing about it. If folks want to chime in with  
recommendations, I'll compile a list and submit it as a item in the  
U2UG knowledge-base.



Regards,

Clif




On May 13, 2008, at 10:58 PM, Hona, David S wrote:

 Oh, delete the line with 'ListBox1.DataSource = DS' in it, I  
forgot to!





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S
Sent: Wednesday, May 14, 2008 2:32 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniObjects.NET: populating ListBox from XML

Clif,

Try something like this...

 Cmd = uvSession.CreateUniXML
 Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP)
 DS = Cmd.GetDataSet
 ListBox1.DataSource = DS

With ListBox1
.DataSource = DS.Tables(0)
.DisplayMember = COMPANY
.ValueMember = CUSTOMER
End With

Regards,
David

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Clifton  
Oliver

Sent: Wednesday, May 14, 2008 9:05 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniObjects.NET: populating ListBox from XML

Having been successful last week at populating a GridDataView control
using .GenerateXML, we naively thought using XML to populate a ListBox
would be just as straightforward. Using the same code pattern, we've
tried

 Cmd = uvSession.CreateUniXML
 Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP)
 DS = Cmd.GetDataSet
 ListBox1.DataSource = DS
 ListBox1.DisplayMember = CUSTOMER
 ListBox1.Refresh()

gives us one line in the ListBox that reads

  System.Data.DataViewManagerListItemTypeDescriptor

Are we missing something from this incantation, or is this not a valid
way to try to populate a ListBox? (Yeah, I guess ComboBoxes are
next.)

Thanks in advance for any help, examples, or RTM references!


Regards,

Clif
---
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] UniObjects.NET: populating ListBox from XML

2008-05-13 Thread Clifton Oliver
Having been successful last week at populating a GridDataView control  
using .GenerateXML, we naively thought using XML to populate a  
ListBox would be just as straightforward. Using the same code  
pattern, we've tried


Cmd = uvSession.CreateUniXML
Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP)
DS = Cmd.GetDataSet
ListBox1.DataSource = DS
ListBox1.DisplayMember = CUSTOMER
ListBox1.Refresh()

gives us one line in the ListBox that reads

 System.Data.DataViewManagerListItemTypeDescriptor

Are we missing something from this incantation, or is this not a  
valid way to try to populate a ListBox? (Yeah, I guess ComboBoxes are  
next.)


Thanks in advance for any help, examples, or RTM references!


Regards,

Clif
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Fwd: Digiboards

2008-05-13 Thread Clifton Oliver

Posted for a non-list member.


Begin forwarded message:


From: hbkeultjes [EMAIL PROTECTED]
Newsgroups: comp.databases.pick
Subject: Digiboards
Date: Tue, 13 May 2008 13:53:18 -0700 (PDT)

Anyone interested in a bunch of Digiboards, many brand new, including
the cables and 8-port terminations,  please let me know before I put
them up on eBay.

I would be willing to trade all of them for an IBM RT that is running
OA.

Whoever sees this from the U2 list please post this there are well.
Henry Keultjes
Microdyne Company
Mansfield Ohio USA

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniVerse Triggers

2008-05-08 Thread Clifton Oliver

The Nov/Dec 2007 issue, available at:

http://www.intl-spectrum.com/t/135520/link.aspx



On May 8, 2008, at 5:35 AM, Brian Leach wrote:


Mike
If you check the recent issues (pdfs on their site) I wrote an  
article on triggers for Spectrum you might find useful.


Brian



-Original Message-
From: Mike Randall[EMAIL PROTECTED]
Sent: 08/05/08 03:58:08
To: u2-users@listserver.u2ug.orgu2-users@listserver.u2ug.org
Subject: RE: [U2] UniVerse Triggers

Interesting,  I actually saw the trigger reference under SQL  
and made the
incorrect assumption that it was referring to actual SQL  
commands rather

than calling BASIC subroutines.   Thanks for correction.

Mike Randall,  MCP






-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of  
Clifton Oliver

Sent: Wednesday, May 07, 2008 8:58 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Triggers

It's a UniVerse SQL command (yes, even if the file is not an  
SQL table).


CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR  
event ]  ON

tablename FOR EACH ROW CALLING ' program ' ;

Details are in chapter 5 of the UniVerse SQL Reference.



[Message truncated. Tap Edit-Mark for Download to get remaining  
portion.]

---
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/


DQM (was [U2] Using ETL to extract data from UD to SQL)

2008-05-08 Thread Clifton Oliver
I wanted to change the subject line to see is we Listizens have any  
interest in discussing Data Quality Management.


How do you cleanse MultiValue non-typed data for integration with  
strongly datatyped non-MV applications?


Anyone want to kick off the discussion?

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On May 8, 2008, at 6:00 PM, Boydell, Stuart wrote:


nd dirty
data to get to a set of data suitable for your DW/reporting
requirements.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniObjects.NET: .GenerateXML method fails

2008-05-07 Thread Clifton Oliver
Thanks, David. I'll check those references and post a summary  
findings back to the list.


I really appreciate the help!


Regards,

Clif


On May 6, 2008, at 8:31 PM, Hona, David S wrote:


Clif,

I vaguely recall that the UniXML functionality isn't officially
supported until UV 10.2.x (on the server). I could

However, I have got it working at UniVerse 10.1.18 on Sun Solaris. But
earlier versions of UV 10.1.x do not work with UniXML calls. This  
is the

same U2 Webservices Developer Tool (and some other toolsets as well).

I believe this may be mentioned in the UniVerse 'newfeatures.pdf'  
for UV

10.2 documentation set.


Regards
David

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniObjects.NET: .GenerateXML method fails

2008-05-07 Thread Clifton Oliver
It's confirmed. As soon I globally cataloged that routine,  
DataGridView is working. We haven't gotten a list box to work, but  
that will be another subject line for archive purposes.


Thank you!


Regards,

Clif

On May 6, 2008, at 3:12 PM, Clifton Oliver wrote:

Sure enough, that subroutine was not cataloged on the AIX system.  
I've cataloged it, but got my PC access expired before I could test  
it. (What are the odds?) I'll report back to the list (for the  
archives) with a verification when I get my access renewed.


Thank you!


Regards,

Clif

On May 6, 2008, at 1:50 PM, Brian Leach wrote:


Hi Clif

I would check to see whether the GETXMLSUB subroutine has been  
globally cataloged in the uv account. The code is in BP, it needs  
to be cataloged as *GETXMLSUB.


Brian


Greetings, List Citizens (Litizens?)

A client of mine and I are having problems with using UniObjects.NET
and the GenerateXML menthod to populate a data grid in VB.NET. The
following code, almost a cut-and-paste from Brian Leach's excellent
Introducing UniObject for .NET in the U2UG Knowledge Base runs
perfectly on UV PE 10.2.8 on Windows XP SP2 using the 10.2 UV  
clients.



 Private Sub cmdRead_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles cmdRead.Click
 Cmd = uvSession.CreateUniXML
 Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP)
 DS = Cmd.GetDataSet
 DataGridView1.DataSource = DS
 DataGridView1.DataMember = CUSTOMER
 DataGridView1.Refresh()
 End Sub

  But when we try the exact code against an AIX system, UV 10.1.7
using the 10.1A clients, we get the following error:

[IBM U2][UODOTNET - UNICLIENT][ErrorCode=30105] Unable to load the
subroutine on the server[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91]
Please verify UniVerse or UniData Version. This feature may not be
supported in older UniVerse or UniData version.

In both cases, I am going against the CUSTOMER file in the demo
HS.SALES account. I have logged into the AIX system with the same ID
as is being used to connect a session and verified that I have
permissions to access the file. The command SORT CUSTOMER COMPANY
ID.SUP TOXML ELEMENTS issued from the TCL prompt gives the expected
results. None of the dictionary descriptors are trying to call a
subroutine, so I don't understand what that part of the error message
is referring to.

Thanks in advance for any help, ideas, or insights.

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.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/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Fwd: [U2] UniVerse Triggers

2008-05-07 Thread Clifton Oliver
Excuse me. I mistyped. That is three 90 minute sessions, not one hour.


Regards,

Clif


Begin forwarded message:

 From: Clifton Oliver [EMAIL PROTECTED]
 Date: May 7, 2008 5:58:05 PM PDT
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] UniVerse Triggers

 It's a UniVerse SQL command (yes, even if the file is not an SQL
 table).

 CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] 
 ON tablename FOR EACH ROW CALLING ' program ' ;

 Details are in chapter 5 of the UniVerse SQL Reference.

 [AD]

 Also, I will be conducting a webinar through Spectrum University on
 the topic of UniVerse Triggers starting next Thursday. The course
 is three one-hour sessions on three consecutive Thursdays.

 For more information, please see

 http://www.intl-spectrum.com/tabid/159/univ/15/default.aspx

 [/AD]

 Regards,

 Clif

 --
 W. Clifton Oliver, CCP
 CLIFTON OLIVER  ASSOCIATES
 Tel: +1 619 460 5678Web: www.oliver.com



 On May 7, 2008, at 4:28 PM, Mike Randall wrote:

 On UV triggers,  I've used them often on UD and now have a great
 application
 for them on UV.   I searched the VOC and found no commands with
 the word
 'trigger' in them.  I was expecting the CREATE.TRIGGER of
 Unidata.What's
 the  syntax for setting them up in UV?

 Mike Randall,  MCP





 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes
 Sent: Friday, April 25, 2008 11:02 AM
 To: 'u2-users@listserver.u2ug.org'
 Subject: [U2] UniVerse Triggers

 Hello,

 We have received reports that UV triggers have shown some
 instability. Does
 anyone have anything to share on this?

 We have been using them for a couple of years with no issues but
 were hoping
 for more details from other users, if available.

 Thanks much,
 -Baker
 ---
 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] UniVerse Triggers

2008-05-07 Thread Clifton Oliver

It's a UniVerse SQL command (yes, even if the file is not an SQL table).

CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ]  ON  
tablename FOR EACH ROW CALLING ' program ' ;


Details are in chapter 5 of the UniVerse SQL Reference.

[AD]

Also, I will be conducting a webinar through Spectrum University on  
the topic of UniVerse Triggers starting next Thursday. The course is  
three one-hour sessions on three consecutive Thursdays.


For more information, please see

http://www.intl-spectrum.com/tabid/159/univ/15/default.aspx

[/AD]

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On May 7, 2008, at 4:28 PM, Mike Randall wrote:

On UV triggers,  I've used them often on UD and now have a great  
application
for them on UV.   I searched the VOC and found no commands with the  
word
'trigger' in them.  I was expecting the CREATE.TRIGGER of  
Unidata.What's

the  syntax for setting them up in UV?

Mike Randall,  MCP





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes
Sent: Friday, April 25, 2008 11:02 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] UniVerse Triggers

Hello,

We have received reports that UV triggers have shown some  
instability. Does

anyone have anything to share on this?

We have been using them for a couple of years with no issues but  
were hoping

for more details from other users, if available.

Thanks much,
-Baker
---
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] fixtool

2008-05-06 Thread Clifton Oliver
Unless things have changed since February of 2004, according to a  
white-paper by Leroy Dreyfus:


fixtool supports 3 effective verbosity levels. 0  3 are treated as  
level 2 and show only the summary screen described earlier. Level 4  
displays the record offset, the forward pointer, the backward link,  
and the flag word1. Level 5 adds the record ID and data (as a  
multivalue array) to the display of level 4. The output of each  
verbosity level is directed at the screen. To save them to a file,  
redirect stdout (standard out) to a file name.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On May 5, 2008, at 10:43 PM, Craig Bennett wrote:


Hi All,

fixtool allows you to nominate a Diagnostic level between 1 and 10  
using -level.


Does anyone know what the different levels check?


thanks,


Craig
---
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] UniObject.NET: What are you doing for LOCATE?

2008-05-06 Thread Clifton Oliver
Greetings again, everyone. Second question, put in a separate e-mail  
for ease of future searching the list archives.


Since there does not appear to be any LOCATE method provided by  
UniObjects.NET, what are others using? Did you code your own on the  
VB (or other client language) side? Do a server-side subroutine and  
call it to do the LOCATE? Other ideas?


Thanks for your recommendations.

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UniObjects.NET: .GenerateXML method fails

2008-05-06 Thread Clifton Oliver
Greetings, List Citizens (Litizens?)

A client of mine and I are having problems with using UniObjects.NET  
and the GenerateXML menthod to populate a data grid in VB.NET. The  
following code, almost a cut-and-paste from Brian Leach's excellent  
Introducing UniObject for .NET in the U2UG Knowledge Base runs  
perfectly on UV PE 10.2.8 on Windows XP SP2 using the 10.2 UV clients.


 Private Sub cmdRead_Click(ByVal sender As System.Object, ByVal e  
As System.EventArgs) Handles cmdRead.Click
 Cmd = uvSession.CreateUniXML
 Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP)
 DS = Cmd.GetDataSet
 DataGridView1.DataSource = DS
 DataGridView1.DataMember = CUSTOMER
 DataGridView1.Refresh()
 End Sub

  But when we try the exact code against an AIX system, UV 10.1.7  
using the 10.1A clients, we get the following error:

[IBM U2][UODOTNET - UNICLIENT][ErrorCode=30105] Unable to load the  
subroutine on the server[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91]   
Please verify UniVerse or UniData Version. This feature may not be  
supported in older UniVerse or UniData version.

In both cases, I am going against the CUSTOMER file in the demo  
HS.SALES account. I have logged into the AIX system with the same ID  
as is being used to connect a session and verified that I have  
permissions to access the file. The command SORT CUSTOMER COMPANY  
ID.SUP TOXML ELEMENTS issued from the TCL prompt gives the expected  
results. None of the dictionary descriptors are trying to call a  
subroutine, so I don't understand what that part of the error message  
is referring to.

Thanks in advance for any help, ideas, or insights.

Regards,

Clif

-- 
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] fixtool

2008-05-06 Thread Clifton Oliver

That should read 0-3.

On May 6, 2008, at 10:16 AM, Clifton Oliver wrote:


 0  3 are treated as level 2

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniObjects.NET: .GenerateXML method fails

2008-05-06 Thread Clifton Oliver
Sure enough, that subroutine was not cataloged on the AIX system.  
I've cataloged it, but got my PC access expired before I could test  
it. (What are the odds?) I'll report back to the list (for the  
archives) with a verification when I get my access renewed.


Thank you!


Regards,

Clif

On May 6, 2008, at 1:50 PM, Brian Leach wrote:


Hi Clif

I would check to see whether the GETXMLSUB subroutine has been  
globally cataloged in the uv account. The code is in BP, it needs  
to be cataloged as *GETXMLSUB.


Brian


Greetings, List Citizens (Litizens?)

A client of mine and I are having problems with using UniObjects.NET
and the GenerateXML menthod to populate a data grid in VB.NET. The
following code, almost a cut-and-paste from Brian Leach's excellent
Introducing UniObject for .NET in the U2UG Knowledge Base runs
perfectly on UV PE 10.2.8 on Windows XP SP2 using the 10.2 UV clients.


 Private Sub cmdRead_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles cmdRead.Click
 Cmd = uvSession.CreateUniXML
 Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP)
 DS = Cmd.GetDataSet
 DataGridView1.DataSource = DS
 DataGridView1.DataMember = CUSTOMER
 DataGridView1.Refresh()
 End Sub

  But when we try the exact code against an AIX system, UV 10.1.7
using the 10.1A clients, we get the following error:

[IBM U2][UODOTNET - UNICLIENT][ErrorCode=30105] Unable to load the
subroutine on the server[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91]
Please verify UniVerse or UniData Version. This feature may not be
supported in older UniVerse or UniData version.

In both cases, I am going against the CUSTOMER file in the demo
HS.SALES account. I have logged into the AIX system with the same ID
as is being used to connect a session and verified that I have
permissions to access the file. The command SORT CUSTOMER COMPANY
ID.SUP TOXML ELEMENTS issued from the TCL prompt gives the expected
results. None of the dictionary descriptors are trying to call a
subroutine, so I don't understand what that part of the error message
is referring to.

Thanks in advance for any help, ideas, or insights.

Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.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] UniObject.NET: What are you doing for LOCATE?

2008-05-06 Thread Clifton Oliver

Indeed it does!


Regards,

Clif

On May 6, 2008, at 1:55 PM, Brian Leach wrote:



I wrote my own - BUT - now I'm thinking I should recode it as  
a .NET 3.5 extension method to enhance the UniDynArray class.  
Which, strangely enough, sounds like a good topic for next month's  
Spectrum :)

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] fixtool

2008-05-06 Thread Clifton Oliver
That is my understanding. The different levels just change how much  
and what kind of detail it reported.



Regards,

Clif


On May 6, 2008, at 4:04 PM, Craig Bennett wrote:


Thanks Cliff, I didn't realise they were verbosity levels.

So the actual checks performed are the same for every level?
---
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] UniVerse SQL Tables

2008-04-29 Thread Clifton Oliver

The parameter is OPENCHK.

OPENCHK - the modifies the behavior of operations upon files open  
via the BASIC OPEN statement. When set to zero, I/O to files open  
with the BASIC OPEN statement ignore integrity constraints. If non- 
zero those files will observe the constraints. This tunable does not  
affect files opened via the OPENCHECK statement.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com

On Apr 29, 2008, at 1:56 PM, David Jordan wrote:


Hi Gerry

I think there is an option in UvConfig that allows bad data to be  
written to
a table despite constraints.  I have not been able to write bad  
data to an

SQL Table as you have done in the test program.

Regards

David Jordan

Managing Consultant
---
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] UniVerse SQL Tables

2008-04-28 Thread Clifton Oliver

Not unless you've written a ten line test program to prove that.


On Apr 27, 2008, at 10:50 PM, u2ug wrote:

Can we safely assume that any file writes on sql tables are not  
subject

to data type checks or will this pop up to bite us at some point ?

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniVerse SQL Tables

2008-04-28 Thread Clifton Oliver

Not unless you've written a ten line test program to prove that.


On Apr 27, 2008, at 10:50 PM, u2ug wrote:

Can we safely assume that any file writes on sql tables are not  
subject

to data type checks or will this pop up to bite us at some point ?

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniVerse Triggers

2008-04-26 Thread Clifton Oliver
I have several clients who have been using triggers for a couple of  
years with no reported issues, other than the performance hit.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com




On Apr 25, 2008, at 11:42 PM, Horacio Pellegrino wrote:

We started using triggers some months ago and so far no problems at  
all...
I'm interested in what kind of instability issues you came across.  
Please

let me know.


( We are a 370-Micro$oft Windows shop!)

Horacio Pellegrino


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes
Sent: Friday, April 25, 2008 8:02 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] UniVerse Triggers

Hello,

We have received reports that UV triggers have shown some  
instability. Does

anyone have anything to share on this?

We have been using them for a couple of years with no issues but  
were hoping

for more details from other users, if available.

Thanks much,
-Baker
---
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] Mar/April 2008 issue of International Spectrum magazine

2008-03-07 Thread Clifton Oliver
The Mar/April 2008 issue of International Spectrum magazine is at the  
printer and is now available in PDF format for download at


www.intl-spectrum.com



Regards,

Clif
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Question about the U2 News Flash...

2008-02-29 Thread Clifton Oliver
The issue is in the final stages of going to press, so it's not up on  
the web site yet. I've made a note to post an announcement to the  
list as soon as it is.


[AD] (kind of)

Brian written several articles for Spectrum magazine. The back issues  
can be downloaded from the web site.


[/AD]


Regards,

Clif



On Feb 29, 2008, at 2:03 AM, Brian Leach wrote:

If anyone is interested I've done a writeup of the new ADO.NET  
provider in the next issue of Spectrum (that's www.intl- 
spectrum.com for details).

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Question about the U2 News Flash...

2008-02-29 Thread Clifton Oliver

laughing

Anyone want to edit the Editor?


On Feb 29, 2008, at 1:52 PM, Clifton Oliver wrote:

Brian written several articles for Spectrum magazine. The back  
issues can be downloaded from the web site.

   ^
 has
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] release notes (was: SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong)

2008-02-19 Thread Clifton Oliver
That's an interesting comment. If it is documented in the patchlist,  
I think that makes it part of the release. Plus, we found out about  
it being there in a public talk by LeRoy Dreyfuss at the IBM  
conference in Orlando a couple of years ago. At the time LeRoy was  
the U2 product manager (at least I think that was his title).


LeRoy? You listening in and care to comment?



Regards,

Clif


On Feb 16, 2008, at 11:59 AM, Martin Phillips wrote:

Don't forget to read each releases patchlist in the UV directory.   
They have been known to put things in there that aren't in the  
New  Features doc.  The CONCURRENT option to BUILD.INDEX comes to  
mind.


I queried why CONCURRENT wasn't in the manuals despite pre-release  
publicity. The response I got from IBM support in the UK was that  
it is not officially released as it doesn't work. Maybe JayJay will  
have an update on this.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] release notes (was: SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong)

2008-02-16 Thread Clifton Oliver
Don't forget to read each releases patchlist in the UV directory.  
They have been known to put things in there that aren't in the New  
Features doc.  The CONCURRENT option to BUILD.INDEX comes to mind.



--

Regards,

Clif

W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com

On Feb 15, 2008, at 3:21 PM, Stevenson, Charles wrote:

Each major release is usually accompanied with an update on the  
manuals,

including a New Features at Release X.0 sort of thing.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] anyone seen this error before?

2007-12-17 Thread Clifton Oliver
Because that id is used to determine the id of the printer memory  
segment for the process. If you have two UV processes with the same  
gpid, they end up sharing the memory segment. This is where your  
MFILE structures are stored (rotating file pool), among other things.  
Pointers get mixed up, and you end up getting some files data written  
into a completely different file, usually corrupting the group or  
even the file header, depending on how angry the computer gods are  
that day.



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Dec 17, 2007, at 5:29 AM, Doug Chanco wrote:

I am not sure I fully understand what's going on, why would not  
having a

unique pgid cause this issue?

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] anyone seen this error before?

2007-12-15 Thread Clifton Oliver

That is the reason for having the cron script use the PHANTOM command.


- Clif

On Dec 15, 2007, at 1:46 PM, John Godzina wrote:

I'm not sure, but wasn't there some discussion a while back stating  
that

multiple UV processes initiated via cron would be fine if each process
had their own unique process group id (not just a unique process id)?

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] anyone seen this error before?

2007-12-15 Thread Clifton Oliver
I don't know about perl, but I am *guessing* that would work. An  
early solution (circa 1997/8) was to use a little program written in  
C to do the same thing. I've have to search my records or the list  
archive to dig that out.


But it begs the question, why not just use PHANTOM? Are you assuming  
some doubling of processes or overhead that really isn't there? I'm  
not understanding why you would think hammering the process grp id is  
preferable to letting PHANTOM take care of it for you.


Maybe I'm missing a nuance here.


--

Regards,

Clif



On Dec 15, 2007, at 5:33 PM, John Godzina wrote:


Hi Cliff,

Can I also simply wrap the UV process in something that changes the
pgid? (e.g.: the setpgrp command in perl)

John

Clifton Oliver wrote:
That is the reason for having the cron script use the PHANTOM  
command.



- Clif

On Dec 15, 2007, at 1:46 PM, John Godzina wrote:

I'm not sure, but wasn't there some discussion a while back  
stating that
multiple UV processes initiated via cron would be fine if each  
process
had their own unique process group id (not just a unique process  
id)?

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[demime 1.01d removed an attachment of type text/x-vcard which had  
a name of john.vcf]

---
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] To Ad or Not to Ad

2007-12-05 Thread Clifton Oliver

** Comments embedded below. **


On Dec 5, 2007, at 7:08 AM, Susan Joslyn wrote:


When I was a little girl I didn't wake up in my pink and white Barbie
bedroom


I'm having a bit of cognitive dissonance here trying to reconcile the  
image of pink and white Barbie with Warrior Princess, Slayer of  
Sarbanes-Oxley Auditors.:-)




I think our signature
is the important thing in all of this.  I'll make a point to  
include my full

signature on all posts, that way there's disclosure even when it's not
marked [AD].


I think that's an excellent idea. For those of us who are primarily  
consultants, our product is the very advice that we offer to the list  
at no charge. So an argument could be made, valid IMO, that anytime  
we post we are advertising our product and at least as a secondary  
motivation, looking for leads and potential contracts.


--
Clifton Oliver
Database Thaumaturgist for Hire
n-dimensional anomalies a specialty
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] To Ad or Not to Ad [not-secure]

2007-12-05 Thread Clifton Oliver
chuckle When the original Devcom team was writing INFORMATION, we  
didn't have job titles or business cards. This was causing one of the  
chaps some problems in obtaining a loan, so a couple of us had a  
session of composing the most inflated job descriptions possible.


And a lot of people think software engineers don't have any fun...


On Dec 5, 2007, at 10:17 AM, Hennessey, Mark F. wrote:


Wow, Cliff - Your .SIG made me flip over to wikipedia...Maybe you
should add Proud to be a Humble Man...  :)

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] To Ad or Not to Ad

2007-12-05 Thread Clifton Oliver
Only if you sell your opinion. Then we get to invoice you for Reuse  
Fees.



On Dec 5, 2007, at 10:26 AM, Kevin King wrote:

I agree with Chuck, Brian, Clif, Susan, and anyone else who agrees  
with me. :-)


(Hmmm, does that make this an [AD]?)

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Accessing the OS

2007-12-05 Thread Clifton Oliver
or since the OP was asking about from within UniBasic, the syntax he  
would want would be


execute \SH -c ls -l\




--

Regards,

Clif

On Dec 5, 2007, at 2:37 PM, Jeff Schasny wrote:


SH
For example
SH -c  ls -al

Brutzman, Bill wrote:
From a UniBasic green-screen application (using Dynamic Connect),  
what BASIC
command(s) allow the programmer to execute an Unix command (with  
parameters)

such that something like a SendMail command could be handled.

We have UniVerse and HP-Ux.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/




--
-- 
--

Jeff Schasny - Denver, Co, USA
jeff at schasny dot 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] Deep and long indentations vs multiple exit points - AD functionality not bugs

2007-12-03 Thread Clifton Oliver
Sorry, Stuart. I should have completely trimmed the reply quote on my  
post so it didn't look (as it apparently did) that I was singling out  
you as the main target of my comments (after the part about guard  
clauses). It was more of a sociological musing as to how many times  
over the years we've seen these threads on style, constructs, etc. go  
on and on. I wonder how many people really change the way they label,  
or indent, or whatever based on them. I frequently hear comments in  
my travels from people to the effect of how do people have time to  
write all that stuff during the work week; I don't have time to even  
read them!


I wasn't trying to censor you or anyone else, and I probably should  
keep such musings to myself. At the very least, I should have worded  
it better.


Apologies to any and all for offense given.


--

Regards,

Clif



On Dec 3, 2007, at 2:14 AM, Boydell, Stuart wrote:


Apologies to anyone who thinks I was making unacceptable 'noise' -
you're welcome to filter my posts. In my defence - I have always tried
to put a guard clause in my posts asserting it's MY opinion - not -  
thou

shalt. If I haven't - it's just a bug in my assertion.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Deep and long indentations vs multiple exit points - AD NAUSEUM

2007-12-02 Thread Clifton Oliver
Perhaps you might want to expand your search criteria to include the  
last ten years and examine the use of Guard Clauses.


Does anyone else on the list find these discussions of style, good  
practice, etc. to be both out-of-date and an exercise in wasted  
bandwidth (not to mention having too much time on one's hands)?


People being what they are, these discussions always boil down to,  
I'm going to do it my way because I'm right and you are wrong.


Wouldn't the time be best spent retesting that A/R modification you  
plan to push to Production tomorrow night?



--

Regards,

Clif

On Dec 2, 2007, at 5:12 PM, Boydell, Stuart wrote:

I'm in complete agreement with the one way in/out (OWI-OWO )  
rule. Out

of interest, I have searched the net and of the many articles I found
which cited OWI-OWO, all cited it in the scope of being good  
practice. I

found one which cites one way in, multiple|many ways out with a
scathing comment.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Cool stuff for a Friday [not-secure]

2007-11-26 Thread Clifton Oliver

Who, me? ;-)


On Nov 26, 2007, at 5:43 AM, Hennessey, Mark F. wrote:


Cliff - I'm willing to bet you do it because you CAN.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Can I get some advice on triggers?

2007-11-26 Thread Clifton Oliver
Yes. See Chapter 5 of the UV 10.2 SQL Reference. That's the  
documentation that works. Unfortunately, the triggers documentation  
in the non-SQL portions of the manuals is incorrect, and had been for  
some time.


[AD] Watch for the next issue of International Spectrum magazine.  
Brian Leach has a good article on UniVerse file triggers in it. Also,  
International Spectrum is putting together a webinar on this topic.  
I'll announce it on this list when we have a schedule set. [/AD]



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Nov 26, 2007, at 8:38 PM, Keith Johnson (DSLWN) wrote:


Hi,

I'm hoping someone can give me some help on triggers.  I want to put a
trigger on a file to datestamp address changes.

The system manual (25119270.pdf) says that triggers aer set up by the
command

CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE]


But when I try that I get an SQL prompt.  We don't use SQL at all - is
there some way of setting up triggers without it?  Is there another
manual I should look at?


Thanks, Keith.
---
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] Can I get some advice on triggers?

2007-11-26 Thread Clifton Oliver
Be sure to make that one parameter *some.subroutine. The subroutine  
needs to be UV globally cataloged, even if you are running in a Pick  
flavor account.



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Nov 26, 2007, at 10:50 PM, [EMAIL PROTECTED] wrote:


Try this:

CREATE TRIGGER filename.trigger BEFORE INSERT OR UPDATE OR DELETE ON
filename FOR EACH ROW CALLING some.subroutine;

Note the semi-colon at the end (;).  It is very important.

Regards,
Raul.





 Keith Johnson
 (DSLWN)
  
[EMAIL PROTECTED]  To

 o.nz u2-users@listserver.u2ug.org
 Sent  
by:   cc

 [EMAIL PROTECTED]
 stserver.u2ug.org  
Subject
   [U2] [UV] Can I get some  
advice on

   triggers?
 11/27/07 12:20 AM


 Please respond to
 [EMAIL PROTECTED]
er.u2ug.org






Hi,

I'm hoping someone can give me some help on triggers.  I want to put a
trigger on a file to datestamp address changes.

The system manual (25119270.pdf) says that triggers aer set up by the
command

CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE]


But when I try that I get an SQL prompt.  We don't use SQL at all - is
there some way of setting up triggers without it?  Is there another
manual I should look at?


Thanks, Keith.
---
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] Time Travel

2007-11-26 Thread Clifton Oliver
For the group's edification, at sending out 60,000+ e-mails on some  
days (more than that when people had nothing better to do at work  
than flame each other about coding styles), this was one of the  
problems I had when I hosted the lists.


Larry is also being polite and not mentioning that he is footing the  
bill for this service and bandwidth. So when some people start in on  
this needs to be corrected, the list has to be faster, and so  
forth, I would suggest you show him the money.


Not meaning to put words in your mouth, Larry. Most of us really  
(really, really!) appreciate your donation of time and money in  
support of these lists.


Clif.button.push()


On Nov 26, 2007, at 9:48 PM, Larry Hiscock wrote:


 b) I don't want to be blacklisted as a
spammer.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Cool stuff for a Friday

2007-11-23 Thread Clifton Oliver
Yes, Bill. I've been running on a MacBook since December of last  
year. I use Parallels for any Windows work I need to do. I love it. I  
set up a Windows VM for each client. That may be overkill, but the  
ability to snapshot the state of the entire machine, test, rollback,  
test, rollback is a real productivity booster. I haven't tried  
loading a VM with Linux and then putting UniVerse PE on top of that  
yet. But it shouldn't be a problem. Windows XP running in VM  
frequently out performs some of my colleagues running XP native,  
depending on their h/w.


I don't use Skype or GoToMeeting (yet), but they do have Mac clients  
for them SFTP is no problem. Remember, OS X is built on top of BSD  
Unix. Being a Unix dude, I open a local terminal and use command line  
at times--not that I have to. I just prefer a Road Less Pixeled for  
some things.


All in all, I'm a fan. I'd be hard-pressed to switch back to Windows  
as a full-time system.



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~



On Nov 23, 2007, at 10:33 AM, Bill Haskett wrote:

This reminds me of a question I've been wanting to ask.   Does  
anyone use an Apple

(the new leopard O/S with a VM for Windows)?

I've been thinking of buying one for my next PC purchase.  I need  
Windows for .NET
development, AccuTerm, U2 and mv.NET administration tools, and  
possibly other stuff.
I wonder if I can get Skype, a SFTP client, GoToMeeting, and any  
other useful stuff,

to replace Windows software, for Apple.

Bill


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Friday, November 23, 2007 9:57 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Cool stuff for a Friday

All

If any of you haven't seen the magnificent little Asus eee mobile  
pc yet -
mine is now running an 'nLite' version of XP, C# Express 2008,  
Delphi and -

of course - UniVerse :)

I'll be getting one for each of the kids...

Rgds

Brian

---
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] OT: Email encryption

2007-11-16 Thread Clifton Oliver
If the csv files are being generated by UniBasic, the language has  
encryption functions. Outside of basic, check out GPG. (http:// 
www.gnupg.org/)



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Nov 16, 2007, at 8:26 AM, Brenda Price wrote:


We sometimes have to email csv files with sensitive information to our
clients.  Right now we are just setting a password to the zipped  
files.

We really need to encrypt either the whole email or just the attached
files.  We are using Microsoft Outlook.



Any ideas?



Brenda L Price

Senior Programmer Analyst

Affiliated Acceptance Corporation

Sunrise Beach, MO

(800)233-8483
---
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] OT: Email encryption

2007-11-16 Thread Clifton Oliver

(hitting F7 and making a GTD entry)

I've added it to the list, Glen. Thanks for the suggestion.

[AD] If anyone is interested in writing this in return for by-line,  
photo, and a biography of up to 100 words, contact me at either my  
consulting address ([EMAIL PROTECTED]) or the magazine editor's address  
([EMAIL PROTECTED]). Even if you are not a consultant or  
vendor, exposure as a published subject matter expert to almost  
10,000 subscribers is a great way to build name recognition in the  
MultiValue community. It also helps on the ol' resume. Don't worry if  
your punctuation and grammar skills are rusty; we've got editors. If  
anyone wants to continue this or a general professional development  
discussion online, we can meet up over on the u2-community list. [/AD]


Of course, Glen has dibs on this one, if he was interested. :-)


--

Regards,

Clif

~~~
Clifton Oliver, Managing Editor
International Spectrum Magazine
Spectrum Tel: +1 720 259 1356
Clif's Direct Tel: +1 619 460 5678
~~~


On Nov 16, 2007, at 11:03 AM, Glen Batchelor wrote:


A Spectrum tech article would be nice. :)
nudges Cliff

 I'd be interested in seeing your GPG mail implementation  
guidelines and
perhaps a generic sample. I never got into GPG, but I've briefly  
thought

about integrating it before.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OT: Email encryption

2007-11-16 Thread Clifton Oliver

GPG is free (both as in beer and freedom).

Once setup and public keys exchanged, the user would just have to  
remember one password (or passphase), to unlock their keyring.



--

Regards,

Clif

On Nov 16, 2007, at 1:29 PM, Brenda Price wrote:

We would definitely be looking at a cheap solution as it isn't an  
every

day thing.

We have what we need to develop our own solution with just the .csv  
file

but it would really not be cost effective.

A piece of software that already exists under $100 for 2-4 licenses
would be great as it would get the job done cheaper and faster.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OT: Email encryption

2007-11-16 Thread Clifton Oliver
Would work if you can guarantee that all of your clients use Outlook.  
But a lot of folks won't go near the thing. ;-)



--

Regards,

Clif


On Nov 16, 2007, at 1:30 PM, Jerry Banker wrote:


Brenda,
If I'm not mistaken Outlook has an encryption feature built into it.
Jerry

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV - 10.2.2 [not-secure]

2007-11-06 Thread Clifton Oliver
Mark,

Would you mind giving just a brief description of what you mean by  
broken please? Not in detail (unless you want to grin) but enough  
to let the rest of us know what to watch out for.

Thanks.


On Nov 6, 2007, at 12:43 , Hennessey, Mark F. wrote:

 Also, usa is broken at 10.2.2
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV - 10.2.2 [not-secure]

2007-11-06 Thread Clifton Oliver
I am interpreting that to mean this is on those releases on all  
platforms (AIX) not just Solaris, correct?

Thanks for the info!


- Clif

On Nov 6, 2007, at 2:51 , Richard Nuckolls wrote:

 usa, usm, usp (all the same executable) hang when trying certain  
 operations.  They problem evidently started with  10.2.1, and fixed  
 at 10.2.6 (not available for Solaris yet)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe Benchmark Email --BIG user count

2007-11-05 Thread Clifton Oliver
I think that was Steve O'Neal that posted that information to the u2- 
users list. I see that Chuck Barouch dug out that reference for you.

That was the PDSC benchmark of 15,200 users. Susie Siegesmund talks  
about it in my interview with her in the Jan/Feb 2007 issue of  
International Spectrum Magazine, p. 43, available for download at

http://www.intl-spectrum.com/t/135488/link.aspx

Good luck with your presentation.


--

Regards,

Clif

~~~
Clifton Oliver, Managing Editor
International Spectrum Magazine
Spectrum Tel: +1 720 259 1356
Clif's Direct Tel: +1 619 460 5678
~~~

On Nov 5, 2007, at 7:10 , Ross Ferris wrote:

 I know IBM did a benchmark in the last 12-18 months for a call centre
 application (Lenovo) and someone (Wally?) posted a brief note to the
 group about 15K+ users ... I'm trying to locate for a presentation
 tomorrow, but can not find

 Is this in an online archive, or could someone sheet me an  
 original so
 I can include relevant details  thanks!

 Ross Ferris
 Stamina Software
 Visage  Better by Design!
 ---
 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] Stringing commands together on the command line. Possible?

2007-10-29 Thread Clifton Oliver

This is evil, but does string uv commands on the TCL line.

SH -c 'uv TIME; uv WHO; uv COUNT VOC'
16:42:44 29 OCT 2007
26 uv From root

927 records counted.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Green Screen Dev. Environment

2007-10-10 Thread Clifton Oliver
Nucleus was covered by Charles Barouch in the Sep/Oct 2006 issue of  
International Spectrum Magazine, available on the web at the intl- 
spectrom.com web site (http://www.intl-spectrum.com/Magazine/ 
Magazine.aspx?Page=2).


Or via (http://tinyurl.com/2y4nmt).

[ad] While you're there, why not sign up for a subscription? There is  
no charge. Just click on the Join Now button. [/ad]



--

Regards,

Clif

On Oct 10, 2007, at 7:53 , Baker Hughes wrote:


You should take a look at Nucleus.
It generates a characters screen, an Accuterm GUI screen, or .Net GUI
all from the same code.
Develop character screens in minutes, and If you ever decide to go  
GUI,
just do it, no rollout to clients. (your desktop group will love  
you for

this)
binary-removethis-star.com
Although we use their source safe solution we haven't begun using  
their

IDE yet, but it is impressive.
It appears the learning ramp is shorter than SB.

I have no connection with Binary Star, just a Developer at a licensed
site.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OT: Where to sell Systech serial port servers (for Serial printers/Serial Terminals)

2007-10-04 Thread Clifton Oliver
I doubt it you will ever make anything on these. You might check you  
local colleges and non-profits to see if you can get them to come  
haul them away (or pay the shipping) and then you take a charitable  
contribution deduction.



--

Regards,

Clif

On Oct 3, 2007, at 11:43 , Larry Hiscock wrote:


Gabriel wrote:

We also have over 100 ADDS Viewpoint terminals, but I have yet to  
find

someone

who will buy them where we make anything after shipping


Look at the bright side ... At least you wouldn't have to pay  
someone to
haul them away, which is what will happen if you hold on to them  
too much

longer  ;-)

Larry Hiscock
Western Computer Services
---
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 Printer file size limit reached

2007-09-26 Thread Clifton Oliver
Is that UVTEMP? Or just the regular /tmp (assuming UVTEMP is stored  
somewhere other than in /tmp)?



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Sep 26, 2007, at 11:27 , Jerry Banker wrote:


No the available space on the test system temporary directory is
196452832 K bytes as opposed to 15188328 K bytes on the live system.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: RES: [U2] Universe and triggers

2007-09-13 Thread Clifton Oliver

DOH!

Sorry. Overlooked that. So much for speed reading.


- Clif

On Sep 13, 2007, at 3:38 AM, Brian Leach wrote:


See point 6 on my post grin

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe and triggers

2007-09-12 Thread Clifton Oliver
There currently isn't a .Type19 file; that's the default in the  
absence of a .Type1 or .Type30. But they could add one and do what  
you suggest. I know this has been discussed within IBM for some time.


You have a similar issue for the same reason of being able to  
Transaction Log a type 1 or 19.



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Sep 12, 2007, at 6:06 AM, Mats Carlid wrote:


Clifton Oliver skrev:
Since 10.0. Yes, it works on all file types except 1 and 19. Being  
directories, they don't have file headers, thus no place to put  
the SICA.





It would be possible placing the SICA in  a separate file .sica
or in the .Type1 / .Type19 files wouldn't it?

And it would really be nice and usefull to have triggers in  
directories too.


-- mats
---
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] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Clifton Oliver
That completely depends on how densely the index is populated.  
Example by extremes: If you index on a status code that has only two  
equally possible values, you'd have about 5.5 million records in each  
index. Updates to that file will grind to a near halt. If the code  
could have a couple of hundred equally different values, update  
overhead might be acceptable.


The same logic applies as to whether or not to use the NO.NULLS  
option when creating the index.



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Sep 12, 2007, at 11:39 AM, Louie Bergsagel wrote:


Does anyone know the effect of adding an index to a UniVerse file?

I'd like to add a date index to a type 30 file with 11 million  
records. (

ANALYZE.FILE Total size .   2,115,325,952 bytes)

Would this have any measurable speed slowdown on applications running
against the file?

The file currently has 4 other indexes.

-- Louie Bergsagel
   Seattle
---
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: RES: [U2] Universe and triggers

2007-09-12 Thread Clifton Oliver

Two more come to mind:

If you change and recompile the subroutine, you have to drop and re- 
create the trigger.


Files with triggers cannot be updated via UV/Net.


--

Regards,

Clif


On Sep 12, 2007, at 2:04 AM, Brian Leach wrote:

5. Triggers impose some limitations : they all make sense if you  
step back and think about them except (b):

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe and triggers

2007-09-12 Thread Clifton Oliver

Oops. Meant to type not able to TL a type 1 or 19.

-C


On Sep 12, 2007, at 1:15 PM, Clifton Oliver wrote:

There currently isn't a .Type19 file; that's the default in the  
absence of a .Type1 or .Type30. But they could add one and do what  
you suggest. I know this has been discussed within IBM for some time.


You have a similar issue for the same reason of being able to  
Transaction Log a type 1 or 19.



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Sep 12, 2007, at 6:06 AM, Mats Carlid wrote:


Clifton Oliver skrev:
Since 10.0. Yes, it works on all file types except 1 and 19.  
Being directories, they don't have file headers, thus no place to  
put the SICA.





It would be possible placing the SICA in  a separate file .sica
or in the .Type1 / .Type19 files wouldn't it?

And it would really be nice and usefull to have triggers in  
directories too.


-- mats
---
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: RES: [U2] Universe and triggers

2007-09-12 Thread Clifton Oliver
Oooo! Now there's a neat trick (excuse me, technique). I'd never  
thought of it.


Have you ever used Mark Baldridge's Profiler (Travels With Mark, on  
the IBM Developer Works site) to quantify what I assume is a rather  
trivial amount of overhead in the double call? If not, I'll take a go  
at it and report back. It sounds like a great technique. Thanks!



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Sep 12, 2007, at 8:23 PM, Phil Walker wrote:

What I do is create a wrapper trigger program which does nothing  
more than call the real subroutine. That way as this trigger never  
or rarely changes I can modify the underlying trigger program  
without having to drop and recreate the trigger on the file.


 Clifton Oliver [EMAIL PROTECTED] wrote:

=
Two more come to mind:

If you change and recompile the subroutine, you have to drop and re-
create the trigger.

Files with triggers cannot be updated via UV/Net.


--

Regards,

Clif


On Sep 12, 2007, at 2:04 AM, Brian Leach wrote:


5. Triggers impose some limitations : they all make sense if you
step back and think about them except (b):

---
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] checking files for corruption

2007-09-11 Thread Clifton Oliver
I, too, am not sure how thorough it is, but I do a FILE.STAT (or  
ANALYZE.FILE).



--

Regards,

Clif

On Sep 11, 2007, at 11:07 AM, Bob Woodward wrote:

I'm not sure how through it is but I've always found that just  
doing a COUNT

on a file has shown when there's a problem.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, September 11, 2007 8:20 AM
To: u2-Users
Subject: [U2] [UV] checking files for corruption

Hi all,

UV 10.1.8

What is the best way to verify the integrity of a file while users are
accessing (if possible at all)?

I see that fixtool will set an exclusive file lock when executing  
without
any options.  If I understand correctly, the -start and -stop  
options will
scan the file setting group locks.  Would it work to set -start to  
1 and
-stop to the last group in the file?  If so, how do I tell what the  
last

group of the file is?

Thanks in advance,

Scott Thompson
---
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] U2UG Wiki article on UV's SYSTEM(n) - I need help editing it.

2007-09-11 Thread Clifton Oliver

Naw. Ray's a *real* psychologist. He even knows statistics. grin


On Sep 11, 2007, at 11:22 AM, Stevenson, Charles wrote:


Maybe our resident psychologist, Ray Wurlod, can provide a Freudian
explanation.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe and triggers

2007-09-11 Thread Clifton Oliver
Since 10.0. Yes, it works on all file types except 1 and 19. Being  
directories, they don't have file headers, thus no place to put the  
SICA.



--

Regards,

Clif

On Sep 11, 2007, at 1:59 PM, Geoffrey Mitchell wrote:


I'm not sure in what version it was implemented, but you *can* have
triggers on non-SQL files in Universe (and have been able to for some
time now).  Cataloging the subroutine so that it can be called as a
trigger is somewhat weird, and not well documented, but if you search
the list archives, you should be able to find what you need to  
know.  We

have been using this in production for a couple of years.

Actually installing the trigger uses the same syntax as for an SQL
table.  I believe that this works on all hashed file types (i.e.
anything but type 1 or 19 files).

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: RES: [U2] Universe and triggers

2007-09-11 Thread Clifton Oliver

Not as of release 10.0.


On Sep 11, 2007, at 2:24 PM, Marcos Fogaga wrote:


The problem is that the TEST.FILE MUST be a UV SQL Table.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


  1   2   3   >