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

2013-12-18 Thread HENDERSON MIKE, MR
I'm sorry, but the chances of me buying anything from a company whose website says under the heading Latest News that something is scheduled for release Jan '07 is very, very close to zero. In my view, a company that hasn't updated its website in seven years is - if still in business at all -

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

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

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

2013-03-04 Thread HENDERSON MIKE, MR
Or, instead of SAMBA on the HP-UX system, you could have an NFS share on the Windows box - Windows Server 2008 has Microsoft NFS Services for Windows and there are several freeware / shareware / commercial NFS clients for Windows. Lots of ways to skin this particular cat -Original

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

2012-10-04 Thread HENDERSON MIKE, MR
At a guess, an important customer relies on the behaviour that the option turns off and lost the argument about whether this was a feature-not-a-bug rather than a bug-not-a-feature Regards Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org

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

2012-10-01 Thread HENDERSON MIKE, MR
I have often thought about this - mostly in an idle moment or as a displacement activity for something less amusing that I ought to be doing. ;-) First of all, Universe is already extremely parallel: there's a separate O/S thread for each TTY and for each phantom, and you can't get more parallel

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

2012-09-06 Thread HENDERSON MIKE, MR
Great input, Tony. But be warned WJ, if your client PCs are external to your network, then Private Addressing and NAT may make this whole exercise nugatory. For example, if your host network / server is on your 10.x.y.z (or 192.168.a.b) and your remote client is on his 10.x.y.y (or 192.168.a.c),

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

2012-04-15 Thread HENDERSON MIKE, MR
Wol, Unless Rocket have fixed it in 11.x, the problem may be with the double quotes / bunnies ears. The DOS command is pretty badly broken, particularly if you need to try to use a quoted string with embedded spaces (e.g. '... C:\Program Files\MyApp\AppName.exe ...'). After I bitched about it, a

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

2011-10-06 Thread HENDERSON MIKE, MR
David, I think this is called a Histogram Method in the literature. You can obviously make the 'buckets' as big or as small as you like depending on how much memory you want to use - you could even have 1-byte buckets which would allow you to calculate the actual median rather than an

Re: [U2] Logical error {Unclassified}

2011-06-08 Thread HENDERSON MIKE, MR
Sathish, Or, if you want to make life a little easier for the next poor guy who gets to maintain the code: ESC = CHAR(27) MeaningfulNameForString = [44m ScreenCommand = ESC:MeaningfulNameForString CRT ScreenCommand

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

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

[U2] 'U2 Market Place' {Unclassified}

2011-03-07 Thread HENDERSON MIKE, MR
Folks, I have recently started getting email from postmas...@u2marketplace.com about the 'U2 Market Place'. It also features Return-Path: u2...@mercury.serverphase.com. Whilst it looks like it might be kosher, I'm a little intrigued as to where they got my email address from. The address they use

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

2011-02-09 Thread HENDERSON MIKE, MR
The trouble is, it's so much easier to Just code ... ELSE CRT @(00,24):'***ERROR*** end date must not be before start date' Than look up error number in a list. Darn, it's not there, assign a new number, update the list, document the change Now code ... ELSE ErrorCode = '123456'; ErrorText

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

2010-11-02 Thread HENDERSON MIKE, MR
Don, The DOS command is pretty badly broken, particularly if you need to try to use a quoted string with embedded spaces (e.g. '... C:\Program Files\MyApp\AppName.exe ...'). After I bitched about it, a new GCI function UVRunCommand was introduced (in 10.0 IIRC). You need code like this

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

2010-10-26 Thread HENDERSON MIKE, MR
I.E., add the line with NAP in it. You may want to try different NAP intervals to work out the best balance between snappy user response and CPU usage. OK = 0 ; START.DT = DATE() ; START.TM = TIME(); TIME.OUT = 900 LOOP INPUTIF PSN

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

2010-09-19 Thread HENDERSON MIKE, MR
I can't help finding a certain delicious irony in seeing a UniVerse support request coming from someone who works for the former owner of the product. Gayathru, I expect that IBM India should still have some internal support people who know about UniVerse, or at least know where they've gone. Do

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

2010-09-09 Thread HENDERSON MIKE, MR
Ryan, You said you had indexes like 'ORDER.DATE', 'COUNTRY', 'MEMBER ID'. If those are really the full index data items, you could have thousands, tens of thousands, or even hundreds of thousands, of records with the identical index data item value in the SOH file. If that's the case, updates

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

2010-09-01 Thread HENDERSON MIKE, MR
Dear oh deary me, this is sooo 1970s! Guys, Google 'optimistic locking' [Quick overview: 1) When the user first looks at the data, * read the record, no lock, * save a copy in memory (Named Common) or on a BeforeLook disk file 2) When the user wants to update the record, * read

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

