Re: [U2] Any code share for Levenshtein distance

[u2ug]

How hard can porting 20 lines of code be ? ;-)


http://en.wikipedia.org/wiki/Levenshtein_distance



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: Wednesday, April 17, 2013 1:39 PM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] Any code share for Levenshtein distance

Hi,

Does anyone have any Basic code that implements the algorithm,
Levenshtein distance?

We are playing with words for a fraud detection project, trying discover
bad guys better.

TIA,
-Baker

Thanks for all the good discussions - I'm lurking and reading now and
then.  Others usually provide splendid answers.



  

This communication, its contents and any file attachments transmitted
with it are intended solely for the addressee(s) and may contain
confidential proprietary information.
Access by any other party without the express written permission of the
sender is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy,
distribute or use the contents, attachments or information in any way.
Please destroy it and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

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

[u2ug]

mv basic doesn't require an END to an IF either

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Louie
Bergsagel
Sent: Sunday, December 09, 2012 3:21 AM
To: U2 Users List
Subject: Re: [U2] Another job ad written by people who have no clue

I'm in my current job because I was willing to learn Python at work and
on my own dime.  I took a beginner's course in Python at the University
of Washington because I didn't know much besides Prime Information,
Henco's Info, Structure/4, UniVerse, UniData and MITS.  It was fun to
learn Python as the syntax was so similar to Pick basic.  Program
controls is through indentation, which we usually use anyway.  They even
go Pick one better:
 an IF statement doesn't need an END.  They all require one, right, so
why
not assume it?  I love that thinking.   Learn some Python.  You'll be
glad
you did.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] [u2] Parallel processing in Universe

[u2ug]

True - but why would you want it any other way ?
Once one end closes it - process is complete 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, October 01, 2012 4:16 PM
To: U2 Users List
Subject: Re: [U2] [u2] Parallel processing in Universe

The only thing about a pipe is that once it's closed, I believe it has
to be re-opened by both Ends again. So if point a opens one end, and
point b opens the other end, once either end closes, It closes for both
sides, and both sides would have to reopen again to use.

To eliminate this, you could have one end open a file, and have the
other sides do a ">>" append To that file - just make sure you include
some kind of dataheader so the reading side knows which Process just
wrote the data.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
Sent: Monday, October 01, 2012 4:11 PM
To: U2 Users List
Subject: Re: [U2] [u2] Parallel processing in Universe

pipes


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, October 01, 2012 4:05 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [u2] Parallel processing in Universe


What's the largest dataset in the Universe user world?
In terms of number of records.

I'm wondering if we have any potential for utilities that map-reduce.
I suppose you would spawn phantoms but how do they communicate back to
the master node?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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


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

Re: [U2] [u2] Parallel processing in Universe

[u2ug]

pipes


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, October 01, 2012 4:05 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [u2] Parallel processing in Universe


What's the largest dataset in the Universe user world?
In terms of number of records.

I'm wondering if we have any potential for utilities that map-reduce.
I suppose you would spawn phantoms but how do they communicate back to
the master node?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] Variable Interpolation

[u2ug]

http://www.thefreedictionary.com/interpolation
in·ter·po·late (n-tûrp-lt)
v. in·ter·po·lat·ed, in·ter·po·lat·ing, in·ter·po·lates 
v.tr.
1. To insert or introduce between other elements or parts.
2. 
a. To insert (material) into a text.
b. To insert into a conversation. See Synonyms at introduce.
3. To change or falsify (a text) by introducing new or incorrect material.
4. Mathematics To estimate a value of (a function or series) between two known 
values.
v.intr.
To make insertions or additions.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Friday, August 24, 2012 12:10 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Variable Interpolation

Sorry but I always thought iterpolation means describing a mathematical 
function like  Y=2X for instance  by producing a graph from it or 
describing key parameters in a system of coordinates (x,y) like where it 
crosses the y- or x-axis, if it rises or falls and in which degree etc. .



On 24/08/2012 04:56, Tony Gravagno wrote:
>> From: jjuser
>> Does UniBasic have a way to do variable interpolation (without
> writing to
>> a file, compiling it as a program, and calling it)?
>
> Do you mean something like this?
>
> VAL = 0
> CALL @"SUB FOO(X,Y);Y=X+1;RETURN"( 3, VAL )
> CRT VAL ; *  4
>
> That would be Awesome! I don't believe any of the MV platforms do that
> because I've been looking for it for 15 years. It can be simulated in
> various ways, but you did limit the scope of the challenge.
>
> I think you're trying to avoid this?:
>
> CODE = \ CRT DATE()+20\
> EXECUTE "PGEN ":CODE CAPTURING OUT
> * OUT is 16327
> In this case the PGEN program reads from TCL, writes, compiles, runs,
> and that output gets captured. But at least the mechanism for
> performing that task is abstracted from this client/application code.
>
> Cache' allows you to enter code at TCL and then execute it without
> saving/compiling. That can also be simulated in U2. I don't think I've
> ever seen anyone else ask for it here - certainly no one willing to
> pay for it. ;)
>
> Out of curiosity, what's your application for this? And please correct
> the above if I've misunderstood the question.
>
> T
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>

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


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

Re: [U2] trimming a list (a test of your ability)

[u2ug]

Oops - meant to say :

I seem to remember this being a problem writing values to an mv file
rather than internal string handling.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
Sent: Friday, July 13, 2012 2:54 PM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

Yep - I've run into that at some time as well.
I seem to remember this being a problem with the editor or with
reading/writing values to an mv file rather than internal string
handling.
If you re-edit the source, do you find that it has been split into :

001 PRINT "DOG
002 ":CHAR(255):"CAT"

?


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, July 13, 2012 1:49 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] trimming a list (a test of your ability)


Well I'll be a horned toad.
However try this

ED BP TESTFF
001 PRINT "DOG":CHAR(255):"CAT"
.^
Up arrow mode
.R/DOG/DOG^255
001 PRINT "DOG ":CHAR(255):"CAT"
.FI

BASIC BP TESTFF

No closing quote

The compiler doesn't see the FF as the same "sort" of thing as other
characters even if the editor does










-Original Message-
From: u2ug 
To: U2 Users List 
Sent: Fri, Jul 13, 2012 10:43 am
Subject: Re: [U2] trimming a list (a test of your ability)


Just to be complete :
for j=0 to 255
   if char(j)='x' then continue
   x="abc":char(j):"xyz"
   l=len(x)
   p=index(x,"x",1)
   if j=0 or l#7 or p#5 then
   crt "j=":j
   crt " x  =[":x:"]"
   crt " len=":l
   crt " pos=":p
   end
ext
nd

=0
x  =[abcxyz]
len=7
pos=5

-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of u2ug
ent: Friday, July 13, 2012 1:10 PM
o: U2 Users List
ubject: Re: [U2] trimming a list (a test of your ability) For universe,
I believe that used to be true - I seem to recall running into his maybe
15+(?) years ago.
 also seem to recall that the resolution to this issue was, as was
mentioned, repending all strings with a length.
Try it:
  x="abc":char(255):"xyz"
 crt "[":x:"]"
 crt len(x)
 crt index(x,"x",1)
nd
[abc xyz]



Original Message-
rom: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of Wjhonson
ent: Friday, July 13, 2012 12:27 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] trimming a list (a test of your ability)

es/No
A string is stored in a fixed length *spot*, and is ended by an FF.
his is *why* if you actually try to create a string in BASIC (or read
one) with n embedded FF in it, the runtime will "truncate" the string It
doesn' actually runcate the variable spot, what it does is fool the
run-time into thinking ou've hit the "end" of the string so it ignores
anything else after it thinking t's leftover garbage from trimming or
something.
So initially let's say you get a "spot" of 8 bytes which is the default
size of ny variable, if you're string is only 8, it will then allocate
you 50 bytes, nd *move* the string into that new spot and the old spot
will just be a direct ointer to the new spot.
If you exceed 50 bytes, it then *allocates* you a new *spot* of 250
bytes lsewhere, and the original 8 byte spot now points at the new spot
And so on.  
However, as it scans the string looking for the *end*, if it encounters
an FF, hat's the end.
he run-time will also garbage-collect the old spots by the way, for use
as ther things.
I'd be surprised if it actually wastes effort to store the length
constantly at he fore, but I'm willing to be edumacated on that abstruse
point. (Or pointer) Will

-Original Message-
rom: Wols Lists 
o: u2-users 
ent: Fri, Jul 13, 2012 3:53 am
ubject: Re: [U2] trimming a list (a test of your ability)

n 12/07/12 16:15, Dave Laansma wrote:
I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares'
about pointers, it still has to get to the end of the 'string' one way
or nother.
xcept that a string, as far as I am aware, uses the "pascal method" I
hink it's alled - namely a string is stored as its length followed by he
string (or a ollerith string as I used to do in FORTRAN).

So, the question then is, does concatenation := establish and append to
a string' faster than <-1>?
ery much so

And if so, why doesn't the database use the same logic for <-1> as it
does for = since technically they're accomplishing the same thing?

cause it's doing it in a completely different way. The <-1> logic just
happens o work" whereas the a

Re: [U2] trimming a list (a test of your ability)

[u2ug]

Yep - I've run into that at some time as well.
I seem to remember this being a problem with the editor or with
reading/writing values to an mv file rather than internal string
handling.
If you re-edit the source, do you find that it has been split into :

001 PRINT "DOG
002 ":CHAR(255):"CAT"

?


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, July 13, 2012 1:49 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] trimming a list (a test of your ability)


Well I'll be a horned toad.
However try this

ED BP TESTFF
001 PRINT "DOG":CHAR(255):"CAT"
.^
Up arrow mode
.R/DOG/DOG^255
001 PRINT "DOG ":CHAR(255):"CAT"
.FI

BASIC BP TESTFF

No closing quote

The compiler doesn't see the FF as the same "sort" of thing as other
characters even if the editor does










-Original Message-
From: u2ug 
To: U2 Users List 
Sent: Fri, Jul 13, 2012 10:43 am
Subject: Re: [U2] trimming a list (a test of your ability)


Just to be complete :
for j=0 to 255
   if char(j)='x' then continue
   x="abc":char(j):"xyz"
   l=len(x)
   p=index(x,"x",1)
   if j=0 or l#7 or p#5 then
   crt "j=":j
   crt " x  =[":x:"]"
   crt " len=":l
   crt " pos=":p
   end
ext
nd

=0
x  =[abcxyz]
len=7
pos=5

-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of u2ug
ent: Friday, July 13, 2012 1:10 PM
o: U2 Users List
ubject: Re: [U2] trimming a list (a test of your ability) For universe,
I believe that used to be true - I seem to recall running into his maybe
15+(?) years ago.
 also seem to recall that the resolution to this issue was, as was
mentioned, repending all strings with a length.
Try it:
  x="abc":char(255):"xyz"
 crt "[":x:"]"
 crt len(x)
 crt index(x,"x",1)
nd
[abc xyz]



Original Message-
rom: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of Wjhonson
ent: Friday, July 13, 2012 12:27 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] trimming a list (a test of your ability)

es/No
A string is stored in a fixed length *spot*, and is ended by an FF.
his is *why* if you actually try to create a string in BASIC (or read
one) with n embedded FF in it, the runtime will "truncate" the string It
doesn' actually runcate the variable spot, what it does is fool the
run-time into thinking ou've hit the "end" of the string so it ignores
anything else after it thinking t's leftover garbage from trimming or
something.
So initially let's say you get a "spot" of 8 bytes which is the default
size of ny variable, if you're string is only 8, it will then allocate
you 50 bytes, nd *move* the string into that new spot and the old spot
will just be a direct ointer to the new spot.
If you exceed 50 bytes, it then *allocates* you a new *spot* of 250
bytes lsewhere, and the original 8 byte spot now points at the new spot
And so on.  
However, as it scans the string looking for the *end*, if it encounters
an FF, hat's the end.
he run-time will also garbage-collect the old spots by the way, for use
as ther things.
I'd be surprised if it actually wastes effort to store the length
constantly at he fore, but I'm willing to be edumacated on that abstruse
point. (Or pointer) Will

-Original Message-
rom: Wols Lists 
o: u2-users 
ent: Fri, Jul 13, 2012 3:53 am
ubject: Re: [U2] trimming a list (a test of your ability)

n 12/07/12 16:15, Dave Laansma wrote:
I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares'
about pointers, it still has to get to the end of the 'string' one way
or nother.
xcept that a string, as far as I am aware, uses the "pascal method" I
hink it's alled - namely a string is stored as its length followed by he
string (or a ollerith string as I used to do in FORTRAN).

So, the question then is, does concatenation := establish and append to
a string' faster than <-1>?
ery much so

And if so, why doesn't the database use the same logic for <-1> as it
does for = since technically they're accomplishing the same thing?

cause it's doing it in a completely different way. The <-1> logic just
happens o work" whereas the append logic was designed to work hat way.
f you use a field number, the code searches for that field - I think it
akes he field as a counter, and searches the string decrementing the
ounter every ime it hits a field mark. When the counter hits zero it's
ound what it's ooking for.
f course, if you start at -1, it never hits zero and ends up at the end
f the tring. 

Re: [U2] trimming a list (a test of your ability)

[u2ug]

Just to be complete :

for j=0 to 255
if char(j)='x' then continue
x="abc":char(j):"xyz"
l=len(x)
p=index(x,"x",1)
if j=0 or l#7 or p#5 then
crt "j=":j
crt " x  =[":x:"]"
crt " len=":l
crt " pos=":p
end
next
end


j=0
 x  =[abcxyz]
 len=7
 pos=5



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
Sent: Friday, July 13, 2012 1:10 PM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

For universe, I believe that used to be true - I seem to recall running into 
this maybe 15+(?) years ago.
I also seem to recall that the resolution to this issue was, as was mentioned, 
prepending all strings with a length.

Try it:

  x="abc":char(255):"xyz"
  crt "[":x:"]"
  crt len(x)
  crt index(x,"x",1)
end

[abc xyz]
7
5


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, July 13, 2012 12:27 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] trimming a list (a test of your ability)


Yes/No

A string is stored in a fixed length *spot*, and is ended by an FF.
This is *why* if you actually try to create a string in BASIC (or read one) 
with an embedded FF in it, the runtime will "truncate" the string It doesn' 
actually truncate the variable spot, what it does is fool the run-time into 
thinking you've hit the "end" of the string so it ignores anything else after 
it thinking it's leftover garbage from trimming or something.

So initially let's say you get a "spot" of 8 bytes which is the default size of 
any variable, if you're string is only 8, it will then allocate you 50 bytes, 
and *move* the string into that new spot and the old spot will just be a direct 
pointer to the new spot.

If you exceed 50 bytes, it then *allocates* you a new *spot* of 250 bytes 
elsewhere, and the original 8 byte spot now points at the new spot And so on.  

However, as it scans the string looking for the *end*, if it encounters an FF, 
that's the end.
The run-time will also garbage-collect the old spots by the way, for use as 
other things.

I'd be surprised if it actually wastes effort to store the length constantly at 
the fore, but I'm willing to be edumacated on that abstruse point. (Or pointer)

Will



-Original Message-
From: Wols Lists 
To: u2-users 
Sent: Fri, Jul 13, 2012 3:53 am
Subject: Re: [U2] trimming a list (a test of your ability)


On 12/07/12 16:15, Dave Laansma wrote:
 I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares'
 about pointers, it still has to get to the end of the 'string' one way  or 
another.
Except that a string, as far as I am aware, uses the "pascal method" I hink 
it's called - namely a string is stored as its length followed by he string (or 
a Hollerith string as I used to do in FORTRAN).
 
 So, the question then is, does concatenation := establish and append to  a 
'string' faster than <-1>?
Very much so
 
 And if so, why doesn't the database use the same logic for <-1> as it  does 
for := since technically they're accomplishing the same thing?
 
ecause it's doing it in a completely different way. The <-1> logic just happens 
to work" whereas the append logic was designed to work hat way.
If you use a field number, the code searches for that field - I think it akes 
the field as a counter, and searches the string decrementing the ounter every 
time it hits a field mark. When the counter hits zero it's ound what it's 
looking for.
Of course, if you start at -1, it never hits zero and ends up at the end f the 
string. But this is by accident not design. To do what you uggest would require 
special case code which doesn't - logically - elong there.
> Sincerely,
 David Laansma
 IT Manager
 Hubbard Supply Co.
 Direct: 810-342-7143
 Office: 810-234-8681
 Fax: 810-234-6142
 www.hubbardsupply.com
 "Delivering Products, Services and Innovative Solutions"
 
heers,
ol
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

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


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


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

Re: [U2] trimming a list (a test of your ability)

[u2ug]

For universe, I believe that used to be true - I seem to recall running into 
this maybe 15+(?) years ago.
I also seem to recall that the resolution to this issue was, as was mentioned, 
prepending all strings with a length.

Try it:

  x="abc":char(255):"xyz"
  crt "[":x:"]"
  crt len(x)
  crt index(x,"x",1)
end

[abc xyz]
7
5


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, July 13, 2012 12:27 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] trimming a list (a test of your ability)


Yes/No

A string is stored in a fixed length *spot*, and is ended by an FF.
This is *why* if you actually try to create a string in BASIC (or read one) 
with an embedded FF in it, the runtime will "truncate" the string It doesn' 
actually truncate the variable spot, what it does is fool the run-time into 
thinking you've hit the "end" of the string so it ignores anything else after 
it thinking it's leftover garbage from trimming or something.

So initially let's say you get a "spot" of 8 bytes which is the default size of 
any variable, if you're string is only 8, it will then allocate you 50 bytes, 
and *move* the string into that new spot and the old spot will just be a direct 
pointer to the new spot.

If you exceed 50 bytes, it then *allocates* you a new *spot* of 250 bytes 
elsewhere, and the original 8 byte spot now points at the new spot And so on.  

However, as it scans the string looking for the *end*, if it encounters an FF, 
that's the end.
The run-time will also garbage-collect the old spots by the way, for use as 
other things.

I'd be surprised if it actually wastes effort to store the length constantly at 
the fore, but I'm willing to be edumacated on that abstruse point. (Or pointer)

Will



-Original Message-
From: Wols Lists 
To: u2-users 
Sent: Fri, Jul 13, 2012 3:53 am
Subject: Re: [U2] trimming a list (a test of your ability)


On 12/07/12 16:15, Dave Laansma wrote:
 I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares'
 about pointers, it still has to get to the end of the 'string' one way  or 
another.
Except that a string, as far as I am aware, uses the "pascal method" I hink 
it's called - namely a string is stored as its length followed by he string (or 
a Hollerith string as I used to do in FORTRAN).
 
 So, the question then is, does concatenation := establish and append to  a 
