RE: [U2] U2 University Last Week In Denver

2007-09-11 Thread Jackie Burhans
I thought I'd give a shot at answering some of Doug's questions about the 
new U2 Developer (aka GUI Basic IDE). 

Is it backward compatible to Universe 9.6 or UniData 6.1? 
   It will require you to install some Basic routines on the server but 
should work with older versions.

Has it been tested by over 700 users?
   No, it hasn't been released yet as part of the Early Adoption Program, 
but it will soon.

Has it been test on Mac, Windows, Linux and Fedora? 
   No, see above. Also currently we have a dependency on a piece that runs 
on Windows-only. That would have to be resolved before we could run on 
other platforms.

Can you update the product using Eclipse's Update Manager?
   We are looking into it.

Does it work on Eclipse 3.3 and Eclipse 3.2?
   Runs today on Eclipse 3.2

Does it run on Java 1.5 or 1.6?
   Runs today on JRE 1.4 and 1.5 (aka 5.0)

Can we test that Editor today in a real world environment?
   No, see above but watch for our announcement of its availability in our 
Early Adopter Program. Subscribe to the U2 News Flash if you haven't 
already and you should see it there soon. 

We are glad to have feedback from those who see this at U2U and those who 
will sign up for the EAP, especially those experienced in this technology. 
We have a number of existing and planned Eclipse-based tools and are 
looking forward to leveraging our experience to build this new tool and 
going back to our existing tools and integrating some or all of this tool 
as appropriate into those. 

And we're glad to have partners also providing modern development tools 
for U2--there cannot be too many good tools!


Jackie Burhans
U2 Portfolio Manager
IBM Information Management
Tel: 303-773-7717   T/L 656-7717
Mobile: 719-238-1553 
Email: [EMAIL PROTECTED]
http://www.ibm.com/software/data/u2
Register Now!Tune 
In! 


 



D [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
09/05/2007 09:20 AM
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] U2 University Last Week In Denver






That U2 Editor you saw at the U2 University will not be out until first
quarter 2008 for Unidata and later for Universe.  Here are the questions 
you
should be asking.

Is it backward compatible to Universe 9.6 or Unidata 6.1?  We doubt it!
Has it been tested by over 700 users?  We doubt it!
Has it been test on Mac, Windows, Linux and Fedora?  We doubt it!
Can you update the product using Eclipse's Update Manager?  We doubt it!
Does it work on Eclipse 3.3 and Eclipse 3.2?  We doubt it!
Does it run on Java 1.5 or 1.6?  We doubt it!
Can we test that Editor today in a real world environment? We doubt it!

We are the only company in the U2 market that has the programming 
expertise
and the years of experience that has been producing and selling Eclipse
based tools.  We are updating our U2 editor and other tools on a daily 
basis
and giving them away.

What are you waiting for?

Regards,
Doug

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Wednesday, September 05, 2007 6:25 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] U2 University Last Week In Denver

I'd also like to add that everyone better start looking into Eclipse
because some great things are going to be built on that platform. They
are also looking to recruit developers and users for an advisory group.
So, if you have some things you would like to see added to the products
this is your chance.
Jerry
---
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 image/jpeg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] U2 University Last Week In Denver

2007-09-11 Thread Symeon Breen
To be a part of the ud7.2 EAP would be nice - I have been asking for months but 
not heard anything yet, I would definitely be a good tester of the ide if only 
I could get hold of it ..




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans
Sent: 11 September 2007 07:26
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] U2 University Last Week In Denver

I thought I'd give a shot at answering some of Doug's questions about the 
new U2 Developer (aka GUI Basic IDE). 

Is it backward compatible to Universe 9.6 or UniData 6.1? 
   It will require you to install some Basic routines on the server but 
should work with older versions.

Has it been tested by over 700 users?
   No, it hasn't been released yet as part of the Early Adoption Program, 
but it will soon.

Has it been test on Mac, Windows, Linux and Fedora? 
   No, see above. Also currently we have a dependency on a piece that runs 
on Windows-only. That would have to be resolved before we could run on 
other platforms.

Can you update the product using Eclipse's Update Manager?
   We are looking into it.

Does it work on Eclipse 3.3 and Eclipse 3.2?
   Runs today on Eclipse 3.2

Does it run on Java 1.5 or 1.6?
   Runs today on JRE 1.4 and 1.5 (aka 5.0)

Can we test that Editor today in a real world environment?
   No, see above but watch for our announcement of its availability in our 
Early Adopter Program. Subscribe to the U2 News Flash if you haven't 
already and you should see it there soon. 

We are glad to have feedback from those who see this at U2U and those who 
will sign up for the EAP, especially those experienced in this technology. 
We have a number of existing and planned Eclipse-based tools and are 
looking forward to leveraging our experience to build this new tool and 
going back to our existing tools and integrating some or all of this tool 
as appropriate into those. 

And we're glad to have partners also providing modern development tools 
for U2--there cannot be too many good tools!


Jackie Burhans
U2 Portfolio Manager
IBM Information Management
Tel: 303-773-7717   T/L 656-7717
Mobile: 719-238-1553 
Email: [EMAIL PROTECTED]
http://www.ibm.com/software/data/u2
Register Now!Tune 
In! 


 



D [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
09/05/2007 09:20 AM
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] U2 University Last Week In Denver






That U2 Editor you saw at the U2 University will not be out until first
quarter 2008 for Unidata and later for Universe.  Here are the questions 
you
should be asking.

Is it backward compatible to Universe 9.6 or Unidata 6.1?  We doubt it!
Has it been tested by over 700 users?  We doubt it!
Has it been test on Mac, Windows, Linux and Fedora?  We doubt it!
Can you update the product using Eclipse's Update Manager?  We doubt it!
Does it work on Eclipse 3.3 and Eclipse 3.2?  We doubt it!
Does it run on Java 1.5 or 1.6?  We doubt it!
Can we test that Editor today in a real world environment? We doubt it!

We are the only company in the U2 market that has the programming 
expertise
and the years of experience that has been producing and selling Eclipse
based tools.  We are updating our U2 editor and other tools on a daily 
basis
and giving them away.

What are you waiting for?

Regards,
Doug

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Wednesday, September 05, 2007 6:25 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] U2 University Last Week In Denver

I'd also like to add that everyone better start looking into Eclipse
because some great things are going to be built on that platform. They
are also looking to recruit developers and users for an advisory group.
So, if you have some things you would like to see added to the products
this is your chance.
Jerry
---
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 image/jpeg]
---
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 basic assignment error ?

2007-09-11 Thread Jeff Marcos
Hi Scott,

You need to initialise Y to null at the start too.

Y = 

Regards,
Jeff Marcos

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger
Sent: Tuesday, 11 September 2007 11:35 AM
To: u2-users@listserver.u2ug.org; Dana Moore
Subject: [U2] UV basic assignment error ?

Here is a weird UV error condition that I just spent way too long
debugging:

CT BP SB

 SB
0001 X = 
0002 IF X EQ  THEN X = Y
0003 PRINT ONE
0004 PRINT TWO
0005 PRINT THREE
0006 PRINT X
0007 Y = A

RUN BP SB

ONE
TWO
THREE
Program SB: Line 6, Variable X previously undefined.  Empty string
used.

Why does the run-time error happen in line 6 instead of line 2? This is
_not_ what I was expecting.

In D3:

:run bp sb

[B10] in program sb, Line 2:
Variable has not been assigned a value; zero used.
ONE
TWO
THREE
0

I like the way D3 reports this better. Is this a normal, known UV thing?
Perhaps this is just the first time I have ever tripped over it...

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
---
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 basic assignment error ?

2007-09-11 Thread Moderator

REPOSTED FOR NON-MEMBER ADDRESS: Louie Bergsagel [EMAIL PROTECTED]

Bounce Notice: If you read this list through Indexfocus, Nabble, or any other 
replicator - and you would like to be able to participate - sign up directly 
with us. Here's all you need to know: To subscribe or
resubscribe please visit http://listserver.u2ug.org/.

UniVerse only displays undefined errors when the variable is used. 
Probably to frustrate programmers who are used to other compilers.


-- Louie Bergsagel
  North Coast Electric
  Seattle, WA 


-Original Message-
From: [EMAIL PROTECTED]

Program SB: Line 6, Variable X previously undefined.  Empty string used.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV basic assignment error ?

2007-09-11 Thread Brian Leach
All

For anyone who didn't pick up on Charles' timely plug (thanks Charles):

The U2UG have published a new Wiki. It's waiting for your content to turn this 
into the most complete resource for the IBM U2 community. 

You can find the Wiki on the U2UG website. Registration is separate, and all 
U2-ers are invited to contribute. Even if you can't write find the time to 
contribute a whole article, give us your thoughts and experiences or help to 
enhance the pages as they arrive.

This is an exciting opportunity to harness and pass on the knowledge and 
expertise in this list for the community.

Brian

Scott,
This is a known behavior.  It is by design, so I won't even call it a
bug, although it sure can be misleading, as you've found out! 
It's an excellent question  ought to go under some sort of FAQ, in the
new U2UG Wiki maybe.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Religious Wars

2007-09-11 Thread Moderator

All,
  It is no secret that I vehemently disagree with making this an 
