Re: [U2] History of Prime Information

2013-06-12 Thread Brett Callacher
I think it is a hard task for anyone to remember all this - gets complicated.  
This may help:
http://www.tincat-group.com/mv/familytree.html


Larry Hiscock lar...@wcs-corp.com wrote in message 
news:009e01ce42f0$092cac70$1b860550$@wcs-corp.com...
 If I recall correctly (and I may not ;-), Ardent was the company behind
 UniData.  Ardent and VMark merged (or Ardent acquired VMark -- I'm not 100%
 clear on the details), and retained the Ardent name.  Ardent was
 subsequently acquired by Informix, which was acquired by IBM, which later
 sold the U2 division to Rocket Software.
 
 Larry Hiscock
 Western Computer Services
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Taylor
 Sent: Friday, April 26, 2013 6:13 PM
 To: U2 Users List
 Subject: Re: [U2] History of Prime Information
 
 If I'm not mistaken, there was another company in between Vmark and IBM.
 
 I believe (and there may have been some smoke and mirrors in all this) that
 Informatics acquired Ardent and then assigned the CEO of Ardent as the
 President of Informatics, or something like that, to run both Ardent and
 Informatics.  And then later, IBM acquired Informatics for their database
 and just inherited Vardent almost by accident.
 
 Then, I believe that IBM acquired Unidata and formed the U2 product group.
 
 Certainly someone (Suzie) at Rocket could clarify this and perhaps publish
 an document for historical purposes to document this history completely and
 accurately.
 
 Dave Taylor
 Sysmark Information Systems, Inc.
 
 
 
  Prime Computer out of Natick Massachusetts went out of business.   One
  of their products was PR1ME INFORMATION.   They were acquired by another
  computer, Computervision (Thank you Mark, I'd forgotten the name).
 
  The product PRIME INFORMATION was acquired by VMark.   Vmark was later
  acquired by Ardent Software.
 
  I don't remember if there were any companies in between Ardent and 
  IBM, and while this was going on, there was a separate history 
  happening for Unidata.  Net upshot was that IBM acquired both Universe 
  and Unidata, and branded them as U2.
 
  Source - my memory, (such as it is).  I started playing with PR1ME 
  INFORMATION on a PR1ME 450-II back in 1978.
 
  I bought disk drives, controllers, and tape units off and on 
  throughout the years from Computronix, specifically from Randy Styka, 
  which is where I came into this conversation.
 
 
 
  On 4/26/2013 4:18 PM, Wjhonson wrote:
  so explain that better
  and whats the source?
 
 
 
 
 
 
 
 
  -Original Message-
  From: Allen Egerton aeger...@pobox.com
  To: U2 Users List u2-users@listserver.u2ug.org
  Sent: Fri, Apr 26, 2013 12:58 pm
  Subject: Re: [U2] TCL input and response logging (AD)
 
 
  I didn't say vmark acquired prime. I said they acquired prime 
  information.
 
  (Allen - Sent from my paperweight)
 
  On Apr 26, 2013, at 3:07 PM, Wjhonson wjhon...@aol.com wrote:
 
  That idea doesn't seem right Allen.
  I can't find any reference to Vmark acquiring Prime, after Prime's 
  bankruptcy.
  One reference says that the Prime assets all went to ComputerVision, 
  but it's
  just a blog
  Anyone have a newspaper article link ?
 
 
 
 
 
 
 
 
  -Original Message-
  From: Wjhonson wjhon...@aol.com
  To: u2-users u2-users@listserver.u2ug.org
  Sent: Fri, Apr 26, 2013 11:58 am
  Subject: Re: [U2] TCL input and response logging (AD)
 
 
  I'll have to update the wiki poo pea a pages
 
  Who is the woman in this picture?
 
  http://en.wikipedia.org/wiki/File:Prime9950_kean.jpg
 
 
 
 
 
 
 
 
 
  -Original Message-
  From: Allen Egerton aeger...@pobox.com
  To: U2 Users List u2-users@listserver.u2ug.org
  Sent: Fri, Apr 26, 2013 11:31 am
  Subject: Re: [U2] TCL input and response logging (AD)
 
 
  Prime Information was a product running as an application on PRIMOS.
 
   It was acquired by Vmark and subsequently by Advent if memory 
  serves me correctly.
 
  IBM acquired Universe and Unidata and subsequently sold them to Rocket.
 
  (Allen - Sent from my paperweight)
 
  On Apr 26, 2013, at 1:40 PM, Wjhonson wjhon...@aol.com wrote:
 
  I don't think Universe was ever Prime.
 
 
 
 
 
 
 
 
  -Original Message-
  From: Allen Egerton aeger...@pobox.com
  To: U2 Users List u2-users@listserver.u2ug.org
  Sent: Thu, Apr 25, 2013 5:06 pm
  Subject: Re: [U2] TCL input and response logging (AD)
 
 
 
  On 4/25/2013 5:36 PM, Randy Styka wrote:
  Hi!
 
  It's been a long time since I posted here but our company, 
  Computronics, has sold a product called PEEK for Unix systems 
  since 1993.  It is most often used for remote support, to see what 
  is on someone's screen.
  And,
  if needed to send keystrokes as if they were typing them, to help 
  them out or close out programs.
 
  But one of the other uses is for logging.  PEEK can be set up to 
  fire off a background process when a user logs in.  That process 
  is 

Re: [U2] Replacements for Old SB?

2013-03-20 Thread Brett Callacher
What also doesn't help is that SB+ was rebranded as System Builder, i.e. the 
same name as the old product.

I recall using the wrapper Brian refers to convert old screens - it was only 
really a half-way house and any screen with any complexity ended up being 
re-written anyway.

Tony Gravagno 3xk547...@sneakemail.com wrote in message 
news:316-1363123376-413...@sneakemail.com...
 From Wjhonson
  Of all the jobs posted over the past several years, several have
 asked
  for SB+ experience, none have asked for any other product of that
 class.
 
 I'll respond to that here because it dove-tails with what I have
 below. You don't see ads, in-part, because the sites still running the
 old software are largely not aware that an MV community exists that
 might respond to such an ad. Many of them don't even know what
 software they have running on their DOS system. Most of them that I
 run across have no consultants (I dare say Value-Add Reseller) who
 strongly insists on upgrades. The result is that they only reach out
 to the world after a hard drive failure, hurricane, or some other
 catastrophe. More below. 
 
 
  From: Brian Leach
  So an 80% conversion is easy ..
 
 Yeah, everyone claims to do 80%, some only really do 50%. But we all
 know it's that last 20% that occupies your time for the next year or
 three. So perhaps to further refine the query, I'm looking for tools
 that really do bring us closer to that 95-98% mark - with no marketing
 fluff to bridge the gap between there and 80%.
 
 I don't have any immediate opportunities but I keep stumbling on these
 poor sites. And if I do, and picking up orphans isn't my business,
 then you gotta know that people who do go after that business must be
 finding more of these. Some of these sites have gone through
 developers (aka snake-oil salesmen) who claim they're going to convert
 the software but never do, and eventually the sites just migrate away
 from MV. It's a terrible story.
 
 [uh oh, soapbox alert]
 You'd think the MV DBMS providers would take some interest in this but
 I've yet to see any of them pro-actively offer assistance to any of
 these sites, for-fee or otherwise. I know the original intent was to
 discontinue support for SB and  earlier SB+ in an effort to force
 end-users to migrate to U2. That tactic worked for some sites but the
 people who implemented that policy simply didn't have a plan-B for the
 large number of sites that didn't fall for it. They were thinking
 about starving out their DBMS competition by leveraging this tool.
 What actually happened is that end-users decided not to upgrade their
 DBMS just so they could keep using SB, and these sites migrate away
 from the model as soon as some young nephew comes along. So everyone
 loses with this predatory approach.
 
 I'm not asking any company to maintain software when it's not in their
 financial interest, nor to chase small sites that are more inclined to
 drop support than to migrate to a new platform. But from a marketing
 perspective we all lose when a policy like this is only
 half-implemented. 
 
 Regards,
 T
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] uniobjects.net

2012-12-04 Thread Brett Callacher
Similarly, you can do a SELECT file SAVING field1 field2 

Then read that select list either by subroutine or directly.

The only catch is you need to make sure there is an 'A' in attribute 4 of the 
select verb.

Kate Stanton k...@walstan.com wrote in message 
news:caawmjlj_uwxsopifb0fmc9udvmvpfnuauq3czgcvzu+ct_o...@mail.gmail.com...
 Why not call a subroutine to do REFORMAT to a file, then read the file and
 return the output.  That will give you your I-type data (if I am reading
 what you are after correctly).
 
 On 4 December 2012 03:48, Symeon Breen syme...@gmail.com wrote:
 
  Hi - I have been using uniobjects.net for many years now,   however I
  usually use it to call a basic subroutine on the u2 server.  I now have a
  little project where I need to get a number of records from a file, ideally
  like the output of a list command as I have some itypes I also need to get.
 
  I could do this via a select list and read the ids into a unidataset and
  then call other programs to get the itype data, or I could do a unixml
  probably a few other ways.
 
 
 
  So what is the best way to do this ?
 
 
 
 
 
 
 
  Thanks
 
  Symeon.
 
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.org
  http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 
 
 -- 
 Kate Stanton
 Walstan Systems Ltd
 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
 Phone: + 64 9 360 5310  Mobile: + 64 21 400 486
 Email: k...@walstan.com
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] [UD] Multi-Level Files

2012-11-07 Thread Brett Callacher
Am not sure why you would be getting the last hashed dictionary item passed.

However, I think you would need to pass something other than @ID to your 
subroutine - a multivalue of files via another I descriptor with subroutine.  
Don't know about in UniData but in UniVerse VOC4 has M and 7 an mv of data 
sections.  The file to open is AccountPath/APOPEN/HISTORY for instance.

As an alternative you could try using a Q pointer to each data section.

HTH

Brett

