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]

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

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

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

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:

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

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

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

RE: [U2] create a select list

2007-05-21 Thread Anthony Youngman
don't know how to make a selec list with the ic_execute. Thanks Pamela On 21/05/07, Anthony Youngman [EMAIL PROTECTED] wrote: Can you give a bit more detail as to what you mean I receive the data in a different way when the select statement change. A BASIC select, or a simple RETRIEVE select

RE: [U2] create a select list

2007-05-22 Thread Anthony Youngman
the data. I will investigate more but I you have any idea i will apreciate it!! Thanks again you give me a great idea. Pamela On 21/05/07, Anthony Youngman [EMAIL PROTECTED] wrote: OOWWW I don't know what to suggest here ... but I do know what's happening. You're using a SQL SELECT

[U2] RE:

2007-05-22 Thread Anthony Youngman
Sounds like you've got a big iron system :-( There's no chance you could get an old machine (or create a partition on a newer machine) and install the old version of UV? Okay, there's licencing issues but hopefully IBM shouldn't mind if all you're doing is trying to get yourself out of a hole.

RE: [U2] [BB] U2 Enhancement Request - WRITE

2007-05-24 Thread Anthony Youngman
I *think* this is historical. It used to be that ON ERROR didn't exist (I don't think ELSE existed initially!). So I guess that ELSE was added to deal with failed writes but not with file isn't there type problems, then ON ERROR was added to deal with those. I think originally, when even ELSE

RE: [U2] [BB] U2 Enhancement Request - WRITE

2007-05-29 Thread Anthony Youngman
Actually, that's not obvious at all :-) My prototype code for MaVerick's dynamic files (and no, that code is not part of Rob's MaVerick code) would never have run out on a delete. Let's say I was merging two buckets - 5 and 13 for the sake of argument. If 5 was the fullest I just reset the

RE: [U2] RedBack Garbage Collection

2007-05-30 Thread Anthony Youngman
I seem to remember a bug in garbage collection at some point. When did it last run (time of day, not date!)? There was something about it not working if the previous run was just before midnight, because all time comparisons were earlier than the last run so it couldn't calculate time since last

[U2] LONGNAMES oddity

2007-06-06 Thread Anthony Youngman
Can anybody explain this? Our upgrade replaced CREATE.FILE etc, so it started creating short file names. But ... When this was fixed by doing a LONGNAMES ON, doing a CREATE.FILE immediately afterwards still created a short file. Weird! Cheers, Wol --- u2-users mailing list

RE: [U2] Help in creating Retrieve statement for a multivalue field

2007-06-06 Thread Anthony Youngman
You can use an EVAL or an i-descriptor. For example, assuming your field is the ID, then EVAL @ID[2] will give you the year, and EVAL FIELD(@ID, '*', 4, 1) will give you the route. (or you could use field(5) for the year :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED]

RE: [U2] LONGNAMES oddity

2007-06-06 Thread Anthony Youngman
the same behavior as what you describe, so it seems to be a bug which has come into 10.2. Kurt Neumann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 06 June 2007 11:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] LONGNAMES

RE: [U2] UV telnet disconnects over WAN

2007-06-06 Thread Anthony Youngman
Probably not relevant ... I know some early Demon broadband adopters had nightmares when BT upgraded their kit. Because it wouldn't affect any subscribers they did it without informing any ISPs, with the result that when customers complained the ISPs didn't have a clue. If you were an early

RE: [U2] UD IP Address

2007-06-07 Thread Anthony Youngman
From your original post, there's nothing wrong that I can see. You and Patti are inside the local network, therefore UD is seeing your local network address. John Smith is logged in over the internet, therefore he shows up with the address assigned to his router (if he has one). His address may

RE: [U2] Time conversion code

2007-06-07 Thread Anthony Youngman
If it has been changed, it should be logged as a bug! It's QUITE NORMAL for the 24hr clock to go over 24 hours - many places work on the basis that you always start and end a shift on the same day - I believe London Underground are one. As such, a shift ending at 28.30 is normal practice ...

RE: [U2] [UV] Efficient way of determining if item is inuse

