Re: [U2] Please recommend a Pick-based upgrade for QuickBooks (SECURITY=Unclassified)

[HENDERSON MIKE, MR]

I'm sorry, but the chances of me buying anything from a company whose website 
says under the heading "Latest News" that something is "scheduled for release 
Jan '07" is very, very close to zero.
In my view, a company that hasn't updated its website in seven years is - if 
still in business at all - obviously way out of touch and not going to be the 
supplier of anything I care about.

Bah, humbug!

Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George R Smith
Sent: Thursday, 19 December 2013 6:20 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Please recommend a Pick-based upgrade for QuickBooks

http://www.gaap.com/

Pick based for over 30 years.
George

-Original Message- 
From: Wjhonson
Sent: Wednesday, December 18, 2013 10:53 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Please recommend a Pick-based upgrade for QuickBooks


For a client who is currently using QuickBooks.

Just essentially the same functionality as QuickBooks, doesn't need added 
bells and whistles.
No one who's going to charge 50K please :)
Thanks.



___
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
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] How do I find the code? [SECURITY=UNCLASSIFIED]

[HENDERSON MIKE, MR]

Greg,

Looks to me like you need to go through the entire file system looking
for something (*anything*!) that looks like "... A26.ISS.EMPLOYMENT...",
and hope that you find something and that all you find isn't just object
code.
Good luck, I'm afraid you might be going to need it :-(

You don't say if the target system is UV or UD, but the object code
could be globally catalogued somewhere - in UV IIRC it's be something
like "*A26.ISS.EMPLOYMENT" in the GLB.CTLG file.


Regards


Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Wednesday, 6 March 2013 4:06 p.m.
To: U2 Users List
Subject: Re: [U2] How do I find the code?

This is a good point.  I have been trying to track down the reason why
this process is NOT working.  I've already spent too much time going
down this rabbit hole where I have very little access to runtime
processing. 
Out of the 12 thousand lines of code that I was able to find -
A26.ISS.EMPLOYMENT is my primary culprit.  It will just be too easy for
all this to result from the code disappearing! LOL  I'm throwing in the
towel for tonight - tomorrow morning I start looking for disappeared
code.

Thanks!



From:   Wjhonson 
To: u2-users@listserver.u2ug.org, 
Date:   03/05/2013 09:33 PM
Subject:Re: [U2] How do I find the code?
Sent by:u2-users-boun...@listserver.u2ug.org



It might be a non-runnable command.
Have you tried to actually RUN this to see if it complains that the code
is missing?


 

 

 

-Original Message-
From: Greg Coelho 
To: U2 Users List 
Sent: Tue, Mar 5, 2013 6:19 pm
Subject: Re: [U2] How do I find the code?


Can't seem to find it in either WBP.O or WBP.OBS (I do have a VOC
listing 
for WBP.OBS). 



From:   Wjhonson 
To: u2-users@listserver.u2ug.org, 
Date:   03/05/2013 09:06 PM
Subject:Re: [U2] How do I find the code?
Sent by:u2-users-boun...@listserver.u2ug.org



Then Greg I suggest someone has stripped the source, and left you with 
only the object.
You can do
ED WBP.O A26.ISS.EMPLOYMENT
to verify that it exists, but DO NOT LIST IT
it will screw up your terminal emulator software most likely if you 
display the object code
ED only gives you Top, then you can do EX right away

 

 

 

-Original Message-
From: Greg Coelho 
To: U2 Users List 
Sent: Tue, Mar 5, 2013 5:52 pm
Subject: Re: [U2] How do I find the code?


Unfortunately that was one of the first things I tried...

:AE WBP A26.ISS.EMPLOYMENT 
Top of New "A26.ISS.EMPLOYMENT" in "WBP". 
*--: P 
Top. 
Top of new record. 

It looks like A26.ISS.EMPLOYMENT doesn't live in WBP.

Greg



From:   Wjhonson 
To: u2-users@listserver.u2ug.org, 
Date:   03/05/2013 07:51 PM
Subject:Re: [U2] How do I find the code?
Sent by:u2-users-boun...@listserver.u2ug.org



You have a file called WBP so

ED WBP A26.ISS.EMPLOYMENT



 

 

 

-Original Message-
From: Greg Coelho 
To: U2 Users List 
Sent: Tue, Mar 5, 2013 4:50 pm
Subject: Re: [U2] How do I find the code?


All,

I am not versed in (PQ) PROC.  Can anybody tell where I have to go to
find 



the code for A26.ISS.EMPLOYMENT?

:AE VOC A26.ISS.EMPLOYMENT 
3 lines long. 
 
: P 
0001: PQ 
0002: HRUN WBP A26.ISS.EMPLOYMENT 
0003: P 
Bottom at line 3. 

As Always, THANKS!

Greg
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] VOC Pointer [SECURITY=UNCLASSIFIED]

[HENDERSON MIKE, MR]

Or, instead of SAMBA on the HP-UX system, you could have an NFS share on
the Windows box - Windows Server 2008 has Microsoft "NFS Services for
Windows" and there are several freeware / shareware / commercial NFS
clients for Windows.

Lots of ways to skin this particular cat

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Tuesday, 5 March 2013 11:51 a.m.
To: U2 Users List
Subject: Re: [U2] VOC Pointer

How about using scp with public/private key authentication running from
a unix cron to scp from the windows host to a dir on the unix host?
Requires ssh installed on both hosts.

I've also installed Cygwin on a windows host in the past and used that
for the ssh/scp component as you get a nice unix flavour when you ssh in
remotely.

Alternatively as someone has already said try using smbmount to mount a
windows share on a unix dir and use unix cp or mv. Requires samba
installed on your HPUX host and that install must have the smbmount (or
equivalent) utility.

You could also use ftp to fetch the files from the windows server.
Requires ftp server installed on windows host.

All the above could be driven from within a UD/UV basic program.

HTH
Peter

[snip]
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UD] Odd question re: 7.1 docs (Unclassified)

[HENDERSON MIKE, MR]

At a guess, an "important" customer relies on the behaviour that the
option turns off and lost the argument about whether this was a
feature-not-a-bug rather than a bug-not-a-feature


Regards


Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Friday, 5 October 2012 3:19 p.m.
To: U2 Users List
Subject: [U2] [UD] Odd question re: 7.1 docs

I just found this in the UDT.OPTIONS manual...

"If UDT.OPTIONS 107 is off, UniData returns incorrect multivalues from
the
target file."

Here's my question.  With that description in mind, why would anyone
want
this to be off?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [u2] Parallel processing in Universe (Unclassified)

[HENDERSON MIKE, MR]

I have often thought about this - mostly in an idle moment or as a
displacement activity for something less amusing that I ought to be
doing. ;-)


First of all, Universe is already extremely parallel: there's a separate
O/S thread for each TTY and for each phantom, and you can't get more
parallel than that for interactive processing.

So you want more parallelism for your batch processes.
Different applications have different degrees of inherent parallelism.
For example in utility billing systems there is frequently the concept
of a group of premises - based on the old concept of a foot-borne meter
reader with a 'book' of readings to get. Each 'book' can be processed
independently of every other. In payroll, each employee's record can be
processed independently. Other areas of commerce have different
characteristics.

I think that whatever unit of parallelism you settle for, you'd need
three processes: a 'dispatcher' that selects records for processing and
queues them into some structure for processing; a set of 'workers' that
take queued work items, process them, mark them as processed and put the
results in some common store; and a 'monitor' that looks for unprocessed
records and indications of stuck processes, and collates the results for
final output.
I've seen a couple of versions of this, one for electricity billings and
another for overnight batch-processing of report requests, both well
over a decade ago, and neither still in use although their underlying
packages are still being run.

The major issue is that these days the whole entity in the general
commercial world is far more likely to be I/O limited than CPU limited,
and therefore introducing parallelism will be no help at all if the I/O
system is already choked.
Even if the system is currently CPU-limited, multi-threading may not
produce much improvement without very careful design of the record
locking philosophy - introducing parallelism will be no help if all the
threads end up contending serially for one record lock or a small set of
locks.


If you want it to go faster, buy the CPU with the fastest clock you can
get (not the one with the most cores), and put your database on SSD like
Ross said.
The Power7+ chips being announced any day now are rumoured to go to
5GHz+, maybe even more if you have half the cores on the chip disabled.


Regards


Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris
Sent: Tuesday, 2 October 2012 3:50 p.m.
To: U2 Users List
Subject: Re: [U2] [u2] Parallel processing in Universe

If the file were big enough, and already had part files, then I believe
that you could have a phantom process each of the individual parts.
Failing that, get an SSD  relatively cheap, and will give your
processing a reasonable kick along!!

Ross Ferris
Stamina Software
Visage > Better by Design!


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David
Wolverton 
Sent: Tuesday, 2 October 2012 8:47 AM
To: 'U2 Users List'
Subject: Re: [U2] [u2] Parallel processing in Universe

OK - I was trying to create a 'smoother use' of the disk and 'read
ahead' -- this example the disk would be chattering from the heads
moving all over the place. I was trying to find a way to make this
process more 'orderly' -- is there one?

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

Create an index on a dict pointing at the first character of the key,
and have each phantom take two digits. (0-1, 2-3, 4-5, 6-7, 8-9)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David
Wolverton
Sent: October-01-12 2:43 PM
To: 'U2 Users List'
Subject: Re: [U2] [u2] Parallel processing in Universe

So how would a user 'chop up' a file for parallel processing?  Ideally,
if here was a Mod 10001 file (or whatever) it would seem like it would
be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how
'start a BASIC select at Group 2001 or 4001' ...

-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 3:29 PM
To: U2 Users List
Subject: Re: [U2] [u2] Parallel processing in Universe

0001: OPENSEQ "/tmp/pipetest" TO F.PIPE ELSE STOP "NO PIPE"
0002: LOOP
0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE
0004:PRINT LINE
0005: REPEAT
0006: STOP
0007: END

Although, not sure if you might need to sleep a litte between the
READSEQ's ELSE and CONTINUE
   Might suck up cpu time when nothing is writing to the file.

Then you could setup a printer in UV that did a  "cat - >>
/tmp/pipetest"

Now your p

Re: [U2] [Windows] (SECURITY=UNCLASSIFIED)

[HENDERSON MIKE, MR]

Great input, Tony.

But be warned WJ, if your client PCs are external to your network, then
Private Addressing and NAT may make this whole exercise nugatory.
For example, if your host network / server is on your 10.x.y.z (or
192.168.a.b) and your remote client is on his 10.x.y.y (or 192.168.a.c),
then you may end up resolving the name for the remote client as being
whatever has 10.x.y.y (or 192.168.a.c) assigned on its local network. 
IPv4 addresses are legitimately non-unique.


Regards


Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org  On Behalf Of Tony Gravagno
Sent: Friday, 7 September 2012 1:48 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [Windows]

Here are a number of ways to link a telnet client into UV back to its
respective hostname. There's some redundancy here as not all commands
work everywhere.

[snip]

I'm sure none of that was helpful to WJ who will say "no, that's not
it at all, what I really want is..." but I trust it will benefit
someone else.
T

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] DOS /c and the &HOLD& file {SECURITY=UNCLASSIFIED}

[HENDERSON MIKE, MR]

Wol,

Unless Rocket have fixed it in 11.x, the problem may be with the double
quotes / bunnies ears.
The "DOS" command is pretty badly broken, particularly if you need to
try to use a quoted string with embedded spaces (e.g. '... "C:\Program
Files\MyApp\AppName.exe" ...').
After I bitched about it, a new GCI function "UVRunCommand" was
introduced (in 10.0 IIRC).

You need code like this
-
DECLARE GCI UVRunCommand
DOS.COMMAND.STRING = 
MY.GCI.STATUS = UVRunCommand('c:\WINDOWS\system32\cmd.exe /c
':DOS.COMMAND.STRING)
IF MY.GCI.STATUS NE 0 THEN
   
END
--

I'm sure "UVRunCommand" is documented somewhere (apart from the Release
Notes when it was introduced), I'm just not sure where. Nor do I
understand why they just didn't fix the "DOS" command.

Hope this helps


Regards


Mike


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Friday, April 13, 2012 4:25 PM
To: U2 Users List
Subject: [U2] DOS /c and the &HOLD& file

Just a quickie - I'm trying to run a command and pass a pathname to the
&HOLD& file

DOS /c 'pcl6 -sOutputFile="&HOLD&\PO.pdf" "&HOLD&\PO.pcl"'

I can't work out how to get dos to handle the & properly - everything
seems to work perfectly until I put an & into the command. Seeing as
it's a print file I've just created with a mode 3 setptr and LIST LPTR,
I really don't want to struggle to move everything around.

That said, I might be better off writing a basic program to move it to
&UFD& and working on it from there :-(

Cheers,
Wol
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] FAST (File Analysis and Sizing Tool) {Unclassified}

[HENDERSON MIKE, MR]

David,

I think this is called a "Histogram Method" in the literature.
You can obviously make the 'buckets' as big or as small as you like
depending on how much memory you want to use - you could even have
1-byte buckets which would allow you to calculate the actual median
rather than an approximation, but an approximation would be plenty good
enough for this application.

There are also published algorithms for calculating the Standard
Deviation in a single pass, so that using this and your method would
allow calculation of the mean, median and SD with one pass through the
file.
That should give you a pretty good idea of the 'shape' of the data



Regards


Mike


-Original Message-
From: u2-users-boun...@listserver.u2ug.org On Behalf Of David Wolverton 
Sent: Friday, 7 October 2011 8:29 a.m.
To: 'U2 Users List'
Subject: Re: [U2] FAST (File Analysis and Sizing Tool)

What about this... Could you just store a MultiValue of the 'approx
size' of each record?  Then you would 'add one' to the correct MV as you
process the record counts.  At the end of the run, you'd have a list
where you could essentially start a loop to 'work to the center'

So you'd have a MV of buckets as
512]1024]2048]4096]8192]16384]32768[etc
in whatever break was most reasonable -- perhaps it would be
100]200]300]400]500]600]700 etc...

Each record would '+1' to the correct size bucket - so a record that is
310 would drop into the '400' bucket (>300, <=400) or one that is 4000
would be in 4096 (>2048 <=4096) -- the number and size for the buckets
would be what would be 'meaningful' to the process.
At the end, you'd have an array of counts based on the 'size' MV it
dropped into that would resemble

20]400]22600]52000]16000]250]1]]]1

Or the like... from there, you could get to 'median' pretty quickly I
think with one pass at it. And while not the EXACT a byte count (meaning
the 52000 'bucket' clearly has the 'median' which would be somewhere
between 300 and 400 bytes or 2048 to 4096 - depending on how you did
your 'buckets'. This would likely be 'close enough' for the 'horseshoes'
game of file sizing as long as you did the buckets in
narrow-ish/meaningful breaks.  

(And maybe you'd do a DIM'd Array over MV to make incrementing the
counters faster -- but you get the idea.)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff
Fitzgerald
Sent: Thursday, October 06, 2011 12:44 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] FAST (File Analysis and Sizing Tool)

[snip]

This brings up my question - What is the best way to find the median?
Say that you have an arbitrary number of records; how do you find the
median record size?  The easy answer is to sort the size values and then
pick the middle.  However, suppose you have a billion records - storing
the billion size values provides some challenges!  Is there a way to
find median with a single pass and without having to provide storage for
ALL the values?  I'd be interested in anyone's ideals about finding
median and about measures of skewness in general.
 Thanks!

Jeff Fitzgerald
Fitzgerald & Long, Inc.
www.fitzlong.com
j...@fitzlong.com
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Logical error {Unclassified}

[HENDERSON MIKE, MR]

Sathish,

Or, if you want to make life a little easier for the next poor guy who
gets to maintain the code:


ESC = CHAR(27)
MeaningfulNameForString = "[44m"

ScreenCommand = ESC:MeaningfulNameForString

CRT ScreenCommand




Regards


Mike


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Thursday, 9 June 2011 5:14 p.m.
To: U2 Users List
Subject: Re: [U2] Logical error

In UniBasic, you could just do:

CRT CHAR(27):"[44m"



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of sathish
Sent: Wednesday, 8 June 2011 11:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Logical error

Hi,

   I am having problem in using escape sequence in UniBasic coding.I
cant use the following command in UniBasic code.

Command: echo -e "\033[44m".

If i use this command in UniBasic code it shows error for using "\".So
can you suggest any solution for using this command in UniBasic coding.

Thanks,
Sathish

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] 'U2 Market Place' {Unclassified}

[HENDERSON MIKE, MR]

No, just my nasty suspicious mind: this could be a drive-by web-site
that will [try to] infect my PC if I visit it, then vacuum up sufficient
data to either impersonate me or run up a bill on my credit card - or
both if I got really 'lucky'. So I ain't going there.

In my view, if these folks are legit they should have solicited my
interest by advertising, e.g. on this list, rather than snaffling my
email address from somewhere and sending me UCE



Regards


Mike


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
fft2...@aol.com
Sent: Thursday, 10 March 2011 6:02 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 'U2 Market Place' {Unclassified}

The original poster mentioned "hard earned cash", is this offering
soliciting money for something?  And if so, for what?

W
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] 'U2 Market Place' {Unclassified}

[HENDERSON MIKE, MR]

Folks,

I have recently started getting email from
"postmas...@u2marketplace.com" about the 'U2 Market Place'. It also
features "Return-Path: u2...@mercury.serverphase.com".
Whilst it looks like it might be kosher, I'm a little intrigued as to
where they got my email address from. The address they use indicates
it's not been harvested from an email I sent, but that it may have been
scraped from a signature block.

I guess I could do a little "whois" work on "u2marketplace.com" and
"serverphase.com", and maybe a traceroute on "mercury.serverphase.com",
but asking here is definitely easier!

So: advice, please: is this a genuine bona fide organisation I might be
interested in, or yet another but reasonably sophisticated attempt to
separate me from my digital identity and possibly my hard-earned cash?


Thanks


Mike

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Clear Message Initiative - Logging Errors to a U2 File {Unclassified}

[HENDERSON MIKE, MR]

The trouble is, it's so much easier to 

Just code 
"... ELSE CRT @(00,24):'***ERROR*** end date must not be before start
date' "