unmoderated list. So I'm going to take a poll. Everyone who is looking 
forward to no moderator intervention during the next GOTO war or Single 
Letter Variable war or next Monty Python Quote jamboree, please sound 
off your approval. All those who want to see personal attacks 
unsanctioned, sing out. And please take a moment to vote for obscene and 
inappropriate comments as well.


  Those who think the mods *should* step in on those sort of things, 
kindly explain exactly what rules want and don't want. Because the 
'freedom now' posts are not well thought out.


  Digest users, for example, can't filter out posts. People who have 
quotas on their e-mail boxes really don't want important messages 
bouncing because two people decide to chat on the list about the nuances 
of implementing a rock-paper-scissors design strategy on various MV 
platforms. Some people are stuck with low speed connections.


  The reason U2-Community is under used is because the vast majority of 
people on this list aren't very interested in that sort of endless naval 
gazing.  Bear in mind, I generally don't END OF THREAD anything 
immediately. I shut it down when the value vs. volume becomes reduced. 
If it is running too long, but still of interest, I send it to 
U2-Community. If asking you to change the address on the send line is 
enough to completely kill a topic, you weren't very invested in it, were 
you?


If this sounds angry, you have read it correctly.

  This is now a U2UG board issue and will be discussed at the Wednesday 
meeting. I suggest you put your opinions out in the open, on 
U2-Community -as that is where it belongs under the CURRENT rules, 
before then.


- Charles Barouch, Moderator

To subscribe or resubscribe to U2-Community please visit 
http://listserver.u2ug.org/.

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


[U2] [UV] checking files for corruption

2007-09-11 Thread iggchamp
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/


RE: [U2] Religious Wars

2007-09-11 Thread Marc Harbeson
My *opinion* is that u2-community needs abolished.  

As for the argument I don't have enough bandwidth in the 2000's for text 
email - I don't buy it.

I think topics need *END OF THREAD* only when they become obscene, or out of 
control - meaning someone is attacking someone else, or each other in a non 
professional manor.  Otherwise we're all adults, can read subject lines, and 
need to move beyond this.

To summarize I am in complete agreement with Cliff and Dawn's previous poses on 
this subject.

That's my $0.02 right here in the open for everyone to see and enjoy.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator
Sent: Tuesday, September 11, 2007 10:34 AM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: [U2] Religious Wars

All,
   It is no secret that I vehemently disagree with making this an 
unmoderated list. So I'm going to take a poll. Everyone who is looking 
forward to no moderator intervention during the next GOTO war or Single 
Letter Variable war or next Monty Python Quote jamboree, please sound 
off your approval. All those who want to see personal attacks 
unsanctioned, sing out. And please take a moment to vote for obscene and 
inappropriate comments as well.

   Those who think the mods *should* step in on those sort of things, 
kindly explain exactly what rules want and don't want. Because the 
'freedom now' posts are not well thought out.

   Digest users, for example, can't filter out posts. People who have 
quotas on their e-mail boxes really don't want important messages 
bouncing because two people decide to chat on the list about the nuances 
of implementing a rock-paper-scissors design strategy on various MV 
platforms. Some people are stuck with low speed connections.

   The reason U2-Community is under used is because the vast majority of 
people on this list aren't very interested in that sort of endless naval 
gazing.  Bear in mind, I generally don't END OF THREAD anything 
immediately. I shut it down when the value vs. volume becomes reduced. 
If it is running too long, but still of interest, I send it to 
U2-Community. If asking you to change the address on the send line is 
enough to completely kill a topic, you weren't very invested in it, were 
you?

 If this sounds angry, you have read it correctly.

   This is now a U2UG board issue and will be discussed at the Wednesday 
meeting. I suggest you put your opinions out in the open, on 
U2-Community -as that is where it belongs under the CURRENT rules, 
before then.

 - Charles Barouch, Moderator

To subscribe or resubscribe to U2-Community please visit 
http://listserver.u2ug.org/.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.485 / Virus Database: 269.13.13/998 - Release Date: 9/10/2007 8:48 
AM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.485 / Virus Database: 269.13.13/998 - Release Date: 9/10/2007 8:48 
AM
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Religious Wars

2007-09-11 Thread Craig Bennett

Hi Charles,

I can't post this to U2-Community as I'm not subscribed so apologies for 
posting here.


I remember the solipsistic and personal threads and do not miss them. I 
much prefer and value the moderated list and have nothing but thanks and 
appreciation (and a beverage of choice if your are ever in Sydney) for 
all the moderators.


The moderators should step in and end the things you mention and the 
only rule is At the Moderator's Discretion.


Anyone in favour of a moderator free list should check some of the 
bizarre and abusive threads on comp.databases.pick.

Are the current MI5 cross posts malicious? who knows.




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


[U2] U2UG Wiki article on UV's SYSTEM(n) - I need help editing it.

2007-09-11 Thread Stevenson, Charles
Thank-you, Brian.  This has great potential.

From: Brian Leach
 The U2UG have published a new Wiki. It's waiting for your content
 to turn this into the most complete resource for the IBM U2 community.

 
 You can find the Wiki on the U2UG website. Registration is separate, 
 and all U2-ers are invited to contribute. Even if you can't write find
 the time to contribute a whole article, give us your thoughts and
 experiences or help to enhance the pages as they arrive.

 This is an exciting opportunity to harness and pass on the knowledge
 and expertise in this list for the community.


I mentioned on-list last week that I posted a beta Wiki thing on UV's
SYSTEM(n)function and ASSIGNment - undocumented (except here)
features. 

It's under:
 www.usu2.org
   u2ug Wiki
   For Developers 
 Server Development
  UniBasic Development
   SYSTEM(n) function and ASSIGNment - undocumented (except here)
features
 
If someone more experienced writing wikis would edit it and link it up
properly, I'd appreciate it.   I don't think I have hyperlinks  search
keywords set up right.  I think it would be hard to find the info if one
didn't know exactly what to look for.  My fault, not the wiki's.

For example, there's a table with a row for each numeric argument,
applicable for SYSTEM(n). I should have a link on the 9001 row that
points to the separate system(9001) detail section.  But I can't seem to
get it the link right.

I also had a hard time formatting text within a cell, so I don't like
how some of the longer descriptions read.  In the editor it recognized
enter, but after filing it, the enters get dropped.

And by _all_means_, anyone, fill in / correct the table content!  Most
was info I gleaned from this list w/o personal knowledge.


Chuck
---
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 Jerry Banker
You can try doing a uvbackup on the file to /dev/null. When the file is
backed up it checks the integrity of the file.
Jerry

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 11, 2007 10: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/


RE: [U2] UV basic assignment error ?

2007-09-11 Thread Bill Haskett
Chuck:

Too bad UD doesn't feel the same way.  :-( 

Bill

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of 
Stevenson, Charles
Sent: Monday, September 10, 2007 10:00 PM
To: u2-users@listserver.u2ug.org
Cc: Dana Moore; Scott Ballinger
Subject: RE: [U2] UV basic assignment error ?


[snipped]

Learn to routinely monitor uv/errlog for runtime errors like this that
might slip by your users.   You can catch these latent bugs and fix them
at their source, rather than waiting for users to complain about bad
data and wondering how it got that way.  I've promised to add a Wiki
article on monitoring uv/errlog, including some programs to do so.

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


Re: [U2] Religious Wars

2007-09-11 Thread Susan Lynch
Everyone who is looking forward to no moderator intervention during the 
next GOTO war or Single Letter Variable war or next Monty Python Quote 
jamboree, please sound off your approval. All those who want to see 
personal attacks unsanctioned, sing out. And please take a moment to vote 
for obscene and inappropriate comments as well.



I, for one, would like to  thank everyone who has worked to moderate this 
list throughout its history -  it is a difficult job, and frequently 
thankless.  However, I don't think the proposal to merge the 2 lists is a 
call for no moderator, just to keeping all the discussion together.  Closing 
off the periodic Monthy Python quote orgy, and flagging the end of a GOTO 
war (did we ever have a single-letter-variable war?  I don't remember that 
one!) are not the same as moving them to another list.  I find the 
historical notes on the development of the product enlightening, so I 
subscribe to both lists, but I would prefer that the Monty Python threads go 
to a Monty Python list somewhere, not to this list. And certainly on either 
list, personal attacks and obscenities should be off-limits - this is a 
professional forum and the people who post here to share their knowledge and 
assist others are deserving of thanks rather than disrespect.  People going 
out of their way to help others should be applauded, not sanctioned.


The problem for me with having the 2 lists is that I frequently get repeats, 
which is mildly annoying, but I can live with it since that is what the 
group decided to do in the past.  If the future decision by the community 
and the moderator is to have one list, I will have one less minor annoyance 
in life and the people who think that having a discussion sent to the 
community list is the kiss of death for the discussion will be much happier. 
However, if the moderator who is donating so much time and effort to the 
group will be unhappy, let's keep two lists and be thankful for his efforts!


Susan Lynch
F. W. Davison  Company, Inc. 
---

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


Re: [U2] Religious Wars

2007-09-11 Thread Ron White

I am *not *in favor of an unmoderated list.  I am a member of CDP and
it is not uncommon for religious wars and off-topic threads to run for
days.  I tend to ignore the list when this happens thereby losing the 
benefit

of the excellent help to be had.

Ron White

Moderator wrote:

All,
  It is no secret that I vehemently disagree with making this an 
unmoderated list. So I'm going to take a poll. Everyone who is looking 
forward to no moderator intervention during the next GOTO war or 
Single Letter Variable war or next Monty Python Quote jamboree, please 
sound off your approval. All those who want to see personal attacks 
unsanctioned, sing out. And please take a moment to vote for obscene 
and inappropriate comments as well.


  Those who think the mods *should* step in on those sort of things, 
kindly explain exactly what rules want and don't want. Because the 
'freedom now' posts are not well thought out.


  Digest users, for example, can't filter out posts. People who have 
quotas on their e-mail boxes really don't want important messages 
bouncing because two people decide to chat on the list about the 
nuances of implementing a rock-paper-scissors design strategy on 
various MV platforms. Some people are stuck with low speed connections.


  The reason U2-Community is under used is because the vast majority 
of people on this list aren't very interested in that sort of endless 
naval gazing.  Bear in mind, I generally don't END OF THREAD anything 
immediately. I shut it down when the value vs. volume becomes reduced. 
If it is running too long, but still of interest, I send it to 
U2-Community. If asking you to change the address on the send line is 
enough to completely kill a topic, you weren't very invested in it, 
were you?


If this sounds angry, you have read it correctly.

  This is now a U2UG board issue and will be discussed at the 
Wednesday meeting. I suggest you put your opinions out in the open, on 
U2-Community -as that is where it belongs under the CURRENT rules, 
before then.


- Charles Barouch, Moderator

To subscribe or resubscribe to U2-Community 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] Religious Wars

2007-09-11 Thread Bill Haskett
-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Lynch
Sent: Tuesday, September 11, 2007 9:07 AM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: Re: [U2] Religious Wars

 Everyone who is looking forward to no moderator intervention during the 
 next GOTO war or Single Letter Variable war or next Monty Python Quote 
 jamboree, please sound off your approval. All those who want to see 
 personal attacks unsanctioned, sing out. And please take a moment to vote 
 for obscene and inappropriate comments as well.

[snipped]

However, I don't think the proposal to merge the 2 lists is a 
call for no moderator, just to keeping all the discussion together.

[snipped]

I concur.  I would not like the list unmoderated, but I would like both lists
together.

[snipped]

However, if the moderator who is donating so much time and effort to the 
group will be unhappy, let's keep two lists and be thankful for his efforts!

Again, I concur.

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


RE: [U2] Religious Wars

2007-09-11 Thread Glen Batchelor
Chuck,

 I would suggest a chat room for unmoderated and off-topic discussions
instead of a mailing list. Who really wants to dig through archives to read
about totally unrelated material? CDP is already cluttered with it. If you,
or any of the admins, want help setting something up, let me know. I'd be
willing to oper an IRC channel, part-time, on Freenode if needed. Most
instant messengers support IRC and there are also a variety of HTTP based
streaming or polling chat apps. (similar to what I had at PickSource.

Glen


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Moderator
 Sent: Tuesday, September 11, 2007 10:34 AM
 To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
 Subject: [U2] Religious Wars
 
 All,
It is no secret that I vehemently disagree with making this an
 unmoderated list. So I'm going to take a poll. Everyone who is looking
 forward to no moderator intervention during the next GOTO war or Single
 Letter Variable war or next Monty Python Quote jamboree, please sound
 off your approval. All those who want to see personal attacks
 unsanctioned, sing out. And please take a moment to vote for obscene and
 inappropriate comments as well.
 
Those who think the mods *should* step in on those sort of things,
 kindly explain exactly what rules want and don't want. Because the
 'freedom now' posts are not well thought out.
 
Digest users, for example, can't filter out posts. People who have
 quotas on their e-mail boxes really don't want important messages
 bouncing because two people decide to chat on the list about the nuances
 of implementing a rock-paper-scissors design strategy on various MV
 platforms. Some people are stuck with low speed connections.
 
The reason U2-Community is under used is because the vast majority of
 people on this list aren't very interested in that sort of endless naval
 gazing.  Bear in mind, I generally don't END OF THREAD anything
 immediately. I shut it down when the value vs. volume becomes reduced.
 If it is running too long, but still of interest, I send it to
 U2-Community. If asking you to change the address on the send line is
 enough to completely kill a topic, you weren't very invested in it, were
 you?
 
  If this sounds angry, you have read it correctly.
 
This is now a U2UG board issue and will be discussed at the Wednesday
 meeting. I suggest you put your opinions out in the open, on
 U2-Community -as that is where it belongs under the CURRENT rules,
 before then.
 
  - Charles Barouch, Moderator
 
 To subscribe or resubscribe to U2-Community 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] {Blocked Content} Moderation

2007-09-11 Thread Bob Wyatt
Warning: This message has had one or more attachments removed
Warning: (not named).
Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s) for 
more information.

Charles,

I think you have the answer already... topics moved to community die, albeit
gracelessly...
I have no idea what the subscription numbers are for community verses this
list, but most of us lack the time or inclination to participate in the
majority of the 'diatribe' (my word choice) that might otherwise occur in
the community list.

This list is comprised of users, administrators, VAR's, and IBM'ers... It
isn't reasonable to expect that a user, administrator, VAR, or IBM with a
homemade script, derived or created solution, a different approach that
solved the issue, etc. would give away their knowledge or work for free,
although many may be willing. If the 'solution; addresses the needs of a
poster, and it isn't a 'blatant' ad, I see no reason to restrict whom may
reply, or that the Subject line be amended to reflect 'Ad'. Some of us may
even mention products that are not ours to sell, and we aren't required to
change the subject to 'Ad'.

The only change in moderation I'd like to see is that, if it is known that
sending a topic to community sends it to its (perhaps) untimely death, but
there is technical merit to continuing the conversation, don't move it.
Eventually, the topic will die it's own death; there may, however, be a
chance that someone writes something that someone else finds enlightening.
Not many, but there has been a topic or two that I thought was banished
prematurely, and I wasn't about to subscribe to community to find out 'how
it ended'.

Regards, 

Bob Wyatt 
This is a message from the MailScanner E-Mail Virus Protection Service
--
The original e-mail attachment winmail.dat
was believed to be infected by a virus and has been replaced by this warning
message.

If you wish to receive a copy of the *infected* attachment, please
e-mail helpdesk and include the whole of this message
in your request. Alternatively, you can call them, with
the contents of this message to hand when you call.

At Tue Sep 11 10:41:58 2007 the virus scanner said:
   Could not parse Outlook Rich Text attachment

Note to Help Desk: Look on the AngelicHost MailScanner in
/home/virtual/site2/fst/var/spool/mail.quarantine/20070911 (message
l8BHfrlD012967).
--
Postmaster
MailScanner thanks transtec Computers for their support
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Religious Wars

2007-09-11 Thread Brian Leach
Chuck

As a list-member, here is my personal view: I'm entirely with you.

I also have to say - I have witnessed Chuck's involvement with this list and 
with the U2UG board, and the time he gives to this community is simply 
incredible. I would also say the same of Larry for the wonderful job he does in 
keeping these lists going. And so if moderators like Chuck and Larry are happy 
to step in - intelligently and with the respect they have shown for this list - 
I applaud them. 

This list is hardly over-moderated: just count back the ACTUAL NUMBER of topics 
that have been crossed to U2-Community in the last 3 months, and you will see 
that this really is a non-issue.

If anyone wants a topic going to Community - then subscribe to that list and 
follow on. It's not difficult or onerous. We're all professionals, and so I 
don't accept (a) that it should be the dustbin of meaningful topics (or we 
would all have voted to end the threads, not move them) or (b) that intelligent 
I.T. people can be blocked from them. There are such things as personal emails, 
webmail, and if these are blocked at the workplace then people can always 
access this stuff from home if it is valuable. 

These lists work for those of us who read them daily. I only wish I could 
contribute better, and I have no problem with them staying as they are.

BUT with my U2UG hat on, I will be guided by the opinion, as far as we can get 
it, of the MAJORITY of the real users of this list.

Brian
---
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 Bob Woodward
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] Moderation

2007-09-11 Thread Bob Wyatt
Charles,

I think you have the answer already. topics moved to community die, albeit
gracelessly.
I have no idea what the subscription numbers are for community verses this
list, but most of us lack the time or inclination to participate in the
majority of the 'diatribe' (my word choice) that might otherwise occur in
the community list.

This list is comprised of users, administrators, VAR's, and IBM'ers. It
isn't reasonable to expect that a user, administrator, VAR, or IBM with a
homemade script, derived or created solution, a different approach that
solved the issue, etc. would give away their knowledge or work for free,
although many may be willing. If the 'solution; addresses the needs of a
poster, and it isn't a 'blatant' ad, I see no reason to restrict whom may
reply, or that the Subject line be amended to reflect 'Ad'. Some of us may
even mention products that are not ours to sell, and we aren't required to
change the subject to 'Ad'.

The only change in moderation I'd like to see is that, if it is known that
sending a topic to community sends it to its (perhaps) untimely death, but
there is technical merit to continuing the conversation, don't move it.
Eventually, the topic will die it's own death; there may, however, be a
chance that someone writes something that someone else finds enlightening.
Not many, but there has been a topic or two that I thought was banished
prematurely, and I wasn't about to subscribe to community to find out 'how
it ended'.