2007-06-07 Thread Anthony Youngman
How important is rapid response (and how do you define rapid? :-) I presume you've got another outer loop round this lot - if not you can create one. Get your ls command to return the file size, and save the old output. Now, each time through the inner loop, you compare filesize against the

RE: [U2] Automated Faxing

2007-06-07 Thread Anthony Youngman
From your description, it should be possible to run two instances. Just create two users, move the /etc/profile code to .profile, and have /etc/profile instantiate two daemons - one per user. I don't know the details, but if all VSI-FAX is using is environment variables, then that's just standard

RE: [U2] New UV system

2007-06-13 Thread Anthony Youngman
Why do you need uvbackup? I'm NOT recommending that you don't use it, but a while ago I had a linux box, a SCO box, and a Windows box, and quite happily copied UV files between all three of them using the OS-level copy command. Bearing in mind they all run on Intel chips, and byte order is a chip

RE: [U2] New UV system

2007-06-14 Thread Anthony Youngman
machines. Also, it gets rather tedious setting up the many VOC entries for the OS files again. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, June 13, 2007 12:05 PM

RE: Re:[U2] New UV system

2007-06-14 Thread Anthony Youngman
Your memory is faulty :-( though I would advise people to do what you suggest. We've had serial cards plugged in the back of servers and they worked fine (when they worked...). But if you have any sense, you do tend to stick a network card into a printer, or plug it into a dedicated printserver

RE: [U2] [UV] - Distributed Files

2007-06-19 Thread Anthony Youngman
Maintain it against the part files (mind you, I'd just declare them DYNAMIC and let UV sort it out). In a distributed file, each individual part file is just an ordinary file, with a little bit of extra logic that hashes the ID to say is this record permitted in this file. You can treat the

RE: [U2] UV HASH.HELP error

2007-06-20 Thread Anthony Youngman
Actually, this could be a VERY OLD feature ... :-) I seem to remember it being documented that HASH.HELP and HASH.HELP.DETAIL (or similar) had a habit of disagreeing with each other on Prime INFORMATION. Now that's going back some ... ! Anyway, the advice always was don't trust HASH.HELP. Suck

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-21 Thread Anthony Youngman
Off the top of my head - AND CHECK TO MAKE SURE... You can't create triggers (or indexes, or anything like that) on the master, because it only exists as a record in PARTFILES). But - and I'm pretty sure this is true of indices at least - if you try and create an index on the master, it will

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread Anthony Youngman
27. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On 6/21/07 Anthony Youngman wrote: You can't create triggers (or indexes, or anything

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread Anthony Youngman
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, 22 June 2007 8:30 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Trigger(s) on distributed file That's weird ... has that changed at all recently? I used to create multiple masters by hand and never did

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread Anthony Youngman
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, 22 June 2007 10:16 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Trigger(s) on distributed file Then things really are confusing ... I'm talking about the file-type

RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly

2007-06-26 Thread Anthony Youngman
What are you trying to say here? You don't make sense (sorry). Not knowing UD, I have to be careful here, but if I'm selecting BY.EXP a multi-value field, I would NOT expect the number of records selected to be the same as the number of items in the select list. I'm getting the impression that

RE: [U2] The best way to access SQLServer from UV [not-secure]

2007-06-27 Thread Anthony Youngman
Any reason you're not putting it on a secure encrypted UV server? (I believe the latest version of UV does native encryption ... :-) If it's not a 1-1 record-row match, then SQL-Server will be unlikely to match UV for speed. Cheers, Wol -Original Message- From: Jerry Banker

RE: [U2] Basic developments reverse engineering tool ?

2007-06-28 Thread Anthony Youngman
PLEASE put stuff like this on PickWiki. It's a wonderful place to put snippets, small programs, etc etc. The one thing to watch out for about a user group keeping a repository is that there's copyright issues involved. If you wrote the utility, you can put it on PickWiki, or in a repository, or

RE: [U2] Phantoms not working

2007-06-28 Thread Anthony Youngman
Not sure what you mean by checked another box, but it does sound very like a paths problem. What user is the phantom running as? What does that user's .profile contain? Could the user launching the phantom drop to the linux command line and run bin/uv? Cheers, Wol -Original Message-

RE: [U2] UD Phantom Credentials

2007-07-06 Thread Anthony Youngman
Ouch !!! I can tell you WHAT is happening. How you solve it is a policy issue, not a technical issue. Basically, drive mappings are system-wide, not user-related. If you have multiple processes/users all wanting their own unique drive mappings, sorry it's not going to happen! We had this exact

RE: [U2] Universe and virtual machines

2007-07-10 Thread Anthony Youngman
Subversion. Does this use GIT as a back-end now? The old-style version control systems pretty much only worked with one person being able to check out a file at a time. Sounds like Eugene wants a distributed version control, and there's a choice. But - AND CHECK IT OUT, I'M NOT SURE - I think

RE: [U2] Issue with installing UniVerse on Linux

2007-07-10 Thread Anthony Youngman
One other point. Have IBM fixed the problem they had with default options on cpio? I know when I installed PE on SuSE ages ago, the SuSE and RH defaults were different and I had to edit the install script. It was one of those toggle issues - where RH was on by default and the switch toggled it

RE: [U2] [UV] Conversion code for week number

2007-07-11 Thread Anthony Youngman
I know you said don't tell me it's the base date, but the date 1/1/68 was chosen for a reason - it means divide by 365.25 actually gives the right answer... Cheers, Wol -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: 11 July 2007 14:17 To:

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Anthony Youngman
Because the results are not (scientifically) reproducible. (Well, they are for that one implementation...) Because data storage is part of the Pick data model, we can be confident that benchmark results are valid across all (similar?) implementations. Because relational forbids knowing anything

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-17 Thread Anthony Youngman
are totally relevant as a comparison of those two systems. Anthony Youngman wrote: Because the results are not (scientifically) reproducible. (Well, they are for that one implementation...) Because data storage is part of the Pick data model, we can be confident that benchmark results are valid across

RE: [U2] RE: Cleaner Case Statement

2007-08-03 Thread Anthony Youngman
To really throw the cat amongst the pigeons ... :-) I recently started using the IF ... ELSE programming style precisely *because* I found it *easier* to understand! Depending on what X is, it can be a lot more comprehensible to write IF X is true ELSE Rather than IF NOT X THEN Especially if

