Re: [U2] SB+ PA Compare

2010-06-02 Thread Anthony Youngman
On 02/06/10 21:10, Steve Romanow wrote: > On 6/2/2010 3:00 PM, u2-users-requ...@listserver.u2ug.org wrote: >> Date: Wed, 2 Jun 2010 06:45:43 -0700 >> From: "Boydell, Stuart" >> To: U2 Users List >> Subject: Re: [U2] SB+ PA Compare >> Message-ID: >> <7ee7790a950e094399b01520071826a20106b48d6...@

RE: [U2] Universe SIMPLE database management tool

2004-05-11 Thread Anthony Youngman
Actually, it predates the PC product. It was written (iirc) for 50-series INFORMATION, and that was the version we first had. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy Sent: 11 May 2004 14:20 To: [EMAIL PROTECTED] Subject: Re:

RE: [U2] Getting current SETPTR values

2007-08-10 Thread Anthony Youngman
Does !SETPTR (or !SET.PTR - can't remember) do what you want? Cheers, Wol -Original Message- From: Jonathan Leckie [mailto:[EMAIL PROTECTED] Sent: 10 August 2007 09:55 To: u2-users@listserver.u2ug.org Subject: [U2] Getting current SETPTR values Is there a way to get the values reported

RE: [U2] IBM - Windows Vista Support with U2 products

2007-08-14 Thread Anthony Youngman
Quite likely - it's "Patch Tuesday", the second Tuesday of the month, when MS releases a month's worth of security patches in one hit. So that'll include XP, W2K if it's still supported, Office, and everything else. There might not actually be a lot of Vista-specific stuff in there... Cheers, Wol

RE: [U2] Binary data corruption on copy

2007-08-22 Thread Anthony Youngman
The OP was worried about a Unix directory not being able to handle the thousands of jpegs he had. I can't offer help as to how to store binary in a hashed file (other than what some other person suggested - convert it to ascii somehow eg uuencode or whatsit64), but I think you may well be able to

RE: [U2] Internal Cache in Unidata

2007-09-24 Thread Anthony Youngman
What OS? How much RAM does your server have? Etc etc. What's the likelihood that the data was on disk when you first ran the query, and was pulled into the OS cache as a result? Second time round, the OS didn't bother to access the disk because it was all in cache ... Especially if your query i

RE: [U2] U2U London

2007-09-26 Thread Anthony Youngman
If you can find the IBM Bedfont Lakes website, I'm sure it lists hotels. And if the hotel is within lurching distance of Heathrow Airport, last I knew there was a courtesy bus that ran from the Airport (and from the local BR rail station) approximately every half hour. But the airport itself is

RE: [U2] help!

2007-10-08 Thread Anthony Youngman
Is it possible your work server is subscribed and you're on the internal distribution list? See if you can look at the email header to find out if it's been forwarded from somewhere. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chan

RE: [U2] ODBC error

2007-10-23 Thread Anthony Youngman
If you did that, in that order, then the answer's simple. You need to update the cache AFTER updating HS_FILE_INFO. Can't remember the name of the command, but it's something like you need to run HS.UPDATE in the same account as HS_FILE_INFO in order to publish the changes. Cheers, Wol -Or

RE: [U2] Stringing commands together on the command line. Possible?

2007-10-29 Thread Anthony Youngman
And an easy way to block that is to remove write access to the dictionary. Iirc, you can't compile an EVAL if you can't compile an i-type. I believe that was done for security reasons, but it may simply be that the easy way to code it was to write a temporary item to the dictionary. Either way,

RE: [U2] OCONV Extraction Question - Best Practises

2007-11-19 Thread Anthony Youngman
Just DON'T start a few flame wars over this :-) I'd actually vehemently disagree with the original suggestion, for several reasons. The two biggest are: It introduces an extra variable. Any poor maintenance guy coming along has to worry about whether it's used elsewhere. This sort of behaviour

RE: [U2] Badly overflowed Dynamic files

2007-11-27 Thread Anthony Youngman
Overflowed groups take longer to read, so you want to reduce the number of such groups. Is the size of this file roughly constant, or does it just slowly grow? If it's roughly constant, try setting a MINIMUM.MODULO at around 900,000. It'll hopefully break up a lot of your badly overflowed groups

RE: [U2] Deep and long indentations vs multiple exit points

2007-11-28 Thread Anthony Youngman
I must admit I prefer multiple exit points, but I'll throw a third variant into the mix ... OK = TRUE IF OK THEN Various statements that set OK to false if there's an error END IF OK THEN More statements that set OK to false if there's an error END Rinse and repeat RETURN Cheers, Wol --

RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation

2007-11-29 Thread Anthony Youngman
I think part of the problem is, because it says MINIMUM.MODULUS, we think of it as analogous to the modulus of a hashed file. It isn't. It's more of a hint to the system about how big the file is likely to be, and how to avoid wasting effort. So if you're creating a file and intend to load it w

RE: [U2] Badly overflowed Dynamic files

2007-11-29 Thread Anthony Youngman
e batches that has been taking up to two hours to complete finished the other night in under 10 minutes. Thanks a ton. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, November 27, 2007 10:22 AM To: u2-users@listserver.u2u

RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation

2007-12-03 Thread Anthony Youngman
A second, far bigger adjustment (which will account for a lot of the underestimate), is to divide by 1600, not 2000 or 2048. A split factor of 80 means that your groups will, at maximum, be 80% full. 80% of 2048 is 1640 (near enough). That will give a second-cut (and rather more accurate) estim

RE: [U2] anyone seen this error before?

2007-12-27 Thread Anthony Youngman
Replying again ... Having looked at the previous email, I notice that the if/else/endif was originally #if/#else/#endif. Those #'s are important ... ignore my previous solution and put the #s back. Oh - and whether UCB is 1 or 0 - do "man setpgrp" and hopefully the answer will be obvious ...

RE: [U2] anyone seen this error before?

2007-12-27 Thread Anthony Youngman
My C skills are rusty, but I think the two errors are 1) a misplaced curly brace - it's " procedure (args) { body } " so move the first curly brace between the arguments and the variable declarations. 2) C doesn't have "endif" - get rid of it. (Oh - and good programming practice - always put yo

RE: [U2] Graphic Printing

2008-01-04 Thread Anthony Youngman
It's not quite true that HP-GL/2 is in all HP laser printers... Although it predates PCL/5, when that came out with the LaserJet III, it was included as a subset. So it's not found on LaserJet IIs or Is (anybody still got any?), and it should also be found any recent laser (or inkjet) that clai

RE: [U2] Problem installing System Builder PE

2008-01-18 Thread Anthony Youngman
I think IBM's versions officially work on Red Hat. Somewhere along the line one of the cpio arguments' official meanings has been reversed, and I think RH hasn't changed. You're probably right in saying it's the "c" option, which now in most non-RH distros has exactly the *opposite* effect that

RE: [U2] What is the BREAK key setting for Dynamic connect?

2008-01-23 Thread Anthony Youngman
Setting the terminal to 132 chars wide ... I did that at another site. There's an @(-nn) setting (which you'll probably have to define yourself - I don't think it's set by default in the files provided by IBM). And the TERM command doesn't do anything with it. However, you get the source for T