Regards, 

Bob Wyatt 
---
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 Stevenson, Charles
From: Laura Hirsh
 Hey Chuck - I think you meant www.u2ug.org in your path... 

Yup, the new Wiki is under www.u2ug.org. 
Neither fat fingers nor MS spellchecker accounts for that one.
Maybe our resident psychologist, Ray Wurlod, can provide a Freudian
explanation.
On second thought, don't!

  From: Stevenson, Charles
  
  www.usu2.org---  should be  www.u2ug.org
u2ug Wiki
For Developers 
  Server Development
   UniBasic Development
SYSTEM(n) function and ASSIGNment - undocumented (except
here) features
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Religious Wars

2007-09-11 Thread Allen E. Elwood
I think we should start a war over this!!!  '-)

Seriously though, I'm on the everything is just fine side

-Original Message-
[mailto:[EMAIL PROTECTED] Behalf Of Moderator
Sent: Tuesday, September 11, 2007 07:34

All,
   It is no secret that I vehemently disagree with making this an 
unmoderated list. snip
---
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 karlp
A count misses many types of possible corruption. If you select the file,
then do

LIST FNAME LASTATTRIBUTE

that will give you a better, though still incomplete, appraisal of a
file's integrity.

Karl

quote who=Bob Woodward
 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/



-- 
Karl Pearson
Director of I.T.
ATS Industrial Supply, Inc.
[EMAIL PROTECTED]
http://www.atsindustrial.com
800-789-9300 x29
Local: 801-978-4429
Fax: 801-972-3888

To mess up your Linux PC, you have to really work at it;
 to mess up a microsoft PC you just have to work on it.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Religious Wars

2007-09-11 Thread Paul Law
Please keep this a moderated list.

Thanks,

Paul Law
Programmer / Analyst
Value Part, Inc
http://www.valuepart.com/

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


RE: [U2] Religious Wars

2007-09-11 Thread Tom Gorton
I say keep the list moderated. I have seen what happens when lists get thrown to
the wolves - they basically become useless. I have not had any issues with how
the lists have been managed.

Keep up all the good work!



Regards,
Tom Gorton

When faced with a challenge, look for a way, not a way out.

- David L. Weatherford




  
This communication (including any attachments) is intended only for use by the 
addressee(s) named herein and may contain legally privileged or confidential 
information. If you are not the intended recipient or an authorized 
representative of the intended recipient on this communication, you are hereby 
notified that any dissemination or distribution of this communication (or 
attachments) is strictly prohibited. If you have received this communication in 
error, please notify us immediately by e-mail and permanently delete the 
communication and any attachments from your system.
---
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/


[U2] Universe and triggers

2007-09-11 Thread Marcos Fogaça
Hi,

 

It is possible create a trigger (subroutine) for a pick file (non SQL
table)?

On D3 we have CALLX, is there a feature like this in Universe?

 

Thanks in advance.

 

Best Regards,

 

Marcos Fogaca

Integral Sistemas

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


RE: [U2] UV basic assignment error ?

2007-09-11 Thread Timothy Snyder
 Too bad UD doesn't feel the same way.  :-( 

I'm not sure what this references, but UniData does have a series of log 
files.  They're text files ($UDTBIN/*.log and $UDTBIN/*.errlog), and the 
information doesn't scroll away if you don't catch the entries quickly 
enough.

Tim Snyder
Consulting I/T Specialist
U2 Lab Services
Information Management, IBM Software Group
717-545-6403
[EMAIL PROTECTED]
---
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 hemiiim2k
Hi Marcos,

Universe seems hellbent on invoking the entire SQL system in order to put a 
simple trigger on a file.  UniData is MUCH more forgiving in that regard.

With Universe, I have had a certain amount of success making what I call 
'indexed subroutines'  where by an index on a file calls a virtual Dictionary 
subroutine which does, in fact, operate as a rudimentary trigger.  You CANNOT 
affect data going to the actual file record update as you might with an actual 
trigger, but you can write information to a tracking database and then I have a 
background phantom in operation which manages email distribution from the 
triggered events and what not.  I *could* even write back to the originating 
file record that initiated the trigger -- I've closed off the mortal embrace 
between phantom and virtual subroutine -- but that will always have a lag time 
between the actual record update event and the final conclusion of the trigger, 
so I would not consider it a particularly clean solution for true database 
triggering.  It does work well as a tracking and reporting system, though.

Trey


 -- Original message --
From: Marcos Fogaga [EMAIL PROTECTED]
 Hi,
 
  
 
 It is possible create a trigger (subroutine) for a pick file (non SQL
 table)?
 
 On D3 we have CALLX, is there a feature like this in Universe?
 
  
 
 Thanks in advance.
 
  
 
 Best Regards,
 
  
 
 Marcos Fogaca
 
 Integral Sistemas
 
 Sao Paulo / Brazil
 ---
 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] [AD] checking files for corruption

2007-09-11 Thread Jeff Fitzgerald
Scott,

Are you still with a company that uses FAST?  If so, it does a good job
of checking file integrity and doesn't interfere with other users.

COUNT will find gross errors, FILE.STAT is a little better, but these
kinds of utilities can miss problems such as a large record with a flink
/ blink problem several buffers along the chain.

HTH,

Jeff Fitzgerald
Fitzgerald  Long, Inc.
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, September 11, 2007 9: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] Re: [U2C] Religious Wars

2007-09-11 Thread Dawn Wolthuis
On 9/11/07, Moderator [EMAIL PROTECTED] wrote:
 All,
   It is no secret that I vehemently disagree with making this an
 unmoderated list.

I must have missed some of the conversation because I did not hear
anyone suggest that the list be unmoderated, just that it be moderated
like many other lists where folks do not get chided or their
conversations closed down if they have somethig to do with the subject
of the list.  I very much recognize that something else was decided
with this list when the u2-community approach was taken.  I disagreed
with it then, but played along, and was thinking that perhaps the time
had come to close that list down and have one list like the jbase
folks, for example.

If the majority opinion is to keep all meta conversations (like this
one) and all discussions about U2 that are more general than specific,
perhaps seemingly theoretical to some (I'm seen as a practitioner by
anyone in the theory world, but sometimes my questions and responses
have theory in them) out of u2-users, so that the guidelines are not
changed, then I will continue to comply.  And, again, I am not just
concerned with my own postings, but with the general sense of the
community.

To me, these guidelines feel excessively male, for example, perhaps
more so than the U2 community of developers at large.  With the brain
differences that have made news in recent years, that might make
sense.  It might make sense to more males than females that one could
cut out community and move it to some separate place.

 So I'm going to take a poll. Everyone who is looking
 forward to no moderator intervention during the next GOTO war or Single
 Letter Variable war or next Monty Python Quote jamboree,

You are setting up a scenario that I don't think anyone requested.
Unless the Monte Python quotes include a wIntegrate or Accuterm
interface or something, wink wink, I would expect a moderator to end
such threads if they get too off track.

 please sound
 off your approval. All those who want to see personal attacks
 unsanctioned, sing out.

Who are these people?  I think I asked the question differently and
got positive responses to shutting down u2-community and permitting
the u2 related topics to be in this list.

 And please take a moment to vote for obscene and
 inappropriate comments as well.

It appears you are purposely painting a very different picture than
anything that anyone else has suggested.  I'm not sure why you are,
however.

   Those who think the mods *should* step in on those sort of things,
 kindly explain exactly what rules want and don't want. Because the
 'freedom now' posts are not well thought out.

I'm not sure what you think to be ill-thought out, but I am not sure
you are hearing me and others, Chuck. I am not looking for freedom
from moderation at all.  I am looking for freedom to post and response
on topics of interest to me and others, even if they do not involve
the word printer, for example.  I recall asking how people
classified their file types in the past (transaction, hostory, code
files, ...), as an example of an interchange that would help me in my
job and perhaps others in theirs, but that not everyone who is trying
to write an EVAL statement to xyz might find interesting..

   Digest users, for example, can't filter out posts.

I didn't think many people used digests any more, but one person told
me that he does and simply does not want to filter e-mail and wants to
open all posts, so he would prefer they all be relevant to him (or
something like that, I'm still not quite sure). Given tools like gmail
and yahoo mail, among others, this is a personal choice that people
make, but not one that should interfere as much as it does in
potentially shutting down threads of interest to others.  That is just
an opinion, of course.

 People who have
 quotas on their e-mail boxes really don't want important messages
 bouncing because two people decide to chat on the list about the nuances
 of implementing a rock-paper-scissors design strategy on various MV
 platforms. Some people are stuck with low speed connections.

Because I suspect that to be a minority position (I could be wrong),
perhaps we could pass along only some subset of threads to a second
list.  For the purpose of understanding what these might be, what
criteria does a u2-users posting need to meet to be one that some
subset of u2-users would like as the only type of e-mails on the list?

   The reason U2-Community is under used is because the vast majority of
 people on this list aren't very interested in that sort of endless naval
 gazing.

Of course if you clamp down on a list, those whose postings would fall
outside of the def are bound to float away over time. I suspect that I
am not the only one who does not like to be told that I just posting
something that has been deemed END OF THREAD.  It is enough to make me
not want to post anything.

 Bear in mind, I generally don't END OF THREAD anything
 immediately. I shut it down 

[U2] RE: [U2C] Religious Wars

2007-09-11 Thread Jerry Banker
Well said.
Do you realize that this thread is actually being talked about on both
lists now! :-)
Jerry