2010-05-23 Thread HENDERSON MIKE, MR
But remember, Windows 2000 goes off life support - not even security patches - on 13th July. That's 13th July 2010, just seven weeks time. So I'd be more than a little bit leery about putting a new application on a Win2K box, especially if the box has got any sort of connection 'outside' your

Re: [U2] UD: Phantoms {Unclassified}

2010-04-07 Thread HENDERSON MIKE, MR
Meh! Like NAP 1 in UniVerse on Windows is actually NAP 18 - you can't actually NAP for 1 millisecond, the lowest resolution seems to be about 18 milliseconds. YMMV Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org On Behalf Of Dan McGrath Sent: Thursday, 8 April 2010

Re: [U2] Auto logout time {Unclassified}

2009-12-07 Thread HENDERSON MIKE, MR
Kate, IIRC UV Objects don't go through the login paragraph, the auto logout time is in the unirpcservices file (in your local equivalent of C:/IBM/unishared/unirpc/) Regards Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org

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

2009-12-07 Thread HENDERSON MIKE, MR
Bill, UOLOGIN would be a *lovely* enhancement to UV! But unless it's in 10.3, or is an undocumented feature in 10.2, it would indeed be an enhancement. :-( Wally, Rocket anyone, care to comment? Regards Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org

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

2009-09-15 Thread HENDERSON MIKE, MR
You can indeed say you now have a Rocket in your Pocket And I'm afraid that this rather exactly illustrates the damage to the products' image that will be done, or has already been done, by this disposal. How can anyone take a firm called Rocket Software seriously*? Sorry, but for me it's

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

2009-06-23 Thread HENDERSON MIKE, MR
Dave, From (IIRC) 10.0 onwards, there's the SYSTEM(9001) pseudo-variable which contains the UV CALL Stack. It's formatted a bit funny, but there may be a routine on the Pickwiki to make it a sensible format. HTH Regards Mike -Original Message- From:

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

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

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

2009-04-23 Thread HENDERSON MIKE, MR
RESIZE file name DYNAMIC GROUP.SIZE 2 MINIMUM.MODULUS your guess I think the manual says this doesn't work but it does, on Windows anyway. Usual caveats about resizing files apply! YMMV Regards Mike -Original Message- From: owner-u2-us...@listserver.u2ug.org

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

2009-03-26 Thread HENDERSON MIKE, MR
Yes, fine and warm - low twenties Celsius - Napier, Art Deco capital of the world. New Zealand 4/393 against India, an hour into day two of the second Test match. Wish I was there instead of stuck in a Wellington office! ;-) Regards Mike -Original Message- From:

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

2009-03-19 Thread HENDERSON MIKE, MR
Wol / Wally T / Anyone Can you please specify what was the earliest version of UV that includes the dynamic files headers are flushed when they are updated feature? For a site with lots lots of dynamic files and planning a UV platform upgrade anyway, this would be a big pointer in determining

RE: [U2] time Verb {Unclassified}

2009-03-09 Thread HENDERSON MIKE, MR
Why do people [with NT systems] change the system time to deal with daylight savings changes? Because that's the way MS-DOS did it. On Unix systems, the hardware clock runs in UTC, and the TZ variable is used to determine the difference between UTC and local time (including allowing for daylight

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