RE: [U2] UniObjects error 30105 "Unable to load subroutine on server"

2008-02-06 Thread Anthony Youngman
Thanks. It's on UV, but we found the problem. The routine wasn't cataloged! What threw me was that it worked sometimes, but I'm told that if you call a routine locally it doesn't always need to be cataloged. So, obviously, sometimes the call to load the subroutine looked in the right place and

RE: [U2] question(s)

2008-02-06 Thread Anthony Youngman
The one problem with SAMPLE and SAMPLED is that, afaik, they are pseudo-random. Unless your file is volatile, you are likely to get approximately the same result set every time (or exactly the same result set, if your file hasn't changed). Cheers, Wol -Original Message- From: [EMAIL PR

RE: [U2] UniVerse 10.2 Error code: 2 2 on OpenSUSE

2008-02-14 Thread Anthony Youngman
It's the classic "UV is supported on Red Hat" problem. The install script doesn't understand the SuSE rc setup. This all ought to be documented somewhere ... has somebody put a "how to install on SuSE" FAQ on the u2ug wiki? If not, could someone put one there (I did it so long ago, I've forgott

RE: [U2] [UB] Beep Error

2008-02-14 Thread Anthony Youngman
PRINT CHAR(7) I think you can also do PRINT @BELL Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 14 February 2008 15:32 To: 'u2-users@listserver.u2ug.org' Subject: [U2] [UB] Beep Error How do I send a rudimentay ascii a

RE: [U2] Indexes

2008-03-14 Thread Anthony Youngman
I'd use basic. When I used it (yonks ago) I thought the manual was reasonably clear. The basic command takes two arguments. The first is the index name, and if that's all you supply it returns a list of the index values. The second is the index value, and if you supply that as well it returns a

RE: [U2] Indexes

2008-03-14 Thread Anthony Youngman
Ah... If that's what you want, then in BASIC SELECTINDEX "STOCK.ID" FROM F.REPAIR Should have exactly the same effect (and save the overhead of an EXECUTE). The only difference is the resulting select list may not be sorted (although I think it is). If you then want to find what records are t

RE: [U2] RE: UNIDATA 7.1 performance measures

2008-03-31 Thread Anthony Youngman
Firstly, you should NEVER run AV software on a database server. It's known for causing performance issues. By all means run a scan on the database from a remote machine via a share ... And you don't want it installed on the db server, because a lot of these things have a nasty habit of self-act

RE: [U2] COMMON

2008-04-04 Thread Anthony Youngman
And be very careful with 4GLs using named common, as I found out many years ago with &PACE. It stored filepointers in named common, generating the common name from the file name. Fortunately we found the problem when the runtime complained of a redefinition of common (one routine had the same n

RE: [U2] UVODBC Account Activation

2008-06-25 Thread Anthony Youngman
Not that I know much about this error but ... What version of UV are you running? I've set up ODBC on both 9.6 and 10.2, and the later version seems to be a lot more robust ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent:

RE: [U2] UVODBC Account Activation

2008-06-25 Thread Anthony Youngman
t's a very old version of uv - maybye 9.5 or possibly even 9.4 Mac -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 12:41 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation N

RE: [U2] UVODBC Account Activation

2008-06-26 Thread Anthony Youngman
CTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 16:34 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Okay. Firstly, do you need this file in your account? Oddly enough, most of my "hard to fix" problems with ODBC

RE: [U2] UVODBC Account Activation

2008-06-26 Thread Anthony Youngman
se they only use SQL Schemas. The fact you think you're running a very old version also means it may be (probably is) a fixed problem by now... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 26 June 2008 09:42 To: 

[U2] ODBC problems

2008-06-30 Thread Anthony Youngman
I'm having a problem with ODBC ... I found a post about what looks like my problem on gmane from 3 years ago but it wasn't very helpful ... it just said "we upgraded our software and it went away" ... Anyways, the error I'm getting is ODBC--call failed. [IBM][UVODBC][1401032]Error ID: 46 Severi

[U2] RE: ODBC problems

2008-06-30 Thread Anthony Youngman
327 SQL_SUCCESS What's odd is it looks like it's the PC end getting the query wrong before it sends it, but I've got two files sharing the same physical dictionary file and one works while the other one doesn't ... which implies a data problem ... cue headscra

RE: [U2] RE: ODBC problems

2008-07-01 Thread Anthony Youngman
avid -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 01, 2008 12:01 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: ODBC problems What's odd is it looks like it's the PC end getting the query

RE: [U2] locking question

2008-07-01 Thread Anthony Youngman
I notice you're on nix ... Is the piece of code that writes invoked via an EXECUTE or PERFORM from the code that did the original READU? I wouldn't expect it to on doze, but on Unix that *might* change the execution environment enough to cause a problem... (grasping at straws to see if it gives

RE: [U2] UniObjects - read .rtf doc from UV server

2008-07-07 Thread Anthony Youngman
Just be warned - rtf isn't as portable as it's supposed to be. I wrote rtf files from UV and they would read perfectly okay in some word processors and not in others. Oh - and just doing a "read, save" in Word of a file created in UV increased the file size horrendously ... There might be some

[U2] Strange SQL query optimisation ...

2008-07-17 Thread Anthony Youngman
One of my colleagues brought a speed problem to me - he has two queries which produce the same result but one (the "proper" "modern" SQL) runs slowly, and the other (deprecated SQL) runs much faster. He was running them in a web engine, so I ran them at TCL with the EXPLAIN keyword and got an odd r

RE: [U2] Strange SQL query optimisation ...

2008-07-18 Thread Anthony Youngman
the right table. An index on @ID in each of the tables may help. > - Original Message - > From: "Anthony Youngman" <[EMAIL PROTECTED]> > To: "u2-users@listserver.u2ug.org" > Subject: [U2] Strange SQL query optimisation ... > Date: Thu, 17 Jul 2008 14:34:

RE: [U2] Copied an account, now indexes messed up..

2008-07-18 Thread Anthony Youngman
And if you've got to rebuild all the indices on the live server, you might want to look at recreating them. Not sure what the keyword is, but if you recreate them as relative indices, it will put the relative path in the file header and you won't have this problem again ... Cheers, Wol -Or

RE: [U2] Strange SQL query optimisation ...

2008-07-21 Thread Anthony Youngman
Thanks. If I add the no.optimize keyword, it changes all joins to an "outer cartesian join". So that's even worse ... (I haven't tried actually running it :-) If a LEFT JOIN and LEFT OUTER JOIN are the same thing, that adds another little oddity to the mix :-) Why is the optimiser using both t

RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows

2008-07-21 Thread Anthony Youngman
Sounds like you might not have to do fnuxi at all ... If your linux is running on x86, you will probably get away with just a copy and that's that - fnuxi is required if you changed endian-ness on the processor, not OS. Why not just make the UV box export a SQL interface? Point out the fact th

[U2] RE: Basic SORT() Function not avail in UniVerse?

2008-07-22 Thread Anthony Youngman
Look on PickWiki - there are several sort routines there. Of course, I'd recommend the SHELL sort :-) NB - which version of UV are you using - it's long fixed but there's a nasty bug in the COMPARE function in 9.6. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL P

RE: [U2] [uv] Secure Sockets / SSL

2008-07-23 Thread Anthony Youngman
SSL direct from UV, or SSL direct from the UV server ... If they're sending it to their internal mailserver, which is configured to require SSL, or they don't have an internal mailserver and must use SSL to talk out ... I got the impression they wanted the CLIENT software to talk SSL, Postfix a

RE: [U2] Data Editor

2008-07-29 Thread Anthony Youngman
The obvious place is for a vendor to add a page to PickWiki, and then any other vendors add themselves to that ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: 29 July 2008 00:36 To: u2-users@listserver.u2ug.org Subje

[U2] RE: Universe ODC field association

2008-07-29 Thread Anthony Youngman
What help exactly do you need? Make sure that the @ID is listed in @SELECT or whereever (I try to always list it as the very first field). That way, you can simply JOIN the single-value table to the ASSOCiated table. And have you seen the article on PickWiki? It's a bit out-of-date but still us

RE: [U2] Linux Psuedo Directory

2008-08-04 Thread Anthony Youngman
Man chroot Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Results Sent: 04 August 2008 14:59 To: u2-users@listserver.u2ug.org Subject: [U2] Linux Psuedo Directory All, I'm going blank on this one, all help appreciated. I want to create a

RE: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch

2008-08-04 Thread Anthony Youngman
Don't know about UD, but on UV you can switch on logging that will list all the commands passed to UV. Only problem is, to describe it as verbose is an understatement ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 04 Au

RE: [U2] uniobjects help needed!

2008-08-06 Thread Anthony Youngman
I've looked up the notes on our error and found the following The object invoked has disconnected from its clients (-2147417848) I don't know where that came from but it's the same error that you've got, and I guess we found that somewhere in some documentation on OLE or whatever. So what is ha

[U2] SELECT problem with quote characters

2008-08-06 Thread Anthony Youngman
I'm trying to select a string that contains a single-quote, using the LIKE operator. It works fine with EQ. So if I do a " SELECT FILE WITH FIELD EQ "LLOYD'S" ", the select returns exactly what I expect. But if I do a " SELECT FILE WITH FIELD LIKE ..."LLOYD'S"... " it returns pretty much the enti

RE: [U2] Why Buy (or develop in) UniVerse?

2008-08-13 Thread Anthony Youngman
Relational theory requires you to abstract the database to fit a (badly flawed) prescriptive theory of what data *should* be like. MV simply models the database to look like the real world. Relational scatters the data about individual real-world items across multiple tables. MV (properly desig

[U2] RE: TCL literal select

2008-08-13 Thread Anthony Youngman
Rather than writing a simple program ... SELECT PARTS WITH EVAL "DCOUNT(F1, '"') GT 0" Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 12 August 2008 21:59 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal

[U2] RE: TCL literal select

2008-08-13 Thread Anthony Youngman
Ooops ... COUNT, not DCOUNT Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 13 August 2008 12:01 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Rather than writing a simple program .

RE: [U2] Dynamic Array oddity very useful

2008-08-19 Thread Anthony Youngman
I think you're muddling dynamic and dimensioned arrays - a dynamic array can't have an element 0 :-) Sounds like somebody, when writing jBase, saw the "feature" of <-1> and thought they'd be clever with <0>. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTE

RE: [U2] What Next?

2008-08-20 Thread Anthony Youngman
Going down the linux route ... IBM support RedHat, so look at RHEL or CentOS. My choice would be Slackware or gentoo - not because they're better or worse distros, but because you learn a lot more dealing with their oddities. Slack is very BSD-oriented (or was), but is also very minimalist in i

RE: [U2] RE: U2UG Board Meeting

2008-08-29 Thread Anthony Youngman
Yes, that would be nice BUT! Ordinary members would be observers, and that's quite difficult to enforce on a conference call. What would be best if the call could be streamed so that anyone could listen in, but (unless it's changed) the calls are courtesy of IBM on IBM's equipment, and I don't

RE: [U2] Updating UV/UD PE

2008-08-29 Thread Anthony Youngman
IBM are doing you a favour letting you have PE (yes, I know it's in their interests too :-) One of the conditions of letting you have it is that you stay bleeding edge. The way they enforce that (and also keep track of who's using PE) is to date-bomb the PE version. So re-installing won't work.

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Anthony Youngman
I looked at that SQL and thought "what's wrong with double quotes?" (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the dou

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Anthony Youngman
ASSOC MY_SELECTED_TABLE It does conform to SQL... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 4:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData I looked

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Anthony Youngman
] Crystal Reports and UniData Usually, the AS keyword is in use... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 10:18 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal R

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

2008-09-18 Thread Anthony Youngman
Which *ix? A philosophy (which I tend heartily to agree with) is "if it ain't broke, don't fix it". Unfortunately, that also often leads to vendors saying "it works for everyone else, why do you need it changed?". Wonder what the limit is on RHEL? That's an *ux rather than an *ix so it *should*

[U2] RE: Universe Lock Error

2008-09-18 Thread Anthony Youngman
Closing a file apparently releases all the locks. There's an implied close in read_prog, therefore the lock gets released. To fix it, you need to remove the OPEN in read_prog, either by opening the file in COMMON or passing the file pointer as an argument. Yup, I agree that behaviour *might* be

RE: [U2] Wintegrate Query Builder

2008-09-18 Thread Anthony Youngman
Bear in mind that ODBC is relational is set-oriented. There is NO CONCEPT WHATSOEVER of "order" in sets, therefore if stuff comes out correctly ordered it *must* *be*, *by* *definition*, down to pure chance (or an accident of implementation). If you want to guarantee it, you need to add an extr

RE: [U2] [UD] Crystal Reports and UniData

2008-09-19 Thread Anthony Youngman
There is, unfortunately, a question of "market power" here. If Access and SQL-Server talk to each other, even if they use a *broken* version of SQL to do so, the market place will expect other databases and clients to talk the same - BROKEN - dialect of SQL. It's all very well a vendor (like IB

RE: [U2] Updating UV/UD PE

2008-09-30 Thread Anthony Youngman
Point 6 ... I know you think that c:\ibm is nasty, but be aware that (I think it's UV itself) does NOT like spaces in pathnames. I always accept the defaults, I've had some weird problems installing in Program Files, the space means various services fail to start. Cheers, Wol -Original Me

RE: [U2] Updating UV/UD PE

2008-10-03 Thread Anthony Youngman
Mind you, AS ALWAYS :-), they were only coping someone else! Ever wondered why "\" is the path delimiter in Windows? Because when Gary Kildall wrote CP/M he used "/" as a valid character in a file name... (Okay, Unix wasn't so ubiquitous in those days.) Cheers, Wol -Original Message- F

RE: [U2] Universe Triggers

2008-10-15 Thread Anthony Youngman
But IF you can update VOC, you CAN bypass remote voc, which is what David said! As part of your security you need to make sure that users CAN'T update VOC (which is rather harder than it seems at first glance). Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTEC

RE: [U2] UniVerse and/or AIX caching

2008-10-23 Thread Anthony Youngman
It's probably AIX that's doing the caching. If it's like linux, there's no way to tell it - it will just aggressively cache everything until it runs out of spare RAM. Question is, why do you want these files in RAM? UV is very fast at retrieving from disk so what's the reason? And it sounds li

[U2] RE: Triggers on a NFS file?

2008-10-24 Thread Anthony Youngman
Owww Firstly I doubt the trigger on one system will spot changes made by the other system. But, rather more seriously, we have had UV file corruption which was laid pretty conclusively down to two systems accessing the same dynamic file - oh and one of them, allegedly, only had read access

RE: [U2] Normal SELECT behavior? [UD]

2008-11-04 Thread Anthony Youngman
Unfortunately, it's obviously doing a numeric equality (which I believe is the default if it can). What happens if you add "AND F1 MATCHES 6N"? Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A. Green Sent: 04 November 2008 03:10 To: u

RE: [U2] Create file on remote account

2008-11-12 Thread Anthony Youngman
Is this the DIRECTORY keyword? (Be careful, in PI this meant create a type 1 file, so it might be a bit temperamental to get working.) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: 12 November 2008 16:07 To: u2-users@listse

RE: [U2] UV 10.2 catdir problems

2008-11-13 Thread Anthony Youngman
Looking at this, a couple of ideas ... Is UV supported on SuSE? Last I knew (probably out of date :-) it was only supported on RHEL. Catdir looks to be a type 1 file - can you change it to a type 19? What are/were the permissions on the *client*SCRNHD directory? Do you only get this problem wh

RE: [U2] SELECT-READNEXT That's odd

2008-11-17 Thread Anthony Youngman
The other problem with counting backwards is if you've got a lot of fields. BASIC has optimisations for scanning forward through a list. I don't think it scans backwards very well. Go backwards and the result is not likely to be pretty. The only time I normally go backwards is when I have a hab

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Anthony Youngman
If you're going to do it that way, I wouldn't bother with putting the @VMs back (or may the @SM's too, depending on what you're doing. Get CUST.NUM and CUST.DESC from your modified IN.LINE as follows ... CUST.NUM = FIELD( IN.LINE, CHAR(9), 1, 1) CUST.DESC = FIELD( IN.LINE, CHAR(9), 1, 1) Cheers

RE: [U2] Counting records

2008-11-19 Thread Anthony Youngman
Several things look a bit wonky to me here. Firstly I'd get rid of the first three lines with CMD = "COUNT ":FILENAME Then the routine as shown here leaves a hanging select list - NOT a good idea when the next person comes along and doesn't realise it. I've never used it, but isn't there a form

RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Anthony Youngman
Which version of UV? Triggers have only recently worked on UV files. They used to only work on SQL-ized files. If you're not using SQL and haven't upgraded recently you may be on a version that's too old to support them. (And is HTTEST a type 1/19? No triggers on them ...) Cheers, Wol -O

RE: [U2] Universe triggers + SB+$ OPTIONS PICK

2008-11-26 Thread Anthony Youngman
Does the common contain dimensioned arrays? Quite likely, I would have thought. And that would be why you need OPTIONS PICK. Ideal-flavour UV uses PI-style arrays which have an element (0). Pick-style arrays don't. I think there may also be something to do with how many entries in the common tab

RE: [U2] UniData ODBC and Vista

2008-12-04 Thread Anthony Youngman
I asked IBM a similar question ... The client tools are certified at the same level as the server, so if the server is certified to run on Vista, so will the tools. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 04 Decembe

RE: [U2] test - no email since 12-05

2008-12-10 Thread Anthony Youngman
Nothing since the twelfth of May!?!? Mind you, it has been a bit quiet these last few days :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson Sent: 10 December 2008 12:48 To: u2-users@listserver.u2ug.org Subject: [U2] test -

RE: [U2] UV - broken file issue [not-secure]

2008-12-19 Thread Anthony Youngman
The 20-somethings probably do WORSE than us. For most of them, if they haven't got a wizard to do it for them, they can't do it. They don't actually UNDERSTAND what they're doing most of the time. (I hope I'm not maligning them, but I often feel, when trying to help users, that "tech support" i

RE: [U2] [UV] Requirements for UO.NET connection?

2009-01-14 Thread Anthony Youngman
If you're on Windows it *shouldn't* (famous last words) make any difference. I never worry about correct case (though I do try and keep it the same as what Windows says...). Windows is "case insensitive but case preserving" so the case of the pathname shouldn't make any difference whatsoever. I

RE: [U2] checking if a passed in file pointer is valid?

2009-01-14 Thread Anthony Youngman
You'll have to check the functions that return file information about a file pointer. I'm sure there's some way of doing it. It would be nice if IBM could fix that - it always used to work in INFOBASIC, you would have thought that a logic test could at least return true/false instead of crashin

RE: [U2] [UV] Requirements for UO.NET connection?

2009-01-15 Thread Anthony Youngman
The VOC doesn't need to be small (ever since my PI days, I've always had VOC as dynamic when it's been up to me), but files don't hash very well if they have a large standard deviation in record size. VOC contains a lot of very small records, so if you add a lot of very large records (Paragraphs

RE: [U2] Moving a UniVerse a/c from Unix to Windows

2009-01-27 Thread Anthony Youngman
There's an easier SELECT than that SELECT VOC WITH TYPE EQ 'F' TYPE is a predefined i-descriptor in DICT VOC. Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jef Lee Sent: 27 January 2009 07:48 To: u2-user

RE: [U2] UV, Linux, and Active Directory

2009-01-28 Thread Anthony Youngman
To authenticate linux against Active Directory, look into PAM (pluggable authentication modules). Just be careful - if you break PAM and don't have a backup, you then can't log in to your linux box! I can't give any advice about PAM, my only attempt to use it failed, but I know that's how you'

RE: [U2][UD] Index for @ID (IBM documentation)

2009-01-30 Thread Anthony Youngman
If I indexed @ID, I would always include nulls in the index. Two reasons: 1) There should never be a null @ID 2) The reason you shouldn't index nulls is because you may have many records with a null value, so you will end up with a huge record in your index. Bad... But with @ID you'll only have

RE: [U2] UniData LIMITs

2009-01-30 Thread Anthony Youngman
My idea would be to: Create a field in the CLIENT file that contains a list of all users that can see that client. Create an i-descriptor in the file that you're reporting on that pulls that field across. Use a WHEN or WITH (can never remember which) to only pick records where that user's id

[U2] Replication troubles ...

2009-01-30 Thread Anthony Youngman
And the docu says absolutely nothing about troubleshooting :( I'm experimenting with replication - trying to set up a hot-standby scenario. So I've gone to my primary, enabled replication, and published the account I'm interested in. Fine, it comes up as everything (about 53 files) published. Go

RE: [U2] converting universe files between aix/linux

2009-02-04 Thread Anthony Youngman
Everybody's been jumping in saying what the tool is. What they haven't said is "do you need it" because it has ABSOLUTELY NOTHING to do with a port from AIX to linux, and everything to do with the hardware. I presume you're going from RS/6000 (or similar) to Intel? In that case you do need the

[U2] UDR initialisation failed

2009-02-05 Thread Anthony Youngman
Replication is giving me grief ... I've found the programs in APP.PROGS (which seem so much more usable than UvAdmin :) bit I'm getting nowhere. Looking at the files in the UV account it seems okay but I'm not at all sure. I *think* it's all configured "about right", but I'm getting "UDR initializ

[U2] RE: UDR initialisation failed

2009-02-05 Thread Anthony Youngman
inistrator Program "*vmadmsub": pc = 94a0, Message[02] This lot is in our errlog, *vmadmsub looks suspiciously like a system routine, and message 02 is "Bad file descriptor" Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-u

RE: [U2] Users of UniVerse

2007-04-27 Thread Anthony Youngman
Have William Hill dropped UniVerse now? They used it as the back end to their on-line betting, I believe. If they're still using it, they're a good site to quote as they are one of the big UK bookmakers. Cheers, Wol -Original Message- From: Charles Barouch [mailto:[EMAIL PROTECTED] Sent

RE: [U2] Users of UniVerse

2007-04-27 Thread Anthony Youngman
Reynolds & Reynolds? Look on the u2ug web site - you might find the story there. They spent MILLIONS converting their product to SQL-Server, and the SQL version floated about as well as a lead balloon. They ended up scrapping it. Cheers, Wol -Original Message- From: Mark Eastwood [mailto

RE: [U2] What's My IP Address ?

2007-05-03 Thread Anthony Youngman
wIntegrate certainly has this. We had a mix of Wyse50s, the odd PT250, and wIntegrate configured as a PT250. As the user logged in, LOGIN printed "esc " to the screen (at least, I think that's what it was) and read the response. That way, we (usually) didn't have users asking us "is this a Wyse or

RE: [U2] wintegrate 6.0

2007-05-08 Thread Anthony Youngman
When you installed your previous version of wIntegrate, did someone customise it for you? I don't remember it as being able to handle a 80/132 switch - on our system I had to code the switching escape sequences into pt250.wis myself, and I also had to edit the PTERM code so it used those sequences

RE: [U2] Incubator - News from the board

2007-05-10 Thread Anthony Youngman
I'm trying to get a working Gentoo at home. That's a game and a half :-) When I succeed I'll likely try and create an ebuild to install UVPE. Be nice to get that officially into portage :-) (I want to get a WordPerfect 8 ebuild working, too :-) Cheers, Wol -Original Message- From: Brutz

RE: [U2] A couple of questions about the PE version

2007-05-14 Thread Anthony Youngman
If it's a *nix box, just fire up a bash shell, and enter the command "uv". (That's for UniVerse, of course. YMMV for UD.) Cheers, Wol -Original Message- From: Dave Taylor [mailto:[EMAIL PROTECTED] Sent: 14 May 2007 07:14 To: u2-users@listserver.u2ug.org Subject: Re: [U2] A couple of que

RE: [U2] [UD] Union Query

2007-05-17 Thread Anthony Youngman
Well, when I read that comment about READNEXT having to return file as well as key - actually it *already* returns a lot more than just key - try doing a SELECT WHEN. I guess partfiles would be easier - the problem with partfiles (and I hit this in my last job) is that the database must be able to

RE: [U2] read secuencial a table

2007-05-18 Thread Anthony Youngman
I don't think you can just read the file sequentially ... you can't do it in BASIC, therefore you can't do it with InterCall. In BASIC you do a SELECT, then a READNEXT, then a READ. You should be able to do exactly the same with InterCall. Cheers, Wol -Original Message- From: pam [mailto

  1   2   >