Bill Haskett wphask...@advantos.net wrote in message 
news:5095a055.8090...@advantos.net...
 I build the following subroutine to be used by a dictionary.
 
 SUBROUTINE D.GETFILEINFO ( Value, atID )
 *
 ** Get information on file using FILEINFO()
 *
 ** Initialize local variables
 SP1   = ' '
 NULL$ = ''
 *
 ** Assign passed variables
 Value= NULL$ ; ** initialize return variable
 FileName = atID  ; ** the name of the file (key)
 *
 ** Open the file and get the file information to pass back
 OPEN '', FileName TO FileName.FV THEN
 Modulo= FILEINFO(FileName.FV, 5)
 BlockSize = FILEINFO(FileName.FV, 8)
 BlockCode = INT(BlockSize / 1024)
 Value = Modulo : ',' : BlockCode
 CLOSE FileName.FV
 END ELSE
 Value = NULL$
 END
 *
 RETURN
 END
 
 I use this program in a dictionary item called F_SIZE.
 
 3 Dev (0)- AE VOC F_SIZE
 Top of F_SIZE in VOC, 6 lines, 95 characters.
 *--: P
 001: I Return the file information on the defined size
 002: SUBR ( D.GETFILEINFO, @ID )
 003:
 004: FileInfo
 005: 10R
 006: S
 Bottom.
 
 ...which returns the size of the file.  When I use this on a multi-level 
 file it fails to return the file size.  e.g.
 
 3 Dev (0)- LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE
 LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE 14:50:50 Nov 03 2012 1
 VOC... Data Location FileInfo..
 
 APOPEN APOPEN
 HISTORY
 HOLD
 APPO APPO11,1
 2 records listed
 
 It works fine on regular files.  I tracked the problem down to UniData 
 doesn't pass in the name of the file to the called subroutine, @ID 
 doesn't work.  What is passed is the last hashed dictionary item of the 
 APOPEN dictionary file.  When I put a CRT statement in the program 
 code just below where the FileName variable is assigned...
 
 CRT FileName
 
 ...the list output looks like this:
 
 3 Dev (0)- LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE
 *BALANCE*
 LIST VOC 'APOPEN''APPO' F_DATAW F_SIZE 14:50:50 Nov 03 2012 1
 VOC... Data Location FileInfo..
 
 APOPEN APOPEN
 HISTORY
 HOLD
 *APPO*
 APPO APPO11,1
 2 records listed
 
 I discovered this because I listed the dictionary of the APOPEN file; 
 which looks like:
 
 3 Dev (0)- LIST DICT APOPEN NOPAGE
 LIST DICT APOPEN NOPAGE 14:51:11 Nov 03 2012 1
 Dict Name..
 
 ACCT_F
 REP
 TEST2
 @UQ
 ACCT_L
 .
 CHECK_ID
 @HOLD
 @APOPEN
 VNAME20
 .
 APPROVED
 @ID
 AS_LKS
 .
 BNAME
 CBALANCE
 ACCTS_VCNT
 ACCT_CNT
 AMTS1
 APMY
 *BALANCE*
 99 records listed
 
 ...and BALANCE, which UD passes into the subroutine, happens to be the 
 last dictionary item hashed into the APOPEN dictionary file.  Any idea 
 why this is the case, or is this some kind of feature.
 -- 
 Untitled Page
 
 Bill Haskett
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] Etymology of Q-Pointer

2012-09-12 Thread Brett Callacher
Completely agreed.  Even within Universe the longer Locate syntax can be 
ambiguous.

Tony Gravagno 3xk547...@sneakemail.com wrote in message 
news:14130-1347054812-792...@sneakemail.com...
 I do the exact opposite for exactly the same reasons. :)
 I use the Locate function rather than statement because I find it
 easier to read and 99% consistent across all platforms.
 
 T
 
  From: John Lorentz 
  I fully believe that I've never used the function ever since they
 introduced
  it as an alternative to the function on Reality sometime in the late
 70s.
  While there are some small differences between Pick platforms on the
  layout of the LOCATE statement (having to do with searching values,
  subvalues, etc.), it's so much easier to read than using the
 function.
  
  But then, I've only been programming in Pick since 1978...
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] RESIZE - dynamic files

2012-07-03 Thread Brett Callacher
Almost.  Though the file will look after itself, it may not do so very well.  
Dynamic files, for best performance, do sometimes need periodic resizing.  
Having said that it is true that some never resize Dynamic files.

If the minimum modulo is much lower than the actual, then this will cause 
constant splits to occur if the file is constantly growing.  The 80% actual 
load is further indication of this.  What can be even worse is if the file then 
shrinks dramatically in this case as very intensive merges will takes place - 
not desirable if you expect the file to grow again.

In this case I would choose a new modulo greater than the actual - how much 
bigger depends on the rate of growth expected.  That is with the current 
separation - the best separation you will only determine by examining the size 
of the records.

Martin Phillips martinphill...@ladybridge.com wrote in message 
news:00f601cd588c$cd3d1310$67b73930$@ladybridge.com...
 Hi Chris,
 
 The whole point of dynamic files is that you don't do RESIZE. The file will 
 look after itself, automatically responding to
 variations in the volume of data.
 
 There are knobs to twiddle but in most cases they can safely be left at 
 their defaults. A dynamic file will never perform as well
 as a perfectly tuned static file but they are a heck of a lot better than 
 typical static files that haven't been reconfigured for
 ages.
 
 
 Martin Phillips
 Ladybridge Systems Ltd
 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
 +44 (0)1604-709200
 
 
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: 02 July 2012 20:22
 To: u2-users@listserver.u2ug.org
 Subject: [U2] RESIZE - dynamic files
 
 
 I was wondering if anyone had instructions on RESIZE with a dynamic file? For 
 example I have a file called 'TEST_FILE'
 with the following:
 
 01 ANALYZE.FILE TEST_FILE
 File name ..   TEST_FILE
 Pathname ...   TEST_FILE
 File type ..   DYNAMIC
 File style and revision    32BIT Revision 12
 Hashing Algorithm ..   GENERAL
 No. of groups (modulus)    83261 current ( minimum 31 )
 Large record size ..   3267 bytes
 Group size .   4096 bytes
 Load factors ...   80% (split), 50% (merge) and 80% (actual)
 Total size .   450613248 bytes
 
 How do you calculate what the modulus and separation should be? I can't use 
 HASH.HELP on a type 30 file to see the recommended
 settings
 so I was wondering how best you figure out the file RESIZE.
 
 Thanks,
 
 Chris
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] User ID of a LOCKED record

2012-05-04 Thread Brett Callacher
The issue with LIST.READU and the pid is a known issue in 11.1.1 and a fix is 
scheduled to be available in 11.1.3 

As I think that 11.1.1 was a Windows release, it may only affect Windows.

Wjhonson wjhon...@aol.com wrote in message 
news:8cef5d423cf37bc-19d0-24...@webmail-m105.sysops.aol.com...
 
 I think the difference is probably not the release version number, but rather 
 the operating system.
 This is Universe on WINDOWS, you are probably on Unix.
 
 
 
 -Original Message-
 From: Wjhonson wjhon...@aol.com
 To: u2-users u2-users@listserver.u2ug.org
 Sent: Tue, May 1, 2012 10:06 am
 Subject: Re: [U2] User ID of a LOCKED record
 
 
 
 niverse 10.2.3
  LIST.READU
 ctive Record Locks:
 evice Inode. Netnode Userno   LmodePid Item-ID
 ..
 566926395 1210555995   0   27368 RU   2736 16193-12-25
 291123247  403366260   0   5436   30 RU   5436 181424343
 252535158 1093183945   0   5436   39 RU   5436 181424343
 119682271   15147876   0   2804   42 RU   2804 44050
 998816505 1380435731   0   2804   45 RU   2804 44050
 759630365  344848829   0   6008   58 RU   6008 B18561
 290469198  999414438   0   6008   64 RU   6008 B18561
 016887084 1213711733   0   4144   67 RU   4144 C8671402037
 759630365  344848829   0   7644   69 RU   7644 863535
 290469198  999414438   0   7644   75 RU   7644 863535
 469823969 1880557134   0   5660   95 RU   5660 RETRO.PAYROLL
 
 
 Original Message-
 rom: Dianne Ackerman dia...@aptron.com
 o: U2 Users List u2-users@listserver.u2ug.org
 ent: Tue, May 1, 2012 6:23 am
 ubject: Re: [U2] User ID of a LOCKED record
 
 t does on my system - uv 10.2.7
 LIST.READU
 ctive Record Locks:
 vice Inode  Netnode Userno   LmodePid Login Id 
 em-ID
 ...
6553741067810 15   29 RU 499890 dianne   TEST
 On 4/30/2012 7:28 PM, Wjhonson wrote:
 LIST.READU -INTERNAL
 you don't need the EVERY to see record locks
  but how wild that -INTERNAL gives you the USER NAME !
 And the regular LIST.READU does not (even though the documentation says it 
 ll)
 
 
 
 
  -Original Message-
 From: Buss, Troy (Contractor, Logitek Systems) (Contractor, Logitek 
 stems)troy.b...@nordsonasymtek.com
 To: U2 Users Listu2-users@listserver.u2ug.org
 Sent: Mon, Apr 30, 2012 4:23 pm
 Subject: Re: [U2] User ID of a LOCKED record
 
 On Universe:
 LIST.READU -EVERY - INTERNAL
 Gives details without truncation for capturing in basic.
 _
 canned by IBM Email Security Management Services powered by MessageLabs. For
 ore information please visit http://www.ers.ibm.com
 This email is intended only for the use of the party to which it is addressed
 nd may contain information that is privileged, confidential, or protected by
 aw.  If you are not the intended recipient you are hereby notified that any
 issemination, copying or distribution of the email or its contents is strictly
 rohibited.  If you have received this message in error, please notify us
 mmediately, by replying to the message and deleting it from your computer.
 WARNING: Internet communications are not assured to be secure or clear of
 naccuracies as information could be intercepted, corrupted, lost, destroyed,
 rrive late or incomplete, or contain viruses.  Therefore, we do not accept
 esponsibility for any errors or omissions that are present in this email, or
 ny attachment, that have arisen as a result of e-mail transmission.
 
 __
 2-Users mailing list
 2-us...@listserver.u2ug.org
 ttp://listserver.u2ug.org/mailman/listinfo/u2-users
  ___
 __
 -Users mailing list
 -us...@listserver.u2ug.org
 tp://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 2-Users mailing list
 2-us...@listserver.u2ug.org
 ttp://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP 

Re: [U2] Building an Excel File

2012-02-08 Thread Brett Callacher
Have encountered exactly this issue.  

You can convert the raw xml to xlsx (using DocumentFormat.OpenXml.Spreadsheet) 
and Excel will happily open this.  Sadly, have found that iPhone still can't.  
Not sure why yet but it may be an Apple thing:
https://discussions.apple.com/thread/2494221?start=0tstart=0

Brett

Israel, John R. johnisr...@daytonsuperior.com wrote in message 
news:c60fce7b7dfbba4a82b3dfac17e23d0c0f4acdd...@mbexmbx03.daysup.com...
 No, the Smart Phones can not open the XML at all.  The txt and xls files can 
 be opened, but they are just text.  Managers want to be able to read the 
 files cleanly.
 
 I am guessing the issue is that when a smart phone opens a true Excel file, 
 it is not running Excel, but some sort of emulator.  The emulator does not 
 have all the bells and whistles that a full blown version of Excel has, thus 
 undesirable results.
 
 John
 
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
 Sent: Monday, February 06, 2012 4:45 PM
 To: U2 Users List
 Subject: Re: [U2] Building an Excel File
 
 Can they open an XML file coded for Excel, but without formatting and colors 
 and such?
 If so, you may just have to have two files produced, one for the phones and 
 one for desktops.
 
 I haven't checked, but are there any perl modules that can convert an XML 
 file to an .xls file
This would require unix, but not any user intervention.
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
 Sent: Monday, February 06, 2012 4:40 PM
 To: 'U2 Users List'
 Subject: [U2] Building an Excel File
 
 We are running UniData on a UNIX platform.  We create tab-delimited txt files 
 (and tab delimited txt files with xls extensions) all the time that users 
 open with Excel.  Many of these jobs are run in the middle of the night or in 
 a trigger program.  In all cases, there is no direct user interaction 
 building these files.
 
 We also have some XML files that are coded so that Excel opens them with 
 formatting, colors, filters, etc.
 
 Unfortunately, our BB users and iPhone users can not open these files up in a 
 meaningful way.
 
 Is there a way to build a TRUE Excel file without any user intervention from 
 UniData or UNIX?
 
 John
 
 
 
 
 
 John Israel
 Senior ERP Developer
 
 Dayton Superior Corporation
 1125 Byers Rd  Miamisburg, OH 45342
 Office: 937-866-0711 x44380
 Fax: 937-865-9182
 
 johnisr...@daytonsuperior.com
 
 This message w/attachments (message) is intended solely for the use of the 
 intended recipient(s) and may contain information that is privileged, 
 confidential or proprietary. If you are not an intended recipient, please 
 notify the sender, and then please delete and destroy all copies and 
 attachments, and be advised that any review or dissemination of, or the 
 taking of any action in reliance on, the information contained in or attached 
 to this message is prohibited.
 
 
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] Uniobjects for Java and Domino 8