2009-03-04 Thread HENDERSON MIKE, MR
Roger, Two possibilities occur to me:- * How big is that Index file - it's not getting close to 2GB by any chance? * Maybe it's getting confused between numbers and strings somehow: would something that works like SELECT FILE WITH :INVOICE EQ 0499906608.1 [You could make a new I-Type called

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

2009-02-26 Thread HENDERSON MIKE, MR
Tom, I don't think that 'maintaining a lock manager' is necessarily a good solution to non-persistent connections. A more conventional approach is for each connection to maintain the state of the record(s) it was going to modify - i.e. a 'before image'. Then, when it's time to apply the

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

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

RE: [U2] biztalk adapter {Unclassified}

2008-11-25 Thread HENDERSON MIKE, MR
There are simple, but rather crude and nasty, ways of doing this. The most obvious is to use the BizTalk 'file' adapter, with the target BizTalk directories described as UniVerse Type 19 files. The UniVerse 'send' process drops XML messages as 'records' in the Type 19 file into the directory for

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

2008-10-15 Thread HENDERSON MIKE, MR
UV/Net doesn't handle Distributed Files (32- or 64-bit) - it's a published 'feature'. You have to refer to the individual part files. Actually, that seems like a good Better-and-Better submission ... Regards Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Boydell,

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

2008-10-13 Thread HENDERSON MIKE, MR
Troy, You _can_ use 64-bit files on 32-bit Windows 2003 Server, NTFS is quite happy with files over 2GB. I would describe multi-level files as an 'old' way of getting some of the same functionality as you get with UV Distributed files. You could have STOCK,HIST1 and STOCK,HIST2 ... if you

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

2008-10-08 Thread HENDERSON MIKE, MR
Bill, Or you can use the UniVerse ENCODE() function to turn the binary photograph data into a Base64 MV-safe form on input for storing in a regular UniVerse file, and back into the original form for output. And IIRC, the un-ENCODEing process arbitrarily inserts CHAR(10) every 76(?) characters.

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

2008-09-25 Thread HENDERSON MIKE, MR
Peter, You don't have licenses per account, only per UniVerse system instance. The maximum UV licensed users count is available in SYSTEM(36). The number of licenses currently consumed is available in SYSTEM(35). Regards Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of

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

2008-09-17 Thread HENDERSON MIKE, MR
I have come across this limitation before, too. One work-around is to use READSEQ and WRITESEQ, that seems to work OK even when COPY and ED fail. Also, the item size limit on the Windows implementation of UV was much larger than that on Unix last time I participated in a conversion (it may even

RE: [U2] CAPTURING TOXML {unclassified}

2008-07-27 Thread HENDERSON MIKE, MR
At UV 10.1 XMLExecute() is documented in the Basic Extensions and 10.1 New Features manuals. At UV 10.2 XMLExecute() is documented in the Basic Extensions and Basic Reference (BasicRef.pdf) manual However, in three out of the four of these manuals the documentation is WRONG - they say it takes

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

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

RE: [U2] Friday query logic {Unclassified}

2008-06-24 Thread HENDERSON MIKE, MR
Try WHEN not WITH LIST APOPEN WHEN(ACCTS UNLIKE 52... AND ACCTS UNLIKE 29...) etc Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathleeni M Hunter Sent: Wednesday, 25 June 2008 12:23 p.m. To: u2-users@listserver.u2ug.org Subject:

RE: [U2] blink questions {Unclassified}

2008-05-13 Thread HENDERSON MIKE, MR
uvNet - ... Does CONFIG show it when it is installed? Sure does --- CONFIG Configuration data for license number my Dev license: User limit =20 Expiry date=1/1/2500 -UVNET package is installed. User limit = .

[U2] UniVerse to PDF {Unclassified}

2008-05-11 Thread HENDERSON MIKE, MR
List-folks, I'm sure I've seen someone on this list advertising an 'all UniVerse' solution to outputting PDF documents from a UniVerse system. Then, I wasn't interested, so I threw the message away. Now, I just might have an application for such a technology. So, if you're in the business of

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

2008-04-14 Thread HENDERSON MIKE, MR
Harold, If your UniVerse server is Windows, it's not too hard at all:- Install the UniVerse ODBC Client from the U2 Clients CD on your server On the server, do to Start Settings Control panel Administrative Tools Data Sources (ODBC) From the System DSN tab, select Add, choose 'SQL Server',

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

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

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

2008-03-30 Thread HENDERSON MIKE, MR
For what it's worth, that's why when we recently upgraded out UniVerse / Windows2003 Production server, I specifically said don't get more than 4GB. To use more than that, with a 32-bit Windows platform, you need to use the /PAE and /3GB switches. I think you may also need to use Win2K3 Enterprise

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

2008-03-17 Thread HENDERSON MIKE, MR
UV 10.1.18, Windows Server 2003 Using Louie's code without the DISPLAY Ran over two-and-a-quarter million iterations so far, task memory allocation for tl_server.exe is still 10,344KB, the same as it was when I started. It also spawns a SYSTEM thread which steadily consumes 40KB Regards Mike

RE: [U2] Estimating Timelines {Unclassified}

2008-03-09 Thread HENDERSON MIKE, MR
And then, you have the client factor, as in * Work out a rough estimate * Double it * And multiply this result by the client factor to give the actual estimate You know what I mean, * If you ever find such a beast, a really good client that knows what they want

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

2008-03-04 Thread HENDERSON MIKE, MR
Jacques, If you're referring to UniVerse, use the @TRANSACTION meta-variable:- @TRANSACTION * A numeric value. Any nonzero value indicates that a transaction is active; the value 0 indicates that no transaction exists. Regards Mike -Original Message- From: [EMAIL PROTECTED] On

RE: [U2] Distributed files poll {Unclassified}

2008-01-23 Thread HENDERSON MIKE, MR
Brenda, We have several, each part is Type 30 / Dynamic. Our Distributed Files have only four to six parts, in general. No discernable bad impacts on performance, some things have improved performance because only one part-file is scanned instead of the whole file. We have no 64-bit files and

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

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

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

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

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

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

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

2007-12-10 Thread HENDERSON MIKE, MR
John I also remember setting up a separate SQL-ized UV account and Q-pointers back to my Pick flavor account's data to make that work. I'm fairly sure that's the recommended way of doing it, it's certainly the way we've done it. That way, you only 'expose' the particular file(s) and data

RE: [U2] UV - 10.2.2 [unclassified]

2007-11-06 Thread HENDERSON MIKE, MR
From: [EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Wednesday, 7 November 2007 9:43 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] UV - 10.2.2 [not-secure] [snip] Do any of our IBMers have an idea when 10.2.6 will be released for Solaris? Or Windows, we've been at 10.2.3

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

2007-10-24 Thread HENDERSON MIKE, MR
Stuart, Can you tell us when IBM in their wisdom have decided to add a UTF8 encoding tag in the XML header? I think it was some time between 10.0.15 and 10.1.18, but not sure when. It is, as you can see from the second message below, causing us grief in our BizTalk 2006 upgrade. We are looking

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

2007-09-18 Thread HENDERSON MIKE, MR
John, No, but you have to *create* the file before UV will use it (yes, I know it's nuts, but it's always been that way) Just touch errlog in the right directory. With the right permissions, of course Regards Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of John Hester

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

2007-09-16 Thread HENDERSON MIKE, MR
I was one of those who returned with a bulging brain! No question, it was the best training money my boss has spent on me in years. If you possibly can, GO! Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Friday, 14

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

2007-08-21 Thread HENDERSON MIKE, MR
Thanks, Sara UVCS.LOGIN seems like just exactly what I need (for a different reason) and have been looking for for ages. What a pity that it is completely undocumented - except in the U2UG List of course! Is there an equivalent for ODBC and/or OLEDB login? Maybe ODBC.LOGIN? Jef, you could

RE: [U2] U2 University {Unclassified}

2007-08-19 Thread HENDERSON MIKE, MR
, Kate Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland, New Zealand Phone +64 9 360 5310 Fax +649 376 0750 Email [EMAIL PROTECTED] - Original Message - From: HENDERSON MIKE, MR [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, August 17, 2007 10:17 PM

RE: [U2] U2 University {Unclassified}

2007-08-19 Thread HENDERSON MIKE, MR
Thanks, Ray Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Monday, 20 August 2007 3:43 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University {Unclassified} Stay with the ferries - it's by far the

RE: [U2] U2 University {Unclassified}

2007-08-19 Thread HENDERSON MIKE, MR
Sounds like an excellent idea. Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Monday, 20 August 2007 4:14 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 University {Unclassified} Is there going to be a

RE: [U2] U2 University {Unclassified}

2007-08-17 Thread HENDERSON MIKE, MR
I'm going to the Sydney, Australia session. Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Thursday, 9 August 2007 05:07 To: u2-users@listserver.u2ug.org Subject: [U2] U2 University I'm going to the U2 University in Denver the last week of this

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

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

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

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

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

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

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

2007-07-05 Thread HENDERSON MIKE, MR
Ah, yes there it is in the User Reference, like you said Mark. BUT, on 10.1 anyway, * 'SUSPEND.FILES' is not in the Index of the User Reference, you have to search the document to find it. * When you do find it, it doesn't say whether the Dynamic / Type 30 file headers (or anything

RE: [U2] Time conversion code {Unclassified}

2007-06-07 Thread HENDERSON MIKE, MR
UV 10.1.18 on Win2K3 User Accounts LIST VOC RELLEVEL EVAL @RECORD EVAL 9 CONV MTS VOC.@RECORD...9. RELLEVELX 01:00:00 10.1.18 INFORMATIO N INFORMATIO N.FORMAT

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

2007-05-09 Thread HENDERSON MIKE, MR
Dear UniVerse Gurus, Our UniVerse system (10.1, Win2K3) is set up without any Transaction Logging parameters set in the UV Config. I.E. TXMODE = 0, and all the other related configration parameters are set to defaults. Transactions do however, still work from UniBasic or from UniObjects, even

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

2007-05-07 Thread HENDERSON MIKE, MR
HELP BASIC STATUS (from TCL) tells you all you need to know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave R Sent: Tuesday, 8 May 2007 12:28 To: u2-users@listserver.u2ug.org Subject: [U2] 2 questions, one on STATUS and the other on

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

2007-04-19 Thread HENDERSON MIKE, MR
This is actually a 'hard' problem in IT, particularly with some large ERP packages, a German one being a particularly aggravating example. ;-) However, in a UniVerse environment, if you have source code, it's not too difficult. [The fact that other packages / systems make it seem so hard is a bit

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

2007-04-16 Thread HENDERSON MIKE, MR
Ray, NZ Defence Force will have at least two, possibly three attendees. These are all Wellington-based civilian employees, so we would prefer Wellington. Looking forward to it Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Tuesday, 17 April 2007

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

2007-04-02 Thread HENDERSON MIKE, MR
No SYSTEM() function as far a I know But see HELP MAKE.MAP.FILE LIST MAP WITH @ID LIKE Program id REF OBJ CR SIZE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul McVicker Sent: Tuesday, 3 April 2007 08:36 To: u2-users@listserver.u2ug.org

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

2007-03-22 Thread HENDERSON MIKE, MR
Yes, Wol. SYS.TERMINALS exists on UniVerse 10.1.18. Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Friday, 23 March 2007 06:35 To: u2-users@listserver.u2ug.org Subject: Re: [U2] I need info on trapping the 'page up' key within a Universe

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

2007-03-12 Thread HENDERSON MIKE, MR
Chuck, You can say 2GB or 3GB, but unless you're using a 64-bit CPU (I think they all are, now) and a 64-bit O/S (which XP professional is not), you can't effectively use more than 3GB, even though the box will probably address 4GB (or even more) happily. A 32-bit O/S like Windows uses a 4GB

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

2007-03-11 Thread HENDERSON MIKE, MR
Folks, I have been asked to find out if either 'Progress' or 'RedBrick' databases are multi-value. Their web-sites don't say anything either way so far as a quick look told me, but we all know that many products are shy about any association with 'Pick'. So, any information would be helpful.

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

2007-02-22 Thread HENDERSON MIKE, MR
Dianne From the Linux command line prompt in the \UV\bin\ directory uvlictool clean_lic -a Or Create a Paragraph PA SH /c 'path to UV stuff\bin\uvlictool clean_lic -a' I think you need to be a super-user to do clean_lic HTH Mike -Original Message- From: [EMAIL PROTECTED] On

RE: [U2] Index Problem {Unclassified}

2007-02-06 Thread HENDERSON MIKE, MR
We have no scheduled index re-builds here. Very, very occasionally we get an unexplainable error which 'goes away' when we rebuild the index on the file that's giving the error. The last time was a 'Write Error' [#040011] on a file with triggers and secondary indexes. Not actually sure whether

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

2007-01-31 Thread HENDERSON MIKE, MR
Leslie, Jon and others, Thank you all for these and other suggestions for alternatives to the 'official' IBM training course delivery. I am sure they are all very valuable. I may even take advantage of some of them, as I have of others in the past. However, I have at this moment a specific

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

2007-01-30 Thread HENDERSON MIKE, MR
Thanks, Ray Training Choice don't appear to have a presence in NZ, they sub-contract to Ace Training, who regularly advertise IBM training courses - in Tivoli, Notes, Domino, etc, but never any U2. :-( They have said in the past that UV903 (now superceded by U2125 I suppose) could run in

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

2007-01-29 Thread HENDERSON MIKE, MR
Oz Folks, The IBM Course U2125 IBM UniVerse UniData Database Programming (or its predecessors) has not been delivered in NZ for ages, despite my having a standing order with the alleged provider for about three years. Has this course actually been delivered recently in Australia? What are the

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

2007-01-29 Thread HENDERSON MIKE, MR
- From: Craig Bennett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, January 30, 2007 11:23 AM Subject: Re: [U2] IBM Course U2125 in Australia? {Unclassified} If the course runs in Sydney, I have a candidate too. Craig HENDERSON MIKE, MR wrote: Oz Folks

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

2007-01-14 Thread HENDERSON MIKE, MR
Perry, NAP takes milliseconds as its parameter, but, at least on Windows platforms, NAP 1 does not sleep for 1 millisecond, but actually for about 15 milliseconds. It seems that there is a fundamental clock somewhere in the UV Basic runtime environment on Windows that only 'ticks' about once

RE: [U2] UV Bci {Unclassified}

2007-01-11 Thread HENDERSON MIKE, MR
Rudy, I use a code fragment that looks a bit like this [names have been changed to protect the innocent ;-) ] STATUS = SQLExecDirect(HANDLE,EXEC Stored proc name @Input param name = ':Input param value:' ;) STATUS = SQLBindCol(HANDLE, 1, SQL.B.DEFAULT, return parameter 1) STATUS =

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

2006-11-30 Thread HENDERSON MIKE, MR
Charles, I have 10.1.18 (Windows) and the UNIVERSE.INCLUDE FILEINFO.H entries you are worried about are still there in the source code! :-) I ran your sample code and got what appears to be exactly the same outputs. Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of

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

