[U2] Re: U2 Users Digest V1 #550
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] I-Type and Assoc
Dear all, I have a problem with an I-type used in an association. Here is my I-descriptor : SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD3,@MV:'|':'TMDEFN':'|':'CT.ES'); SUBR('SQ_CAL_SUB','OEM2ANSI',@1) When I use this descriptor in a select (through ODBC), I get this : [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]E [EMAIL PROTECTED]E [EMAIL PROTECTED]E [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]S [EMAIL PROTECTED]S [EMAIL PROTECTED]S [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE The excepted output should be : [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE How can I do ? Thanks a lot, Vincent MASSON mailto:[EMAIL PROTECTED] Infodata Sarl http://www.infodata.lu Tel : (352) 33 16 48 Fax : (352) 33 75 55 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV Programmer/Analyst contract position
And I wouldn't muck around in the stuff plumbers do for $120 an hour! ;^) Regards, Charlie Noah [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) writes: My plumber chargers 60 an hour -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Sunday, March 06, 2005 08:46 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV Programmer/Analyst contract position I was about to mention the potential for lower $ in an academic environment. What is the exchange, ie what do you get in that environment versus the percieved lower pay. Mid $60's is the implied 'okay' amount in the northeast US (plus benefits) with some peaks around $70-75. The $60 is also for 11 months, so pro-rated it's around $65. In the most gross sense, it's 1760 hours (11 months x 40 hrs/week) at $60,000 which is $34 per hour. If this position offers 1 week of sick time, 2 weeks vacation and 1 week of holidays, the rate becomes $37.50. If it's a 1099 (contract), then it's a little low. If it's a payroll position, then it's a little more favorable. I guess it all depends on what you're doing at the present. my 1 cent. P.S. I like your binary phrase. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] I-Type and Assoc
Re, Inside a I-Type; SUBR is called only one time. The first. You need to return a mv'ed dynamic array. That the reason why there is many functions to manage mv'ed field. Functions are usually postfixed by S like CHAR and CHARS. You must have : SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD3:'|':'TMDEFN':'|':'CT.ES'); SUBR('SQ_CAL_SUB','OEM2ANSI',@1) Inside your GQ.COD.TAB test if param is mv'ed if yes, loop on all mv and return a mv'ed dynarray. Regards. Manu Fernandes Infodata S.`r.l. Tel : (352) 33 16 48 Fax : (.352) 33 75 55 - Original Message - From: Vincent MASSON [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 12:00 PM Subject: [U2] I-Type and Assoc Dear all, I have a problem with an I-type used in an association. Here is my I-descriptor : SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD3,@MV:'|':'TMDEFN':'|':'CT.ES'); SUBR('SQ_CAL_SUB','OEM2ANSI',@1) When I use this descriptor in a select (through ODBC), I get this : [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]E [EMAIL PROTECTED]E [EMAIL PROTECTED]E [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]S [EMAIL PROTECTED]S [EMAIL PROTECTED]S [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]E [EMAIL PROTECTED]S [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE The excepted output should be : [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED]ENTRiE [EMAIL PROTECTED]ENTRiE How can I do ? Thanks a lot, Vincent MASSON mailto:[EMAIL PROTECTED] Infodata Sarl http://www.infodata.lu Tel : (352) 33 16 48 Fax : (352) 33 75 55 --- 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] broken dynamic file on UDT
Chuck, I feel your pain. I've spent the good part of the last two weekends fixing a similar problem. I'm not sure how big *very* large is in your world is, in mine it was about 3GB. Guide didn't find an error in the file but it would coredump when certain items were filed. Programs trying to write the file received similar errors. I managed to copy out the records in the bad group (RECORD HISTFILE '35676354'). Strangely enough they copied out OK. I deleted the indices. I then used fileview with the -nv option to wipe the group. Then memresized the file (with memory 512000 - it's much faster), with the same paramters. Checked the group and ran guide. Re-ran memresize with a completely different modulo and block size. I made sure the items I copied out didn't exist and copied them back in. Lastly, the invoices were rebuilt. The file appears to be OK now. This was all done while all other users were off of the system. It's times like this that I miss the Pick DUMP command. It lets you see exactly what is in the group so you know what it was unable to pull out. All of this was interspersed with efforts of dumpgroup, fixgroup, a routine (clean.group) from IBM that programatically ran the fileview commands to clear the group, adding space to the filesystem (reboot to make sure the dynamic file can see the new space). At one point sms -F to see the space on the system was just going wacky. It was on UniData 6.0.8 on Aix 5.1. Colin Alfke Calgary, AB -Original Message- From: Chuck Mongiovi Hey all, I've got a *very* large dynamic file running on a UDT 6 / AIX 5 system .. I'm trying to fix it with memresize and getting the following error: Resize HISTFILE mod(,sep) = 0(,-1) type = -1 memory = 8000 (k) RESIZE file HISTFILE to 258317. The temporary file for memresize is rsztemp9jrTya. 2:blk check error in U_catch_tuple for file 'HISTFILE' key '35676354', number=224274 cannot read record from HISTFILE,key is 35676354 grp(224275) (1)th key -- RESIZE failed No dictionary file reference in VOC for rsztemp9jrTya. memresize failed. The file DOES have indexes .. I never have any problems with fixing static files, but when thie file breaks (and it has several times), I can't fix it .. I just have to copy as much data out of it as possible and dump the rest .. Any ideas? -Chuck MOngiovi --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unique Ids
I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
Hi David, It ain't so Joe! All keys must be unique. If I have a record with the ID of JoeItAintSo and I try to add another record with the same key, it will just overwrite the original record. I can have JoeItAintSo, JoeItAintSo1, JoeItAintSo2, etc., that works, maybe that was what they were thinking about? Or, you can create a sequential RECORD where each row could be considered a record in and of itself, and the first field could be considered a key, but in reality this sequential record would need a unique key itself. So I dunno who stated this in your meeting but they must need a refresher course. I've been using Pick and Unidata for darn near 20 years now and every record must have a unique key. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 10:38 To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/
RE: [U2] Unique Ids
Well certainly you have have two records with the same ID, but only if there is more than a single file in play. I can have record X in both file A and file B, but I cannot have a record with a key of X twice in file A without some file corruption. There is uniqueness within a single file, but not necessarily global uniqueness. Then again, without some funky programming no other databases have globally unique identifiers either. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 11:38 AM To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/
RE: [U2] Unique Ids
The person who had the comment has worked in the MV world for how long. The only time I have seen this was when a file was corrupted. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 10:38 AM To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/
Re: [U2] Unique Ids
I don't recall an MV implementation that intentionally allowed non-unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non-intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/
RE: [U2] Unique Ids
The only time I've seen duplicate key values in UniVerse files is when the file has become corrupted. I suspect that doesn't fall into the assertion made in your meeting, which is just plain wrong. Hashing algorithms wouldn't be as effective as they are if duplicate key values were allowed. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
The only other thing I can think of, using Universe Pick flavor account, I can make a key of JOE and a key of joe which it thinks are two different records. So keys are case sensitive. That'd be the closest I can think of non-unique keys. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Tuesday, March 08, 2005 2:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids Hi David, It ain't so Joe! All keys must be unique. If I have a record with the ID of JoeItAintSo and I try to add another record with the same key, it will just overwrite the original record. I can have JoeItAintSo, JoeItAintSo1, JoeItAintSo2, etc., that works, maybe that was what they were thinking about? Or, you can create a sequential RECORD where each row could be considered a record in and of itself, and the first field could be considered a key, but in reality this sequential record would need a unique key itself. So I dunno who stated this in your meeting but they must need a refresher course. I've been using Pick and Unidata for darn near 20 years now and every record must have a unique key. Allen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unique Ids
From: [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 1:37 PM I just came out of a meeting where it was stated that MV databases allow non-unique keys. snip Secondary keys perhaps, if you're considering the indexes as keys, but not the primary key. Primary keys are by definition unique. Unless the file's corrupted, then anything can occur. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
thanks for the early replies .. it is good to know that i have not been wrong for the last 20 years g .. well at least in this instance G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Unique Ids From: Allen E. Elwood [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:12 am To: u2-users@listserver.u2ug.org Hi David, It ain't so Joe! All keys must be unique. If I have a record with the ID of JoeItAintSo and I try to add another record with the same key, it will just overwrite the original record. I can have JoeItAintSo, JoeItAintSo1, JoeItAintSo2, etc., that works, maybe that was what they were thinking about? Or, you can create a sequential RECORD where each row could be considered a record in and of itself, and the first field could be considered a key, but in reality this sequential record would need a unique key itself. So I dunno who stated this in your meeting but they must need a refresher course. I've been using Pick and Unidata for darn near 20 years now and every record must have a unique key. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 10:38 To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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] Unique Ids
Perhaps they were referring to indexes? Such as a customer type field within the customer file. You could have customer 123 and customer 456 with the same customer type of WHL and the index on Customer Type would have WHL in there 'twice', once for each customer. Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED] www.valuepart.com -Original Message- From: Kathleeni M Bodine [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 1:35 PM To: u2-users@listserver.u2ug.org Subject:RE: [U2] Unique Ids The person who had the comment has worked in the MV world for how long. The only time I have seen this was when a file was corrupted. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 10:38 AM To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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] Unique Ids
Indexes don't have to be unique. Is that what they were referring to ? Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 1:38 PM To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/
RE: [U2] Unique Ids
However.. you now need to share those Twinkies. Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED] www.valuepart.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 2:03 PM To: u2-users@listserver.u2ug.org Subject:RE: [U2] Unique Ids thanks for the early replies .. it is good to know that i have not been wrong for the last 20 years g .. well at least in this instance G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Unique Ids From: Allen E. Elwood [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:12 am To: u2-users@listserver.u2ug.org Hi David, It ain't so Joe! All keys must be unique. If I have a record with the ID of JoeItAintSo and I try to add another record with the same key, it will just overwrite the original record. I can have JoeItAintSo, JoeItAintSo1, JoeItAintSo2, etc., that works, maybe that was what they were thinking about? Or, you can create a sequential RECORD where each row could be considered a record in and of itself, and the first field could be considered a key, but in reality this sequential record would need a unique key itself. So I dunno who stated this in your meeting but they must need a refresher course. I've been using Pick and Unidata for darn near 20 years now and every record must have a unique key. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 10:38 To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
Susan, This is the approach I took with the speaker. There was a period of time 'in the good old days' where the has could go goofy either through corruption or keys containing system delimiters .. But as the speaker (supposidly with the same term of experieince as I) was teaching the benefits of MsSql Server and the wonders of sql .. G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Susan Lynch [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:54 am To: u2-users@listserver.u2ug.org I don't recall an MV implementation that intentionally allowed non-unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non-intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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] Unique Ids
I often wonder about SQL. scratching bald spot on head BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 12:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids Susan, This is the approach I took with the speaker. There was a period of time 'in the good old days' where the has could go goofy either through corruption or keys containing system delimiters .. But as the speaker (supposidly with the same term of experieince as I) was teaching the benefits of MsSql Server and the wonders of sql .. G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Susan Lynch [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:54 am To: u2-users@listserver.u2ug.org I don't recall an MV implementation that intentionally allowed non- unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non- intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
Dave: Since D3 can be case-insensitive, it's possible to: 1) Create an item in (VOC) named Joe 2) Edit an item named JOE, which is the item Joe, and file it. So, from a certain perspective, one could say that D3 allows an item named JOE, JOe, joe, jOE, etc to share the same record key of Joe; therefore, there are duplicate record keys. Did I say this right? :-) Bill P.S. I've been working with some ODBC stuff lately and really have to do the shake to get data to come out ok. I guess the SQL crowd doesn't care of the general illogic of it, just that regular people can't use the tools. Job security is not all bad. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 12:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids Susan, This is the approach I took with the speaker. There was a period of time 'in the good old days' where the has could go goofy either through corruption or keys containing system delimiters .. But as the speaker (supposidly with the same term of experieince as I) was teaching the benefits of MsSql Server and the wonders of sql .. G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Susan Lynch [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:54 am To: u2-users@listserver.u2ug.org I don't recall an MV implementation that intentionally allowed non-unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non-intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unique Ids
Aha - the 'same term of experience', but apparently not the same level of understanding! Reminds me of a description by Jane Austen of a person whose university experience had consisted of keeping the necessary number of terms, but forming no useful acquaintance there... G Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 3:25 PM Subject: RE: [U2] Unique Ids Susan, This is the approach I took with the speaker. There was a period of time 'in the good old days' where the has could go goofy either through corruption or keys containing system delimiters .. But as the speaker (supposidly with the same term of experieince as I) was teaching the benefits of MsSql Server and the wonders of sql .. G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Susan Lynch [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:54 am To: u2-users@listserver.u2ug.org I don't recall an MV implementation that intentionally allowed non-unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non-intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unique Ids
Now you could have a situation where you brought a part file online that had a duplicate key. - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 2:41 PM Subject: RE: [U2] Unique Ids I often wonder about SQL. scratching bald spot on head BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 12:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids Susan, This is the approach I took with the speaker. There was a period of time 'in the good old days' where the has could go goofy either through corruption or keys containing system delimiters .. But as the speaker (supposidly with the same term of experieince as I) was teaching the benefits of MsSql Server and the wonders of sql .. G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Susan Lynch [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:54 am To: u2-users@listserver.u2ug.org I don't recall an MV implementation that intentionally allowed non- unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non- intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/ --- 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] Unique Ids
David, I just came out of a meeting where it was stated that MV databases allow non-unique keys. perhaps the person was refering to multivalues? If you were modelling parents and children in an SQL database you might use a PARENTS table and a CHILDREN table. Usually neither table would allow duplicate keys. In MV you might have a PARENTS file which had a multivalued attribute CHILDREN. (I don't think) there is a way to make the database enforce a rule which makes all the children of a parent unique, except using triggers. Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
How would you 'create' the part file to begin with having a non-unique key. If you are talking about say .. a csv file that is imported .. the csv could have duplicate keys .. but i bet after the import the 'mv' table will not have any duplicate keys. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Jerry Banker [EMAIL PROTECTED] Date: Tue, March 08, 2005 1:48 pm To: u2-users@listserver.u2ug.org Now you could have a situation where you brought a part file online that had a duplicate key. - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 2:41 PM Subject: RE: [U2] Unique Ids I often wonder about SQL. scratching bald spot on head BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 12:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids Susan, This is the approach I took with the speaker. There was a period of time 'in the good old days' where the has could go goofy either through corruption or keys containing system delimiters .. But as the speaker (supposidly with the same term of experieince as I) was teaching the benefits of MsSql Server and the wonders of sql .. G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Susan Lynch [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:54 am To: u2-users@listserver.u2ug.org I don't recall an MV implementation that intentionally allowed non- unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non- intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/ --- 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] Unique Ids
The actual definition (relational or sql?) requires a unique column(or set of columns). It is possible in *all* implementations to allow for this to be missing. It is frowned upon .. but it is possible. Lots of little 'features' depending on the implementation. Like languages that are 'typed' except for the inclusion of a 'variant' type G. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Unique Ids From: Bob Woodward [EMAIL PROTECTED] Date: Tue, March 08, 2005 12:41 pm To: u2-users@listserver.u2ug.org I often wonder about SQL. scratching bald spot on head BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 12:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids Susan, This is the approach I took with the speaker. There was a period of time 'in the good old days' where the has could go goofy either through corruption or keys containing system delimiters .. But as the speaker (supposidly with the same term of experieince as I) was teaching the benefits of MsSql Server and the wonders of sql .. G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Susan Lynch [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:54 am To: u2-users@listserver.u2ug.org I don't recall an MV implementation that intentionally allowed non- unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non- intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, 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/ --- 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] Unique Ids
David, If you added a new part to an existing distributed file, and the new part already had records in it, you could potentially have records in this new part whose item-id should be in another part based on the partitioning algorithm. Then you could create that item-id in the proper part (or maybe it already exists there, too!). Now you have 2 records with the exact same item-id, in 2 different parts of the distributed file. If you ED or READ, you'd get the record that was in the proper part. But if you LIST/SORT you could get both records selected and on a report. Good catch, Jerry! --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 4:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids How would you 'create' the part file to begin with having a non-unique key. If you are talking about say .. a csv file that is imported .. the csv could have duplicate keys .. but i bet after the import the 'mv' table will not have any duplicate keys. DSig David Tod Sigafoos SigsSolutions, Inc. snip Now you could have a situation where you brought a part file online that had a duplicate key. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unique Ids
You can do it with a Universe SQL table (Make MV values unique, that is). In traditional UV tables, however, you are correct. The uniqueness in this case is a combination of the primary key and the MV position. I would also guess that the person in question was referring to multivalues since traditional MV tables (or Universe anyway) have no concept of a controlling attribute (or primary key) of an association. Craig Bennett wrote: David, I just came out of a meeting where it was stated that MV databases allow non-unique keys. perhaps the person was refering to multivalues? If you were modelling parents and children in an SQL database you might use a PARENTS table and a CHILDREN table. Usually neither table would allow duplicate keys. In MV you might have a PARENTS file which had a multivalued attribute CHILDREN. (I don't think) there is a way to make the database enforce a rule which makes all the children of a parent unique, except using triggers. Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- [This E-mail scanned for viruses by Declude Virus] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I-Type and Assoc
Vincent, I am not sure why you get a one character answer one way and a full word the other. I assume that's either in the nature of how your SQ_CAL_SUB is written called, or from formatting applied differently in the 2 methods. I think we need more context. Manu Fernandes seems to be assuming the former. Stipulating that, I have some comments interspersed below. cds -Original Message- From: Manu Fernandes Inside a I-Type; SUBR is called only one time. The first. I think Manu means an I-descriptor, not SUBR(), is evaluated once per _record_, not for each value in the association. That is the nature of I-descriptors, regardless of whether SUBR() is invoked. It is both the beauty and bane of I-descriptors. It is a (the?) major distinction between them and pick-correlatives. In your case, the I-descriptor has 2 SUBR() calls in it. Both will be called, but the whole I-descriptor will only be evaluated once per record. The exception is if you are processing an active exploded list, i.e. one that has been generated by SELECT . . . WHEN mv-field condition . . . BY.EXP mv-field . . . then each line of such a list contains id particular value number. That is what populates @MV for your I-desc to process. The I-descriptor will be evaluated once for each entry in the active select list. A record with many values might be in the list many times, once per value. Perhaps this is why you get different results. One way you are processing an exploded list and the other way you are not? You need to return a mv'ed dynamic array. That the reason why there is many functions to manage mv'ed field. Functions are usually postfixed by S like CHAR and CHARS. You must have : SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD3:'|':'TMDEFN':'|':'CT.ES'); SUBR('SQ_CAL_SUB','OEM2ANSI',@1) Manu has removed your @MV from @RECORD3,@MV. ( Humour me. Let's also simplify: ) ( '|':'TMDEFN':'|':'CT.ES' ) ( which is really one constant:) ( '|TMDEFN|CT.ES' ) Applying the MV functions that Manu suggests, you would change SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD3:'|':'TMDEFN':'|':'CT.ES'); SUBR('SQ_CAL_SUB','OEM2ANSI',@1) into CATS( @RECORD3,REUSE('|TMDEFN|CT.ES')); SUBR('SQ_CAL_SUB','GQ.COD.TAB',@1); SUBR('SQ_CAL_SUB','OEM2ANSI',@2) For UniData I think it is: SUBR('-CATS',@RECORD3,REUSE('|TMDEFN|CT.ES')); SUBR('SQ_CAL_SUB','GQ.COD.TAB',@1); SUBR('SQ_CAL_SUB','OEM2ANSI',@2) If I have only muddied the waters please ask, either on- or off-list, for clarification or tell me to go away. Don't give up. Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
Yes .. UV sql does allow that, and so does most Sql *servers* available now. In fact Oracle has an inbedded structure now. Haven't played with it .. i try to stay away from Oracle if I can. I would also guess that the person in question was referring to multivalues since traditional MV tables (or Universe anyway) have no concept of a controlling attribute (or primary key) of an association. actually PICK has always had a C and D information in their dicts. Controlling and list of positions and D and controlling postion. I believe Prime (and Revelation based on prime) had a Mn.x structure defining Master Value (n) and x(the controled subvalue positions) of coures if you weren't talking about that .. ignore G dsig Original Message Subject: Re: [U2] Unique Ids From: Geoffrey Mitchell [EMAIL PROTECTED] Date: Tue, March 08, 2005 2:37 pm To: u2-users@listserver.u2ug.org You can do it with a Universe SQL table (Make MV values unique, that is). In traditional UV tables, however, you are correct. The uniqueness in this case is a combination of the primary key and the MV position. I would also guess that the person in question was referring to multivalues since traditional MV tables (or Universe anyway) have no concept of a controlling attribute (or primary key) of an association. Craig Bennett wrote: David, I just came out of a meeting where it was stated that MV databases allow non-unique keys. perhaps the person was refering to multivalues? If you were modelling parents and children in an SQL database you might use a PARENTS table and a CHILDREN table. Usually neither table would allow duplicate keys. In MV you might have a PARENTS file which had a multivalued attribute CHILDREN. (I don't think) there is a way to make the database enforce a rule which makes all the children of a parent unique, except using triggers. Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- [This E-mail scanned for viruses by Declude Virus] --- [This E-mail scanned for viruses by Declude Virus] --- 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] [UV] non-numeric error after passing (ANS MATCHES '0N' ANS0)
The relevant code ( I am VERY sure source matches object): 072: BEGIN CASE 073: CASE ANS MATCHES '0N' ANS0 074: IF MITM5,ANS# THEN 075: IF MITM7,ANS# THEN GOSUB 200 ; IF ERR THEN GOTO 15 287: 200:*Subroutine For Password Check. 291: IF MITM7,ANS[1,1] = # THEN 310: IF X#MITM7,ANS THEN 4 times in recent months line these have generated the a set of 4 runtime errors Nonnumeric data when numeric required. Zero used. as recorded in uv/errlog: Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 74, Message[040025] Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 75, Message[040025] Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 291, Message[040025] Mon Mar 7 14:04:06 78 wrc63580 Program MENU.DRIVER: Line 310, Message[040025] (See SYS.MESSAGES 040025) The only operation on all four lines that requires a numeric is using ANS as the value number in the EXTRACT(). ANS is non-numeric ??? - But how can a non-numeric string get past the test on line 73, (ANS MATCHES '0N' ANS0) ? - Can a non-numeric both match 0N and also be greater than zero? Something involving spaces or ^128, maybe? That's the most likely line of enquiry, as I see it. This is in our top level menu driver that every interactive user runs. These lines get executed countless times each day, but with only four such errors incidents since last September. Am I missing something glaringly obvious? Any answers? cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unique Ids
I'm glad I read through the rest of the messages before replying. Thank you Ron for the explanation on my behalf. - Original Message - From: Pingilley, Ron [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 4:33 PM Subject: RE: [U2] Unique Ids David, If you added a new part to an existing distributed file, and the new part already had records in it, you could potentially have records in this new part whose item-id should be in another part based on the partitioning algorithm. Then you could create that item-id in the proper part (or maybe it already exists there, too!). Now you have 2 records with the exact same item-id, in 2 different parts of the distributed file. If you ED or READ, you'd get the record that was in the proper part. But if you LIST/SORT you could get both records selected and on a report. Good catch, Jerry! --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 4:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids How would you 'create' the part file to begin with having a non-unique key. If you are talking about say .. a csv file that is imported .. the csv could have duplicate keys .. but i bet after the import the 'mv' table will not have any duplicate keys. DSig David Tod Sigafoos SigsSolutions, Inc. snip Now you could have a situation where you brought a part file online that had a duplicate key. --- 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] non-numeric error after passing (ANS MATCHES '0N' ANS0)
Goo'day, Charles, At 18:25 08/03/05 -0500, you wrote: The relevant code ( I am VERY sure source matches object): 072: BEGIN CASE 073: CASE ANS MATCHES '0N' ANS0 074: IF MITM5,ANS# THEN 075: IF MITM7,ANS# THEN GOSUB 200 ; IF ERR THEN GOTO 15 287: 200:*Subroutine For Password Check. 291: IF MITM7,ANS[1,1] = # THEN 310: IF X#MITM7,ANS THEN 4 times in recent months line these have generated the a set of 4 runtime errors Nonnumeric data when numeric required. Zero used. as recorded in uv/errlog: Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 74, Message[040025] Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 75, Message[040025] Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 291, Message[040025] Mon Mar 7 14:04:06 78 wrc63580 Program MENU.DRIVER: Line 310, Message[040025] (See SYS.MESSAGES 040025) The only operation on all four lines that requires a numeric is using ANS as the value number in the EXTRACT(). ANS is non-numeric ??? - But how can a non-numeric string get past the test on line 73, (ANS MATCHES '0N' ANS0) ? - Can a non-numeric both match 0N and also be greater than zero? Something involving spaces or ^128, maybe? That's the most likely line of enquiry, as I see it. Quite some time ago, UV 9.something on NT4, IIRC, we had a similar instance and it seemed to come from an accidental keyboarded Ctrl sequence - happened a few times at one site - which UV interpreted as numeric/non numeric depending on the source statement. Different statements seemed to give different responsesWe never got to the bottom of it properly - we changed the code to check for numerics at point of input. This is in our top level menu driver that every interactive user runs. These lines get executed countless times each day, but with only four such errors incidents since last September. Am I missing something glaringly obvious? Any answers? cds --- 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.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/05 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.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/05 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] broken dynamic file on UDT
I'm not familiar with the Pick(r) DUMP command, but you can peer into a group with fileview... Simple syntax: $UDTBIN/fileview -g1 VOC You can dump blocks using the -b option (useful for overflow blocks - chasing the links). Different arguments for part files in dynamic files, etc. Also - Colin typoed with the 6.0 option for 'zapping' a group.fileview -gn -zv FILENAME (group n, 'z'ap, 'v'erify (eg prompt 'are you sure')) No fileview is not documented. Designed as an engineering tool. Originally designed to GENERATE file corruption to test 'guide'. So - be careful. If you just type the command with no arguments, it spits out 2 pages of syntax - you can see the 'randomly generate' options... skip 'em. There are a number of examples of using this utility on slides in the presentations I've made at conferences over the past few years and are on the infamous 'survival kit cd'. Wally Terhune Manager - U2 Advanced Technical Services IBM Information Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Alfke, Colin [EMAIL PROTECTED] To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] broken dynamic file on UDT 03/08/2005 06:57 AM Please respond to u2-users Chuck, I feel your pain. I've spent the good part of the last two weekends fixing a similar problem. I'm not sure how big *very* large is in your world is, in mine it was about 3GB. Guide didn't find an error in the file but it would coredump when certain items were filed. Programs trying to write the file received similar errors. I managed to copy out the records in the bad group (RECORD HISTFILE '35676354'). Strangely enough they copied out OK. I deleted the indices. I then used fileview with the -nv option to wipe the group. Then memresized the file (with memory 512000 - it's much faster), with the same paramters. Checked the group and ran guide. Re-ran memresize with a completely different modulo and block size. I made sure the items I copied out didn't exist and copied them back in. Lastly, the invoices were rebuilt. The file appears to be OK now. This was all done while all other users were off of the system. It's times like this that I miss the Pick DUMP command. It lets you see exactly what is in the group so you know what it was unable to pull out. All of this was interspersed with efforts of dumpgroup, fixgroup, a routine (clean.group) from IBM that programatically ran the fileview commands to clear the group, adding space to the filesystem (reboot to make sure the dynamic file can see the new space). At one point sms -F to see the space on the system was just going wacky. It was on UniData 6.0.8 on Aix 5.1. Colin Alfke Calgary, AB [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic16748.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] non-numeric error after passing (ANS MATCHES '0N' ANS0)
072: BEGIN CASE 073: CASE ANS MATCHES '0N' ANS0 074: IF MITM5,ANS# THEN 075: IF MITM7,ANS# THEN GOSUB 200 ; IF I saw a case similar to this. There was this program code which was looking for an address. There was an index per building where the city code, civic number and street name was the key. The appartments were seperated by value marks on field 1. Anyhow, the LOCATE command on the appartments, made a match for appartment 1 when appartment 1E0 was what was being looked for. 1E0 was interpreted as: 1 x 10^0 which meant the same as 1. Years ago: num( :1 ) would give 1, now it is true on 10.something. In the above example I believe that if ANS is a string, the 0 will be treated as: 0 (the string zero). In which case it can be compared. Perhaps you should change the code to: ANS += 0 ;* Force it to become a number BEGIN CASE CASE ANS MATCHES '1N0N' AND ANS 0 '1N0N' will force at least one numerical digit to pass __ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] broken dynamic file on UDT
Thanks Wally. I keep forgetting that I can use fileview. The good thing about UniData is that I don't need it nearly as often :-). Dump is just like a hex file viewer. Plus will follow the links backwards and forwards. Read only so not dangerous. I meant to not give quite enough details to actually run fileview. As you said - very dangerous. Colin Alfke Calgary, Alberta -Original Message- From: Wally Terhune I'm not familiar with the Pick(r) DUMP command, but you can peer into a group with fileview... Simple syntax: $UDTBIN/fileview -g1 VOC You can dump blocks using the -b option (useful for overflow blocks - chasing the links). Different arguments for part files in dynamic files, etc. Also - Colin typoed with the 6.0 option for 'zapping' a group. fileview -gn -zv FILENAME (group n, 'z'ap, 'v'erify (eg prompt 'are you sure')) No fileview is not documented. Designed as an engineering tool. Originally designed to GENERATE file corruption to test 'guide'. So - be careful. If you just type the command with no arguments, it spits out 2 pages of syntax - you can see the 'randomly generate' options... skip 'em. There are a number of examples of using this utility on slides in the presentations I've made at conferences over the past few years and are on the infamous 'survival kit cd'. Wally Terhune [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE : [U2] I-Type and Assoc
Hi Charles, Thanks a lot for your help and explanation. Know, I understand the use of the @MV in an I-descriptor. In my case, I can't use a BY-EXP clause because I'm working with SQL statements sent through ODBC to Universe. Finally, I made the modifications suggested by Manu Fernandes in my subroutine and it works fine. I was just dreaming about a way of defining an I-descriptor without any modification in my subroutine (also used in a Pick correlative) :-( Best regards, Vincent MASSON Infodata Sarl Tel : (352) 33 16 48 Fax : (352) 33 75 55 -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Stevenson, Charles Envoyi : mercredi 9 mars 2005 0:00 @ : u2-users@listserver.u2ug.org Objet : RE: [U2] I-Type and Assoc Vincent, I am not sure why you get a one character answer one way and a full word the other. I assume that's either in the nature of how your SQ_CAL_SUB is written called, or from formatting applied differently in the 2 methods. I think we need more context. Manu Fernandes seems to be assuming the former. Stipulating that, I have some comments interspersed below. cds -Original Message- From: Manu Fernandes Inside a I-Type; SUBR is called only one time. The first. I think Manu means an I-descriptor, not SUBR(), is evaluated once per _record_, not for each value in the association. That is the nature of I-descriptors, regardless of whether SUBR() is invoked. It is both the beauty and bane of I-descriptors. It is a (the?) major distinction between them and pick-correlatives. In your case, the I-descriptor has 2 SUBR() calls in it. Both will be called, but the whole I-descriptor will only be evaluated once per record. The exception is if you are processing an active exploded list, i.e. one that has been generated by SELECT . . . WHEN mv-field condition . . . BY.EXP mv-field . . . then each line of such a list contains id particular value number. That is what populates @MV for your I-desc to process. The I-descriptor will be evaluated once for each entry in the active select list. A record with many values might be in the list many times, once per value. Perhaps this is why you get different results. One way you are processing an exploded list and the other way you are not? You need to return a mv'ed dynamic array. That the reason why there is many functions to manage mv'ed field. Functions are usually postfixed by S like CHAR and CHARS. You must have : SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD3:'|':'TMDEFN':'|':'CT.ES'); SUBR('SQ_CAL_SUB','OEM2ANSI',@1) Manu has removed your @MV from @RECORD3,@MV. ( Humour me. Let's also simplify: ) ( '|':'TMDEFN':'|':'CT.ES' ) ( which is really one constant:) ( '|TMDEFN|CT.ES' ) Applying the MV functions that Manu suggests, you would change SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD3:'|':'TMDEFN':'|':'CT.ES'); SUBR('SQ_CAL_SUB','OEM2ANSI',@1) into CATS( @RECORD3,REUSE('|TMDEFN|CT.ES')); SUBR('SQ_CAL_SUB','GQ.COD.TAB',@1); SUBR('SQ_CAL_SUB','OEM2ANSI',@2) For UniData I think it is: SUBR('-CATS',@RECORD3,REUSE('|TMDEFN|CT.ES')); SUBR('SQ_CAL_SUB','GQ.COD.TAB',@1); SUBR('SQ_CAL_SUB','OEM2ANSI',@2) If I have only muddied the waters please ask, either on- or off-list, for clarification or tell me to go away. Don't give up. 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] Upgrading Universe to 10.1.4
We are in the process of upgrading a 800+ Universe system from 10.0.7 to 10.1.4, is anyone aware of any functionality that works at the previous release but no longer at the upgrade release. Many thanks, Tim Franklin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] non-numeric error after passing (ANS MATCHES '0N' ANS0)
In UniData the '.' and '-' will evaluate as numeric. You might want to check how these would fall through your logic in UniVerse. hth Colin Alfke -Original Message- From: Stevenson, Charles The relevant code ( I am VERY sure source matches object): 072: BEGIN CASE 073: CASE ANS MATCHES '0N' ANS0 [snip] 4 times in recent months line these have generated the a set of 4 runtime errors Nonnumeric data when numeric required. Zero used. as recorded in uv/errlog: Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 74, [snip] The only operation on all four lines that requires a numeric is using ANS as the value number in the EXTRACT(). ANS is non-numeric ??? - But how can a non-numeric string get past the test on line 73, (ANS MATCHES '0N' ANS0) ? - Can a non-numeric both match 0N and also be greater than zero? Something involving spaces or ^128, maybe? That's the most likely line of enquiry, as I see it. This is in our top level menu driver that every interactive user runs. These lines get executed countless times each day, but with only four such errors incidents since last September. Am I missing something glaringly obvious? Any answers? cds [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE : [U2] Upgrading Universe to 10.1.4
Hi Tim I think you'll have to reinstall ODBC drivers on each client. I don't see anything else. Best regards, Vincent MASSON Infodata Sarl Tel : (352) 33 16 48 Fax : (352) 33 75 55 -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Tim Franklin Envoyi : mercredi 9 mars 2005 7:10 @ : 'u2-users@listserver.u2ug.org' Objet : [U2] Upgrading Universe to 10.1.4 We are in the process of upgrading a 800+ Universe system from 10.0.7 to 10.1.4, is anyone aware of any functionality that works at the previous release but no longer at the upgrade release. Many thanks, Tim Franklin --- 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] PHANTOM command
I believe in a previous email I have read that it is possible to specify a user name that you can supply on the command line to the PHANTOM command and this user will be used to log on to run the command. Does anyone have the details? Tim Franklin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/