'string' faster than <-1>?
Very much so
 
 And if so, why doesn't the database use the same logic for <-1> as it  does 
for := since technically they're accomplishing the same thing?
 
ecause it's doing it in a completely different way. The <-1> logic just happens 
to work" whereas the append logic was designed to work hat way.
If you use a field number, the code searches for that field - I think it akes 
the field as a counter, and searches the string decrementing the ounter every 
time it hits a field mark. When the counter hits zero it's ound what it's 
looking for.
Of course, if you start at -1, it never hits zero and ends up at the end f the 
string. But this is by accident not design. To do what you uggest would require 
special case code which doesn't - logically - elong there.
> Sincerely,
 David Laansma
 IT Manager
 Hubbard Supply Co.
 Direct: 810-342-7143
 Office: 810-234-8681
 Fax: 810-234-6142
 www.hubbardsupply.com
 "Delivering Products, Services and Innovative Solutions"
 
heers,
ol
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

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


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

Re: [U2] trimming a list (a test of your ability)

[u2ug]

:= doesn't care because a plain string has no concept of 'delimiters'
therefore no pointers/position to track other than beginning and end.
Agreed <-1> could be special cased to := BUT <3,-1> could not

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Thursday, July 12, 2012 11:15 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares'
about pointers, it still has to get to the end of the 'string' one way
or another.

So, the question then is, does concatenation := establish and append to
a 'string' faster than <-1>?

And if so, why doesn't the database use the same logic for <-1> as it
does for := since technically they're accomplishing the same thing?

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative Solutions"


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid
Sent: Thursday, July 12, 2012 9:41 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

String concatenation will probably work faster since it doesn't care
about pointers IF NEW.LIST#"" THEN NEW.LIST := @AM  (or @VM if you want
in the original format) NEW.LIST := UTILITY.ID

Martin


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: 12 July 2012 14:20
To: Marco Manyevere; U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

This is the best solution, using REMOVE and building a new list instead
of constantly 'shrinking' the original table.

That being said, as NEW.LIST gets rather large, adding new elements to
it can get 'time' consuming. Just like the REMOVE keeps track of the
pointer as you spin through a table, I wish there was a comparable
statement that kept track of the pointer as we added new elements <-1>
to tables.

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative Solutions"

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco
Manyevere
Sent: Thursday, July 12, 2012 4:14 AM
To: U2 Users List
Subject: Re: [U2] trimming a list (a test of your ability)

Is this what the OP is asking about or I'm missing something? The 2 code
fragments look totally different. We dont know what's happening in
GET.UTILITY.RECORD or the significance of UTILITY.NAME and LAST.NAME to
totally eliminate them during the 'optimisation'

I would rather do:
 
NEW.LIST = ''
LOOP
  REMOVE UTILITY.ID FROM KEY.LIST SETTING MORE WHILE MORE:UTILITY.ID
  GOSUB GET.UTILITY.RECORD
   IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN CONTINUE
   NEW.LIST<-1> = UTILITY.ID
REPEAT
KEY.LIST = NEW.LIST
NEW.LIST = '' ;* free the memory
 


 From: Kate Stanton 
To: U2 Users List 
Sent: Thursday, 12 July 2012, 4:27
Subject: Re: [U2] trimming a list (a test of your ability)
  
I am getting sucked in!

NLST = ""   ;* For
new list MAXI = DCOUNT(KEY.LIST<1>,@vM) ;* Count items FOR INO
=1 TO MAXI   ;* Each key in list
  KEY.ID = KEY.LIST<1,INO>;* A key ID
  LOCATE(KEY.ID,NLST,1;POS;'AL') ELSE  ;* see if there
INS KEY.ID BEFORE NLIST<1,POS>   ;* Sort to list
  END
NEXT INO  ;* Check
all keys On 12 July 2012 12:09, Wjhonson  wrote:

>
> 1295  FOR DISPLAY.LOOP = 1 TO KEY.COUNT
> 1296 UTILITY.ID = KEY.LIST<1,DISPLAY.LOOP>
> 1297 GOSUB GET.UTILITY.RECORD
> 1298 IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN
> 1299KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0)
> 1300DISPLAY.LOOP -= 1
> 1301KEY.COUNT -= 1
> 1302 END
> 1303  NEXT DISPLAY.LOOP
>
>
> Comments?
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



--
Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
Phone: + 64 9 360 5310  Mobile: + 64 21 400 486
Email: k...@walstan.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Regarding : Usage of the SEL.CMD

[u2ug]

... and then you should be all set to put everyone on this list out of a
job ...

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Friday, June 08, 2012 1:37 PM
To: 'U2 Users List'
Subject: Re: [U2] Regarding : Usage of the SEL.CMD

> Or you can get your company to spring for a couple of Universe or
Unidata
licenses.  I wouldn't pay for them out of my own pocket unless you have
the
couple grand to spare :)

For personal educational purposes, you can just download the personal
editions from the Rocket website.

And if you haven't already done so, check out the tutorials on the U2UG
website.

Brian



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


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

Re: [U2] U2, satya satya has invited you to open a Gmail account

[u2ug]

This user is very suspicious - email harvesting maybe ?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya
Sent: Monday, May 07, 2012 1:23 PM
To: U2 Users List
Subject: [U2] U2, satya satya has invited you to open a Gmail account

I've been using Gmail and thought you might like to try it out. Here's
an
invitation to create an account.


  You're Invited to Gmail!

satya satya has invited you to open a Gmail account.

Gmail is Google's free email service, built on the idea that email can
be
intuitive, efficient, and fun. Gmail has:

 *Less spam*
Keep unwanted messages out of your inbox with Google's innovative
technology.

*Lots of space*
Enough storage so that you'll never have to delete another message.

*Built-in chat*
Text or video chat with satya satya and other friends in real time.

*Mobile access*
Get your email anywhere with Gmail on your mobile phone.

You can even import your contacts and email from Yahoo!, Hotmail, AOL,
or
any other web mail or POP accounts.

Once you create your account, satya satya will be notified of your new
Gmail address so you can stay in touch. Learn
moreor get
started
!
Sign
up

Google Inc. | 1600 Ampitheatre Parkway | Mountain View, California 94043
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

[U2] Hello

[u2ug]

Is the list alive ?  Haven't seen anything for a week.


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

Re: [U2] Passing by Value 101 ?

[u2ug]

It gives the calling routine a way to ensure that a called routine can't
modify the variables value ( intentionally or inadvertently ).

FOR COUNTER=1 TO 10
IF IWANTTOCAUSEPROBLEMS
THEN CALL *BADSUB( @LOGNAME , COUNTER ) ;* go boom !
ELSE CALL *BADSUB( (@LOGNAME) , (COUNTER) ) ;*
everything ok
NEXT

SUBROUTINE BADSUB (ARG1,ARG2)
ARG1="XXX"  ;* this will globally change the value of
@LOGNAME believe it or not
ARG2="XXX"  ;* this will mess up the FOR NEXT
END


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Friday, January 27, 2012 7:52 PM
To: U2 Users List
Subject: Re: [U2] Passing by Value 101 ?

It is not clear to me why "Passing By Value" is worth anything.  

I am surprised that this thread has led to so many responses... most...
I did not read.

>From here... having a variable with a name... and calling an external
subroutine... is all the bread and butter that  I would ever need. 

 myGuzInTa = ''
   myGuzOutA =
''
  errorFlag
= ''

Call *SUB.MY.THING.R1(myGuzInTa, myGuzOutA, errorFlag)

Begin case
Case myGuzOutA = ''  ;  gosub xx
 Case 1  ;  gosub yy
Endcase

Putting a thingy-poo in double parens seems to be at odds with good
programming practice.

Perhaps I am missing something...

I promise to try to read clarifying responses...

--Bill

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


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

Re: [U2] Passing by Value

[u2ug]

It generates a variable cross reference listing which gives you a list
of all variables and labels in your program along with and the lines on
which they are referenced in your program, I believe it even identifies
lines where the variables are assigned to ( as opposed to just being
referenced )

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki
Foerthmann
Sent: Thursday, January 26, 2012 4:27 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Passing by Value

What does -X do?
I'd probably compile it with -Z2, run the program in debug and put a 
trace on A.

On 26/01/2012 21:22, u2ug wrote:
> BASIC -X  !!!
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester
> Sent: Thursday, January 26, 2012 4:16 PM
> To: U2 Users List
> Subject: Re: [U2] Passing by Value
>
> One of these searches should eventually work:
>
> L  A=
> L  A =
> L A=
> L A =
>
> Unless the original author used some kind of ridiculous syntaxt like:
>
> A   = 500
>
> Granted, you're also going to get results for any IF/THEN equality
tests
> in the mix, but you'd have the exact same issue if the variable were
> named I.LIKE.TO.USE.VERY.LOOONG.VARIABLE.NAMES.  You might get more
> false positives with A if you also have variables like AA, AAA, BA,
> etc., but one can only hope any programmer that incompetent would get
> fired before they could leave behind too much code like that.
>
> -John
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: Thursday, January 26, 2012 12:59 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Passing by Value
>
>
> Mecki you're not paying attention.
> You have an 8000 line program that uses a variable "A"
> You didn't write it.  You need to find where that variable is
assigned.
> You search for A ?
>
> That's not going to work.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] Passing by Value

[u2ug]

BASIC -X  !!!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester
Sent: Thursday, January 26, 2012 4:16 PM
To: U2 Users List
Subject: Re: [U2] Passing by Value

One of these searches should eventually work:

L  A=
L  A =
L A=
L A =

Unless the original author used some kind of ridiculous syntaxt like:

A   = 500

Granted, you're also going to get results for any IF/THEN equality tests
in the mix, but you'd have the exact same issue if the variable were
named I.LIKE.TO.USE.VERY.LOOONG.VARIABLE.NAMES.  You might get more
false positives with A if you also have variables like AA, AAA, BA,
etc., but one can only hope any programmer that incompetent would get
fired before they could leave behind too much code like that.

-John

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, January 26, 2012 12:59 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Passing by Value


Mecki you're not paying attention.
You have an 8000 line program that uses a variable "A"
You didn't write it.  You need to find where that variable is assigned.
You search for A ?

That's not going to work.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] Brilliant? or not?

[u2ug]

You can get pretty close :  SMAX = IF S1 > S2  THEN S1 ELSE S2

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A.
Green
Sent: Friday, January 13, 2012 3:32 PM
To: 'U2 Users List'
Subject: Re: [U2] Brilliant? or not?

Are you trying to emulate C?

SMAX = (S1 > S2) ? S1 : S2;

David A. Green
(480) 813-1725
DAG Consulting

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, January 13, 2012 10:42 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Brilliant? or not?


SMAX = (S1 > S2) * S1 + (S2 >= S1) * S2

?


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

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


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

Re: [U2] Testing . . .

[u2ug]

Well that's 1

After the posting overload last week this week has been zero.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Verhagen
Sent: Thursday, November 24, 2011 11:40 AM
To: 'U2 Users List'
Subject: Re: [U2] Testing . . .

4 ... 5 ... 6

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- 
> boun...@listserver.u2ug.org] On Behalf Of u2ug
> Sent: Thursday, November 24, 2011 8:34 AM
> To: U2 Users List
> Subject: [U2] Testing . . .
> 
> 1 ... 2  ... 3
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users



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


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

[U2] Testing . . .

[u2ug]

1 ... 2  ... 3

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

Re: [U2] Changing TCL prompt?

[u2ug]

There is - PROMPT 'x' - but it only allows 1 character 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
gcan...@coverys.com
Sent: Wednesday, October 05, 2011 2:06 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Changing TCL prompt?


Hi everyone,

Maybe I am going back to my Prime INFORMATION days, but I thought there
was a way to set the '>' prompt to a free form prompt, or to display the
account name you were in as the TCL prompt.  I know that can be done at
the OS level.

Am I dreaming, or is there a (fairly easy) way without having to write
code to do it?

Thanks

Gary P. Canedy
Senior Database Analyst
P: 617.757.6775
F: 617.428.9803
gcan...@coverys.com

(Embedded image moved to file: pic24821.jpg)

101 Arch Street, 4th Floor
Boston, MA 02110
www.coverys.com
Toll Free:
800.225.6168


--
This email and any files transmitted with it are intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material.   If you received this email in error,
please contact the sender immediately and delete this email from your
system.  If you are not the named addressee, you should not disseminate,
distribute, print, or copy the email, or take any action in reliance on
its contents.


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

Re: [U2] Reading Dictionary Items

[u2ug]

The same as you would with any other file - off the top :

open 'DICT','filename' to dfp else abortm 'Cant open dict filename'

execute 'SELECT DICT filename WITH TYPE="D"'
loop while readnext id
writev id on dfp,id,4
repeat



Gerry


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Thursday, September 29, 2011 2:44 PM
To: U2 Users List
Subject: [U2] Reading Dictionary Items

I would like read open a (large) dictionary, read the line items, and
write back the @ID field to Attribute <4> (the column heading) of each.

Syntax help would be appreciated.

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


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

Re: [U2] Comparing numeric strings

[u2ug]

Have you looked at the COMPARE() function ?
Does the trick under universe.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers
Sent: Friday, August 12, 2011 1:11 PM
To: U2 Users List
Subject: Re: [U2] Comparing numeric strings

Thanks all.  I should have mentioned that I already knew about the
alpha-concatenation hack. I was sort of looking for a cleaner approach.
It looks like SCMP falls down on floating point numbers.  That should
probably be mentioned in the docs, but instead it just fails silently.
;-(

-Rob

On Fri, Aug 12, 2011 at 9:51 AM, Rex Gozar  wrote:

> In July I added to PickWiki:
>
>
> http://www.pickwiki.com/cgi-bin/wiki.pl?UniVerse_Tips_And_Tricks#Forci
> ng_string_comparison_on_numbers
>
> rex
>
> On Fri, Aug 12, 2011 at 8:15 AM, Rob Sobers  wrote:
> > Say you have two strings that happen to be numeric:
> >
> > FOO = "401.0101"
> > BAR = "401.0101000"
> >
> > Since UniBasic is untyped, even though I've wrapped each value in 
> > quotes
> "",
> > they are treated as numbers.  As a result, FOO EQ BAR evaluates to
@TRUE.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] Selecting a List

[u2ug]

What system ?  this works fine in UV.

001  x=@VM:@VM:@VM
002  crt x
003  crt convert(@VM,"x",x)
004 end

>RUN DEV.BP X
²²²
xxx



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Wednesday, June 08, 2011 11:47 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Selecting a List

Hi All,

Again, I need a little help. 

The following PROCEDURE LINE works just fine.  In this case I'm just 
inserting the variable V.CALENDAR.YEAR to complete my file suite and I am 
going after 2  alphanumeric records ('P2021422' 'P2083158').

PROCEDURE LINE "SELECT GLA.":V.CALENDAR.YEAR:" WITH GLA.REF.NO = 
'P2021422' 'P2083158'"

The problem arises when I attempt to select from a LIST (below)

PROCEDURE LINE "SELECT GLA.":V.CALENDAR.YEAR:" WITH GLA.REF.NO = ":
VL.JS.LIST.VAR1

Of course the system does not like the Value Marker so I need to get rid 
of it...

VL.JS.LIST.VAR1 = "'":CONVERT (@VM,"' '",VL.JS.LIST.VAR1):"'"

The hope here is to replace @VM with ' ' and then place the ' at each 
end... but CONVERT will only switch one for one - one @VM for a single 
single quote (') which results in a quote mismatch.

Any suggestions?

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


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

Re: [U2] Universe PE

[u2ug]

This link was posted to the list a while back :

http://www.rocketsoftware.com/u2/resources/premium/downloads/universe-li
nux?searchterm=universe+personal+edition+linux

I just recently downloaded and installed from here.
I am thinking that the rocket fish site download setup hasn't really
been thought out very well :)



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Wednesday, May 25, 2011 2:15 PM
To: U2 Users List
Subject: Re: [U2] Universe PE

Thats pretty much standard behavior nowadays.  At least every time I've
tried it...

You really do have to wait for someone to contact you and give you a
"free"
license for it.

Please someone enlighten us if I'm wrong...

On Wed, May 25, 2011 at 1:57 PM, Dan Fitzgerald
wrote:

>
> To clarify, it appears that this happens for the Linux PE. The Windoze
PE
> downloads.
>
> > From: fft2...@aol.com
> > Date: Wed, 25 May 2011 13:56:34 -0400
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] Universe PE
> >
> > I tried to again go to the download link for the Universe PE. It
lets me
> > fill out the registration form, but then nothing downloads, I just
get an
> > email saying someone will contact me
> >
> > What's up?
> >
> > Will Johnson
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



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


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

Re: [U2] Hello ?

[u2ug]

Aaaah  ,  Bach.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles
Barouch
Sent: Monday, May 02, 2011 9:48 PM
To: U2 Users List
Subject: Re: [U2] Hello ?

I can see you. This may just be that post Spectrum triptophan nap.

Charles Barouch

u2ug  wrote:

>Well - it looks like I can talk to myself - lots or practice there.
>
>Actually what is this " u2-users-boun...@listserver.u2ug.org" :  
>bounces ???
>
>-Original Message-
>From: u2-users-boun...@listserver.u2ug.org
>[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
>Sent: Monday, May 02, 2011 9:39 PM
>To: U2 Users List
>Subject: [U2] Hello ?
>
>The list has gone silent for me for the past week - is there anybody 
>out there ? Just yell if you can hear me ...
>
>___
>U2-Users mailing list
>U2-Users@listserver.u2ug.org
>http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
>___
>U2-Users mailing list
>U2-Users@listserver.u2ug.org
>http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] Hello ?

[u2ug]

Thanks Dan - so I guess the list has just gone on hiatus ?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan
Fitzgerald
Sent: Monday, May 02, 2011 9:48 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Hello ?


I hear you.
 
> Date: Mon, 2 May 2011 21:43:08 -0400
> From: simpson-u...@gerzio.ca
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Hello ?
> 
> Well - it looks like I can talk to myself - lots or practice there.
> 
> Actually what is this " u2-users-boun...@listserver.u2ug.org" : 
> bounces ???
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
> Sent: Monday, May 02, 2011 9:39 PM
> To: U2 Users List
> Subject: [U2] Hello ?
> 
> The list has gone silent for me for the past week - is there anybody 
> out there ? Just yell if you can hear me ...
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] Hello ?

[u2ug]

Well - it looks like I can talk to myself - lots or practice there.

Actually what is this " u2-users-boun...@listserver.u2ug.org" :  bounces
???

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
Sent: Monday, May 02, 2011 9:39 PM
To: U2 Users List
Subject: [U2] Hello ?

The list has gone silent for me for the past week - is there anybody out
there ? Just yell if you can hear me ...

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


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