2006-11-09 Thread HENDERSON MIKE, MR
OK, this seems more than a bit weird to me (must be Friday afternoon!) ... Our QA guys are testing a new VB.NET application which connects to UV via UVObjects and calls a subroutine that calls a subroutine that writes one record and PHANTOMs off a batch-type job. The VB app was written with a

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

2006-11-07 Thread HENDERSON MIKE, MR
Doug, There are two alternatives:- 'DOS /c Windows command-line string' This is the direct equivalent of the Unix 'SH /c Unix command-line string', but it mangles strings containing double-quoted spaces, e.g. 'DOS /c MyUtility.exe -qstring with spaces' See HELP DOS To get round that problem, a

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

2006-09-20 Thread HENDERSON MIKE, MR
Yes Better still, isTRUE=TRUE12=Y Works the same and can be tricky to find when the second = is a typo for adjacent or shifted keys - or + :-( Which is why I much prefer to see isTRUE = @FALSE IF TRUE12 EQ Y THEN isTRUE = @TRUE As a convention, I always use = for assignment only and EQ for

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

2006-09-12 Thread HENDERSON MIKE, MR
George INT(((DATE() - 1) * 86500) + TIME()) will stay as ten digits until 07 JUL 2284, which might well be long enough for your purposes 07 JUL 2284 is a ten-digit date+time:- LIST file SAMPLE 1 EVAL((DATE()+101470) * 86500) + TIME() EVALOCONV(DATE()+101470,DE) ID955099.016

RE: [U2] Universe Logins {Unclassified}

2006-08-27 Thread HENDERSON MIKE, MR
John, I am having the exact same problem, also on UV 10.1.18 / Windows 2003 Server SP1. This particular user was away on an extended vacation during which his password expired. When his domain password was reset, he lost the ability to log in as a Telnet user to the Development box using his

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

2006-08-13 Thread HENDERSON MIKE, MR
Chris, Yes, an I-Type and an I-descriptor are two words for the same thing. The point I am making is that you can be exporting what looks on the surface like a simple data item from UV via ODBC. Then when you look at the actual dictionary entry, you find it is an I-descriptor with perhaps two

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

2006-08-10 Thread HENDERSON MIKE, MR
John, Chris is transferring on average about 360 (2.6M / 2 / 3600) records per second. If the records are ~200 chars, then he's getting about 700kb/sec (that's kb, not kB), or about 1.5% of the throughput you might hope for on a 100Mbps Ethernet pipe! So I'd say Chris does have an issue here. I