Than

Now code 
" ... ELSE ErrorCode = '123456'; ErrorText = ''
   CALL ErrorLookup (ErrorCode, ErrorText)
   CRT AtErrMsgPosn:'***ERROR*** ':ErrorText "


In my experience, programmers tend to revert to the former even when
there's a provided way of doing the latter, particularly for what they
consider to be unlikely errors. 
You'll only catch this if your Quality Assurance actions include code
review.
And most of us don't do that


Regards


Mike

 

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
> Charlie Noah
> Sent: Thursday, 10 February 2011 10:53
> To: U2 Users List
> Subject: Re: [U2] Clear Message Initiative - Logging Errors 
> to a U2 File
> 
> This is indeed an excellent article. Thanks, Susan! Error 
> messages certainly get ignored, and I'm as guilty as rest.
> 
> Charlie Noah
> 
> 
> On 02-09-2011 2:02 PM, Bill Brutzman wrote:
> > Thanks to Susan Joslyn for the excellent article on the 
> "Clear Message Initiative.  I just received my copy of the 
> magazine in the mail today.
> >
> > It happens that over the weekend, I was reading "Code 
> Complete 2" by Steve McConnell of Construx.  Following an 
> idea in Code Complete...
> >
> > Yesterday, I told my boss that I am planning to enhance the 
> clarity of our error messages, send a workflow message to 
> others who would need to know about that problem and also to 
> LOG THE ERROR MESSAGE to a U2 file, user, time, date etc.
> >
> > --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
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] The sky is so falling! {Unclassified}

[HENDERSON MIKE, MR]

In case you hadn't already heard, IANA has allocated the last blocks of
IPv4 addresses to the Regional Internet Registries (RIRs). There are *NO
MORE*, the cupboard is bare. 
See, amongst what will doubtless be lots of others,
http://www.apnic.net/final-five.


If AfriNIC is your RIR, you'll probably be able to get an IPv4 address
allocation for several years.
IF APNIC (which serves China, India, Korea and Japan as well as
Australia & NZ) is your RIR, you'll be flat out of luck before Christmas
- some commentators say as soon as July.


So, how "IPv6 Ready" is the U2 community?
How "IPv6 Ready" are you? 
E.g. Have you got any tables where you store IP addresses? If so, what
happens when you need to store and display/list
"DEAD:BEEF::1020:17AA:0236:1AAA" instead of "192.168.215.132"? 


The fun is about to start
:-)


Regards


Mike

 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse DOS Command - Batch File Error {Unclassified}

[HENDERSON MIKE, MR]

Don,

The "DOS" command is pretty badly broken, particularly if you need to
try to use a quoted string with embedded spaces (e.g. '... "C:\Program
Files\MyApp\AppName.exe" ...').
After I bitched about it, a new GCI function "UVRunCommand" was
introduced (in 10.0 IIRC).

You need code like this
-
DECLARE GCI UVRunCommand
DOS.COMMAND.STRING = 
MY.GCI.STATUS = UVRunCommand('c:\WINDOWS\system32\cmd.exe /c
':DOS.COMMAND.STRING)
IF MY.GCI.STATUS NE 0 THEN
   
END
--

I'm sure "UVRunCommand" is documented somewhere (apart from the Release
Notes when it was introduced), I'm just not sure where. Nor do I
understand why they just didn't fix the "DOS" command.

Hope this helps

Regards


Mike 

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org On Behalf Of Don P. Nagai
> Sent: Wednesday, 3 November 2010 08:35
> To: 'U2 Users List'
> Subject: [U2] UniVerse DOS Command - Batch File Error
> 
> I have a batch file on a server running UniVerse.  This file 
> can be executed from Windows Explorer with no problems.
> 
>  
> 
> If I attempt to run the same batch file using the UniVerse 
> DOS command, the batch file will not process.  The DOS 
> command line is displayed, there is a slight delay (2 sec or 
> so) before the "EXIT" command is issued and the system 
> returns to TCL, but the batch file doesn't run.
> 
>  
> 
> The UV User Ref is pretty vague on details for the DOS command.
> 
>  
> 
> Any ideas on what I might be missing?
> 
>  
> 
> TiA
> 
>  
> 
>  
> 
>  
> 
>  
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] INPUTIF statement in Universe {Unclassified}

[HENDERSON MIKE, MR]

I.E., add the line with "NAP" in it.
You may want to try different NAP intervals to work out the best balance
between snappy user response and CPU usage.


OK = 0 ; START.DT = DATE() ; START.TM = TIME(); TIME.OUT = 900  LOOP
INPUTIF PSN THEN OK = @TRUE ELSE
   NAP 100 ; Doze 100 milliseconds = 1/10 sec
   OK = ((DATE()-START.DT)*86400)+TIME()-START.TM > TIME.OUT

   IF OK THEN
  IF EDIT.FLG THEN PSN = '' ELSE PSN = 'Q'
   END
END
 UNTIL OK DO
 REPEAT
__
 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
fft2...@aol.com
Sent: Wednesday, 27 October 2010 10:14 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] INPUTIF statement in Universe

In a message dated 10/26/2010 11:58:58 AM Pacific Daylight Time, 
eric.rosenzw...@petco.com writes:


> In testing, it's the INPUTIF statement that's utilizing the CPU, not
the
> timer calculation.
> 
> Is there a better, less CPU intensive way to do this? 
> 
> Thanks in advance. >>
> 


INPUTIF checks the type-ahead buffer every time slice.  You're getting
so 
many slices that your CPU is consumed with this one task of checking the

type-ahead buffer.  It's frenetic, a CPU on crystal meth.

In the old days, we would say Release Timeslices RQM.  Today you can
solve 
that issue as well, by adding a Sleep for a 1 second.  On systems that
allow 
sleeping for periods less than a second, you only really need to add a 
sleep for a tenth of a second, to see your CPU suddenly quiesce.

Will Johnson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Help in removing erroneous character from data file {Unclassified}

[HENDERSON MIKE, MR]

I can't help finding a certain delicious irony in seeing a UniVerse
support request coming from someone who works for the former owner of
the product.
Gayathru, I expect that IBM India should still have some internal
support people who know about UniVerse, or at least know where they've
gone. Do you have a local Value Added Reseller or are you a direct
support customer of Rocket Software? From your postings, it appears that
you have a potentially badly corrupted file and are a little light on
in-depth understanding of the platform.
You also need to think about how did the bad data get there? The routine
that puts the data into your UniVerse file may need amendment to better
control the quality of the incoming data, if that is the seat of the
problem.
Just 'correcting' the apparently bad data may not solve the problem at
all

Good luck, I'm afraid you're going to need some

Mike
-Original Message-
From: u2-users-boun...@listserver.u2ug.org On Behalf Of
ggayat...@in.ibm.com
Sent: Friday, 17 September 2010 8:39 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Help in removing erroneous character from data file


Another application had problem processing the file that it had pulled
from
my application with the data. In Line Number : 2506 a field(field comes
from
a UniVerse table) had a value of 11 and the application is looking for
time
(XX:XX:XX format) After this field all data is incorrect. Also, the line
2506 is unusually long. 

Gayathru

Mecki Foerthmann wrote:
> 
>  More information would be helpful.
> 
> On 17/09/2010 06:10, ggayathri wrote:
>> I have a data file that is sent from my application(on UniVerse) to
an
>> interfacing application.
>> In the huge amount of data, an erroneous character has been
introduced. 
>> Can someone suggest a way to remove that character?
>> May be a routine that would do it?
> ___
> 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/Help-in-removing-erroneous-character-from-data-fil
e-tp29735223p29736257.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
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Slow READ/WRITE with indexes {Unclassified}

[HENDERSON MIKE, MR]

Ryan,

You said you had indexes like "'ORDER.DATE', 'COUNTRY', 'MEMBER ID'". If
those are really the full index data items, you could have thousands,
tens of thousands, or even hundreds of thousands, of records with the
identical index data item value in the SOH file. If that's the case,
updates (inserts) may well be s-l-o-w as the system churns through many,
many, many linked buffers of identical valued keys looking for an insert
point.

I'd try to isolate if the problem is with deletes from the SO file or
inserts to the SOH file, by disabling indexing first on one, then the
other, then both, to see where the problem lies. 

If it's inserts to the SOH  file that's the problem - which I suspect is
the case - then you have two choices: make the disabling of indexes
during this process a 'feature'; or restructure your SOH file and its
indexes to avoid the clumping. The restructuring could involve
re-defining your indexed fields to give fewer duplicated values (but
that might mean considerable application program changes, depending how
they're written) or you could consider turning SOH into a UV Distributed
File set, maybe partitioning on values of ORDER.DATE.


Good hunting


Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ryan M
Sent: Friday, 10 September 2010 8:13 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Slow READ/WRITE with indexes


The indexes have been in place for some time now (1+ years)

I'm guessing 10k to 15k new records per day is fairly high volume (this
does
not include changes to existing records).


The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] Shared Record Locks {Unclassified}

[HENDERSON MIKE, MR]

Dear oh deary me, this is sooo 1970s!
Guys, Google 'optimistic locking' 

[Quick overview:
 1) When the user first looks at the data, 
* read the record, no lock, 
* save a copy in memory (Named Common) or on a BeforeLook disk file
 2) When the user wants to update the record,
* read the record with lock
* compare the just-read record with the saved copy
  + if they are the same 
- write the updates
  + if they are different
- give the user an error message
  "someone else fritzed with it while you were dawdling"
* throw away the BeforeLook
* unlock everything, you're done
 This is called 'optimistic' because you're betting that the BeforeLook 
 and the current record are almost always the same, so you hardly ever 
 get to take the error path.
End of quick and probably oversimplified overview]


-Original Message-
> From: u2-users-boun...@listserver.u2ug.org On Behalf Of Mecki
Foerthmann
> Sent: Thursday, 2 September 2010 5:00 a.m.
> To: U2 Users List
> Subject: Re: [U2] [UV] Shared Record Locks
> 
> 
>  Bill,
> 
> I thought doing something similar myself when I was a Junior
programmer
> because some people tend to lock records and go for lunch etc..
> But what happens if you read the record into the variable R.This do
some
> processing, then the phone rings and you talk for 10 minutes, while
> somebody else uses the same process, changes the record and writes it
> 
[snip]
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Code 128 Soft Font {Unclassified}

[HENDERSON MIKE, MR]

But remember, Windows 2000 goes off life support - not even security
patches - on 13th July. That's 13th July 2010, just seven weeks time.
So I'd be more than a little bit leery about putting a new application
on a Win2K box, especially if the box has got any sort of connection
'outside' your network.
In fact, you should most likely be trying to upgrade all your Win2K
boxes to something vaguely supported. 

Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Thursday, 20 May 2010 8:30 p.m.
To: 'U2 Users List'
Subject: Re: [U2] Code 128 Soft Font

'Cmon, are you seriously saying you don't have any old windows boxes
lying
around your organization?

I can't speak for PrintWizard, but mvPDF will run happily on an old
Win2000 box. 

[snip] 

Brian 


The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UD: Phantoms {Unclassified}

[HENDERSON MIKE, MR]

Meh!

Like "NAP 1" in UniVerse on Windows is actually "NAP 18" - you can't
actually NAP for 1 millisecond, the lowest resolution seems to be about
18 milliseconds.

YMMV

Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org On Behalf Of Dan McGrath
Sent: Thursday, 8 April 2010 10:34 a.m.
To: U2 Users List
Subject: Re: [U2] UD: Phantoms

Bill, I get similar results to your test program.

INPUT PauseTime
FOR I = 1 TO 10
   StartTime = TIME()
   PAUSE PauseTime
   StopTime = TIME()
   CRT "Total time taken is " : OCONV(StopTime - StartTime, 'MTS'):
   CRT ", expected ": OCONV(PauseTime, 'MTS')
NEXT I

Run from ECL
Input = 5, Times taken: 6,10,10,10,10,10...
Input = 10, first time taken was 8, the next 9 where all 10.
...

So, clearly PAUSE aligns itself to a 10 second boundary and can only
operate on that.

Given this, PAUSE works correctly for any 10 second increment, AFTER the
first pause statement. Something like this should be added to the
document, because according to the manuals 'PAUSE 5' should work, but in
practice, it will actually running a 'PAUSE 10' with the first PAUSE
statement pausing for an undefined period. 

Regards,
Dan
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [Fwd: Re: Auto logout time {Unclassified}]

[HENDERSON MIKE, MR]

Bill,

"UOLOGIN" would be a *lovely* enhancement to UV!
But unless it's in 10.3, or is an undocumented feature in 10.2, it would
indeed be an enhancement. :-(

Wally, Rocket anyone, care to comment?


Regards


Mike

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Tuesday, 8 December 2009 12:21 p.m.
To: U2 Mail List
Subject: [U2] [Fwd: Re: Auto logout time {Unclassified}]

  Mike:

In UD, UniObjects doesn't hit the LOGIN paragraph (verb) but it does hit

the "UOLOGIN" globally cataloged item.  One can control a lot from this 
program.  I'm guessing UV has the same thing.

Bill

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Auto logout time {Unclassified}

[HENDERSON MIKE, MR]

Kate,

IIRC UV Objects don't go through the login paragraph, the auto logout
time is in the unirpcservices file (in your local equivalent of
C:/IBM/unishared/unirpc/)


Regards


Mike


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton
Sent: Wednesday, 2 December 2009 10:36 a.m.
To: U2 Users List
Subject: [U2] Auto logout time

On Windows UniVerse 10.1.18 (and many versions before, I think), using
UV 
objects.

User goes through a VOC PA executed when loggin  in, including statement

AUTOLOGOUT 60.

He wants the user to stay up for much longer than that, so has changed
the 
60 to 360.

It still logs out within the expected 3 hours.

IIRC, there is another place timeout minutes or seconds are set up.
Does 
anyone know what, where?

TIA, Kate

Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
Ph: +64 9 360 5310  Fax: +64 9 376 0750  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
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] U2 being sold! {Unclassified}

[HENDERSON MIKE, MR]

You can indeed say you now have "a Rocket in your Pocket"

And I'm afraid that this rather exactly illustrates the damage to the
products' image that will be done, or has already been done, by this
disposal.

How can anyone take a firm called "Rocket Software" seriously*? 
Sorry, but for me it's instant Zero Credibility for a DBMS vendor.
Maybe it's cultural thing and it'll go down fine in the USA, but I think
it'll go down like a 'cup of cold sick' in the UK & AUS / NZ / RSA
markets

On the other hand, maybe we'll get more emphasis on integration with
mainstream (= Microsoft) products and less on IBM. For example
*   MSMQ instead of MQSeries for reliable message handling, 
*   SQL Server for EDA instead of DB2, 
*   Windows Server 2008 the first and principal port of a release,
then Linux, then AIX & other niche O/Ses?


Regards


Mike


* OK, I'll concede it might be an acceptable name for a missile guidance
software company, but this ain't them

-Original Message-
From: u2-users-boun...@listserver.u2ug.org On Behalf Of Garry Smith
Sent: Wednesday, 16 September 2009 8:28 a.m.
To: victor.hender...@gmail.com; U2 Users List
Subject: Re: [U2] Rocket Change is a coming!


 Now I can say I have a "Rocket in my Pocket"


The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] What Program Am I? {Unclassified}

[HENDERSON MIKE, MR]

Dave,

>From (IIRC) 10.0 onwards, there's the "SYSTEM(9001)" pseudo-variable
which contains the UV CALL Stack.
It's formatted a bit funny, but there may be a routine on the Pickwiki
to make it a sensible format.

HTH


Regards


Mike


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A
Barrett
Sent: Wednesday, 24 June 2009 8:33 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] What Program Am I?

[Snip]

It would be super if it were possible to see the call stack from a
running 
program.  Kind of like the the UV "T" debugger command.  Sometimes I'm 
just wondering, "How the hell did I get *there*".  Or I'll see debugging

output in the &PH& file and I wonder, "What program is that from?".  In 
those cases it would be useful to have the call stack sitting beside the

output in the &PH& file.

Does anybody know a way to do this?  I've even considered building a 
little $INCLUDE snippet that updates @USER1 or a named common area and 
recompiling ever server side program with it added. 

Any help will be greatly appreciated.

Dave Barrett,
Lawyers' Professional Indemnity Company
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Odd permissions error running a vb script using dos /c command {Unclassified}

[HENDERSON MIKE, MR]

Or you could try using the "UVRunCommand()" function instead of "dos
/c".
This was introduced (in 10.1 IIRC) as a result of an E-case I opened,
but is documented only in the 10.2 GCI manual.
 
Usage is:

!---
---
 
  DECLARE GCI UVRunCommand
 
!---
---
 
  DOSString = 
  MyStatus = UVRunCommand('c:\WINDOWS\system32\cmd.exe /c
':DOSString)

  IF MyStatus NE 0 THEN
 
  END

!---
---
 
The major advantage of "UVRunCommand()" over "DOS /c" is that it handles
quoted strings correctly. "DOS /c" scrambles a quoted string.
 


Regards 


Mike 


From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Tuesday, 2 June 2009 11:30 p.m.
To: 'U2 Users List'
Subject: Re: [U2] Odd permissions error running a vb script using dos
/ccommand



Hi Dave
 
It should take the permissions of whatever user you have logged into
UniVerse with.
At the risk of asking the obvious, have you logged in as that admin
user?
 
Also, it shouldn't make any difference but do you get the same error if
you create a verb pointer directly to CSCRIPT.EXE instead of shelling
via DOS /C ?
 
Brian 




From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Greer
Sent: 01 June 2009 19:40
To: u2-users@listserver.u2ug.org
Subject: [U2] Odd permissions error running a vb script using
dos /c command


 
I have a vb script that updates a filezilla configuration file
on another server given a username and password. Universe 10.2 is
running on a Windows 2003 Server. The Universe Server has administrator
permissions on the other server. If I run the script from the windows
command line of the Universe server, it works perfectly. If I run the
script from TCL or execute it from Unibasic it throws up a permissions
error pointing to the write line of the vbscript.

When running from the windows command line, I'm running:
cscript.exe d:\newage\createftp.vbs "Username" "Password"

From UV, I'm running dos /c cscript.exe createftp.vbs "UserName"
"Password"

Windows messages are:

Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights
reserved.

[Create FTP v2005.2.0]

D:\NEWAGE\CREATEFTP.VBS(542, 3) Microsoft VBScript runtime
error: Permission denied


 


The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

RE: [U2] encode to base64 in universe? {Unclassified}

[HENDERSON MIKE, MR]

You mean apart from

MyStatus = ENCODE('Base64', '1', InputData, '1', EncodedData, '1')


Regards


Mike


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of doug chanco
Sent: Wednesday, 6 May 2009 9:09 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] encode to base64 in universe?