-Original Message-
From: Jeff Fitzgerald [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 11, 2007 3:01 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2C] Religious Wars

Chill, Chuck!  ;-)  As Bruce Neylon pointed out, your emotions
are leading you to distort things a tad.  But, this is such a nice group
that no one is going to attack you for venting or suggest that you not
do that.  Even if tomorrow you wish you'd waited to hit SEND no one here
will jump down your throat for expressing yourself.

I don't believe anyone wants an un-moderated group -- I know I
don't.  And I think everyone would agree that the moderators have been
doing a fine job and have contributed value to the list far in excess of
their pay.  So I vote to keep the list moderated.

However there have been some valid questions raised, including
these:

*  [AD] tagging - What are the rules?  Who decides when a post
is an ad?  What is the punishment?  [MY OPINION] If the sole purpose of
a post is clearly to advertise a product it should be tagged in the
subject line.  Otherwise, we should allow a lot of slack and not worry
about it.  [/MY OPINION] [DISCLAIMER] I am a software vendor and was
recently cyber spanked for a post which Charles (erroneously)
categorized as touting a product. [/DISCLAIMER]

*  u2-community list - Should there be two lists?  Who decides
when a post should be moved or killed?  [MY OPINION] There should only
be one list and we should allow a lot of slack before killing a thread.
If there are a lot of MP posts I guess that means that quite a few list
members are enjoying that thread and I have no problem with it
continuing a bit as long as I can identify related posts by subject
line.  Maybe the list should decide when enough's enough - perhaps five
votes from list members to kill a thread?  [/MY OPINION]

*  serious issues - What should cause a moderator to step in,
kill a thread, reject a post, revoke list membership or take other
serious action?  [MY OPINION]  Posting of pornography, obscene language,
personal attacks against other members, racist or sexist comments,
spamming the list, harvesting member addresses for spamming purposes or
other posts that offend the list membership.  Perhaps feedback from five
members ought to be enough to revoke membership; I like the idea of the
moderator assisting in the administration of a list that is actually run
by the membership.  [/MY OPINION]

Jeff Fitzgerald
---
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 Doug Miller

At 02:01 PM 9/11/2007, you wrote:


It is possible create a trigger (subroutine) for a pick file (non SQL
table)?


Yes.  I just so happened looked this up for someone else this 
morning.  The best source of documentation I came across was this FAQ.


File Trigger Example
 Technote (FAQ)

Problem
Sometimes it is useful to find out what processing has occurred on a 
file. For instance, records may have been deleted from a file in 
error and these records need to be tracked. Placing a trigger on a 
file which fires after the delete can keep a record of the event.


Cause
From the 10.0 release of UniVerse, and later, it is possible to 
place a trigger on a UniVerse file.


Solution
UniVerse executes (fires) triggers when some action changes the 
file's data. UniVerse treats all events that change the database as 
either an INSERT, UPDATE, or DELETE action. For example, a BASIC 
WRITE statement would be either an INSERT or UPDATE action and a 
BASIC DELETE would be treated as a DELETE action.


The following is an example of how to place a trigger on a file which 
fires when a DELETE has taken place. The trigger updates a separate 
file which can then be read to find out what was deleted.



Some example code for a trigger BASIC subroutine follows. It is 
called FILETRIG and is saved in the BP file. A trigger BASIC 
subroutine must contain 14 arguments in a specific order. For more 
information on these arguments, see the chapter titled File Triggers 
in the UniVerse System Description manual.


0001: SUBROUTINE 
TEST(TEST,SCHEMA,TABLE,EVENT,TIME,NEWID,NEWREC,OLDID,OLDREC,ASSOC,ASSOC.EVENT,COUNT,CHAIN.CASCADE,CASCADE)

0002: COMMON /TEST/ AUDITFV
0003: FILEOPENED = FILEINFO(AUDITFV,0)
0004: IF FILEOPENED NE 1 THEN
0005: OPEN '','TRIG_AUDIT' TO AUDITFV ELSE CRT 'COULD NOT OPEN TRIG_AUDIT';
0006: RETURN
0007: END
0008: ITEM = 'Deleted ':OLDID:' in ':TABLE
0009: ID = TIMEDATE(): '*' :OLDID
0010: LOOP
0011: RECORDLOCKU AUDITFV,ID
0012: ON ERROR RETURN
0013: LOCKED
0014: NAP 250
0015: CONTINUE
0016: END
0017: EXIT
0018: REPEAT
0019: WRITE ITEM ON AUDITFV,ID
0020: RETURN

After FILETRIG is compiled it must be globally catalogued:

CATALOG BP FILETRIG
*ce*FILETRIG cataloged.

Now create the trigger on the file in question:

CREATE TRIGGER TEST.TRIGGER AFTER DELETE ON TEST.FILE FOR EACH ROW 
CALLING *ce*FILETRIG;

Adding trigger TEST.TRIGGER

Now create the file TRIG_AUDIT:

CREATE.FILE TRIG_AUDIT 30
Creating file TRIG_AUDIT as Type 30.
Creating file D_TRIG_AUDIT as Type 3, Modulo 1, Separation 2.
Added @ID, the default record for RetrieVe, to D_TRIG_AUDIT.

Now, if a record is deleted from the file called TEST.FILE, 
TEST.TRIGGER will fire and update the TRIG_AUDIT file. As an example, 
record id 103 was deleted from TEST.FILE. Listing TRIG_AUDIT gives:


$50LIST TRIG_AUDIT 16:32:23  15-09-06  PAGE1
TRIG_AUDIT

16:32:16 1
5 SEP 2006
*103

1 records listed.



Doug Miller   [EMAIL PROTECTED]
Manager of Technical Services
Strategy 7Dallas TX 
---

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 gerry-u2ug
Hi Marcos, what version of universe are you running ?
We used to use the index w subroutine method you describe but this is
now gone in favour of native universe triggers.  We have many files in
universe with triggers on them , there is no requirement to SQL'ize the
table and believe me these tables would take a LOT of work to make them
sql conformant.
Universe will add a SICA for the table but that's it, any garbage hashed
file works just fine afaik.





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: September 11, 2007 04:07 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe and triggers

Hi Marcos,

Universe seems hellbent on invoking the entire SQL system in order to
put a simple trigger on a file.  UniData is MUCH more forgiving in that
regard.

With Universe, I have had a certain amount of success making what I call
'indexed subroutines'  where by an index on a file calls a virtual
Dictionary subroutine which does, in fact, operate as a rudimentary
trigger.  You CANNOT affect data going to the actual file record update
as you might with an actual trigger, but you can write information to a
tracking database and then I have a background phantom in operation
which manages email distribution from the triggered events and what not.
I *could* even write back to the originating file record that initiated
the trigger -- I've closed off the mortal embrace between phantom and
virtual subroutine -- but that will always have a lag time between the
actual record update event and the final conclusion of the trigger, so I
would not consider it a particularly clean solution for true database
triggering.  It does work well as a tracking and reporting system,
though.

Trey


 -- Original message --
From: Marcos Fogaga [EMAIL PROTECTED]
 Hi,
 
  
 
 It is possible create a trigger (subroutine) for a pick file (non SQL
 table)?
 
 On D3 we have CALLX, is there a feature like this in Universe?
 
  
 
 Thanks in advance.
 
  
 
 Best Regards,
 
  
 
 Marcos Fogaca
 
 Integral Sistemas
 
 Sao Paulo / Brazil
 ---
 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 and triggers

2007-09-11 Thread Geoffrey Mitchell
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).

Geoff

[EMAIL PROTECTED] wrote:

Hi Marcos,

Universe seems hellbent on invoking the entire SQL system in order to put a
simple trigger on a file.  UniData is MUCH more forgiving in that regard.

With Universe, I have had a certain amount of success making what I call
'indexed subroutines'  where by an index on a file calls a virtual Dictionary
subroutine which does, in fact, operate as a rudimentary trigger.  You CANNOT
affect data going to the actual file record update as you might with an actual
trigger, but you can write information to a tracking database and then I have
a background phantom in operation which manages email distribution from the
triggered events and what not.  I *could* even write back to the originating
file record that initiated the trigger -- I've closed off the mortal embrace
between phantom and virtual subroutine -- but that will always have a lag time
between the actual record update event and the final conclusion of the
trigger, so I would not consider it a particularly clean solution for true
database triggering.  It does work well as a tracking and reporting system,
though.

Trey


 -- Original message --
From: Marcos Fogaga [EMAIL PROTECTED]


Hi,



It is possible create a trigger (subroutine) for a pick file (non SQL
table)?

On D3 we have CALLX, is there a feature like this in Universe?



Thanks in advance.



Best Regards,



Marcos Fogaca

Integral Sistemas

Sao Paulo / Brazil
---
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/





--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
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 Charles Barouch

Trey,
   I do the same thing. You have to keep the actions taken by the 
trigger brief, though. You don't want to interfere with the entry, 
maintenance, and other updating that the file receives.


- Chuck

[EMAIL PROTECTED] wrote:

Hi Marcos,