2011-12-14 Thread Brett Callacher
Since I was under the impression that UniObjects is still supported, am also 
interested in the response to this.  

jim.sto...@esc.edu wrote in message 
news:of751a420f.4c7bb679-on85257965.0075e4a7-85257965.00761...@esc.edu...
 Hi Dan,
 
 Thanks for this information.
 
 Can you tell us if Rocket has any plans to further develop / support the 
 original COM/OLE version of UniObjects?  And in particular, are there any 
 plans to release a 64 bit version?
 
 Thank you,
 Jim Stoner
 SUNY Empire State College
 
 
 
 From:   Daniel McGrath dmcgr...@rocketsoftware.com
 To: U2 Users List u2-users@listserver.u2ug.org
 Date:   12/07/2011 05:00 PM
 Subject:Re: [U2] Uniobjects for Java and Domino 8
 Sent by:u2-users-boun...@listserver.u2ug.org
 
 
 
 I missed this email.
 
 Q: Will UOJ be further developed and supported by Rocket in the future?
 A: Yes. There are no plans on changing this answer in the foreseeable 
 future either.
 
 Regards, 
 
 Dan McGrath
 U2 Product Manager
 Rocket Software
 Web: www.rocketsoftware.com/u2 
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [
 mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
 charles_shaf...@ntn-bower.com
 Sent: Wednesday, December 07, 2011 10:22 AM
 To: U2 Users List
 Subject: Re: [U2] Uniobjects for Java and Domino 8
 
 Great information John and Robert.   Looks like UOJ is getting mature. 
 In my situation, it is attractive since we use Domino and Unidata 
 extensively.  But, I do not want to invest my time in something that won't 
 be supported in the future.
 
 My question for Rocket is Will UOJ be further developed and supported by 
 Rocket in the future? 
 
 Thanks.
 
 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 
 Robert said:
 Hi John,
 
 On Fri, Dec 2, 2011 at 10:01 AM, John Hester jhes...@momtex.com wrote:
  We've been using UOJ with WebSphere App Server since around 2003.  Not 
  quite the same as Domino, I realize, but at least under the same IBM 
  Java middleware umbrella.  I can't offer a lot the way of best 
  practices, but I can say that the combination is robust and 
  trouble-free.  This is more OS related, but if you're connecting to or 
  from a linux box you need to make sure the LANG environment variable 
  is set correctly.  The RedHat default is incorrect for UOJ (at least 
  up to EL 5) and will result in MV delimiters being incorrectly 
  translated into other ascii characters.  RedHat EL 5 stores the LANG 
  value in /etc/sysconfig/i18n and the official setting I was given by 
  IBM is en_US.iso885915.
 
 The above has caused me many problems in both web applications and running 
 UOJ on mobile devices.
 
 I got a debugger out and went through what is happening, it appears UOJ is 
 using deprecated routines within java and writing invalid data to the udcs 
 server. The deprecated routines are using the systems character encoding 
 to convert 16bit java characters to 8bit bytes.  As the host systems 
 character encoding is variable thus different data will be sent to the 
 server depending on what location and operating system is used.
 
 Roughly the uniobjects conversion routines grab the java system property 
 file.encoding which is meant for reading and writing files and use it 
 directly and indirectly to write data to the socket.
 
 Quick fix is on the java command line -Dfile.encoding=iso8859_1
 Warning: once java program is running ie
 System.setProperty(file.encoding,iso8859_1) does not work as a bunch 
 of system level stuff is cached on startup.
 
 The above quick fix has many bad side effects as the java process now 
 has the wrong character encoding to read and write files on the local 
 system and has caused me issues in third party libraries which expect to 
 be able to read and write files correctly.  ie my web server should be 
 emitting utf8 for maximum compatibility but is putting out
 iso8859_1 for most files thanks to this quick fix
 
 It would be better for the rocket engineers to decide on a character 
 encoding to talk to the server with and set it as a separate define(or 
 hard code it maybe), according to oracle the basic encodings below should 
 be available on most jvms :
 http://docs.oracle.com/javase/1.3/docs/guide/intl/encoding.doc.html
  
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 

Re: [U2] U2 known issues, patches

2011-11-15 Thread Brett Callacher
Thanks for the updates on this Wally, that is very informative.

If by 'notice' file, you refer to the Alert link next to each release number, 
then I can only see this if I log in.  This is certainly an improvement but 
does not really address the issue here.

It would seem that the best way we have of getting this information is through 
this forum.  And that is only useful if you know what question to ask! I have 
an issue right now where I would like to choose the right version to evaluate 
for a client.  We do not have the information we need to make that call - to be 
able to search on the faults logged and the release where it was, or is 
scheduled, for a fix for each platform would assist here greatly.

Regards

Brett

Wally Terhune wterh...@rocketsoftware.com wrote in message 
news:0d0b269b9fd7a64687f66c66d6f49fab12c47...@nwt-s-mbx1.rocketsoftware.com...
 Brett:
 We have recently started publishing some known problems.
 When you look at the Product Availability Matrix (PAM) (publicly available - 
 no login required: https://u2tc.rocketsoftware.com/matrix.asp) and are 
 considering a release to upgrade to, there is a new link to 'Notice' file. 
 This includes some selected items you might want to know about before 
 upgrading.
 
 Looking at the 11.1.4 release note file (which I downloaded from the PAM from 
 the AIX platform), we did fix the UOLOGIN at 11.1.3:
 
 UNV-5255  UniVerse -- Before this release, if an attempt was made 
   to connect to the server using UniObjects, UniObjects for 
   Java, or UniObjects for .NET and the globally cataloged 
   program *UOLOGIN did not exist, the following error message 
   was written to the errlog in the UVHOME directory:
 
   Incorrect VOC entry for UOLOGIN
 
   Now, UniVerse uses the *UOLOGIN cataloged program if 
   it exists, but does not report an error message and
   continues processing if it does not.
 
 
 The LIST.READU issue you note (UNV-5010) appears to be a Windows platform 
 only issue. We are down to the final QA testing for the 11.1.5 release for 
 Windows. We expect this to be released shortly. It contains the fix for this 
 issue.
 
 Regards,
 
 Wally Terhune
 U2 Support Architect
 Rocket Software
 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
 Tel: +1.720.475.8055
 Email: wterh...@rs.com
 Web: www.rocketsoftware.com/u2
 
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brett Callacher
 Sent: Friday, November 11, 2011 9:51 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] U2 Replication on Universe
 
 Have been asking for known issues to be included in the knowledge base for 
 some time now so that one could search on a release and make this sort of 
 judgement call. Have not had any success with this.
 
 Can't comment on replication but we have found a couple of issues with 
 11.1.1, the first one quite serious:
 
 1.  LIST.READU no longer reports the pid that has the lock.  This has been 
 fixed and we were advised in April that this would be in 11.1.3.  We do not 
 know of a scheduled release date for this.
 2.  UniObjects logins generate '*UOLOGIN is not in the CATALOG space' in 
 the runtime error log if there is no UOLOGIN routine.  This will be fixed in 
 a 'subsequent' release.
 
 HTH
 
 Brett
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] U2 known issues, patches

2011-11-15 Thread Brett Callacher
Wally,

Ok, I can see the Notice link now on 11.1.  Have emailed Ask Us.

Thanks

Brett

Wally Terhune wterh...@rocketsoftware.com wrote in message 
news:0d0b269b9fd7a64687f66c66d6f49fab318b2...@nwt-s-mbx2.rocketsoftware.com...
 There is a 'Notice' link in the PAM. These are new and only created for 7.2 
 and 11.1 releases (not older versions). As you point out, it is only 
 available if you are logged in to u2techconnect - so not publically 
 available. While the notes there do indicate at which patch level a fix is 
 planned, we are not trying to provide the platform rollout details in that 
 format. 
 
 Please direct your requests for improvements in this area to 
 u2as...@rocketsoftware.com.
 Regards,
 
 Wally Terhune
 U2 Support Architect
 Rocket Software
 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
 Tel: +1.720.475.8055
 Email: wterh...@rs.com
 Web: www.rocketsoftware.com/u2
 
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brett Callacher
 Sent: Tuesday, November 15, 2011 3:11 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] U2 known issues, patches
 
 Thanks for the updates on this Wally, that is very informative.
 
 If by 'notice' file, you refer to the Alert link next to each release number, 
 then I can only see this if I log in.  This is certainly an improvement but 
 does not really address the issue here.
 
 It would seem that the best way we have of getting this information is 
 through this forum.  And that is only useful if you know what question to 
 ask! I have an issue right now where I would like to choose the right version 
 to evaluate for a client.  We do not have the information we need to make 
 that call - to be able to search on the faults logged and the release where 
 it was, or is scheduled, for a fix for each platform would assist here 
 greatly.
 
 Regards
 
 Brett
 
 Wally Terhune wterh...@rocketsoftware.com wrote in message 
 news:0d0b269b9fd7a64687f66c66d6f49fab12c47...@nwt-s-mbx1.rocketsoftware.com...
  Brett:
  We have recently started publishing some known problems.
  When you look at the Product Availability Matrix (PAM) (publicly available 
  - no login required: https://u2tc.rocketsoftware.com/matrix.asp) and are 
  considering a release to upgrade to, there is a new link to 'Notice' file. 
  This includes some selected items you might want to know about before 
  upgrading.
  
  Looking at the 11.1.4 release note file (which I downloaded from the PAM 
  from the AIX platform), we did fix the UOLOGIN at 11.1.3:
  
  UNV-5255UniVerse -- Before this release, if an attempt was made 
  to connect to the server using UniObjects, UniObjects for 
  Java, or UniObjects for .NET and the globally cataloged 
  program *UOLOGIN did not exist, the following error message 
  was written to the errlog in the UVHOME directory:
  
  Incorrect VOC entry for UOLOGIN
  
  Now, UniVerse uses the *UOLOGIN cataloged program if 
  it exists, but does not report an error message and
  continues processing if it does not.
  
  
  The LIST.READU issue you note (UNV-5010) appears to be a Windows platform 
  only issue. We are down to the final QA testing for the 11.1.5 release for 
  Windows. We expect this to be released shortly. It contains the fix for 
  this issue.
  
  Regards,
  
  Wally Terhune
  U2 Support Architect
  Rocket Software
  4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
  Tel: +1.720.475.8055
  Email: wterh...@rs.com
  Web: www.rocketsoftware.com/u2
  
  
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org 
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brett Callacher
  Sent: Friday, November 11, 2011 9:51 AM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] U2 Replication on Universe
  
  Have been asking for known issues to be included in the knowledge base for 
  some time now so that one could search on a release and make this sort of 
  judgement call. Have not had any success with this.
  
  Can't comment on replication but we have found a couple of issues with 
  11.1.1, the first one quite serious:
  
  1.  LIST.READU no longer reports the pid that has the lock.  This has been 
  fixed and we were advised in April that this would be in 11.1.3.  We do not 
  know of a scheduled release date for this.
  2.  UniObjects logins generate '*UOLOGIN is not in the CATALOG space' in 
  the runtime error log if there is no UOLOGIN routine.  This will be fixed 
  in a 'subsequent' release.
  
  HTH
  
  Brett
  
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.org
  http://listserver.u2ug.org/mailman/listinfo/u2-users
  
  
 This message contains information that may be privileged or confidential and 
 is the property of GPM Development Ltd