Short of writing my own encoder function is there any other way to 
encode a pick item to base64?

thoughts/suggestions/ideas welcomed!

OS - AIX 5.x
universe 10.2.x

thanks

dougc
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Record Size Limit in UV {unclassified}

[HENDERSON MIKE, MR]

Adam,

I hate to contradict you, but the system *HAS* outgrown its design!
In a previous job, we had the exact same problem with serialised stock,
and eventually we had to bite the bullet and re-architect with a
more-normalised 'traditional SQL' joining table instead of embedded
multi-values.

We ended up with a table with attributes (IIRC) of
** as ID, Stock #, Serial #, Order #,
Line #. We may even have stuffed Customer # in too, as a de-normalised
performance-improver on reporting, I can't remember now, it was quite a
few years ago. And several UV indices to give access reasonably quickly.
The pain was significant, and the system became probably on average a
tiny tad slower - not enough for users to notice, though. The change did
stop the l-o-n-g pauses, which users certainly did notice, while UV grew
a record from a very large size to a little bit larger to add another
serial number to a sales record. 


YMMV as usual


Regards


Mike

 

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org On Behalf Of Adam Taylor
> Sent: Friday, 24 April 2009 10:57
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Record Size Limit in UV
> 
> Our scenario isn't so much outgrowing its design as expanding 
> upon its design.  Basically what happened was due to 
> accounting requirements, we had to make a change to our 
> company's inventory process to move it from a mixture of 
> serialized parts (for large-ticket items) and non-serialized 
> parts (for small-ticket items) to have everything be 
> serialized.  Combined with the fact that some of the orders 
> our customers place have line items with small-ticket items 
> where quantities range into the multiple thousands, this 
> causes very large amounts of data to be stored in the serial 
> number field of the records.
> 
> We are already seeing a performance hit in certain areas with 
> these instances.  Fortunately they are not completely common 
> occurrences, but they do occur frequently enough that we have 
> had two or three instances of connections timing out on some 
> of our users since we made the conversion three months ago.
>  
> Adam Taylor
> Program Manager
> 713.795.2352
> www.INXI.com
> 
> 
> 
[snip]
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV 10.1.22; Dynamic File question {Unclassified}

[HENDERSON MIKE, MR]

RESIZE  DYNAMIC GROUP.SIZE 2 MINIMUM.MODULUS  

I think the manual says this doesn't work but it does, on Windows
anyway.
Usual caveats about resizing files apply!
YMMV

Regards


Mike

 

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org 
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Allen Egerton
> Sent: Friday, 24 April 2009 07:39
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UV 10.1.22; Dynamic File question
> 
[snip]
> The situation is that I'm potentially adding a million 
> records to a dynamic file.  That's not hypothetical, it's a 
> real life scenario.  And I don't want to wait while the file 
> splits multiple times over the course of the add.  I don't 
> have that large a window.  I want to force the file to expand 
> the weekend before so that when I add the records the file 
> isn't rebuilding.
> 
> The file's already dynamic, so setting Minimum.Modulus 
> doesn't seem to do me much good unless I can figure out how 
> to force it to split to that minium.modulos.  And there's the 
> crux of my question.  How can I force it to split?
> 
[snip]
> 
> --
> Allen Egerton
> aegerton at pobox dot com
> PGP Key ID 0x8EA57261
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Denver IBM U2 Office Closed due to Blizzard {Unclassified}

[HENDERSON MIKE, MR]

Yes, fine and warm - low twenties Celsius - Napier, Art Deco capital of
the world.
New Zealand 4/393 against India, an hour into day two of the second Test
match.
Wish I was there instead of stuck in a Wellington office! ;-)


Regards


Mike


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Ritchie
Sent: Friday, 27 March 2009 11:25 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Denver IBM U2 Office Closed due to Blizzard

If it makes anyone feel any better it's fine and sunny here in Sydney,
though
we might get a touch of rain duing the day :)

Across the Tasman they can inform me the cricket is underway on Day 2 in
Napier with clear skies.



-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Garry Smith
Sent: Friday, 27 March 2009 8:56 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Denver IBM U2 Office Closed due to Blizzard

At first glance - Denver IBM U2 Office Closed..

Wow the economy has really tanked :) 


Garry L. Smith
Dir Info Systems
Charles McMurray Company
V# 559-292-5782   F# 559-346-6169

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Glen Batchelor
Sent: Thursday, March 26, 2009 2:45 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Denver IBM U2 Office Closed due to Blizzard

 It's a blast here @ the hotel. If I could snowboard I'd take
it out to the Prominade and run across the bridge. Hopefully our 8am
flight is on-time and the roads are clear enough for us to drive the
rental car back to DIA. :/ This is the most snow I think I've ever seen!

GlenB

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org]on Behalf Of Stephen O'Neal
Sent: Thursday, March 26, 2009 12:44 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Denver IBM U2 Office Closed due to Blizzard


Enough said.   It's got to be bad if the office closes.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Does anybody have a hot backup server? {Unclassified}

[HENDERSON MIKE, MR]

Wol / Wally T / Anyone

Can you please specify what was the earliest version of UV that includes
the dynamic files "headers are flushed when they are updated" feature?

For a site with lots & lots of dynamic files and planning a UV platform
upgrade anyway, this would be a big pointer in determining the release
to move onto.


Regards


Mike


-Original Message-
> From: owner-u2-us...@listserver.u2ug.org On Behalf Of Anthony W.
Youngman
> Sent: Friday, 20 March 2009 5:43 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Does anybody have a hot backup server?
> 
> Manu Fernandes  writes
[snip]
> >One restriction, we don't use DYNAMIC files because the headers are
not 
> >permanently flushed when write occurs files.
> >
> I believe (iirc) IBM have confirmed that, as of the latest versions of

> UV, the headers are flushed when they are updated so dynamic files are

> now safe ...
> 
> Cheers,
> Wol
> -- 
> Anthony W. Youngman 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Does anybody have a hot backup server? {Unclassified}

[HENDERSON MIKE, MR]

Jeff

UniData or UniVerse?
>From a very limited understanding, I think UD has a 'better' native
answer at the moment. I think Ken Wallis (on this list) did something
along those lines some time ago for a large Australian utility company. 

Or you could go the external route, where you use SAN replication from
one site to another. I know of at least one site that's thinking of
doing that with EMC SANs.


Regards


Mike


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Powell
Sent: Thursday, 19 March 2009 8:07 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] Does anybody have a hot backup server?

I am trying to put together a backup strategy that involves keeping a 
standby server within two data hours of the primary. The idea is to be 
able to have users log into the backup server and keep the business 
running in the event of a crash.

I'd like to hear what solutions others have found for this.

I've been trying to contact IBM for the last 6 months but they haven't 
answered and my ERP vendor doesn't know how to do this.

Any ideas are appreciated.

TIA
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] time Verb {Unclassified}

[HENDERSON MIKE, MR]

"Why do people [with NT systems] change the system time to deal with
daylight savings changes?" 
Because that's the way MS-DOS did it.
On Unix systems, the hardware clock runs in UTC, and the TZ variable is
used to determine the difference between UTC and local time (including
allowing for daylight Saving if appropriate), and local time is output
by the various utilities.
On MS-DOS systems, and their 'Windows' heirs and successors, the
hardware clock is the direct source of system time, so it runs local
time. The new-fangled (Windows95?) automatic time zone management simply
writes a new value into the hardware clock on the motherboard on
'flip-over' from summer to winter time.
As I understand it, even Vista and Windows Server 2008 still work that
way.
Horrible.

[Digression: I wonder how a VM-ed Windows environment copes with that?
Can you have different VMs in different Time Zones on the same real
host? Can you use VMs to 'time travel', by setting the date/time on one
VM to a completely different value to another and/or to the real time on
the host?]


Regards


Mike


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Ken Wallis
Sent: Tuesday, 10 March 2009 10:00 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] time Verb

Why do people change the system time to deal with daylight savings
changes?
On unix systems you just have to set the TZ environment variable
correctly -
for example the AIX patches associated with this just change the default
TZ
settings for certain zones.

On Windows there is a utility called tzedit.exe that came with NT and
which
has to be googled for on later versions which lets you change the
relevant
registry settings.

Cheers,

Ken

-Original Message-
From: On Behalf Of George Gallen

Our unix system does the same thing. (older unix that thinks we are
still doing daylight savings shift on the old date). UV is showing
the same time as the unix time.

So, if the NT reset it's time, you might need to shutdown UV, then
restart it, for it to get the correct system time from NT, unless you
have an old version of NT as well (unpatched), so NT has the incorrect
system time as well??

George

> -Original Message-
>
> I am using an old version of UniVerse on a NT, this morning when I
> changed the
> system time to adjust for Daylight savings time the UniVerse time is
> not 1
> hour behind. Anyone know if there is a fix?
> I poked around and didn't find a way to adjust it. So I reset the
> system time
> so that the UniVerse time is correct.
>
> Dave R
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: RE: [U2] Universe Index still not working {Unclassified}

[HENDERSON MIKE, MR]

Roger,

Two possibilities occur to me:-
* How big is that Index file - it's not getting close to 2GB by any
chance?

* Maybe it's getting confused between numbers and strings somehow: would
something that works like SELECT FILE WITH " ":INVOICE EQ "
0499906608.1" [You could make a new I-Type called SPACE.INVOICE to do
this and build a new Index]?

Pretty much grasping at straws


Regards


Mike


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
ro...@optonline.net
Sent: Thursday, 5 March 2009 8:11 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: RE: [U2] Universe Index still not working

Yes, I was retyping, rather then cut and paste.

Actual ids are co*custno*type.invoicemain.invoicesub
Key INVOICE
01*165001*IN.0499906608.1   0499906608.1
dictionary = 0002: FIELD(FIELD(@ID,'*',3),'.',2,2)
old dictionary = 0002: FIELD(@ID,'*',3)[4,999]

both outputted what we needed.   the old one was used for longer then
I've been at this company.   I tried changing it just in case.

I really don't think it is dictionary related, since we did not change
it until after the index stopped working.

btw: for those that don't know
SELECT FILE WITH INVOICE EQ "0499906608.1" NO.INDEX tells the command to
skip the indexes and just go through the file.
SELECT FILE WITH INVOICE EQ "0499906608.1" will go first to the index
created for INVOICE.  Hence the speed and why people use indexes but
also the reason why we 'know' that something is broken in the index.
If skipping the index works, doesn't that suggest something is wrong
with the index?

Thanks
Roger






- Original Message -
From: kishor 
Date: Wednesday, March 4, 2009 1:56 pm
Subject: RE: [U2] Universe Index not working
To: u2-users@listserver.u2ug.org

> Shouldn't dictionary #2 
> Be FIELD(FIELD(@ID,'*',2),'.',3,2)
> Instead of
> FIELD(FIELD(@ID,'*',3),'.',2.2)
> 
> This will return
> 1123.2
> 
> Don't know why some selects worked.
> 
> Regards,
> Kishor Parmar
> 
> 
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of 
> ro...@optonline.netsent: 04 March 2009 17:37
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Universe Index not working
> 
> AIX 5.3 Universe 10.2.4 300+ user license
> 
> Moved from older aix/universe 9.5 to current one in September 2008.
> No index problems.
> 
> File contains 1.5 million records. key = company number * customer
> number.xx.invoicenumber.invoicesubnumber.
> so the key looks like
> 01*123456.IN.1123.2
> 01*123456.IN.1123.3
> 
> The invoice number should be unique, except for the subnumbers.
> dictionary #2 - FIELD(FIELD(@ID,'*',3),'.',2.2)
> 
> On Monday, SELECT FILE WITH INVOICE EQ "1000123.2" found 0 
> records. Other
> SELECTS seemed to work. The keys are clean, no special characters.
> SELECT FILE WITH INVOICE EQ "1000123.2" NO.INDEX finds 2 records?
> 
> I did a build.index file on Tuesday morning. didnt work.
> Late Tuesday evening, I deleted the index and recreated it and 
> then rebuilt
> it. didnt work.
> I also copied the contents of the file and the dictionaries from 
> one file to
> a new one. recreated and rebuilt the index. so no luck.
> 
> There are no error messages. nothing reported when files were 
> copied. same
> number records before and after.
> 
> Any thoughts?
> Tonight I'll try a universe shutdown and restart.
> 
> Thanks.
> Roger Glenfield
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Inter-Process Control... {Unclassified}

[HENDERSON MIKE, MR]

Tom,

I don't think that 'maintaining a lock manager' is necessarily a good
solution to non-persistent connections. 

A more conventional approach is for each connection to maintain the
state of the record(s) it was going to modify - i.e. a 'before image'.
Then, when it's time to apply the transaction, you lock the records
(READU), and check that the records now on disk are in the same state as
their before images. If they are, you can safely overwrite them. If they
are not all the same as before, you unlock them and tell the user that
someone else has changed the data and bad luck, please start again. This
is known as the "optimistic locking" design philosophy.

You also need a Phantom process to go through and clean out all the old
'before image' data that users never came back to.


Of course, if you get too many oops-somebody-else-changed-it collisions,
you may need to use persistent connections or a re-architecting of the
data and/or application to reduce the frequency of collisions.


Hope this helps


Mike


-Original Message-
From: owner-u2-us...@listserver.u2ug.org On Behalf Of Tom Whitmore
Sent: Friday, 27 February 2009 11:21 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Inter-Process Control...

One example of what I'm trying to do is develop a record lock manager
(for the lack of a better description) for non-persistent connections.
I need the lock manager to wakeup when there is a request for a
readu/write/delete.  The all the "responders" would need to send
requests to the "lock manager".  We have other processes that could use
this functionality as well.

I hope that helps,
Tom

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
iggch...@comcast.net
Sent: Thursday, February 26, 2009 4:09 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Inter-Process Control...

Hey Tom,



Are you trying to do something like...



Program A

B B B B  DONE = 0

B B B B  LOOP

B B B B B B B B B B  GOSUB ;* PROCESS STUFF

B B B B B  UNTIL DONE DO

B B B B B B B B B B B  IF SOME.EVENT THEN

B B B B B B B B B B B B B B B B  LOCK 10;* WAKE UP PROGRAM B

B B B B B B B B B B B B END

B B B B B B B B B B B  LOCK 11 THEN

B B B B B B B B B B B B B B B B B B B B UNLOCK 11

B B B B B B B B B B B B END ELSE

B B B B B B B B B B B B B B B B B B  UNLOCK 10;* PROGRAM B FINISHED

B B B B B B B B B B B  END

B B B B B B B B B B B B SLEEP 30

B B B B B B  REPEAT

B B B B B B B STOP



PROGRAM B

B B B B B B B DONE = 0

B B B B B B  LOOP

B B B B B B B B B B B B B  LOCK 10 THEN

B B B B B B B B B B B B B B B B B B B B  UNLOCK 10

B B B B B B B B B B B B B B ENDB ELSE

B B B B B B B B B B B B B B B B B B B B  LOCK 11

B B B B B B B B B B B B B B B B B B B B  GOSUB ;* PROCESS STUFF

B B B B B B B B B B B B B B B B B B B B B  UNLOCK 11

B B B B B B B B B B B B B B  END

B B B B B B B  UNTIL DONE DO

B B B B B B B B B B B B B B  SLEEP 30

B B B B B B B  REPEAT

B B B B B B B B STOP




- Original Message -
From: "Tom Whitmore" 
To: u2-users@listserver.u2ug.org
Sent: Thursday, February 26, 2009 12:05:19 PM GMT -06:00 US/Canada
Central
Subject: RE: [U2] Inter-Process Control...

Thank you for all the responses.

I should have stated that we are a UniVerse shop.

I did play with the lock/unlock but the only process that can modify the
lock
is the one that set it. B Also, I could not get the process to wait on
the
lock. B From the playing I did, lock/unlock seems very limited compared
to
what was available 15 years ago.

Thanks
Tom
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe triggers (still more) {Unclassified}

[HENDERSON MIKE, MR]

Susan,

On a Windows system, you can write to the Event Log so that you can at
least leave some 'footprints' when this happens - it's a general problem
when you use Transaction State because it rolls back EVERYTHING which
makes it hard when the transaction has been created from UniObjects.

What I did was to use the "UVRunCommand()" function to call the DOS
function "eventcreate", like this:-
==
DOS.STRING = 'eventcreate /T ':EVENT.TYPE
DOS.STRING := ' /ID ':EVENT.ID
DOS.STRING := ' /L ':EVENT.LOG
DOS.STRING := ' /SO ':QUOTE(EVENT.SOURCE)
DOS.STRING := ' /D ':QUOTE(EVENT.DESCRIPTION)

DOS.STATUS = UVRunCommand('c:\WINDOWS\system32\cmd.exe /c ':DOS.STRING)
==

Notes:
1) "UVRunCommand()" will work in Transaction State, whereas "PERFORM
'DOS \c ...'" won't
2) You can get most of the details on "eventcreate" by typing
"eventcreate /?" at a Windows Command-Line (DOS) prompt.
3) It seems like you can't use the same 'Event Source' string to log
events in more than one of the System and Application Event logs
4) Works on Windows XP, Windows Server 2003 and Windows Server 2008.
Probably works on lots of Windows platforms, I just haven't tried it.
5) I wrapped all the code in a called SUBROUTINE so I could put in
sensible defaults etc.


YMMV and non-Windows platforms will obviously require different
solutions


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Wednesday, 3 December 2008 2:16 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe triggers (still more)

Thanks to the folks who gave me info on Unidata triggers.  I've had
those
implemented for years and they do work very simply and well.  Universe
has
been a whole different ballgame.