RE: [U2] EXECUTE environment in Universe

2007-08-03 Thread Anthony Youngman
Seeing as you don't say whether you're wanting to enable PIOPEN.EXECUTE as a global option, or just in programs as you need to recompile them, it's not clear what exactly your problem is. Two things ... 1. Look at using PERFORM instead of EXECUTE. I'm not sure of the difference, but I strongly

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

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

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

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

RE: [U2] Badly overflowed Dynamic files

2007-11-29 Thread Anthony Youngman
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.u2ug.org Subject: RE: [U2] Badly overflowed

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)

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 your

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

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

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

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 forgotten

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

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

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

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

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
- 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 Not that I know much about this error

RE: [U2] UVODBC Account Activation

2008-06-26 Thread Anthony Youngman
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-users@listserver.u2ug.org

[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

[U2] RE: ODBC problems

2008-06-30 Thread Anthony Youngman
the same physical dictionary file and one works while the other one doesn't ... which implies a data problem ... cue headscratching here ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 30 June 2008 09:46 To: u2

RE: [U2] RE: ODBC problems

2008-07-01 Thread Anthony Youngman
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 wrong before it sends it, but I've got two files sharing the same

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

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

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

2008-07-18 Thread Anthony Youngman
. - Original Message - From: Anthony Youngman [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Subject: [U2] Strange SQL query optimisation ... Date: Thu, 17 Jul 2008 14:34:32 +0100 One of my colleagues brought a speed problem to me - he has two queries which

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

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

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

[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

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

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

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

[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 entire file

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

[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 ... SELECT

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 PROTECTED] On

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

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

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

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

2008-09-17 Thread Anthony Youngman
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 at that SQL

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 Reports

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*

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 extra

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

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

  1   2   >