[U2] Indexes on distributed files
Hi, I having the following problem with indexes on a distributed file Scenario - I have a distributed file split by years - 1997 (1) 1998 = 2 1999 = 3 I create an index on the main file, and build the index (this creates index files for each part file on the filesystem) Now i'm trying to do a bscan on the main file, using the USING clause (with the index I just created) and I'm getting a status error 3 - (file is not a type 25, or no secondary indices defined) The platform is Universe 9.6.2 - UNIX Can BSCAN's be done on a main controlling file for a distributed file, if so how ? Thanks Mac -- 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/
RE: [U2] Indexes on distributed files
Unfortunately, BSCAN is not supported on distributed files in UniVerse. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: Wednesday, March 22, 2006 5:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] Indexes on distributed files Hi, I having the following problem with indexes on a distributed file Scenario - I have a distributed file split by years - 1997 (1) 1998 = 2 1999 = 3 I create an index on the main file, and build the index (this creates index files for each part file on the filesystem) Now i'm trying to do a bscan on the main file, using the USING clause (with the index I just created) and I'm getting a status error 3 - (file is not a type 25, or no secondary indices defined) The platform is Universe 9.6.2 - UNIX Can BSCAN's be done on a main controlling file for a distributed file, if so how ? Thanks Mac -- 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/ 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/
RE: [U2] Indexes on distributed files
Mac, If the index value you are wanting to lookup is the exact value in the record you can use SELECTINDEX. However, you cannot do partial matches this way. For example, let's say you have an index on LAST.NAME in the CUST file, and you are looking for any records with the last name of TAYLOR... OPEN 'CUST' TO F.CUST ELSE STOP 201,'CUST' SELECTINDEX 'LAST.NAME', 'TAYLOR' FROM F.CUST LOOP WHILE READNEXT CUST.ID DO ... REPEAT But if you wanted to get any cust record with LAST.NAME starting with T. You cannot use SELECTINDEX and will have to query instead... OPEN 'CUST' TO F.CUST ELSE STOP 201,'CUST' EXECUTE 'SELECT CUST WITH LAST.NAME T]' CAPTURING OUTPUT LOOP WHILE READNEXT CUST.ID DO ... REPEAT Your only other option is to write logic that will query each individual part file and collate the results... Not a trivial routine. You might contact IBM/U2 Professional Services. Mark Baldridge wrote something that does this very thing and you probably can get it from them. Hope this helps some. Perry -Original Message- From: Mac Bhyat [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 22, 2006 7:21 AM To: Perry Taylor Subject: RE: [U2] Indexes on distributed files Hi, Thanks for the reply - do you know how I can use indexes on distributed files ? Thanks Mac -Original Message- From: Perry Taylor [mailto:[EMAIL PROTECTED] Sent: 22 March 2006 04:06 PM To: Mac Bhyat; u2-users@listserver.u2ug.org Subject: RE: [U2] Indexes on distributed files Unfortunately, BSCAN is not supported on distributed files in UniVerse. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: Wednesday, March 22, 2006 5:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] Indexes on distributed files Hi, I having the following problem with indexes on a distributed file Scenario - I have a distributed file split by years - 1997 (1) 1998 = 2 1999 = 3 I create an index on the main file, and build the index (this creates index files for each part file on the filesystem) Now i'm trying to do a bscan on the main file, using the USING clause (with the index I just created) and I'm getting a status error 3 - (file is not a type 25, or no secondary indices defined) The platform is Universe 9.6.2 - UNIX Can BSCAN's be done on a main controlling file for a distributed file, if so how ? Thanks Mac -- 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/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ 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/
Re[2]: [U2] Basic statement
Ross, only a victim if you want to be or believe yourself to be 'victim' (i knew the new listserver rules were a conspiracy to get me) rotfl dsig Tuesday, March 21, 2006, 3:34:08 PM, you wrote: RF Another victim of the new list and not doing a reply all :-( RF Ross Ferris RF Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Barry Rogen Sent: Wednesday, 22 March 2006 4:34 AM To: Stevenson, Charles Cc: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic statement Buy that man a drink - that is exactly what it was. There was an $Include that contained an equate statement that equated CALL.TRANS.WRITE.SUB TO 'CALL subroutine' Excellent job Charles and much thanks Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 11:48 AM To: Barry Rogen Subject: RE: [U2] Basic statement ten chances out of nine there is an $INCLUDE that has an EQUATE buried in it: EQUATE CALL.TRANS.WRITE.SUB LIT CALL *TRANS.WRITE.SUB( FILE.VAR, RF ID, REC ) If this is universe, compile with -L option look at the listing. and do a VLIST to see what this actually compiles to. cds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Rogen Sent: Tuesday, March 21, 2006 7:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] Basic statement To all, We have 'new' programs from a package I need now support. There is a Basic statement that I have never seen in my 20+ years. Hopefully, one can shed a little light for me... CALL.TRANS.WRITE.SUB (that's a dot tween CALL and TRANS not a space) I search everywhere for it being a custom entity and found so such clue. This led me to assume that it had to be a Pick Basic command format that I am just unfamiliar with. Any thoughts are, as always, very appreciated. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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. 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ RF --- RF u2-users mailing list RF u2-users@listserver.u2ug.org RF To unsubscribe please visit http://listserver.u2ug.org/ RF __ NOD32 1.1454 (20060321) Information __ RF This message was checked by NOD32 antivirus system. RF http://www.eset.com -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ a pirate walks into a bar with a steering wheel hanging out of his zipper. The bartender says doesn't that hurt?'arrr.. it's drivin' me nuts!' -Subweird --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit
[U2] ODBC UniAdmin UniData - No RPC connection active.
Morning, I am trying to connect to a Unix server through ODBC. When I start up UniAdmin I get a message that No RPC connection active. Does anyone know what I need to do to correct this? Thanks John John Casserly Senior Applications Systems Administrator Information Technology Bata Library Suite 101.10 Trent University Peterborough, Ontario Canada K9J 7B8 Phone: 705 748-1011 Ext. 7579 Fax: 705 748-1122 E-Mail: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] ODBC UniAdmin UniData - No RPC connection active.
[EMAIL PROTECTED] wrote: Morning, I am trying to connect to a Unix server through ODBC. When I start up UniAdmin I get a message that No RPC connection active. Does anyone know what I need to do to correct this? You haven't been clever and changed the install location for UniAdmin to Program Files, have you? It does NOT like that. There's a lot of stuff that doesn't like spaces in pathnames - it's not wise to move any of the default install locations as far as UV and utilites go... Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic statement
Maybe Chuck wrote that program that Barry had trouble with! :) Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic statement Buy that man a drink Chocolate Milk is my vice of choice. Hershey's powder - NOT Nestle's Quik - in whole milk (OK, yeah, HalfHalf, but I'm trying to cut back.) - that is exactly what it was. There was an $Include that contained an equate statement that equated CALL.TRANS.WRITE.SUB TO 'CALL subroutine' Excellent job Charles and much thanks Sure, spaghetti code is not the only way to deceive: I try to write all my programs with this technique for job security. Chuck Stevenson --- 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] Distributed File Confusion
I'm attempting to build a test system on Linux with version 10.1 of UniVerse. After moving my accounts over to the test machine, running fnuxi on them I've been able to login and get to everything except the distributed file (we only have one of them). The error I receive when attempting to list, verify.df or rebuild.df is below. The path of this file is the same. Am I missing something here? Distributed File TIME.LEDGER must be rebuilt at this release. Call your Database Administrator! Cannot read header in Distributed File TIME.LEDGER. Call your Database Administrator. Cannot open TIME.LEDGER. I've moved over the PARTFILES data from the live system to this test system in an attempt to make it happy, but that didn't work either. Thanks for any and all help! -- Don Kibbey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Triggers
I agree with his assessment for the most part but had some comments to add as well. At 04:46 PM 3/20/2006, Dave Taylor wrote: We were under the impression IBM had conversion utilities available that would mostly convert D3 style dictionaries to UD style dictionaries; thus mitigating the one advantage UV had over UD. There were utilities that were provided, documented and supported by UniData (when they were UniData the company) at one time. They are no longer ever mentioned and most people do not even know they ever existed. They are extremely valuable for converting the dictionaries. I played with UV for about three months and pretty much validated that D3 doesn't run like D3 on UV. Our application needed a lot of work to make it run. What this means is that any (and I mean ANY) use of newer D3 functionality makes conversion more difficult. The application we're converting does have some of this functionality. Often true. Straight Pick code converts over nicely. When you get into trouble is when you start using the new functionality offered by databases (was not part of original Pick) or you hired those clever consultants who knew how to get Pick to do things that are not documented. :^) 1) Backup utility. UD has no backup utility. As a result it could not restore data reliably. That is true. You must use native OS or 3rd party backup software. Often not an issue. Just make sure files are not being updated while backing them up. Most sites are using mirrorred snapshots to make a static backup nowadays. Because the backups are done at file level and not the record level, they will go much faster as well. 2) Limited U2 resources. The VAR we worked with has limited technical resources for UniData. We've had to pretty much do this ourselves. IBM has no interest in our conversion from D3 and there seems to be very limited resources available for assistance. There are other VAR's with the experience to do migrations as well as provide on going support behind them. I can think of at least one. :-) 3) Q-File facility. UniData doesn't have a comparable function. Users of UD, and the engineers, don't seem to have a clue of it's benefits and have not incorporated this into UD. Someone already posted to this. UD has the ability to emulate QPointers in a general sense. 4) Pick compatibility. UniData doesn't seem to have moved forward in 20 years with their Pick syntax. They have, however, incorporated the '-' in the usual verbs (CREATE-FILE works as well as CREATE.FILE). Many commands just fail instead of working in a default state. That is true to some extent. Most of the Pick compatibility issues have been added years ago. Now the product focus is not in conversions but in bringing current (and new) customers into newer technology and making the data more open to other products. For the most part, in UD, the major hurdle will be the dictionary conversion. But once that is done, its done. You just then have the training issue to create new dicts going forward. Hope this is at all interesting. Yes it was. Keep in mind though that every site is going to be different. Most of the issues encountered are going to be strictly unique to the applications. Once worked around though you never have to really deal with it again. (Unless you decided to migrate to another database) Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [DC] Dynamic Connect, Ctrl V
I have a user who like to use that Ctrl-V, Ctrl-Something to cut and paste. Although it runs as part of the install, I am having trouble finding info on it in the yr 2000 Using Dynamic Connect manual. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [DC] Dynamic Connect, Ctrl V
At 18:06 22/03/06 -0500, Brutzman, Bill wrote: I have a user who like to use that Ctrl-V, Ctrl-Something to cut and paste. Although it runs as part of the install, I am having trouble finding info on it in the yr 2000 Using Dynamic Connect manual. Suggestions would be appreciated. Isn't it CtrlC to copy and CrlV to paste? (Standard Winblows) The Edit menu of a DC session has copy and paste... and the above seems to work... for mebut not at an INPUT prompt... --Bill --- 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 Anti-Virus. Version: 7.1.384 / Virus Database: 268.2.6/288 - Release Date: 22/03/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.384 / Virus Database: 268.2.6/288 - Release Date: 22/03/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