It turns out that Universe has cleverly adapted the triggers from SQL.
I
say cleverly because it probably really is on some esoteric mathematical
level.  And certain from a viewpoint of 'using what you have'. But for
an
old Pickie like me it has been very foreign.  Also they have made use of
the
Begin Transaction business - so that the writes can be rolled back using
that existing logic, I reckon.  Again, good re-use. But this is also an
area
that I'm not familiar with.  

The three problems that I had were with:
1) The SB+ COMMON block - this was resolved by adding $OPTIONS PICK to
the
trigger program - and to all the programs down the line that it called.

2) WRITES requiring locks: The Begin Transaction relies on a system
variable
called ISOMODE which can be set to 0,1 or 2 to control how rigorous the
locking requirements are - as part of the 'transaction/rollback' stuff.
I
was able to get my programs working by making sure I had a READU before
each
WRITE (which I didn't have in some cases - where I had decided in my own
wisdom that it was safe not to do it - audit logs, new items, etc.) but
I
can't get into the SB+ code and the authors thereof were also of this
same
wisdom.  But it turned out that by using Uniadmin to set ISOMODE to 0,
this
problem was alleviated.
 
3) Last, I wanted to be able to control whether the write should occur.
I
can do it - the manual was not clear on the syntax and I kept thinking
there
was something more, but apparently as long as I put:
DUMMY = SetDiagnostics("This message is about why the item cannot be
written"), the trigger will fail the write and display that message. I
don't
display that message, I don't use the variable DUMMY, I don't set any
particular flag.  The display and the failure to write is not pretty.

4) One thing I cannot overcome is that the triggers in Universe will not
permit any interaction.  So my program can't explain to the user why it
doesn't think they should write and then allow them to make a decision.
It
throws them back into their item, though, so I guess they can save the
item
somewhere else or something from there.

Again, thanks to Manu in particular who has obviously fought the exact
same
battle - and to those of you who offered up the "how to" in Unidata.
You
are so lucky you are doing it in Unidata!

Hope this helps someone else, some day.

Susan Joslyn
SJ+ Systems Associates, Inc.
PRC(r) Complete software development life-cycle management for U2.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.

RE: [U2] biztalk adapter {Unclassified}

[HENDERSON MIKE, MR]

There are simple, but rather crude and nasty, ways of doing this.

The most obvious is to use the BizTalk 'file' adapter, with the target
BizTalk directories described as UniVerse Type 19 files.
The UniVerse 'send' process drops XML messages as 'records' in the Type
19 file into the directory for BizTalk to pick up.
The universe 'receive' process is a phantom that monitors the receiving
Type 19 file for incoming XML messages which it parses and processes.

I would recommend that the 'sending' directory has a parallel 'sent'
directory and the BizTalk orchestration which grabs the file moves it
from 'sending' to 'sent'. Similarly the UV process that receives
messages should move them into a 'received' directory. These measures
allow auditing and re-playing of messages as may be needed.


HTH


Mike


> From: Bob Witney
> I am happily going from aix5.3 running universe 10.2 to ms sql via MS
> BizTalk, works fine
> 
> Does anyone have knowledge of a BizTalk adapter (ms don't 
> have one) that will le me go the other way?
> i.e. BizTalk to Universe
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] using distributed files with multi level data files possible? {Unclassified}

[HENDERSON MIKE, MR]

UV/Net doesn't handle Distributed Files (32- or 64-bit) - it's a
published 'feature'.
You have to refer to the individual part files.

Actually, that seems like a good Better-and-Better submission ...


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Thursday, 16 October 2008 11:26 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] using distributed files with multi level data
files possible?

We decided to try (64bit Type30 on 64bit OS) part files on a couple of
large transaction files because it made archiving easier for us. We
could just drop off a chunk at a time.
However, we've since discovered that part files can't be used with
SBClient SmartQuery because it uses S/REFORMAT verb.
As far as I know we haven't had any problems with UVNet on 64bit dynamic
files on our (thirty) 2 bit Windows platforms.
Stuart

>-Original Message-
>We have a few distributed files on UV 10.1.18 on Windows 2003 32 bit.
>64-bit files would be better but I thought there were limitations in 
>their use on a 32 bit OS, especially with DYNAMIC files?
>
>I seem to remember from the UV internals course that UV/Net can have
>problems accessing the file. Does this ring a bell with anyone?

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] using distributed files with multi level data files possible? {unclassified}

[HENDERSON MIKE, MR]

Troy,

You _can_ use 64-bit files on 32-bit Windows 2003 Server, NTFS is quite
happy with files over 2GB. 

I would describe multi-level files as an 'old' way of getting some of
the same functionality as you get with UV Distributed files.  You could
have STOCK,HIST1 and STOCK,HIST2 ... if you wanted to keep more History.
Or maybe STOCK,HIST06 STOCK,HIST07 STOCK,HIST08 for 2006, 2007 & 2008?

If you want to use Distributed Files, I think you'll have to lose the
multi-level concept.



Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy
(Logitek Systems)
Sent: Tuesday, 14 October 2008 10:36 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] using distributed files with multi level data files
possible?

Running Universe 10.0.17 on Windows Server 2003 32bit:



Can I create a distributed file for a data file that is part of shared
dictionary (ie a multi-level data file)?



I can't seem to get the syntax right.



Here is the scenario.  We have a large stock file with current
transactions called STOCK that contains about 2 years of transactions
and a growing history file with data copied from STOCK,STOCK to
STOCK,HIST on a semi-annual basis.   We've had to limit this STOCK,HIST
file to about 2 years because of the 2GB limit.



We are on Windows Server 2003 32bit and cannot create 64bit files, so
I'd like to implement a distributed file for this STOCK,HIST and copy in
about 4 to 6gb of older (offline) history data into it.



Since the records are pure numeric and sequential I was going to create
10 part files and use the partitioning algorithm as INTERNAL
"@ID[LEN(@ID),1]+1".



What would be my steps and syntax to do this?



>From my research, I have been successful at using DEFINE.DF, etc to do
this at the primary datafile level like STOCK (aka STOCK,STOCK) but not
when I reference a sub data file off of STOCK (like STOCK,HIST) it blows
up.  Sample below using similar names:



Creating the files work fine:



:CREATE-FILE TEST.STOCK 1,1 101,1

:CREATE-FILE TEST.STOCK.HIST.PART1 1,1 101,1



Then using the following to associate TEST.STOCK,HIST with the first
part file fails:



:DEFINE.DF DATA TEST.STOCK,HIST ADDING TEST.STOCK.HIST.PART1 1 INTERNAL
"@ID[LEN(@ID),1]+1"



I get:



DICT and PDICT are not legal keywords with multilevel DATA files.

File not created.



If I leave out 'DATA' above, no difference.



All of the existing applications software and dictionaries reference
STOCK (comma) HIST or I'd just rewrite this as a new data file like
STOCK (DOT) HIST and be done. This may end up being the work-around if
this just won't work.



Either multi level data files are not supported or I'm not getting the
syntax correct.  Any help would be much appreciated!





-Troy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Saving Photos {Unclassified}

[HENDERSON MIKE, MR]

Bill,

Or you can use the UniVerse ENCODE() function to turn the binary
photograph data into a Base64 "MV-safe" form on input for storing in a
regular UniVerse file, and back into the original form for output.
And IIRC, the un-ENCODEing process arbitrarily inserts CHAR(10) every
76(?) characters. That was early in 10.0, things may have changed.
Testing is definitely required!

The Base64 ENCODEd string is about one-third larger than the original -
three bytes of input are transformed into four bytes.

HTH

Regards


Mike


-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Scott Ballinger
Sent: Thursday, 9 October 2008 7:34 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Saving Photos

Bill,

I do this for JPEGs, TIFs,  PDFs, etc, by just storing the filename in
the
database. The actual BLOB file remains stored in the host O/S
filesystem.
You may need to work out your own simple hierarchial directory structure
to
limit the number of files per sub-directory; in my case I typically
assign
the BLOB file a sequential name, e.g. 1234999.pdf, then store a maximum
of
1000 files per directory as .../1234/1234999.pdf.  A standardized
subroutine
calculates and returns the path to the file based on it's name.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006

On Wed, Oct 8, 2008 at 11:01 AM, Brutzman, Bill
<[EMAIL PROTECTED]>wrote:

> Is there a way to save a file with a photograph in a U2 database?
>
> I seem to remember the idea of a BLOB (Binary Large Object) data type
in
> say MS-SQL.
>
> Suggestions would be appreciated.
>
> --Bill
> ---
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Universe license usage per account {Unclassified}

[HENDERSON MIKE, MR]

Peter,

You don't have licenses per account, only per UniVerse system instance. 

The maximum UV licensed users count is available in SYSTEM(36).
The number of licenses currently consumed is available in SYSTEM(35).


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Peter Veenhof
Sent: Friday, 26 September 2008 8:06 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Universe license usage per account

Hi,

I was wondering if anyone knows a way to extract the number of
licensed users (or rather licenses in use) for a specified Universe
Account?

Thanks
Pete
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] uniVerse COPY command and the UVTEMP directory {Unclassified}

[HENDERSON MIKE, MR]

I have come across this limitation before, too.
One work-around is to use READSEQ and WRITESEQ, that seems to work OK
even when COPY and ED fail.

Also, the item size limit on the Windows implementation of UV was much
larger than that on Unix last time I participated in a conversion (it
may even have been unbounded). Code that worked OK on Windows failed on
HP-UX, so we had to change to use READSEQ/WRITESEQ. 
Heh, Windows better than *ix?
=O
 ;-)

Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel
Sent: Thursday, 18 September 2008 9:46 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] uniVerse COPY command and the UVTEMP directory

That happens to me all the time when I try to COPY a &HOLD& file/record
to
another directory. My reports are often 230mb or larger.
I asked IBM, and they said "COPY always had a size limit."  Can't ED it
either, as Dan observed.

So I just wrote a program to select the records, and copy them using the
unix cp command.
Then I list them using the unix ls command to make sure they were
copied.

-- Louie

0001:   COMMAND = \SELECT REPORTS WITH START.DATE =
\:OCONV(@DATE,"D4/")
0002:   DISPLAY COMMAND
0003:   EXECUTE COMMAND
0004:   LOOP
0005:  READNEXT COPY.HOLD.ID ELSE COPY.HOLD.ID = ''
0006:   WHILE COPY.HOLD.ID
0007:  COMMAND = \sh -c "cp -r
'/sam/hill/&HOLD&/\:COPY.HOLD.ID:\'
/sam/hill/HOLD.TODAY/\:
 COPY.HOLD.ID:\"\
0008:  DISPLAY COMMAND
0009:  EXECUTE COMMAND
0010:  COMMAND = \sh -c "ls -l
/sam/hill/HOLD.TODAY/\:COPY.HOLD.ID:
\"\
0011:  DISPLAY COMMAND
0012:  EXECUTE COMMAND
0013:  DISPLAY
0014:   REPEAT
0015:END
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] CAPTURING TOXML {unclassified}

[HENDERSON MIKE, MR]

At UV 10.1 
XMLExecute() is documented in the Basic Extensions and 10.1 New Features
manuals.
At UV 10.2
XMLExecute() is documented in the Basic Extensions and Basic Reference
(BasicRef.pdf) manual

However, in three out of the four of these manuals the documentation is
WRONG - they say it takes two parameters, actually it takes four. The
only one that is correct is the 10.2 Basic Reference. 
The XMLExecute function is also used in BP GETXMLSUB in the UV account,
that's where we found out what the correct parameters are. It was our
VAR who eventually pointed out the one place it's documented correctly

Note: You have to call it "XMLExecute", "XMLEXECUTE" doesn't work, this
XML stuff is a bit picky


* * * HOWEVER * * *
Once we got it going , we found it is five times faster than "EXECUTE
... TOXML"
Yes that's right, a program with the function runs in one fifth of the
elapsed time of a program otherwise identical except using "EXECUTE
...". So, well worth the aggravation!
This is on 10.1.18 / Win2003, YMMV


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns
Sent: Sunday, 27 July 2008 11:07 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] CAPTURING TOXML

You may like to investigate XMLEXECUTE() which allows you to get around
a lot of your difficulties.

I cannot remember how we found this and I can not find any useful
references in the documentation.  Maybe someone else knows where this is
documented.  I have had a quick look and found some references on Google

Sara Burns


IS Development Manager

Public Trust
Phone: +64 (04) 978 4534 (DDI)

Mobile: 029 978 4534


---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Getting daily data from SAP from Universe {Unclassified}

[HENDERSON MIKE, MR]

John

"2nd problem is actually getting access to SAP table names, data
definitions etc."
As I understand it, the SAP Table names are in SAP (German) code, and
the column names are in SAP code. Then there is another set of tables -
also named in SAP code, of course - which provide translations between
the SAP column names and .

Oh, yes, it's as complicated as heck. That's how SAP consultants make
all their money, and why you need them. The data may be more easily
accessible in something like SAP BW, provided you bought that.


"The only known I have at the moment is that they can send me
spreadsheets"
Which are possibly produced by a point-and-click GUI, so the user will
have no idea of the underlying data structures.
Or by some customised ABAP reporting, see 'SAP Consultants' above.


The easiest and most cost effective mechanism may even be to read in,
parse and consume the spreadsheets. 

Sorry


Regards


Mike

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Friday query logic {Unclassified}

[HENDERSON MIKE, MR]

Try "WHEN" not "WITH" 

LIST APOPEN WHEN(ACCTS UNLIKE "52..." AND ACCTS UNLIKE "29...") etc


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathleeni M 
Hunter
Sent: Wednesday, 25 June 2008 12:23 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic

If this is not working, create a dictionary item that does the 
evaluation you want and have it return a 1 if it meet the condition and a 0 if 
it does not.

Dictionary would look like 

IF FIELD[1,2] # "SF" OR FIELD[1,2] # "SH" THEN 0 ELSE IF
CONVERT("SH","",CONVERT("SF","",OCONV(FIELD,"MCA"))) # "" THEN 0 ELSE 1


Then you would be a select based on this dictionary be equal to a 1.


-Original Message-
From: Eric Armstrong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 1:17 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic

Bill,
Sorry for not responding sooner, but I agree with the comment below. It should 
work! So if it doesn't, we have to step back and start asking other questions.

Eric


-Original Message-
From: JPB-U2UG [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 11:24 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic


I take it that you checked to make sure that the fields were associated so 
let's take a different look. Are the values separated by value marks or 
sub-value marks? What does the dictionary contain? What does the record below 
look like in the editor?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Tuesday, June 24, 2008 12:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic

Eric:

That doesn't work either.

list APOPEN WITH ANY ACCTS UNLIKE "52..." OR WITH ANY ACCTS UNLIKE "29..."
INVDATE
COMMENT ACCTS AMTS
APOPEN INV-DATE DESCRIPTION ACCT. ACCT/AMTS

58*6-4 06-01-08 LOAN #123456, 06/2008   5230246.04
2910  1,025.50
2365 61.08
2980273.70
5230 50.00

I wouldn't have expected this to work anyway because every MV meets one or the 
other of the criteria.  The dicts ACCTS and AMTS are associated with each other.
I would
have expected the following to work though:

list APOPEN WITH ACCTS UNLIKE "52..." AND WITH ACCTS UNLIKE "29..." INVDATE 
COMMENT ACCTS AMTS APOPEN INV-DATE DESCRIPTION 
ACCT. ACCT/AMTS

58*6-4 06-01-08 LOAN #123456, 06/2008   5230246.04
2910  1,025.50
2365 61.08
2980273.70
5230 50.00

Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] "blink questions" {Unclassified}

[HENDERSON MIKE, MR]

"uvNet - ... Does CONFIG show it when it is installed?"

Sure does
---
>CONFIG
Configuration data for license number :
User limit =20
Expiry date=1/1/2500
-UVNET  package is installed.
User limit =   . Expiry date = 1/1/2500
-GCIpackage is installed.
User limit = 20. Expiry date = 1/1/2500
-UCIpackage is installed.
User limit = 20. Expiry date = 1/1/2500
-UVCS   package is installed.
User limit = 20. Expiry date = 1/1/2500
-UVADM  package is installed.
User limit = 20. Expiry date = 1/1/2500
-UVODBC package is installed.
User limit = 20. Expiry date = 1/1/2500
-iPHANTOM   package is installed.
User limit = 20. Expiry date = 1/1/2500
>


So does your license fee bill 
:-(

But it's the only 'no thinking required' method to copy data from one
running UniVerse instance to another. If you need it, you REALLY NEED
it!


Regards


Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Tuesday, 13 May 2008 8:44 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] "blink questions"

Henry,

If you're lucky the file fixing utility uvfixfile may repair it: type
HELP uvfixfile for details. For anything other than automatic fixing you
need to find some expertise or get the backup out.

If you're really lucky, you might (might) get the content out by using

RESIZE filename * * *

This creates a new copy of the file with the original sizing parameters.
It's worth a try.

UniVerse has filepeek which allows you to modify the structure, but it
requires some expertise. 

But to reiterate - NEVER copy records between instances of UniVerse over
shares (samba or nfs, makes no difference). My personal would be to
write a simple .Net program to read from one server and write to the
other over UniObjects connections.

I don't have a copy of uvNet - so maybe someone can assist. Does CONFIG
show it when it is installed?

Regards

Brian
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] UniVerse to PDF {Unclassified}

[HENDERSON MIKE, MR]

List-folks,

I'm sure I've seen someone on this list advertising an 'all UniVerse'
solution to outputting PDF documents from a UniVerse system.
Then, I wasn't interested, so I threw the message away.
Now, I just might have an application for such a technology.

So, if you're in the business of selling something like this, and
supporting it, in New Zealand either directly or through a VAR, feel
free to let me know.

Our UV system, and almost all our infrastructure, is Windows, so a Unix
/ Linux solution probably won't fly.
The application needs to scale between printing a few pages on demand,
and producing a batch of up to ten to twelve thousand of the same-format
documents in a short period (minutes, not hours)


And don't spend the sales revenue yet: this may come to nothing, it's
just a bright idea I had that may demonstrate all the aerodynamic
qualities of a lead brick if / when put to management!
;-)