Re: [U2] U2 Replication on Universe

2011-11-11 Thread Brett Callacher
Have been asking for known issues to be included in the knowledge base for some 
time now so that one could search on a release and make this sort of judgement 
call. Have not had any success with this.

Can't comment on replication but we have found a couple of issues with 11.1.1, 
the first one quite serious:

1.  LIST.READU no longer reports the pid that has the lock.  This has been 
fixed and we were advised in April that this would be in 11.1.3.  We do not 
know of a scheduled release date for this.
2.  UniObjects logins generate '*UOLOGIN is not in the CATALOG space' in the 
runtime error log if there is no UOLOGIN routine.  This will be fixed in a 
'subsequent' release.

HTH

Brett

Amy Raisanen araisa...@rammutual.com wrote in message 
news:d76bac9cbfb0f040b820c12e55b227ca03039...@mail.corp.rammutual.com...
 Anyone have experience or insight on upgrading on Universe on Windows
 from 10.2.10 to 11.1.1 and/or implementing replication on Windows?  
 
  
 
 I realize there are alerts on this release, is there any word when the
 next possibly more stable release maybe be available for Windows?  Would
 it be worth waiting and just upgrade to 10.3.12 for now?
 
  
 
 Amy Raisanen
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] The math just doesn't work.

2011-10-11 Thread Brett Callacher
Hi Bill,

I think you would need to set Wide Zero to something like the UV default (2.91 
* 10^-11) to do a comparative test.

Thanks for checking anyway.

Brett

Bill Haskett wphask...@advantos.net wrote in message 
news:4e933047.6050...@advantos.net...
 Brett:
 
 When I run the following code on UD v7.2.7, it works fine.
 
 *
 ** Test program
 EXECUTE \SET.WIDEZERO 0.01\
 *
 NUL = ''
 CM = ','
 A = -409071.8775: CM: 475000: CM: -652413: CM: 652413: CM: -475000: CM: 
 409071.8775
 *
 TEST.VMC = 1
 TEST.TOTAL = 0
 *
 LOOP UNTIL FIELD(A, CM, TEST.VMC) = NUL DO
 TEST.TOTAL += FIELD(A, CM, TEST.VMC)
 TEST.VMC += 1
 REPEAT
 *
 IF TEST.TOTAL = 0 THEN
 PRINT 'OK'
 END ELSE
 PRINT TEST.TOTAL, (TEST.TOTAL = 0), TEST.TOTAL - 0, 
 (OCONV(TEST.TOTAL, 'MD0') = 0)
 END
 
 *2 Dev (0)- RUN BP BILL
 OK*
 
 HTH,
 
 Bill
 
 
 - Original Message -
 *From:* bre...@gpmdev.co.uk
 *To:* u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
 *Date:* 10/10/2011 1:16 AM
 *Subject:* Re: [U2] The math just doesn't work.
  I also thought: great explanation and nodded sagely when I read this.  
  However, consider this code:
 
 
 
 NUL = ''
 
 CM = ','
 
 A = -409071.8775: CM: 475000: CM: -652413: CM: 652413: CM: -475000: 
  CM: 409071.8775
 
  *
 
  *
 
 TEST.VMC = 1
 
 TEST.TOTAL = 0
 
  *
 
 LOOP UNTIL FIELD(A, CM, TEST.VMC) = NUL DO
 
TEST.TOTAL += FIELD(A, CM, TEST.VMC)
 
TEST.VMC += 1
 
 REPEAT
 
  *
 
 IF TEST.TOTAL = 0 THEN
 
PRINT 'OK'
 
 END ELSE
 
PRINT TEST.TOTAL, (TEST.TOTAL = 0), TEST.TOTAL - 0, 
  (OCONV(TEST.TOTAL, 'MD0') = 0)
 
 END
 
 
 
 
 
  Running this on our Universe system 11.1.1 produces:
 
 
 
  0 0 0 1
 
 
 
  So, in other words zero is the total result in TEST.TOTAL but this does not 
  equate to zero.
 
 
 
  Now I know I can get round this by rounding the answer but am not sure why 
  I should have to.  Any ideas?
 
 
 
  Thanks
 
 
 
  Brett
 
 
 
  Martin 
  Phillipsmartinphill...@ladybridge.commailto:martinphill...@ladybridge.com
wrote in message 
  news:2636297EDC484501AD1A5AC277EE76A7@lbs8news:%3c2636297EDC484501AD1A5AC277EE76A7@lbs8...
 
  Hi George,
  As a general rule in programming, comparison of floating point values
  for equality should be avoided. This is because, just as we cannot
  write the number one third accurately in decimal notation, so the IEEE
  floating point format used by computer systems cannot store numbers
  accurately. The example that I use when teaching training courses is
  14.2 which actually ends up as something close to 14.197.
  UniVerse gets around this with a wonderful concept called wide zero
  that says, when testing for equality of floating point numbers, they
  must be within some specified value of being equal rather than
  strictly equal. The default wide zero error tolerance, set in IEEE
  format with the WIDEZERO configuration parameter, is 2.91 * 10^-11 (2^
  035) which is good for most business applications but occasionally needs 
  adjusting.
  Unidata has a command, SET.WIDEZERO, to serve the same purpose but
  defaults to 0.0 for backward comaptibility.
  Martin Phillips
  Ladybridge Systems Ltd
  17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
  +44 (0)1604-709200
  - Original Message -
  From: George Hammerlezhamme...@hubert.commailto:zhamme...@hubert.com
  To:u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org
  Sent: Thursday, September 29, 2011 1:30 PM
  Subject: [U2] The math just doesn't work.
  Can anybody please help?
  For some reason A + B does not equal C in the comparison below. Is
  there any trick to get the comparisons to work properly?
  Unidata 7.2 on Hp Unix 11+
  Top of TEST.COMP in RMH.MAIN, 13 lines, 263 characters.
  *--: P
  001: A = 3176.79
  002: B = 106.19
  003: C = 3282.98
  004: D = 920.11
  005: A = A + D
  006: C = C + D
  007: IF (A+B) # C THEN
  008:   CRT '(A+B) # C? YOU LIE'
  009:   CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C
  010: END ELSE
  011:   CRT '(A+B) = C? YOU ROCK'
  012:   CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C
  013: END
  Bottom.
  *--: FIBR
  Filed TEST.COMP in file RMH.MAIN unchanged.
  Compiling Unibasic: /db1/ud1/PGM/RMH.MAIN/TEST.COMP in mode 'u'.
  compilation finished
  (A+B) # C? YOU LIE
  A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09
  George Hammerle
  Programming Dude
  Hubert Company LLC.
  9555 Dry Fork Road
  Harrison, Ohio 45030
  513-367-8974
  
  zhammerle@hubertREMOVE_THIS.commailto:zhammerle@hubertREMOVE_THIS.com
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org
  

Re: [U2] The math just doesn't work.

2011-10-10 Thread Brett Callacher
I also thought: great explanation and nodded sagely when I read this.  
However, consider this code:



  NUL = ''

  CM = ','

  A = -409071.8775: CM: 475000: CM: -652413: CM: 652413: CM: -475000: CM: 
409071.8775

*

*

  TEST.VMC = 1

  TEST.TOTAL = 0

*

  LOOP UNTIL FIELD(A, CM, TEST.VMC) = NUL DO

 TEST.TOTAL += FIELD(A, CM, TEST.VMC)

 TEST.VMC += 1

  REPEAT

*

  IF TEST.TOTAL = 0 THEN

 PRINT 'OK'

  END ELSE

 PRINT TEST.TOTAL, (TEST.TOTAL = 0), TEST.TOTAL - 0, (OCONV(TEST.TOTAL, 
'MD0') = 0)

  END





Running this on our Universe system 11.1.1 produces:



0 0 0 1



So, in other words zero is the total result in TEST.TOTAL but this does not 
equate to zero.



Now I know I can get round this by rounding the answer but am not sure why I 
should have to.  Any ideas?



Thanks



Brett



Martin Phillips 
martinphill...@ladybridge.commailto:martinphill...@ladybridge.com wrote in 
message 
news:2636297EDC484501AD1A5AC277EE76A7@lbs8news:%3c2636297EDC484501AD1A5AC277EE76A7@lbs8...

 Hi George,



 As a general rule in programming, comparison of floating point values

 for equality should be avoided. This is because, just as we cannot

 write the number one third accurately in decimal notation, so the IEEE

 floating point format used by computer systems cannot store numbers

 accurately. The example that I use when teaching training courses is

 14.2 which actually ends up as something close to 14.197.



 UniVerse gets around this with a wonderful concept called wide zero

 that says, when testing for equality of floating point numbers, they

 must be within some specified value of being equal rather than

 strictly equal. The default wide zero error tolerance, set in IEEE

 format with the WIDEZERO configuration parameter, is 2.91 * 10^-11 (2^

 035) which is good for most business applications but occasionally needs 
 adjusting.



 Unidata has a command, SET.WIDEZERO, to serve the same purpose but

 defaults to 0.0 for backward comaptibility.





 Martin Phillips

 Ladybridge Systems Ltd

 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England

 +44 (0)1604-709200





 - Original Message -

 From: George Hammerle zhamme...@hubert.commailto:zhamme...@hubert.com

 To: u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org

 Sent: Thursday, September 29, 2011 1:30 PM

 Subject: [U2] The math just doesn't work.





  Can anybody please help?

 

  For some reason A + B does not equal C in the comparison below. Is

  there any trick to get the comparisons to work properly?

 

  Unidata 7.2 on Hp Unix 11+

 

 

  Top of TEST.COMP in RMH.MAIN, 13 lines, 263 characters.

  *--: P

  001: A = 3176.79

  002: B = 106.19

  003: C = 3282.98

  004: D = 920.11

  005: A = A + D

  006: C = C + D

  007: IF (A+B) # C THEN

  008:   CRT '(A+B) # C? YOU LIE'

  009:   CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C

  010: END ELSE

  011:   CRT '(A+B) = C? YOU ROCK'

  012:   CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C

  013: END

  Bottom.

  *--: FIBR

  Filed TEST.COMP in file RMH.MAIN unchanged.

 

  Compiling Unibasic: /db1/ud1/PGM/RMH.MAIN/TEST.COMP in mode 'u'.

  compilation finished

 

  (A+B) # C? YOU LIE

  A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09

 

 

 

 

 George Hammerle

 Programming Dude

 Hubert Company LLC.

 9555 Dry Fork Road

 Harrison, Ohio 45030

 513-367-8974

 
  zhammerle@hubertREMOVE_THIS.commailto:zhammerle@hubertREMOVE_THIS.com



 ___

 U2-Users mailing list

 U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

 http://listserver.u2ug.org/mailman/listinfo/u2-users



This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] The math just doesn't work.

2011-10-10 Thread Brett Callacher
Hi Martin,

Ok, have re-run with PRECISION 14.  I now get:

0.0058210 0.0058211

So, the difference is 5.8 * 10^-11 which I can see is greater than the standard 
Wide Zero setting.

The realisation for me here is that PRECISION has nothing to do with the 
precision of the calculation, it only effects display.

