[U2] Memo: Universe file size limit
Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large... thanks in advance HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Memo: Universe file size limit
Unix limitation? Perhaps something needs tweaking there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 01 September 2004 10:18 To: [EMAIL PROTECTED] Subject: [U2] Memo: Universe file size limit Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large... thanks in advance HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Memo: Universe file size limit
Surely if the standard Universe 32bit max file size is 2gb (2147483648 Bytes) Then the 64bit would be 4gb (2147483648*2 Bytes) Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: 01 September 2004 11:46 To: [EMAIL PROTECTED] Subject: RE: [U2] Memo: Universe file size limit Unix limitation? Perhaps something needs tweaking there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 01 September 2004 10:18 To: [EMAIL PROTECTED] Subject: [U2] Memo: Universe file size limit Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large... thanks in advance HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [PICK] File handle opened?
I forgot to mention - the FILEVAR will be considered to be ASSIGNED=TRUE even if you've simply done a FILEVAR= somewhere in the program. The key to this is never use the file handle variable name except for the ASSIGNED or the various file-handling verbs. Rick Ramsey Healthpac Cumputer Systems Savannah, GA -Original Message- From: Rick Ramsey Sent: Wednesday, September 01, 2004 7:18 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] [PICK] File handle opened? I believe this will work for you in D3: IF ASSIGNED(FILEVAR) . . . where FILEVAR is the file handle variable used in the OPEN statement Rick Ramsey Healthpac Cumputer Systems Savannah, GA -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:39 PM To: [EMAIL PROTECTED] Subject: [U2] [PICK] File handle opened? I've done this in U2 before, but in a Raining Data Pick Env, does anyone know how to interrogate a file handle to see if it has been properly opened? I'm writing a LOCK.RECORD subroutine with all kinds of nifty options and it would be nice to be able to not blow out to debugger if a handle is not opened. Even the ON ERROR clause will not stop it from blowing out if the file is unopened and you try to read, or if the file is opened and you do any BUT a file operation. Thanks! Allen --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Memo: Universe file size limit
Hi Bob, A 64bit file has a very large capacity. The 64 bit number is binary so every bit = 1 greater power of 2. Whereas 2,147,483,648 = 2^31 then 9,223,372,036,854,775,808 = 2^63. A very big number indeed. The reason it is 31 and 63 is that the leftmost bit generally signifies the sign of the number, eg: whether it is a positive or a negative number. If it is 1 then it is negative, 0 is positive so it generally doesn't get used when calculating the filepointers. I'm not that familiar with HPUX, however I'd be checking out any filesystem limitations there maybe. Depending on the filesystem you are using, eg: UFS, XFS or JFS there could be limitations on the maximum filesystem size. Check with your support people but Universe shouldn't be giving you any problems. Admittedly we are running a version 10.0 system on Tru64 but we have files that are now in excess of 25Gb so it really shouldn't be that. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Wednesday, 1 September 2004 8:30 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Memo: Universe file size limit Surely if the standard Universe 32bit max file size is 2gb (2147483648 Bytes) Then the 64bit would be 4gb (2147483648*2 Bytes) Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: 01 September 2004 11:46 To: [EMAIL PROTECTED] Subject: RE: [U2] Memo: Universe file size limit Unix limitation? Perhaps something needs tweaking there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 01 September 2004 10:18 To: [EMAIL PROTECTED] Subject: [U2] Memo: Universe file size limit Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large... thanks in advance HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED]
RE: [U2] Memo: Universe file size limit
Surely if the standard Universe 32bit max file size is 2gb (2147483648 Bytes) Then the 64bit would be 4gb (2147483648*2 Bytes) I guess more in the neighbourhood of 2^63 = 9223372036854775808 bytes but nevermind, the limit for a 32 bit system on 2gb is stupid as you could have used the full range of bits instead of using a signed integer, I can't understand why cardinal types can't be used in filesystems, it may be a problem with the cpu's, the good old motorola 68k never had those stupid limitations. best regards from rainy Denmark Claus Derlien Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Memo: Universe file size limit
I would check your ulimit settings. On both HP-UX 10.20 and 11 we have a setting of 4194303. Only problem with that is that IIRC this figure is in blocks - which would mean 2GB. Robert Paterson Technology Support Manager www.epicor.com Tel.: +44 (1344) 468231 Cell: +44 (7799) 348513 Fax: +44 (1344) 468050 E-Mail: [EMAIL PROTECTED] 1 The Arena, Downshire Way, Bracknell, Berks, UK, RG12 1PU This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 01 September 2004 10:18 To: [EMAIL PROTECTED] Subject: [U2] Memo: Universe file size limit Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large... thanks in advance HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [PICK] File handle opened?
IF ASSIGNED(file.var) then * Check for locks... END Works. You can also do NOT(ASSIGNED(file.var)) as well. This works on both regular and file variables. Hth Colin Alfke Calgary, Alberta -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 2:39 PM To: [EMAIL PROTECTED] Subject: [U2] [PICK] File handle opened? I've done this in U2 before, but in a Raining Data Pick Env, does anyone know how to interrogate a file handle to see if it has been properly opened? I'm writing a LOCK.RECORD subroutine with all kinds of nifty options and it would be nice to be able to not blow out to debugger if a handle is not opened. Even the ON ERROR clause will not stop it from blowing out if the file is unopened and you try to read, or if the file is opened and you do any BUT a file operation. Thanks! Allen --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Memo: Universe file size limit
If I remember correctly, when I was implementing the 64-bit file system in universe, the HPUX max file size was somewhere around 128 Terabytes, but I can't locate my notes from that far back to verify that number. It certainly sounds like something in the OS is stopping you, such as ulimit (as mentioned). Good luck. Glenn At 05:17 AM 9/1/2004, you wrote: Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large... thanks in advance HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Memo: RE: [U2] Universe file size limit
Hi, Thanks for all the responses. Ulimit, is set to unlimited so that shouldn't be the problem. Our unix support people cant find any other HPUX kernel parameter that would affect the maximum file size. Glen's recollection is correct - HPUX support file sizes up to 128 terabytes. It is looking increasingly as if this is a Universe 9.6 issue or a 9.6 on HPUX issue. is anyone running UV 9.6 with files over 4 GB? thanks again.. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] How import data from UniVerse into MS Access?
The @select item should be a list of FIELD (i.e. dictionary entry) names not record ID's -original message- [snip] Below is the setup: CT DICT BLAH @SELECT @SELECT 0001 PH 0002 INTO ALTER - the records I want Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Memo: Re: RE: [U2] Universe file size limit
Hi Glen, This is the output when we first ran across the problem: 0008 Program FIS00200: Line 551, Internal data error. 0009 Program FIS00200: Line 555, Internal data error. 0010 Program FIS00200: Line 555, WRITE failure. Line 551 is a MATREADU from the file, and line 555 is a MATWRITE to the file. This file is a an archive of another file, so there cannot be any invalid characters in the key. We just ran fixtool on the file, which claimed to have found 657 errors and fixed 649 : Start Diagnostics. 0 Errors found in physical structure. 0 Errors found in file header. 0 Errors found in primary groups. 654 Errors found in data. 3 Other errors found in file. 657 Errors on file. Start Fixing. 649 Errors fixed. Fixtool Completed. but when I did a COUNT of the file there were still problems: WARNING: Internal file corruption detected during SCAN operation! Invalid pad length detected within record block! Filename: JOBHIST Group offset: 3575808 (0x0) Key: Abnormal termination of UniVerse. Fault type is 11. Layer type is Query. I am getting the sysadmin to run the fixtool command again thanks for your help, Glenn Herbert [EMAIL PROTECTED] on 01 Sep 2004 15:24 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: bcc: Subject:Re: RE: [U2] Universe file size limit I have a version of 9.6 (and beyond!) running here on an hp 11.11i with a few large files that exceed 4 gig (one is around 20 gig) with no problems; note that these files aren't exercised all that much as I don't really play around with this stuff much anymore. Additionally, we have a number of DS end users who have files that regularly exceed this size and don't have issues, so I'm sure it's something specific to your system. I don't recall you mentioning what the exact error was other than it being an internal data error, so maybe posting the entire message might jiggle some latent memory somewhere. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Correlative referencing multi-value field in another file
Yes, this is the way it works, unfortunately. What we ended up doing was to change att 8 in WO.COMP.QTY to F;0(TWIP;X;;8);(G0 1);0(TWIP;X;;8);(G1 1);0(TWIP;X;;8);(G2 1);.;+;+;+;+ etc -Dianne Rod Hills wrote: We are trying to do a very basic PICK technique of summing a multi-value field in a F-type correlative. However, it appears uniVerse is not putting the multi-values onto it's stack as inividual values, but rather as one entry with the value markers replaced with blanks. Below are two dictionary definitions, the only difference is WO.COMPL.QTY does a sum as its last step. As can be seen by the LIST output, only single-value entries return a non-zero value. Anyone else come across this? And should it be working this way? We are on UV10.0.16 and HPUX11i. Thanks in advance -- Rod Hills WO.COMPL.QTY 0001 A 0002 0 0003 Wo Compl}Total 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8);S 0009 R 0010 8 WO.QTY.COMPL 0001 A 0002 0 0003 Wo Qty Compl 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8) 0009 R 0010 12 LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am 31 Aug 2004 PAGE1 WIPOPERACT Wo Compl Wo Qty Compl Total... 89783*560 44 89433*111 0 14 1 78574*370 03 5 6 1 5 84804*780 0 2 2 3 3 5 3 88810*070 0 R7735*380 0 15 2 1 89922*630 0 60330*001 0 79101*000 0 18 60 5 2 10 3 2 90032*050 0 82930*110 0 88671*001 2937 2937 90449*260 0 3 20 4 3 60268*790 0 60129*720 0 79312*380 22 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: Memo: Re: RE: [U2] Universe file size limit
Well, I do know that the Internal data error message (at 9.6) is generated within the file handling subsystem when blink values are mucked up; interesting that no information pertaining to this type of error is displayed so one might postulate this isn't the issue. This message can also be generated when the INMAT function isn't used against an array or in the (undocumented) ASSIGN statement referencing an invalid action. All other generators of this message are within utilities, such as create.file, file.stat, hash.help, resize, etc, which I assume isn't the case here. It does sound like this file may be beyond the repair of a tool and could require manual intervention or restoration. One thing I just thought of: are there indices on this file? Best of luck! At 10:49 AM 9/1/2004, you wrote: Hi Glen, This is the output when we first ran across the problem: 0008 Program FIS00200: Line 551, Internal data error. 0009 Program FIS00200: Line 555, Internal data error. 0010 Program FIS00200: Line 555, WRITE failure. Line 551 is a MATREADU from the file, and line 555 is a MATWRITE to the file. This file is a an archive of another file, so there cannot be any invalid characters in the key. We just ran fixtool on the file, which claimed to have found 657 errors and fixed 649 : Start Diagnostics. 0 Errors found in physical structure. 0 Errors found in file header. 0 Errors found in primary groups. 654 Errors found in data. 3 Other errors found in file. 657 Errors on file. Start Fixing. 649 Errors fixed. Fixtool Completed. but when I did a COUNT of the file there were still problems: WARNING: Internal file corruption detected during SCAN operation! Invalid pad length detected within record block! Filename: JOBHIST Group offset: 3575808 (0x0) Key: Abnormal termination of UniVerse. Fault type is 11. Layer type is Query. I am getting the sysadmin to run the fixtool command again thanks for your help, Glenn Herbert [EMAIL PROTECTED] on 01 Sep 2004 15:24 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: bcc: Subject:Re: RE: [U2] Universe file size limit I have a version of 9.6 (and beyond!) running here on an hp 11.11i with a few large files that exceed 4 gig (one is around 20 gig) with no problems; note that these files aren't exercised all that much as I don't really play around with this stuff much anymore. Additionally, we have a number of DS end users who have files that regularly exceed this size and don't have issues, so I'm sure it's something specific to your system. I don't recall you mentioning what the exact error was other than it being an internal data error, so maybe posting the entire message might jiggle some latent memory somewhere. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Correlative referencing multi-value field in another file
The translate returns MV data with spaces. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills Sent: Wednesday, September 01, 2004 9:11 AM To: [EMAIL PROTECTED] Subject: [U2] Correlative referencing multi-value field in another file We are trying to do a very basic PICK technique of summing a multi-value field in a F-type correlative. However, it appears uniVerse is not putting the multi-values onto it's stack as inividual values, but rather as one entry with the value markers replaced with blanks. Below are two dictionary definitions, the only difference is WO.COMPL.QTY does a sum as its last step. As can be seen by the LIST output, only single-value entries return a non-zero value. Anyone else come across this? And should it be working this way? We are on UV10.0.16 and HPUX11i. Thanks in advance -- Rod Hills WO.COMPL.QTY 0001 A 0002 0 0003 Wo Compl}Total 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8);S 0009 R 0010 8 WO.QTY.COMPL 0001 A 0002 0 0003 Wo Qty Compl 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8) 0009 R 0010 12 LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am 31 Aug 2004 PAGE 1 WIPOPERACT Wo Compl Wo Qty Compl Total... 89783*560 44 89433*111 0 14 1 78574*370 03 5 6 1 5 84804*780 0 2 2 3 3 5 3 88810*070 0 R7735*380 0 15 2 1 89922*630 0 60330*001 0 79101*000 0 18 60 5 2 10 3 2 90032*050 0 82930*110 0 88671*001 2937 2937 90449*260 0 3 20 4 3 60268*790 0 60129*720 0 79312*380 22 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Correlative referencing multi-value field in another fil e
Hi Rod,
I assist my customers who run both UniVerse and UniData in the Pick
flavor and created the following dict item to SUM the values from another
record:
0001: I (SQL)}}NUMERIC}Y}}}
0002: SUM(TRANS('WO-BOM',F0,3,'X'))
0003: MD4
0004: Test SUM
0005: 8R
0006: S
0007:
WO List values Test SUM
10045. 11.
5.
1.
10213. 3.
10381. 1.
S01011 1. 5.
1.
1.
1.
1.
1055 0.
1072 0.
Your dict item reminds me of the old PICK days. I still have 1
customer running the PICK operating system.
Have a Great Day!
Paul Trebbien
Kore Technologies, Senior Support Tech.
Solutions that work. People who care.
V 858.678.0030 F 858.300.2600 W www.koretech.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Rod Hills
Sent: Wednesday, September 01, 2004 8:11 AM
To: [EMAIL PROTECTED]
Subject: [U2] Correlative referencing multi-value field in another file
We are trying to do a very basic PICK technique of summing a multi-value
field
in a F-type correlative.
However, it appears uniVerse is not putting the multi-values onto it's
stack
as inividual values, but rather as one entry with the value markers replaced
with blanks.
Below are two dictionary definitions, the only difference is WO.COMPL.QTY
does
a sum as its last step.
As can be seen by the LIST output, only single-value entries return a
non-zero
value.
Anyone else come across this? And should it be working this way?
We are on UV10.0.16 and HPUX11i.
Thanks in advance
-- Rod Hills
WO.COMPL.QTY
0001 A
0002 0
0003 Wo Compl}Total
0004
0005
0006
0007
0008 F;0;(G0*1);(TWIP;X;;8);S
0009 R
0010 8
WO.QTY.COMPL
0001 A
0002 0
0003 Wo Qty Compl
0004
0005
0006
0007
0008 F;0;(G0*1);(TWIP;X;;8)
0009 R
0010 12
LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am 31 Aug 2004 PAGE1
WIPOPERACT Wo Compl Wo Qty Compl
Total...
89783*560 44
89433*111 0 14 1
78574*370 03 5 6 1 5
84804*780 0 2 2 3 3 5 3
88810*070 0
R7735*380 0 15 2 1
89922*630 0
60330*001 0
79101*000 0 18 60 5 2 10
3 2
90032*050 0
82930*110 0
88671*001 2937 2937
90449*260 0 3 20 4 3
60268*790 0
60129*720 0
79312*380 22
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe file size limit
Hello! We have had problems with big UV 64-bit files on HPUX11i PA-RISC. As far as I remember, it is UV version 9.6.2.1 or 9.6.1.smth, where a static hashed file bigger than 4GB could be killed by modifying a record (beyond the 4GB border?). That is, if one is just adding records to a file it is not a problem, we've seen them reaching 13GB smoothly. But modifying already existing record (so that its length changes?) may (it does not happen every time) mess up entire group. From filepeek it looked like record headers were getting overwritten by record data. Since then we are on 9.6.2.1, distributed every big file getting record updates so that none of them exceeds 4GB. Hope, this helps. Aleksejs. Date: Wed, 1 Sep 2004 14:47:30 +0100 From: [EMAIL PROTECTED] Subject: Memo: RE: [U2] Universe file size limit Hi, Thanks for all the responses. Ulimit, is set to unlimited so that shouldn't be the problem. Our unix support people cant find any other HPUX kernel parameter that would affect the maximum file size. Glen's recollection is correct - HPUX support file sizes up to 128 terabytes. It is looking increasingly as if this is a Universe 9.6 issue or a 9.6 on HPUX issue. is anyone running UV 9.6 with files over 4 GB? thanks again.. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Correlative referencing multi-value field in another file
No. It has Itypes too, just that some of us love to code in a manner that pre-dates Itypes. And for the challenge too! ;-) Oh. Or we have existing stuff already coded to support. At 12:40 PM 9/1/2004, you wrote: Wow, in Unidata this would be an I descriptor that would just be SUM(WO.COMP.QTY) in attr 2 of the dict. Guess UV doesn't have I desc's? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dianne Ackerman Sent: Wednesday, September 01, 2004 08:37 To: [EMAIL PROTECTED] Subject: Re: [U2] Correlative referencing multi-value field in another file Yes, this is the way it works, unfortunately. What we ended up doing was to change att 8 in WO.COMP.QTY to F;0(TWIP;X;;8);(G0 1);0(TWIP;X;;8);(G1 1);0(TWIP;X;;8);(G2 1);.;+;+;+;+ etc -Dianne Rod Hills wrote: We are trying to do a very basic PICK technique of summing a multi-value field in a F-type correlative. However, it appears uniVerse is not putting the multi-values onto it's stack as inividual values, but rather as one entry with the value markers replaced with blanks. Below are two dictionary definitions, the only difference is WO.COMPL.QTY does a sum as its last step. As can be seen by the LIST output, only single-value entries return a non-zero value. Anyone else come across this? And should it be working this way? We are on UV10.0.16 and HPUX11i. Thanks in advance -- Rod Hills WO.COMPL.QTY 0001 A 0002 0 0003 Wo Compl}Total 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8);S 0009 R 0010 8 WO.QTY.COMPL 0001 A 0002 0 0003 Wo Qty Compl 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8) 0009 R 0010 12 LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am 31 Aug 2004 PAGE 1 WIPOPERACT Wo Compl Wo Qty Compl Total... 89783*560 44 89433*111 0 14 1 78574*370 03 5 6 1 5 84804*780 0 2 2 3 3 5 3 88810*070 0 R7735*380 0 15 2 1 89922*630 0 60330*001 0 79101*000 0 18 60 5 2 10 3 2 90032*050 0 82930*110 0 88671*001 2937 2937 90449*260 0 3 20 4 3 60268*790 0 60129*720 0 79312*380 22 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV: FMT and FMTS processing of CHAR(247) differs
Dear All! Please, shed some light on the strange behaviour of UV BASIC FMTS function. Environment: UV 9.6.2.6 and 9.6.2.1 on HPUX 11i on PA-RISC 8xxx. Problem: FMTS is supposed to FMT each field of a given dynamic array. It appears to be wrong if source data in a field of the array contains CHAR(247). The character in question is a letter of Latvian language, one of three languages we've packed into 256 ASCII values and it would be hard to relocate it to some other place, not to mention conversion of terabytes of data and hundreds of workplaces we have. Reproduction: following program in our environment gives following results: SUBROUTINE SWR.T1 T='This is a text which will wrap at some point' T:[EMAIL PROTECTED]:'Here goes another field yet with same purpose' F=FMTS(T, '16T') CONVERT @TM TO CHAR(10) IN F CONVERT @FM TO '|' IN F CONVERT CHAR(32) TO '.' IN F CONVERT CHAR(247) TO '=' IN F PRINT 'FMTS=' PRINT F PRINT '=FMTS' T='This is a text which will wr':CHAR(247):'p at some point' T:[EMAIL PROTECTED]:'Here goes ano':CHAR(247):'her field yet with same purpose' F=FMTS(T, '16T') CONVERT @TM TO CHAR(10) IN F CONVERT @FM TO '|' IN F CONVERT CHAR(32) TO '.' IN F CONVERT CHAR(247) TO '=' IN F PRINT 'FMTS=' PRINT F PRINT '=FMTS' F=FMT(T1, '16T'):@FM:FMT(T2, '16T') CONVERT @TM TO CHAR(10) IN F CONVERT @FM TO '|' IN F CONVERT CHAR(32) TO '.' IN F CONVERT CHAR(247) TO '=' IN F PRINT 'FMT=' PRINT F PRINT '=FMT' END FMTS= This.is.a.text.. which.will.wrap. at.some.point...|Here.goes... another.field... yet.with.same... purpose. =FMTS FMTS= This.is.a.text.. which.will.wr...=p.at.some.point.|Here.goes.ano...=her.field.yet... with.same... purpose. =FMTS FMT= This.is.a.text.. which.will.wr=p. at.some.point...|Here.goes... ano=her.field... yet.with.same... purpose. =FMT Thank you in advance, Aleksejs. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Senior Pick Programmer position Denver, Colorado
William, Unless I missed it, there's no locational information in the post, which makes Relocation will not be considered - we are seeking a local candidate. difficult. -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail [EMAIL PROTECTED] - Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED]- Zeus Data Integration Mount Olympus, Home of Zeus Data Integration --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Correlative referencing multi-value field in another file
Allen, Universe does have I-descriptors, but the programmer was trying to build an F-correlative (from old PICK) to do the task. -- Rod Hills -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 9:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Correlative referencing multi-value field in another file Wow, in Unidata this would be an I descriptor that would just be SUM(WO.COMP.QTY) in attr 2 of the dict. Guess UV doesn't have I desc's? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dianne Ackerman Sent: Wednesday, September 01, 2004 08:37 To: [EMAIL PROTECTED] Subject: Re: [U2] Correlative referencing multi-value field in another file Yes, this is the way it works, unfortunately. What we ended up doing was to change att 8 in WO.COMP.QTY to F;0(TWIP;X;;8);(G0 1);0(TWIP;X;;8);(G1 1);0(TWIP;X;;8);(G2 1);.;+;+;+;+ etc -Dianne Rod Hills wrote: We are trying to do a very basic PICK technique of summing a multi-value field in a F-type correlative. However, it appears uniVerse is not putting the multi-values onto it's stack as inividual values, but rather as one entry with the value markers replaced with blanks. Below are two dictionary definitions, the only difference is WO.COMPL.QTY does a sum as its last step. As can be seen by the LIST output, only single-value entries return a non-zero value. Anyone else come across this? And should it be working this way? We are on UV10.0.16 and HPUX11i. Thanks in advance -- Rod Hills WO.COMPL.QTY 0001 A 0002 0 0003 Wo Compl}Total 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8);S 0009 R 0010 8 WO.QTY.COMPL 0001 A 0002 0 0003 Wo Qty Compl 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8) 0009 R 0010 12 LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am 31 Aug 2004 PAGE 1 WIPOPERACT Wo Compl Wo Qty Compl Total... 89783*560 44 89433*111 0 14 1 78574*370 03 5 6 1 5 84804*780 0 2 2 3 3 5 3 88810*070 0 R7735*380 0 15 2 1 89922*630 0 60330*001 0 79101*000 0 18 60 5 2 10 3 2 90032*050 0 82930*110 0 88671*001 2937 2937 90449*260 0 3 20 4 3 60268*790 0 60129*720 0 79312*380 22 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: Senior Pick Programmer position Denver, Colorado
Denver, Colorado isnt specific enough? Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Senior Pick Programmer position Denver, Colorado
Oh gosh, read the subject? Denver CO sounds like a location to me :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Results Sent: Wednesday, September 01, 2004 10:59 To: [EMAIL PROTECTED] Subject: Re: [U2] Senior Pick Programmer position Denver, Colorado William, Unless I missed it, there's no locational information in the post, which makes Relocation will not be considered - we are seeking a local candidate. difficult. -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail [EMAIL PROTECTED] - Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED]- Zeus Data Integration Mount Olympus, Home of Zeus Data Integration --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Correlative referencing multi-value field in another file
Hi Rod, I too have had the 'pleasure' of F and A correlatives. Once upon a time, a nice man named Dick Pick, who created Pick basic, issued a challenge. He said that there was no way in native Pick to access the last value of a multivalued field and challenged anyone to find a way. Enter Me. 'A' correlatives were new at that time and I created a three step dict. Dict step1 converted value marks into 1 's. Dict step2 summed those 1's into a number, and Dict step3 used that sum as an index for the value and BINGO last value of a multivalued field in native Pick! I did the 'victory dance' big time while singing feeling stronger from the Rocky movies :-D !!! And then proceeded to pack up my solution and send the results to Dick. Dick replied to me that the challenge was only for F correlatives (ahh, shucks..) but that he would publish my solution since nobody else had ever done so yet. Publish as in paper before the internet became widely used. So, that was my 15 seconds of fame Today, I prefer SUBR type dicts over all else if it takes me more than a couple of seconds to try to figure out what to do. However, I'm currently working for a client with a..Legacy Pick system without SUBR's. gaa... Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rod Hills Sent: Wednesday, September 01, 2004 11:01 To: [EMAIL PROTECTED] Subject: RE: [U2] Correlative referencing multi-value field in another file Allen, Universe does have I-descriptors, but the programmer was trying to build an F-correlative (from old PICK) to do the task. -- Rod Hills -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 9:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Correlative referencing multi-value field in another file Wow, in Unidata this would be an I descriptor that would just be SUM(WO.COMP.QTY) in attr 2 of the dict. Guess UV doesn't have I desc's? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dianne Ackerman Sent: Wednesday, September 01, 2004 08:37 To: [EMAIL PROTECTED] Subject: Re: [U2] Correlative referencing multi-value field in another file Yes, this is the way it works, unfortunately. What we ended up doing was to change att 8 in WO.COMP.QTY to F;0(TWIP;X;;8);(G0 1);0(TWIP;X;;8);(G1 1);0(TWIP;X;;8);(G2 1);.;+;+;+;+ etc -Dianne Rod Hills wrote: We are trying to do a very basic PICK technique of summing a multi-value field in a F-type correlative. However, it appears uniVerse is not putting the multi-values onto it's stack as inividual values, but rather as one entry with the value markers replaced with blanks. Below are two dictionary definitions, the only difference is WO.COMPL.QTY does a sum as its last step. As can be seen by the LIST output, only single-value entries return a non-zero value. Anyone else come across this? And should it be working this way? We are on UV10.0.16 and HPUX11i. Thanks in advance -- Rod Hills WO.COMPL.QTY 0001 A 0002 0 0003 Wo Compl}Total 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8);S 0009 R 0010 8 WO.QTY.COMPL 0001 A 0002 0 0003 Wo Qty Compl 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8) 0009 R 0010 12 LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am 31 Aug 2004 PAGE 1 WIPOPERACT Wo Compl Wo Qty Compl Total... 89783*560 44 89433*111 0 14 1 78574*370 03 5 6 1 5 84804*780 0 2 2 3 3 5 3 88810*070 0 R7735*380 0 15 2 1 89922*630 0 60330*001 0 79101*000 0 18 60 5 2 10 3 2 90032*050 0 82930*110 0 88671*001 2937 2937 90449*260 0 3 20 4 3 60268*790 0 60129*720 0 79312*380 22 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands
My with and without scores were 78 seconds and 80 seconds respectively. Yes, without took longer. It was 1000 updates, the same record set, and a simple RETURN after the parameters. The trigger was AFTER INSERT UPDATE DELETE. Maybe the INSERTS take longer or system load may have been radically different. j -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Tuesday, August 31, 2004 6:24 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Trigger not intensive, it's what you do with trigger! Was RE: [U2] Dot Commands I beg to differ. I created a trigger program that does nothing; just the subroutine header and a RETURN. Creating a series of records took 17 seconds without the trigger and 291 with it. Quite an overhead I'd say. Adding hardware won't sort the replication problem. Universe will not allow a published or subscribed file to have triggers on it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 31 August 2004 09:18 To: [EMAIL PROTECTED] Subject: [U2] Trigger not intensive, it's what you do with trigger! Was RE: [U2] Dot Commands A trigger need not necessarily be intensive - tho' admittedly the concept of an audit or any process requiring a write will mean the extra overhead of that write. The thing to watch out for is the temptation to read lots and write lots... Then imagine this blowing out exponentially as 3 zillion records are written, read, updated, and deleted. If, however, you intend to entirely cripple a site, you could always add triggers to update files that in turn have triggers that update others in a sort of round-robin... just imagine, what overhead that would involve! smile As for replication - just add another hardware controller to machine - every write will initiate two hardware writes -- no lag, overhead, everything instant. -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 August, 2004 9:02 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Dot Commands Bear in mind though that a trigger is a very intensive thing to add to a file. Just try timings on writes with and without them. Also you cannot replicate a file with triggers (major problem for use that I would LOVE IBM to fix.) PRE - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp/PRE --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: FMT and FMTS processing of CHAR(247) differs
Problem: FMTS is supposed to FMT each field of a given dynamic array. It appears to be wrong if source data in a field of the array contains CHAR(247). If you look at the DOCs for REMOVE (for example), it indicates that the lowest system delimiter is CHAR(248), and that is true with REMOVE. However, I've noticed that some of the functions like FMTS() and FIELDS() also consider CHAR(247) to be a system delimiter. Experimentation has shown me that CHAR(246) and below are safe to use. I've always wondered about the discrepancy though. Barry --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Senior Pick Programmer position Denver, Colorado
I think codingitis is the cause. Time to lay off the keyboard for a while, man. You know, semi-colons start to disappear after 6 hours of continuous coding. Any higher amount of time can cause strange things to happen. I remember starting during mid-day and missing night-time once, while programming a test application in Borland C 3.0. I think my brain crashed and rebooted to idle, for the rest of the day. Though, I can't really remember much about that day.. or the application for that matter. *pondering look* I do remember that there was one compiling error that never went away. Probably a missing semi-colon... :P Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Wednesday, September 01, 2004 2:09 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Senior Pick Programmer position Denver, Colorado Chuck Did you have nourishment today? Eat some carrots lately? Have your glasses on? ;-) It's in the subject line...Denver ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Results Sent: Wednesday, September 01, 2004 1:59 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Senior Pick Programmer position Denver, Colorado William, Unless I missed it, there's no locational information in the post, which makes Relocation will not be considered - we are seeking a local candidate. difficult. -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail [EMAIL PROTECTED] - Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED]- Zeus Data Integration Mount Olympus, Home of Zeus Data Integration --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Delete a Printer Universe
Since I haven't done this in some time. I cant remember how to do this. I added a printer that I now wish to delete. I am using a dumb terminal to do this via the SYSADM.MENU menu. There appears to be menu options at the top File, Action, Help. I guess I need the magic keystroke for Action. Hopefully, there is a delete in there somewhere. I realize that I could delete the printer from DEVICE. Then it would still be in sp.config ? I don't think that is one of those files that you should be editing or is it ? Is there a command line way of doing this ? Why do the simple things always give me trouble ? Thanks Anthony --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Senior Pick Programmer position Denver, Colorado
But Debra, all you need is an A below the B, on your (ahem, ahem), and then you'll have a TBA tattoo (To Be Announced). You can have a lucrative career doing commercials for TV Guide. It was like experiencing a nuclear explosion in a very small place. - Loni Anderson, describing having sex with WKRP in Cincinnati costar Gary Sandy David Hanwell -Original Message- From: [EMAIL PROTECTED] On Behalf Of Debster Sent: Wednesday, September 01, 2004 4:03 PM EDT To: [EMAIL PROTECTED] Subject: RE: [U2] Senior Pick Programmer position Denver, Colorado And when you have keyboard imprints on your forehead, it's really gone too far. I am still trying to get rid of the T on my forehead and the B on my nose. -Original Message- From: [EMAIL PROTECTED] On Behalf Of Glen B Sent: Wednesday, September 01, 2004 3:46 PM EDT To: [EMAIL PROTECTED] Subject: RE: [U2] Senior Pick Programmer position Denver, Colorado I think codingitis is the cause. Time to lay off the keyboard for a while, man. You know, semi-colons start to disappear after 6 hours of continuous coding. Any higher amount of time can cause strange things to happen. I remember starting during mid-day and missing night-time once, while programming a test application in Borland C 3.0. I think my brain crashed and rebooted to idle, for the rest of the day. Though, I can't really remember much about that day, or the application for that matter. *pondering look* I do remember that there was one compiling error that never went away. Probably a missing semi-colon. :P Glen -Original Message- From: [EMAIL PROTECTED] On Behalf Of Debster Sent: Wednesday, September 01, 2004 2:09 PM EDT To: [EMAIL PROTECTED] Subject: RE: [U2] Senior Pick Programmer position Denver, Colorado Chuck Did you have nourishment today? Eat some carrots lately? Have your glasses on? ;-) It's in the subject line...Denver ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Results Sent: Wednesday, September 01, 2004 1:59 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Senior Pick Programmer position Denver, Colorado William, Unless I missed it, there's no locational information in the post, which makes Relocation will not be considered - we are seeking a local candidate. difficult. -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail [EMAIL PROTECTED] - Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED]- Zeus Data Integration Mount Olympus, Home of Zeus Data Integration CONFIDENTIALITY This e-mail and any attachments are confidential and also may be privileged. If you are not the named recipient, or have otherwise received this communication in error, please delete it from your inbox, notify the sender immediately, and do not disclose its contents to any other person, use them for any purpose, or store or copy them in any medium. Thank you for your cooperation. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: FMT and FMTS processing of CHAR(247) differs
I've heard once that UniVerse goes down to char(246) as system delimiters. Don't know where it came from. (Probably this list) I would love to have the ability to access those values with the normal tools of Basic or UniObjects, but I guess this is one case where there show through. Martin Scholl President Martin Scholl Consulting, Inc. http://www.hipaasuite.com/ mailto:[EMAIL PROTECTED] 18910 New Hampshire Ave Brinklow, MD 20862 301-924-5537 Phone 301-570-0139 Fax 301-613-9572 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik Sent: Wednesday, September 01, 2004 3:36 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] UV: FMT and FMTS processing of CHAR(247) differs Problem: FMTS is supposed to FMT each field of a given dynamic array. It appears to be wrong if source data in a field of the array contains CHAR(247). If you look at the DOCs for REMOVE (for example), it indicates that the lowest system delimiter is CHAR(248), and that is true with REMOVE. However, I've noticed that some of the functions like FMTS() and FIELDS() also consider CHAR(247) to be a system delimiter. Experimentation has shown me that CHAR(246) and below are safe to use. I've always wondered about the discrepancy though. Barry --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata shared memory and catalogs
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno I've tried the !NEWPCODE and !NEWVERSION ... Sorry, I missed that detail in my previous response. The problem I usually have w/ NEWPCODE is the syntax. You might try using FIBCDFN in the AE editor and see if that causes any difference. At least then you know NEWPCODE is executed with the right syntax. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata with AccuTerm?
I'm no Wintegrate person, so I can't say what's happening there, but I have seen terminal types send an ASCII 127 (DEL) for a BS. To the terminal it looks perfectly normal but to the command interpreter it's totally whacked. What does PTERM -DISPLAY show? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Wednesday, September 01, 2004 9:10 PM To: [EMAIL PROTECTED] Subject: [U2] Unidata with AccuTerm? I've been having a heck of a time at ECL on Unidata PE 6.0 with AccuTerm 2k2 - all over WinXP Pro. I'm not sure of which terminal emulation is best, or even how to check/set the term type in Unidata. term vt100 doesn't return a confirmation and term just returns A,B,C,D help with nothing about term type. Are there any other settings in AccuTerm that should or should not be set for best results? Gosh I hope this isn't a case of reading friendly manuals cuz I think I've been through them. The problem seems to be that a backspace looks like a backspace, but it seems to leave some character embedded in the entered string, so what is seen on the screen is not what is being processed by the system, and I get lots of syntax errors. I get a lot of these errors even if I enter a command perfectly. Sometimes just doing a .x will return a good execution, othertimes a copy/paste of what's on the screen works - sometimes not... Thanks much! Tony Nebula RD --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