Looking forward to hearing from you


Mike Henderson
-
Lead Applications Engineer (HR Systems),
Communications & Information Systems Branch,
New Zealand Defence Force






The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Reading data from an SQL Server Database from Universe {unclassified}

[HENDERSON MIKE, MR]

Harold,

If your UniVerse server is Windows, it's not too hard at all:-
Install the UniVerse ODBC Client from the U2 Clients CD on your server
On the server, do to Start > Settings > Control panel > Administrative
Tools > Data Sources (ODBC)
>From the System DSN tab, select Add, choose 'SQL Server', follow the
prompts
The entry you make in the 'Name' box is the one you put in the
uvodbc.config file (instead of "")


If your UniVerse server is *ix, then I think you need a thing called an
"ODBC-ODBC Bridge" which will cost you money and which will need
configuring. But I'm on Windows, so ...

HTH

Regards


Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold
Sent: Tuesday, 15 April 2008 11:43 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] Reading data from an SQL Server Database from Universe

I am simply trying to read data from a SQL Server database into
Universe.

It's all supposed to be explained in the document "BASIC SQL Client
Interface Guide", but am missing one key point, it seems...

One defines the ODBC data source in the uvodbc.config file.  According
to the documentation the only information one puts into this parameter
file are data source name and dbms type.  For example:


DBMSTYPE = ODBC

are two lines in this file.  This says the data source name is 'mysqldb'
and it's an ODBC type of database.  OKfine.

That's it!  For sources which are Universe databases, one also enters a
service type and host. That makes sense.

Well - the SQL Server database I am interested in reading is on another
server. WHERE do I specify the name of the server and the database name?
Is it even possible in Universe to connect to a SQL Server database on
another server?

Thanks for any help on this.


Harold D. Oaks
Sr. Analyst/Programmer
Office of the Budget and Information Systems Clark County, Washington
ph: (360) 397-6121 x4132
fax: (360) 397-2342
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] base64 under Universe 10.2.4/AIX 5.3 {Unclassified}

[HENDERSON MIKE, MR]

Roger,

It has in fact been expertly concealed in the PDF manuals, although of
course not in the table of contents, although if you look in the right
place they are in some but by no means all of the INDEXes. 
The Adobe Reader 'Search' function will, however find the "ENCODE"
function for you.
:-(

Look in the Basic Extensions manual under the obvious chapter heading
"Using SSL with the CallHTTP and Socket Interface" there is "Encoding
and Cryptographic Functions" pages 3-46ff 
Or "Universe Basic Reference" (that's the one in 'BasicRef.pdf', not the
one in 'Basic.pdf' and before you ask, no, I've no idea either) on page
251 of the 10.1 version.

A triumph of the documenter's art this is NOT


Probably worth a quick troll through the APP.PROGS and BP files in the
UV Account for some examples, you may get lucky



Regards


Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, 2 April 2008 10:08 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] base64 under Universe 10.2.4/AIX 5.3

I'm trying to convert a standard Pick data string into base64 format.
I don't need to encrypt, just convert to base64 to take off the 'edges'.

Googling has found references to a new universe basic command, ENCODE,
but my current manuals, pdf version 10.2, dated September 2006 don't
list the command.  And HELP BASIC ENCODE don't do me any good. 

BTW Support.HELP BASIC ENCRYPT doesn't work either.

Thanks for any help.
Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] RE: UNIDATA 7.1 performance measures {Unclassified}

[HENDERSON MIKE, MR]

For what it's worth, that's why when we recently upgraded out UniVerse /
Windows2003 Production server, I specifically said "don't get more than
4GB". To use more than that, with a 32-bit Windows platform, you need to
use the /PAE and /3GB switches. I think you may also need to use Win2K3
Enterprise or DataCenter versions. I didn't want to make our UV server
the first one in our network to be configured that way, so we 'stayed
small'

If you want to use more than 4GB RAM with Windows, you really need to go
to the Windows Server 64-bit editions, and you'd want to check the
Availability Matrix to see which releases of UD are qualified.

My $NZ0.02


Regards


Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert
Sent: Saturday, 29 March 2008 9:31 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] RE: UNIDATA 7.1 performance measures

Hi Jeff,

 We have since come to realize that the /3gig switch is not for us. What
we are trying to do is be proactive to hopefully avoid a problem
situation. Late last year we were forced to move to the latest version
of the vendor software we use. Under the previous version, our
registration process ran like a charm. It took a while for us to get to
that plateau but once we had achieved it...life was good. This new
software has a number of challenges that we've been able to address
however, this coming month will be the first time we've used it for
student registration. We only recently realized that because we are a
Win2k3 32bit client that is *not* using SQL Server, we really can't take
advantage of some of the advanced memory options available. Because of
the way Windows manages memory, we effectively only have control of
memory in the <4gig window. And to make matters worse, said 4gig window
is sub-divided between user and kernel activities. So after monitoring
system activities using RRDTOOL over a period of time, we realized that
everything we are doing on the app server is crammed into <2.5gig...this
is a 16gig box. We discovered that if our vendors' software had made use
of the AWE API that allows for better memory management, we would be in
a better position...but they don't and we're not. We have run
registration simulations and have discovered approximately when
registration will crash...but we doubt (and hope) we will ever reach
that level of activity.  

 You mentioned UD settings below. Would you mind sharing yours with us? 

Thanks,
Rob Smith
Philadelphia University

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff
Sent: Friday, March 28, 2008 2:22 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] RE: UNIDATA 7.1 performance measures

All the /3gig switch does for you is allow more memory to be available.
You would still need to make settings in Unidata to take advantage of
the additional memory.  Unless I'm getting the /3gig switch confused
with the SQL settings.

I'd also start with turning off hyper threading on the processors if
you're using that just to see if it helps.  Although I'm not sure if 7.1
has these kinds of problems or not.

Jeffrey Lettau
ERP Systems Manager
polkaudio


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert
Sent: Friday, March 28, 2008 11:51 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] RE: UNIDATA 7.1 performance measures



From: Smith, Robert
Sent: Thursday, March 27, 2008 11:37 AM
To: u2-users@listserver.u2ug.org
Subject: UNIDATA 7.1 performance measures



Good Morning,



 We are a UNIDATA shop and presently we are struggling with identifying
the best way to increase the performance level of our environment. We
presently are running UD on a Windows Enterprise server (SP2) with 16gig
of ram and 8 - 3gig processors. We have read through some MS Knowledge
Base articles that suggest a possible performance increase if we use the
/PAE and /3GB boot.ini switches. We were wondering whether anyone has
deployed these settings before and if there were any problems that
resulted...with either the OS or database.



 Does anyone have any suggestions regarding ways to increase UD
performance levels in a Win2k3 environment?



Thanks in advance,

Rob Smith

Philadelphia University
---
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV: LOOP;EXECUTE cmd CAPTURING X; REPEAT fatal memory fault. {Unclassified}

[HENDERSON MIKE, MR]

UV 10.1.18, Windows Server 2003
Using Louie's code without the DISPLAY

Ran over two-and-a-quarter million iterations so far, task memory
allocation for "tl_server.exe" is still 10,344KB, the same as it was
when I started. It also spawns a "SYSTEM" thread which steadily consumes
40KB


Regards


Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel
Sent: Tuesday, 18 March 2008 1:52 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV: LOOP;EXECUTE cmd CAPTURING X; REPEAT fatal memory
fault.

I killed this after 1.4 million iterations of executing and displaying
the date (capturing X) and a counter with no problems.

 TEST.FATAL.CS
0001   COUNTER = 0
0002   LOOP
0003  EXECUTE "DATE" CAPTURING X
0004  COUNTER += 1
0005  DISPLAY X:" ":COUNTER
0006   REPEAT
0007END

Monday, March 17, 2008  05:47pm~ 1,406,473

I don't dare let it run overnight, in case it does blow up the system.

-- Louie
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Estimating Timelines {Unclassified}

[HENDERSON MIKE, MR]

And then, you have the "client factor", as in
*   Work out a rough estimate
*   Double it
*   And multiply this result by the "client factor" to give the actual 
estimate

You know what I mean, 
*   If you ever find such a beast, a really good client that knows what 
they want and is capable of articulating that, gets a "1" or "1="
*   The average clueless client gets about a "2" or "3"
*   Anyone with 'President' or 'Director' in their job title gets at 
least a "5"
*   And we all have those 'Oh, maybe I forgot to mention ...' clients
that definitely rate a "10"

Yeah, I'm getting cynical in my old age


Regards


Mike

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Saturday, 8 March 2008 12:28 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Estimating Timelines

I have to weigh in on this in support of everything stated so far.  John is 
right, the first estimate is the one that "sticks" so that estimate has to 
factor in what is known about the problem, solution, and path at the time the 
estimate is requested, which is often before any real discovery has taken 
place.  The less information known before the estimate, the higher the estimate 
will be, if for no other reasons than to make sure everyone is covered with no 
surprises.  And of course, while customers will do their best to give all of 
the information needed at the outset of the task, the reality is that any and 
all information needs to be weighed against some kind of objective review to 
ensure that the information is accurate and complete.  In fact, I believe that 
ensuring that all of the important information is on the table is a real art 
form!  (I mean, hey, that's what discovery and analysis are for, right?) And as 
Jerry said, there can be a lot of time invested in those ta!
 sks.  Asking someone to estimate a complete job - which includes the discovery 
and analysis needed to estimate the remainder of the tasks - without having 
those tasks completed in advance is pretty much asking for an unknown on a 
fixed timeline, which is as close to an impending failure as one can 
intentionally get.

For the past several years I've been taking a multi-stage approach to the 
larger projects.  Certainly on a smaller project I've finally gotten to a point 
where I can spitball an estimate pretty reliably, but on the big ones I'll 
estimate the discovery separate from the analysis separate from the
implementation+testing+installation.  And of course, documentation is 
implementation+testing+also
estimated separately.  Most customers - to date - have been pretty happy to 
give me a small budget for discovery knowing that it pays big dividends in more 
accurate estimates for the rest of the project.  And accurate, on time, and on 
budget makes everyone happy.

-K
http://www.PrecisOnline.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Testing for TRANSACTION block {Unclassified}

[HENDERSON MIKE, MR]

Jacques,

If you're referring to UniVerse, use the @TRANSACTION meta-variable:-

"@TRANSACTION * A numeric value. Any nonzero value indicates that a
transaction is active; the value 0 indicates that no transaction
exists."


Regards


Mike

-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Jacques G.
Sent: Wednesday, 5 March 2008 6:09 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] Testing for TRANSACTION block

If there a way for a subroutine to know that it has been called from
within a 

BEGIN TRANSACTION
END TRANSACTION

I've got a subroutine somewhere that is calling an illegal command for a
transaction block and having hard time finding where the call is coming
from.


---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Distributed files poll {Unclassified}

[HENDERSON MIKE, MR]

Brenda,

We have several, each part is Type 30 / Dynamic.
Our Distributed Files have only four to six parts, in general.

No discernable bad impacts on performance, some things have improved
performance because only one part-file is scanned instead of the whole
file.

We have no 64-bit files and no intention of having any, when we get
close to 2GB we'd rather partition than go 64-bit.
Frankly, we're a bit leery of 64-bitness. The only time I remember us
using a 64-bit file (apart from just playing in Development to see if
they worked at all) was when we wanted to change the partitioning
algorithm on one of our larger distributed files. It was easier to
create a temporary 64-bit file, copy all the records from the
distributed file to it, clear the part files, reset the partitioning
algorithm and move the part files, then copy the data all back again.
Then we deleted the temporary 64-bit file.
Oh, we're on Windows 2003 Server, UV 10.1


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price
Sent: Thursday, 24 January 2008 10:56 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] Distributed files poll

How many sites use distributed files?  Any issues you have with them?
Do they impact system performance?



Which would you prefer, a distributed file or a 64-Bit file to get
around the 2 gig limit.



Brenda L Price

Senior Programmer Analyst

Affiliated Acceptance Corporation

Sunrise Beach, MO

(800)233-8483
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] list vs. email {Unclassified}

[HENDERSON MIKE, MR]

It's not only to "inhibit Suzy in accounting from wasting time", and
it's not only "the PHBs [who] will not allow the users to surf the net".
Having your desktop PC able to access the internet means that it's
accessible from the internet too, at least to some hopefully small
degree of risk.

My employer requires that PCs which are connected to the Internet be on
a separate physical network to all our 'work' PCs. The only exceptions
are specified gateway servers, e.g. the external email gateway, which
are firewalled to death and heavily protected from intrusion. Our
internet web sites are not hosted on our internal network.
So to access a web-based forum, I need an 'Internet PC', the nearest of
which is down the corridor a bit. So I wouldn't be bothered, I only go
to an 'Internet PC' for a specific purpose.
Like Jerry said, changing this to a forum would also change me from a
participant to an observer.

Oh, and Happy New Year! :-)


Regards


Mike

-Original Message-
> From: [EMAIL PROTECTED] On Behalf Of MAJ Programming
> Sent: Friday, 4 January 2008 6:52 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] list vs. email

[snip]

> overall corporate policies meant to inhibit Suzy in accounting from
wasting time.
> 
> My 1 cent
> Mark Johnson
> - Original Message -
> > From: "Jerry Banker" <[EMAIL PROTECTED]>

[snip]

> > the PHB's will not allow the users to surf the net 

[snip]

> > in that case I would be an observer and not a participant.

[snip]

> > Jerry Banker
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Server Processors (Universe) {Unclassified}

[HENDERSON MIKE, MR]

Dave,

We run our 250-user UniVerse system (10.1.x at the moment) on Windows
2003 Server.
We have 2 x quad-core Xeon E5345 2.33GHz/1333FSB and 3GB RAM (no point
in more on 32-bit O/S like Windows, Windows-64 could use more). So we
have eight actual CPU cores, and it shows as 8 CPUs in Windows Task
Manager.

Yes, multiple Telnet, phantom and uvcs (UniObjects) processes do
'spread' themselves across the available CPUs. This is completely
automatic and it 'just happens'.
An individual job is a single process (BUILD.INDEX and some sorts
excepted) and will run on a single CPU core.
To get a single job to run across multiple processors, you would have to
re-architect it as a controlling process splitting up the data and
somehow allocating it to a number (# CPUs - 2?) of phantom processes to
run in parallel. I know of an ISV who looked seriously at this, but
decided they didn't need to bother, the Moore's Law 'free lunch' solved
their throughput issues! :-)

Happy New Year


Mike

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Liesse, Dave
> Sent: Tuesday, 1 January 2008 04:09
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Server Processors (Universe)
> 
> Thank you all for your answers.  For the record, I'm talking 
> about Windows (while we're moving away from UNIX because 
> nobody wants to learn a superior OS, I tend to forget that 
> most of you are working on real systems).
> 
> Dave
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] server-side ODBC question {Unclassified}

[HENDERSON MIKE, MR]

John asked 
"Is it possible to write data to UV" [from a remote ODBC client]?

I'm not aware of any technical reason why not, but we work really hard
to not allow it. :-)
So I can't really say


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Hester
Sent: Wednesday, 12 December 2007 10:50 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] server-side ODBC question {Unclassified}

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of HENDERSON MIKE,
MR
> Sent: Monday, December 10, 2007 6:20 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UV] server-side ODBC question {Unclassified}
> 

[snip]
 
> We have a lot of DTS (SQL Server 2005 SSIS) packages which 
> access our UV databases this way.
> Mostly it works fine, if at times a little slowly when the 
> tables being extracted are large and the I-Types really complex.

Thanks, Mike.  Is it possible to write data to UV from the client
application when connecting this way?

-John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] server-side ODBC question {Unclassified}

[HENDERSON MIKE, MR]

John

"I also remember setting up a separate SQL-ized UV account and
Q-pointers back to my Pick flavor account's data to make that work."
I'm fairly sure that's the recommended way of doing it, it's certainly
the way we've done it.
That way, you only 'expose' the particular file(s) and data element(s)
you want to for ODBC consumption.  That way you can also expose as
simple-appearing I-Types, fairly complex inter-table joins and/or apply
and security / filtering rules against your UV data.

We have a local user on the UV server that the remote server
impersonates. This user has read access to the SQL-ised account only.
The user ID & password are hard-coded in the remote server's ODBC setup
- the IBM U2 ODBC Data Source setup (on the Clients CD) now encrypts
this password, which is nice.

We have a lot of DTS (SQL Server 2005 SSIS) packages which access our UV
databases this way.
Mostly it works fine, if at times a little slowly when the tables being
extracted are large and the I-Types really complex.



Regards


Mike


-Original Message-
From: [EMAIL PROTECTED] On Behalf Of John Hester
Sent: Tuesday, 11 December 2007 2:24 p.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] server-side ODBC question

We're evaluating phone systems and need to access our UV customer data
for call routing.  One of the systems (Vertical Televantage) can only
communicate with other databases via ODBC.  In this scenario, UV would
need to be the ODBC server and Televantage the client.  Caller ID would
be passed to UV, and it would return back whatever customer data we
might want to use to route to the appropriate call center agent.

Back around '03 I explored something similar with our SQL Server based
CRM application and ended up making UV the ODBC client instead.  Seems
like I couldn't find a way to go the other direction except via a
desktop VB app - not in the background as a service.  I did successfully
connected to UV as an ODBC server from Excel some years back, but again,
that was via the desktop.  I also remember setting up a separate
SQL-ized UV account and Q-pointers back to my Pick flavor account's data
to make that work.  That was on a different platform and version of UV,
though.

Has anyone done something similar using ODBC and UV as the ODBC server?
Does what I remember about the process still hold true, or am I
completely off base?

Thanks,
John

John Hester
System & Network Administrator
Momentum Group
(949) 833-8886 x623
http://www.themomgroup.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV - 10.2.2 [unclassified]

[HENDERSON MIKE, MR]

> From: [EMAIL PROTECTED] On Behalf Of Hennessey, Mark
F.
> Sent: Wednesday, 7 November 2007 9:43 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: [U2] UV - 10.2.2 [not-secure]
> 
[snip]
> 
> Do any of our IBMers have an idea when 10.2.6 will be released for
Solaris?