RE: [U2] [UV] Weird error {Unclassified}

2006-07-24 Thread HENDERSON MIKE, MR
Scott, There are some HP-specific tuning parameters in UV10.x - 'SPINTRIES' and 'SPINSLEEP'. Maybe these need to be set up somehow? HTH Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 25 July 2006 07:11 To: u2-Users Subject: [U2] [UV]

[U2] FW: On data models, data types and dangerous liaisons | The Register {Unclassified}

2006-07-23 Thread HENDERSON MIKE, MR
The author has posted a follow-up to the multi-value harmful article, it's here:- http://www.regdeveloper.co.uk/2006/07/22/data_models/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the

RE: [U2] [UV] time() {Unclassified}

2006-07-23 Thread HENDERSON MIKE, MR
Barry, I believe that all the UV platforms now return TIME() as a 9.999 quantity, this was made uniform across the range sometime in the 10.0 timeframe. Then sometime during 10.1, the TIMEACCURACY configuration parameter appeared, I'd guess because too many people complained that they had

[U2] FW: Multivalued datatypes considered harmful | The Register {Unclassified}

2006-07-19 Thread HENDERSON MIKE, MR
MS Access 2007 is to support multi-valued data types! ... if you are an application developer, the finer points of relational database theory often sound like just so much academic nonsense. If a new feature makes life easier, who cares if it happens to break some arbitrary rule written over 20