[U2] Hello ?

[u2ug]

The list has gone silent for me for the past week - is there anybody out
there ? Just yell if you can hear me ...

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

Re: [U2] Is this worth rewriting?

[u2ug]

agreed

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: March 4, 2011 11:05 AM
To: 'U2 Users List'
Subject: Re: [U2] Is this worth rewriting?

I still think all of these constructs as just sooo basic that if you
can't
just read them either which way,  then you had better think about
another
career.

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar
Sent: 04 March 2011 14:09
To: U2 Users List
Subject: Re: [U2] Is this worth rewriting?

 

good comprehension = faster, accurate programming (that's programming,
not code execution)

We all want fast and accurate programming.  To improve comprehension,
you have to write code to (a) reveal its logical structure, and (b)
reveal the business rules implemented in the code.

Sorry, but structures like:

IF A:B:C NE '' THEN CUM(M) = A+B+C

(concatenating variables as a string, then performing numeric
operations on them) slows down the comprehension process.  And for
what benefit?  To me, that's just a lazy programmer that doesn't want
to type a few extra keystrokes.

Another structure caused a number of comments:

IF condition THEN statement ELSE
   other-statement
END

(inline THEN followed by block ELSE). It appears that some readers saw
the "#" in the condition and assumed an "If Not Not" structure at
first, missing the THEN.

I find it interesting that no one has commented on the fact that
CUM(M) gets conditionally reinitialized, and whether or not that is
important.  But it proves my points that neither the structure nor
business rules are clear within the OP's code.