Or Windows, we've been at 10.2.3 since April this year


Mike

> Mark H.
> ---
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] extended ascii characters and TOXML {Unclassified}

[HENDERSON MIKE, MR]

Stuart,

Can you tell us when "IBM in their wisdom have decided to add a UTF8
encoding tag in the XML header"?
I think it was some time between 10.0.15 and 10.1.18, but not sure when.
It is, as you can see from the second message below, causing us grief in
our BizTalk 2006 upgrade.

We are looking at having to parse the generated XML and remove the UTF-8
references before sending it on.
[Hmm ... I wonder if replacing "UFT-8" with "ISO-8859-1" might work?]


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Monday, 15 October 2007 8:30 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] extended ascii characters and TOXML [was:select
statement with single quotes]

[snip]

IBM in their wisdom have decided to add a UTF8 encoding tag (Unicode) in
the XML header produced by the TOXML verb. 

[snip]


__ 
From:   MACK ANDREW, MR  
Sent:   Tuesday, 9 October 2007 2:27 p.m.
To: 'u2-users@listserver.u2ug.org'
Subject:[U2][UV] Generating XML documents  {unclassified}

Hi all,

We are in the process of upgrading our BizTalk 2004 server to BizTalk
2006 and have discovered that the BizTalk 2006 XML Disassembler in the
receive port no longer likes the "encoding="UTF-8" header at the top of
the XML doc. 
[snip]
Our &XML& mapping file has  as the first line but
when the XML doc is generated, a 'encoding="UTF-8"' has been added, as
below.


http://NZDF.Defence.HR.BizTalk.Schemas.AtlasBankDat
aSchema"
xmlns:U2xml="http://www.ibm.com/U2-xml";>


The XML examples in the UV Basic Extensions documentation all show only
 being generated, as per the map file. I need to
prevent the encoding="UTF-8" bit being added to the generated XML doc.
Can anyone help?

Thanks

Andrew Mack
Senior Database Manager (UV/SQL)
Applications Development, CIS Branch
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [BB] Does UD need the equivalent of uv/errlog? {Unclassified}

[HENDERSON MIKE, MR]

John,

No, but you have to *create* the file before UV will use it (yes, I know
it's nuts, but "it's always been that way")
Just "touch errlog" in the right directory. With the right permissions,
of course


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]  On Behalf Of John Hester
Sent: Wednesday, 19 September 2007 11:00 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [BB] Does UD need the equivalent of uv/errlog?

Oddly, my UV install doesn't have an errlog file:

[EMAIL PROTECTED] root]# cd `cat /.uvhome` [EMAIL PROTECTED] uv]# ls errlog
ls: errlog: No such file or directory

Is there a service that needs to be started in order to populate the
log?

-John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 University in Sydney {Unclassified}

[HENDERSON MIKE, MR]

I was one of those who returned with a bulging brain!
No question, it was the best training money my boss has spent on me in
years.

If you possibly can, GO!


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
Sent: Friday, 14 September 2007 4:23 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] U2 University in Sydney

If you can, send at least two people.  There are three tracks, each with
15 sessions.  A few of the main ones are repeated, but one person can't
learn everything he/she would want to.
It was a well put-together show, even if one or two of the presenters
were overworked (at least for the Sydney show), and most of the
attendees to whom I spoke went away with their brains bulging - if not
hurting.
Also a great opportunity to catch up with the U2 community, who nowadays
seem to meet far too infrequently.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Sacred Licence Seat - A Challenge {Unclassified}

[HENDERSON MIKE, MR]

Thanks, Sara

"UVCS.LOGIN" seems like just exactly what I need (for a different
reason) and have been looking for for ages.
What a pity that it is completely undocumented - except in the U2UG List
of course!

Is there an equivalent for ODBC and/or OLEDB login? Maybe "ODBC.LOGIN"?


Jef, you could maybe use a program run from the UVCS.LOGIN paragraph and
the IP address [SYSTEM(42)] of the user to determine if it's an 'inside'
or 'outside' [Internet] user?


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Sara Burns
Sent: Tuesday, 21 August 2007 9:26 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Sacred Licence Seat - A Challenge

>>4) To my knowledge, VB UniObject and UniJava sessions do not go
through LOGIN or UV.LOGIN.

We use the  UVCS.LOGIN paragraph to set variables like the European Date
format.  I believe this gets called for uvcs sessions.

I cannot remember how we found out about this.

Sara Burns


Sara Burns (SEB)


IS Development Manager

Public Trust
Phone: +64 (04) 978 4534 (DDI)

Mobile: 029 978 4534


-Original Message-
From: [EMAIL PROTECTED]  On Behalf Of Jef Lee
Sent: Friday, 17 August 2007 2:23 p.m.
To: u2-users@listserver.u2ug.org
Cc: [EMAIL PROTECTED]
Subject: [U2] Sacred Licence Seat - A Challenge

Does anyone have a way to set one licence seat as sacred?

[snip]
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 University {Unclassified}

[HENDERSON MIKE, MR]

Sounds like an excellent idea. 


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett
Sent: Monday, 20 August 2007 4:14 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] U2 University {Unclassified}

Is there going to be a U2UG catch up at the Sydney event? I'd like to
put some faces to names especially with the NZ crowd.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 University {Unclassified}

[HENDERSON MIKE, MR]

Thanks, Ray


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
Sent: Monday, 20 August 2007 3:43 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] U2 University {Unclassified}

Stay with the ferries - it's by far the easiest.  Get a second ferry
from the Quay to Darling Harbour (and you can do it all on the one
ticket).  The IBM building is the tall one with the IBM logo on it!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 University {Unclassified}

[HENDERSON MIKE, MR]

Kate,

No hotel for me, I'm staying with my parents in Manly - the food's as
good but the staff are friendlier and the tarriff is w-a-a-y cheaper!
:-)

So I'll be forced to catch the ferry across to Circular Quay (a tough
job but somebody has to do it, I guess), then ... not quite sure where
the IBM building is, either the train or a bus I guess.
Any of the Aussie listers got ideas on the best way from the Quay to
IBM?

I think there'll be a representative from Ultimate Computer (our VAR)
there too, so that's at least four Kiwis.


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kate Stanton
Sent: Saturday, 18 August 2007 9:04 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] U2 University {Unclassified}

See you there, Mike.  My sister Eleanor & I shall also be there.  I am
staying at the Crowne Plaza, are you?  Cheers, Kate

Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay, Auckland, New Zealand Phone +64 9 360 5310
Fax +649 376 0750 Email [EMAIL PROTECTED]
- Original Message -----
From: "HENDERSON MIKE, MR" <[EMAIL PROTECTED]>
To: 
Sent: Friday, August 17, 2007 10:17 PM
Subject: RE: [U2] U2 University {Unclassified}


> I'm going to the Sydney, Australia session.
>
> Mike
>
>> -Original Message-
>> From: [EMAIL PROTECTED] On Behalf Of Jerry Banker
>> Sent: Thursday, 9 August 2007 05:07
>> To: u2-users@listserver.u2ug.org
>> Subject: [U2] U2 University
>>
>> I'm going to the U2 University in Denver the last week of
>> this month, any others attending?
>>
>>
>>
>> Jerry
> The information contained in this Internet Email message is intended
> for the addressee only and may contain privileged information, but not
> necessarily the official views or opinions of the New Zealand Defence 
> Force.
> If you are not the intended recipient you must not use, disclose, copy
or
> distribute this message or the information in it.
>
> If you have received this message in error, please Email or telephone
> the sender immediately.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 University {Unclassified}

[HENDERSON MIKE, MR]

I'm going to the Sydney, Australia session.

Mike 

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Jerry Banker
> Sent: Thursday, 9 August 2007 05:07
> To: u2-users@listserver.u2ug.org
> Subject: [U2] U2 University
> 
> I'm going to the U2 University in Denver the last week of 
> this month, any others attending?
> 
> 
> 
> Jerry
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Sacred Licence Seat - A Challenge {Unclassified}

[HENDERSON MIKE, MR]

Jef,

In the LOGIN Paragraph in VOC run a program that, if the number of users
logged in - in SYSTEM(35) - is more than the # sessions limit passed in
on the command line, and this is a TELNET login, then an information
screen is displayed, and the program chains "OFF".

The number is passed in on the command line, so you can change it on the
fly quite easily.
In your case, it would be one less than the number of licenses.



Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Friday, 17 August 2007 2:23 p.m.
To: u2-users@listserver.u2ug.org
Cc: [EMAIL PROTECTED]
Subject: [U2] Sacred Licence Seat - A Challenge

Does anyone have a way to set one licence seat as sacred?



There are 15 users in the organization and 20 licences for UniVerse.
But users will open more than one session if they can.  We need one
licence always available for when an internet connection is made.



How do we keep one unused?

Is there a UniVerse setting that prevents a seat from being taken
locally?

Has someone out there done this?  Would you like to share the technique?



Any suggestions?





Jeffrey Lee
Senior Analyst/Programmer



IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning
Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA,
6153
P:  (08) 9315 7000F: (08) 9315 7088
W: http://www.itvision.com.au 
___

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Large-scale scanner / OCR devices and interfaces to UniVerse {Unclassified}

[HENDERSON MIKE, MR]

Folks,

We have some process improvement people who are keen to reduce manual
key-boarding effort by setting up some large-scale scanner / OCR devices
and interfacing them to our UniVerse systems.
[I'd rather avoid the paper forms altogether and get XML streams from
the document originators, but ...]

Anyone got any experience on this kind of gear?
I'm clueless about this (Google next, I guess), so ideas on brand names
etc would be helpful.

Thanks


Mike
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Conversion code for week number {unclassified}

[HENDERSON MIKE, MR]

Adrian,

This has been discussed before on the list.
IIRC, there is no built-in U2 support (i.e. conversion code) for this,
at least partly because it's one of those nasty 'depends what you mean'
questions.  
For example, 
* is the first week in the year week # 0 or 1?
* when does the first week start - the first day in the year, the first
Sunday in the year, the first Monday, ... ?

There is I believe an ISO standard, but that may not be what you want.
There may be something in Pickwiki


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian
Sent: Wednesday, 11 July 2007 3:07 p.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Conversion code for week number

Does anyone know of a conversion code that returns the week number of
the year?

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UD Backups - DBPAUSE for UniVerse? {Unclassified}

[HENDERSON MIKE, MR]

Ah, yes there it is in the User Reference, like you said Mark.

BUT, on 10.1 anyway,
*   'SUSPEND.FILES' is not in the Index of the User Reference, you
have to search the document to find it.
*   When you do find it, it doesn't say whether the Dynamic / Type
30 file headers (or anything else) are flushed to disk when you
SUSPEND.FILES ON, and
*   The documentation for uv -admin [options] lists the effects of
the options but not what the switch settings are that you would have to
use to invoke the options


All in all, not amongst IBM's best documentation efforts


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark
F.
Sent: Friday, 6 July 2007 3:34 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD Backups - DBPAUSE for UniVerse? [not-secure]



I am still not finding any real documentation details on
UV's SUSPEND.FILES ON/OFF.



As an aside, I suspect you are suffering from the poor organization of
the UniVerse documentation. I would expect something like this to be in
a guide for administrators, yet SUSPEND.FILE is documented is the user
reference. (It does get one sentence in the Administering UniVerse
guide...)... Then there are items in the "System Description" that
should be somewhere else. It's one thing to use the system description
to talk about the existence of file triggers, but to use that as the
place to document the whole functionality it counter intuitive.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Time conversion code {Unclassified}

[HENDERSON MIKE, MR]

UV 10.1.18 on Win2K3

"User" Accounts
 LIST VOC "RELLEVEL"  EVAL "@RECORD"  EVAL "9" CONV "MTS" 
VOC.@RECORD...9.

RELLEVELX 01:00:00
10.1.18
INFORMATIO
N
INFORMATIO
N.FORMAT
10.1.18


"uv" Account
LIST VOC "RELLEVEL"  EVAL "@RECORD"  EVAL "9" CONV "MTS" 
VOC.@RECORD...9.

RELLEVELX-type - T01:00:00
he RELEASE
 LEVEL of
this accou
nt
10.1.18
ADMIN
10.1.18

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Friday, 8 June 2007 4:26 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Time conversion code

> From: Anthony Youngman
> If it has been changed, it should be logged as a bug!
> > From: Norman, David
> >This (IMO unwanted) change in functionality occurred at 10.0.

UV users any & all,
Please post results to this simple test: 

   LIST VOC "RELLEVEL"  EVAL "@RECORD"  EVAL "9" CONV "MTS"

[snip]
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [BB] U2 Enhancement Request - CREATE.FILE {Unclassified}

[HENDERSON MIKE, MR]

I'm with Tony on this.
Any of the situations that Susan outlines, except the 'correct' scenario
of CREATE.FILE when neither VOC entry nor underlying O/S file pre-exist,
is in my view a serious run-time error. The program should fail in that
situation.

A well-designed program should [in my not-so-humble opinion ;-) ] always
check for the existence of a file it's about to create.  Then the design
specification would state what is the correct action. That may be to
carry on, or to delete and re-create, or to ask the user what to do, or
just to report an error and stop.


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno
Sent: Thursday, 24 May 2007 6:18 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [BB] U2 Enhancement Request - CREATE.FILE

Smart is in the eyes of the beholder.  (huh?)  I just went through a
similar situation.  Let's say the CREATE.FILE points to an undesirable
path
via some programmatic glitch.  Now delete, clear, or write over the
data.
Anything in there goes away or gets butchered.  If you use sudo to get
into
U2 or you are otherwise using permissions that allow you to blow away
something that you really needed, you're in a world of hurt.  A prompt
might be nice but it should not be exposed to end-users.  A mis-used
Force
option could be very dangerous.  Be careful about what you ask for, you
might get it.  :)

T

Susan Joslyn wrote:
> The CREATE.FILE could be smart enough to recognize these latter two
> situations and rectify them:
>   CREATE.FILE finds a VOC but no underlying file - delete the VOC and
> create fresh.
>   CREATE.FILE finds an underlying file but no VOC pointer - create
> the VOC pointer to the existing file.
> 
> Ideally it will stop and report what is happening and ask, but there
> could be a FORCE type option that did not stop for the question.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] UV Transactions when TXMODE is set to 0 {Unclassified}

[HENDERSON MIKE, MR]

Dear UniVerse Gurus,

Our UniVerse system (10.1, Win2K3) is set up without any Transaction
Logging parameters set in the UV Config.
I.E. TXMODE = 0, and all the other related configration parameters are
set to defaults.

Transactions do however, still work from UniBasic or from UniObjects,
even without TXMODE set - the UniAdmin documentation says "A value of
zero allows transactions to execute but not be logged ...".
So we can use UV Transactions to get all-or-none of a set of updates
applied, i.e. ensure atomicity of operation, but not for roll-forward
recovery from a crash.  

OK, so far so good ...

But, where is the information needed to roll a transaction forward
("Commit") or back ("Rollback") stored in that situation?
All the documentation in the PDF is about transaction logging, i.e. it
assumes TXMODE = 1
Are there any configuration parameters which we ought to set, and if so,
how could we determine the optimal values? TXMEM, for example.


Thanks


Mike

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] 2 questions, one on STATUS and the other on STEAL-FILE {Unclassified}

[HENDERSON MIKE, MR]

HELP BASIC STATUS (from TCL) tells you all you need to know.

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave R
> Sent: Tuesday, 8 May 2007 12:28
> To: u2-users@listserver.u2ug.org
> Subject: [U2] 2 questions, one on STATUS and the other on STEAL-FILE

[snip]
 
> 
> STATUS:
> The basic STATUS IE STATUS ARRAY FROM F.FILE ELSE ARRAY = ''
> returns 30 + attributes is the definitions covered in a 
> manual some where? I can see some of the data points.  
> What I am looking for this the creation date
> and the revision date of the file.
> 
> Enter File Name?PARTS
>1..

[snip]

>   26..
>   27..D:\uvdata\/PARTS
>   28..
>   29..0
>   30..UNIDATA\daverav
> 
> 
> 
> Dave R
> 
> e Fax (815)4259364
> P.O. Box 17811, Irvine CA 92623-7811
> ---
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Single Signon for U2 - Identity Management ? {Unclassified}

[HENDERSON MIKE, MR]

This is actually a 'hard' problem in IT, particularly with some large
ERP packages, a German one being a particularly aggravating example. ;-)

However, in a UniVerse environment, if you have source code, it's not
too difficult. [The fact that other packages / systems make it seem so
hard is a bit of a mystery to me]
What you need to do, at the place where you would otherwise ask the user
to input a UserID & Password, is *trust* that the identity of the
currently logged-in user has been verified by the identity management
system (in our case Windows Active Directory services). So, don't ask
the user for their ID, it's already there in @LOGNAME.

As an additional check, if the user is about to change some piece of
information which might be of particular concern (like the Bank Account
Number their pay goes into) you can ask them to re-enter their password
(displaying  instead of the actual password course) and use the
manufacturer-supplied API to check that the input password matches the
user-ID.

HTH

Mike

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Charles Barouch
> Sent: Friday, 20 April 2007 07:10
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Single Signon for U2 - Identity Management ?
> 
> All,
>I *believe* Baker is looking to have people put in their User ID & 
> Password exactly once, and not have to re-enter it for each process 
> (UniVerse, E-mail, Mapped Directories, etc.). Basically, he wants 
> logging on in the morning to preclude having to even think about 
> identity until you log off.
> 
> - Chuck "Speaking for Baker, Even Though He's Here To Speak For 
> Himself" Barouch
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] On Behalf Of Baker Hughes
> > Sent: 19 April 2007 14:49
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Single Signon for U2 - Identity Management ?
> >
[snip]
> >
> > Does anyone know of an Identity Management Suite that is U2 
> > aware?  
> >
[snip]
> >
> > What we need - single signon and immediate access to those systems,
> > servers, storage that your identity allows.  Whatever you don't have
> > rights to, you can't see (an old Novell concept that Microslop still
> > doesn't get).
> >
> > Thanks for any guidance.
> >
> > -Baker
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] BASIC Programming Class - New Zealand {Unclassified}