Thanks for the insight.

Brett

Martin Phillips martinphill...@ladybridge.com wrote in message 
news:373068736ABE411796AEF7AD7F0A6B1D@lbs8...
 Hi Brett,
 
 I think my discussion on this topic still holds. Run your program with
PRECISION 14
 at the top and you can see the rounding errors creeping in. This is exactly 
 why comparing floating point values is generally considered a bad idea.
 
 
 Martin Phillips
 Ladybridge Systems Ltd
 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
 +44 (0)1604-709200
 
 - Original Message - 
 From: Brett Callacher bre...@gpmdev.co.uk
 To: u2-users@listserver.u2ug.org
 Sent: Monday, October 10, 2011 9:16 AM
 Subject: Re: [U2] The math just doesn't work.
 
 
 I also thought: great explanation and nodded sagely when I read this. 
 However, consider this code:
 
 
 
   NUL = ''
 
   CM = ','
 
   A = -409071.8775: CM: 475000: CM: -652413: CM: 652413: CM: -475000: 
  CM: 409071.8775
 
  *
 
  *
 
   TEST.VMC = 1
 
   TEST.TOTAL = 0
 
  *
 
   LOOP UNTIL FIELD(A, CM, TEST.VMC) = NUL DO
 
  TEST.TOTAL += FIELD(A, CM, TEST.VMC)
 
  TEST.VMC += 1
 
   REPEAT
 
  *
 
   IF TEST.TOTAL = 0 THEN
 
  PRINT 'OK'
 
   END ELSE
 
  PRINT TEST.TOTAL, (TEST.TOTAL = 0), TEST.TOTAL - 0, 
  (OCONV(TEST.TOTAL, 'MD0') = 0)
 
   END
 
 
 
 
 
  Running this on our Universe system 11.1.1 produces:
 
 
 
  0 0 0 1
 
 
 
  So, in other words zero is the total result in TEST.TOTAL but this does 
  not equate to zero.
 
 
 
  Now I know I can get round this by rounding the answer but am not sure why 
  I should have to.  Any ideas?
 
 
 
  Thanks
 
 
 
  Brett
 
 
 
  Martin Phillips 
  martinphill...@ladybridge.commailto:martinphill...@ladybridge.com 
  wrote in message 
  news:2636297EDC484501AD1A5AC277EE76A7@lbs8news:%3c2636297EDC484501AD1A5AC277EE76A7@lbs8...
 
  Hi George,
 
 
 
  As a general rule in programming, comparison of floating point values
 
  for equality should be avoided. This is because, just as we cannot
 
  write the number one third accurately in decimal notation, so the IEEE
 
  floating point format used by computer systems cannot store numbers
 
  accurately. The example that I use when teaching training courses is
 
  14.2 which actually ends up as something close to 14.197.
 
 
 
  UniVerse gets around this with a wonderful concept called wide zero
 
  that says, when testing for equality of floating point numbers, they
 
  must be within some specified value of being equal rather than
 
  strictly equal. The default wide zero error tolerance, set in IEEE
 
  format with the WIDEZERO configuration parameter, is 2.91 * 10^-11 (2^
 
  035) which is good for most business applications but occasionally needs 
  adjusting.
 
 
 
  Unidata has a command, SET.WIDEZERO, to serve the same purpose but
 
  defaults to 0.0 for backward comaptibility.
 
 
 
 
 
  Martin Phillips
 
  Ladybridge Systems Ltd
 
  17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
 
  +44 (0)1604-709200
 
 
 
 
 
  - Original Message -
 
  From: George Hammerle 
  zhamme...@hubert.commailto:zhamme...@hubert.com
 
  To: u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org
 
  Sent: Thursday, September 29, 2011 1:30 PM
 
  Subject: [U2] The math just doesn't work.
 
 
 
 
 
   Can anybody please help?
 
  
 
   For some reason A + B does not equal C in the comparison below. Is
 
   there any trick to get the comparisons to work properly?
 
  
 
   Unidata 7.2 on Hp Unix 11+
 
  
 
  
 
   Top of TEST.COMP in RMH.MAIN, 13 lines, 263 characters.
 
   *--: P
 
   001: A = 3176.79
 
   002: B = 106.19
 
   003: C = 3282.98
 
   004: D = 920.11
 
   005: A = A + D
 
   006: C = C + D
 
   007: IF (A+B) # C THEN
 
   008:   CRT '(A+B) # C? YOU LIE'
 
   009:   CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C
 
   010: END ELSE
 
   011:   CRT '(A+B) = C? YOU ROCK'
 
   012:   CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C
 
   013: END
 
   Bottom.
 
   *--: FIBR
 
   Filed TEST.COMP in file RMH.MAIN unchanged.
 
  
 
   Compiling Unibasic: /db1/ud1/PGM/RMH.MAIN/TEST.COMP in mode 'u'.
 
   compilation finished
 
  
 
   (A+B) # C? YOU LIE
 
   A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09
 
  
 
  
 
  
 
  
 
  George Hammerle
 
  Programming Dude
 
  Hubert Company LLC.
 
  9555 Dry Fork Road
 
  Harrison, Ohio 45030
 
  513-367-8974
 
   
   zhammerle@hubertREMOVE_THIS.commailto:zhammerle@hubertREMOVE_THIS.com

Re: [U2] Pondering recent thread on compact framework

2011-05-20 Thread Brett Callacher
We have started using an App called Citrix Receiver:
http://www.citrix.com/English/ps2/products/product.asp?contentID=1689163

Have just started evaluating it.  It seems to work well.

Brett

David Jordan da...@dacono.com.au wrote in message 
news:6F91EB9F76538448AB0D1D84E19424D1199316A04D@DACONOSBSERVER2.daconosbs.local...
 Hi George

 I use a Windows phone 7.  With a web page there is a cost of time for 
 downloading a web page and a performance issue with screen loading.  With an 
 app, I conform to the user interface of the phone which are more intuitive to 
 a phone user.  The app loads quicker and runs quicker.   However if you have 
 users using android, blackberry, iphone, etc then you need to create a 
 separate app for each phone.   With the new phones you need to load the app 
 from the marketplace which is difficult for an enterprise application.   
 Hence the decision to use an app vs web is related to performance and 
 intuitive interface vs portable and easier to load.

 Remember also that most phones have no virus protection and are a potential 
 risk area for Trojans and viruses for web interfaces.  An app is a bit more 
 secure.

 Again there are other features I can use on the phone such as sending a 
 spreadsheet of KPIs to the phone rather than having an application to access 
 KPIs.  There are just too many ways to skin a cat.

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

This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] Why should we NOT upgrade to UV11.1.1 ?

2011-05-19 Thread Brett Callacher
Chuck,

I think that 11.1.1 is a Windows release so this may, or may not be relevant.

LIST.READU does not report a pid in 11.1.1.  This is a known issue and is 
fixed in 11.1.3 I am told.

How you go about finding any known issues, I have yet to establish.

HTH

Brett

Charles Stevenson stevenson.c...@gmail.com wrote in message 
news:4dd479ef.9030...@gmail.com...
 UV11.1 has been available for AIX for 7 month; for Linux only 3..
 I don't know how widely used it is yet.
 I have not seen a rash of complaints about 11.1.

 We are currently on 10.2.10 / Windows and contemplating migrating to Linux.
 UV choices are:  10.3.9   11.1.1.

 We do not have a burning need for any new 11.1 functionality.  The main
 motivation would be to be able to put off future upgrades longer by
 making this jump bigger.

 Linux choices are RedHat or SuSE.  Your thoughts?

 Any warnings or endorsements re. UV version /or Linux choices would be
 much appreciated.

 Chuck Stevenson
 Tolt Service Group

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

This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam

2011-03-22 Thread Brett Callacher
Actually Robert, I think English does have this word.  You just used it - the 
rather unfashionable 'one'.

Brett


Robert Houben robert.hou...@fwic.net wrote in message 
news:9c300472e764f645b1bab4571ac8d12601d461579...@bc-comm.fusionware.net...
 Good point, Bill,

 I think one sometimes uses you when one means someone other than 
 themselves, without intending to pin the reader with the crime being 
 mentioned.  The English language does not differentiate plural, general you 
 from singular, specific you (unless you're from the deep south, in which 
 case you have the unique y'all, which oddly enough I've always heard used 
 as the singular, specific form.)

 For instance, I might have written:
 I think you sometimes use you when you mean someone other than yourself...

 :)

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
 Sent: Friday, March 18, 2011 5:14 PM
 To: U2 Users List
 Subject: Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam

 I learned about the I-Beam of Interpersonal Communications at a 
 ToastMasters meeting.

 The idea is to stop using the word you altogether.  Easier said than done.

 The beauty of the I-Beam is that it removes blaming others.

 Thus...

 I wish that Rocket would see that 123 and then did ABC along the 
 lines of XYZ...

 I am in favor of...

 I am not in favor of...   are decent I-Beam constructs.

 On the other hand...

 YOU are a dirty rotten bungling oaf and it is all YOUR fault.  This 
 of course not I-Beam.  It uses the inflamatory blame word (YOU).  The word 
 YOU is toxic.

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


This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] Val on UniDynArray produces unexpected results

2010-11-15 Thread Brett Callacher
Scary indeed, we had to go through this frightful exercise.  I think it is not 
a Val that you need to search on, rather it is the multiple extracts.  If you 
are using the Visual Studio IDE then you can use pattern match searching to 
find a lot of these.



The issue was recognised by IBM quite some years ago.  IIRC, it was put down to 
a problem with Microsoft, presumably in the VB runtime.  It is documented 
somewhere.



Regards



Brett



Adrian Halid adrian.ha...@itvision.com.au wrote in message 
news:13e4ae055d203648a4121114f2458c8c9f16a05...@tefnut.perth.itvision.com.au...

Hi,



Yeah we believe the issue is referencing the same UO dynamic array on the same 
line.



We have also sent this off to Rocket and are waiting their response.



We have fixed the issue as you said by assigning the Val function to a variable 
first.



It's just a little scary to think of the millions of lines of code in our 
application and what other conditional statement may not be calculating 
correctly.



This means we are having to do a search and replace to find all instances where 
we are doing a Val in a conditional statement.



Regards



Adrian Halid

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 7000  F:  (08) 9315 7088

E:  adrian.ha...@itvision.com.auW: http://www.itvision.com.au



___



NOTICE : This e-mail and any attachments are intended for the addressee(s) only 
and may

contain confidential or privileged material. Any unauthorised review, use, 
alteration,

disclosure or distribution of this e-mail (including any attachments) by an 
unintended recipient

is prohibited. If you are not the intended recipient please contact the sender 
as soon as

possible by return e-mail and then delete both messages.

___





-Original Message-

From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brett Callacher

Sent: Friday, 12 November 2010 6:16 PM

To: u2-users@listserver.u2ug.org

Subject: Re: [U2] Val on UniDynArray produces unexpected results



I think you will find that the problem here is two expressions, on the same 
line, that reference the same UO dynamic array.  Assign your Val functions to 
variables first and then use these variables in your case statement.







HTH







Brett