With Universe, I have had a certain amount of success making what I call 
'indexed subroutines'  where by an index on a file calls a virtual Dictionary 
subroutine which does, in fact, operate as a rudimentary trigger.

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


RES: [U2] Universe and triggers

2007-09-11 Thread Marcos Fogaça
Hi Doug,

The problem is that the TEST.FILE MUST be a UV SQL Table. In my case, will
be a problem if a need to convert my regular files using the command
CONVERT.SQL, it will be painful.

Regards,

Marcos Fogaca

-Mensagem original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de Doug Miller
Enviada em: terga-feira, 11 de setembro de 2007 18:01
Para: u2-users@listserver.u2ug.org
Assunto: Re: [U2] Universe and triggers

At 02:01 PM 9/11/2007, you wrote:

It is possible create a trigger (subroutine) for a pick file (non SQL
table)?

Yes.  I just so happened looked this up for someone else this 
morning.  The best source of documentation I came across was this FAQ.

File Trigger Example
  Technote (FAQ)

Problem
Sometimes it is useful to find out what processing has occurred on a 
file. For instance, records may have been deleted from a file in 
error and these records need to be tracked. Placing a trigger on a 
file which fires after the delete can keep a record of the event.

Cause
 From the 10.0 release of UniVerse, and later, it is possible to 
place a trigger on a UniVerse file.

Solution
UniVerse executes (fires) triggers when some action changes the 
file's data. UniVerse treats all events that change the database as 
either an INSERT, UPDATE, or DELETE action. For example, a BASIC 
WRITE statement would be either an INSERT or UPDATE action and a 
BASIC DELETE would be treated as a DELETE action.

The following is an example of how to place a trigger on a file which 
fires when a DELETE has taken place. The trigger updates a separate 
file which can then be read to find out what was deleted.


Some example code for a trigger BASIC subroutine follows. It is 
called FILETRIG and is saved in the BP file. A trigger BASIC 
subroutine must contain 14 arguments in a specific order. For more 
information on these arguments, see the chapter titled File Triggers 
in the UniVerse System Description manual.

0001: SUBROUTINE 
TEST(TEST,SCHEMA,TABLE,EVENT,TIME,NEWID,NEWREC,OLDID,OLDREC,ASSOC,ASSOC.EVEN
T,COUNT,CHAIN.CASCADE,CASCADE)
0002: COMMON /TEST/ AUDITFV
0003: FILEOPENED = FILEINFO(AUDITFV,0)
0004: IF FILEOPENED NE 1 THEN
0005: OPEN '','TRIG_AUDIT' TO AUDITFV ELSE CRT 'COULD NOT OPEN TRIG_AUDIT';
0006: RETURN
0007: END
0008: ITEM = 'Deleted ':OLDID:' in ':TABLE
0009: ID = TIMEDATE(): '*' :OLDID
0010: LOOP
0011: RECORDLOCKU AUDITFV,ID
0012: ON ERROR RETURN
0013: LOCKED
0014: NAP 250
0015: CONTINUE
0016: END
0017: EXIT
0018: REPEAT
0019: WRITE ITEM ON AUDITFV,ID
0020: RETURN

After FILETRIG is compiled it must be globally catalogued:

 CATALOG BP FILETRIG
*ce*FILETRIG cataloged.

Now create the trigger on the file in question:

 CREATE TRIGGER TEST.TRIGGER AFTER DELETE ON TEST.FILE FOR EACH ROW 
CALLING *ce*FILETRIG;
Adding trigger TEST.TRIGGER

Now create the file TRIG_AUDIT:

 CREATE.FILE TRIG_AUDIT 30
Creating file TRIG_AUDIT as Type 30.
Creating file D_TRIG_AUDIT as Type 3, Modulo 1, Separation 2.
Added @ID, the default record for RetrieVe, to D_TRIG_AUDIT.

Now, if a record is deleted from the file called TEST.FILE, 
TEST.TRIGGER will fire and update the TRIG_AUDIT file. As an example, 
record id 103 was deleted from TEST.FILE. Listing TRIG_AUDIT gives:

$50LIST TRIG_AUDIT 16:32:23  15-09-06  PAGE1
TRIG_AUDIT

16:32:16 1
5 SEP 2006
*103

1 records listed.



Doug Miller   [EMAIL PROTECTED]
Manager of Technical Services
Strategy 7Dallas TX 
---
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 and triggers

2007-09-11 Thread Geoffrey Mitchell

After FILETRIG is compiled it must be globally catalogued:

CATALOG BP FILETRIG
*ce*FILETRIG cataloged.

Note that, depending on your account flavor, this may not do what you 
need.  I believe that you need an Information flavor catalog.  We have a 
verb setup as follows:


ED VOC ICATALOG
6 lines long.

: P
0001: V
0002: CATALOG
0003: I
0004: BDGZ
0005: catalog
0006: INFORMATION.FORMAT


Using this will. globally catalog your subroutine.  A pick format 
catalog will only locally catalog it (create an entry in the VOC on the 
local account).  I could be wrong in some detail, but this is my 
understanding, and waht I have found to work.


--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Religious Wars

2007-09-11 Thread Tom Dodds
I am against the unmoderated list and I am against the combining of the two
lists into one.  I often wait with great anticipations the intervention of
the moderator when a thread gets to far off track, for my thinking.

Tom Dodds

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Moderator
Sent: Tuesday, September 11, 2007 9:34 AM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: [U2] Religious Wars

All,
   It is no secret that I vehemently disagree with making this an 
unmoderated list. So I'm going to take a poll. Everyone who is looking 
forward to no moderator intervention during the next GOTO war or Single 
Letter Variable war or next Monty Python Quote jamboree, please sound 
off your approval. All those who want to see personal attacks 
unsanctioned, sing out. And please take a moment to vote for obscene and 
inappropriate comments as well.

   Those who think the mods *should* step in on those sort of things, 
kindly explain exactly what rules want and don't want. Because the 
'freedom now' posts are not well thought out.

   Digest users, for example, can't filter out posts. People who have 
quotas on their e-mail boxes really don't want important messages 
bouncing because two people decide to chat on the list about the nuances 
of implementing a rock-paper-scissors design strategy on various MV 
platforms. Some people are stuck with low speed connections.

   The reason U2-Community is under used is because the vast majority of 
people on this list aren't very interested in that sort of endless naval 
gazing.  Bear in mind, I generally don't END OF THREAD anything 
immediately. I shut it down when the value vs. volume becomes reduced. 
If it is running too long, but still of interest, I send it to 
U2-Community. If asking you to change the address on the send line is 
enough to completely kill a topic, you weren't very invested in it, were 
you?

 If this sounds angry, you have read it correctly.

   This is now a U2UG board issue and will be discussed at the Wednesday 
meeting. I suggest you put your opinions out in the open, on 
U2-Community -as that is where it belongs under the CURRENT rules, 
before then.

 - Charles Barouch, Moderator

To subscribe or resubscribe to U2-Community 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/


RES: [U2] Universe and triggers

2007-09-11 Thread Marcos Fogaça
Hi,

My UV is release 10.2 and if I try convert a regular pick file there are the
error message :

CREATE TRIGGER T_TRIGGER AFTER INSERT OR UPDATE ON GVMTA030 FOR EACH ROW
CALLING '*T_TRIGGER';
UniVerse/SQL: Invalid file type specified.
Warning: SICA information could not be read properly!!

T_TRIGGER
001 SUBROUTINE
T_TRIGGER(PAR1,PAR2,PAR3,PAR4,PAR5,PAR6,PAR7,PAR8,PAR9,PAR10,PAR1
1,PAR12,PAR13,PAR14)
002 RETURN

What type of file are you using?

Thanks in advance.

Regards,

Marcos Fogaca

-Mensagem original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de gerry-u2ug
Enviada em: terga-feira, 11 de setembro de 2007 18:26
Para: u2-users@listserver.u2ug.org
Assunto: RE: [U2] Universe and triggers

Hi Marcos, what version of universe are you running ?
We used to use the index w subroutine method you describe but this is
now gone in favour of native universe triggers.  We have many files in
universe with triggers on them , there is no requirement to SQL'ize the
table and believe me these tables would take a LOT of work to make them
sql conformant.
Universe will add a SICA for the table but that's it, any garbage hashed
file works just fine afaik.





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: September 11, 2007 04:07 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe and triggers

Hi Marcos,

Universe seems hellbent on invoking the entire SQL system in order to
put a simple trigger on a file.  UniData is MUCH more forgiving in that
regard.

With Universe, I have had a certain amount of success making what I call
'indexed subroutines'  where by an index on a file calls a virtual
Dictionary subroutine which does, in fact, operate as a rudimentary
trigger.  You CANNOT affect data going to the actual file record update
as you might with an actual trigger, but you can write information to a
tracking database and then I have a background phantom in operation
which manages email distribution from the triggered events and what not.
I *could* even write back to the originating file record that initiated
the trigger -- I've closed off the mortal embrace between phantom and
virtual subroutine -- but that will always have a lag time between the
actual record update event and the final conclusion of the trigger, so I
would not consider it a particularly clean solution for true database
triggering.  It does work well as a tracking and reporting system,
though.

Trey


 -- Original message --
