Re: [U2] SB+ PA Compare
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, Stuartstuart.boyd...@spotless.com.au To: U2 Users Listu2-users@listserver.u2ug.org Subject: Re: [U2] SB+ PA Compare Message-ID: 7ee7790a950e094399b01520071826a20106b48d6...@sg1rd3xvs031.red003.local Content-Type: text/plain; charset=us-ascii I have uploaded the file. The way I use it; I have a trigger around dictionaries to write them to a type 19 file when they change which is used for source control. The trigger program gets the new dictionary record, removes attribute 10 and up from I-types, lowers the record then puts several bits of meta data written into the first 6 attributes followed by the dictionary record into att7 and then written to the type 19 file. Eg: write hostName:@vm:dictPath:@am:dictName:@am:dictId:@am:field(dict1,' ',1):@am:system(99):@am:system(19):@am:lower(dictRecord) on Type19File,SourceControlKey The key is an MD5 digest of the dictionary path and id for the key (it's relatively short, unique, char safe) but you could use anything you like to make it easy to compare items across systems or accounts. The formatter script puts them into a format for easy comparison in BC. http://www.pickwiki.com/cgi-bin/wiki.pl?Beyond_Compare Hope that's helpful, Stuart This is very helpful. I am thinking of maybe a control record per dict item record type to classify the relations between say the FD and .FD or the SD, SD.GUI and SD.TXT. That control record would specify which attributes to export out in the lowered record. This could be extended to RD's, Conditional's, Dialog's. All of the SB+ types. Maybe instead of a trigger, put a wrapper around (or in) FD, AE, etc. Stuart, what vcs do you use? I have been looking strongly at Hg, but the distributed model looks liek an ill fit when the code must be run in an ERP environment. Its not like each dev can have their own TEST account. Might be nice, but it is not reasonable. I'm not a mercurial user - I'm learning git, but what's wrong with a DVCS? Yes it would be nice if each dev could have their own account, but you're assuming one dev per DVCS instance. Why not one account per DVCS instance? But by not giving each dev their own account, you're throwing all the advantages of ANY version control system! Whether it's Mercurial, git, SCCS, CVS, Visual Source Safe, as soon as you have devs fighting over access to the source you're giving yourself a headache. Centralised system, distributed system, it's all the same. Let me give you an example method of working with git, several devs, one test environment. Pretty safe bet you can translate this into Mercurial terms easy enough. Each dev has their own test account, probably can't do an awful lot there, but they do all their coding, compiling, and basic unit testing in their own account. They can then push their changes to a branch in the central test account to test them. When they're happy, they can merge them into the main branch. If several devs are fighting over the central test account, the fact that git allows very rapid changes between branches means that one can have it for however long it takes, then revert his changes leaving it clean for the next one, so you can switch the test account rapidly. And more importantly, dev A *can't* step all over My experience of cvs's commercially was either none (for UV, had to track everything manually), or VSS for VB where it was a right pain when I had something checked out for dev work and somebody else needed it for a quick bugfix, or vice versa. Thing is, you can put procedures in place so that a DVCS has strict central control. You can't set up a centralised VCS to give several developers flexibility to work on the same code at the same time. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UDR initialisation failed
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 initialization failed with a return value of -2. In the logs. Any ideas anyone? Also when I ran REPSUBLIST I got the error Unable to read record from file UV in account AWY, STATUS() is 0. That's a double-space after record by the way, so it was trying to read a null key from a non-existent file (I couldn't find any file called UV, not in the account I was replicating from, to, or in the UV account). What's that about? I'm not making much headway. And the documentation just seems to assume that everything will work fine - it doesn't even *mention* troubleshooting as far as I can see, just says if it doesn't work, once you've fixed the problem ... and assumes it's a dodgy file you're trying to replicate. I've just created two clean accounts to try and get things working between them ... Any help/ideas gratefully received. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: UDR initialisation failed
Following up to myself, could the following have any bearing on the matter? Wed Feb 04 12:02:31 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:31 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:53 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:53 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:53 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:53 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:09:18 -2761 PROG1\Administrator Program *vmadmsub: pc = b4f2, Message[02] Wed Feb 04 12:09:18 -2761 PROG1\Administrator Program *vmadmsub: pc = b4f2, Message[02] Wed Feb 04 12:09:20 -2761 PROG1\Administrator Program *vmadmsub: pc = b4f2, Message[02] Wed Feb 04 12:09:20 -2761 PROG1\Administrator Program *vmadmsub: pc = b4f2, Message[02] Wed Feb 04 12:09:20 -2761 PROG1\Administrator Program *vmadmsub: pc = 94a0, Message[02] Wed Feb 04 12:09:20 -2761 PROG1\Administrator Program *vmadmsub: pc = 94a0, Message[02] Wed Feb 04 12:09:21 -2761 PROG1\Administrator Program *vmadmsub: pc = 94a0, Message[02] Wed Feb 04 12:09:21 -2761 PROG1\Administrator 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-us...@listserver.u2ug.org] On Behalf Of Anthony Youngman Sent: 05 February 2009 13:24 To: u2-users@listserver.u2ug.org Subject: [U2] UDR initialisation failed 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 initialization failed with a return value of -2. In the logs. Any ideas anyone? Also when I ran REPSUBLIST I got the error Unable to read record from file UV in account AWY, STATUS() is 0. That's a double-space after record by the way, so it was trying to read a null key from a non-existent file (I couldn't find any file called UV, not in the account I was replicating from, to, or in the UV account). What's that about? I'm not making much headway. And the documentation just seems to assume that everything will work fine - it doesn't even *mention* troubleshooting as far as I can see, just says if it doesn't work, once you've fixed the problem ... and assumes it's a dodgy file you're trying to replicate. I've just created two clean accounts to try and get things working between them ... Any help/ideas gratefully received. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] converting universe files between aix/linux
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 tool, but forget about the O/S, check (as I are think you are doing) the endian-ness of the processor. That's all that's relevant. If you were running AIX and linux on the same hardware you (probably) wouldn't need it (you can get hardware which is soft-switchable between big and little endian :-). Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of doug chanco Sent: 03 February 2009 16:45 To: u2-users@listserver.u2ug.org Subject: [U2] converting universe files between aix/linux hey all, I am attempting to make a QA virtual universe system and I think I am going to have a big Indian/little Indian issue (when moving the databases from aiz to linux), I seem recall that there was some tool available to convert the databases but for the life of me I cannot remember what its called. Also if anyone has any tools they already developed to do this and would be willing to share I would greatly appreciate it as well as any gotchas you may have run across doing such a conversion thanks dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] Index for @ID (IBM documentation)
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 one value so the argument against indexing nulls is invalid. Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: 30 January 2009 10:27 To: u2-users@listserver.u2ug.org Subject: Re: [U2][UD] Index for @ID (IBM documentation) Hi, Martin, are you sure? I would expect the query optimizer to see the = and cancel the use of the index. Unless I mis-typed my posting (I didn't keep it), it is fine because the overall condition is not satisfied by a null item. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData LIMITs
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 appears in that field. (Or create a subroutine which returns an allow or deny field and only select allowed records.) Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of David A. Green Sent: 30 January 2009 12:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData LIMITs Bill, I would create a CLIENT Type field that you can lump the CLIENTS together and use the Type field for your selections. Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, January 29, 2009 12:44 PM To: U2 Mail List Subject: [U2] UniData LIMITs We have a report writer that allows users to select the client they want to print any report for. This subroutine builds a list of clients available to any particular user and uses this list to either compare against the clients entered or of all clients are selected then the entire list is used. When this list is placed in an ECL query and executed, e.g SELECT CUSTOMERS WITH CLIENTNO = 1234. ...all has been fine for years. We picked up a new customer who has over 300 clients. When a user tries to run a report for all clients accessible by them the query aborts with... WITH condition stack overflow A quick look at LIMIT shows: :LIMIT U_MAXFNAME: File name limit = 198. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = NT Spooler. U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256 ...which indicates there's a limit of data allowed in the WITH clause(s) of 256. The UniData documentation says these parameters are __NOT__ configurable. How in the world are other people overcoming this limitation? Doesn't anyone want data for more than 256 somethings? Is it possible for me to overcome this limitation without going into 1,000 programs to split large numbers of ECL queries? Or am I forced to count the somethings available to submit to any query and abort if its more than 250? Am I forced to split up A/P check runs (and many other processes) into two or more runs to accommodate this limitation? Any experience, or thoughts, on this will be appreciated. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Replication troubles ...
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 to the standby, try to subscribe. It only finds two files published by the primary! If I go to the primary and LIST UV_UDRPUB, files 1 and 2 are the ones the secondary can see. So I go and check that files 2 and 3 both seem okay on the primary - they do. They list fine, so both the data and dict portions seem okay. Where do I go from here? Why does the primary claim they're published, and the secondary can't see them? All ideas gratefully received ... Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV, Linux, and Active Directory
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 supposed to do it. Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Norman Bauer Sent: 28 January 2009 00:25 To: u2-users@listserver.u2ug.org Subject: [U2] UV, Linux, and Active Directory I am still learning UV, it's been a long three months of learning, but I have to say that I really do like it. That being said, we run it on Windows Server 2003. We recently tried to deploy it on Server 2008 which IBM says is possible in the docs. However it will not run on Server 2008. My suggestion to my boss was to try running it on CentOS 5, when I was promptly rebuked for the idea. I was told that if we were to do that our UV accounts could not authenticate against Active Directory. And that may be somewhat tue given that our authentication module was custom written. How are you authenticating against AD on Linux? I would be very interested in knowing, because I would love to move us off of UV for Windows and run it on Linux because there is so much that I personaly know that I can do running it on Linux that it takes major hoops to pull of on Windows but is realatively trivial on Linux, like PDF printing, Python scripting, Postgresql integration, Apache tricks, etc;. Thanks, Norm --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Moving a UniVerse a/c from Unix to Windows
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-users@listserver.u2ug.org Cc: Steven Tilden; John Steer; Glenn Cameron; Glenn Summerfield Subject: RE: [U2] Moving a UniVerse a/c from Unix to Windows Dave this may not be letter-accurate but from memory it's like VOC has MYVERYLONGFILENAME 0001 F 0002 MYVERYLONGFILENAME 0003 D_MYVERYLONGFILENAME But on the Unix filesystem it's .../MYVERYLONGFIL/ENAME Where the long UniVerse name is turned into a folder + file combination for Unix's sake. The backup did nothing more than follow what was there. We have just been told why the indices failed: they were disabled. The backup/restore process disabled them to minimize process time. We didn't know that (UniVerse for Dummies definitely needed here). A BUILD.INDEX works when they're disabled but automatic updating when the record is updated does not work. So next time it will be: Everybody! Get off the system! SSELECT VOC WITH F1=F OR F1=F ] ENABLE.INDEX OK everybody it's ready to use! Jef. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: Tuesday, 27 January 2009 3:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Moving a UniVerse a/c from Unix to Windows Jeff, The indices may still be failing because they are still too long. Were the long names broken in the Unix system during backup or were they broken in the Windows system upon restore? Have you set LONGNAMES ON in the Pick-flavor account? eg: WHO 5232 uvnt.spooler From W2KAPPSERVER\UV LONGNAMES ON Your 'VOC' has been modified to use long file names. ED VOC LONGNAMES 3 lines long. : P 0001: R 0002: UNIVERSE.VOCLIB 0003: LONGNAMES Bottom at line 3. : EX If the longnames are breaking up on Type 1 files, RESIZE them to Type 19 files. hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Jef Lee jef@itvision.com.au To: u2-users@listserver.u2ug.org Cc: Steven Tilden steven.til...@itvision.com.au; John Steer john.st...@itvision.com.au; Glenn Summerfield glenn.summerfi...@itvision.com.au; Glenn Cameron glenn.came...@itvision.com.au Sent: Monday, January 26, 2009 9:31 PM Subject: [U2] Moving a UniVerse a/c from Unix to Windows Does anyone have the magic bullet? We have a UniVerse account that was backed up using uvbackup on an AIX platform. We restored the account on to a Windows platform and the sky fell in. Firstly there was the 13 (14?) character naming boundary. File names record names that were longer than this boundary were broken in the Unix system into acceptable chunks. I think this protocol dates back decades (centuries?chuckle). Well so far with much fiddling and leg work we have gotten passed that. Now the indices on files are failing to maintain their integrity. This is what happens: 1. Look for a record using a keyed search and it was not found 2. Rebuild the indices using BUILD.INDEX 3. Repeat #1 and the record was found 4. Add or edit a record affecting a keyed field and the indices return to #1. What's the answer? Do we need to change the way we physically port the account? Is there a tool that will resolve the problem? Should we create a new empty account and copy all the records into it, then build the indices? All thoughts and guidance appreciated. Our UniVerse is: CT VOC RELLEVEL RELLEVEL 0001 X 0002 10.1.11 0003 PICK 0004 PICK.FORMAT 0005 10.1.11 Thanks, Jeffrey Lee Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000F: (08) 9315 7088 W: http://www.itvision.com.au ___ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list
RE: [U2] [UV] Requirements for UO.NET connection?
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 etc) the result will almost certainly be a file that is a nightmare to hash properly. For VOC, that can be quite a performance hit ... Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bob Wyatt Sent: 14 January 2009 20:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Requirements for UO.NET connection? Anthony/Tony, There are 5 files and 1 directory required that identify a UniVerse account (perhaps for UO.net purposes), or so I am told... And this information may be 10.2 specific... D_VOC VOC D_VOCLIB VOCLIB D_SAVEDLISTS SAVEDLISTS Tony, although you wrote ...moving directories for easier housekeeping..., I think you meant dictionaries. VOCLIB is home to large VOC records or paragraphs, such as most of the LIST-type paragraphs... You could also place restricted verbs, paragraphs, etc. in VOCLIB... The intent is to keep the items in VOC as small as possible for efficiency and performance purposes... Or so the documentation leads one (well, okay, me) to conclude... Bob Wyatt Ashwood Computer, Inc. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: Wednesday, January 14, 2009 2:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Requirements for UO.NET connection? In message 2853-61...@sneakemail.com, Tony G 1tlx6h...@sneakemail.com writes Thanks Wol - I've been informed that the issue was due to someone moving directories for easier housekeeping. For some reason D_VOCLIB and VOCLIB (data dir) physically need to be under the root path of the account. It's not enough that the pointers point to the right location. That precludes certain types of creative administration. Oh well. Issue resolved. Ummm That's a useful thing to know! I know that the physical presence of VOC defines the account, and I thought that VOCLIB was an optional file. Why should an optional file have to reside in the actual directory when any other file can exist anywhere? Was the VOCLIB pointer a q-pointer or an f-pointer with absolute paths? Thanks to all for your time. T That's fine. Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3766 (20090114) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 3766 (20090114) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Requirements for UO.NET connection?
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. If you were using the account name then case probably DOES make a difference because UV (like Unix) is case-sensitive. Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G Sent: 14 January 2009 08:58 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Requirements for UO.NET connection? We've been using the full path, not relying on the link from UV.ACCOUNTS. Nice try, thanks bud. Now that you mention it though, I do want to verify that the casing of the path name is all UC. Telnet may forgive mixed casing where UO may not... Hopefully IBM Support will have a solution soon. T From: Symeon Breen Hi Tony, Just a shot in the dark - for the account are you using the full path or just the account name - if just the name then it needs to be entered in a special file somewhere - i can't remember where on uv ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] checking if a passed in file pointer is valid?
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 crashing even when fed a file pointer ... Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of doug chanco Sent: 14 January 2009 14:48 To: u2-users@listserver.u2ug.org Subject: [U2] checking if a passed in file pointer is valid? is there a way (universe 10.2.x/aix) to tell if a file pointer passed into a subroutine as a parameter is valid? I somehow forgot that doing the following won't work when the pointer is valid. IF pointer name NE '' THEN any suggestion/thoughts/ideas welcomed thanks! dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - broken file issue [not-secure]
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 is often tech hindrance. The user *may* be an idiot, but if you actually try to look at it from their point of view, what they're trying to do usually makes sense. And the amount of support that is useless because they WON'T look at the problem through the user's eyes ... :-( Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 19 December 2008 16:12 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV - broken file issue [not-secure] Mark: You'll notice that the 20-somethings who work in IT __DON'T__ do any better than the rest of us. Their work performance is as bad as anyone's who doesn't pay attention to their work. :-) Bill __ Hennessey, Mark F. wrote on 12/19/2008 6:09 AM: That'll teach me to compose and e-mail while talking on the phone and checking a text message on my G1... I don't know how the 20-somethings do it... I should have included that ulimit is in fact unlimited. IBM sent us a later version (March 2008) of fixtool. It reported the same error. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Ken Wallis Sent: Thursday, December 18, 2008 6:30 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - broken file issue [not-secure] Have you checked what your ulimit is set to currently? -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: Friday, 19 December 2008 7:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV - broken file issue [not-secure] I have a broken file - likely due to the fact that DATA.30 is over 2 gigs. fixtool falls over, complaining that 'Data file size is over ulimit,. I believe I have used fixtool on files over the 2gb limit before, and gotten the file in good enough shape to copy to a 64 bit file. However that was on 10.0.8, we're now on 10.2.2. Does anyone know if the ulimit reference is a red herring? Is fixtool simply not giving me the love because DATA.30 is over 2gb? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] test - no email since 12-05
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 - no email since 12-05 Please disregard --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe triggers + SB+$ OPTIONS PICK
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 table are taken up by an array. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: 26 November 2008 12:47 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe triggers + SB+$ OPTIONS PICK Hi, About $OPTIONS PICK, Yes it is important - to fix, we put it into the DMSKELCODE COMMON record ; on the first line - before COMMON statement. SB+ is PICK flavor compiled . On certain site, we have SB+ running under INFORMATION flavor account (backward compatibility of old application mixed with SB+ UI. To be in ad equation with SB+, the new basic code must be (force) compiled under PICK FLAVOR. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Susan Joslyn Envoyi : mercredi 26 novembre 2008 11:26 @ : u2-users@listserver.u2ug.org Objet : RE: [U2] Universe triggers + SB+ Manu, You are a life-saver! Thank you! I didn't know about $OPTIONS PICK and that truly solves the problem!snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on PICK flavor of UV
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire Sent: 20 November 2008 15:59 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers on PICK flavor of UV Tom, Yes they are, we use them in our Pick UniVerse system. Mike Michael Dallaire Senior Applications Developer IBM Certified Solutions Expert Mortgage Builder Software, Inc. [EMAIL PROTECTED] Main: 800.850.8060 ext. 103 Fax:248.304.0601 www.mortgagebuilder.com Help Desk198 Confidentiality Notice This transmission may contain confidential information which is intended for the exclusive use of the intended recipient. Any disclosure, copying, distribution or use of the contents by anyone other than the intended recipient is strictly prohibited. If received in error, please reply to the sender immediately -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, November 20, 2008 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on PICK flavor of UV Does anyone know if Triggers are supported under the PICK flavor of UniVerse. CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT; Statement triggers are not supported. If they are not, does anyone know a cleaver way around it other than writing your own? Thanks in advance Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Counting records
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 of EXECUTE that will return the select list as a variable? I'd use that to mop up the select list. Then I'd do RCNT = @SELECTED (iirc there is such an @ variable) Failing any of those, after the execute, I'd do a READLIST to mop up the select list, followed by a RCNT = DCOUNT( variable, @FM) to get the count. Oh - and I'd return RCNT in the first argument. Makes it a lot more flexible - you can declare it as a function, call it from SUBR in i-descriptors, whatever whatever. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma Sent: 19 November 2008 14:05 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Counting records I have written the following subroutine to count files: SUBROUTINE HUB.COUNT.FILE (FILENAME,RCNT) CMD = 'COUNT' CMD-1 = FILENAME SWAP @AM WITH IN CMD CALL SB.DISP(9,CMD) EXECUTE CMD CAPTURING MSG RETURNING ERR RCNT = ERR2,2 IF RCNT = THEN RCNT = ERR1,2 END RETURN END David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Wednesday, November 19, 2008 8:34 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Counting records In udt there is a system function after you have done a select, system(11). E.g. EXECUTE SELECT file ; NUM.OF.RECORDS = SYSTEM(11) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of T Stokes Sent: 18 November 2008 22:59 To: u2-users@listserver.u2ug.org Subject: [U2] Counting records I am trying to remember a Universe function that returns the number of records in a file. Something like this. OPEN 'SOMEFILE' TO SOMEFILE ELSE STOP 201,SOMEFILE NUM.OF.RECORDS = UNKNOWNFUNCTION(SOMEFILE) -- View this message in context: http://www.nabble.com/Counting-records-tp20569376p20569376.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.3/1786 - Release Date: 17/11/2008 17:24 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Speeding up processing through large dynamic table
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, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma Sent: 17 November 2008 20:19 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table That is what I was afraid of. Okay. So after listening to all of your comments (thus far since there is an annoying delay in these messages), here is what I like the best: SWAP CHAR(9) WITH IN IN.TAB SWAP CHAR(10) WITH IN IN.TAB SWAP @VM WITH CHAR(9) IN IN.TAB SWAP @SM WITH CHAR(10) IN IN.TAB REPEAT REMOVE IN.LINE FROM IN.TAB SETTING MARK SWAP CHAR(9) WITH @VM IN IN.LINE SWAP CHAR(10) WITH @SM IN IN.LINE (do my thing with IN.LINE) UNTIL MARK DO REPEAT Any objections, concerns or better suggestions for using CHAR(10) as the temporary substitute for the @SM? I just picked it because it came right after CHAR(9) on my handy-dandy ASCII chart! Been using it since the 70's. Some things just never go out of style! David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, November 17, 2008 2:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table If you don't want to 'swap' all the other markers with 'strings' (SWAP @VM WITH VM IN RECORD) then you have to 'build' the line item up -- keep removing until you see the remove hit the @AM and then process the line... DW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma Sent: Monday, November 17, 2008 1:24 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table Oh my goodness! This is incredible. Okay, now I have a mixture of @VM and @AM in the table. The REMOVE 'stops' at every @VM and @AM. I only want it to 'stop' at @AMs. How do I do that? David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SELECT-READNEXT That's odd
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 habit of deleting the
value I'm working on, and need to know I've processed every value.
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: 15 November 2008 03:52
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT-READNEXT That's odd
I would have to challenge the concept of putting the DCOUNT as the first
value and counting backwards.
99% of the time FOR..NEXT loops start at 1 and go to some end. We assume
that there's a test for surpassing the second variable at each iteration of
FOR. But is the first variable touched only once and not again.
If it's touched for each iteration, then DCOUNT anywhere is excessive. If it
is only the first pass and only when working backwards, then it's too
awkward and the more readable code would be to assign it and not have it
derived per iteration, stepping in either direction.
While noble and accurate, saving one variable when so many programmers have
zillions of variables anyway would amount to much savings.
My 2 cents.
Mark Johnson
- Original Message -
From: Edward Brown [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Friday, November 14, 2008 12:05 PM
Subject: RE: [U2] SELECT-READNEXT That's odd
Hey, save the variable by looping backwards - if the code in the loop
allows it, of course...
FOR A = DCOUNT(WORK.THINGY,VM) TO 1 STEP -1
code
NEXT A
-Original Message-
Also for any newbies watching. Do not put DCOUNT as the second value in
a
FOR...NEXT Loop. Assign it once prior to the FOR statement and the loop
will
be faster.
MAX=DCOUNT(WORK.ITEM.REC17,VM)
FOR I=1 TO MAX
My 2 cents
Mark Johnson
- Original Message -
From: Jef Lee [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Friday, November 14, 2008 2:39 AM
Subject: [U2] SELECT-READNEXT That's odd
One of our programmers wrote this snippet:
FOR YY=1 TO DCOUNT(WORK.ITEM.REC17,VM)
LISTNUMBER=''
SQLCOMMAND=''
UNISTATEMENT='SELECT BPM.WORKITEMS WITH
A1=':WORK.ITEM.REC1:'
AND
WITH A2=':WORK.ITEM.REC2:' AND WITH A17=':WORK.ITEM.REC17,YY:'
AND
WITH A24#C AND WITH A24#R AND WITH A24#F'
*MY.REC1=UNISTATEMENT
CALL SR.EXECUTESQL(LISTNUMBER,UNISTATEMENT,SQLCOMMAND)
READNEXT DEPENDANT.ID ELSE
* NO ACTIVE ITEMS LEFT I NEED TO UPDATE THE STATUS OF THE
DEPENDANT TASK
CALL
SR.READSQL('BPM.WORKITEMS',DEP.TASK.REC,WORK.ITEM.REC17,YY,'')
DEP.TASK.REC24='A'
DEP.TASK.REC8=DATE()
DEP.TASK.REC9=TIME()
CALL
SR.WRITESQL('BPM.WORKITEMS',DEP.TASK.REC,WORK.ITEM.REC17,YY)
END
NEXT YY
The FOR loop has 2 values to iterate, so it does 2 loops. The function
SR.EXECUTESQL()does the SELECT call.
Loop 1 returns 2 keys found.
Loop 2 returns 0 keys found.
What's odd is that the select list is empty on loop iteration 2 and
the
READNEXT is populated the ID with the second key from the first
iteration.
I looked in the help PDFs and all I found was a reference to a
corrected
error
relating to memory not being released if the READNEXT did not exhaust
the
SELECT list.
Any thoughts?
We have since changed our strategy to check the count returned
instead.
But it
would be nice to know that others have encountered this as well.
Jeffrey Lee
Senior Analyst/Programmer
IT Vision Australia Pty Ltd (ABN: 34 309 336 904)
PO Box 881, Canning Bridge WA 6153
Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153
P: (08) 9315 7000F: (08) 9315 7088
W: http://www.itvision.com.au
___
NOTICE : This e-mail and any attachments are intended for the
addressee(s)
only and may
contain confidential or privileged material. Any unauthorised review,
use,
alteration,
disclosure or distribution of this e-mail (including any attachments)
by
an
unintended recipient
is prohibited. If you are not the intended recipient please contact
the
sender
as soon as
possible by return e-mail and then delete both messages.
___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
-
Please remember to recycle wherever possible.
Reduce, reuse, recycle, think do you need to print this e-mail?
RE: [U2] UV 10.2 catdir problems
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 where the catalog name (ie *client*SCRNHDG) is over 14 characters? Next time you want to take a backup (especially if you're going to recatalog it :-) what happens if you do a mv rather than a cp? If that fails, it means the problem probably lies with the directory, not the file. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 12 November 2008 21:39 To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.2 catdir problems Once again, the catdir issue has raised its ugly head. Here's the synopsis. I have a customer running UV 10.2 (not 10.1 as previously mentioned) on a SuSE Linux box. Everything will be humming along swimmingly and then something weird happens with a catalog pointer (for reasons unknown) and everyone who is running a program that calls that subroutine finds themself greeted by an error and then drops to a colon prompt. In diagnosing this today I went to the offending file in /usr/ibm/uv/catdir and the file was in fact there, 666 perrmissions, so I figured I'd copy it off before correction so that I could compare the old and new versions to possibly spot some differences. Well get this: Despite being root (via su) I could not copy that file because the system said I didn't have read permissions. The following is the transcript of the highlights of that session: Last login: Wed Nov 12 09:04:59 2008 from 68.246.114.44 UniVerse Command Language 10.2 (c) Copyright IBM Corporation 2006. All rights reserved. client logged on: Wed Nov 12 14:01:50 2008 Program MS005: Line 209, /usr/ibm/uv/catdir/*client*SCRNHD/G is not in the CATALOG space. [EACCES] Permission denied Program MS005: Line 209, Incorrect VOC entry for SCRNHDG. Program MS005: Line 209, Unable to load subroutine. *sh* [EMAIL PROTECTED]:/u1/client cd /usr/ibm/uv/catdir/*client*SCRNHD [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *ls -l* total 4 -rw-rw-rw- 1 kking users 1042 2008-11-12 13:56 G [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *cp G G.old* cp: cannot open `G' for reading: Permission denied [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *su* Password: linux-oar1:/usr/ibm/uv/catdir/*client*SCRNHD # *cp G G.old* cp: cannot open `G' for reading: Permission denied linux-oar1:/usr/ibm/uv/catdir/*client*SCRNHD # *ls -l* total 4 -rw-rw-rw- 1 kking users 1042 2008-11-12 13:56 G *(note, I did not catalog this item at this time. That time does correlate to when I attempted to login above, however)* linux-oar1:/usr/ibm/uv/catdir/*client*SCRNHD # *cp G /tmp* cp: cannot open `G' for reading: Permission denied linux-oar1:/usr/ibm/uv/catdir/*client*SCRNHD # *cp * /tmp* cp: cannot open `G' for reading: Permission denied linux-oar1:/usr/ibm/uv/catdir/*client*SCRNHD # *exit* [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *exit* *CATALOG BP SCRNHDG* *client*SCRNHDG cataloged. *SH* [EMAIL PROTECTED]:/u1/client *cd /usr/ibm/uv/catdir/*client*SCRNHD* [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *ls -l* total 4 -rw-rw-rw- 1 kking users 1042 2008-11-12 14:05 G [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *cp G G.old* [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *ls -l* total 8 -rw-rw-rw- 1 kking users 1042 2008-11-12 14:05 G -rw-rw-rw- 1 kking users 1042 2008-11-12 14:05 G.old [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *rm G.old* [EMAIL PROTECTED]:/usr/ibm/uv/catdir/*client*SCRNHD *ls -l* total 4 -rw-rw-rw- 1 kking users 1042 2008-11-12 14:05 G Once the routine was recatalogued, everything worked fine. But how is it that the item was not readable despite the rw- privs and me being authenticated as root? Has anyone seen this and have any clues as to what might be causing this? It keeps happening on this system and the customer is most frustrated (as am I!). -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Create file on remote account
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@listserver.u2ug.org Subject: [U2] Create file on remote account I know this has been addressed before, but I can't find the references. We need to create files in account(directories) other than where we are running our programs. This is an automated process so it needs to run on the command line. We are running UniVerse 10.2.7 in a Suse environment SUSE Linux Enterprise Server 10 SP2 (x86_64) - Kernel 2.6.16.60-0.27-default (15). Thanks Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Normal SELECT behavior? [UD]
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: u2-users@listserver.u2ug.org Subject: [U2] Normal SELECT behavior? [UD] Is this normal SELECT behavior? I get the same results when I use NO.INDEX. Is there an UDT.OPTIONS I can use? I also noticed using 700 selected the same records when the F1 was Right Justified but not when it was Left Justified. But the leading zeros were an issue either way. LIST POH F1 WITH F1 = 000700 19:26:49 Nov 03 2008 1 POH... 01 Vendor Number 7110 00700 7120 0700 7130700 9262700 4 records listed Thanks, David A. Green www.dagconsulting.com (480) 813-1725 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Triggers on a NFS file?
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! If you're doing this, I'd say the first rule is DON'T use dynamic files. Preferably use a type 1 file. And only use the file as a staging post. Even then, don't expect it to work all the time, every time. If you control the third system, look at firewalling the UV ports and using port forwarding - with a bit of effort you should be able to get the first two systems to network transparently. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 23 October 2008 22:05 To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on a NFS file? If I have a NFS mounted directory (on a third non-UV system) which houses a UV format file. I have (2) linux system that have that directory mounted, which each have UV that have a VOC pointer to that file. 1F , 2 /mnt/directory/filename , 3 /mnt/directory/D_filename Both UV systems can read/write to this file, but only one system will be writing to the file, the other will only be reading.I realize locking is not respected from one system to another. If I defined a trigger on this file on the system that will only be doing the reading, will it detect any changes to the file when the other UV makes changes? Basically System1 will be making changes to that file. And System2 will need to update on it's system based on those changes. The reason I'm using NFS is that the two UV systems can't interact easily because they are on different networks, but both have access to the system which is exporting the UV formatted file. George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and/or AIX caching
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 like you want a file-type that INFORMATION had - I can't remember what filetype it was because I only ever used it once, but it was pinned in memory and read-only - intended iirc for very fast lookups. I would be very surprised if UV has what you want, because they would have copied this file type, and they haven't. They probably didn't see any need for it. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: 23 October 2008 00:31 To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse and/or AIX caching I've heard that UniVerse will cache data, or leave data in memory in case the next request needs it. Is there any way to control how much data gets kept in memory, and for how long? If one has 32 gigabytes of memory on an AIX machine, is there any way to tell the operating system (or UniVerse) to load whole (several) files in memory so the data can be accessed instantaneously, or is configuring some memory as a ramdisk the closest one can get to that? -- Louie in Seattle AIX 5.2 UniVerse release 10.2.7 UniVerse syntax: PICK --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Triggers
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 PROTECTED] On Behalf Of Susan Joslyn Sent: 15 October 2008 12:36 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Triggers David, With the use of remote voc you really can prevent by-pass of wrapped TCL commands. Completely, unequivocably. Regards, Susan Joslyn SJ+ Systems Associates, Inc. PRC(r) Real software configuration management for U2! -- Date: Wed, 15 Oct 2008 08:26:00 +1100 From: Hona, David S [EMAIL PROTECTED] Subject: RE: [U2] Universe Triggers You can by-pass them if you can update the VOC. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Updating UV/UD PE
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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: 02 October 2008 20:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Updating UV/UD PE This may be true but it really isn't a smart move even in windows, almost everything in programming is delimited by spaces. Personally I think it was one of the dumbest things implemented by MS. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, October 02, 2008 5:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Updating UV/UD PE CREATE.FILE FILE WITH SPACES IN'T 30 Creating file FILE WITH SPACES IN'T as Type 30. Creating file D_FILE WITH SPACES IN'T as Type 3, Modulo 1, Separation 2. Added @ID, the default record for RetrieVe, to D_FILE WITH SPACES IN'T. -Original Message- I'm not quite sure what you're getting at here, but never mind ... Don't forget UV comes from a heritage where space was an illegal character in file names. (And it still is, for quite a lot of other programs that run under Windows, too. Spaces cause me grief, even in Windows itself!) ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Updating UV/UD PE
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 Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 30 September 2008 01:15 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Updating UV/UD PE I've posted a summary of my recent experience with this so far. I'm running in a virtual machine and can test this process many times before committing the disk updates. So if anyone is curious about something or has a suggestion, I'll be happy to try it before I finalize my upgrade. HTH remove.thisNebula-RnD.com/blog/tech/mv/2008/09/u2upgrade1.html Thanks to those who have helped on this so far. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com (See blog posting about new product, NebulaRemoteControl) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
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 IBM, for example) saying we comply with the standard, but if the official and the de-facto standards don't agree, then the smaller vendors (and here I include U2) are likely to get trampled. Like it or not, IBM should treat any problems with a market-influential tool like CR as high priority, even if it is CR that's at fault. In an ideal world, if IBM said CR is broken, and here's how, it would result in CR getting fixed. In the world we live in, CR can probably get away with saying tough, on yer bike, mate. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: 19 September 2008 14:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniVerse COPY command and the UVTEMP directory {Unclassified}
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* (famous last words...) be as good as Windows :-)
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE,
MR
Sent: 18 September 2008 00:11
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] uniVerse COPY command and the UVTEMP directory {Unclassified}
I have come across this limitation before, too.
One work-around is to use READSEQ and WRITESEQ, that seems to work OK
even when COPY and ED fail.
Also, the item size limit on the Windows implementation of UV was much
larger than that on Unix last time I participated in a conversion (it
may even have been unbounded). Code that worked OK on Windows failed on
HP-UX, so we had to change to use READSEQ/WRITESEQ.
Heh, Windows better than *ix?
=O
asbestos underwear on ;-)
Regards
Mike
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel
Sent: Thursday, 18 September 2008 9:46 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] uniVerse COPY command and the UVTEMP directory
That happens to me all the time when I try to COPY a HOLD file/record
to
another directory. My reports are often 230mb or larger.
I asked IBM, and they said COPY always had a size limit. Can't ED it
either, as Dan observed.
So I just wrote a program to select the records, and copy them using the
unix cp command.
Then I list them using the unix ls command to make sure they were
copied.
-- Louie
0001: COMMAND = \SELECT REPORTS WITH START.DATE =
\:OCONV(@DATE,D4/)
0002: DISPLAY COMMAND
0003: EXECUTE COMMAND
0004: LOOP
0005: READNEXT COPY.HOLD.ID ELSE COPY.HOLD.ID = ''
0006: WHILE COPY.HOLD.ID
0007: COMMAND = \sh -c cp -r
'/sam/hill/HOLD/\:COPY.HOLD.ID:\'
/sam/hill/HOLD.TODAY/\:
COPY.HOLD.ID:\\
0008: DISPLAY COMMAND
0009: EXECUTE COMMAND
0010: COMMAND = \sh -c ls -l
/sam/hill/HOLD.TODAY/\:COPY.HOLD.ID:
\\
0011: DISPLAY COMMAND
0012: EXECUTE COMMAND
0013: DISPLAY
0014: REPEAT
0015:END
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.
If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Universe Lock Error
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 broken, but then again it might not. There's arguments both for and against. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 18 September 2008 12:05 To: u2-users@listserver.u2ug.org Subject: [U2] Universe Lock Error Morning All We are running on UV 10.2.11 and have encountered an error. Scenario: PROGRAM MAIN_PROG OPEN FILE TO FILE ELSE STOP 201,FILE CALL READ_PROG CRT YOU SHOULD BE HERE...: INPUT X RELEASE FILE, TESTER PROGRAM READ_PROG (A) OPEN FILE TO FILE ELSE STOP 201,FILE READU REC FROM FILE, TESTER ELSE REC = REC1 = 1 WRITEU REC ON FILE, TESTER RETURN PROGRAM READ_PROG (B) OPEN FILE TO FILE ELSE STOP 201,FILE READU REC FROM FILE, TESTER ELSE REC = RETURN With both Program (A) and (B) when READ_PROG returns to MAIN_PROG it releases the Record Lock before the release. Has anybody else encountered this, is there a way to fix it (Work Around / Setting etc...) Regards Bjvrn Behr SUMMIT CORE Developer Tel No: +27 12 673 3251 Fax No: +27 12 673 4681 E-Mail: [EMAIL PROTECTED] [demime 1.01d removed an attachment of type text/x-vcard which had a name of Bjorn Behr.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wintegrate Query Builder
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 field (like HS/ODBC does), to tell you what order to sort in. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caryl Lange Sent: 18 September 2008 14:35 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Wintegrate Query Builder We have that same issue with our ODBC connection and Access. We have tried adding a field for a line counter, which works but is cheesy. We also have one or two that we write twice, one MV and one SV. Neither solution is that graceful. Caryl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Wednesday, September 17, 2008 3:18 PM To: u2-users@listserver.u2ug.org Subject: [U2] Wintegrate Query Builder Hi, I have some notes that are stored in a MV field. My application, (Dataflo) keeps the lines in order. However, I use Wintegrate Query Builder to export them. I have found that the notes don't necessarily come out in the proper sequence. For example: I am going to The park today And then I Will go home Might look like this: And then I I am going to Will go home The park today Is there a way to keep a note in the right sequence? Thanks, Bruce Ordway Unidata 5.2 Dataflo5.4G7 Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
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 doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
But won't it then disappear up its own backside with ambiguous field names? Iiuc, listing multiple file names does a cross-product, and as a result if you repeat the same file name, EVERY field will be ambiguous and the SQL will be unable to resolve. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 14:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_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 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 doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1675 - Release Date: 9/16/2008 7:06 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
Exactly. Doing it WITHOUT an AS keyword (as is happening in my case) will cause it to blow up. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 16:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] 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 and UniData But won't it then disappear up its own backside with ambiguous field names? Iiuc, listing multiple file names does a cross-product, and as a result if you repeat the same file name, EVERY field will be ambiguous and the SQL will be unable to resolve. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 14:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_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 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 doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com
RE: [U2] RE: U2UG Board Meeting
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 know whether the equipment the board are using even has that capability. Cheers, Wol (ex board member) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 28 August 2008 19:12 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] RE: U2UG Board Meeting Consider opening these conference calls up to ordinary U2UG members. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What Next?
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 its basic configuration. I make sure I've got a copy of Slack in my rescue kit because it's pretty much guaranteed to boot any hardware successfully - live CD distros normally don't like my hardware... Gentoo because, well, it's Gentoo. It compiles everything from source, it's a pain to update on occasion, I left the update running overnight last night because it takes so long... but you've got the source to everything, it's infinitely tweakable etc etc. I'd be inclined to spend some of those education dollars on a good PC. If you can afford it, make it a twin dual-core CPU. On that run RHEL/VMWare and UV/UD PE. Inside VMWare you can then run Windows, other linuxes, whatever. Play! Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Garry Smith Sent: 19 August 2008 19:09 To: u2-users@listserver.u2ug.org Subject: RE: [U2] What Next? XML, XSD, XSLT and CSS Then wrap all that into a VB/C# .net application and if your brain doesn't explode from looking at all the MS API's then take on either Redback/U2 WDE or SQL Admin, SQL and SQL reporting. Does anyone know who Joe Celko is? Or counter grain - Linux, PHP, Ruby, and the darkside at insecure.org (nmap - fydor - hacker) Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Tuesday, August 19, 2008 9:16 AM To: u2-users@listserver.u2ug.org Subject: [U2] What Next? For the last 14 years or so I have been doing programming support and light DBA work; first in Universe (Prime Information) and now in Unidata (Pick). I'm basically a one-trick pony (UniBasic and System Builder) because my goal has always been to move into a business analyst role, but that has never worked out (I'm too IT). Last fall I decided to stop trying to pursue that and stay in what I'm doing. So now I need to decide what I should invest my educational dollars. I want to stay in application development and support because I like better than techie stuff. So what would you suggest I begin learning that would keep me reasonably employable in the future? Thanks. Albert DeWitt Sr. Programmer Analyst Stylmark, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic Array oddity very useful
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 Behalf Of Mats Carlid Sent: 19 August 2008 14:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Dynamic Array oddity very useful That is then flavour dependent - in information flavour there is a zero element , that's where the overflowing elements go ( if any) in a matparse. -- mats Martin Phillips skrev: Hi Dennis, So A0 = X is a way quicker way of writing A = X : @fm : A I'm not sure that this is a safe assumption. I have taken a quick look at the documentation for various mv products and they tend not to define what will happen. Trying your example with UV does not produce the result that you quote. I think that the real issue here is that there is no field zero. It is up to the different products to determine what they do in this case as there doesn't appear to be an agreed behaviour. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Why Buy (or develop in) UniVerse?
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 designed) puts it all in one place. That's why MV doesn't need optimisers etc - it doesn't need to guess what data is likely to be accessed as a blob - if data is tightly joined in the real world, it is likely to be tightly joined in an MV database (while it's guaranteed to be scattered everywhere in a relational database). Relational REQUIRES that data comes in two dimensions. MV reflects the real world in accepting data that comes in more than two dimensions. A generic data is n-dimensional theory will ALWAYS be preferable to a data is 2-dimensional theory. I liken that requirement of relational to Euclid's assertion in geometry that parallel lines never meet. Without realising it, he placed an artificial restraint on geometry and held it back centuries. CD have done the same for database theory. Would you use Newtonian mechanics to model events in the LHC? The physicists would laugh you out of Switzerland. As David said, Oracle market to CEOs - relational wins on marketing clout. Unfortunately, the mathematical foundation behind it is iredeemably flawed :-( It breaks the Einsteinian corollory to Occam - make it as simple as possible - but no simpler - relational theory has been simplified too far, with the result that it ends up far more complex than it need be. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: 13 August 2008 01:18 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Why Buy (or develop in) UniVerse? Hi Louie Intersystems have done some benchmarks of multidimensional databases versus RDBMS and some of that logic follows through to UniVerse. It is difficult to compare UniVerse to RDBMS in benchmarks as they are designed for RDBMS strengths. If a benchmark was designed for UniVerse strengths instead, RDBMS would not look so rosy. RDBMS databases are designed to optimise cache and indexing because of the performance issues in the database. UniVerse does not inherit those performance issues, hence they do not need to optimise Cache and indexs to the same extent and the optimisations needs to be different. There are hosts of differences. RDBMS have fixed length and fixed structure records, where as UniVerse has variable length records and fields can be added at any time. More UniVerse records can fit on a disk sector than RDBMS rows increasing U2 performance. RDBMS don't efficiently lock rows, they do group locks. Universe can lock individual records without performance hits. RDBMS work with optimistic locking as pessimistic locking is a nightmare with group locking. UniVerse can handle both optimistic and pessimistic locking. RDBMS stores all tables within one file, UniVerse has a file for every table. Totally different approaches for BU, Restore and handling file corruptions. RDBMS have to join multiple tables which creates overhead and referential integrity issues. UniVerse stores all specific data in a multidimensional record. UniVerse is close to Zero-Administration, where RDBMS still require expensive Database administrators. RDBMS have large workloads in setting up security access to tables for different users. UniVerse can use table security or OS file security. RDBMS have limited functionality in business rules stored in the database. UniVerse can handle complex business rules with ease. In complex applications UniVerse is well ahead. However the argument should not be technical. The CEO and board does not make decisions on Cache and indexes, they make it on a business case. ROI, Cost of running, Staff numbers to administer and develop, competitive advantage. The old joke was what hardware does Oracle run best on, a projector. Oracle markets to CEOs and does little technology discussion, that is why they are successful. Its horses for courses, but if a project is going to be complex, the success rate of the project completing on time and on cost in UniVerse is near 100%, on an RDBMS the numbers are scary. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: TCL literal select
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 select I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: TCL literal select
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 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 select I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniobjects help needed!
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 happening is that the connection between UniObjects and your VB app has disapppeared (note with us it was our app and Word that stopped talking to each other, both running on the same PC if I've got it right). So it looks like it's local to the affected PC(s), and is a time-out issue. Good luck tracking it down - it took us ages! Have you tried explicitly trapping that error and just retrying the read? You saying UniObjects just dies looks a good clue - it might well have gone to sleep ... we found the failed connection attempt woke Word up again so that the second try worked. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: 06 August 2008 03:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uniobjects help needed! Hello all, I was joking about the voodoo chants when I first posted but several days later and little progress made I am now seriously willing to consider any chants anyone knows. on a more serious note does anyone know if it's possible to talk directly to a uvrpc daemon? (uniobjects) I know you can with smtp and other socket programs if you know the language/syntax, so I think it should be possible with uvrpc (uniobjects). Any suggestions/ideas on how (if possible) to do this would be appreciated! What we are seeing are users (who are ALL using the EXACT same VB 6 program) having problems with writes and receiving back corrupted data (to a universe database using uniobjects). We have turned on logging in uniobjects but I am having some trouble reading the log files (its hard to tell if the corruption is coming to uniobjects or from universe). We have tested the universe programs that the VB app. calls and they work exactly as they should. We have tested the VB 6 apps and they too appear to be working as expected (but obviously something is wrong)/ We have tested/checked/rebooted the entire network (to include the aix machine). What is throwing me is that if the basic program does not find a match to whatever was passed to it, it returns null but sometimes we get back garbage to the VB app, which to me means that the basic program got a valid value and returned a valid response that somewhere in the chain got corrupted. We have even done an iptrace on the aix box to see what it gets/sends as well as on the windows PC(s) but sadly I am not able to fully comprehend what I am seeing. If anyone is willing (and this is asking a lot, so please forgive me) to look at an iptrace I would be incredibly grateful! I have two trace files, 1. one from a windows PC that was not able to edit an order 2. one that logged all the traffic coming/going to the aix machine on the uvrpc port any suggestions/chants/thoughts would be extremely welcome! I hope all this makes sense, if not this is what working 96+ hours in the last 7 days does to you thanks again dougc -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Sunday, August 03, 2008 12:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects help needed! In message [EMAIL PROTECTED], doug chanco [EMAIL PROTECTED] writes Hey, We are having a problem with uniobjects that started a couple of days ago. We have a VB app that uses uniobjects to access an aix system running universe 10.1 and a few days ago we started getting errors where uniobjects would just die, its starting to look like it might be a network issue but so far nothing we can discover. Our Cisco guy is not seeing any errors in the cisco switches, I am not seeing any errors on the aix system (5.2.6). While is may or may not be a universe/uniobjects issue, so far we have been stumped as to what the problem is. We even called an IBM uniobjects engineer for several hours and he could not find a problem as neither could our VAR or IBM tech support for aix. So I thought I would throw this out to youll who vast knowledge may hold the key to the answers we seek! The fact that in the past 3 days I have works close to 60 hours is a testimony to the amount of effort we have been putting in to try and solve this problem. Basically what we are seeing that is Run-TIme error '-2147417848 (80010108)': Method 'Read' of object 'IUniFileEx' Failed So any suggestions/thoughts/ideas/crystal balls/magic spells/voodoo chants are welcomed! This, I think, will fall into the Voodoo Chant school of hopeful wishing ... but the message number looks vaguely familiar to me. Do you know which line of your code is returning your error? What happens if the code just retries the read? The problem I'm thinking of that we had was our program talking
[U2] SELECT problem with quote characters
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 And if I do a SELECT FILE WITH FIELD LIKE \...LLOYD'S...\ it returns nothing. What on earth is the syntax for picking up an embedded quote in data in a LIKE comparison? PIOPEN flavour, by the way. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Linux Psuedo Directory
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 Linux user who cannot see the top level directories, i.e. what they see as '/' is actually further down the chain. Can anyone remind me how? - Chuck Rootless Barouch --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch
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 August 2008 15:41 To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch I have no idea what the SQL is being sent from Worldship. That could possibly be valuable, but I don't have access to that level of information right now. But an interesting question, no doubt. On Sun, Aug 3, 2008 at 10:14 AM, Anthony W. Youngman [EMAIL PROTECTED] wrote: In my case, the SQL command being sent (by MS Access) is SELECT * FROM TABLE TABLE ORDER BY ... Note the doubled-up file name - UV barfs on it and you get an error S1000 back. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Editor
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 Subject: Re: [U2] Data Editor Could we get links to multivalue vendors (who wish them) on the U2UG Knowledge Base page or somewhere? It is a crying shame that all these nifty multivalue tools are out there, and one only stumbles across them in miscellaneous posts. Also multivalue software packages. We have users with thousands of hours (millions?) of experience in the multivalue world, and we seem to be intent on keeping it all a secret. -- Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Universe ODC field association
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 useful - go to the UniVerse page and it's linked from there. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: 29 July 2008 13:08 To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uv] Secure Sockets / SSL
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 and Exim are server software. But if they want everything to run on the UV server and leave that over an SSL connection, I think the blat email client talks SSL. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen Batchelor Sent: 23 July 2008 15:12 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [uv] Secure Sockets / SSL -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Mike Pflugfelder Sent: Wednesday, July 23, 2008 7:17 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [uv] Secure Sockets / SSL Well, I'd like this to run from a Universe server, running on either Windows or Unix, not the client side. From what I understand, current releases of Universe include secure sockets and therefore can make the call directly. Is there a specific reason why it has to be SSL directly from the UV software? Postfix (and I'm sure Exim too - I'm a postfix guru) can be configured to do SASL and TLS (with/without SSL) for incoming and outgoing SMTP. Once you set up the TLS/SSL, all you'd have to do is configure a simple transport by destination domain and it would do the rest for you through the normal sendmail/mail command. People do this regularly when they want to forward mail to a gmail account, which requires TLS/SSL and a SMTPS port connection. I can understand the want to keep the code inside the center of the mass, but such universal functionality would gain much better support and features if it wasn't custom written in a UV app. Regards, Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: [EMAIL PROTECTED] Web: http://www.all-spec.com Blog: http://blog.all-spec.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Strange SQL query optimisation ...
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 terminologies when the input uses just one? :-) Not that that's important unless it gives IBM's engineers a clue ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: 21 July 2008 00:26 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange SQL query optimisation ... LEFT JOIN and LEFT OUTER JOIN are the same animal. A left outer join must yield every row from the left input and (a) any matching rows from the right input and (b) nulls for any row that does not exist in the right input. To achieve this from the right input, the optimizer has chosen to use a full table scan. Why? I don't know. There is a 30% rule that applies when deciding when to use an index, but there is no index involved here. What happens (as reported by EXPLAIN) if you specify NO.OPTIMIZE for each query? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Strange SQL query optimisation ...
Thanks. But I don't understand ... In the second query I've asked for a LEFT JOIN both times. What's the difference between a LEFT JOIN and a LEFT OUTER JOIN? And why when I ask it twice for LEFT JOINs does it do a left join once, and a left outer join once? While I think I understand your comment about a left outer join must capture rows that may not be in the right table I don't see how any such rows could exist - the fact that we're matching @ID to @ID guarantees that, surely? Unfortunately, I don't think creating an index is an option Sorry for troubling you for more detail, but my SQL isn't superb, and I don't see why it should treat the two joins any differently - they're both joining tables on a key matches key basis. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: 18 July 2008 02:00 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Strange SQL query optimisation ... They are not the same query. The second one specifies LEFT OUTER JOIN. The first does not. A left outer join must capture rows that may not be in 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 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 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 result. Here are the two queries: 02 SELECT * FROM REGISTER, CLAIMS_CLAIMCOSTS, CLAIMS_COVERCODEFROMPOLICY WHERE R EGISTER.CLAIM.NUMBER=CLAIMS_CLAIMCOSTS.CLAIM.NUMBER AND REGISTER.CLAIM.NUMBER=CL AIMS_COVERCODEFROMPOLICY.CLAIM.NUMBER AND REGISTER.CLIENT.REF='W1323' AND CLAIMS _CLAIMCOSTS.CURRENCY.CLAIM.PAID.IN '' EXPLAIN 01 SELECT * FROM REGISTER LEFT JOIN CLAIMS_CLAIMCOSTS ON REGISTER.CLAIM.NUMBER=C LAIMS_CLAIMCOSTS.CLAIM.NUMBER LEFT JOIN CLAIMS_COVERCODEFROMPOLICY ON REGISTER.C LAIM.NUMBER=CLAIMS_COVERCODEFROMPOLICY.CLAIM.NUMBER WHERE REGISTER.CLIENT.REF='W 1323' AND CLAIMS_CLAIMCOSTS.CURRENCY.CLAIM.PAID.IN '' EXPLAIN; Note that REGISTER and CLAIMS are the same UV file (don't ask why) and CLAIM.NUMBER is the @ID. When the first query is run, the optimiser says it's doing a hashed join on the primary key for both subtables. When the second query is run, it does an outer hashed join for the first subtable, but an outer cartesian join using scan of secondary file on the second. Why? It's the same query! Any ideas how to make the modern syntax do the right thing and not run like a snail on tranquilisers? Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Strange SQL query optimisation ...
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 result. Here are the two queries: 02 SELECT * FROM REGISTER, CLAIMS_CLAIMCOSTS, CLAIMS_COVERCODEFROMPOLICY WHERE R EGISTER.CLAIM.NUMBER=CLAIMS_CLAIMCOSTS.CLAIM.NUMBER AND REGISTER.CLAIM.NUMBER=CL AIMS_COVERCODEFROMPOLICY.CLAIM.NUMBER AND REGISTER.CLIENT.REF='W1323' AND CLAIMS _CLAIMCOSTS.CURRENCY.CLAIM.PAID.IN '' EXPLAIN 01 SELECT * FROM REGISTER LEFT JOIN CLAIMS_CLAIMCOSTS ON REGISTER.CLAIM.NUMBER=C LAIMS_CLAIMCOSTS.CLAIM.NUMBER LEFT JOIN CLAIMS_COVERCODEFROMPOLICY ON REGISTER.C LAIM.NUMBER=CLAIMS_COVERCODEFROMPOLICY.CLAIM.NUMBER WHERE REGISTER.CLIENT.REF='W 1323' AND CLAIMS_CLAIMCOSTS.CURRENCY.CLAIM.PAID.IN '' EXPLAIN; Note that REGISTER and CLAIMS are the same UV file (don't ask why) and CLAIM.NUMBER is the @ID. When the first query is run, the optimiser says it's doing a hashed join on the primary key for both subtables. When the second query is run, it does an outer hashed join for the first subtable, but an outer cartesian join using scan of secondary file on the second. Why? It's the same query! Any ideas how to make the modern syntax do the right thing and not run like a snail on tranquilisers? Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects - read .rtf doc from UV server
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 routines on PickWiki that write rtf - I can't remember if I uploaded them or not. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Gouws Sent: 07 July 2008 11:01 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects - read .rtf doc from UV server Hi Mac, Thanks for that link - very helpful Louie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 07 July 2008 11:46 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects - read .rtf doc from UV server Rtf is normally just text that is formatted a special way that rtf readers and writers understand - the rtf specification http://msdn.microsoft.com/en-us/library/aa140277.aspx, so you can write a uv pgm that read's/or writes that type of file using simple openseq/readseq - Mac --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: ODBC problems
What I did was link to the table in Access, open it, and then click on a column to sort it. So it should have been an identical query. I thought I'd test it - get Dr Dee Bee Spy to monitor me doing it on the table that worked - and guess what! That table won't sort now, either! I thought that would give some credence to David Jordan's idea of the temp space, but there's masses of free disk space both on my pc and the server. And I don't see how it could be permissions, seeing as it works sometimes and not others. As for different client software etc, we're having problems on at least two pcs. The one we first noticed it on is running Office (Access) 2007, and my pc is running Office (Access) 2003. The ODBC software is identical - installed from a 10.2 client CD. Probably (but not definitely) the same CD. Thing is, we really need to know what's causing it so we can definitely avoid the problem - we don't want to install this on our customer's site and then have them go down with this problem... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 01 July 2008 06:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: ODBC problems Is it the same query for both files/tables (that share the same dictionary)? Do both your queries work from a different client PC? If so, is there different client software versions or ODBC clients? Regards, david -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 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 headscratching here ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] locking question
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 you any more ideas...) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 01 July 2008 15:03 To: u2-users@listserver.u2ug.org Subject: [U2] locking question hey all, has anybody run across/seen an issue where a process sets a lock via READU and then when it tries to write back the record cannot because the record is locked but somehow lost the fact that the process trying to write the record is the process that created the lock? I am not sure if this is even possible but we at are at a loss as to whats causing this lockup (which does not occur regularly but enough that its causing us concerns with our busy season coming around) We had a lock up last night that LIST.READU EVERY showed that that a process was holding a lock and that the same process was failing on a write (in a program) and 'stuck' (yes we have old old old old old code that does not believe in a failure clause or the handling of a write failure). Once I cleared the lock the process continued on its merry way ... Now the obvious things I checked 1. that there were no other users logged in as that particular user (yes they sometimes login multiple times with the same user but we are forcing them to change that) 2. the PID's were indeed the same system info: aix 5.2.6 RELLEVEL 001 X 002 10.1.7 003 PICK 004 PICK.FORMAT 005 10.1.7 any thoughts/suggestions/ideas/etc .. are welcomed! thanks everyone dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC problems
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 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLPrepare(DML); State:S1; uniVerse code: 950088; Msg: [IBM][SQL Client][UNIVERSE]Universe/SQL: syntax error. Unexpected filename. Token was CLAIMS_CLAIMSCOSTS. Scanned command was FROM CLAIMS_CLAIMCOSTS CLAIMS_CLAIMCOSTS . (#950088) I can call up the linked table in Access no problem. As soon as I click on a column to sort it, however, this is the error I get. My colleagues are trying to create queries and are getting similar problems, a straight table retrieve works fine - but as soon as they add selection or sorting criteria it starts bombing out. It also seems to be a bit inconsistent in that it will often work first time, and then start failing (though that may be a false impression as we've been playing with criteria trying to work out what works). Software? I've loaded the latest UV clients from a 10.2 CD, I'm running Office 2003 for Access, and one of my colleagues is running Office 2007. I'm on XP. (The previous post I mentioned talked about Crystal Reports, which we're not using.) Anybody got any clues as to what's wrong? Or am I just going to have to try and update everything and hope it goes away? One thing I notice - the two instances of the filename are differently-quoted - does that give anyone any ideas? Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: ODBC problems
Adding a bit more info ... the following is from Dr DeeBee Spy's log ... SQLExecDirect 0x020A0001 [171]SELECT CLAIMS_CLAIMCOSTS.CLAIM_NUMBER,CLAIMS_CLAIMCOSTS.Z_ASSOC_ROW FROM CLAIMS_CLAIMCOSTS CLAIMS_CLAIMCOSTS ORDER BY CLAIMS_CLAIMCOSTS.CLASS_OF_BUSINESS SQL_NTS SQL_ERROR SQLError NULL NULL 0x020A0001 [5]S1000 950088 [327][IBM][UVODBC][1401032]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLPrepare(DML); State: S1000; uniVerse code: 950088; Msg: [IBM][SQL Client][UNIVERSE]UniVerse/SQL: syntax error. Unexpected filename. Token was CLAIMS_CLAIMCOSTS. Scanned command was FROM CLAIMS_CLAIMCOSTS CLAIMS_CLAIMCOSTS . 512 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 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-users@listserver.u2ug.org Subject: [U2] ODBC problems 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 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLPrepare(DML); State:S1; uniVerse code: 950088; Msg: [IBM][SQL Client][UNIVERSE]Universe/SQL: syntax error. Unexpected filename. Token was CLAIMS_CLAIMSCOSTS. Scanned command was FROM CLAIMS_CLAIMCOSTS CLAIMS_CLAIMCOSTS . (#950088) I can call up the linked table in Access no problem. As soon as I click on a column to sort it, however, this is the error I get. My colleagues are trying to create queries and are getting similar problems, a straight table retrieve works fine - but as soon as they add selection or sorting criteria it starts bombing out. It also seems to be a bit inconsistent in that it will often work first time, and then start failing (though that may be a false impression as we've been playing with criteria trying to work out what works). Software? I've loaded the latest UV clients from a 10.2 CD, I'm running Office 2003 for Access, and one of my colleagues is running Office 2007. I'm on XP. (The previous post I mentioned talked about Crystal Reports, which we're not using.) Anybody got any clues as to what's wrong? Or am I just going to have to try and update everything and hope it goes away? One thing I notice - the two instances of the filename are differently-quoted - does that give anyone any ideas? Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC Account Activation
Just had a thought. Could it be access rights? If, as looks likely, this is used by UV to manage schemas, it might be locked down so only the SQL DBA can edit it. What's the betting that would cause your problem? In that case, it's nasty, because it also means any attempt to run HS.UPDATE.FILEINFO is likely to fail. Hmm... you might need to change the F to X to export your tables then change it back again so the account actually works... I'm guessing we might not suffer this because I've never used SQL Schemas in UV, and other people may not have met it because 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-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Yes I know it's a UV file. That was point of me mentioning PTERM.FILE - that's a UV file too and it was UV files that gave me the most grief. Does anybody know what UV_ASSOC does? Is it safe to delete the VOC pointer? It looks to me like it's part of the SQL table mechanism so if you're not actually creating SQL schemas etc it's probably totally unnecessary in this account. What you could try is changing the F to an X and seeing if anything in the account falls over. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 26 June 2008 08:56 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC Account Activation This is a brand new uv account - the problem seems to be on a uv file D_UV_ASSOC and I'm not sure if I can delete that Mac -Original Message- From: [EMAIL PROTECTED] [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 have been caused by the various preparation/export programs crashing on system files we've never touched. If you don't need it, delete the VOC entry. I had it crash on PTERM.FILE - a system-supplied multi-part file. Secondly, go to pickwiki, find the page on Universe, and then look at the page on ODBC. You might find it useful as it describes my tribulations with 9.6. Bear in mind that these export routines process EVERYTHING, so the entire account needs to be nice and clean, not just the files you're exporting :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 14:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC Account Activation Hi, I know it'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 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: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http
RE: [U2] UVODBC Account Activation
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: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC Account Activation
Okay. Firstly, do you need this file in your account? Oddly enough, most of my hard to fix problems with ODBC have been caused by the various preparation/export programs crashing on system files we've never touched. If you don't need it, delete the VOC entry. I had it crash on PTERM.FILE - a system-supplied multi-part file. Secondly, go to pickwiki, find the page on Universe, and then look at the page on ODBC. You might find it useful as it describes my tribulations with 9.6. Bear in mind that these export routines process EVERYTHING, so the entire account needs to be nice and clean, not just the files you're exporting :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 14:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC Account Activation Hi, I know it'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 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: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ __ NOD32 3216 (20080625) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] COMMON
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 name declared twice), and not by two programs confusing one declaration and thereby writing to the wrong file! Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: 04 April 2008 14:00 To: u2-users@listserver.u2ug.org Subject: Re: [U2] COMMON Dennis Bartlett wrote: Following up on the common thread, can one OPENSEQ to a COMMON variable? Absolutely. COMMON is merely a method of sharing data between programs without argument passing as is commonly done with subroutines. Note that common in this fashion is accessible among programs for the individual user, not to be confused with shared common, (such as the catalog uses, which allows users to access the same info). So, any variable can be stuffed into a common block, and it's best to use what's called NAMED COMMON so that you don't collide with anyone else's definitions, (particularly if you're running vendor code which you can't read the source code to). And then any program or routine that has that COMMON block defined within it has acccess to the variables within it. With file pointers, the trick is to set flags so that you know that they're open or closed. Which can be followed through to other variables, set flags to show that they've been initialized or not. Always set them to show non-initialized first, set them, set the flags, then in any routine that uses them, check the flags before you use them, and if the flags aren't set, you can't use the values. One very common way of dealing with this is to call a program from the VOC LOGIN PA which sets common. As has been mentioned previously, watch out for accounts, as showing that your PAYMASTER file is open, and having your user log from TEST to LIVE will give you some very real problems... -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIDATA 7.1 performance measures
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-activating, or leaving dlls in the autoload, or whatever. AV software mucks about in the guts of the OS, and caution teaches you not to trust it ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: 31 March 2008 14:46 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Good Morning John, Our Network Manager asked why you recommended removing the anti-virus software vs. disabling them. Could/would you please share your rationale for making that recommendation? The feedback I am getting as a result of this posting has been incredibly helpful. Rob Smith Philadelphia University -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Saturday, March 29, 2008 8:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Ibd start by looking for specific bottlenecks. Itbs too easy to see one of the system constraints and assume that's your bottleneck (been there). Run some mete As others have said, see a specific bottleneck first then take it from there. Some suggestions on things to look at in Windows and hardware - I'm assuming all the usual has been done inside UniData itself. __ Anti-Virus software killing you? REMOVE it first for the avoidance of doubt - then decide. Donbt just reconfigure or disable - REMOVE. Tweak afterwards - know whether itbs worth tweaking first. Paging (yes/no/how much)? Disk performance *read *write *wait I/O Are you using RAID? Should be 0+1, try and avoid RAID 5 Use hardware RAID not software Turn off read-ahead, optimise for random, not sequential Steps vary for different SANS (Hitachi / Veritas / Shark etc). If using an external SAN: * has the memory battery failed? (turns off write caching - a killer) Put paging space on a separate disk, and UniData TMP also. * Do you have remote mirroring on the SAM turned on (requiring remote commit on writes can be a killer). _ If 3Gb is does turn out to be an issue consider Unix, much better memory management. Linux on your x86 platform seems the logical move (same hardware). You also get better CPU resource usage on Unix then Windows. Memory could be a bottleneck for you, but Ibd be surprised. The usual memory related issues I see on Windows (or Unix come to that) are due to file import/export programs READING and WRITING truly enormous text files from the O/S file structures. READSEQ and WRITESEQ are the cure there/ Regards JayJay From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexes
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 then associated with each stock id SELECTINDEX STOCK.ID, STOCK.ID FROM F.REPAIR Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 14 March 2008 13:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Indexes Thanks! This is by far the easiest, and it works! -Original Message- [EMAIL PROTECTED] wrote: At the universe tcl: SELECT REPAIR SAVING UNIQUE STOCK.ID --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse 10.2 Error code: 2 2 on OpenSUSE
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 how :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 14 February 2008 13:50 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse 10.2 Error code: 2 2 on OpenSUSE Universe comes with a bootscript to be placed in the startup scripts folder that is not executed - sthg like uv.rc. HTH -- mats DeanNapper skrev: Hi. I have installed UniVerse 10.2 onto OpenSUSE and all was well until I restarted the host, now UniVerse reports the following when starting: An error has occurred during uniVerse initialization Please contact the system administrator Error code: 2 2 I can't seem to find any info about this error, please help! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UB] Beep Error
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 audio error beep message when an end-user makes a keyboard error? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects error 30105 Unable to load subroutine on server
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 found it, and sometimes looked in the wrong place and didn't. Very confusing. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: 05 February 2008 18:11 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects error 30105 Unable to load subroutine on server Wol: If you're using UD there's a tricky way to log UO... activity. If on UV I don't know the technique to do this. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Saturday, February 02, 2008 2:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniObjects error 30105 Unable to load subroutine on server In message [EMAIL PROTECTED], David Jordan [EMAIL PROTECTED] writes Hi Wol UniObjects does not like returning unassigned variables, it causes a fatal. In the unibasic subroutine, you could check if the parameter is unassigned and set it to before returning. Thanks - that's a good thing to know. But it's not the case here. The error is that the subroutine never gets called, if I've got it right. Certainly, none of the DataBasic code seems to run (almost the first thing it does is write diagnostic tracking stuff to a file, and that never happens). And all the arguments are assigned in my VB app before I call it, so they should still be assigned when it returns :-) Thanks, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] question(s)
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 PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: 06 February 2008 15:23 To: u2-users@listserver.u2ug.org Subject: Re: [U2] question(s) 1. we use ANALYZE.FILE FILE.NAME .. it gives the scoop on anything not a directory and a little bit on dynamic files. 2. That's an indication of some type of memory leak or stack overflow I think. I'm pretty sure its an abnormal condition. You could probably duplicate it in a sub calling itself until it gets either too deep or too big maybe. The 'printer segment removed' I think is a symptom of the abnormal condition. 3. If you dont require specific key characteristics, you can use 'SAMPLED'. SELECT FILE.NAME SAMPLED 2000 , will take every 2000th record as they occur in the file I believe. john On 2/6/08, Doug Chanco [EMAIL PROTECTED] wrote: Hey all, I am back to re tooling my mind from jBASE to Universe (although one question is not vendor specific) 1. In universe how can I tell what type of pick file I am looking at (type 2,3,4,5,6, etc ) 2. I am getting a few (very few) PRINTER MEMORY SEGMENT REMOVED errors in root's emails but the few I am getting (roughly 3 a day) I cannot seem to figure out what's causing them. All our root cron jobs are either using uvcron or PHANTOM to start the universe program. 3. does anyone have a suggestion on RANDOMLY (or as random as possible) a way to SELECT a file? I am trying to get @ 500 RANDOM records from a file with 850,000 items. I have some ideas such as selecting the entire file and then every x records do some math operation and if even use this record but since I am a pup compared to some of you I have been doing pick forever vets out there I thought I would throw this out and see what comes back. The keys look like 51037517 51037516 15312939 51037518 15312936 51037519 51037512 51037513 51037515 14137791 51037514 51037510 Thanks everyone! dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What is the BREAK key setting for Dynamic connect?
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 TERM in the UV account so you can go in there and modify it. I don't think I posted my modifications on PickWiki, so you'll have to do it yourself; but I had our site set up so that, when the user wanted to display something to screen in wide layout, the program simply did an EXECUTE TERM ... and the screen would resize itself under program control, not requiring the user to do anything. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 22 January 2008 18:22 To: u2-users@listserver.u2ug.org Subject: [U2] What is the BREAK key setting for Dynamic connect? Its about 4 years since I worked on a UniVerse box. I've worked in Clarion / Javascript / HTML / MS SQL Server 2005 since. Returning to U2 is amazingly confusing! So bear with me. (1) I'm having a problem setting my Break key. is it Ctrl-C, Ctrl-B or Ctrl-Break? And when I press Ctrl-C I get a dialog saying noth is highlighted. I'm getting really bored opening another session to kill the looping process. (2) How do I set the terminal to 132 chars wide to view reports? Thanks Dennis bartlett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Problem installing System Builder PE
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 it does in RH. Unfortunate... But that explains why removing it for non-RH works. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 17 January 2008 22:46 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Problem installing System Builder PE I had a similar problem with UV 10.2 on Ubuntu Linux. The issue seems to be related to a quirk in the Linux version of the cpio command. I changed the command line to NOT include the c command line parameter. Try this: cpio -ivBdum instead of cpio -icvBdum Regards, Raul [EMAIL PROTECTED] wrote on 01/17/2008 02:47:04 PM: Ibm trying to install SB 5.4.1 PE on Fedora 8 and Ibm getting an error: sh-3.2# cpio -icvBdum pe_sb541_uv_cpio cpio: premature end of file Does anybody know what I can do to get this thing installed? I though perhaps the file was corrupted so I re-downloaded and tried it again and received the same error. Bob Little UniVerse Developer Market America 336-478-1694 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Graphic Printing
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 claims HP compatibility with PCL/5 or 6. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 04 January 2008 15:12 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Graphic Printing 1. For perhaps 20 years here we have been using HP-GL/2. What follows is the UniBasic Source Code for an example program. I believe that HP-GL/2 lives in every HP laser printer, but not on most inkjets. Thus, except for development time, HP-GL/2 is free. There is plenty of HP documentation on HP-GL/2. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] anyone seen this error before?
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 ...
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco
Sent: 27 December 2007 13:43
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] anyone seen this error before?
# cat uvcron.c
/* This c routine can be used to start universe processes
in cron or at. Normally only one process can run at a
time because they use the same printer memory segment.
simply replace the 'uv' command with 'uvcron' for example:
uvcron 'BATCH-REPORT1' dave.mail */
#define UCB 0
/* set to 0 for System V or 1 for Berkeley */
main (argc, argv, envp)
int argc;
char *argv[], *envp[];
{
if UCB
setpgrp(0,getpid());
else
setpgrp();
endif
/* CHANGE PATH TO MATCH YOUR INSTALLATION */
(void)execve(/usr/ibm/uv/bin/uv,argv,envp);
/* We should never come back here */
printf(exec failed \n);
exit(-1);
}
When I try to compile the above code I am getting the following errors:
(using both cc and gcc) on aix 5.2
# gcc uvcron.c
uvcron.c: In function `main':
uvcron.c:17: error: parse error before numeric constant
uvcron.c:25: error: parse error before void
#
My 'c' programming skills are pitiful, can anyone shed any light on the
errors and a fix?
Thanks,
Dougc
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] anyone seen this error before?
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 if and else blocks inside
curly brackets, even if they're not needed ...)
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco
Sent: 27 December 2007 13:43
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] anyone seen this error before?
# cat uvcron.c
/* This c routine can be used to start universe processes
in cron or at. Normally only one process can run at a
time because they use the same printer memory segment.
simply replace the 'uv' command with 'uvcron' for example:
uvcron 'BATCH-REPORT1' dave.mail */
#define UCB 0
/* set to 0 for System V or 1 for Berkeley */
main (argc, argv, envp)
int argc;
char *argv[], *envp[];
{
if UCB
setpgrp(0,getpid());
else
setpgrp();
endif
/* CHANGE PATH TO MATCH YOUR INSTALLATION */
(void)execve(/usr/ibm/uv/bin/uv,argv,envp);
/* We should never come back here */
printf(exec failed \n);
exit(-1);
}
When I try to compile the above code I am getting the following errors:
(using both cc and gcc) on aix 5.2
# gcc uvcron.c
uvcron.c: In function `main':
uvcron.c:17: error: parse error before numeric constant
uvcron.c:25: error: parse error before void
#
My 'c' programming skills are pitiful, can anyone shed any light on the
errors and a fix?
Thanks,
Dougc
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation
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) estimate 25% larger than the original divide by 2048 estimate. And 20-25% (depending which way you're going) is quite a big error. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 03 December 2007 10:08 To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation A first adjustment is to allow for the overhead that page and record headers and other administrative information uses e.g. divide by 2000 instead of 2048. Each page has d page header, each record as a record header there will be an 'end of item'-character at the end of each key and each record ( if not there will be pointers and/or lengths instead ) and there will be some unused characters where no record fits at the end of the page. I don't know the sizes of these things but I'd feel lucky if I had a file where they totalled less than 48bytes per page. -- mats Perry Taylor skrev: That's approximately what I did when calculating how big I needed this file, although I used the average record size rather than the total bytes since the majority of the records are less than 75 bytes with a few large records. Let's assume for argument's sake that I took the sum of the record and ID sizes and divided by 2048. The problem is I came up way short. If I query that data from the existing table here's what I get... SUM CLM.RUN.STRIP.PROVDATA EVAL LEN(@ID) AS ID BYTES FMT 10R EVAL LEN(@RECORD) AS REC BYTES FMT 10R EVAL LEN(@ID) + LEN(@RECORD) AS BYTES FMT 10R CLM.RUN.STRIP.PROVDATA ID BYTES.. REC BYTES. BYTES. == == == TOTALS5035139 17035963 22071102 719305 records summed. DIVD 22071102 2048 Decimal 10776 remainder 1854 See this is where I get into trouble. 10776 is still a far cry from 19618. What is also confusing is why ANALYZE.FILE reports such larger totals for the record and ID bytes than I get from my query. See the confusion? Thanks. Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Thursday, November 29, 2007 12:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation This is a very rough cut, but if you divide data+id bytes by 2048, you'll be in the ballpark. so... 46Mb + 5Mb = 51Mb/2048=24902 I'd pad that a bit (you don't need tightly packed files), possibly as much as 50% maybe go up to a MIN MOD of a prime near 36K. I'm assuming that disk space isn't a constraint as we're dealing with a few Mb. If you don't know what the data size will be, my admittedly subjective formula would be to divide the anticipated number of records by 10 go with a number in that range, assuming no other issues (like the # of id's is going to be 40 Billion it's a 32-bit file). In this case, you'd end up with an oversized file (MIN MOD around 72K) , but you can always adjust that if it's a problem. I don't mind oversizing nearly as much as undersizing. Subject: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation Date: Thu, 29 Nov 2007 10:13:53 -0500 From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org I continue to struggle with accurate calculation of MINIMUM.MODULUS values for dynamic files. Static hashed files do not seem to be such a challenge for me. Here is an example where, once again, I was woefully shy... --- File name .. CLM.RUN.STRIP.PROVDATA Pathname ... CLM.RUN.STRIP.PROVDATA File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 19618 current ( minimum 7867, 0 empty, 8869 overflowed, 4612 badly ) Number of records .. 719305 Large record size .. 75 bytes Number of large records 6614 Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 69978112 bytes Total size of record data .. 46331730 bytes Total size of record IDs ... 5114218 bytes Unused space ... 18528068 bytes Total space for records 69974016 bytes File name .. CLM.RUN.STRIP.PROVDATA Number per group ( total of 19618 groups ) Average Minimum Maximum StdDev Group buffers .. 1.74 1 15 1.19 Records 36.67 10 68 12.15 Large records .. 0.34 1 4 0.58 Data bytes . 2361.69 350 30359 2270.12 Record ID bytes 260.69 70 491 86.71 Unused bytes
RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation
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 with a lot of data, you can tell the system don't bother creating a small file, because it's going to grow immediately. You're best off starting with X (where X is what it's going to be when you've loaded it). A second use is where a file fluctuates rapidly in size, and you want to tell the system don't bother shrinking it, because it's going to grow again very soon. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 29 November 2007 15:39 To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation My experience seems to demonstrate that setting the MINIMUM.MODULUS to the size of the data works best, and then needs to be adjusted in much the same way a static file would need to be resized. With that said, however, for files that grow and shrink continuously during a given period, i.e. each month, I found that setting the MINIMUM.MODULUS to roughly 2/3 to 3/4 the largest size the file grew during the month to seem to allow the file to perform at a reasonable rate. This is based on trial and error. In your situation I'm hoping there are some good, hard and fast rules you can glean from this list... and good luck because I'm suspecting there aren't any because of the many and varied applications and environments involved. Karl quote who=Perry Taylor I continue to struggle with accurate calculation of MINIMUM.MODULUS values for dynamic files. Static hashed files do not seem to be such a challenge for me. Here is an example where, once again, I was woefully shy... --- File name .. CLM.RUN.STRIP.PROVDATA Pathname ... CLM.RUN.STRIP.PROVDATA File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 19618 current ( minimum 7867, 0 empty, 8869 overflowed, 4612 badly ) Number of records .. 719305 Large record size .. 75 bytes Number of large records 6614 Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 69978112 bytes Total size of record data .. 46331730 bytes Total size of record IDs ... 5114218 bytes Unused space ... 18528068 bytes Total space for records 69974016 bytes File name .. CLM.RUN.STRIP.PROVDATA Number per group ( total of 19618 groups ) AverageMinimumMaximum StdDev Group buffers .. 1.74 1 15 1.19 Records 36.67 10 68 12.15 Large records .. 0.34 1 4 0.58 Data bytes . 2361.69350 303592270.12 Record ID bytes 260.69 70491 86.71 Unused bytes ...944.44 24 2068 650.69 Total bytes 3566.83 2048 30720 0.00 Number per record ( total of 719305 records ) AverageMinimumMaximum StdDev Data bytes . 64.41 34 28700 353.25 Record ID bytes 7.11 2 20 1.14 Total bytes 71.52 36 28720 354.13 --- I cannot seem to figure out the relationship of the current modulus to the record sizes/counts/group size factors. When I do the math I always come up short. Can someone offer some suggestions for accurate calculation of MINIMUM.MODULUS? Thanks. Perry Taylor ZirMed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl
RE: [U2] Badly overflowed Dynamic files
The resize SHOULDN'T (I don't think) have had any effect. Reducing the split percent will have made all of your groups smaller. That will have had various side-effects - reading and writing individual records in overflowed groups will be quicker, fewer records will be in overflowed groups, and splitting overflowed groups will be quicker because they're smaller. That's still quite a result though - your file will have grown about 15% and it's lopped 90% off the run time! Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Smith Sent: 29 November 2007 16:10 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Badly overflowed Dynamic files I don't know if changing my the split load from 80% to 70% or if running a RESIZE [filename] DYNAMIC command (or both) did the trick, but one of the 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.u2ug.org Subject: RE: [U2] Badly overflowed Dynamic files 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. Or change it away from a dynamic file to a hash-type that better suits your keys. If it grows steadily, try REDUCING your split figure - maybe 70%. Again, that will increase the number of groups, and hopefully reduce your number of overflowed groups. Lastly, I was going to suggest looking at your block size and large records, but I notice you don't have any. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Deep and long indentations vs multiple exit points
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 28 November 2007 16:18 To: u2-users@listserver.u2ug.org Subject: [U2] Deep and long indentations vs multiple exit points There has been a lot said recently about styles, standards and good practice and I wonder what your take is on deeply indented routines with a common exit point versus unindented routines but with multiple exit points. I almost always prefer the later and find it much easier to follow. I come accross several routines or GOSUBs that get indented from line 1 right up to the end and I always change that to an early return and remove the indentation. Below are some examples: PROCESS.ID: READ RECORD FROM FILE, ID THEN * Several lines of indented code to calculate DESIRED.VALUE IF RECORDFIELD.NO EQ DESIRED.VALUE THEN * Several lines of even more indented code END END RETURN versus: PROCESS.ID: READ RECORD FROM FILE, ID ELSE RETURN END * Several lines of unindented code to calculate DESIRED.VALUE IF RECORDFIELD.NO NE DESIRED.VALUE THEN RETURN END * Several lines of unindented processing code RETURN Or LOOP READ RECORD FROM FILE, ID THEN IF RECORDFIELD.NO EQ 1 THEN * Processing code END END REPEAT UNTIL SOMECONDITION Versus: LOOP READ RECORD FROM FILE, ID ELSE CONTINUE END IF RECORDFIELD.NO NE 1 THEN CONTINUE END * Processing code REPEAT UNTIL SOMECONDITION ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Badly overflowed Dynamic files
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. Or change it away from a dynamic file to a hash-type that better suits your keys. If it grows steadily, try REDUCING your split figure - maybe 70%. Again, that will increase the number of groups, and hopefully reduce your number of overflowed groups. Lastly, I was going to suggest looking at your block size and large records, but I notice you don't have any. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kevinsmith Sent: 27 November 2007 14:59 To: u2-users@listserver.u2ug.org Subject: [U2] Badly overflowed Dynamic files I have yet to find someone who can give me a straight answer to this. I have a file that is badly overflowed (actually, I have a few files this way). It is affecting our batch processing with ridiculous complete times. What would be the best way to increase performance with this file. Do I increase the split load so that splits occur less frequently? Any assistance would be greatly appreciated. Thanks, Kevin The stats of the file: File name .. STOCK Pathname ... STOCK File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 777564 current ( minimum 1, 14835 empty, 247100 overflowed, 28403 badly ) Number of records .. 4770913 Large record size .. 1628 bytes Number of large records 8 Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 2185496576 bytes Total size of record data .. 1253392129 bytes Total size of record IDs ... 32664403 bytes Unused space ... 899435948 bytes Total space for records 2185492480 bytes File name .. STOCK Number per group ( total of 777564 groups ) AverageMinimumMaximum StdDev Group buffers .. 1.37 1 4 0.53 Records 6.14 1 26 3.55 Large records .. 0.00 1 1 0.00 Data bytes . 1611.95194 6893 936.26 Record ID bytes 42.01 4179 24.39 Unused bytes ... 1156.74 12 3560 576.33 Total bytes 2810.69 2048 8192 0.00 Number per record ( total of 4770913 records ) AverageMinimumMaximum StdDev Data bytes .262.72184 2061 25.79 Record ID bytes 6.85 4 15 0.40 Total bytes 269.56188 2076 25.93 -- View this message in context: http://www.nabble.com/Badly-overflowed-Dynamic-files-tf4880009.html#a13965441 Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OCONV Extraction Question - Best Practises
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 is actually frowned on in ANY programming language, I believe. And my personal reason for disliking it, over and above the previous - it takes two lines where one would do. Okay, compressing code for the sake of it can hinder comprehension, but I like tight, compact code with white-space separating small sections, not individual sections full of white space... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: 19 November 2007 15:18 To: u2-users@listserver.u2ug.org Subject: RE: [U2] OCONV Extraction Question - Best Practises It's JUST a preference, presently I know we all reach for a good balance between brevity and clarity. I have some preferences too which I think are ideal, which seem less than ideal to others. ... but rather than mount my own hobby horse I have a suggestion / question that could put these types of exchanges to rest: WHAT IF - the U2UG took it as a future project to compile a Best Practices coding guideline document for our language? There's always helpful 'How to' stuff exchanged here. ...but style question sometimes spiral downward. As someone pointed out recently, we have the blessing and curse of using a rather free style language. Not much Structure-Style is not imposed by the construct of the language itself, like some others. Is it time to codify some best practices relating to structure, modularity, reuse, length of internal subs, etc? I may not like some of the resulting definitions myself but it would build cohesion and greater respect for the MV space. Another thing it would do is chart a clearer path for those coming behind us - we need new blood if the VARs in this space are going to continue to sell/support embedded MV apps. I would personally find it fascinating to see some of our venerable coders get together and see what they produced along this line. I have some names in mind but I'll wait for the nominations to officially open. Happy Thanksgiving. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Saturday, November 17, 2007 12:58 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OCONV Extraction Question According to who? I know there are some pluses and minuses but where is this decided or is it just a preference. Thanks Mark Johnson - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, November 16, 2007 11:30 AM Subject: RE: [U2] OCONV Extraction Question Speaking of mis-used commands and side-stepping some of the given code craziness... It is better practice to atomize the code into discrete elements such as... Var1.F = oconv(Var1, 'MD0') crt Var1.F 'R#11' rather than to try to kill two birds with one stone by including an oconv statement inside a crt statement such as... crt oconv(Var1, 'MD0') --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MAJ Programming Sent: Friday, November 16, 2007 12:48 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OCONV Extraction Question This is real smart, making things harder than they should be. Just use . Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, November 14, 2007 5:23 PM Subject: RE: [U2] OCONV Extraction Question Didn't work for me either. It may not fit what you need, but SWAP can make it work. VAR1 = 'SAM':@VM:'TRUDY' SWAP @VM WITH '*' IN VAR1 FMTSTR = 'G*1' CRT OCONV(VAR1,FMTSTR) Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list
RE: [U2] Stringing commands together on the command line. Possible?
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, if you can't write to the dictionary, you shouldn't be able to do an EVAL. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 29 October 2007 07:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Stringing commands together on the command line. Possible? Yes, I wondered the same thing... EVAL is designed to emulate an I-type dictionary item. Hence, will only execute any command that you can successfully compile within an I-type. So it wouldn't allow what you have in your example. You'd need a subroutine that could execute via EVAL to invoke a TCL or OS command indirectly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Monday, October 29, 2007 6:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Stringing commands together on the command line. Possible? Don't have access to UV at present, but wonder if the following INPUT would do the trick ' AND WITH EVAL EXECUTE 'CLEAR.FILE CLIENT' = ' Ross Ferris Stamina Software Visage Better by Design! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] help!
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 chanco Sent: 08 October 2007 15:24 To: u2-users@listserver.u2ug.org Subject: [U2] help! I am unscribed from this list with my work address ([EMAIL PROTECTED]) BUT I am still getting emails .. I even emailed majordomo the which command (from my work address) and it says that I am NOT subscribed to any lists BUT yet I am still getting emails and when I try to email the list from my work account it bounced back to me because it says I am not a member of the list and yet I still get emails! help! I still want to receive thsi on my home account, I just need to stop receiving it on my work email ([EMAIL PROTECTED]) thanks! dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2U London
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 within lurching distance (iirc it's 15 minutes brisk walk, if that). Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 26 September 2007 14:11 To: u2-users@listserver.u2ug.org Subject: [U2] U2U London Fellow Brits Since we don't get the convenience of a hotel location for the 'London' U2U sessions, does anyone know of a convenient hotel in lurching distance from IBM? Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Internal Cache in Unidata
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 is only accessing one file, I'd write a little macro in ED to just pull in every record in the file, and then see if your query flies the first time. If it does fly (and if you're on Unix that's especially likely) then it's down to OS caching, not UniData. Certainly when I tried writing the file access code for MaVerick, I deliberately ignored caching the files on the basis that linux would do a better job than I could ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: 24 September 2007 13:34 To: u2-users@listserver.u2ug.org Subject: [U2] Internal Cache in Unidata Can anyone speak factually about internal cache in Unidata? In short... I often look at performance and attempt to improve things by changing queries, using indicies, rewriting source and so on. In doing so I perform timing and consistently note that the second time a query is performed, it executes considerably faster than the first. As an example, here's the first execution of a series of queries: SELECT H08.CR.DIV.DATA WITH XCDD.HAMP.CMTE.MEMBER=0202736 time=18ms SELECT H08.CR.DIV.DATA WITH XCDD.DIV EQ D2 time=988ms SELECT H08.CR.DIV.DATA WITH XCDD.REV EQ P time=5ms And then immediately peforming these again: SELECT H08.CR.DIV.DATA WITH XCDD.HAMP.CMTE.MEMBER=0202736 time=18ms SELECT H08.CR.DIV.DATA WITH XCDD.DIV EQ D2 time=9ms SELECT H08.CR.DIV.DATA WITH XCDD.REV EQ P time=5ms To be clear - the difference between 988ms and 9ms is not a typo, it's real. Likewise this is not the result of server load. I can consistently reproduce the above scenario with different queries at different times of the day (and wee hours of the morning with few users). I'm not complaining - it's a perfectly good feature - it's just hard to get accurate timings on things so I often perform queries numerous times and dump the first few executions. Of course, this isn't reality as many queries only get executed once in a blue moon... -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Mom - Daddy knows everything. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Binary data corruption on copy
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 store these files efficiently in a directory. Look at the various filesystems available - they may be optimised to do just what you want. In the linux world, reiserfs is apparently very good at handling thousands of small files such as a mail or news spool. And I've heard of at least one project to handle directories as hashed files (I don't know any more about that, though). There might well be something out there that stores the directory listing as a btree or somesuch that's efficient. Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 22 August 2007 14:23 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Binary data corruption on copy Universe doesn't have the noconvert command. -Original Message- From: David A. Green [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 8:06 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Binary data corruption on copy Harold, In UniData you would store your binary files in a DIR type file. When you need to read the data you would first issue the NOCONVERT ON Command to keep the auto conversion of Nulls to CHAR(128) from happening. Thanks, David A. Green DAG Consulting 480-813-1725 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] IBM - Windows Vista Support with U2 products
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 -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 14 August 2007 14:36 To: u2-users@listserver.u2ug.org Subject: RE: [U2] IBM - Windows Vista Support with U2 products I heard on the radio this morning that Microsoft is going to announce a whole slew of security breaches on the new operating system today. -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 6:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] IBM - Windows Vista Support with U2 products G'day Chuck! Yes, I am successfully running Universe on a Windows Vista box :-) For a small consulting fee ... Ahhh, what the heck -- C H E A T ! Load up a copy of Virtual PC with Windows XP you are in business - will also let you run the 70% of other Windows programs that don't work with Vista (I even have to use it to access Outlook! Vista doesn't like something in my 3Gb profile, and I'm not inclined to find out what) It is interesting that even products like IE7 behave differently under Vista than XP - some of it is esoteric, but you know how we like to push the boundary. HTH Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, 13 August 2007 3:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] IBM - Windows Vista Support with U2 products All, Is anyone running UniVerse PE successfully on Vista? I just bought (against my will) a Vista Home Premium system. PE installs and the shell works, but I don't seem to be able to create accounts or telnet to it. All help appreciated. http://www- 1.ibm.com/support/docview.wss?rs=629context=SSCRY4dc=D600uid=swg2125 4 814loc=en_UScs=UTF- 8?=enrss=ct629db2_DARGS=/template_parts/template_U2.jhtml_A_DAV= http://www- 1.ibm.com/support/docview.wss?rs=629context=SSCRY4dc=D600uid=swg2125 4 814loc=en_UScs=UTF- 8lang=enrss=ct629db2_DARGS=/template_parts/template_U2.jhtml_A_DAV= - Charles Barouch [EMAIL PROTECTED] Consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Getting current SETPTR values
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 by SETPTR, especially the destination without parsing the results of the ECL command? I have noticed that the format of the output of the SETPTR command is not consistant, making parsing difficult. -- Important Manager : Hello, is that the chief neologist? Chief neologist : Yes, speaking. IM : I need a new word to replace implement in I.T. system. CN : Yes, far, far too wordy a phrase. IM : And too accurate! I need something dynamic, but vague, something that people wont know how to pronounce when they see it written. CN : Let me think ... how about, ititize? Like dramatize but with I.T.? IM : Brilliant! CN : And the beauty part is you get ititization or itism for free! -- * This message has been scanned for viruses and dangerous content by * Blairs MailScanner, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs * via email at [EMAIL PROTECTED] * * Name Registered Office: * -- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Cleaner Case Statement
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 X is some complicated expression. I prefer to write X in whatever manner is most easily understood (and that does not include a gratuitous negate), then use THEN or ELSE as appropriate. Cheers, Wol -Original Message- From: SP [mailto:[EMAIL PROTECTED] Sent: 03 August 2007 09:03 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Cleaner Case Statement The code should be easy to understand. Yes. we can figure out a lot of stuff but if making the next guy to stumble over each line having to figure it out is not very professional. - Original Message - From: Symeon Breen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, August 03, 2007 7:44 AM Subject: RE: [U2] RE: Cleaner Case Statement Come on guys 'IF X ELSE blah' - is it really that bad/hard - it is logic and we are computer programmers, we should be able to figure out a lot tougher stuff than that ;) Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: 03 August 2007 01:32 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Cleaner Case Statement Then you must have the luzury of programming from scratch. I support roughly 15 clients worth of software written in various platforms with some source code stretching as far back as 1974. Yes, 33 year old code. I certainly program from scratch as well. But the incredibly large installed base uses IF X=1 THEN GOSUB 100 instead of the ALL_OK=X=1 then IF ALL_OK THEN DO_SOMETHING Again, don't read into the literal nature of the example. The deviated topic was avoiding the ELSE as the first condition in IF X=100 ELSE GOSUB 100 which is historically inconsistent. My 1 cent Mark Johnson - Original Message - From: Jeff Flynt [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, July 31, 2007 10:14 PM Subject: RE: [U2] RE: Cleaner Case Statement I typically use the full form of each structured statement and lay it out in the indented format. This is just coding laziness since I hate having to go back and add that missing branch of an if statement when I am 500 lines of code into it and several indent levels deep. This includes using the default branch of a case - the old fashioned CASE 1 clause. How I do it differently is in the wording. I like my code to be self documenting and consistent. Using a variable such as X and a label such as 100 is definitely a little dated. I used to, in the old days, create an equate for TRUE and set it to 1 = 1. And I would equate OTHERWISE to TRUE. I then have a CASE OTHERWISE, and I always have a CASE OTHERWISE on every case statement - even if it had no action. These days, I get lazy and just use CASE @TRUE since it would be an arrogant assumption of me to assume that 1 is true. At best it is very old school and poor form. But having the CASE @TRUE branch there is my signature; Coding every structured path is my style. On the other hand, while I don't do this a lot, I don't have any problem with the using the form IF X = 1 ELSE GOSUB 100 type statement. I do think it is dreadfully cryptic. I seriously hate dealing with this kind of code. What is X? What is 100? YIKES! And I like to avoid single use subroutines/GOSUBs when possible - not because they are inherently bad, but because they are parameterless and if you use it once why complicate the issue? I usually just put the code inline, but I occasionally don't if it would improve the self documenting nature of the code. Anyway, if X were a status code say, and we wanted to watch for a status of 1 I might do something like this: ALL_IS_WELL_PROCEED = X = 1 ; * This X business is just to match the previous example. ... Some code goes here including possibly status code ALL_IS_WELL_PROCEED updates ... IF ALL_IS_WELL_PROCEED ELSE GOSUB HANDLE_PROBLEM To me that reads like instructions to bake a cake, and anybody can see the intension. I do not have to have a degree in cryptography to read this regardless of how I set it up. It is 1,000,000 times easier to read then the suggested alternative IF X#1 THEN GOSUB 100 or IF X=1 ELSE GOSUB 100. Both are equally despicable. Either way the code is so obfuscated it is to be avoided at all cost! So why argue about how many angels can dance on the head of a pin when you cannot see the mountains in your molehills? It's like, is it better to pick you nose in public with your right hand or your left hand...? So, while I jest about this, I do have an ounce of seriousness about it. Everybody is so my way is better... And it just isn't. I include my
RE: [U2] EXECUTE environment in Universe
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 suspect that PERFORM *always* does a PI-style execute. I think PERFORM stays in the calling program's exec level, while EXECUTE by default creates a new one. 2. Look at rewriting your code something like EXECPHRASE = PA :@FM: SELECT ... :@FM: PRINT BACKORDER.REPORT PERFORM EXECPHRASE That way, you're guaranteed stable behaviour of select lists, etc etc. But if you're porting code, it looks like you're relying on PI-style executes, so setting PIOPEN.EXECUTE is unlikely to be a problem. Cheers, Wol -Original Message- From: Dave Greer [mailto:[EMAIL PROTECTED] Sent: 03 August 2007 14:41 To: U2-Users (E-mail) Subject: [U2] EXECUTE environment in Universe Is there a configuration setting or $OPTIONS routine, other than $OPTIONS PIOPEN.EXECUTE, that keeps select lists active when an Execute command is run? Our software package uses basic programs with execute statements rather than procs to run reports. An example might be something like the following: EXECUTE 'SSELECT ORDER WITH B/O.FLAG Y BY CUSTOMER BY DUE.DATE' CAPTURING REPLY RETURNING MSG IF SYSTEM(11) = 1 THEN EXECUTE 'PRINT BACKORDER.REPORT' END I'm afraid of the unintended consequences of using PIOPEN.EXECUTE because EXECUTES are used throughout hundreds of programs and many include named common variables. _ Dave Greer Director of Information Systems NewAge Industries AdvantaPure http://www.newageindustries.com/images/nalogo.jpg NewAge Industries, Inc. [EMAIL PROTECTED] www.newageindustries.com http://www.newageindustries.com/ 215.526.2300 PHONE 215.526.2191 FAX http://www.newageindustries.com/ Notice: If you are not the named recipient of this transmission, please notify us immediately, by telephone, and delete or destroy any copy of this message. You should not disclose or use this information in any way. Disclosure or use of this information may expose you to criminal or civil liabilities. We apologize for the inconvenience and thank you for your attention to this notice. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
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 about the implementation, any benchmark is valid for that one configuration only. Cheers, Wol -Original Message- From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED] Sent: 16 July 2007 19:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance Read Codd and Date's rules. Can't remember which, but one of them says the database user is not permitted to know how the database stores the data. In other words, empirical testing is FORBIDDEN. Seeing as empirical testing is *the* sine qua non of science, relational databases are, BY DEFINITION, totally unscientific. So, if you want a benchmark, relational database theory explicitly says No way, Jose! !!! How does not being able to know how the data is stored prohibit empirical testing? As long as you can provide inputs to a system and retrieve outputs you can perform empirical tests. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
I understand your desire for a black box. The problem arises when your black box is upgraded. I've come across anecdotes of eg Oracle upgrades, where new software has resulted in a markedly slower system, because Oracle changed their data storage, or indexing, or something, and all the app's assumptions suddenly became wrong. That, basically, is the problem with the black box approach. And the relational model says you're not allowed to do it any other way. You're not allowed to look behind the curtain. In other words, you're not allowed to empirically test the WHOLE system (ie inside the black box). At least with MV, while we may not care to look behind the curtain, we are welcome to do so, and to prove that we have the fastest possible implementation. As a scientist by training I *DO* *NOT* like being told look, just use it, it works. You don't need to understand it. All too often I end up getting badly bitten when that happens... Cheers, Wol -Original Message- From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED] Sent: 17 July 2007 15:58 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance I don't have any idea what you are trying to say. A database should be a black box. You put data in and pull data out. The less you have to know about the details of what goes on inside, the better. You can easily benchmark two black box systems that perform the same function (with unknown implementations), and the results 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 all (similar?) implementations. Because relational forbids knowing anything about the implementation, any benchmark is valid for that one configuration only. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Conversion code for week number
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: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Conversion code for week number Finally, what is the calculation that MV uses for its internal dates? (Don't bother telling me the base date, what's the calculation? I don't think it's Thirty days hath September...) I've heard it called Zeller's Congruence and I've looked it up but didn't get the direct connection to how our dates are incredibly fastly derived/converted. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe and virtual machines
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 most of them use git as the back-end so you might well find that one person can use subversion, another DARCS, another Cogito, and they're all happy accessing the same GIT backing store. I haven't got round to installing git on gentoo yet - that's a project for as soon as I can find the time ... :-) Cheers, Wol -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: 10 July 2007 11:35 To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] Universe and virtual machines Eugene I do all my development work on Microsoft Virtual PC (in fact going back to when it was owned by Connectix). It is solid. If you're using this for local copies, remember to also have some form of source control system in place. I'd recommend SubVersion with TortoiseSVN windows explorer integration: very simple. You can read about this in the next issue of Spectrum. Regards Brian REPOSTED FOR NON-MEMBER ADDRESS: Eugene Perry [EMAIL PROTECTED] [Bounce notice: Eugene, Your recent post to our lists bounced because either you are not a member or because you are not signed up using the e-mail address which you used to post. To subscribe or resubscribe please visit http://listserver.u2ug.org/. You aren't subscribed to U2-Community under this name.] Hello, I would like to be able to create virtual machines on a Windows server and run Universe and Redback on the virtual machine. Is anyone doing this now. Currently we are stepping each others toes as we are wanting to work on the same program at the same time. My idea is to create virtual machines so that we can work on the copies of the same program and interface to redback. Since each virtual machine would be running universe as well as redback we should be able to get more work done since this is our major bottleneck. I am interested in hearing of any experiences with this method. Thanks Eugene --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Issue with installing UniVerse on Linux
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 off, and SuSE was vice versa or the whole lot was vice versa :-) If IBM haven't explicitly said Ubuntu is supported, this might be the problem - certainly sounds like it, but I would have thought it would have sorted itself out by now ... Cheers, Wol -Original Message- From: Doug Chanco [mailto:[EMAIL PROTECTED] Sent: 10 July 2007 15:30 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Issue with installing UniVerse on Linux My guess is that you did not download a complete tar file (maybe something happened during the download) are you using download director to download or manually downloading it? Also make sure that tmp has enough free space (this would be the first thing I would check) that may be why cpio stops (full file system) Dougc _ Doug Chanco Engineer Developer Senior, TLOTLD Activant Solutions Inc.(tm) Austin, Texas 78746 T: 800-678-5426 F: 512-278-5915 E-mail: [EMAIL PROTECTED] Web site: www.activant.com _ -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Trevor McNamara Sent: Monday, July 09, 2007 7:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Issue with installing UniVerse on Linux Hi, I'm having some issues with installing UniVerse on an Ubuntu machine. I have everything in the /tmp/uv directory, so the listing is like this:- CONNPL CVTB DEVELOP DOC FILESIZE GCI IC JDBC MAIN NETWORK NLS OBJ PORTING QA STARTUPUCI UOJ UVODBC uv.load When I run ./uv.load it runs, i select option 1 (Install as root), then it prompts for the settings, which i change option 4 and 5 to /tmp/uv So looks like this:- _ UniVerse Installation Options The current settings of the available options are: UniVerse installer: root UniVerse administrator: root uid=0 gid=0 1) UniVerse home directory: /usr/ibm/uv (currently: Not Installed.) 2) UniVerse-UniData shared directory: /usr/ibm/unishared (currently: Not Installed.) 3) Compile terminfo definitions: true 4) Rewind tape name /tmp/uv 5) No-rewind tape name/tmp/uv 6) Long File NamesOFF _ When i press enter to begin installing it comes up with the following:- _ User uvsql will inherit ownership of the SQL catalog. Downloading from /tmp/uv to /usr/ibm/uv Now loading uniVerse from the install media... cpio: premature end of file Unable to read installation media. Contact your IBM support representative. _ I have created the uvsql and uvadm users. I have also tried burning it all to cd and running it from there, which produced the same results? Anyone got any ideas? Thanks Trev --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Phantom Credentials
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 problem - our backup script on our servers had its own
drive mappings. Our dear consultant (until we screamed at him once we
realised what was happening) had this nasty habit of (a) using our
server as his personal workstation, and (b) forgetting to log off. The
ramifications were many and annoying, including such things as failed
backups...
Anyways. You have to have a policy saying that either (a) THIS is the
set of drive mappings on the server and THEY MUST NOT CHANGE, OR (b)
every process needs to set its own drive mappings on login, and every
process needs to be aware of every other process that does this to avoid
a collision, and no users are to leave the console logged in to mess
things up.
Your call ...
Oh - by the way - stick a net use disconnect whatever the syntax is
before every connect. That way, at least if there's no-one logged in
holding the drive, you'll get rid of whatever setting it's been left at.
Otherwise, if they did a remember this setting, your process will load
their mapping, then your explicit mapping will fail with drive letter
already in use.
Cheers,
Wol
-Original Message-
From: Bill Haskett [mailto:[EMAIL PROTECTED]
Sent: 06 July 2007 09:56
To: u2-users@listserver.u2ug.org
Subject: [U2] UD Phantom Credentials
A look at Google tells me this is some kind of drive mapping problem
associated with a possible conflict with non-administrator
users and the net use command. It so happens that I've mapped an ftp
server's drive onto the UD server (Windows) as the N:\
drive. To get UniData to use this shared directory, on the other
server, I have to insert
!net use N: \\sftpserver\ftpdir {password} /user:{sftpserver\userid}
...into the LOGIN paragraph (it appears this has to be run at each
invocation of a UD shell, aka UD login). I then create a (VOC)
entry:
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic developments reverse engineering tool ?
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 whatever. What the User Group must NOT do (unfortunately) is to copy the code from the email into a repository :-( This would raise a massive can of worms :-( When did the US sign Berne? Things were a lot easier for USians (not us Europeans) before then. An alternative (should someone care to volunteer!) is to maintain an index on the u2ug website pointing at a repository that stores the emails. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 June 2007 22:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic developments reverse engineering tool ? Other user groups that I belong(ed) to provide(d) a repository for user submitted utilities. Things like neatly formatted file ACL's, tape listings, database copy routines, etc Each submission would include the utility's documentation, source code, any ancillary files (db) and executable if applicable. I am sure that there is a wealth of end user utilities available for U2. This source code listing program would be a great start. Since our software vendor does not provide any technical documentation about their system, the sort of cross-reference source code tool features mentioned by Susan is something I would find very usefull. Currently, I just save any emails from this group that have useful proc's or commands. Searching the archives is usefull but an index of software utilities by category might be a better way to help fledging U2 programmers see how to accomplish certain tasks. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Phantoms not working
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- From: Moderator [mailto:[EMAIL PROTECTED] Sent: 28 June 2007 15:06 To: DMeerholz; u2-users@listserver.u2ug.org Subject: [U2] Phantoms not working REPOSTED FOR NON-MEMBER ADDRESS: DMeerholz [EMAIL PROTECTED] Hi, Anyone got any ideas what the problem here could be? I installed uniVerse on a FedoracCore 6 box the other day, got everything working fine... I thought, until i realised today that the phantoms aren't running. I have a little BP program TEST.XXX, only code in it is PRINT 1, compiled and cataloged. PHANTOM TEST.XXX This is the output in the PH file. LIST.ITEM PH LIKE ...XXX... 03:43:59pm 28 Jun 2007 PAGE1 001 Unable to execute the operating system file bin/uv. 002 [ENOENT] No such file or directory 1st I thought I just need to add the /usr/ibm/uv path to my global paths for linux, but checked another box and it wasnt part of the paths. Then I thought permissions, but permissions on the file are exactly the same a the working box. I then tried making a little script that would send it straight to /usr/ibm/uv and execute bin/uv like it seemed it was trying to do... I placed this in the account that I was running the program, but then the phantom basically starts a session for you... PH output... LIST.ITEM PH LIKE ...XXX... 03:43:52pm 28 Jun 2007 PAGE1 TEST.XXX_48815_14424 001 UniVerse Command Language 10.1 002 (c) Copyright IBM Corporation 2003. All rights reserved. 003 uv logged on: Thu Jun 28 13:33:35 2007 005 So thats not it either... Anyone got any ideas what is wrong? Thanks. BOUNCE NOTICE: Your recent post to our lists bounced because either you are not a member or because you are not signed up using the e-mail address which you used to post. To subscribe or resubscribe please visit http://listserver.u2ug.org/. - Charles Barouch, Moderator U2-Users, U2-Community, SBSolutions, RBSolutions --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV [not-secure]
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 [mailto:[EMAIL PROTECTED] Sent: 27 June 2007 16:20 To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
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 @SYSTEM.RETURN.CODE *IS* the number of records selected. Thing is, you're asking it to count records multiple times if the same record appears multiple times in the select list. Let's say we have 10 records, half of them with two items in an MV field, and the rest with just one. Am I correct in thinking that, if you do a SELECT BY.EXP, the @SYSTEM.RETURN.CODE is 10, the number of *records* selected, while SYSTEM(11) is 15, the number of *items* in the select list? Hope this clarifies things :-) Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 26 June 2007 14:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly To David A. Green, who said, SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected. @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 anything like that ... (and never bothered to update PARTFILES either :-) Where does it store the pointer to the master file? Field 2 of the VOC is just a multi-value list of the relevant partfiles ... Cheers, Wol -Original Message- From: Clifton Oliver [mailto:[EMAIL PROTECTED] Sent: 21 June 2007 18:01 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Trigger(s) on distributed file Just a point of technical correction. The master does exist as a physical file, type 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 like that) on the master, because it only exists as a record in PARTFILES). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Trigger(s) on distributed file
Then things really are confusing ... I'm talking about the file-type introduced by Prime, and officially managed using the DEFINE.DF command. By multi-part, do you mean the Pick style NEW.ACCOUNT,PIOPEN type file? I'm certainly not thinking of those - they were never in PI and I've never had cause to use them. I wouldn't presume to know anything about them. Distributed files, as known on Prime, never to my knowledge had any physical existence other than as individual part-files. As far as I was aware, the UV implementation had similar characteristics ... Cheers, Wol -Original Message- From: phil walker [mailto:[EMAIL PROTECTED] Sent: 22 June 2007 10:02 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Trigger(s) on distributed file Wol, I think you are confusing multi-part files with distributed files. Cheers, Phil -Original Message- From: [EMAIL 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 anything like that ... (and never bothered to update PARTFILES either :-) Where does it store the pointer to the master file? Field 2 of the VOC is just a multi-value list of the relevant partfiles ... Cheers, Wol -Original Message- From: Clifton Oliver [mailto:[EMAIL PROTECTED] Sent: 21 June 2007 18:01 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Trigger(s) on distributed file Just a point of technical correction. The master does exist as a physical file, type 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 like that) on the master, because it only exists as a record in PARTFILES). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Trigger(s) on distributed file
Odder and odder. I don't ever remember seeing a file at OS level with the name of a distributed master file. PI *or* UV. As implemented by Prime, iirc, any partfile could be used as a master to get the algorithm definition etc, and you were warned that a VERY QUICK way to corrupt your distributed file was to use FORCE with DESIGN.DF unless you knew exactly what you were doing - precisely because a part file could belong to multiple masters and if the masters weren't in sync the result was a terrible mess... Cheers, Wol -Original Message- From: phil walker [mailto:[EMAIL PROTECTED] Sent: 22 June 2007 11:20 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Trigger(s) on distributed file Sorry Wol, Yes, I did think you meant the Pick style multi-part, sorry about that. But as far as the distributed files as managed by DF they have always had a master file of type (27 or 41 - cannot remember which ) which was basically just a header and I think had the algorithms etc in them. Dave Meeks or Glenn Herbert could probably confirm if they are still around. Palmer Chapelle was the engineer who had most input in implementing them in UV from PI. Cheers, Phil -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 introduced by Prime, and officially managed using the DEFINE.DF command. By multi-part, do you mean the Pick style NEW.ACCOUNT,PIOPEN type file? I'm certainly not thinking of those - they were never in PI and I've never had cause to use them. I wouldn't presume to know anything about them. Distributed files, as known on Prime, never to my knowledge had any physical existence other than as individual part-files. As far as I was aware, the UV implementation had similar characteristics ... Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Trigger(s) on distributed file
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 loop through the list of partfiles and create an index on each individual partfile. The same is likely to be true of triggers. Where this WILL bite you, is when you create a new partfile. By default, it won't have any indices, or triggers, or whatever. You'll need to add them to that partfile. So - the situation with indices (and probably triggers etc) is that creating them on the master is a legit thing to do. But under the covers it is actually doing it to each individual partfile. So when you add a new partfile, they won't get automatically added to the new partfile. Cheers, Wol -Original Message- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: 21 June 2007 04:29 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Trigger(s) on distributed file Just to check as I couldn't find doco on it - Do I create triggers on each part of a DF? Or is there a way to have the trigger on the master? Cheers, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV HASH.HELP error
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 it and see Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 20 June 2007 15:12 To: u2-users@listserver.u2ug.org Subject: [U2] UV HASH.HELP error Sorry I forgot the subject line the first time. I've also tested this on our Linux system running the same revision with the same results. Jerry -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 20, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: I just came across what may be a bug in HASH.HELP. I ran HASH.HELP on a static hash file and it told me the smallest modulus should be 80015 (yes, not a prime number), smallest separation or 4, and the best type of 10. I then ran HASH.HELP.DETAIL on the same file and got 80021, 4, and 18 respectively. In this second case the modulus is a prime number. No changes were being made on the system because it is our test system and I was the only one on it at the time. This was on Solaris 8 running Universe 10.1.12 in Reality flavor. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