Adrian Halid adrian.ha...@itvision.com.au wrote in message 
news:13e4ae055d203648a4121114f2458c8c9f16a05...@tefnut.perth.itvision.com.au...



 Hi All,







 We have come across a very strange bug between UniDynArray and VB6.







 In our applications we were getting two different results on an if statement 
 between the IDE and the compiled (into Native) exe.







 In the IDE case the statement was returning True which is correct.



 In the compiled native exe the exact same statement was returning false which 
 is wrong as the statement should evaluate to true.



 If we compiled the exe into p-code then the statement evaluates to True as it 
 should.







 The conditional statement seems to have to be in this exact structure (kind 
 of like a perfect storm of conditions).







 ((var1.Field(1).StringValue  ) Or (False And 
 Val(var1.Field(2).StringValue)  0))







 It must compare the same UniDynArray in each part of the if statement and 
 perform a Val on the second UniDynArray.







 The issue can be demonstrated by the sample code below.



 We have two Booleans (b1 and b2) that should always evaluate to true.



 In the VB6 IDE b1 is true and b2 is true as expected.



 In the Compile Native exe b1 actually evaluates to false. (This is wrong b1 
 and b2 should always be True).







 ---



 Dim var1 As UniDynArray



 Dim b1 As Boolean



 Dim b2 As Boolean







 Set var1 = New UniDynArray







 var1.Field(1).StringValue = 1



 var1.Field(2).StringValue = 







 ' b1 and b2 should always be True



 ' When compiled into Native Code b1 is false and b2 is true. Why?







 b1 = ((var1.Field(1).StringValue  ) Or (False And 
 Val(var1.Field(2).StringValue)  0))







 b2 = ((False And Val(var1.Field(2).StringValue)  0) Or 
 (var1.Field(1).StringValue  ))







 MsgBox b1=  b1   and b2=  b2







 ---







 I know we can fix the problem quickly by swapping round the conditional 
 blocks or create new variables to hold the string values and then compare 
 them.







 My concern is that in our very large application what conditional statements 
 could be failing in the executable we send out

Re: [U2] Val on UniDynArray produces unexpected results

2010-11-12 Thread Brett Callacher


Adrian Halid adrian.ha...@itvision.com.au wrote in message 
news:13e4ae055d203648a4121114f2458c8c9f16a05...@tefnut.perth.itvision.com.au...
 Hi All,

 We have come across a very strange bug between UniDynArray and VB6.

 In our applications we were getting two different results on an if statement 
 between the IDE and the compiled (into Native) exe.

 In the IDE case the statement was returning True which is correct.
 In the compiled native exe the exact same statement was returning false which 
 is wrong as the statement should evaluate to true.
 If we compiled the exe into p-code then the statement evaluates to True as it 
 should.

 The conditional statement seems to have to be in this exact structure (kind 
 of like a perfect storm of conditions).

 ((var1.Field(1).StringValue  ) Or (False And 
 Val(var1.Field(2).StringValue)  0))

 It must compare the same UniDynArray in each part of the if statement and 
 perform a Val on the second UniDynArray.

 The issue can be demonstrated by the sample code below.
 We have two Booleans (b1 and b2) that should always evaluate to true.
 In the VB6 IDE b1 is true and b2 is true as expected.
 In the Compile Native exe b1 actually evaluates to false. (This is wrong b1 
 and b2 should always be True).

 ---
 Dim var1 As UniDynArray
 Dim b1 As Boolean
 Dim b2 As Boolean

 Set var1 = New UniDynArray

 var1.Field(1).StringValue = 1
 var1.Field(2).StringValue = 

 ' b1 and b2 should always be True
 ' When compiled into Native Code b1 is false and b2 is true. Why?

 b1 = ((var1.Field(1).StringValue  ) Or (False And 
 Val(var1.Field(2).StringValue)  0))

 b2 = ((False And Val(var1.Field(2).StringValue)  0) Or 
 (var1.Field(1).StringValue  ))

 MsgBox b1=  b1   and b2=  b2

 ---

 I know we can fix the problem quickly by swapping round the conditional 
 blocks or create new variables to hold the string values and then compare 
 them.

 My concern is that in our very large application what conditional statements 
 could be failing in the executable we send out.



 Regards

 Adrian Halid
 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 7000  F:  (08) 9315 7088
 E:  adrian.ha...@itvision.com.aumailto:adrian.ha...@itvision.com.au
 W: http://www.itvision.com.auhttp://www.itvision.com.au/



 ___

 NOTICE : This e-mail and any attachments are intended for the addressee(s) 
 only and may
 contain confidential or privileged material. Any unauthorised review, use, 
 alteration,
 disclosure or distribution of this e-mail (including any attachments) by an 
 unintended recipient
 is prohibited. If you are not the intended recipient please contact the 
 sender as soon as
 possible by return e-mail and then delete both messages.
 ___


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

This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] Val on UniDynArray produces unexpected results

2010-11-12 Thread Brett Callacher
Testing a string   is a valid way to test for a non-null variable IMO.  If 
you think about it a string can never be  .  Am not aware of a language, 
p-code or otherwise, where that is not the case.



Brett



Brian Leach br...@brianleach.co.uk wrote in message 
news:004b01cb8248$26598bd0$730ca3...@co.uk...

 var1.Field(1).StringValue  



 Do you mean that? Or do you mean var1.Field(1).StringValue   ?



 Differences between the P-Code and fully compiled code have been a 'feature'

 of VB for a long time - the compiled code is generally more accurate/less

 forgiving and - whilst not relevant here - if you have any sort of

 multithreading in your code, that can operate differently.



 If you are concerned, can you send out the P-Code executable? On today's

 processors, the performance difference is unlikely to hurt.



 Brian



 -Original Message-

 From: u2-users-boun...@listserver.u2ug.org

 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Halid

 Sent: 12 November 2010 02:18

 To: u2-users@listserver.u2ug.org

 Subject: [U2] Val on UniDynArray produces unexpected results



 Hi All,



 We have come across a very strange bug between UniDynArray and VB6.



 In our applications we were getting two different results on an if statement

 between the IDE and the compiled (into Native) exe.



 In the IDE case the statement was returning True which is correct.

 In the compiled native exe the exact same statement was returning false

 which is wrong as the statement should evaluate to true.

 If we compiled the exe into p-code then the statement evaluates to True as

 it should.



 The conditional statement seems to have to be in this exact structure (kind

 of like a perfect storm of conditions).



 ((var1.Field(1).StringValue  ) Or (False And

 Val(var1.Field(2).StringValue)  0))



 It must compare the same UniDynArray in each part of the if statement and

 perform a Val on the second UniDynArray.



 The issue can be demonstrated by the sample code below.

 We have two Booleans (b1 and b2) that should always evaluate to true.

 In the VB6 IDE b1 is true and b2 is true as expected.

 In the Compile Native exe b1 actually evaluates to false. (This is wrong b1

 and b2 should always be True).



 

 ---

 Dim var1 As UniDynArray

 Dim b1 As Boolean

 Dim b2 As Boolean



 Set var1 = New UniDynArray



 var1.Field(1).StringValue = 1

 var1.Field(2).StringValue = 



 ' b1 and b2 should always be True

 ' When compiled into Native Code b1 is false and b2 is true. Why?



 b1 = ((var1.Field(1).StringValue  ) Or (False And

 Val(var1.Field(2).StringValue)  0))



 b2 = ((False And Val(var1.Field(2).StringValue)  0) Or

 (var1.Field(1).StringValue  ))



 MsgBox b1=  b1   and b2=  b2



 

 ---



 I know we can fix the problem quickly by swapping round the conditional

 blocks or create new variables to hold the string values and then compare

 them.



 My concern is that in our very large application what conditional statements

 could be failing in the executable we send out.







 Regards



 Adrian Halid

 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 7000  F:  (08) 9315 7088

 E:  adrian.ha...@itvision.com.aumailto:adrian.ha...@itvision.com.au

 W: http://www.itvision.com.auhttp://www.itvision.com.au/







 ___



 NOTICE : This e-mail and any attachments are intended for the addressee(s)

 only and may

 contain confidential or privileged material. Any unauthorised review, use,

 alteration,

 disclosure or distribution of this e-mail (including any attachments) by an

 unintended recipient

 is prohibited. If you are not the intended recipient please contact the

 sender as soon as

 possible by return e-mail and then delete both messages.

 ___





 ___

 U2-Users mailing list

 U2-Users@listserver.u2ug.org

 http://listserver.u2ug.org/mailman/listinfo/u2-users





 ___

 U2-Users mailing list

 U2-Users@listserver.u2ug.org

 http://listserver.u2ug.org/mailman/listinfo/u2-users





This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please 

Re: [U2] save quot; break-onquot; query result as data file records

2010-07-19 Thread Brett Callacher
If you supply REFORMAT with its first field that is your group field, then it 
will generate multi values for you in records keyed on the group.  If you are 
after break sub-totals these can then be achieved using a correlative or I 
descriptor on the destination file.

HTH

Brett

Danila danila.bezme...@gmail.com wrote in message 
news:loom.20100716t222842-...@post.gmane.org...

 Boydell, Stuart Stuart.Boydell at spotless.com.au writes:

 
  If you're familiar with SQL you can use SQL.
 
  INSERT INTO NEWFILE
  SELECT COL1,COL2,SUM(COL3) FROM OLDFILE GROUP BY COL1,COL2;
  Etc
 
  See the SQL User Guide for UV specific extensions and syntax
 
  Otherwise, if you want to use Revise, you can use the REFORMAT verb.
 
  HTH,
  Stuart

 Thanks Stuart,
 I think I have no choice as to use BASIC,
 because Insert SQL statement does not allow field modifiers
  in a subquery, and REFORMAT syntax does not
 allow break-on values, but original records instead.




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

This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] Universe: AE just ... disappears?

2010-07-14 Thread Brett Callacher
Which version of Windows is this?  We have had a number of strange problems 
with Windows 2008 R2 - these all resolved to use of UAC which is turned on by 
default.

Kevin King precisonl...@gmail.com wrote in message 
news:aanlktiklo_vayllx_pahiuxw9ot3gtlkezhnp4hsk...@mail.gmail.com...
 We have had a number of problems with AE on UV/Windows; every now and again
 - and sometimes repeatedly in the same couple of seconds - some catalog
 pointer just disappears and AE stops working.  We've experienced problems
 with other UV sites and having catalog pointers just disappear but this is
 the first time it's happened with AE and never this often.

 The ADDAE program (thanks Susan [Joslyn]!) fixes the issue but... What is up
 with UV and catalog pointers disappearing?

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

This message contains information that may be privileged or confidential and is 
the property of GPM Development Ltd. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient ,you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

This e-mail was sent to you by GPM Development Ltd.  We are incorporated under 
the laws of England and Wales (company no. 2292156 and VAT registration no. 523 
5622 63).  Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 
2LX.
 

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


Re: [U2] What Program Am I?

2009-06-25 Thread Brett Callacher
Agreed about use of SYSTEM(9001), however as it is not clear on the platform 
there is one caveat if you are using UniObjects.  You may need to ensure that 
you are using at least UV 10.2.4 as some previous versions did a hang on 
consecutive calls to this function (Issue 8283).  Am not sure when this bug was 
introduced so you may be ok.

phil walker p...@gnosys.co.nz wrote in message 
news:6806801183013245804b6a7c6b34750715a...@hera.gnosys.local...
 Depending on the version of UV you are on you should be able to access
 SYSTEM(9001) from memory. This is an array which contains the call
 stack.

  -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:46 a.m.
  To: u2-users@listserver.u2ug.org
  Subject: [U2] What Program Am I?
 
  We've got a UV client/server application with a thick VB client.  The
  vintage is around 1997, and the architecture has a debug mode that I
  leave