You can have 2 years programming experience, or 20, it does not
matter.  Better structure and variable naming will vastly improve
program accuracy. (On the other hand, I could make this code really,
really fast if it didn't have to be accurate!)

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

  _  

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3480 - Release Date: 03/03/11

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


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

Re: [U2] Clear Messages

[u2ug]

I believe those are the program counters




-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: February 10, 2011 06:29 PM
To: U2 Users List
Subject: [U2] Clear Messages

The following program (and sub) returns the following string.  What is nice 
about it is that if running SYSTEM(9001) from a sub, it comes back with the 
grand path.  

2ý/usr/ibm/uv/catdir/*SUB.GET.PROGR/AM.NAME.R0ý0x0þ1ý/u2/CODE/B.BP.O/GET.CODE.DATA.R0ý0x16aþ

What is the significance of the data at the end of the sub-strings... that 
is... 0x0  and   x16a ?

--Bill

*

  call *SUB.GET.PROGRAM.NAME.R0(Who.Am.I)
  
  crt  Who.Am.I

*

SUBROUTINE SUB.GET.PROGRAM.NAME.Rx(This.Program.Name)

  This.Program.Name = SYSTEM(9001)
  
RETURN  
END

Thanks to those who responded earlier especially Steve and Will.

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


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

Re: [U2] How to Clear Empty VM marks in Field

[u2ug]

That gets rid of all @VMs not just the empty trailing ones.
I realize it answers the very specific example posted , but if that example was 
really the case being questioned I would say just use FXI=FXI<1,1,1>  or count=1
I would assume that this question is really being asked about a more general 
situation such as FXI  = 1ý2ýý
In which case >> FXI=trim(FXI,@VM,'T')
To remove all empty @VM delimited fields >> FXI=trim(FXI,@VM,'R')



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: January 31, 2011 09:13 AM
To: U2 Users List
Subject: Re: [U2] How to Clear Empty VM marks in Field

Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not do the job?
or FXI=CHANGE(FXI,CHAR(253),"") 

Maybe: 

EQU CLEARVM TO CONVERT CHAR(253) TO "" IN
...
...
...
CLEARVM FXI

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
> Sent: Friday, January 28, 2011 8:26 PM
> To: U2 Users List
> Subject: Re: [U2] How to Clear Empty VM marks in Field
> 
> I suspect that there is no canned function.
> 
> I little homemade sub could look like
> 
> SUBROUTINE SUB.XM.Counter(FXI, XM.Count)
> 
> XM.Count = 0
> Total.String.Length = len(FXI)
> For Posn = 1 to Total.String.Length
> 
>   Next = Posn + 1
> 
>   This.Char = FXI[Posn, 1]
>   Next.Char = FXI[Next, 1]
> 
>   Begin case
> Case This.Char = VM  ;  begin case
>   Case This.Char =
> Next.Char  ;  null
>   Case 1  ;
> XM.Count += 1
>Endcase
>   End   case
> 
> Next Posn
> 
> return
> END
> 
> I hope that I made no speling mistakes this time...
> 
> --Bill
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Garry Smith
> Sent: Friday, January 28, 2011 7:30 PM
> To: U2 Users List
> Subject: [U2] How to Clear Empty VM marks in Field
> 
> FXI  = 1ýý
> 
>  DCount(FXI,VM) returns 3
> Is there function to clear the blank value marks so that FXI = 1
> and then DCOUNT would return 1
> 
> TIA
> 
> Garry L. Smith
> Dir Info Systems
> Charles McMurray Company
> V# 559-292-5782   F# 559-346-6169
> 
> -Original Message-
> From: Garry Smith
> Sent: Friday, January 28, 2011 2:04 PM
> To: 'U2 Users List'
> Subject: RE: [U2] What do you do with CallHTTP?
> 
> I tried to but we are still using AIX 4.3.3 and UV 9.6
> 
> Garry L. Smith
> Dir Info Systems
> Charles McMurray Company
> V# 559-292-5782   F# 559-346-6169
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
> Sent: Friday, January 28, 2011 1:29 PM
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> On 1/28/2011 1:50 PM, David Wolverton wrote:
> > What uses have you found for CallHTTP for in your applications?
> None whatsoever.
> > Are you 'eating' someone else's data with it - like doing lookups
> > against a web service call?
> >
> > Or are you using it to 'serve' data to others?  Rocket says you can
> do
> > this, but I can't see how it would work offhand and would like to
> know
> > the scenario.
> >
> > How complex have you found it and how stable?
> >
> Too complex, not sure about stability.
> 
> I am following someone on c.d.p's lead from 2006 and using curl.  I
> have also used wget in the past for a dictionary items to do a
> filecheck on web images.  You can use wget in --spider mode and it will
> just give you back an http 200 if the file resolves, but will not
> actually download it.
> > Thanks for your thoughts!
> >
> >
> >
> >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] UUID [was Data in Dict]

[u2ug]

Sorry - I missed the second page.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: January 27, 2011 05:25 PM
To: U2 Users List
Subject: Re: [U2] UUID [was Data in Dict]

The use of both the @USER.NO and the current PID ensure the UUID is
unique across the installation, and the presence of the UV system id
makes the UUID unique between systems.
The named common ensures the current port does not generate the same
UUID within the same second/millisecond.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
Sent: Thursday, 27 January 2011 11:19 PM
To: U2 Users List
Subject: Re: [U2] UUID [was Data in Dict]

This is only guaranteed to be unique "per process" due to the usage of
named common.
Different processes running on the same system could generate duplicate
values.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: January 26, 2011 07:35 PM
To: U2 Users List
Subject: Re: [U2] UUID [was Data in Dict]

Interesting trade-off between the overhead of calculating a unique-yet
compact sequential number and calculating a consistently long UUID.

We use the "last-number-stored-in-a-file" method.

We recently had need for a UUID as part of an XML exchange with a third
party. I looked at the various options available, and eventually ended
up writing a UV subroutine to create a UUID in v4 format.

It is not overly complex - the hardest part was working out the bit
manipulations needed.
The result is unique across UV systems due to the use of the UV system
id.

-

subroutine MAKE.UUID( UUID )
*
*  This subroutine generates a version 4 UUID, following the
*  rules outlined in the RFC found here:
* http://tools.ietf.org/html/rfc4122.html
*
common /UUID$GEN/ UUID$lastgen
if unassigned(UUID$lastgen) then UUID$lastgen = ''
DECLARE GCI getpid

time.NOW = system(12)
date.NOW = date()
date.BASE = iconv( "15 Oct 1582", "D")

* We need to determine the accuracy of the time value
* From this we derive the appropriate factor to apply to
* convert our time from seconds/milliseconds to nanoseconds
if index( time.NOW, ".", 1) then
   * The TIME.MILLISECOND compiler option is NOT active
time.NOW = time.NOW * 1
nano.FACTOR = 10
time.PERDAY = 86400 * 1
end else
   * The TIME.MILLISECOND compiler option IS active
   nano.FACTOR = 100
   time.PERDAY = 86400 * 1000
end

* We need to ensure we can cope if we create more than 1 UUID
* in the same millisecond.
this.STAMP = date.NOW:"-":time.NOW

* Need to use 'compare' on large 'numbers'.
* A result of 0 means they are equal
if compare( this.STAMP, field( UUID$lastgen, ".", 1)) = 0 then

   * We have already created one this (milli)second.
TAIL = oconv( field( UUID$lastgen, ".", 2), "MCN") + 0
if TAIL then
   TAIL += 1
   this.STAMP = fieldstore( UUID$lastgen, ".", 2, 1, TAIL)
end else
   TAIL = 1
   this.STAMP := ".1"
end
time.NOW += (TAIL / 10)

end

* Track our latest generation
UUID$lastgen = this.STAMP

* Now we can build our UUID
time.UUID = ((date.NOW - date.BASE) * time.PERDAY) + time.NOW
nano.UUID = time.UUID * nano.FACTOR

port.NOW = abs(@USERNO)
port.HEX = oconv( port.NOW, "MCDX")"R%4"

ver.VAL = rnd(65535)
ver.VAL = bitreset( ver.VAL, 12)
ver.VAL = bitset( ver.VAL, 13)
ver.VAL = bitreset( ver.VAL, 14)
ver.VAL = bitreset( ver.VAL, 15)
ver.HEX = oconv( ver.VAL, "MCDX")

rnd.VAL = rnd(255)
rsvd.VAL = bitset( rnd.VAL, 6)
rsvd.VAL = bitreset( rsvd.VAL, 7)
rsvd.HEX = oconv( rsvd.VAL, "MCDX")

sysid.HEX = oconv( system(31), "MCDX")"R%6"
pid.NOW = getpid()
pid.HEX = oconv( pid.NOW, "MCDX")"R%6"

* UUID Structure
* <1> =  : 8 char hex value for time
* <2> =  : 4 char hex value
* <3> =  : 4 char hex value
* <4> =  : 2 char hex value :  :
2 char hex value
* <5> =  : 12 char hex value
UUID = ''
UUID<1> = oconv(nano.UUID, "MCDX")"R%8"
UUID<2> = port.HEX
UUID<3> = ver.HEX
UUID<4> = rsvd.HEX:oconv(rnd(255), "MCDX")"R%2"
UUID<5> = sysid.HEX:pid.HEX

convert @AM to "-" in UUID

return

-


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Thursday, 27 January 2011 10:46 AM
To: U2 Users List
Subject: Re: [U2] UUID [was Data in Dict]

We also are using a form of UUID instead of sequential numbering on most
of our new files. A lot ea

Re: [U2] UUID [was Data in Dict]

[u2ug]

This is only guaranteed to be unique "per process" due to the usage of
named common.
Different processes running on the same system could generate duplicate
values.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: January 26, 2011 07:35 PM
To: U2 Users List
Subject: Re: [U2] UUID [was Data in Dict]

Interesting trade-off between the overhead of calculating a unique-yet
compact sequential number and calculating a consistently long UUID.

We use the "last-number-stored-in-a-file" method.

We recently had need for a UUID as part of an XML exchange with a third
party. I looked at the various options available, and eventually ended
up writing a UV subroutine to create a UUID in v4 format.

It is not overly complex - the hardest part was working out the bit
manipulations needed.
The result is unique across UV systems due to the use of the UV system
id.

-

subroutine MAKE.UUID( UUID )
*
*  This subroutine generates a version 4 UUID, following the
*  rules outlined in the RFC found here:
* http://tools.ietf.org/html/rfc4122.html
*
common /UUID$GEN/ UUID$lastgen
if unassigned(UUID$lastgen) then UUID$lastgen = ''
DECLARE GCI getpid

time.NOW = system(12)
date.NOW = date()
date.BASE = iconv( "15 Oct 1582", "D")

* We need to determine the accuracy of the time value
* From this we derive the appropriate factor to apply to
* convert our time from seconds/milliseconds to nanoseconds
if index( time.NOW, ".", 1) then
   * The TIME.MILLISECOND compiler option is NOT active
time.NOW = time.NOW * 1
nano.FACTOR = 10
time.PERDAY = 86400 * 1
end else
   * The TIME.MILLISECOND compiler option IS active
   nano.FACTOR = 100
   time.PERDAY = 86400 * 1000
end

* We need to ensure we can cope if we create more than 1 UUID
* in the same millisecond.
this.STAMP = date.NOW:"-":time.NOW

* Need to use 'compare' on large 'numbers'.
* A result of 0 means they are equal
if compare( this.STAMP, field( UUID$lastgen, ".", 1)) = 0 then

   * We have already created one this (milli)second.
TAIL = oconv( field( UUID$lastgen, ".", 2), "MCN") + 0
if TAIL then
   TAIL += 1
   this.STAMP = fieldstore( UUID$lastgen, ".", 2, 1, TAIL)
end else
   TAIL = 1
   this.STAMP := ".1"
end
time.NOW += (TAIL / 10)

end

* Track our latest generation
UUID$lastgen = this.STAMP

* Now we can build our UUID
time.UUID = ((date.NOW - date.BASE) * time.PERDAY) + time.NOW
nano.UUID = time.UUID * nano.FACTOR

port.NOW = abs(@USERNO)
port.HEX = oconv( port.NOW, "MCDX")"R%4"

ver.VAL = rnd(65535)
ver.VAL = bitreset( ver.VAL, 12)
ver.VAL = bitset( ver.VAL, 13)
ver.VAL = bitreset( ver.VAL, 14)
ver.VAL = bitreset( ver.VAL, 15)
ver.HEX = oconv( ver.VAL, "MCDX")

rnd.VAL = rnd(255)
rsvd.VAL = bitset( rnd.VAL, 6)
rsvd.VAL = bitreset( rsvd.VAL, 7)
rsvd.HEX = oconv( rsvd.VAL, "MCDX")

sysid.HEX = oconv( system(31), "MCDX")"R%6"
pid.NOW = getpid()
pid.HEX = oconv( pid.NOW, "MCDX")"R%6"

* UUID Structure
* <1> =  : 8 char hex value for time
* <2> =  : 4 char hex value
* <3> =  : 4 char hex value
* <4> =  : 2 char hex value :  :
2 char hex value
* <5> =  : 12 char hex value
UUID = ''
UUID<1> = oconv(nano.UUID, "MCDX")"R%8"
UUID<2> = port.HEX
UUID<3> = ver.HEX
UUID<4> = rsvd.HEX:oconv(rnd(255), "MCDX")"R%2"
UUID<5> = sysid.HEX:pid.HEX

convert @AM to "-" in UUID

return

-


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Thursday, 27 January 2011 10:46 AM
To: U2 Users List
Subject: Re: [U2] UUID [was Data in Dict]

We also are using a form of UUID instead of sequential numbering on most
of our new files. A lot easier to handle and makes maintenance easier.

Thanks for the Stuart, I wasn't aware of that. For those using UniData,
you can use the VOC as follows instead:

UUID
0001 S
0002 !/etc/ncs/uuid_gen

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell,
Stuart
Sent: Thursday, 27 January 2011 10:07 AM
To: U2 Users List
Subject: Re: [U2] UUID [was Data in Dict]

Most OSs have a call available for generating a UUID (Universally Unique
ID) or GUID (Microsoft's acronym for Globally Unique ID). By definition
and accepted generation standards these are almost guaranteed (!) to be
unique (the probability of a clash is extremely small) across all
computers.

In UV you could use GCI to create a UV verb to invoke the OS call. Or
just create a VOC item which you can execute and capture. There are
usually options which affect the format of the output.

For AIX the VOC item might look like this:

 UUID
0001 V
0002 /etc/ncs/uuid_gen
0003 U
0004 CGHIM

For Linux use: /usr/bin/uuidgen
For Windows (not installed by default): guidgen HTH

-Original Me

Re: [U2] data in dict

[u2ug]

Hi Jay,
What is the 'multiple data levels' you are referring to here -
distributed files ?
Gerry




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jay rappaport
Sent: January 26, 2011 12:03 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] data in dict

Once upon a time, it might have made perfect sense to store in the dict
of a file other bits of information to be used by programs. However,
since the indroduction of multiple data levels within a file, this would
seem to be a non-issue if you just created a "fields" data portion for a
file, and then loaded it up with anything you wanted. This would leave
the dictionary clear of anything that might conflict with the OS you are
using. 


Jay



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


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

Re: [U2] Migration

[u2ug]

Agreed, that this is how it is often done.
But there is nothing that says that this is how it has to be done OR
even how it should be done.

These 2 files could be setup such that :

  The CUSTOMER file contains no such embedded 'cross reference' field
for appointments

  The APPOINTMENTS file could be keyed as :
@ID =  CUSTOMERNO*APPTDATE*APPTTIME*APPTTYPE
 With ITYPE entries setup for 
CUSTOMERNO = @ID['*',1,1]
APPTDATE = @ID['*',2,1]
APPTTIME = @ID['*',3,1]
APPTYPE = @ID['*',4,1]

-- OR --
@ID =  sequentially generated 
 With data fields defined for  CUSTOMERNO, APPTDATE, APPTTIME &
APPTYPE

In both cases, indexed on CUSTOMERNO.


I believe you will find the following 2 snippets pretty comparable
performance wise :

* I know there are other better (?) ways to do this
* insert your own list traversal code
appcnt=dcount(custrec,@VM )
for appidx = 1 to appcnt
appid = custrec
next

execute 'SELECT APPOINTMENTS WITH CUSTOMERNO = ':squote(custno)
loop while readnext appid
repeat

Dropping the xref field in the parent table would help immensely with
file sizing as records would tend to be a lot closer in size to the
average instead of having CUSTOMER records that have accumulate massive
xref fields over time - this is a problem I see in systems all the time.
This also gets around your problem of knowing what is related to what -
you know that all keys are automatic indexes in sql server and anything
that could be used for lookup/joining purposes should also have an
explicit index in sql server else it would be a bottleneck in sql server
as well.

There is also nothing that says that a file's key value has to be based
on anything related to the data in the record - some would argue that
key values should NEVER be related to the data.  The only reason to
prefer the 1st method over the 2nd is for human readability which imo
shouldn't be a concern anyway.
The 2nd scheme also gets around the sql->mv field mapping, no defined
relation, no key, non-unique key and key length max exceeded problems,
and would definitely produce a much more even hash distribution.



Just some thoughts,  Gerry







-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: December 24, 2010 01:41 AM
To: U2 Users List
Subject: Re: [U2] Migration

Oh, one more point.  What if your SQL environment had NOT defined a
primary key for APPOINTMENTS, but had multiple indexes, one of which
happened to have CUSTOMERNO, APPTDATE, APPTTIME and APPTTYPE.  How would
you figure out what to use as the item-id of the PICK file?

What if you had a SQL table that actually did not have a set of fields
that guaranteed a unique value? Then you have NOTHING to create an
item-id from!

I have to stop this, it will consume me! :o  But the list goes on.  Oh
the humanity!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Thursday, December 23, 2010 10:36 PM
To: U2 Users List
Subject: Re: [U2] Migration

I may have been unclear in my earlier post, so I'll clarify.

Consider a CUSTOMER file and an APPOINTMENTS file.  The item-id of the
CUSTOMER file is the customer number.  The item-id of the APPOINTMENTS
file is CUSTOMERNO*APPTDATE*APPTTIME*APPTTYPE.

When you have a parent/child relationship in multiple files in MV,
except in those cases where the key to a child file is the item-id of
the parent file with a sequential ordinal, the common way to indicate a
parent-child relationship involving more than one file in MV is to
embed, in the parent item a multivalued set of either all the entire
item-ids of the child table, or the portion that needs to be
concatenated to the parent's item-id.  That is what I call a cross
reference field.  If you don't have this, you are faced with trying to
scan the whole APPOINTMENTS file to find all item-ids that start with
your CUSTOMERNO value.  What you might actually have in the CUSTOMER
file is a set of 3 correlated multivalued attributes that have APPTDATE,
APPTTIME, and APPTTYPE values for all the APPOINTMENTS items that
pertain to the CUSTOMER item.

In a SQL environment, the primary key to the child table would consist
of at least two fields, one or more of which would be the full primary
key of the parent table.  In SQL Server a true primary key forces the
file to actually be sorted by those key fields (it forces a clustered
index).  You can also have secondary indexes that are also pre-sorted by
their indexed columns.  They are effectively complete copies of the
indexed fields and a copy of the primary key so it can directly read the
data once you've found the index entries that match your query.   In our
example above, you'd have CUSTOMERNO as a primary key to the CUSTOMER
table, and 4 separate 

Re: [U2] Why don't calendars show the pick date?

[jpb-u2ug]

Simple if you have a calendar that shows the Julian date. Find out what the
internal date for December 31st of the previous year is and write it
somewhere on the calendar. Then all you have to do is add the Julian date to
it. 

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, November 11, 2010 8:01 AM
To: U2 Users List
Subject: [U2] Why don't calendars show the pick date?

Wouldn't it be so much easier if those desk calendars and wall calendars had
the pick date on them,
as well as the julian date.that would make them so much more useful!


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



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

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

Re: [U2] UniVerse On RedHat?

[jpb-u2ug]

I've never moved UV from HP-Ux to Red Hat but I have worked on both. We went
from a Sun Risc system to Red Hat on Intel and, like Drew said, you would
have to do recompiling of programs and I-descriptors, and either
uvbackup/uvrestore or fnuxi the files. If you use any operating system
scripts or programs those will have to be checked for differences. The
spooler should work pretty much the same. I did our conversion on a Saturday
morning. Moving from a 'nix system to Windows was not as easy.

Jerry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Friday, November 05, 2010 4:59 PM
To: U2 Users List
Subject: [U2] UniVerse On RedHat?

0. We are considering migrating from HP-Ux to RedHat.
1. How is RedHat?
2. Will I have to re-compile and re-catalog everything?
3. Did anyone migrate from HP-Ux to RedHat and then back to HP-Ux?
4. Is the RedHat Standard Edition Suitable?
5. Did anyone try running UV on RedHat on an HP Integritity (Itanium)
server?
6. Are there any gotchas?
7. Insights and hind-sights would be appreciated.

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

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

Re: [U2] I'm baaaack

[jpb-u2ug]

There are discussion email groups like this one as well as forums. Go to the
www.u2ug.org web site and sign up for all of that you want to belong to.

Welcome home.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon
Sent: Thursday, October 28, 2010 8:49 AM
To: U2 Users
Subject: [U2] I'm bck

Greetings Group,

I just started a new position with a company running a Unidata / SB+ shop
after my hiatus from the multivalue market.  It seems some things have
changed since I left (Rocket instead of IBM) but many things seem the same.
I look forward to the discussions on this group which I've missed.

Gordon

Gordon J Glorfield | Software Application Engineer | Vertis Communications
250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201
T 410-361-8664 | M 443-280-7093
gglorfi...@vertisinc.com | http://www.vertisinc.com

Vertis Communications is a results-driven marketing communications company
that delivers inventive advertising, direct marketing and interactive
solutions to prominent brands across North America. Our deep industry
knowledge and extensive range of offerings-including integrated data
solutions, digital program management systems, creative services,
world-class print and mail production, logistics, out-of-home and business
process outsourcing-are used to deliver superior program performance that
drives bottom line results for our clients. With 100 strategically
positioned locations and more than 5,000 dedicated professionals, we deliver
impeccable quality and fast turn-around to any market.

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

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

Re: [U2] Building XML using the UV XDOM API functions

[jpb-u2ug]

I'll have to disagree with you on this one Tony. As a vendor yourself you
would of course think this way. As an end user of the product we would like
it all to come from one source. This is the reason that Microsoft has got
such a jump on everyone else, they will provide you with all of the tools as
well as the database. I'm talking about the harsh reality of things, at one
time if you went IBM you went all the way, now it's Microsoft. Companies
don't want to deal with several vendors they want one.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Monday, October 25, 2010 11:35 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Building XML using the UV XDOM API functions

Gregor, your comments serve as a testimonial to support my
position against using many of these vendor-supplied toolkits.
Some of them are OK, but many not.  People insist on the DBMS
vendors building stuff for them, but then we get the mess that
you've described.  For this reason I continue to recommend at
least consideration for integration with tools that are outside
of the  DBMS.  DBMS vendors should be focusing on making superior
databases, not XML, web services, or a lot of this other fluff.
People in the open source and commercial markets spend a great
deal of time focused on  these things, and because of this, their
offerings are often much better.  So take a look around and weigh
other offerings against the built-in functionality.  It would be
nice to see people here comparing more toolkits - it might save
others from feeling like they're stuck with whatever is provided
by the DBMS vendors.

T

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

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

Re: [U2] "too many values in sort"

[jpb-u2ug]

I don't think UniVerse has the same limits (SELBUF controls in memory size)
but then UniVerse doesn't use the same structure as Unidata in their
selects.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Monday, October 25, 2010 11:52 AM
To: U2 Users List
Subject: Re: [U2] "too many values in sort"

  Of course, why would anyone need a BASIC program larger than 32K?  I 
believe it's called progress.  Non-configurable size limits are just 
__NOT__ acceptable in today's computing environment.  The attendant 
"work-arounds" are just plain ugly, and inexcusable.

The greatest aspect of PICK is the narrow gulf between the logical and 
the physical; database structure is logical, query syntax is logical, in 
fact, the entire machine is a logical machine.  Twenty year old physical 
limitation should have been resolved at least ten years ago.  :-(

Bill


Kevin King said the following on 10/25/2010 8:27 AM:
> Agreed on all points.  Will check this on my customer's system.
>
> On Mon, Oct 25, 2010 at 9:11 AM, Dave
Daviswrote:
>
>> That's some shopping list.
>>
>> I haven't seen anything anywhere that lets you adjust this limit.
>>
>> Besides breaking the record up into separate tables, you may need to make
a
>> temp file that normalizes this for you, by doing something like stringing
>> the value or row number into the key.
>>
>> I've never had anything approaching 10240 values in a multivalue.
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org [mailto:
>> u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
>> Sent: Monday, October 25, 2010 10:54 AM
>> To: U2 Users List
>> Subject: [U2] "too many values in sort"
>>
>> Unidata 6.1.15 on AIX.  The following command:
>>
>> SSELECT SHOPPING.LIST BY.EXP PROD.NUM
>>
>> Yields the message "too many values in sort".  There is one record in
this
>> file with 36,457 product numbers but would that "break" the BY.EXP?  If
so,
>> is there a config parameter somewhere that could be tweaked to make this
>> work?
>>
>> -Kevin
>> http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

Re: [U2] Licensing

[jpb-u2ug]

We changed from standard licensing to device licensing because of the fact
that many of our users have multiple sessions open of the same IP. It has
helped tremendously. We use to run out of licenses on a regular basis with
only 75 users on a 117 license system. Now we have kept the same number of
licenses except they are device licenses and we hardly ever run out. The
only time that we have is when we had too many objects left as zombies and
it was a heavy day for the web. Just as an aside we use Accuterm which has a
configuration selection for device licensing.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Thursday, October 21, 2010 3:27 PM
To: U2 Users List
Cc: 'U2 Users List'; u2-users-boun...@listserver.u2ug.org
Subject: Re: [U2] Licensing

>> I like to use a small script in the .profile of *ix to limit the number 
of
>> simultaneous logins to say 3

>> Roy

The users feel they have a legitimate need for having quick access to all 
of the screens.  I'm not sure if they do, but I've never done their jobs 
so I hesitate to argue with them.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

Re: [U2] Compiling 102

[jpb-u2ug]

The usage of the CATALOG command depends on the flavor you are using.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Thursday, October 21, 2010 2:24 AM
To: U2 Users List
Subject: Re: [U2] Compiling 102

 Bill,

By default CATALOG will catalog programs globally.
To catalog a program locally you have to use the LOCAL option.
This will generate a VOC entry for the program name without the file name.
So CATALOG BP CODE LOCAL will generate a VOC entry named CODE.
To run the program you only need to type CODE at ECL and your program
will run.
Quite simple really.

Mecki


On 20/10/2010 17:06, Bill Brutzman wrote:
> I have been using Revision suffixes and VOC.  In other words...
>
>> LOGTO SANDBOX
>> ED VOC SAMPLE.PROGRAM
>> PA
>> RUN BP SAMPLE.PROGRAM.R1  --> R2   save
>> BASIC BP SAMPLE.PROGRAM.R2
> After the program is found to be workable...
>
>> LOGTO METAL
>> ED VOC SAMPLE.PROGRAM
>> PA
>> RUN BP SAMPLE.PROGRAM.R1  --> R2   save
> I have only been using CATALOG to register global SUBs.
>
> --Bill
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
> Sent: Wednesday, October 20, 2010 11:44 AM
> To: U2 Users List
> Subject: Re: [U2] Compiling 102
>
> You might want to consider having two "BP" files - Production and Test
> (Sandbox?) - e.g. BP and TEST.BP
> You then use the CATALOG command to control which version is running.
>
> Mark
>
>  
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
> Sent: Wednesday, October 20, 2010 8:28 AM
> To: U2 Users List
> Subject: [U2] Compiling 102
>
> 1. It works.  Thanks to Kat, Tom, Vance, and Drew.
> 2. I am wondering if others keep their source code in an UV account as
such.
> 3. Prior to this thread, I had two accounts
>   /u2/METAL
>   /u2/SANDBOX
>
> 4. The source code was not in a UV account in
>   /u2/SOFTWARE
>
> 5. An advantage that I seem to have now is that I can compile code when
logged in to either METAL or SANDBOX and the compiled code works in both
METAL and SANDBOX.  In other words, I do not have to compile the same source
code for each account.  It is not clear to me how VOC and Q-Pointers are
setup to handle this scheme.
>
> 6. Comments would be welcome.
>
> --Bill
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

Re: [U2] [U2} Cloud UniVerse?

[jpb-u2ug]

I could be wrong but I think they allow it with replication. Then again I
think you also have to keep a minimum number of seats on those systems too.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Thursday, October 07, 2010 1:39 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [U2} Cloud UniVerse?

No one else has mentioned this but there might be a conflict
between your desire to get "disaster recovery seats" and your
desire to run reports from a backup system.  Failover systems
generally should not be used for anything, though some sites do
use them purely for generating reports from the current but
otherwise unused data.  I don't know how Rocket licensing works,
just suggesting that you not be surprised if someone brings this
up.

T 

> From:Bill Brutzman 
> I expect that one of the kickers in this is printing 
> forms. Right now I cannot see how to send print jobs 
> from the cloud host through our static IP router to 
> our printers.
> 
> Also, I sent a message to our sales rep at Rocket to 
> ask about how licensing would work.  That is, would we 
> need to buy more seats or is there special pricing for 
> disaster recovery seats.

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

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

Re: [U2] CUPS printing and sequence of jobs

[jpb-u2ug]

When we used cups on our Linux server I had to go directly to the IP address
of the printer circumnavigating the Windows print server. Going through the
print server created too many problems, especially for print jobs that we
had imbedded pcl coding.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, October 05, 2010 1:21 PM
To: U2 Users List
Subject: Re: [U2] CUPS printing and sequence of jobs

it's a Canon Imagerunner copier/printer with it's own "pc" acting as a
server.
I'm not really sure what OS it's running, I don't think it's windows.

I'm submitting lpd protocol to it, directly to it's IP

I switched our side so that cups sends to a Windows PC running RPM lpd
server, 
   and RPM then sends the raw data to a windows network printer (same
copier/server)
   except it's getting it's jobs through the networks windows printer
server, and
   the jobs print as expected.

So, it's definitely in the Canons PC's lpd server specifically.

This all sounds great..and solved, EXCEPT, we have found another little
issue
with cups, it seems when the lpd server is busy, cups triggers the printer
queue
to disable (ErrorPolicy stop-printer), which is extremely annoying to have
to
keep reenabling the queue when you send a flurry of jobs. So we changed it
so the
ErrorPolicy retry-job instead, now it doesn't take the queue offline,
instead now
it just doesn't send a job to the server, but still deletes it from it's
queue.

SoUntil I can get this lost job issue solved, looks like I have choices:

1. Look into changing from lpd protocol (port 515) to Ipp protocol (port
9100) (next attempt)
2. See if the server's admin can set something so the lpd server does FIFO
3. have fun sorting printed jobs back into their correct order!

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen
> Sent: Tuesday, October 05, 2010 1:50 PM
> To: U2 Users List
> Subject: Re: [U2] CUPS printing and sequence of jobs
> 
> Is this with a standalone hardware printer server, or a PC acting as a
> printer server? If the latter, with what software on the PC?
> 
> Our Print Wizard software for Windows can act as a printer server. We
> have
> *some* capabilities for job sequencing, and we could explore more
> options
> with you if this is critical.
> 
> On Tue, 5 Oct 2010, George Gallen wrote:
> 
> > the debug info shows they were sent to the printer in the numerical
> unix job# order.
> > I disabled the printer, sent the jobs again, and the unix job# order
> was the same
> >as the order sent, I renabled the printer and when the jobs
> printed they were
> >in random order, according to the cups log, they were sent in the
> correct order.
> >
> > So it looks like it's the receiving print server that is sending them
> in random
> >order to the printer, of course the admin for that server swears
> it does FIFO...
> >
> > Thanks for the debug tip...
> >
> > > -Original Message-
> > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
> > > Sent: Saturday, October 02, 2010 12:51 PM
> > > To: U2 Users List
> > > Subject: Re: [U2] CUPS printing and sequence of jobs
> > >
> > > Maybe turn the logging up a notch and verify the order they are
> being
> > > submitted?  It might not be considered "submitted" until it
> finishes
> > > spooling, where a large job can be surpassed by smaller jobs.  We
> would
> > > not really want it to "block" on large print jobs.  Take for
> instance
> > > you start spooling an invoice run that may take 5-6 minutes to
> spool,
> > > you do you not want to process any other jobs while this thing is
> > > transferring to the queue?
> > > ___
> > > U2-Users mailing list
> > > U2-Users@listserver.u2ug.org
> > > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >
> 
> Regards,
> Bob Rasmussen,   President,   Rasmussen Software, Inc.
> 
> personal e-mail: r...@anzio.com
>  company e-mail: r...@anzio.com
>   voice: (US) 503-624-0360 (9:00-6:00 Pacific Time)
> fax: (US) 503-624-0760
> web: http://www.anzio.com
>  street address: Rasmussen Software, Inc.
>  10240 SW Nimbus, Suite L9
>  Portland, OR  97223  USA
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] where did everyone go ?

[u2ug]

I guess everyone is just happy happy so no reason post ?  Or has the
list just become irrelevant ?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: September 30, 2010 10:00 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] where did everyone go ?


I'm still here :) I noticed the same thing though. Wonder if some people
dropped off the mailing list..
 
-Chris

 
> Date: Fri, 1 Oct 2010 06:52:26 +0530
> From: anantkum...@gmail.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] where did everyone go ?
> 
> Same here :-)
> 
> Anant
> 
> On Tue, Sep 28, 2010 at 12:58 PM,  wrote:
> 
> > I'm lurking as usual, nothing to add, lots to learn. 8-)
> >
> > Brian
> >
> >
> >
> > From: "u2ug" 
> > To: 
> > Date: 27/09/2010 18:07
> > Subject: [U2] where did everyone go ?
> > Sent by: u2-users-boun...@listserver.u2ug.org
> >
> >
> >
> > The number of postings has drastically dropped over the past few
weeks
> > down to virtually zero
> > Has the list been relegated the dust bin and I missed the notice ?
> >
> >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] UV index with duplicate nodes

[jpb-u2ug]

Does the correlative have any special coding in it? I would suggest deleting
the index for this field recreate the field as a D type then add the field
to the index again. Some correlatives don't give you what you would expect.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis
Sent: Thursday, September 30, 2010 7:47 PM
To: U2-Users@listserver.u2ug.org
Subject: [U2] UV index with duplicate nodes

We've just uncovered a rather unusual and unsettling situation.  We have a
file with a single index that has somehow gotten nodes with duplicate keys.
A simple example would be having an index on ZIPCODE in a address database,
and finding that there are _two_ nodes (records) in the index for ZIPCODE
12345, for example.  The source records referred to in the nodes are not
duplicated, but since most operations find the 'first' node, any source
records referred to in the duplicate node appear to not exist in the index.

>LIST.INDEX fname ALL
Alternate Key Index Summary for file fname
File... fname
Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
num/I-type
fieldnameANot Reqd  YesYes  ML N2


The file contains 6,539,233 records, with 574,547 unique values in fieldname
(which is actually a single-valued field, and has been verified that each
record's fieldname contains one and only one value).  We found that 9 source
records appear to have not been included in the index, but upon further
research found the nodes with duplicate keys.  We created an F-pointer to
the index file itself (not normally recommended, but useful), then got the
results like the following:

LIST indexfile WITH @ID = "12345]" F1 F2

fname. F1 F2
12345  987654 876543
12345-6789 765432 543219
12345  654321

We are having our UniVerse administrator ask our dealer for assistance, but
were interested if any other users have had any recent similar experiences,
or advice.

Sincerely Best Regards,

Richard Lewis
IBM Certified Solutions Expert

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

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

Re: [U2] UVRESTORE error

[jpb-u2ug]

Look up the command in the documentation. You will notice that if you are
going to restore to a lower revision you will need to back up with one of
the -rev options.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, September 28, 2010 1:22 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UVRESTORE error


Hello,

We have a new version of UniVerse on our new server and every night we make
a backup image
using UVBACKUP. Today I tried to do a UVRESTORE from last night's backup
onto the old server
which is running a slightly older version of UniVerse and received the
following message:

WARNING: Unable to restore image of revision level 10.  This
process is only capable of restoring backup images
created with revisions between 2 and 9, inclusive.

I'm assuming this message is due to the different versions of UniVerse but I
was curious if there
was a quick workaround that people have found? 

Thanks,

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

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

Re: [U2] where did everyone go ?

[u2ug]

So it wasn't just me


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: September 27, 2010 12:27 PM
To: U2 Users List
Subject: Re: [U2] where did everyone go ?

>>> The number of postings has drastically dropped over the past few
weeks 
down to virtually zero Has the list been relegated the >>> dust bin and
I 
missed the notice ?

All of the problems have been solved.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

[U2] FW: Warning: mvargh...@silverlinewindow.com - User unknown!

[u2ug]

Any idea why I got this bounce back ?  shouldn't this just have gone to
the list server and not to me ?



-Original Message-
From: MDaemon at mdaemon.slbp.com [mailto:mdae...@silverlinewindow.com] 
Sent: September 27, 2010 12:08 PM
To: u2ug
Subject: Warning: mvargh...@silverlinewindow.com - User unknown!

mvargh...@silverlinewindow.com - no such user here.

There is no user by that name at this server.
: Message contains [1] file attachments


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

[U2] where did everyone go ?

[u2ug]

The number of postings has drastically dropped over the past few weeks
down to virtually zero 
Has the list been relegated the dust bin and I missed the notice ?



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

Re: [U2] Does Reality Flavor have globally cataloged subroutines?

[JPB-U2UG]

We are running in Reality flavor and have many globally cataloged programs. 
We have separate catalog commands for doing this just as others have 
mentioned. I have never seen a problem doing this.

Jerry

--
From: "George Gallen" 
Sent: Thursday, August 26, 2010 9:53 AM
To: "U2 Users List" 
Subject: Re: [U2] Does Reality Flavor have globally cataloged subroutines?


I'll have to play around this this then

Thanks


-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Thursday, August 26, 2010 9:49 AM
To: U2 Users List
Subject: Re: [U2] Does Reality Flavor have globally cataloged
subroutines?

Hi George,

> If I do that, then I lose the features of the Reality Account
> correct? Or Do I change it, catalog the routine, then change
> it back?

You could create an alternative named VOC entry that uses
INFORMATION.FORMAT
to save changing it back.

However, it may not really be an issue. The Reality mode version of
CATALOG
behaves the same as the Information style one with no extra options
(what
Ideal/Information and PI/open call "normal mode"). By selecting the
INFORMATION format you gain LOCAL and global modes.

> The problem is that those accounts were imported from a
> Reality system, and I wanted to use some of the subroutines
> that were written on another account imported from a Prime
> system.

The mode of CATALOG has no effect on what you can call. It only
determines
how the cataloguing is done.


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
+44 (0)1604-709200

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

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


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

Re: [U2] Unix to SQLServer

[JPB-U2UG]

Hear, hear, and as an end user I welcome knowing about new, and old, 
products that are available for my use.


Jerry

--
From: "Larry Hiscock" 
Sent: Friday, August 13, 2010 11:26 AM
To: "'U2 Users List'" 
Subject: Re: [U2] Unix to SQLServer


At the risk of being roasted for mentioning my "vendor product" (see

other threads - it seems to be unpopular) ...

I'm not speaking for the U2UG officially, but as a moderator on this list,
and as the list host.  IMHO, there is nothing wrong with mentioning or
endorsing a product, whether it's free or commercial.  If it provides a
solution to the problem in question, then it's germane to the discussion.

What I personally find distasteful is when someone gives a product a 
glowing
review without disclosing the fact that they stand to benefit from its 
sale.

That's why we've simply asked that when endorsing a product with which one
has a fiduciary relationship, that it be disclosed as such.

Ok, back to the topic...

Larry Hiscock
Moderator

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


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

Re: [U2] RetrieVe enhancements

[JPB-U2UG]

Yes, all of the time. It's still a very good ad hoc reporting tool. Plus we 
have many reports that are generated using retrieve that we transform into 
PDF's.


--
From: "Symeon Breen" 
Sent: Friday, July 16, 2010 2:42 PM
To: "'U2 Users List'" 
Subject: Re: [U2] RetrieVe enhancements


This got me thinking - pardon the question, I have not used retrieve for
such things for many years , but do people still use retrieve for print or
screen reporting ?



Symeon.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: 16 July 2010 16:28
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RetrieVe enhancements

With full agreement that C justification would be helpful if
built-in, this function is easily accomplished with a correlative
or even a call to a common subroutine.

T

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

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


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

[U2] UV Session hang using spool.

[jpb-u2ug]

We've just converted over to Windows 2008 Server running UV 10.3.3 from RH
Linux and I've come across an error that we never had on the Linux system. I
set up a printer with the SETPTR command:

 

SETPTR 0,174,58,0,0,1,NFMT,NOHEAD,BRIEF,NOEJECT,AT
AccountPrint_Landscape,GDI,FONTNAME Courier New,FONTSIZE 8

 

Then I try to spool a file:

 

SPOOL PA_FILE LOGIN

 

Then I get the following error and the session I am working in locks up.

 

Pstartjob: Failed to impersonate user. Error = 6

 

Any answers?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

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

Re: [U2] @LOGNAME... Changing @variables

[u2ug]

That is different from universe where you get the error "@Variable
(Read-only) unexpected" when you try to directly assign to @LOGNAME


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: June 17, 2010 06:53 PM
To: U2 Users List
Subject: Re: [U2] @LOGNAME... Changing @variables

I looked into this and there appears to be 2 different type of "system
variables" in UniData. There are those like @AM which cannot be changed
and those like @LOGNAME which can be. It is not required to pass them to
a subroutine to change those that can be. A program will not compile if
you assign to the first type.

First type (Those that cannot be changed):

@ACCOUNT
@AM
@COMMAND
@CRTHIGH
@CRTWIDE
@DATA
@GID
@LASTVERB
@LEVEL
@LPTRHIGH
@LPTRWIDE
@PARASENTENCE
@PATH
@RM
@SM
@SVM
@SYS.BELL
@SYSTEM.RETURN.CODE
@TM
@TRANSACTION
@TTY
@UDTNO
@UID
@VM
@WHO


Second type (Those that can be freely changed):

@CONV
@DATE
@DICT   (This is actual usage. Documented)
@FORMAT
@HEADER
@ID (This is actual usage. Documented)
@LOGNAME
@MONTH
@RECORD (This is actual usage. Documented)
@RECUR0 (This is actual usage. Documented)
@RECUR1 (This is actual usage. Documented)
@RECUR2 (This is actual usage. Documented)
@RECUR3 (This is actual usage. Documented)
@RECUR4 (This is actual usage. Documented)
@TIME
@USER0  (This is actual usage. Documented)
@USER1  (This is actual usage. Documented)
@USER2  (This is actual usage. Documented)
@USER3  (This is actual usage. Documented)
@USER4  (This is actual usage. Documented)
@USER.RETURN.CODE (This is actual usage. Documented)
@YEAR


Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
Sent: Friday, June 18, 2010 8:29 AM
To: U2 Users List
Subject: Re: [U2] @LOGNAME on Unidata

We ran into a similar situation in the past with uv on hpux
Although @LOGNAME is documented as a readonly value, we found out that
it is possible to change it ( and other readonly system variables ) by
passing it as an argument to a subroutine - the subroutine can then
change the value.  I guess uv doesn't actually mark the variable as
readonly in any way at run time - readonliness is a compile time
attribute - so a subroutine has no idea that its calling args are
readonly system variables - so in effect they aren't.

Look for any subroutines called with @LOGNAME as an argument then check
that the sub doesn't alter that argument.

Given :
...
CALL *SOMESUB( @LOGNAME )
...
DEFINE SUBROUTINE SOMESUB ( ARG )
...
* this will change the argument value in the calling
routine
* including 'readonly' system variables
ARG="Something" 
...
END

Pass temp variable instead of @LOGNAME :
CALL *SOMESUB( @LOGNAME:"" )
-or-
CALL *SOMESUB( (@LOGNAME) )
-or-
Ensure that argument is never modified in the routine --
DEFINE SUBROUTINE SOMESUB ( ARG.IN )
ARG=ARG.IN ;* the only place IARG is ever used
...
ARG="SomethingElse"
...
END

Note that this also applies to functions and routines called via SUBR()
and once the variable is changed it is changed for the lifetime of the
current session not just for the current program.

Gerry



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey
Butera
Sent: June 17, 2010 02:04 PM
To: U2 Users List
Subject: [U2] @LOGNAME on Unidata

We recently migrated from Unidata 7.1.8 on Solaris to Unidata 7.2.5 on 
RedHat.

We make use of @LOGNAME quite a bit to determine a person's username.  
Since our migration, however, we've documented some cases where @LOGNAME

is not returning the proper username - it returns someone else's.
What's bizarre is that most of the time it's right, but occasionally 
it's not.

Has anyone seen or heard of this?

When we had a report of this (with documentation) I thought it was 
weird.  Today we just got a call about a different problem which I'm 99%

sure is tied to this since it makes use of @LOGNAME.  Like the above, 
sometimes it's correct, sometime it's wrong.

-- 
Jeff Butera, Ph.D.
Manager of ERP Systems
Hampshire College
jbut...@hampshire.edu
413-559-5556

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


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

__
This email has b

Re: [U2] @LOGNAME on Unidata

[u2ug]

We ran into a similar situation in the past with uv on hpux
Although @LOGNAME is documented as a readonly value, we found out that
it is possible to change it ( and other readonly system variables ) by
passing it as an argument to a subroutine - the subroutine can then
change the value.  I guess uv doesn't actually mark the variable as
readonly in any way at run time - readonliness is a compile time
attribute - so a subroutine has no idea that its calling args are
readonly system variables - so in effect they aren't.

Look for any subroutines called with @LOGNAME as an argument then check
that the sub doesn't alter that argument.

Given :
...
CALL *SOMESUB( @LOGNAME )
...
DEFINE SUBROUTINE SOMESUB ( ARG )
...
* this will change the argument value in the calling
routine
* including 'readonly' system variables
ARG="Something" 
...
END

Pass temp variable instead of @LOGNAME :
CALL *SOMESUB( @LOGNAME:"" )
-or-
CALL *SOMESUB( (@LOGNAME) )
-or-
Ensure that argument is never modified in the routine --
DEFINE SUBROUTINE SOMESUB ( ARG.IN )
ARG=ARG.IN ;* the only place IARG is ever used
...
ARG="SomethingElse"
...
END

Note that this also applies to functions and routines called via SUBR()
and once the variable is changed it is changed for the lifetime of the
current session not just for the current program.

Gerry



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey
Butera
Sent: June 17, 2010 02:04 PM
To: U2 Users List
Subject: [U2] @LOGNAME on Unidata

We recently migrated from Unidata 7.1.8 on Solaris to Unidata 7.2.5 on 
RedHat.

We make use of @LOGNAME quite a bit to determine a person's username.  
Since our migration, however, we've documented some cases where @LOGNAME

is not returning the proper username - it returns someone else's.
What's bizarre is that most of the time it's right, but occasionally 
it's not.

Has anyone seen or heard of this?

When we had a report of this (with documentation) I thought it was 
weird.  Today we just got a call about a different problem which I'm 99%

sure is tied to this since it makes use of @LOGNAME.  Like the above, 
sometimes it's correct, sometime it's wrong.

-- 
Jeff Butera, Ph.D.
Manager of ERP Systems
Hampshire College
jbut...@hampshire.edu
413-559-5556

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


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

Re: [U2] UV Memory issues

[JPB-U2UG]

Do you have or have you added any other applications running on the same 
server or is it dedicated to UV? I have seen where having another 
application running on the same server will conflict with UV.


--
From: "u2ug" 
Sent: Tuesday, June 08, 2010 10:31 AM
To: "U2 Users List" 
Subject: [U2]  UV Memory issues


We started running into a situation recently where a box running
universe 10.2.11 on hpux 11.31 started to have severe performance
problems, zero response, processes that normally take seconds to run
taking hours etc.

In Top we could see that the reported free memory was averaging about
28M at times dropping to less than 5M and that the vhand process was
chewing up a most of the cpu.  With the free memory that low, vhand
hogging the system makes sense.  Why the memory is that low is the
question.

The machine has 4G of memory, right after reboot before anyone but me
gets on the system top shows us at 3G free.  If we just let the system
sit, free memory will sit happily at 3G.  As soon as we start using
universe, the free memory starts to fall.   Logging out all universe
processes and even bringing universe down has no effect on free memory -
I would have expected the memory to be freed up once the universe
processes and in particular universe itself was terminated but that's
not what we are seeing.

We were in the process of setting up a new box physically the same as
the old box but running uv  10.3.6 on hpux 11.3.1. So I am looking at
this problem now on that box in isolation.  We were hoping that this
would turn out to be a hardware issue but we are seeing the same problem
on this new box as well.

This is out of my realm of experience and I am stumped as to where to go
next.  I have the system guy checking with hp , my guess is they are
going to point the finger at uv. I am going to check with our var - I'm
not overly optimistic there either.

Any suggestions ?
- Hpux/uv tunables we should be looking at
- can we tell universe to restrict the amount of physical memory
that it uses ?
- Or maybe this is a garbage collection issue ?
- universe or hpux being overly aggressive about caching
- any hpux utilities that we can use to see exactly where the memory is
being used ?
-  ?


Gerry




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl
Sent: June 8, 2010 09:41 AM
To: 'U2 Users List'
Subject: [U2] [Unidata-Windows] Can login, but not execute any command

Upfront: The problem was solved by re-installing UniData

My client had UniData 7.2.3 on Windows within his domain. He rebooted
all
servers within his company over the weekend. Yesterday UniData suddenly
didn't work anymore. I could log in to the database, but any command,
whether Write, Select or catalogued subroutine would stop dead in its
track.
There was no error message, no indication what could have gone wrong.
UniObjects had no time-out, the application hung for hours.

I telneted into the database and many users got the unknown user error,
I
just found one user that allowed me to log in. I ran a few commands and
that
worked.

My hunch is that a Windows update changed NT-Authentication and UniData
didn't like it. Poking through the logs, I see in the Windows security
log
two entries for every UniData login, one success and one failure:
The first a success audit:
A trusted logon process has registered with the Local Security
Authority.
This logon process will be trusted to submit logon requests.
Logon Process Name: \udapi_server.exe

Then a failure audit:
The logon to account: HHC-Unidata
by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
from workstation: HORIZONSERV4
failed. The error code was: 3221225572

The error code means: 32212255720The specified user does not exist.

This behavior started already last year, and even now that everything
works
again.

Does anyone have ideas or similar experiences?


Martin Scholl
18910 New Hampshire Ave
Brinklow, MD 20862
Phone: 301-924-5537
Cell: 301-613-9572
martin.sch...@hipaasuite.com
www.HIPAAsuite.com


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


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


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

[U2] UV Memory issues

[u2ug]

We started running into a situation recently where a box running
universe 10.2.11 on hpux 11.31 started to have severe performance
problems, zero response, processes that normally take seconds to run
taking hours etc.

In Top we could see that the reported free memory was averaging about
28M at times dropping to less than 5M and that the vhand process was
chewing up a most of the cpu.  With the free memory that low, vhand
hogging the system makes sense.  Why the memory is that low is the
question.

The machine has 4G of memory, right after reboot before anyone but me
gets on the system top shows us at 3G free.  If we just let the system
sit, free memory will sit happily at 3G.  As soon as we start using
universe, the free memory starts to fall.   Logging out all universe
processes and even bringing universe down has no effect on free memory -
I would have expected the memory to be freed up once the universe
processes and in particular universe itself was terminated but that's
not what we are seeing.

We were in the process of setting up a new box physically the same as
the old box but running uv  10.3.6 on hpux 11.3.1. So I am looking at
this problem now on that box in isolation.  We were hoping that this
would turn out to be a hardware issue but we are seeing the same problem
on this new box as well.

This is out of my realm of experience and I am stumped as to where to go
next.  I have the system guy checking with hp , my guess is they are
going to point the finger at uv. I am going to check with our var - I'm
not overly optimistic there either.

Any suggestions ?
 - Hpux/uv tunables we should be looking at 
- can we tell universe to restrict the amount of physical memory
that it uses ?
- Or maybe this is a garbage collection issue ?
- universe or hpux being overly aggressive about caching
 - any hpux utilities that we can use to see exactly where the memory is
being used ?
 -  ?


Gerry




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl
Sent: June 8, 2010 09:41 AM
To: 'U2 Users List'
Subject: [U2] [Unidata-Windows] Can login, but not execute any command

Upfront: The problem was solved by re-installing UniData

My client had UniData 7.2.3 on Windows within his domain. He rebooted
all
servers within his company over the weekend. Yesterday UniData suddenly
didn't work anymore. I could log in to the database, but any command,
whether Write, Select or catalogued subroutine would stop dead in its
track.
There was no error message, no indication what could have gone wrong.
UniObjects had no time-out, the application hung for hours.

I telneted into the database and many users got the unknown user error,
I
just found one user that allowed me to log in. I ran a few commands and
that
worked.

My hunch is that a Windows update changed NT-Authentication and UniData
didn't like it. Poking through the logs, I see in the Windows security
log
two entries for every UniData login, one success and one failure:
The first a success audit:
A trusted logon process has registered with the Local Security
Authority.
This logon process will be trusted to submit logon requests. 
 Logon Process Name:\udapi_server.exe

Then a failure audit:
The logon to account: HHC-Unidata
 by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
 from workstation: HORIZONSERV4
 failed. The error code was: 3221225572

The error code means: 32212255720The specified user does not exist.

This behavior started already last year, and even now that everything
works
again. 

Does anyone have ideas or similar experiences?


Martin Scholl
18910 New Hampshire Ave
Brinklow, MD 20862
Phone: 301-924-5537
Cell: 301-613-9572
martin.sch...@hipaasuite.com
www.HIPAAsuite.com


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


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

Re: [U2] OPENSEQ and Abnormal termination of UV

[jpb-u2ug]

Let me see, can it be because you are trying to cram over 4 GB of data into
a single cell. Unlike the OPEN statement that just puts the file variable
into a variable, the OPENSEQ opens the whole file to the variable.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rajesh Menon
Sent: Monday, May 17, 2010 1:56 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] OPENSEQ and Abnormal termination of UV

Does anyone knows what is happening here:
I am trying to open a text file (over 4Gb) using OPENSEQ and storing the
file variable into a array as follows:
COMMON /MYPROG/ FILEVARS(10)
OPENSEQ "/tmp/file.txt" to FILEVARS(1) ELSE ...
This operation results abnormal termination with fault type error 11. Fault
occurred at address 1c (which is the OPENSEQ command.). If the file size is
less than 2147483647 bytes (2Gb), it works.

Opening the same file using a scalar file variable always work irrespective
of the file size.
OPENSEQ "/tmp/file.txt" TO FV.FILE ELSE ...

Any reason why the first method failing for +2Gb files? Any workarounds?

Universe: 10.2.7
AIX:  5.3

Thanks
Rajesh Menon

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

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

[U2] UV on Windows

[jpb-u2ug]

Anybody know what permissions a person needs to use all of the UniAdmin
options on a Windows server running UniVerse. Right now I can bring up the
UniAdmin when I rdp to the system but I can't see any of the users except
myself. I can't kill a user because they don't show up on the users window.
Same thing with the locks. I try to clean the licenses but that doesn't seem
to do anything. I need to know what I need so I can tell the network
administrator what he has to do.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

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

Re: [U2] Looking for a Job.....

[jpb-u2ug]

You do realize that you have more of a chance of finding a job in India than
you do here, right. Most of the jobs here have been outsourced to your
country or China.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
Sent: Monday, April 12, 2010 10:58 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Looking for a Job.

Hi everyone,

 

I have around 9yrs of experience on Unidata, Pick Basic, Unibasic, Redback
and other technologies like ASP.Net, C# and XML.

I am currently leading a offshore team in India and now looking for a
change. I am looking a job near Dallas, Texas.

 

 

Thanks

Jaweed

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

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

Re: [U2] import data to excel sheet...

[jpb-u2ug]

This is a function of the operating system. On Unix systems only a linefeed
character is added to the end of a line whereas on Windows both carriage
return and linefeed characters are added to the end of a line. If you open a
file created on a Unix system with the notepad app it will have one line
with strange characters in it. A quick fix, if you open the same file with
word pad it will be converted and you can save it. If you created a file on
a Unix system for use on a Windows system you have to add a carriage return
character to the end of the line.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Monday, April 12, 2010 11:01 AM
To: U2 Users List
Subject: Re: [U2] import data to excel sheet...

Hi Jaweed,

I haven't looked too closely at your code, but I did notice on thing that I
would consider the most likely candidate:

CHAR(13) is a carriage return, not a line feed.  Try using CHAR(10) instead
for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I
think CHAR(10) should do it.

Good luck!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
Sent: Monday, April 12, 2010 7:53 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] import data to excel sheet...

Can anyone tell me what is wrong with the following code for importing data
from txt file to an excel sheet, when its launch

Excel it giving some error message, but when I open the downloaded file from
my disc, all the data is in one line with some especial

Chars. Any help will be appreciated.



034: **

035: * OPEN FILES *

036: **

037:   ERRMSG = ''

038:   OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE

039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!'

040:   END

041:   IF ERRMSG THEN

042: GOSUB 91000

043: RETURN

044:   END

*--: P

045: **

046: * INITIALIZE *

047: **

048:   PAGE.FEED = CHAR(12)

049:   LINE.FEED = CHAR(13)

050:   ;*

051:   ;* Read the text file to convert

052:   ;*

053:   READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE

054: ERRMSG = "ITEM " : TEXT.REC.NAME : " DOES NOT EXIST IN " :
TEXT.FILE.NA

ME

055: GOSUB 91000

056: RETURN

057:   END

058:   ;*

059:   ;* Set default values (none are used now)

060:   ;*

061:   VALUE = "DEFAULT"

062:   LOCATE "PROPERTY" IN FORMATSTR<1> SETTING PTR THEN

063: VALUE = FORMATSTR<2,PTR>

064:   END

065:   ;*

066:   ;* Remove the first line if it contains a PAGE.FEED

*--: P

067:   ;*

068:   LOOP WHILE TEXT.REC<1> = PAGE.FEED DO

069:  TEXT.REC = DELETE(TEXT.REC,1)

070:   REPEAT

071:   IF TEXT.REC<1>[1,1] = PAGE.FEED THEN

072:  TEXT.REC<1> = TEXT.REC<1>[2,LEN(TEXT.REC)]

073:   END

074:   ;*

075:   ;* Find the header for each page

076:   ;*

077:   SLK.REC = ''

078:   SLK.ROWS = 0

079:   SLK.HEADER.LINES = 0

080:   IF TEXT.REC<1>[1,10] = "RUN D - T:" THEN

081: SLK.REC<-1> = "F;SD;R3"

082: SLK.REC<-1> = "F;SD;R4"

083: SLK.REC<-1> = "C;Y1;X1;K" :
QUOTE(TRIM(CHANGE(TEXT.REC<1>[1,30],';',';;

')))

084: SLK.REC<-1> = "C;Y2;X1;K" :
QUOTE(TRIM(CHANGE(TEXT.REC<2>[1,30],';',';;

')))

085: SLK.REC<-1> = "C;Y3;X1;K" :
QUOTE(TRIM(CHANGE(TEXT.REC<1>[31,90],';',';

;')))

086: SLK.REC<-1> = "C;Y4;X1;K" :
QUOTE(TRIM(CHANGE(TEXT.REC<2>[31,90],';',';

;')))

087: SLK.ROWS = 4

088: SLK.HEADER.LINES = 2

*--: P

089:   END

090:   ;*

091:   ;* Find the number of lines in the header

092:   ;*

093:   LINES = DCOUNT(TEXT.REC,@AM)

094:   SLK.HEADER.CNT = 0

095:   FOR IDX = SLK.HEADER.LINES+1 TO LINES

096: IF INDEX(TEXT.REC,"---",1) THEN

097:   SLK.HEADER.CNT = IDX

098:   EXIT

099: END

100:   NEXT IDX

101:   ;*

102:   ;* Find the column locations

103:   ;*

104:   COL.LIST  = ''

105:   IF SLK.HEADER.CNT THEN

106: DASHES.LINE = " " : TEXT.REC : " "

107: DASHES.LINE = TRIM(DASHES.LINE,'-')

108: DASHES.CNT  = COUNT(DASHES.LINE,'-')

109: DASHES.LINE = TEXT.REC

110: FOR DASHES.IDX = 1 TO DASHES.CNT

*--: P

111:   COL.START = INDEX(DASHES.LINE,'-',1)

112:   DASHES.REMAIN = LEN(DASHES.LINE) - COL.START + 1

113:   COL.LEN   = INDEX(DASHES.LINE[DASHES.REMAIN],' ',1)-1

114:   IF COL.LEN < 1 THEN COL.LEN = LEN(DASHES.LINE)

115:   COL.LIST = COL.START

116:   COL.LIST = COL.LEN

117:   DASHES.LINE[COL.START,COL.LEN] = SPACE(COL.LEN)

118: NEXT DASHES.IDX

119:   END

120:   ;*

121:   ;* Extract the column titles

122:   ;*

123:   COL.CNT = DCOUNT(COL.LIST,@AM)

124:   FOR HDR.IDX = SLK.HEADER.LINES+1 TO SLK.HEADER.CNT-1

125: SLK.ROWS = SLK.ROWS + 1

126: SLK.Y = "Y" : SLK.ROWS : ";"

127: ;*

128: ;* Make sure the header properly fits into the column

129: ;* If it does not, then add it to the spreadsheet's first column

130: ;*

131: CHEC

Re: [U2] Regex searching UD files

[jpb-u2ug]

I'm on UV and  from the Unix command line I can do the following:

cd /usr/ibm/uv
uv port.status | grep j_banker

It will list every line with my login.


Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Monday, March 29, 2010 4:13 PM
To: U2 Users List
Subject: Re: [U2] Regex searching UD files

Not even close... We run in ECLTYPE P and don't have access to EVAL and
the like.

"^[Cc][Hh][Qq].*[5-8][0-9][0-9][0-9]x"

Unless you can explain how to duplicate the above search with ESEARCH?

@Stuart, that would be ideal, but unfortunately I can't go dumping out
multi-gigabyte files. :(



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Tuesday, 30 March 2010 5:22 AM
To: U2 Users List
Subject: Re: [U2] Regex searching UD files

Does UniData ECL ESEARCH command not fill the bill already?

Wally Terhune
U2 Support Architect
Rocket Software
4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA
Tel: +1.720.475.8055
Email: wterh...@rs.com
Web: www.rocketsoftware.com/u2

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell,
Stuart
Sent: Monday, March 29, 2010 12:22 AM
To: U2 Users List
Subject: Re: [U2] Regex searching UD files

I think this should be one for Rocket to implement a RegexSearch in U2. 
However, if it's size non-impactive, what I would normally do is copy
the file to a temporary directory then run grep across that.

Stuart Boydell 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Monday, 29 March 2010 17:08
To: U2 Users List
Subject: [U2] Regex searching UD files

I've written a small utility to be able to run egrep on a UD file (not
UD directory), however its implementation is not ideal.

 

Essentially, I select the file I'm searching, writing each record one at
a time to a temp UNIX file and running egrep on it as follows

 

!egrep -q -f MyTempRegexFile MyTempRecordFile ; echo $?

 

Where MyTempRegexFile is a file containing the desired regex pattern
stored earlier and MyTempRecordFile is a file name unique to each user.

 

My problem with it is that I have to do a READ on each record, followed
by a WRITE then have egrep read it in as well. That's a lot of seemingly
unneeded disk IO if I could only stream the record to egrep without have
to do a WRITE after the READ.

 

Any ideas? I feel I'm missing something quite obvious.

 

Regards,

Dan



###
The information transmitted in this message and attachments (if any) is
intended only
for the person or entity to which it is addressed. The message may
contain confidential
and/or privileged material.  Any review, retransmission, dissemination
or other use of
or taking of any action in reliance upon this information by persons or
entities other
than the intended recipient is prohibited.  If you received this in
error, please
contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose
or distribute
the information contained in this e-mail and any attached files with the
permission of IMB.

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

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

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

###
The information transmitted in this message and attachments (if any) is
intended only
for the person or entity to which it is addressed. The message may contain
confidential
and/or privileged material.  Any review, retransmission, dissemination or
other use of
or taking of any action in reliance upon this information by persons or
entities other
than the intended recipient is prohibited.  If you received this in error,
please
contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or
distribute
the information containe

Re: [U2] Pick on Mac

[jpb-u2ug]

I think I saw someone on this list that was using one of the U2 products on
Mac OSX or on the Windows virtual emulator. Could be wrong.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com
Sent: Monday, March 29, 2010 2:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Pick on Mac

Are there are native implementations of a Pick system on Macs?  Or are all 
Mac connections just terminal emulators into a Windows/Unix system?

I know there is or used to be an emulator by Carnation that rode on a Mac.  
But have all such implementations been to have it talk with a Pick system 
living on a Windows or Unix box?

Does Universe have any sites where users are connecting using Macs as their 
PC?

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

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

[U2] Microsoft SQL Server Driver Support

[jpb-u2ug]

The U2 team at Rocket Software announces a renewed focus on improving SQL
interfaces to the UniData and UniVerse data servers.


Microsoft SQL Server Driver Support


Starting with the November release of UniData on Windows, the Rocket U2 team
will deliver and support the Microsoft SQL Server driver for External
Database Access (EDA) on Windows platforms. The same driver is available now
in the Early Adopter release of UniVerse 11.

To obtain the SQL Server driver for EDA, contact u2as...@rs.com. Please tell
us what database you're using when you do so. External Database Access (EDA)
is required in order to use the SQL Server Driver. EDA is available for
Workgroup and Server edition and is included with Enterprise edition of the
databases.


Common Mapping Tool and Schema Generator


In addition, we are in the early planning stages for an improved, common
mapping tool and schema generator for fully describing the U2 data model in
order to generate SQL and EDA schemas. This new tool will provide a modern,
extensible interface for both initial mapping as well as updating of
schemas. This tool, with its associated APIs, will improve deployment of ISV
solutions to end customer sites thereby saving time and speeding time to
market.

This tool will be available with UniVerse 11.1 and in a UniData 7.3 release
to follow.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

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

Re: [U2] UniObjects 'Exec'

[u2ug]

I did some playing around with this and was surprised at what I found.

First I would have assumed that any error messages would have been returned as 
part of the command.Response
But they aren't.

So I tried setting up a simple program to execute a command line, capture the 
output and CRT it.
crt 'start'
get(ARG.) xqt else return
crt 'before'
execute xqt,OUT>rslt,STATUS>st
crt 'after'
crt '[':rslt:'][':st:']'
crt 'done'

This works fine as long as there is no error in the EXECUTED command.
LIST VOC WITH @ID LIKE 'A...' SAMPLE 1
Console output :
start
before
after
[þ1 record(s) selected to SELECT list #0.þ][1]
done
UO command.Response contains:
start
before
after
[þ1 record(s) selected to SELECT list #0.þ][1]
done
however with an error 
LIST VOC WITH BadField LIKE 'A...' SAMPLE 1
Console output :
start
before
after
[Retrieve syntax error.  Unexpected explicit item.  Token was 
'BadField'.þ   Scanned command was LIST VOC WITH 'BadField' þ3][-1]
done
UO command.Response contains:
start
before
after
[][-1]
Done

So it seems that any error messages are eaten - the really bad thing about this 
is that if you have a program that handles this type of error - it won't work 
because it will never see the error and that's pretty BOGUS !!!


 Gerry




-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton 
Sent: February 19, 2010 09:49 AM
To: 'U2 Users List'
Subject: [U2] UniObjects 'Exec'


We are using a product and just found out that one of the reasons we're
having some difficulties on an installation was that one of my dictionaries
was not defined at a new site.  This caused a 'Exec' of a "SELECT" to fail,
but here's the kicker -- in BASIC, we could have 'seen' the error with
CAPTURING and RETURNING -- but I'm told the interface to UniObjects does not
return this diagnostic information on the 'Exec'...

So in BASIC, I would have

EXECUTE 'SELECT FILENAME WITH DICTITEM = "A"' CAPTURING THIS RETURNING THAT

And I could 'query' what is in THIS and THAT to decide if there is a problem
if the "DICTITEM" didn't exist for some reason.

I'm told that the product we're using cannot do this same thing -- there is
no way to 'know' the message 'select criteria DICTITEM is not a field' was
returned from the 'Exec' as we could have seen in the BASIC EXECUTE.

Is there no way to get back this same REALLY valuable feedback in
UniObjects?  How do you code for this issue in UO?

This would not be big deal if we had source code or a 'log' of what was
happening -- we just had a screen that didn't come up, and with dozens of
fields, it's not obvious what the issue was -- until we found it!  But the
failure of the 'SELECT' command causes the 4GL based on UO to just 'die' I
don't want to be stung another time with this, and am never afraid to ask
for thoughts or ideas!!  If there is a way to handle this, I want to find it
and get the idea into their head so I never have a 'lost day' trying to hunt
down this kind of issue...

TIA!! 
David Wolverton



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


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

Re: [U2] UniData ICONV function

[u2ug]

Changing "DIMDY" to "D-MDY" will do what you want in universe regardless
of any system settings.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: February 10, 2010 02:05 PM
To: U2 Mail List
Subject: Re: [U2] UniData ICONV function


> The problem I'm having is people with different XP date settings (U.S.

> & International) access one of the programs in our application.  This 
> program prints an "amortization" schedule.  Our code parses the day, 
> month, and year via...
>DUEMO  = OCONV(BEGDATE , 'DM')
>DUEDAY = OCONV(BEGDATE , 'DD')
>DUEYR  = OCONV(BEGDATE , 'DY')
>   
> ...then the information is converted to an internal PICK date via...
>DUEDATE = ICONV(DUEMO:'-':DUEDAY:'-':DUEYR, 'DI')
>
>   
> Once this is done the date is printed along with the various loan 
> payment information.  The month is incremented (and year when 
> necessary) then the process repeats.
>
> We notice when an international date configured XP machine accesses 
> our code via UniObjects (DesignBais), we think DATE.FORMAT is adjusted

> and our code fails.  Instead of getting Feb 1st, we get Jan 2nd.  
> Instead of getting Mar 1st we get Jan 3rd.  etc.  We noticed if we 
> implement this ICONV code all is well.
>
>DUEDATE = ICONV(DUEMO:'-':DUEDAY:'-':DUEYR, 'DIMDY')
>
> We were curious if this is standard and whether it works in UniVerse?
>
> Thanks,
>
> Bill
>
>

> Ron Hutchings said the following on 2/10/2010 5:50 AM:
>> It didn't work for me with your conversion code but when I changed it
to 'D' it worked just fine.  Internal conversions don't need all the
fancy output codes.
>>
>>   
>>> Date: Tue, 9 Feb 2010 22:14:40 -0800
>>> From: iako...@gmail.com
>>> To: u2-users@listserver.u2ug.org
>>> Subject: Re: [U2] UniData ICONV function
>>>
>>>
>>> Hi Bill,
>>>
>>> What version of UD are you running?
>>>
>>> We had serious problems with date conversion using ICONV in version
10.2.7
>>> of Universe.
>>>
>>> However this problem of yours looks like a DATE.FORMAT problem
>>> Its looking at the month and thinks its a date and looking at the
date and
>>> thinks its a month.
>>>
>>> change your date format (ON / OFF) depending on which part of the
world
>>> you're in.
>>>
>>> jack
>>>
>>> Bill Haskett wrote:
>>> 
 The following works in UniData:

 DD = '01'
 DM = '02'
 DY = '2010
 CRT ICONV(DM:'-':DD:'-':DY, 'DIMDY')

 ...returns '15343'.

 Does this work in UniVerse?

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


   
>>> -- 
>>> View this message in context:
http://old.nabble.com/UniData-ICONV-function-tp27526458p27526610.html
>>> Sent from the U2 - Users mailing list archive at Nabble.com.
>>>
>>> ___
>>> U2-Users mailing list
>>> U2-Users@listserver.u2ug.org
>>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>> 
>>
>> _
>> Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
>> http://clk.atdmt.com/GBL/go/201469229/direct/01/
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>   
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

[U2] Spooler for Windows

[jpb-u2ug]

What products are out there that mimic the Unix UniVerse spooler in a
Windows environment? From what I can see on Windows, UniVerse uses the
Windows printer subsystem and in my estimation that was a mistake. There's
no retention of print jobs, no form type, no ability to use scripts, it is
the biggest stumbling block for conversion from a 'nix environment. I would
only like to look at packages that are built to work with UniVerse and are
like the Unix spooler with all the bells and whistles. We have moved from
Unix V5, to Solaris, to RH Linux, and our spooler scripts only needed minor
changes long the way. Now we are trying to go to Windows and the only
stumbling block the we have encountered is the spooler. We did so much with
it.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

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

Re: [U2] extraction conversion codes

[u2ug]

I don't see this as misleading if anything it makes a simple list of a
dictionary much more obvious as all D types for the same location are
listed together as opposed to having to SEARCH the DICT for references
hidden in I types. I can't speak to A or S types as I've never used
them.

But to the point, the preference for D over I was performance, I-types
take roughly 3.5x longer to execute that the corresponding D-type.
On an older/slower box churning through very large amounts of data this
can have an impact.

I reran the timings since the original post on our current machines (
this process has been around for a few hardware/software generations )
and the 3.5x still holds but the overall impact has decreased to the
point where this issue is pretty much moot.

Gerry




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: February 8, 2010 05:59 PM
To: 'U2 Users List'
Subject: Re: [U2] extraction conversion codes

I wonder the same thing. All he's doing is converting a D type to a
correlative and in that case I would much rather have it an A or S type
so
you don't have to be misled by the type and not looking for the special
coding in field 3.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin
Phillips
Sent: Friday, February 05, 2010 1:33 PM
To: U2 Users List
Subject: Re: [U2] extraction conversion codes

Hi Gerry,

Out of curiosity, why are you against I-types?


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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


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

Re: [U2] extraction conversion codes

[jpb-u2ug]

I wonder the same thing. All he's doing is converting a D type to a
correlative and in that case I would much rather have it an A or S type so
you don't have to be misled by the type and not looking for the special
coding in field 3.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Friday, February 05, 2010 1:33 PM
To: U2 Users List
Subject: Re: [U2] extraction conversion codes

Hi Gerry,

Out of curiosity, why are you against I-types?


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[U2] extraction conversion codes

[u2ug]

Sorry - I forgot to change the subject - didn't mean to hijack the other
thread.


We have a process that works strictly with I & D type dictionary items.
The fewer I-types we have the better.

One scenario where we can drop I-types in favour of D-Types is :

DATA.VALUE
D multi part '*' delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE["*",1,1]
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE["*",2,1]
MTS
...

This can be cooked down to :

DATA.DATE
D
2
G0*1|D4-YMD
...

DATA.TIME
D
2
G1*1|MTS
...


This works perfectly as long as the delimiter is not a system delimiter
( FM , VM , SVM , TM )
If we have :

DATA.VALUE
D multi value @VM delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE<1,1>
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE<1,2>
MTS
...

I don't see any way to drop the I-types because I don't see any
conversion codes that cam extract using system delimiters.

Am I missing something or are we just stuck with the I-types in these
cases ?

Gerry

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


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

Re: [U2] Resize Question

[u2ug]

We have a process that works strictly with I & D type dictionary items.
The fewer I-types we have the better.

One scenario where we can drop I-types in favour of D-Types is :

DATA.VALUE
D multi part '*' delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE["*",1,1]
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE["*",2,1]
MTS
...

This can be cooked down to :

DATA.DATE
D
2
G0*1|D4-YMD
...

DATA.TIME
D
2
G1*1|MTS
...


This works perfectly as long as the delimiter is not a system delimiter
( FM , VM , SVM , TM )
If we have :

DATA.VALUE
D multi value @VM delimited : date / time
2
...

DATA.VALUE.DATE
I
DATA.VALUE<1,1>
D4-YMD
...

DATE.VALUE.TIME
I
DATA.VALUE<1,2>
MTS
...

I don't see any way to drop the I-types because I don't see any
conversion codes that cam extract using system delimiters.

Am I missing something or are we just stuck with the I-types in these
cases ?

Gerry

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

Re: [U2] Resize Question

[jpb-u2ug]

If you are starting out with trying to use SQL on a legacy database your
best bet would be to create a separate account just for SQL. In the new
account put in pointers to the main data files you will be using and create
dictionaries to the files locally. In this way you can build the
dictionaries to be SQL compliant and only have the fields that you will be
using for your SQL apps. It's a little more work to set up but will save
loads of time later. If you have files with the same data (current and
history files) you can use the same dictionaries so that can cut down on the
number of dictionaries used.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, February 03, 2010 2:57 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Hi Andrew

Because UniVerse dictionaries contain not only solid column definitions, but
also synonyms and virtual fields, you have to choose which of these will be
exposed for ODBC or similar relational protocols. A typical dictionary for a
mature system might have a thousand entries which makes navigating these in
something like MS query or the .NET data set designer very difficult!

So for this you need to do two things:

First, create a phrase named @SELECT. This is a dictionary entry in the
format:

Key: @SELECT
1: PH
2: list of fields SPACE delimited.

You can test this out by doing a SELECT * from file at TCL, which uses the
same phrase.

Then, you need to update the file information cache used by ODBC (prevents
it having to scan every dictionary on connect). For this, run the
HS.UPDATE.FILEINFO command after making your changes.

However, you might also want to step back and consider whether ODBC is
really your best choice. To use ODBC effectively you need to understand
about dynamic normalizing and the differences between the UniVerse data
model and the relational model expected by ODBC. Depending on what you wish
to do, ODBC may tie you up in knots and you may be better off looking at one
of the native protocols (the UniObjects family) or web services instead.

Also, I don't know why you chose to copy your VOC across. That will contain
pointers to all the files from the original system, which you don't have on
yours,  hence the large number of errors you are seeing. If you are brave,
you can try a CLEAN.ACCOUNT command, but take a backup first!

[AD]
You might want to consider my latest book, 'IBM UniVerse Client Developer'
(written when this was still an IBM product) which covers the various
protocols in depth. You can find details on my website,
www.brianleach.co.uk.
[/AD]

Regards

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E.
Tegenkamp
Sent: 02 February 2010 4:17 PM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Thank you very much! That has helped a lot and I can now see the data in the
UV command line :)

If possible, I am now hoping to be able to expose this imported data to ODBC
so I can work with it in PHP, etc. But I am again finding problems I cannot
find an answer for in the help docs or searching the list archive.

First, I created a PICK account using the U2UG guide mentioned. I then used
HS.ADMIN option 3 to "Activate access to files in an account" which went
well and showed it as an activated account.  

I copied over the TEMP and VOC (D_VOC, D_VOCLIB, VOC, VOCLIB, etc) files
from the live UniVerse server to my account as well as my test table ZIP
(ZIP and D_ZIP). I fnuxi'd and SET.INDEX'd them and could see the data on
the command line using SELECT COUNT(*) FROM ZIP and the like.

However, when I went to ODBC I could only see 3 tables. AE_DOC, HELP_FILE,
and HS_FILE_ACCESS (ODBC reported no rows in HS_FILE_ACCESS). I ran HS.ADMIN
option 3 again on the account and for most things it said:

Could not open file FILENAME.  STATUS() = -2
  "FILENAME" was not written into File Information Cache.

For the file I copied over, ZIP, it said: 

ZIP's dictionary has no @ phrase or @SELECT phrase.
  "ZIP" was written into File Information Cache but
  may not behave as desired.

This is a little confusing as I thought D_ZIP was the dictionary file and
SELECT works on the command line. After this, I checked ODBC and saw the 3
above and one more table called UVMD. I am not sure what this was so I got
it but it appears to be a system table of some sort.


Thanks again for any tips on how to properly setup/expose this file/table to
ODBC!
Andrew





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, February 01, 2010 11:55 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question

Okay, a few things her

Re: [U2] UniVerse RetreiVe how do I query a file for all of its column’s values?

[u2ug]

No column names but what about LIST.ITEM ?





-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Evan Carroll
Sent: January 20, 2010 07:05 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse RetreiVe how do I query a file for all of its column’s 
values?

This is a repost from a stackoverflow question I asked:
http://stackoverflow.com/questions/2068026/universe-retreive-how-do-i-query-a-file-for-all-of-its-columns-values


=== START REPOST ===
In UniVerse you can't query a file for all of its columns unless the @
phrase in your file's dictionary is set to all of the tables columns.
If it isn't how do you query a table for all of its column's values?
So I can get the total column listing (column name & display name)
using:

LIST DICT file NAME

This will return a listing of all columns and their display names. How
do I then query the table for all of the columns it has?

LIST file

Will only query it for LIST file @id (@id is the only thing in @).

=== END REPOST ===

I'd like to follow up with a request to see if anyone has a copy of a
BASIC program that does this, I imagine it is something every heavy
universe must keep in arms reach.

Thanks a ton,

-- 
Evan Carroll
System Lord of the Internets
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

[U2] Sharing files

[jpb-u2ug]

I am very familiar with how to do things on Unix/Linux systems but my
knowledge of the MS Windows Server environment is substantially lacking. So
I am wondering if the group can give me some pointers. I have a folder on a
RH Linux system that I would like to share on a Windows 2K8 server running
UV 10.2. The share has been set up using Samba on the RH Linux as3 server
and from a desktop or an RDP session to the Windows server I can map the
share and us it. But, I would like to use the share from within our main UV
account for multiple telnet sessions. On 'nix all I had to do was mount the
folder from another system, put a pointer to it in the VOC, and I was up and
running. From UV Windows I am at a loss to know where the mount is. I have
tried to use a UNC path in the VOC pointer but it doesn't seem to work or
possibly I didn't create it properly (\\IPaddress\smbshare\file
 ). They are on two different subnets.
Can anyone enlighten me on how they are doing it?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

[jpb-u2ug]

Is 5.2 still supported? That may convince them that it is time to upgrade. I
can't seem to find an availability matrix on Rocket's site.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann
Sent: Wednesday, January 13, 2010 10:25 AM
To: U2 Users List
Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

Thanks Bill,

I don't think it is an ODBC problem since SSIS connection managers unlike
DTS don't use ODBC. They use OLEDB and connect even without the IBM U2 ODBC
driver installed. 
I maybe have to add that both SQL Server 2000 and 2008 run under Windows
2003, so I don't think this is an OS issue either.

If anybody has any suggestions how to use UniObjects with SSIS I would give
that a try immediately.

Easiest would of course be to upgrade to UD 7.2 but unfortunately I haven't
been able to convince management to approve that.

Mecki
 Original-Nachricht 
> Datum: Wed, 13 Jan 2010 10:36:27 -0500
> Von: "Brutzman, Bill" 
> An: "U2 Users List" 
> Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

> 
> This problem resembles my recent problem with ODBC between HP-Ux and
> MS-SQL.  Tech Support at Rocket indicated that I would probably have to
> buy special (ODBC) drivers from companies that specialize in data
> integration because... ODBC is a Microsoft thing and this sort of
> connectivity is not bundled with most (maybe any) flavors of Unix.
> 
> Rocket agreed that using UniObjects would be an easier alternative.
> 
> --Bill
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki
> Foerthmann
> Sent: Wednesday, January 13, 2010 7:39 AM
> To: U2 Users List
> Subject: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS
> 
> Hi
> 
> I am trying to use SSIS to load UniData tables to SQL Server 2008.
> I already have been using DTS with SQL Server 2000 successfully for a
> while and I set up everything (System DSN and UCI Editor) the same on
> the 2008 server.
> The connection test works fine, but when I try to go further I get this
> error message.
> 
> > Cannot get string literals from the database connection 
> > "Provider=Informix.UniOLEDB.1;Password=;Persist Security 
> > Info=True;User ID=admin;Data 
> > Source=LIVE_DATA;Location=LIVE_DATA;Mode=Read"
> We are running Unidata 5.2 on Solaris. And I am using UniDK for that
> release on both SQL Server boxes.
> I had tried using a later version of UniDK before, but that didn't seem
> to want to connect to the older version of UD at all.
> 
> Any ideas?
> 
> Thanks
> 
> Mecki
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

Re: [U2] An interesting find....

[JPB-U2UG]

Instead of CASE -1 use CASE 1

--
From: "George Gallen" 
Sent: Tuesday, December 15, 2009 1:23 PM
To: "U2 Users List" 
Subject: [U2] An interesting find


Here is an interesting tidbit I happened to run across.

PROGRAM A:

OPEN "","FILE1" TO F.FILE1 ELSE STOP "NO FILE1"
OPEN "","FILE2" TO F.FILE2 ELSE STOP "NO FILE2"
* F.FILETOUSE = F.FILE1  (Adding this here will get rid of the compile 
warning)

BEGIN CASE
   CASE X=1  F.FILETOUSE = F.FILE1
   CASE X=2 F.FILETOUSE = F.FILE2
   CASE -1 F.FILETOUSE = F.FILE1
END CASE
READ XDATA FROM F.FILETOUSE,"TEST" ELSE XDATA=""

The above program when compiled says F.FILETOUSE never assigned a value
and when it executes, gives an improper file type error

HOWEVER:

PROGRAM B:

OPEN "","FILE1" TO F.FILE1 ELSE STOP "NO FILE1"
OPEN "","FILE2" TO F.FILE2 ELSE STOP "NO FILE2"
   F.FILETOUSE=F.FILE1
   IF X=1  THEN F.FILETOUSE = F.FILE1
   IF X=2 THEN F.FILETOUSE = F.FILE2
READ XDATA FROM F.FILETOUSE,"TEST" ELSE XDATA=""

Compiles and run just fine, no errors.

This is using UV 10.0.2 under the Prime Information flavor

George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



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


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

Re: [U2] UVPE linux setup

[u2ug]

Thanks - that did it.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: December 14, 2009 04:12 PM
To: U2 Users List
Subject: Re: [U2] UVPE linux setup

You need to configure and turn on the Unirpc daemon too:

See the Universe Administration PDF under Managing Network Services > 
Administering the UniRPC on Unix System

u2ug wrote:
> Thanks jeff - I got telnet working ok - uo.net is still a problem
>
>
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff
Schasny
> Sent: December 14, 2009 03:26 PM
> To: U2 Users List
> Subject: Re: [U2] UVPE linux setup
>
> Universe for Linux does not install its own telnet server like the 
> Windows version does. Make sure your Linux telnet daemon is running.
>
> u2ug wrote:
>   
>> I have just setup uvpe 10.3.3 on opensuse 11.1
>> Locally universe seems to be running fine.
>> However I can't access it via telnet or UO.NET either local or
remote.
>>
>> I must have missed something in the installation guide - how do we
>> configure uvpe on linux to accept connections via telnet & uo.net ?
>>
>> Gerry
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
>>   
>> 
>
>   

-- 

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

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


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

Re: [U2] UVPE linux setup

[u2ug]

Thanks - this is just for my own internal use so security isn't really a
concern - telnet will do just fine.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W.
Youngman
Sent: December 14, 2009 03:36 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UVPE linux setup

In message <47c1b98393896f41a7bfe435442394e5268...@gmsdc.gerzio.ca>, 
u2ug  writes
>I have just setup uvpe 10.3.3 on opensuse 11.1
>Locally universe seems to be running fine.
>However I can't access it via telnet or UO.NET either local or remote.
>
>I must have missed something in the installation guide - how do we
>configure uvpe on linux to accept connections via telnet & uo.net ?
>
I don't think you do!

Okay, going back to my days with PI/Open on 7330s, but you logged into 
Unix then invoked UV.

You need to set up telnetd on SuSE (it's disabled or, more likely, not 
even installed on pretty much every linux nowadays). You can then just 
log in remotely over telnet, and fire up UV either from the command line

or from .profile.

General advice nowadays would be (I've never done it myself) to fire up 
a terminal session over something rather more secure than telnet - 
something like SSH for example.

UO.net, someone else will have to guide you with, but I'd check the 
firewall rules first ...

Cheers,
Wol
-- 
Anthony W. Youngman 
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The
man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source
Pick
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] UVPE linux setup

[u2ug]

Thanks jeff - I got telnet working ok - uo.net is still a problem




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: December 14, 2009 03:26 PM
To: U2 Users List
Subject: Re: [U2] UVPE linux setup

Universe for Linux does not install its own telnet server like the 
Windows version does. Make sure your Linux telnet daemon is running.

u2ug wrote:
> I have just setup uvpe 10.3.3 on opensuse 11.1
> Locally universe seems to be running fine.
> However I can't access it via telnet or UO.NET either local or remote.
>
> I must have missed something in the installation guide - how do we
> configure uvpe on linux to accept connections via telnet & uo.net ?
>
> Gerry
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>   

-- 

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

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


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

Re: [U2] UVPE linux setup

[u2ug]

Ok - half way there - I got the telnet part working by installing telnet
& opening up the port through the firewall
I still can't connect via UO.NET though - I tried opening up port 31438
- that didn't work so I completely disabled the firewall - still no joy


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
Sent: December 14, 2009 03:03 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UVPE linux setup

I have just setup uvpe 10.3.3 on opensuse 11.1
Locally universe seems to be running fine.
However I can't access it via telnet or UO.NET either local or remote.

I must have missed something in the installation guide - how do we
configure uvpe on linux to accept connections via telnet & uo.net ?

Gerry

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


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

[U2] UVPE linux setup

[u2ug]

I have just setup uvpe 10.3.3 on opensuse 11.1
Locally universe seems to be running fine.
However I can't access it via telnet or UO.NET either local or remote.

I must have missed something in the installation guide - how do we
configure uvpe on linux to accept connections via telnet & uo.net ?

Gerry

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

Re: [U2] SELECTs on FILEs

[JPB-U2UG]

While you are on the subject I have discovered another little annoyance from 
Windows as opposed to Unix. On Unix, Linux, Solaris, et al you can do a 
select on an account and get the same results every time, however, on 
windows you may not. At least with Universe. For a simple test do a select 
on your current account:

SELECT &UFD&
Then do it a second time:
SELECT &UFD&
On 'nix systems you will get no difference, but, on windows you will get a 
list of entries that it says do not exist and the selection count is lower. 
What I have found is that on the first pass it will select all entries but 
on the second pass none of the folder type files can be found. An account is 
usually made up of a variety of file types; including segmented hash and 
types 1, 19, 25, and 30. What an annoyance when you're trying to create 
lists for backing up or moving to a test location.


--
From: "Dan McGrath" 
Sent: Sunday, December 13, 2009 6:15 PM
To: "U2 Users List" 
Subject: [U2] SELECTs on FILEs


Hi all,



Just a quick question on SELECTs for UD.



I was under the impression that performing a wildcard SELECT with @ID
would only result the key section of a FILE been read.



Eg, SELECT MYFILE WITH @ID = "prefix]"



Is this incorrect? Does it actually result in the entire FILE being read
into memory to complete this SELECT?



Regards,

Dan


###
The information transmitted in this message and attachments (if any) is 
intended only
for the person or entity to which it is addressed. The message may contain 
confidential
and/or privileged material.  Any review, retransmission, dissemination or 
other use of
or taking of any action in reliance upon this information by persons or 
entities other
than the intended recipient is prohibited.  If you received this in error, 
please

contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or 
distribute
the information contained in this e-mail and any attached files with the 
permission of IMB.

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


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

Re: [U2] Uniobjects and login paragraph

[u2ug]

Not true - phantoms execute the login paragraph - in which case you have
to have the logic in your PA to skip the menu for phantom processes.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: December 10, 2009 11:44 AM
To: 'U2 Users List'
Subject: Re: [U2] Uniobjects and login paragraph

Jerry

Anything that can't be interactive. 

If that were not the case, and you started e.g. a menu system from your
LOGIN paragraph, it would try to run that whenever you logged in through
UniObjects and you would be stuffed. 

Brian

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 10 December 2009 4:38 PM
To: 'U2 Users List'
Subject: [U2] Uniobjects and login paragraph

Did I see that someone said Uniobjects bypasses the login paragraph?
What
else bypasses the login paragraph? Is this on both 'nix and Windows? 

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.709 / Virus Database: 270.14.101/2555 - Release Date:
12/09/09
19:41:00

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


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

[U2] Uniobjects and login paragraph

[jpb-u2ug]

Did I see that someone said Uniobjects bypasses the login paragraph? What
else bypasses the login paragraph? Is this on both 'nix and Windows? 

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

[U2] Have I been booted again ?

[u2ug]

I haven't seen activity from the list in a week or so - have I been
'delisted' again or is the list just dead ?

Gerry

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

Re: [U2] UV Transaction logging

[jpb-u2ug]

Thanks Brian.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, November 30, 2009 10:25 AM
To: 'U2 Users List'
Subject: Re: [U2] UV Transaction logging

Jerry

All changes should be logged to any files that are marked for transaction
logging. You have to explicitly enable logging for individual files, with
the caveat that you can't log type 19 files.

If you don't use explicit transaction control in your code, each write will
be treated as a separate transaction and logged individually.

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 30 November 2009 4:14 PM
To: 'U2 Users List'
Subject: [U2] UV Transaction logging

If you have transaction logging turned on in UniVerse do all changes get
logged even those that don't have the code in the programs to start the
transaction and commit it?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.709 / Virus Database: 270.14.87/2535 - Release Date: 11/29/09
19:31:00

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

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

Re: [U2] Mapping files.

[jpb-u2ug]

You also have to have Allownfs set to 1 in your configuration and
permissions set on the other server so you can use the file.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Paul Parkinson
Sent: Monday, November 30, 2009 9:58 AM
To: 'U2 Users List'
Subject: Re: [U2] Mapping files.

Thanks Mas, tried that didn't work

Kind Regards
Paul Parkinson
Director, Ideal Business Services Ltd
mob: +1 758 721 4487 (Caribbean)
skype: 0161 408 2098
eml: pparkin...@idealnet.co.uk 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mats Carlid
Sent: 30 November 2009 11:46
To: U2 Users List
Subject: Re: [U2] Mapping files.


Mount  \\serverB\unidata  as disk Z say
and make the voc entry:

F
Z:filenamn
Z:D_filename


BUT  there is a real  gotcha:
Don't even think about updating that file from server A
as there's no common lock mechanism.

-- mats



Paul Parkinson skrev:
> I have 2 servers both running Unidata 7.1 on Windows 2003.  In an
> application on server "A" I want to access data held in an application on
> server "B"
>
>  
>
> I have tried the voc entry in the application on serverA
>
>  
>
> 001: F
>
> 002: \\serverB\unidata\filename  
>
> 003: \\serverB\unidata\D_filename  
>
>  
>
> I have also tried replacing "serverB" in the above with the IP address
>
>  
>
> But I get the error "open file error no such file."
>
>  
>
> Anyone know what I should be doing?
>
>  
>
> Paul Parkinson
>
>  
>
>  
>
>  
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
>
>   

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


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

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

[U2] UV Transaction logging

[jpb-u2ug]

If you have transaction logging turned on in UniVerse do all changes get
logged even those that don't have the code in the programs to start the
transaction and commit it?

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

 

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

Re: [U2] Code Coverage Project

[jpb-u2ug]

It won't be used by programmers but would by QC/QA types to check and see if
the code is being used or is just a bunch of fluff. One good example would
be if your company is using outsourcing to do your programming and the
outsource is getting paid on the amount of code they produce, instead of the
correct way of getting paid on the quality of their code. You can check to
see if all paths through the code are being used or not.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
Sent: Friday, November 27, 2009 10:47 AM
To: 'U2 Users List'
Subject: Re: [U2] Code Coverage Project

Dan,

Although I missed code coverage in programming school, I'm not sure how much
UniBasic
programmers would or could use code coverage. That being said, why not take
an existing
program that is fully developed and change the syntax to handle basic
syntax.  This way
you do not have to develop the entire infastracture to run this tool.

My suggestion is there are several open source plug-in for Eclipse that can
be modified
to handle code coverage.  There are several examples like jcoverage or gcov
that could
be used for this type of project.

Regards,
Doug
www.u2logic.com
"Native U2 drivers for PHP"



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Thursday, November 26, 2009 2:35 PM
To: U2 Users List
Subject: [U2] Code Coverage Project

Hi all,

 

For those that are interested, I have setup a project on SourceForge for a
Statement Level Code Coverage Tool for UniBasic. It is based on the
prototype for a similar tool we now use at my current employer.

 

Although this version is incomplete, it still enables statement level
coverage for multiple programs/subroutine with html output. The "parser"
(I really shouldn't use that term) is still quite primitive in this version
and may not work with how some programs are coded.

 

http://sourceforge.net/projects/ucov/

 

For a screen shot of the output and a short post about it, visit:
http://u2tech.wordpress.com/

 

Regards,

Dan

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

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

Re: [U2] [UV] Where is the COMMON block reserved ?

[jpb-u2ug]

In the first example the common is declared in program 1 and can be used in
both program 1 and the called subroutine program 2.
In the second example the common is declared only when the second program is
called and can only be used by the second program, and any programs called
from it. In this case program 1 doesn't know of the common at all.
It doesn't matter if you are using connection pooling.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: Thursday, November 19, 2009 2:02 PM
To: U2 Users List
Subject: Re: [U2] [UV] Where is the COMMON block reserved ?

Hello,

I have a question pertaining to how the shell used by the connection pooling
works as it relates to memory allocation.

In the following cases:

Case 1:  Program 1 has a number of variables and matrixes declared in a
common section  it calls  Program 2 which has the same common matrixes and
variables declared.

Ex: Program 1:

COM ABC(100), D,E,F
ARG = "BLAH"
CALL PGM2(ARG)

Program 2:
SUBROUTINE PGM2(ARG)
COM ABC(100), D, E,F
CRT ARG
RETURN

 

Case 2: Program1 doesn't have any common variables declared it calls
Program2 which does have common matrixes and variables declared:

Program 1:  

ARG = "BLAH"
CALL PGM2(ARG)

Program 2:
SUBROUTINE PGM2(ARG)
COM ABC(100), D, E,F
CRT ARG
RETURN


In Case 2, is the common block declared in the stack segment or will the
common be declared in the same place in both cases ?   


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

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

Re: [U2] Unidata odd error

[jpb-u2ug]

I can't speak for Unidata but with UniVerse there was no problem going from
Solaris to Red Hat. We went to it 4 years ago and I did it on a Saturday. I
set up the printers and themaster account ahead of time. 99% of the commands
are identical, I think the only problems I had were with the cp and rm
commands having an extra switch. If you don't use any of the operating
system commands you won't have any problems. Unlike going to Windows the
spooler is the same and cups is easy to use. If you are moving from a RISC
system to INTEL you have to run fnuxi on the accounts if you don't use
backup and restore utilities.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor
Sent: Monday, November 16, 2009 8:10 AM
To: Jeff Butera; U2 Users List
Subject: Re: [U2] Unidata odd error

We will be doing the same move next year.  Please let us know how the
process went, any "gotcha's", etc.
 
I've already tested once and did not have any problems with compiling and
running the application.  Didn't test printing, so I'm a little worried
about that.
 

>>> Jeff Butera  11/14/2009 6:47 PM >>>
> I have a question for you.  Why are you moving to RedHat from Solaris?  Do

> you think that Redhat is a better o/s?

We run everything else on linux here, the Solaris boxes for unidata are 
the oddballs.  Also, when you compare hardware costs (even with .EDU 
pricing from Sun) it's a no brainer to move.

Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
jbut...@hampshire.edu
413-559-5556

"I'm just having a conversation with myself
- it's about that time."
  Catherine Butera

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

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

Re: [U2] [UV] printing html documents

[jpb-u2ug]

If your html files are in a type 19 file and the location on your network is
reachable from your pc, you can kick off the IE browser from Accuterm
sending the path of the file and it will pop up like the wed editor. Then
you can print it or view it.

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
Sent: Friday, November 13, 2009 12:56 PM
To: U2 Users List
Subject: Re: [U2] [UV] printing html documents

Thanks everyone for your suggestions, I will try them all out!  BTW, I'm 
using Accuterm on linux.
-Dianne

Dianne Ackerman wrote:
> I have some documents that were created by users using html editors 
> (different kinds) which then were saved into uv files.  I want to read 
> in these documents from within a basic program and send them to the 
> printer, all nicely formatted.  Any ideas?  The reason I'm doing it 
> from basic is because I have a lot of other data that I'm working with 
> also, the html files are just a small part of it.  Thanks.
> -Dianne
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>

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

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

[U2] Agile and Scrum

[jpb-u2ug]

http://www.agilegamedevelopment.com/2007/12/pair-programming.html


XP Development


Jerry Banker

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

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

Documenting the program or application is always a good idea, it also helps
if changes to the programs are documented, but having to write the specs to
the smallest minutia is overkill. Unless, you are writing the specs for
someone else that doesn't know your business or the next person in line
shouldn't be in the position to start with. 

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
Sent: Wednesday, October 14, 2009 11:35 AM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

John, I agree that listening to the super users is critical.  However, 
writing a detailed spec will give those super users the ability to review 
the spec, add their 'second thoughts' (and the "wow, this is really cool - 
could it also do this?" ideas before the files are designed and the code 
written, and really does not take a lot of time.  It ensures that the coding

team all understand all the aspects of the project the same way.  So even 
with super users, I always waited for a sign-off on the detailed spec before

laying out the files and writing the code.  I had clients that I worked with

for years, and knew their business very well, but taking the time to write a

detailed spec was never a waste of my time.

I am glad for you that your system works well, but I hope I never have to 
come in after you all retire!  ;-)

Susan Lynch
- Original Message - 
From: "Israel, John R." 
To: "U2 Users List" 
Sent: 10/14/2009 12:14 PM
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table


> You cannot buy knowledge of a business.  Experience with a technology: 
> yes.  Knowledge of how a specific company works: no.  That only comes with

> time working at that site.
>
> A key to our success is having super-users that really know how the 
> business works, how the software works, and the ability to clearly 
> describe how they want things enhanced.  The other half of this coin is 
> having programmer/analysts that understand what the user wants, where the 
> data is stored (or will need to be stored), who ask the right questions, 
> and can work with those super-users.  Our users are very happy with what 
> we produce.  We have a small U2 team, but a well seasoned team.
>
> I rarely have specs and never very detailed.  It is all screen shots with 
> hand written notes that come from a meeting or two with the super-users. 
> Requests from non-super-users must go through the super-users.  It is my 
> job to understand what they want (which is usually, but not always what 
> they ask for).
>
> However, not every business will have these conditions.  Contractors have 
> it even tougher since they may have little knowledge of the business they 
> are trying to help.
>
> Just my experience...
>
>
>
> John Israel
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
> Sent: Wednesday, October 14, 2009 12:00 PM
> To: U2 Users List
> Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
>
> As a programmer who has had to maintain and enhance systems that were
> written apparently based on a one-page spec that "everyone on the team"
> understood, when the team members are no longer there, and the 
> documentation
> was all between their ears (and left with them), I am a big believer in
> detailed written specs that get turned into test plans and then into
> documentation.
>
> Eventually the lack of specs turns around and bites the organization that
> allowed it to happen (unless the application was a one-time 
> quick-and-dirty
> project that will never have to be resurrected).
>
> Susan Lynch
> - Original Message - 
> From: "jpb-u2ug" 
> To: "'U2 Users List'" 
> Sent: 10/14/2009 8:18 AM
> Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
>
>
>> Alleluia! Brother!
>>
>> Jerry Banker
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
>> Sent: Wednesday, October 14, 2009 5:00 AM
>> To: 'U2 Users List'
>> Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
>>
>> Exactly - i still stick to the belief that a small team of highly skilled
>> programmers will code quicker from a single page spec than a thousand low
>> quality coders using a high detail spec. Many an institution disagrees, 
>> or
>> rather has been stung by smaller teams giving promises th

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

Alleluia! Brother! 

Jerry Banker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Wednesday, October 14, 2009 5:00 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Exactly - i still stick to the belief that a small team of highly skilled
programmers will code quicker from a single page spec than a thousand low
quality coders using a high detail spec. Many an institution disagrees, or
rather has been stung by smaller teams giving promises that they can then
not deliver, I suppose this is what bureaucracy is all about, something
simple runs perfectly until someone slips up, then all hell breaks loose and
15 procedures are put into place and before you know it you have a team of
20 doing what one guy did all on his own.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 13 October 2009 22:54
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

If you are going to go that far with the minutia then why not just type it
in and get done with it?

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 2:09 PM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Actually for many it is mass produced. Specification is being done to the
absolute minutia, for example in the Unified Rational process, when
generating use cases these get transmitted down to the architectural
specifications and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.

 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 13 October 2009 18:00
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

I don't see where you are coming from here. Every program I ever produce is
for a specific purpose. We don't create one program and then have an
assembly line that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 9:43 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms are pretty much the same as any other - if you get
a small highly focused team of experts they will achieve a lot. The problem
is when you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist development. 


Perhaps




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 12 October 2009 22:09
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies.  I've seen exactly this
progression in other language lists to which I belong.  Indian firm gets
contract based on price and claim to know the language.  Indian firm tries
to get free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got persona

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

If you are going to go that far with the minutia then why not just type it
in and get done with it?

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 2:09 PM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Actually for many it is mass produced. Specification is being done to the
absolute minutia, for example in the Unified Rational process, when
generating use cases these get transmitted down to the architectural
specifications and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.

 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 13 October 2009 18:00
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

I don't see where you are coming from here. Every program I ever produce is
for a specific purpose. We don't create one program and then have an
assembly line that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 9:43 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms are pretty much the same as any other - if you get
a small highly focused team of experts they will achieve a lot. The problem
is when you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist development. 


Perhaps




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 12 October 2009 22:09
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies.  I've seen exactly this
progression in other language lists to which I belong.  Indian firm gets
contract based on price and claim to know the language.  Indian firm tries
to get free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, October 12, 2009 1:47 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Doesn't matter which.  We are the next group that will be asked to work 
for reduced pay or our work will go to India. 

Bruce M Neylon
Health Care Management Group 
Phone: (301) 608-8633
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

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

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listser

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

I don't see where you are coming from here. Every program I ever produce is
for a specific purpose. We don't create one program and then have an
assembly line that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 9:43 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms are pretty much the same as any other - if you get
a small highly focused team of experts they will achieve a lot. The problem
is when you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist development. 


Perhaps




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 12 October 2009 22:09
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies.  I've seen exactly this
progression in other language lists to which I belong.  Indian firm gets
contract based on price and claim to know the language.  Indian firm tries
to get free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, October 12, 2009 1:47 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Doesn't matter which.  We are the next group that will be asked to work 
for reduced pay or our work will go to India. 

Bruce M Neylon
Health Care Management Group 
Phone: (301) 608-8633
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

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

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

I don't think anyone was questioning Jay's intelligence. He is probably a
very intelligent person or he would not have been hired. What is in question
is the intelligence of the individuals that hired the firm he works for and
the intelligence of the people that gave him the work to do without first of
having him trained on it.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor
Sent: Tuesday, October 13, 2009 8:26 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Excellent points.  In my personal experience, I've had terrible dealings
with overseas firms.  On the flip side, the sharpest person I've ever worked
with was from New Delhi.
 
Getting back to the point at hand, I believe that Pick Systems had some
development work done in Russia, during the early 90's.  I remember their
work as being very good and remarkably bug-free. (Of course, I also drank a
lot during those days, so my memory may not be that good.)  Now,all of a
sudden, at the same time that Rocket Software picks up U2, we start getting
questions from rsystems in India.  Naturally, I wondered if Rocket Software
was the company that hired them.  Probably not, but I'm still curious.

>>> "Larry Hiscock"  10/12/2009 5:09 PM >>>
Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies.  I've seen exactly this
progression in other language lists to which I belong.  Indian firm gets
contract based on price and claim to know the language.  Indian firm tries
to get free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, October 12, 2009 1:47 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Doesn't matter which.  We are the next group that will be asked to work 
for reduced pay or our work will go to India. 

Bruce M Neylon
Health Care Management Group 
Phone: (301) 608-8633
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

Re: [U2] U2 is now Rocket U2

[jpb-u2ug]

Prime Information

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis
Sent: Monday, October 12, 2009 3:32 PM
To: U2 Users List
Subject: Re: [U2] U2 is now Rocket U2

Love the U2-rocket story, Dominic. I don't know if there is any U2 in
Russia or related countries, but I understand that some PICK or
PICK-a-like system was used to track Russian spies in the US, perhaps
all the way to the end of the cold war. If anyone has details on that,
such as which MV flavor it was (something I might have known at one
time), I'd be interested.  [And, yes, I know, I know, I shouldn't be
on this list--it should move over to U2C, but ...]  Cheers!  --dawn
-- 
Dawn M. Wolthuis

Take and give some delight today

On Mon, Oct 12, 2009 at 2:36 PM, Dominic Baron
 wrote:
>
>
> Yes, I also like U2. It has interesting historical associations, for those
of us of a certain age. It was a "U2" spy-plane that was shot down by a
"rocket" over the USSR in 1960 that led to quite a frosty first meeting
between Khruschev and Kennedy in Geneva that year.
>
> Which leads me to ask if anyone knows whether any U2 (DB's of course)
installations exist in Russia or in any of the former Soviet Republics?
>
> Dominic Baron.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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