RE: [U2] ODBC Error {Unclassified}

2006-07-18 Thread HENDERSON MIKE, MR
Al, For what it's worth ... CT SYS.MESSAGE 081001 081001 0001 unirpc: Bad Connection 0002 Not very helpful, I'm afraid Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Wednesday, 19 July

RE: [U2] UV - Tracking file writes Unclassified}

2006-07-12 Thread HENDERSON MIKE, MR
Mike, -Original Message- From: [EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Thursday, 13 July 2006 05:46 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Tracking file writes A trigger would be an ideal method as it's non-intrusive to your existing code. [snip]

RE: [U2] Changing server IP address {Unclassified}

2006-07-10 Thread HENDERSON MIKE, MR
-Original Message- From: [EMAIL PROTECTED] On Behalf Of Arie van Dam Sent: Tuesday, 11 July 2006 02:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Changing server IP address I just changed the IP address of our customers servers this weekend with no problems whatsoever, to

RE: [U2] Universe file size limits {Unclassified}

2006-07-05 Thread HENDERSON MIKE, MR
Eugene UniVerse files can go over 2GB if they are created / resized as 64-bit. I have done this on UV 10.0 on Win2K3, it works! You can also use UniVerse distributed files to partition your data so that a set of less-than-2GB files appear as a single logical entity. This is the approach we took

RE: [U2] 4gb RAM on W2K 32bit {Unclassified}

2006-07-04 Thread HENDERSON MIKE, MR
Our Production Win2K3 system has 3GB, worked with UV10.0, recently upgraded to 10.1. Hope this helps Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Hilbert Sent: Wednesday, 5 July 2006 08:10 To: u2-users@listserver.u2ug.org Subject:

  1   2   3   >