SNIP
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Error 30102

2009-06-15 Thread Brett Callacher
This is Internal datum error.  Sorry, probably not very helpful.  This 
question has been asked before though:
http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg22299.html


Martin Scholl msch...@martinscholl.com wrote in message 
news:200906142202.n5em2nzf007...@mail168c2.megamailservers.com...
 I forgot to mentions that this error comes form UniData.





 Martin Scholl

 18910 New Hampshire Ave

 Brinklow, MD 20862

 Phone: 301-924-5537

 Cell: 301-613-9572

 msch...@martinscholl.com

   _

 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl
 Sent: Sunday, June 14, 2009 5:40 PM
 To: 'U2 Users List'
 Subject: [U2] Error 30102



 I program in Visual Basic 6 and use UniObjects to access U2.

 I tried to move a client's application to the replication server this
 weekend. Everything seemed to work fine until I got a call from the client
 that there was a strange error message.

 After investigating in debug mode, I found that a subroutine call returned
 error 30102. This error is not documented in uoaif.txt.

 I recompiled and recatalogued the subroutine to no avail. Other subroutine
 calls work fine. I am at my wit's end here.



 Martin Scholl

 www.HIPAAsuite.com

 18910 New Hampshire Ave

 Brinklow, MD 20862

 Phone: 301-924-5537

 Cell: 301-613-9572

 msch...@martinscholl.com



 No virus found in this incoming message.
 Checked by AVG - www.avg.com
 Version: 8.5.339 / Virus Database: 270.12.68/2175 - Release Date: 06/14/09
 05:53:00



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


Re: [U2] Question on UniVerse VOC record for CREATE.FILE

2009-04-24 Thread Brett Callacher
It is probably the options in attribute 4 that drive this.

Anyway, to set long name support on an account type, try this from the UV 
account:
LONGNAMES ON NEWACC,PICK

You can then see what the verb should look like.  You may want to take a backup 
copy of your original first though.

HTH

Brett

Doug Farmer dfar...@epicor.com wrote in message 
news:dbd320e216b98b4d842bb357e46c0788cd7...@basalt.americas.epicor.net...
 I am mainly a UniData person, so UniVerse is a bit foreign to me.

 I am running UniVerse on a Windows Platform.

 Using the CREATE.FILE command, I created a file with a long name (15
 characters) with my standard VOC pointer, and the VOC pointer in the
 UV\NEWAC,PICK file.

 Using the CREATE.FILE verb in my VOC, I am able to create the file
 correctly.  Using the verb as it is on the NEWAC,PICK file, it truncates
 the file name.  This, even though the LONGNAMES is on.  See the examples
 at the end of the E mail.

 My VOC entry looks like

 AE VOC CREATE.FILE
 Top of CREATE.FILE in VOC, 6 lines, 40 characters.
 *--: L22
 001: V
 002: create.file
 003: E
 004: VF
 005: LONGNAMES
 006: PICK.FORMAT
 Bottom.
 *--:

 The NEWACC\PICK file verb looks like this (After I copy it to my VOC and
 set LONGNAMES)
 AE VOC PICK-CREATE-FILE
 Top of CREATE.FILE in VOC, 6 lines, 40 characters.
 *--: L22
 001: V
 002: create.file
 003: E
 004: FG
 005: LONGNAMES
 006: PICK.FORMAT
 Bottom.
 *--:

 The only difference is attribute 4 which has an FG instead of VF in it.
 I have no idea what FG vs VF is.

 You may wonder why I am asking?  I have an old application that creates
 files specifically using the PICK version, no matter what the VOC
 version is.

 I don't know why, is there a difference?

 The only difference I know of is that LONGNAMES do not seem to work
 under the PICK version.

 Any ideas?

 Thanks in Advance

 Doug


 Using PICK-CREATE-FILE

 PICK-CREATE-FILE DAF1234567890123456 1,1,18 1,1,19
 WARNING: An operating system file will be created with a truncated name.
 Creating file DAF123456000 as Type 19.
 Creating file D_DAF123456000 as Type 18, Modulo 1, Separation 1.

 Using CREATE-FILE
 CREATE.FILE DAF123456789012345 1,1,18 1,1,19
 Creating file DAF123456789012345 as Type 19.
 Creating file D_DAF123456789012345 as Type 18, Modulo 1, Separation 1.
 Added @ID, the default record for RetrieVe, to D_DAF123456789012345.
 

 This e-mail is for the use of the intended recipient(s) only. If you have 
 received this e-mail in error, please notify the sender immediately and then 
 delete it. If you are not the intended recipient, you must not use, disclose 
 or distribute this e-mail without the author's prior permission. We have 
 taken precautions to minimize the risk of transmitting software viruses, but 
 we advise you to carry out your own virus checks on any attachment to this 
 message. We cannot accept liability for any loss or damage caused by software 
 viruses. Any views and/or opinions expressed in this e-mail are of the author 
 only and do not represent the views of Epicor Software Corporation or any 
 other company within its group.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] SQL a possibility?

2009-04-03 Thread Brett Callacher
For the SAVING syntax to work, you need to use a Pick-like flavour version of 
SELECT.  Something like this:

ASELECT
0001 V
0002 SELECT
0003 Q
0004 GHKSXA

Note the A processor mode in attribute 4.

HTH

Brett


George Gallen ggal...@wyanokegroup.com wrote in message 
news:6d57ef06d84b5541af530227504bb68f58c8daf...@34093-mbx-c06.mex07a.mlsrvr.com...
  -Original Message-
  From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
  us...@listserver.u2ug.org] On Behalf Of Brian Leach
  Sent: Thursday, April 02, 2009 4:21 AM
  To: u2-users@listserver.u2ug.org
  Subject: RE: [U2] SQL a possibility?
 
  George
 
  NowHow can I put that data into a saved-list? (Using either TCL or
  SQL?)
  for that matter, how do you save a list using SQL on Universe? I tried
  creating a view, but was told I
  had to create a schema in order to create tables...that's no
  fun...
 
  SQL -
  SELECT SWITCHIT TO SLIST 0 FROM FILENAME WHERE @ID = 'somename';

 This gave me an error, about not being able to use a multivalued field..

 
  RetrieVe -
 
  SELECT FILENAME somename SAVING SWITCHIT

 This did not work, instead of giving me a listing of just the ID, it
 saved the original line without parsing.

 
  Both create active select lists you can then SAVE.LIST.
 
  Brian
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] DEBUG mode on a UniObjects connections

2008-12-04 Thread Brett Callacher
Agreed with COMO comment.  Depending on your version of Universe you may also 
be able to:

1. TANDEM to the UniObjects port.  This should enable you to interact with the 
debugger.
2. See any errors produced by looking at the runtime error log (create a file 
called errlog in the uvhome)

In general it is better to prevent any routines called via UniObjects from 
accepting any input.  It is preferable to try and return an error condition to 
the caller.

HTH

Brett

Allen Bell [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]...
 When I have a problem like this I usually put a COMO ON statement near
 the top of the program and the look at the output stored in the COMO
 file. If you have a bad line of code that causes the abort or debug you
 can see what you would normally see on the screen if you were using an
 interactive connection

 EXECUTE 'COMO ON {substitute some random name here}'


 Regards,


 Allen

 Symeon Breen wrote:
  Databasic will only go into debug mode if you tell it to - this is done
  either at the command line or with a debug statement in the code. Since you
  are calling the sub from uniobjects it will not be a command line issue so i
  suspect you have a debug statement in the code. You need to find it and get
  rid of it, it should not be in live code, and will certainly not work at all
  with a uniobjects call.
 
 
 
  Rgds
  Symeon
 
 
 
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED] On Behalf Of Dave Reynolds
  Sent: 04 December 2008 10:10
  To: u2-users@listserver.u2ug.org
  Subject: [U2] DEBUG mode on a UniObjects connections
 
  Hi all,
 
  I'm new to the list, and hope that someone may have the answer to a
  problem which is causing me a lot of headaches at the moment.
 
  I'm using VB6 and UniObjects to connect to a Universe Database.
 
  I call DataBasic routines from the VB6 client.
 
  All works fine, until there is a problem in the databasic code, which
  sends it into DEBUG.
 
  The client screen locks up, and my talking screenreader goes into sulk
  mode, which normally means I have to reboot.
 
  I wouldn't expect anyone on the list to solve the screenreader problem,
  but sighted colleagues have reported similar experiences with this type
  of connection.
 
  Is this a bug in UniObjects, or did I set it up wrongly.
 
  Many thanks for any ideas,
 
 
 
 
 
 
 
  Dave
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
  No virus found in this incoming message.
  Checked by AVG - http://www.avg.com
  Version: 8.0.176 / Virus Database: 270.9.12/1821 - Release Date: 03/12/2008
  17:41
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] CAPTURING TOXML

2008-07-25 Thread Brett Callacher
Hi Charles,

Can't comment on Unidata but have done this in Universe and had to jump through 
some hoops which may assist:

1. Try setting your terminal type to Dumb so that you don't get escape 
sequences.
2. Watch out for form feeds and the like that get added anyway (post 10.1.18)

HTH

Brett

[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]...
 Hello.  I've been building and returning some simple pages from Unidata to
 PHP, but I now have a big complex report to adapt.  Is there someway that
 I can take advantage of the TOXML verb by CAPTURING the XML and returning
 it to the calling PHP?

 I tried something like this.

 ECMD = SELECT   TOXML
 EXECUTE ECMD CAPTURING RESULT  (where RESULT is returned to the calling
 PHP program.but got the error message:
 protocol error: , Invalid document end at col 32. Check the back end log
 for details.

 I suspect this is due to the marks separating the dynamic array elements.
 Will something like this work, or am I barking up the wrong tree?

 And where is the backend log?

 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Unidata 7.1 ODBC Threading Problems?

2008-06-04 Thread Brett Callacher
Hi Kevin,

The issue we have had is to with Universe and ODBC and more particularly to do 
with ODBC reads preventing Universe-side writes.  However, you don't seem to be 
getting much response with your issue specifically so maybe this could help.

Make sure that your ODBC DSN entry on the client refers to the account and file 
via its U2 name, i.e. from the perspective of the U2 server.  The problem we 
identified was caused by a reference to a file via its UNC path in the DSN 
settings.  This in turn created an Exclusive Lock on the entire file on the 
server (Windows in this case).

HTH

Brett

Kevin King [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]...
 Is the Unidata 7.1 ODBC driver thread/process safe?

 As I've written in previous posts, one of my customers has this Zeacom phone
 system that has the ability to call a (VBScript) script to gather
 information from a back-end database so that it can display that information
 for a customer service rep handing the call.  Conceptually, it's really
 slick.  I had originally written the script using UniObjects, but the
 customer demanded that we use only ODBC to gather the information from
 Unidata, so I rewrote the script using ODBC.  This script opens a connection
 to Unidata, calls a subroutine, gathers the results, and then returns the
 text result to the phone system.  Like I said, it's really slick...

 ...except when there are two calls that come in basically at the same time.
 If there's a open ODBC connection to Unidata processing one call and another
 call comes in and opens up another ODBC connection (from the same Windows
 machine from a different process) one or both of the connections craps out,
 leaving a connection open and a license consumed.  We can log these off with
 UniAdmin no problem, but it's a hassle having to watch the user table pretty
 much all day to prevent all of the licenses from being consumed.

 The message as logged by the phone system looks like this:

 11:33:46.26 01803d90  QueryThread x755fe0: !! ERROR !! QmScript::Script:
 Error 0x80004005 Line 114 'D:\Program Files\Zeacom\CTI\Enhanced
 Routing\EnhancedRouting.vbs' line 114: [Microsoft][ODBC Driver Manager]
 Driver's SQLSetConnectAttr failed

 Line 114 of this script is opening the ODBC connection.  Not only did this
 particular connection fail, but the connection that was in progress when
 this one was started died unexpectedly as well, leaving an open connection
 and consumed license.

 This script really isn't rocket science, and it's vexing me that we can't
 seem to have multiple open ODBC connections from the same Windows server
 into Unidata.  Is this just a fact of life with Unidata and ODBC, or is
 there a solution?

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


Re: [U2] VISTA and U2 Tools

2008-04-02 Thread Brett Callacher
As far as UniObjects is concerned, we are told by our distributor in the UK 
that the only officially supported platform is Vista Ultimate.  This is 
apparently because IBM have not, and have no plans to, test on anything else, 
so I suspect it applies to all the U2 tools.

Brett

JPB-U2UG [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]...
 Does it have to be Ultimate or can it be Business?


 Jerry Banker
 Senior Programmer Analyst
 IBM Certified Solutions Expert

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:owner-u2-
  [EMAIL PROTECTED] On Behalf Of Brutzman, Bill
  Sent: Monday, March 31, 2008 11:34 AM
  To: 'u2-users@listserver.u2ug.org'
  Subject: RE: [U2] VISTA and U2 Tools
 
  Dynamic Connect v5.1.2, wIntegrate v6.0, and UniAdmin v1.3.1 all work
  well
  with Vista Ultimate with no issued uncovered at all.
 
  --Bill
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price
  Sent: Monday, March 31, 2008 8:53 AM
  To: u2-users@listserver.u2ug.org
  Subject: [U2] VISTA and U2 Tools
 
 
  We are getting new PC's soon and they will be coming with VISTA.  Has
  anyone had any problems running U2 Tools, UniAdmin, UniObjects, etc on
  VISTA?
 
 
 
  Brenda L Price
 
  Senior Programmer Analyst
 
  Affiliated Acceptance Corporation
 
  Sunrise Beach, MO
 
  (800)233-8483
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
 ---
 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][UV] ODBC causes data loss