[HENDERSON MIKE, MR]

Ray,

NZ Defence Force will have at least two, possibly three attendees.
These are all Wellington-based civilian employees, so we would prefer
Wellington.


Looking forward to it


Mike

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Ray Wurlod
> Sent: Tuesday, 17 April 2007 10:35
> To: u2-users@listserver.u2ug.org
> Cc: [EMAIL PROTECTED]
> Subject: [U2] BASIC Programming Class - New Zealand
>
> Earlier this year we began seeking expressions of interest in
> running the U2125 class (UniVerse/UniData BASIC Programming)
> in New Zealand, and got enough responses to go ahead.
> However, due to budgetary limitations, the requested
> timeframe was pushed out to July 2007.
>
> This note is to check that everyone who was interested still
> is.  It's now three months out from July, which is about time
> to stir the behemoth (IBM) into action, to get everything
> organized.  Can you please respond either here or directly to
> my email address (mailto:[EMAIL PROTECTED]) with the expected
> number of attendees?  We're currently thinking late July or
> early August, not sure whether Auckland or Wellington at this
> stage.  That's mainly up to where the majority of attendees
> will be sourced.
> ---

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Memory used in a BASIC program {Unclassified}

[HENDERSON MIKE, MR]

No SYSTEM() function as far a I know

But see HELP MAKE.MAP.FILE

LIST &MAP& WITH @ID LIKE <> REF OBJ CR SIZE

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Paul McVicker
> Sent: Tuesday, 3 April 2007 08:36
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Memory used in a BASIC program
> 
> Is there a SYSTEM() function in Universe that will give the 
> amount of memory consumed by the basic program?
> 
> Paul McVicker
> VP Information Services
> HIDI
> pmcvicker at mail.mhanet.com
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] I need info on trapping the 'page up' key within a Universe Basic program ... Can anyone point me in the right direction ? {Unclassified}

[HENDERSON MIKE, MR]

Yes, Wol.  

"SYS.TERMINALS" exists on UniVerse 10.1.18.

Mike

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Anthony W.
Youngman
> Sent: Friday, 23 March 2007 06:35
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] I need info on trapping the 'page up' key 
> within a Universe Basic program ... Can anyone point me in 
> the right direction ?

[snip]

> Have IBM re-instated the SYS.TERMINALS file from PI in recent 
> versions of UV? On PI it contained both the codes sent and the 
> codes received from terminals so things like the COMMAND.EDITOR 
> worked. Now they've reinstated the command, the file might be 
> there too.
> 
> If that's there, it'll tell you what all these keystrokes are
> And you might even be able to trap it the same way they do.
> 
> Cheers,
> Wol
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] How much RAM is too much {Unclassified}

[HENDERSON MIKE, MR]

Chuck,

You can say "2GB" or "3GB", but unless you're using a 64-bit CPU (I
think they all are, now) and a 64-bit O/S (which XP professional is
not), you can't effectively use more than 3GB, even though the box will
probably address 4GB (or even more) happily. A 32-bit O/S like Windows
uses a 4GB address space, but the 'top' 1GB of the address space is
reserved for the O/S itself.  I think you can buy "XP Pro 64-bit
Edition", which would address as much RAM as you can stuff into the box,
but I doubt it would buy you much extra throughput.  Be a fun
bench-mark, though!

Two dual-core, CPUs would probably give you less memory contention than
one quad-core.

I'd configure the disks as one mirror pair for the O/S, UV software etc
(C:\ drive), and another mirror pair, or RAID-5 set, for your data (D:\
drive). If you're using UV transaction logging, put that on a third set
of disks (E:\ drive).
Buy the fastest disks you can get (15,000 rpm), put them on the fastest
hardware RAID controllers on the fastest I/O channels (PCI-X) you can
configure, and install as much battery-backed cache on the controllers
as you can.

You say the SQL servers are on a 'slow' network.  Any chance of setting
up another network segment with Gigabit LAN cards and a cheap GB switch,
just for this work?


HTH

Mike

> -Original Message-
> From: [EMAIL PROTECTED] Behalf Of Charles Barouch
> Sent: Monday, March 12, 2007 2:57 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] How much RAM is too much
> 
[snip]
>  The thing is, I can say "2GB" memory or "4GB" memory, 
> but I can't say 'a lot'. I need to know if there is an upper 
> limit after which the  system stops benefiting from more money 
> being thrown at it.
> 
>  - Chuck "64K" Barouch
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Are 'Progress' or 'RedBrick' databases multi-value? {Unclassified}

[HENDERSON MIKE, MR]

Folks,

I have been asked to find out if either 'Progress' or 'RedBrick'
databases are multi-value.  Their web-sites don't say anything either
way so far as a quick look told me, but we all know that many products
are shy about any association with 'Pick'.

So, any information would be helpful.


Thanks in advance

Mike
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] number of users {Unclassified}

[HENDERSON MIKE, MR]

Dianne

>From the Linux command line prompt in the \UV\bin\ directory
uvlictool clean_lic -a

Or
Create a Paragraph
PA
SH /c '\bin\uvlictool clean_lic -a'


I think you need to be a super-user to do "clean_lic" 

HTH

Mike

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Dianne Ackerman
> Sent: Friday, 23 February 2007 07:44
> To: U2 List Server
> Subject: [U2] [UV] number of users
> 
> Universe 10.1.4 on Linux.  A LISTU shows X users logged on, but the 
> SYSTEM(35) variable says there are many more.  They are not able to 
> reboot easily - is there a way to reset that number so it is 
> accurate?  
> Users keep trying to logon and are getting the user max 
> reached message even though there is plenty of room for them.
> Thanks!
> -Dianne
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Index Problem {Unclassified}

[HENDERSON MIKE, MR]

We have no scheduled index re-builds here.
Very, very occasionally we get an unexplainable error which 'goes away'
when we rebuild the index on the file that's giving the error.  The last
time was a 'Write Error' [#040011] on a file with triggers and secondary
indexes.  Not actually sure whether dropping and re-creating the
trigger, or dropping and re-building the index, cured the problem, the
SysAdmin did both.

By the way, OP's index looks horrendous: all the records in the file in
two possible groups - "Y" and "N".  If you want an index that performs a
bit better, I'd have values "" and "" returned by the
I-Descriptor, so that you can say "NO.NULLS" and have an index of Bad
Addresses (?) that would work properly. Maybe the reason this particular
index needs re-building is because of the bad distribution of keys?

Just my $0.02 worth


Mike

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Scott Ballinger
> Sent: Wednesday, 7 February 2007 10:59
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Index Problem
> 
[snip]
> 
> OT question for the list: is the practice of rebuilding indexes
> (nightly?) common? Why? I use a lot of indexes on large and active
> files, and very rarely have to rebuild them. Rebuilding indexes on a
> periodic basis looks like a little too much of the belt AND suspenders
> mindset. Are the U2 databases really so un-reliable that we have to
> resort to these sorts of hacks? (Actually, IMO they are very reliable
> and no you don't.)
> 
> /Scott Ballinger
> Pareto Corporation
> Edmonds WA USA
> 206 713 6006
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] IBM Course U2125 in Australia/NZ? {Unclassified}

[HENDERSON MIKE, MR]

Leslie, Jon and others,

Thank you all for these and other suggestions for alternatives to the
'official' IBM training course delivery. I am sure they are all very
valuable. I may even take advantage of some of them, as I have of others
in the past.


However, I have at this moment a specific need, which is 

***  to deliver training to my staff which will ***
***  enable them to achieve IBM Certification.  ***

If they were to learn anything useful as part of this, that would be an
additional bonus.


You may think this is a strange attitude, and it is from some points of
view.
BUT
My staff members' salary advancement prospects, and in the not so long
term their employability, depends on their  certification.  In our
UniVerse world, no ISCE ==> no job, in our MS world, no MCSD ==> no job,
in our SAP support world, no {SAP Certification} ==> no job.
This is a Policy, not a preference, it is written into Job Descriptions.

And that is why, after nearly 35 years in IT, I last year achieved my
own very first vendor certification.


Mike Henderson, "IBM Certified Solutions Expert"

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Leslie
Chamberlin
> Sent: Thursday, 1 February 2007 06:36
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] IBM Course U2125 in Australia/NZ? {Unclassified}
> 
> Kevin King with Precision Solutions (a member of our list) is 
> awesome at customizable U2 courses that are available on line. 
[snip]
> 
> -Leslie Chamberlin
>  Affiliated Acceptance Corporation



> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Jon Sisk
> Sent: Thursday, 1 February 2007 05:19
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Another training option
> 
> Greetings, U2,
> 
> I would like to announce another option for UniVerse and UniData 
> training we just recently unveiled.
> 
[snip]
> 
> Please have a look at the JES.com site for a writeup on the details of

> this new offering, and thank you for your time and consideration.
> 
> All the best,
> 
> Jonathan E. Sisk
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] IBM Course U2125 in Australia/NZ? {Unclassified}

[HENDERSON MIKE, MR]

Thanks, Ray

Training Choice don't appear to have a presence in NZ, they sub-contract
to Ace Training, who regularly advertise IBM training courses - in
Tivoli, Notes, Domino, etc, but never any U2. :-(

They have said in the past that UV903 (now superceded by U2125 I
suppose) could run in Wellington or Auckland if they had four people.
Looks like the other poster and I might be able to manage that between
us, so we may be seeing you as the instructor?

Regards

Mike Henderson, ICSE
(Yes, I got certified last year, too!)

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Ray Wurlod
> Sent: Tuesday, 30 January 2007 17:55
> To: u2-users@listserver.u2ug.org
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [U2] IBM Course U2125 in Australia/NZ? {Unclassified}
> 
> Training Choice (www.training-choice.com) claim to have an 
> exclusive agreement with IBM for running U2 classes in New 
> Zealand and Australia.
> 
> I sometimes teach their classes.
> 
> The schedule for New Zealand 
>
(http://www.training-choice.com/education_gateway/schedules_list.php?c=4
&l=7) 
> looks pretty grim.
> It's no consolation that their schedules for Sydney and 
> Melbourne are just as empty.
> 
> I have CC'd them on this response, let's see if we can get 
> anything to happen.  It may be that the UV-903 class has to 
> substitute for the U2-2125, but the main difference is 
> coverage of the AE editor (which UniVerse now has anyway) as 
> the editor of choice.
> 
> Incidentally, I gained the certification last year.
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] IBM Course U2125 in Australia/NZ? {Unclassified}

[HENDERSON MIKE, MR]

Kate,

For Auckland, I would have two people, I think Ace will actually run a
course for four.
For Sydney or Melbourne I would have one at most (if I could get
permission / funding).


Regards


Mike


> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Kate Stanton
> Sent: Tuesday, 30 January 2007 12:01
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] IBM Course U2125 in Australia/NZ? {Unclassified}
> 
> We are about to take on another couple of people, so it would 
> be great if the course were to be run in Auckland!
> 
> - Original Message - 
> From: "Craig Bennett" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, January 30, 2007 11:23 AM
> Subject: Re: [U2] IBM Course U2125 in Australia? {Unclassified}
> 
> 
> > If the course runs in Sydney, I have a candidate too.
> >
> > Craig
> >
> > HENDERSON MIKE, MR wrote:
> >> Oz Folks,
> >>
> >> The IBM Course U2125 "IBM UniVerse & UniData Database Programming"
(or
> >> its predecessors) has not been delivered in NZ for ages, despite my
> >> having a standing order with the alleged provider for about three
years.
> >>
> >> Has this course actually been delivered recently in Australia?
> >> What are the chances of it being held (again) within the next
twelve
> >> months?
> >>
> >> [I'd like to get one of my newer people on this course as a path to
IBM
> >> certification, but don't feel inclined to try to get permission for
> >> "overseas travel" unless there's a realistic chance of the course
> >> happening]
> >>
> >>
> >> Advice, please
> >>
> >>
> >>
> >> Regards
> >>
> >>
> >> Mike
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] IBM Course U2125 in Australia? {Unclassified}

[HENDERSON MIKE, MR]

Oz Folks,

The IBM Course U2125 "IBM UniVerse & UniData Database Programming" (or
its predecessors) has not been delivered in NZ for ages, despite my
having a standing order with the alleged provider for about three years.

Has this course actually been delivered recently in Australia?
What are the chances of it being held (again) within the next twelve
months?

[I'd like to get one of my newer people on this course as a path to IBM
certification, but don't feel inclined to try to get permission for
"overseas travel" unless there's a realistic chance of the course
happening]


Advice, please



Regards


Mike
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Integration of UniVerse with Microsoft Team System 2005 {Unclassified}

[HENDERSON MIKE, MR]

Folks,

Here at NZ Defence Force, we are just embarking on the exciting
adventure of software development using Microsoft Visual Studio Team
System 2005. [ For those who have managed to avoid the advertising
blitz, this is MS extending the Visual Studio .Net development suite
'upwards' into Requirements & Architecture and 'downwards' into Testing
and Database.  Yes, folks, from soup to nuts, the entire banquet can now
be purchased at the MS Buffet. :-) ]
This is a big step forward for our .Net & SQL Server people.

My management is keen to try to integrate *all* our software design,
development, testing, quality assurance and deployment into the same
framework.  This includes our 'legacy' UniVerse systems development.
We would have our documentation in the VSTS documentation repository
(reflected in the companion SharePoint Web site), our bugs entered into
and tracked by the VSTS OLAP database, etc. etc. and our UniBasic source
in a VSTS SourceSafe repository (I think this might be 'interesting' as
we have source code elements with names like
"A.SUB.ROUTINE.TO.DO.SOME.THING" and all those periods will probably
upset things).


So, has anyone else tried this - has someone succeeded gloriously or
failed miserably?


Has anyone got a product to sell me that will make this easy and
painless?
[Feel free to tell me that I really ought to pay more attention to IBM's
marketing stuff if IBM have the answer!]


Thanks


Mike




The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Basic Program Scheduling Priority {Unclassified}

[HENDERSON MIKE, MR]

Perry,

"NAP" takes milliseconds as its parameter, but, at least on Windows
platforms, "NAP 1" does not sleep for 1 millisecond, but actually for
about 15 milliseconds.  

It seems that there is a fundamental clock somewhere in the UV Basic
runtime environment on Windows that only 'ticks' about once every
15-and-a-bit milliseconds (I think 15.3 ms from memory).
You can demonstrate this by getting TIME() in a tight loop and seeing
the values and how they change.  You get the same value returned again
and again, then it will jump up by 15 or 16 milliseconds. This has been
the case at least across 9.6, 10.0 and 10.1 - I haven't tried 10.2 yet.

I'd be interested if someone could try this on a Unix / Linux platform
and see if they observe the same phenomenon, or if it's a "Windows
Special Feature" (TM) ;-)
Code to do it is below.

Regards


Mike

 Begin program code 
* PROGRAM MIKE.SMALLEST.TICK
*
* What is the shortest time interval that you can NAP?
* What is the smallest increment value for TIME()? 
*
  THE.START = TIME()
  CRT 'THE.START ':QUOTE(THE.START):' [':OCONV(THE.START,'MTS'):']'
*
*

-
*
* MINIMUM 'NAP'
*
  DIM TIME.ARRAY(1)
  MAT TIME.ARRAY = ''
  FOR KK = 1 TO 1
 TIME.ARRAY(KK) = TIME()
 NAP 1
  NEXT KK
  NAP.END = TIME()
  CRT 'NAP.END ':QUOTE(NAP.END)
*
  MIN.DIFF = 999.999
  MAX.DIFF = 0
  DIM DIFF.ARRAY()
  MAT DIFF.ARRAY = ''
  TOT.DIFF = 0
  FOR KK = 2 TO 1
 THE.DIFF = TIME.ARRAY(KK) - TIME.ARRAY(KK-1)
 IF THE.DIFF GT MAX.DIFF THEN MAX.DIFF = THE.DIFF
 IF THE.DIFF LT MIN.DIFF THEN MIN.DIFF = THE.DIFF
 DIFF.ARRAY(KK-1) = THE.DIFF
 TOT.DIFF += THE.DIFF
  NEXT KK
*
  AVERAGE.DIFF = TOT.DIFF / 
  INT.AVERAGE.DIFF = INT((AVERAGE.DIFF * 10) + 0.5)
*
  CRT 'Average elapsed time of "NAP 1" is ':OCONV(INT.AVERAGE.DIFF,
"MD2"):' milliseconds'
  CRT ' Minimum value of "NAP 1" is ':MIN.DIFF*1000:'
milliseconds'
  CRT ' Maximum value of "NAP 1" is ':MAX.DIFF*1000:'
milliseconds'
*
*

-
*
* SMALLEST INCREMENT OF TIME()
*
  MAT TIME.ARRAY = ''
  FOR KK = 1 TO 1000
 LAST.TIME = TIME()
 THIS.TIME = LAST.TIME
 LOOP
 UNTIL THIS.TIME NE LAST.TIME
THIS.TIME = TIME()
 REPEAT
 TIME.ARRAY(KK) = THIS.TIME
  NEXT KK
  TIME.END = TIME()
  CRT 'TIME.END ':QUOTE(TIME.END):' [':OCONV(TIME.END,'MTS'):']'
*
  MIN.DIFF = 999.999
  MAX.DIFF = 0
  MAT DIFF.ARRAY = ''
  TOT.DIFF = 0
  FOR KK = 2 TO 1000
 THE.DIFF = TIME.ARRAY(KK) - TIME.ARRAY(KK-1)
 IF THE.DIFF GT MAX.DIFF THEN MAX.DIFF = THE.DIFF
 IF THE.DIFF LT MIN.DIFF THEN MIN.DIFF = THE.DIFF
 DIFF.ARRAY(KK-1) = THE.DIFF
 TOT.DIFF += THE.DIFF
  NEXT KK
*
  AVERAGE.DIFF = TOT.DIFF / 999
  INT.AVERAGE.DIFF = INT((AVERAGE.DIFF * 10) + 0.5)
*
  CRT 'Average difference of "TIME()" is ':OCONV(INT.AVERAGE.DIFF,
"MD2"):' milliseconds'
  CRT 'Minimum difference of "TIME()" is ':MIN.DIFF*1000:'