From: Marcos Fogaga [EMAIL PROTECTED]
 Hi,
 
  
 
 It is possible create a trigger (subroutine) for a pick file (non SQL
 table)?
 
 On D3 we have CALLX, is there a feature like this in Universe?
 
  
 
 Thanks in advance.
 
  
 
 Best Regards,
 
  
 
 Marcos Fogaca
 
 Integral Sistemas
 
 Sao Paulo / Brazil
 ---
 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] 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/


[U2] Religious Wars

2007-09-11 Thread Jeff Fitzgerald
Chill, Chuck!  ;-)  As Bruce Neylon pointed out, your emotions
are leading you to distort things a tad.  But, this is such a nice group
that no one is going to attack you for venting or suggest that you not
do that.  Even if tomorrow you wish you'd waited to hit SEND no one here
will jump down your throat for expressing yourself.

I don't believe anyone wants an un-moderated group -- I know I
don't.  And I think everyone would agree that the moderators have been
doing a fine job and have contributed value to the list far in excess of
their pay.  So I vote to keep the list moderated.

However there have been some valid questions raised, including
these:

*  [AD] tagging - What are the rules?  Who decides when a post
is an ad?  What is the punishment?  [MY OPINION] If the sole purpose of
a post is clearly to advertise a product it should be tagged in the
subject line.  Otherwise, we should allow a lot of slack and not worry
about it.  [/MY OPINION] [DISCLAIMER] I am a software vendor and was
recently cyber spanked for a post which Charles (erroneously)
categorized as touting a product. [/DISCLAIMER]

*  u2-community list - Should there be two lists?  Who decides
when a post should be moved or killed?  [MY OPINION] There should only
be one list and we should allow a lot of slack before killing a thread.
If there are a lot of MP posts I guess that means that quite a few list
members are enjoying that thread and I have no problem with it
continuing a bit as long as I can identify related posts by subject
line.  Maybe the list should decide when enough's enough - perhaps five
votes from list members to kill a thread?  [/MY OPINION]

*  serious issues - What should cause a moderator to step in,
kill a thread, reject a post, revoke list membership or take other
serious action?  [MY OPINION]  Posting of pornography, obscene language,
personal attacks against other members, racist or sexist comments,
spamming the list, harvesting member addresses for spamming purposes or
other posts that offend the list membership.  Perhaps feedback from five
members ought to be enough to revoke membership; I like the idea of the
moderator assisting in the administration of a list that is actually run
by the membership.  [/MY OPINION]

Jeff Fitzgerald


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Moderator
Sent: Tuesday, September 11, 2007 8:34 AM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: [U2C] Religious Wars

All,
   It is no secret that I vehemently disagree with making this an
unmoderated list. So I'm going to take a poll. Everyone who is looking
forward to no moderator intervention during the next GOTO war or Single
Letter Variable war or next Monty Python Quote jamboree, please sound
off your approval. All those who want to see personal attacks
unsanctioned, sing out. And please take a moment to vote for obscene and
inappropriate comments as well.

snip

 - Charles Barouch, Moderator
---
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 Doug Miller
At 04:24 PM 9/11/2007, Marcos Fogaga wrote:
Hi Doug,

The problem is that the TEST.FILE MUST be a UV SQL Table. In my case, will
be a problem if a need to convert my regular files using the command
CONVERT.SQL, it will be painful.


Not per this line in the FAQ as well as reports
from some others posting that they implemented triggers on UV files.

From the 10.0 release of UniVerse, and later, it
is possible to place a trigger on a UniVerse file.




Doug Miller   [EMAIL PROTECTED]
Manager of Technical Services
Strategy 7Dallas TX
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] coldfusion login errors with universe [AD]

2007-09-11 Thread Janet Bond
Hello,

This most likely will not be the response you were hoping for but I thought I 
would let you know that Fusion Direct Java Data Adapter works seamlessly with 
ColdFusion.

Please contact me if you would like further information.

Thanks
Janet Bond
1.866.266.2326 x159



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator
Sent: Monday, September 10, 2007 12:36 PM
To: rsaassoc; u2-users@listserver.u2ug.org
Subject: [U2] coldfusion login errors with universe

REPOSTED FOR NON-MEMBER ADDRESS: rsaassoc [EMAIL PROTECTED]

Bounce Notice: If you read this list through Indexfocus, Nabble, or any other 
replicator - and you would like to be able to participate - sign up directly 
with us. Here's all you need to know: To subscribe or
resubscribe please visit http://listserver.u2ug.org/.


Anyone have any idea. uv 10.2 windows xp coldfusion 7.
ODBC works with excel and others.



Connection verification failed for data source: u2
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][IBM][UVODBC][2701920]Error ID: 46 Severity: ERROR Facility:
DBCAPERR
- UCI Error. Func: SQLConnect(); State: IM980; uniVerse code: 0; Msg:
[IBM][SQL Client]Remote password is required..
The root cause was that: java.sql.SQLException:
[Macromedia][SequeLink JDBC
Driver][ODBC Socket][IBM][UVODBC][2701920]Error ID: 46 Severity: ERROR
Facility: DBCAPERR - UCI Error. Func: SQLConnect(); State: IM980;
uniVerse
code: 0; Msg: [IBM][SQL Client]Remote password is required..
---
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-11 Thread Clifton Oliver

I use triggers on 10.2 files frequently.

What file type is GVMTA030?

If it's a type 1 or 19, it won't work. If it is a static hashed 2  
through 18 it will. Also works on type 30.


However, if it is a distributed file, you have to create the trigger  
on each individual partfile; you cannot name the top level DF.


Also, do a tcl

.L GVMTA030

And see if there is an M in line four. Creating triggers on multi  
data level files requires some tricks as the comma is not valid in a  
file name for CREATE TRIGGER (SQL syntax restriction).



--

Regards,

Clif

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


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


Hi,

My UV is release 10.2 and if I try convert a regular pick file  
there are the

error message :

CREATE TRIGGER T_TRIGGER AFTER INSERT OR UPDATE ON GVMTA030 FOR  
EACH ROW

CALLING '*T_TRIGGER';
UniVerse/SQL: Invalid file type specified.
Warning: SICA information could not be read properly!!

T_TRIGGER
001 SUBROUTINE
T_TRIGGER(PAR1,PAR2,PAR3,PAR4,PAR5,PAR6,PAR7,PAR8,PAR9,PAR10,PAR1
1,PAR12,PAR13,PAR14)
002 RETURN

What type of file are you using?

Thanks in advance.

Regards,

Marcos Fogaca

-Mensagem original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de gerry-u2ug
Enviada em: terga-feira, 11 de setembro de 2007 18:26
Para: u2-users@listserver.u2ug.org
Assunto: RE: [U2] Universe and triggers

Hi Marcos, what version of universe are you running ?
We used to use the index w subroutine method you describe but this is
now gone in favour of native universe triggers.  We have many files in
universe with triggers on them , there is no requirement to SQL'ize  
the
table and believe me these tables would take a LOT of work to make  
them

sql conformant.
Universe will add a SICA for the table but that's it, any garbage  
hashed

file works just fine afaik.





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: September 11, 2007 04:07 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe and triggers

Hi Marcos,

Universe seems hellbent on invoking the entire SQL system in order to
put a simple trigger on a file.  UniData is MUCH more forgiving in  
that

regard.

With Universe, I have had a certain amount of success making what I  
call

'indexed subroutines'  where by an index on a file calls a virtual
Dictionary subroutine which does, in fact, operate as a rudimentary
trigger.  You CANNOT affect data going to the actual file record  
update
as you might with an actual trigger, but you can write information  
to a

tracking database and then I have a background phantom in operation
which manages email distribution from the triggered events and what  
not.
I *could* even write back to the originating file record that  
initiated

the trigger -- I've closed off the mortal embrace between phantom and
virtual subroutine -- but that will always have a lag time between the
actual record update event and the final conclusion of the trigger,  
so I

would not consider it a particularly clean solution for true database
triggering.  It does work well as a tracking and reporting system,
though.

Trey


 -- Original message --
From: Marcos Fogaga [EMAIL PROTECTED]

Hi,



It is possible create a trigger (subroutine) for a pick file (non SQL
table)?

On D3 we have CALLX, is there a feature like this in Universe?



Thanks in advance.



Best Regards,



Marcos Fogaca

Integral Sistemas

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

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

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


[U2] Re: [U2C] Religious Wars

2007-09-11 Thread Dawn Wolthuis
Well said, Jeff, and good point, Jerry.  --dawn

On 9/11/07, Jerry Banker [EMAIL PROTECTED] wrote:
 Well said.
 Do you realize that this thread is actually being talked about on both
 lists now! :-)
 Jerry

 -Original Message-
 From: Jeff Fitzgerald [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, September 11, 2007 3:01 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2C] Religious Wars

Chill, Chuck!  ;-)  As Bruce Neylon pointed out, your emotions
 are leading you to distort things a tad.  But, this is such a nice group
 that no one is going to attack you for venting or suggest that you not
 do that.  Even if tomorrow you wish you'd waited to hit SEND no one here
 will jump down your throat for expressing yourself.

I don't believe anyone wants an un-moderated group -- I know I
 don't.  And I think everyone would agree that the moderators have been
 doing a fine job and have contributed value to the list far in excess of
 their pay.  So I vote to keep the list moderated.

However there have been some valid questions raised, including
 these:

*  [AD] tagging - What are the rules?  Who decides when a post
 is an ad?  What is the punishment?  [MY OPINION] If the sole purpose of
 a post is clearly to advertise a product it should be tagged in the
 subject line.  Otherwise, we should allow a lot of slack and not worry
 about it.  [/MY OPINION] [DISCLAIMER] I am a software vendor and was
 recently cyber spanked for a post which Charles (erroneously)
 categorized as touting a product. [/DISCLAIMER]

*  u2-community list - Should there be two lists?  Who decides
 when a post should be moved or killed?  [MY OPINION] There should only
 be one list and we should allow a lot of slack before killing a thread.
 If there are a lot of MP posts I guess that means that quite a few list
 members are enjoying that thread and I have no problem with it
 continuing a bit as long as I can identify related posts by subject
 line.  Maybe the list should decide when enough's enough - perhaps five
 votes from list members to kill a thread?  [/MY OPINION]

*  serious issues - What should cause a moderator to step in,
 kill a thread, reject a post, revoke list membership or take other
 serious action?  [MY OPINION]  Posting of pornography, obscene language,
 personal attacks against other members, racist or sexist comments,
 spamming the list, harvesting member addresses for spamming purposes or
 other posts that offend the list membership.  Perhaps feedback from five
 members ought to be enough to revoke membership; I like the idea of the
 moderator assisting in the administration of a list that is actually run
 by the membership.  [/MY OPINION]

 Jeff Fitzgerald
 
 u2-community mailing list
 [EMAIL PROTECTED]
 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] Religious Wars

2007-09-11 Thread Bill Haskett
Charles:

Cool! A bit-bucket list (or /dev/null).  :-)

If it works for you it works for me. 

Bill

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of 
Stevenson, Charles
Sent: Tuesday, September 11, 2007 12:46 PM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: RE: [U2] Religious Wars

These 2 questions, (moderator/no moderator)  (1 list/2 lists), at first
glance do appear to be 2 independent questions:

  I don't think the proposal to merge the 2 lists is a call for 
  no moderator, just to keeping all the discussion together.
 
 [snipped]
 
 I concur.  I would not like the list unmoderated, 
 but I would like both lists together.

But I think Chuck B is saying that a good part of his service as
moderator consists of flicking runaway threads off u2-users and onto
u2-community.   

[snipped]

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


RE: [U2] UV basic assignment error ?

2007-09-11 Thread Bill Haskett
Tim:

As far as I can tell, UD doesn't have a BASIC runtime-error log.  All of the 
other
logs rarely interest me, but they occasionally do, but this one is a must (or 
so I
thought).

I was told all previous UD developers don't make any BASIC coding errors, so I 
am the
first to request such logging; I moved our application from D3 and you know D3
developers can't program.  :-) 

Bill

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder
Sent: Tuesday, September 11, 2007 12:29 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV basic assignment error ?

 Too bad UD doesn't feel the same way.  :-( 

I'm not sure what this references, but UniData does have a series of log 
files.  They're text files ($UDTBIN/*.log and $UDTBIN/*.errlog), and the 
information doesn't scroll away if you don't catch the entries quickly 
enough.

Tim Snyder
Consulting I/T Specialist
U2 Lab Services
Information Management, IBM Software Group
717-545-6403
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] U2 University Last Week In Denver

2007-09-11 Thread Jackie Burhans
Symeon, Sorry that would be me. I am on the road right now doing the U2 
University events. I connect every now and again for brief bursts so 
haven't had a chance to add you yet. I will do so before the September 
call. We haven't yet made the GUI IDE part of the EAP drop but may be able 
to do so in November so you haven't missed anything yet.

Jackie Burhans
U2 Portfolio Manager
IBM Information Management
Tel: 303-773-7717   T/L 656-7717
Mobile: 719-238-1553 
Email: [EMAIL PROTECTED]
http://www.ibm.com/software/data/u2
Register Now!Tune 
In! 


 



Symeon Breen [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
09/11/2007 01:46 AM
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] U2 University Last Week In Denver






To be a part of the ud7.2 EAP would be nice - I have been asking for 
months but not heard anything yet, I would definitely be a good tester of 
the ide if only I could get hold of it ..




-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans
Sent: 11 September 2007 07:26
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] U2 University Last Week In Denver

I thought I'd give a shot at answering some of Doug's questions about the 
new U2 Developer (aka GUI Basic IDE). 

Is it backward compatible to Universe 9.6 or UniData 6.1? 
   It will require you to install some Basic routines on the server but 
should work with older versions.

Has it been tested by over 700 users?
   No, it hasn't been released yet as part of the Early Adoption Program, 
but it will soon.

Has it been test on Mac, Windows, Linux and Fedora? 
   No, see above. Also currently we have a dependency on a piece that runs 

on Windows-only. That would have to be resolved before we could run on 
other platforms.

Can you update the product using Eclipse's Update Manager?
   We are looking into it.

Does it work on Eclipse 3.3 and Eclipse 3.2?
   Runs today on Eclipse 3.2

Does it run on Java 1.5 or 1.6?
   Runs today on JRE 1.4 and 1.5 (aka 5.0)

Can we test that Editor today in a real world environment?
   No, see above but watch for our announcement of its availability in our 

Early Adopter Program. Subscribe to the U2 News Flash if you haven't 
already and you should see it there soon. 

We are glad to have feedback from those who see this at U2U and those who 
will sign up for the EAP, especially those experienced in this technology. 

We have a number of existing and planned Eclipse-based tools and are 
looking forward to leveraging our experience to build this new tool and 
going back to our existing tools and integrating some or all of this tool 
as appropriate into those. 

And we're glad to have partners also providing modern development tools 
for U2--there cannot be too many good tools!


Jackie Burhans
U2 Portfolio Manager
IBM Information Management
Tel: 303-773-7717   T/L 656-7717
Mobile: 719-238-1553 
Email: [EMAIL PROTECTED]
http://www.ibm.com/software/data/u2
Register Now!Tune 
In! 


 



D [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
09/05/2007 09:20 AM
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] U2 University Last Week In Denver






That U2 Editor you saw at the U2 University will not be out until first
quarter 2008 for Unidata and later for Universe.  Here are the questions 
you
should be asking.

Is it backward compatible to Universe 9.6 or Unidata 6.1?  We doubt it!
Has it been tested by over 700 users?  We doubt it!
Has it been test on Mac, Windows, Linux and Fedora?  We doubt it!
Can you update the product using Eclipse's Update Manager?  We doubt it!
Does it work on Eclipse 3.3 and Eclipse 3.2?  We doubt it!
Does it run on Java 1.5 or 1.6?  We doubt it!
Can we test that Editor today in a real world environment? We doubt it!

We are the only company in the U2 market that has the programming 
expertise
and the years of experience that has been producing and selling Eclipse
based tools.  We are updating our U2 editor and other tools on a daily 
basis
and giving them away.

What are you waiting for?

Regards,
Doug

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Wednesday, September 05, 2007 6:25 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] U2 University Last Week In Denver

I'd also like to add that everyone better start looking into Eclipse
because some great things are going to be built on that platform. They
are also looking to recruit developers and users for an advisory group.
So, if you have some things you would like to see added to the products
this is your chance.
Jerry
---
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 image/jpeg]
---

Re: [U2] Religious Wars

2007-09-11 Thread Louie Bergsagel
I am a subscriber to both lists, and I don't even pay attention to the
source list.

I have Gmail forward both lists to work, where an Outlook filter pops up a
notice, because I like to read things as they come in, again, regardless of
the source list, and everything goes to my Saved - U2 folder.

So it makes no difference to me if there is one list or two.

I say give everyone a vote and the moderator veto power, unless you want to
be the moderator.

I have seen personal attacks on other lists, and they are ugly and
depressing. They make our moderators (past  present) worth their weight in
gold.

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


Re: [U2] Religious Wars

2007-09-11 Thread MAJ Programming
I agree with Allen. It seems fine and I have had no problem with the
moderator's judgement to END THREAD.

Besides, this forum is far more animated and participated than the D3/Mvbase
ones I'm also on. Mvbase could go for weeks without a new topic or reply.

Besides, I can quickly skim over the subject lines to see if I'm interested
in opening it up.

Thanks
Mark Johnson
- Original Message -
From: Allen E. Elwood [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, September 11, 2007 2:52 PM
Subject: RE: [U2] Religious Wars


 I think we should start a war over this!!!  '-)

 Seriously though, I'm on the everything is just fine side

 -Original Message-
 [mailto:[EMAIL PROTECTED] Behalf Of Moderator
 Sent: Tuesday, September 11, 2007 07:34

 All,
It is no secret that I vehemently disagree with making this an
 unmoderated list. snip
 ---
 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] Vote here - Religious Wars

2007-09-11 Thread Scott Ballinger
Ok, so let's vote.  I agree with Jeff's [OPINION]s and Dawn's comments.

My votes:

Issue 1. A single, lightly moderated list; moderator to intervene in cases
of obvious and egregious abuse. (I don't think anyone actually suggested
having an un-moderated list; and I'm sure that _everyone_ appreciates the
moderators' contributions, efforts and time volunteered to date in
maintaining a professional and pleasant on-line community.)
-yes

Issue 2. Leave placing of [AD] brackets up to the sensibilities of the
poster; moderator intervention typically not required.
-yes

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/