2008-02-22 Thread Brett Callacher
A warning to all: using 'read only' ODBC reporting on Universe and with a DSN 
that references a UNC path, rather than the account path (or name) relative to 
the server, creates read-write pipes on the server.  This in turn can lead to 
data loss as whole groups in dynamic files go missing.

We have reproduced this on versions 10.1.11  10.2.3.  We have raised this with 
our distributor who are reporting this to IBM.

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


[U2] [ad] Job Vacancy, Croydon, UK

2008-02-19 Thread Brett Callacher
We currently have a vacancy for an Analyst Programmer (ideally Universe  VB).

For further details and to apply, please see:
http://www.gpmdev.co.uk/news/GPM-Job-Vacancy.html

No agencies please.

Brett Callacher
GPM Development Ltd
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniData to UniVerse Translation??

2007-10-16 Thread Brett Callacher
Try:

LIST FILENAME WITHOUT EVERY DOODADD = AAA

This also allows you to list the excluded items, eg AAABBB

HTH

Brett

David Wolverton [EMAIL PROTECTED] wrote in message news:[EMAIL 
PROTECTED]...
 In UNIDATA, I can type this query:

 LIST FILENAME WITH EACH DOODADD # AAA  (Pick Flavor)  or LIST FILENAME
 WITH EVERY DOODAD # AAA (Unidata Flavor)

 This would show me the items where **no** value in the Multivalue DOODAD
 Attribute is AAA --

 How do I achieve the same WITH EACH command work in UniVerse?   When I type
 the command I get:
   RetrieVe: syntax error.  Unexpected explicit item id.  Token was EACH

 When I try
 LIST FILENAME WITH EVERY DOODAD # AAA -- it runs, but returns items that
 have AAA in them.

 I need to pull the UniVerse document from IBM's website, but thought I'd ask
 while it crawls down...

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


Re: [U2] Locks in subroutines

2007-10-09 Thread Brett Callacher
It's interesting how one man's feature is another's bug... coming from a 
Pick/AP/D3 background I was horrified to encounter this behaviour in Universe.

I am not convinced by the encapsulation argument here.  If the lock is truly 
local to the file variable then should a READU in the subroutine be respected 
by other instances elsewhere?  Of course it should and so should the release.

I would contend that a global RELEASE with just a file variable (or worse none 
at all) is bad programming practice anyway...

My tuppence.

Brett

Martin Phillips [EMAIL PROTECTED] wrote in message news:[EMAIL 
PROTECTED]...
 Hi all,

  Very quick testing on my home machine, (Win2K and Universe PE) suggests
  that if you pass the opened file pointer from the main to the cataloged
  routine it works as you would expect.  If however, you do the file open
  within the subroutine it releases the lock when you return to the calling
  program.
 
  --
  Allen Egerton


 Although most programmers think of the lock as being related to the file, it
 is actually related to a particular instance of opening the file via the
 associated file variable. The behaviour described by Allen above is what you
 should expect.

 This is an essential feature of the language. If I open a file in a
 subroutine and either explicitly release all my locks using the variant of
 RELEASE with only a file variable or I simply close the file while I have
 locks in place, this should not (must not) affect other parts of my
 application that may have locks in the same file.

 This all comes down to the programming theory concept of encapsulation
 where one part of an application should not need to know anything about what
 it happening elsewhere.

 Note that if I copy the file variable, these are both references to the same
 file instance and locks are shared between the two file variables.


 Martin Phillips
 Ladybridge Systems Ltd
 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
 +44-(0)1604-709200
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] - Getting the call stack trace within a program

2007-09-03 Thread Brett Callacher
For UV, try SYSTEM(9001)

HTH

Brett

Symeon Breen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
 In Unidata it is system(49)  Not sure what number it is in uv but it
is a system function call.
 
 
 Rgds
 Symeon.
 
 
 
 -Original Message-
 From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lubin
 Sent: 03 September 2007 08:47
 To: u2-users@listserver.u2ug.org
 Subject: [U2] [UV] - Getting the call stack trace within a program
 
 I would like to write a program that will enable me to identify which
 program has modified our master file.  I have a generic program that
issues
 the write command, but would like to know what program/subroutine
called
 this generic program.  Alternatively, I am also looking at putting a
trigger
 on the file to identify when the record was modified.  
  
 One of the details that I want to capture is the call stack trace
(Like the
 one produced by the debugger/RAID T command)
  
 Is it possible for me to execute a basic statement/function that will
return
 the call stack trace. I know that we can issue a PORT.STATUS PID 
 LAYER.STACK, However, this is a very resource hungry command (and can
only
 be executed by 1 user at a time) and also the PORT.STATUS command
cannot be
 issued from a file trigger program.
  
 For example if I have PROGRAMA that calls SUBRA which in turns calls
SUBRA2
 and finally the GENERIC.WRITE, I would like to issue a command that
will
 return the subroutine stack : PROGRAMA ; SUBRA; SUBRA2; GENERIC.WRITE
 (preferably with the line number that called the various subroutines)
  
 Thanks 
  
 Bernard Lubin
 Development Department
 Reynolds and Reynolds
 ---
 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] [UV] LIST.READU program

2007-01-11 Thread Brett Callacher
Was not aware of the INTERNAL switch.  Very handy.



Trouble is, at least with UV on Windows, this works fine on 10.1.11 but
seems to return the user id running the LIST.READU on 10.1.18.  Can
anyone confirm this?



Thanks



Brett



Leroy Dreyfuss [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
om
news:[EMAIL PROTECTED]
m.com%3e ...

You  can  use  the INTERNAL keyword with LIST.READU to get the
results

back  as  a  dynamic array. You also might wish to index the
FILEINODE

and  FILEDEV fields of the UNIVERSE.STAT.FILE so you can use
something

like  SELECTINDEX  in  BASIC to obtain the records quickly. Using
this

method, it shouldn't matter if you use Windows or UNIX.



Regards,



LeRoy F. Dreyfuss

Product Manager

IBM UniVerse and UniData (U2) Data Servers

[cid:_2_0AA54ED00AA54C7C006A26B687257259]



Tel: 303-773-7783  Fax: 303-773-5915

Mobile: 720-341-4317 Tie-line: 656-7783

External email:  [EMAIL PROTECTED]

WWW:  http://www.ibm.com/software/data/u2



John Hester [EMAIL PROTECTED]

Sent by: [EMAIL PROTECTED]



01/04/2007 11:16 AM



  Please respond to

 u2-users@listserver.u2ug.org






 To



u2-users@listserver.u2ug.org






 cc





 Subject



RE: [U2] [UV] LIST.READU program



 -Original Message-

 From: [EMAIL PROTECTED]

 [mailto:[EMAIL PROTECTED] On Behalf Of Mike

 Pflugfelder

 Sent: Wednesday, January 03, 2007 7:02 PM

 To: u2-users@listserver.u2ug.org

 Subject: [U2] [UV] LIST.READU program



 Does anyone have a program written that would give us better

 output for

 LIST.READU that they wouldn't mind sharing?

I use this on UV:

0021: EXECUTE 'LIST.READU', OUT  READU.LIST

0022: DEL READU.LISTDCOUNT(READU.LIST,@AM)

0023: READU.ARRAY = TRIM(READU.LIST)

0024: CONVERT ' ' TO @VM IN READU.ARRAY

0025: LINES = DCOUNT(READU.ARRAY,@AM)

0026: QUIT = 0 ; CUR.LINE = 1

0027: FOR I = 1 TO LINES UNTIL QUIT

0028:   IF NUM(READU.ARRAYI,3) AND READU.ARRAYI,3 # '' THEN

0029: INODE.NO = TRIM(READU.ARRAYI,3)

0030: EXECUTE 'SH -c ls -i | egrep ':INODE.NO:'', OUT 
FILENAME

0031: IF FILENAME1,1,1 # '' THEN

0032:   FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#6'

0033:   INODE.POS1 = INDEX(READU.LISTI,INODE.NO,1)

0034:   INODE.POS2 = INODE.POS1 + LEN(INODE.NO)

0035:   IF LEN(INODE.NO) = 9 THEN

0036: INODE.POS2 += 1

0037: FILENAME = ' ':FILENAME:' '

0038:   END

0039:   READU.LISTI =

READU.LISTI[1,INODE.POS1-1]:FILENAME:READU.LISTI

[INODE.POS2,99]

0040: END

0041:   END

0042:   PRINT READU.LISTI

0043:   CUR.LINE += 1

0044:   IF CUR.LINE = 24 THEN

0045: PRINT 'Press any key to continue...':

0046: INPUT DATA.IO, 1

0047: QUIT = DATA.IO = 'Q'

0048: IF NOT(QUIT) THEN

0049:   CUR.LINE = 0

0050: END

0051:   END

0052: NEXT I

0053: END

The only caveat is that it can only report file names for the
account

you run it in.  Works well for us since all of our users work in a

single account.

-John

---

u2-users mailing list

u2-users@listserver.u2ug.org

To unsubscribe please visit http://listserver.u2ug.org/



 [demime 1.01d removed an attachment of type image/jpeg]

 ---

 u2-users mailing list

 u2-users@listserver.u2ug.org

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