milliseconds'
  CRT 'Maximum difference of "TIME()" is ':MAX.DIFF*1000:'
milliseconds'
*
  TOT.DEV.SQUARED = 0
  FOR KK = 1 TO 999
 THIS.DEV = AVERAGE.DIFF - DIFF.ARRAY(KK)
 TOT.DEV.SQUARED += (THIS.DEV * THIS.DEV)
  NEXT KK
*
*

-
*
  STOP
*
   END
- End program code -

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Buss, Troy
(Logitek Systems)
> Sent: Sunday, 14 January 2007 09:30
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UV] Basic Program Scheduling Priority
> 
> Take a look at the NAP statement in UniVerse basic.  I 
> believe it takes tenths or milliseconds as a parameter.
> 
> -Troy
> 
> Perry Taylor wrote:
> > I have several BASIC processes that are quite CPU intensive which I
> > would like to "slow" themselves down a bit so the don't take so much
> > processor time.  Is anyone aware of way for a UniVerse BASIC program
to
> > change it's own processing priority?  Something akin to
> > getpriority()/setpriority() is C?
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV Bci {Unclassified}

[HENDERSON MIKE, MR]

Rudy,

I use a code fragment that looks a bit like this ["names have been
changed to protect the innocent" ;-) ]

STATUS = SQLExecDirect(HANDLE,"EXEC  @ = '"::"' ;")
STATUS = SQLBindCol(HANDLE, 1, SQL.B.DEFAULT, ) 
STATUS = SQLBindCol(HANDLE, 2, SQL.B.DEFAULT, ) 

LOOP
WHILE STATUS NE SQL.NO.DATA.FOUND DO
   STATUS = SQLFetch(HANDLE)
   GOSUB CHECK.SQLERROR
   IF ERROR.FLAG THEN RETURN
   IF STATUS NE SQL.NO.DATA.FOUND THEN
  * The SQL Stored Procedure may return an empty row for 'no hit'
  IF  NE '' THEN
 NUM.ROWS += 1
 OUTPUT.DATA<1,NUM.ROWS> = TRIM()
 OUTPUT.DATA<2,NUM.ROWS> = 
  END
   END
REPEAT

Hope this helps


Mike

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy
> Sent: Friday, 12 January 2007 13:21
> To: u2-users@listserver.u2ug.org
> Subject: [U2] UV Bci
> 
> Hello List,
> 
> 
> Has anyone called a sql server stored procedure with an 
> output parameter from UV using bci and gotten it to work ? 
> 
> Thx,
> 
> 
> Rudy Cooper
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV FILEINFO( Fvar, FINFO$HDRLAYOUT ) gone at 10.1, 10.2? {Unclassified}

[HENDERSON MIKE, MR]

Charles,

I have 10.1.18 (Windows) and the UNIVERSE.INCLUDE FILEINFO.H entries 
you are worried about are still there in the source code!
:-)

I ran your sample code and got what appears to be exactly the same
outputs.


Mike


> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
> Sent: Friday, 1 December 2006 10:23
> To: u2-users@listserver.u2ug.org
> Subject: [U2] UV FILEINFO( Fvar, FINFO$HDRLAYOUT ) gone at 10.1, 10.2?
> 
> After 10.0, does UNIVERSE.INCLUDE FILEINFO.H still have
>EQUATE FINFO$HDRLAYOUT TO 99
> followed by a section of FH$... equates?
> The documentation, by a sin of omission, suggests otherwise.
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [UV] Unexpected interaction between Transaction State and PHANTOM {Unclassified}

[HENDERSON MIKE, MR]

OK, this seems more than a bit weird to me (must be Friday afternoon!)
...

Our QA guys are testing a new VB.NET application which connects to UV
via UVObjects and calls a subroutine that calls a subroutine that writes
one record and PHANTOMs off a batch-type job.
The VB app was written with a UVObjects Begin Transaction and Commit
Transaction wrapped around it.
When they looked in the &PH& entry, it was full of 'Verb "" illegal when a transaction is active' error messages.

*
So it looks like Transaction State persists across a PHANTOM
invocation!?!?
I'm shocked, horrified, amazed, etc.
*

Is this a feature or a bug?
If a feature, is it documented anywhere?

Anyone come across this before?
Any suggestions on how to avoid it, other than not putting the web side
into Transaction State?
The whole point of writing a work-to-do record and PHANTOMing off the
worker process was to de-couple the Web and UV parts of the system.


Thanks


Mike

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] PCPERFORM - UniVerse Equialent {Unclassified}

[HENDERSON MIKE, MR]

Doug,

There are two alternatives:-

'DOS /c '
This is the direct equivalent of the Unix 'SH /c ', but it mangles strings containing double-quoted spaces, e.g.
'DOS /c MyUtility.exe -q"string with spaces"'
See HELP DOS

To get round that problem, a new GCI routine "UVRunCommand" was created
at v 10.0..
I think this is only documented in the Release Notes up to 10.1.  
In v10.2, it is in the "UniVerse GCI Guide" page 57.

Hope this helps


Mike


> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Doug Farmer
> Sent: Wednesday, 8 November 2006 10:12
> To: u2-users@listserver.u2ug.org
> Subject: [U2] PCPERFORM - UniVerse Equivalent
> 
> I am looking for the UniVerse equivalent to the UniData PCPERFORM
> command.  I need this to work on both Unix and Windows Platforms.
> Looking at the UniVerse documentation, I see the CSH and SH 
> commands, but they do not say they work on Windows Platforms.  
> Is there something I am missing?
> 
> Thanks
> 
> Doug Farmer
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Forcing a boolean comparison? {unclassified}

[HENDERSON MIKE, MR]

Yes

Better still, 
isTRUE=TRUE<12>="Y" 
Works the same and can be tricky to find when the second "=" is a typo
for adjacent or shifted keys "-" or "+"
:-(

Which is why I much prefer to see
isTRUE = @FALSE
IF TRUE<12> EQ "Y" THEN isTRUE = @TRUE

As a convention, I always use "=" for assignment only and "EQ" for
comparison


Mike

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of jjuser ud2
> Sent: Thursday, 21 September 2006 10:55
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Forcing a boolean comparison?
> 
> Good evening,
> 
> In UniBasic, does a statement like:
> 
> isTRUE=(TRUE<12>="Y")
> 
> force a boolean comparison instead of an assignment, such 
> that isTRUE is assigned a 1 or 0 as a value?
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Time/Date as a single number {Unclassified}

[HENDERSON MIKE, MR]

George

INT(((DATE() - 1) * 86500) + TIME())

will stay as ten digits until 07 JUL 2284, which might well be long
enough for your purposes

07 JUL 2284 is a ten-digit date+time:-
LIST file SAMPLE 1 EVAL"((DATE()+101470) * 86500) + TIME()"
EVAL"OCONV(DATE()+101470,"DE")"
ID955099.016  07 JUL 2284

But 08 JUL 2284 is an eleven-digit date+time:-
LIST file SAMPLE 1 EVAL"((DATE()+101471) * 86500) + TIME()"
EVAL"OCONV(DATE()+101471,"DE")"
ID   1041589.031  08 JUL 2284


HTH

Mike

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of George Gallen
> Sent: Wednesday, 13 September 2006 07:16
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Time/Date as a single number
>
> OK. what is the ?best? way to store the time/date (to the
> second) as a single number similar to unix's epoch, although
> I'm not looking to convert it to unix format.
>
> My method is take date()*86400+time()
> idate=int(combo/86400), itime=combo-(idate*86400)
>
> Is there anyway to do this giving less than 10 characters
> (and stay in base 10) ?
>
> George Gallen


The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe Logins {Unclassified}

[HENDERSON MIKE, MR]

John,

I am having the exact same problem, also on UV 10.1.18 / Windows 2003
Server SP1.
This particular user was away on an extended vacation during which his
password expired.  When his domain password was reset, he lost the
ability to log in as a Telnet user to the Development box using his
domain account.  He has a local login on that server, and is actually
part of the Administrators group (as his domain account), and he can log
in to that same server via Terminal Services, and can attach to all the
shares on the box that he needs.  He can still log in to the Test and
Production servers fine with his domain account, it's just Development
that won't work.   AARRR!!!

Because it's only Development, he logs in via Telnet to that with
another local account made up specially for this aggravation.

I have help but no joy so far from my support supplier on this.  Now I
have another example, I'll take it up again. Please do the same with
your support.


Thanks


Mike Henderson
--
Lead Applications Engineer (HR Systems), 
Joint Applications Engineering Group
Communications & Information Systems Branch
New Zealand Defence Force
DDI: +64 4 2371 828
Fax: +64 4 2371 807 
Mob: +64 21 300 654


> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Haas, John
> Sent: Friday, 25 August 2006 05:37
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Universe Logins
> 
> Nope. The name in UV.LOGINS and AD match.
> 
> -Original Message-
> > From: [EMAIL PROTECTED] On Behalf Of Arnold Bosch
> > Sent: Thursday, August 24, 2006 12:25 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] Universe Logins
> > 
> > 
> > Hi John
> > 
> > Check the case (upper/lower/mixed) of the user's name in 
> > Active Directory - If the case there doesn't not match the 
> > case in UV.LOGINS, you get this problem.
> > 
> > For example:  In Active Directory username = ArnoldB.  In 
> > UV.LOGINS, username = arnoldb causes this.
> > 
> > I learnt this the hard way when we migrated from Unix to 
> > Windows a couple of years ago; now I set up usernames in 
> > lowercase as a rule.
> > 
> > HTH
> > 
> > Arnold Bosch
> > IT Administrator
> > Taeuber & Corssen SWA (Pty) Ltd
> > 
> > 
> > -Original Message-
> > > From: [EMAIL PROTECTED] On Behalf Of Haas, John
> > > Sent: Friday, 25 August 2006 03:09
> > > To: u2-users@listserver.u2ug.org
> > > Subject: [U2] Universe Logins
> > > 
> > > I am using the Windows Universe platform version 10.1.18.
> > > 
> > > I have a user that receives the message indicating that she 
> > > is restrictd from logging into the account, and the telnet 
> > > session closes.
> > > 
> > > Other users login without any problem.   There is an entry 
> > > in UV.LOGINS, the domain is set correctly and the path to 
> > > the account is set correctly.  I have the user policy set 
> > > to 'home directory' and the full path D:\dir\uvaccount set 
> > > for the users.  There is no local login.
> > > 
> > > Are there any permissions that need to be set on the Windows 
> > > directory?
> > > 
> > > Any thoughts on what I missed in the set-up of this user.
> > > 
> > > Thanks.
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe ODBC driver performance issues {Unclassified}

[HENDERSON MIKE, MR]

Chris,

Yes, an I-Type and an I-descriptor are two words for the same thing.
The point I am making is that you can be exporting what looks on the
surface like a simple data item from UV via ODBC.  Then when you look at
the actual dictionary entry, you find it is an I-descriptor with perhaps
two levels of "T..." or a subroutine call to a several thousand
lines of code program which does I/O all over the place. This means that
you are effectively doing a multi-table join record by record to create
your normalised SQL data.

There are several things you could do to improve performance
*   One is to tweak the ODBC Client parameters, which you 
are trying.
It might just be that the ODBC protocol is so hopelessly slow that minor
improvements are all you will be able to achieve.

Other alternatives would be to try different technologies for the export
*   OLEDB is said to be quicker than ODBC and should be
fairly low effort to try
*   'pushing' the data via UniBasic programs and the 
UniVerse BCI may be quicker but could be a lot of
programming
*   a third-party product (or one you write yourself) that
  uses the UniObjects interface and protocol, or even a
home-rolled sockets interface, should be seriously quicker.


Chris, it seems to me that you may need to get some paid help on this.
The U2 list is a good place to start, it includes some very competent
people in various parts of the world who would be glad to provide you
with professional help.
Good luck!

Mike


> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Chris Brooks
> Sent: Saturday, 12 August 2006 02:02
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Universe ODBC driver performance issues 
> {Unclassified}
> 
> Mike,
> The NIC is reporting 1-2% busy.  Can you explain I-Type 
> Dictionary items?  Is an I-Type Dictionary Item equivalent to 
> a I-descriptor?  
> Sorry I am new to UniVerse, Thanks for your patience!!! 
> Chris 
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe ODBC driver performance issues {Unclassified}

[HENDERSON MIKE, MR]

John,

Chris is transferring on average about 360 (2.6M / 2 / 3600) records per
second.  If the records are ~200 chars, then he's getting about
700kb/sec (that's kb, not kB), or about 1.5% of the throughput you might
hope for on a 100Mbps Ethernet pipe!
So I'd say Chris does have an issue here.

I can see how increasing the block size would make the network traffic
less inefficient, it would be interesting to see what percent busy the
network card reports.

One of the other issues can be that the data contains, on the UV side,
complicated I-Type Dictionary items that mean that the exported data
isn't nearly as simple as it looks.  This can cause an unexpectedly
large amount of I/O on the UV side.

Mike

-Original Message-
From: [EMAIL PROTECTED] On Behalf Of John Hester
Sent: Friday, 11 August 2006 08:39
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues 

> -Original Message-
> From: [EMAIL PROTECTED] Behalf Of Chris Brooks
> Sent: Thursday, August 10, 2006 8:21 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Universe ODBC driver performance issues
> 
> I am new to the group and to UniVerse.  We are experiencing issues in 
> UniVerse 10.1.3 downloading data via the ODBC connection to SQL 
> Server.
> 2.6 mil records can take 2 hours to complete.  We are currently using 
> the default settings for the ODBC driver.  I will soon make changes to

> increase the prefetch and threshold values.  Any experience with the 
> ideal settings?  From my testing the best performance seems to be at 
> prefetch = 16383 and threshold = 4096 on the ODBC driver.  At this 
> settings seem to get a 30% performance increase.  I would like to see 
> it improve even more.
> 
>
> During the download the CPU is utilized less than 10%.

Sounds like you're I/O bound, although 2.6 million records in 2 hours
isn't all that bad in my experience.  Is it possible you're hitting the
threshold of your NICs, or competing with a lot of other network
traffic?  If both machines have multiple NICs, you could reserve one on
each machine for only talking to the other.  You could add an entry to
the hosts file on each so it would only know the other machine by the
reserved NIC's IP, then just make sure the reserved IP addresses don't
exist in DNS so no other machines will use them.  If the machines are
physically close, a crossover cable from NIC to NIC would eliminate any
switch performance issues.  At that point a rough calculation of your
throughput based on the average size of each record would tell you if
you're utilizing the available bandwidth, or if there's some other
bottleneck.

-John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Weird error {Unclassified}

[HENDERSON MIKE, MR]

Scott,

There are some HP-specific tuning parameters in UV10.x - 'SPINTRIES' and
'SPINSLEEP'.
Maybe these need to be set up somehow?

HTH


Mike

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
> Sent: Tuesday, 25 July 2006 07:11
> To: u2-Users
> Subject: [U2] [UV] Weird error
> 
> Hi all
> 
> UV10.1.8 (recent upgrade)
> HPUX 11
> 
> Has anyone ever seen the error "nanosleep: Interrupted system call" ?
> 
> I had a process running that was creating a flat file of 
> inventory history.  The process seemed to be hanging on a 
> READ.  I issued a PORT.STATUS against the pid when suddenly 
> the above error appeared and the process took off.
> 
> Any thoughts would be appreciated.
> 
> Also, I can't seem to remember where to look for bugs 
> reported against a particular release so if someone could 
> point me in the right direction, I'd sure appreciate it.
> 
> Thanks,
> 
> Scott
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] time() {Unclassified}

[HENDERSON MIKE, MR]

Barry,

I believe that all the UV platforms now return TIME() as a "9.999"
quantity, this was made uniform across the range sometime in the 10.0
timeframe.  Then sometime during 10.1, the TIMEACCURACY configuration
parameter appeared, I'd guess because too many people complained that
they had depended on the integer nature of TIME() on their platform.

As for the ~15ms 'tick' on Windows platforms, I think it's a tiny bit
variable between 15 and 16ms.  I wrote a program to check, and it gives
these results on UV10.1.18 / Win2003SP2:-
>MIKE.SMALLEST.TICK
THE.START "31048.042"
NAP.END "31063.666"
Average elapsed time of "NAP 1" is 15.62 milliseconds
 Minimum value of "NAP 1" is 15 milliseconds
 Maximum value of "NAP 1" is 16 milliseconds
Standard Deviation of "NAP 1" is 0.000 milliseconds
TIME.END "31079.291"
Average difference of "TIME()" is 15.62 milliseconds
Minimum difference of "TIME()" is 15 milliseconds
Maximum difference of "TIME()" is 16 milliseconds
Standard Deviation of "TIME()" is 0.484 milliseconds
>
The results were very, very similar on UV10.0.15, but I have not tried
it on other Windows platforms

Hope this helps


Mike

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Barry Brevik
> Sent: Saturday, 22 July 2006 10:41
> To: U2-users (E-mail)
> Subject: [U2] [UV] time()
> 
> The TIME() function is supposed to return the number of 
> seconds since midnight, in whole seconds on unix, but on 
> Windows machines it returns a real number implying it is 
> accurate to the nearest .001 second.
> 
> Of course, it doesn't, but I noticed on my server that it 
> rather reliably returns a number rounded to the nearest .015 
> or .016, giving about 64 divisions per second.
> 
> Back in the old days, the PC's time chip had a periodicity of 
> .054 seconds. Does anyone know how Universe manages to tic 
> every 16 milliseconds? It seems somewhat dependant on machine 
> load. With my head buried in programming, I suppose I might 
> have missed common hardware improvements .
> 
> My main concern is how reliable is it? In other words, under 
> heavy load can you miss a tic? On the old fashioned hardware 
> driven interrupt model, you would never miss a tic no matter 
> what the load. If it is reliable, it's too bad we can't write 
> interrupt handlers in Universe. That would be cool.
> 
> Barry Brevik
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] FW: On data models, data types and dangerous liaisons | The Register {Unclassified}

[HENDERSON MIKE, MR]

The author has posted a follow-up to the "multi-value harmful" article,
it's here:-
http://www.regdeveloper.co.uk/2006/07/22/data_models/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/