Re: [U2] udt dir file max key length
Hi Symeon, The DIR key length in UDT is 124. Sure you do not have an @VM in the key? That would give you this error. Thanks, Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 21 July 2011 20:38 To: 'U2 Users List' Subject: [U2] udt dir file max key length I have a dir type file in udt, at linux I can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB 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. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 is pretty small tho ... -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: 22 July 2011 11:22 To: 'U2 Users List' Subject: RE: [U2] udt dir file max key length These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed Enter CR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 22 July 2011 09:51 To: U2 Users List Subject: Re: [U2] udt dir file max key length Hi Symeon, The DIR key length in UDT is 124. Sure you do not have an @VM in the key? That would give you this error. Thanks, Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 21 July 2011 20:38 To: 'U2 Users List' Subject: [U2] udt dir file max key length I have a dir type file in udt, at linux I can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB 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. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1390 / Virus Database: 1518/3779 - Release Date: 07/21/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 22 July 2011 13:55 To: 'U2 Users List' Subject: Re: [U2] udt dir file max key length MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 is pretty small tho ... -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: 22 July 2011 11:22 To: 'U2 Users List' Subject: RE: [U2] udt dir file max key length These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed Enter CR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 22 July 2011 09:51 To: U2 Users List Subject: Re: [U2] udt dir file max key length Hi Symeon, The DIR key length in UDT is 124. Sure you do not have an @VM in the key? That would give you this error. Thanks, Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 21 July 2011 20:38 To: 'U2 Users List' Subject: [U2] udt dir file max key length I have a dir type file in udt, at linux I can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB 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. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message
Re: [U2] udt dir file max key length
Which is odd, as linux has the files in the directory no problem and i can work with those files using shell commands, awk, python and php. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 22 July 2011 14:21 To: U2 Users List Subject: Re: [U2] udt dir file max key length Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 22 July 2011 13:55 To: 'U2 Users List' Subject: Re: [U2] udt dir file max key length MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 is pretty small tho ... -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: 22 July 2011 11:22 To: 'U2 Users List' Subject: RE: [U2] udt dir file max key length These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed Enter CR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 22 July 2011 09:51 To: U2 Users List Subject: Re: [U2] udt dir file max key length Hi Symeon, The DIR key length in UDT is 124. Sure you do not have an @VM in the key? That would give you this error. Thanks, Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 21 July 2011 20:38 To: 'U2 Users List' Subject: [U2] udt dir file max key length I have a dir type file in udt, at linux I can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB 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. Any views and/or opinions expressed in this e-mail are of the author
Re: [U2] udt dir file max key length
I did a little experimenting with UV under HP-UX as I was curious... I first tried a Type 19 file, and it worked fine. Then tried a Type 1, and it truncated the IDs. # ll total 0 -rw-rw-rw- 1 root sys 0 Jul 22 09:49 .Type1 -rw-rw-rw- 1 root sys 0 Jul 22 09:49 ABCDEFGHIJKLMNOPQRSTUV WXYZABCDEFGHIJKLMNOPQRSTUVWXYZ -rw-rw-rw- 1 root sys 0 Jul 22 09:49 ABCDEFGHIJKLMNOPQRSTUV WXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 -rw-rw-rw- 1 root sys 0 Jul 22 09:49 ABCDEFGHIJKLMNOPQRSTUV WXYZABCDEFGHIJKLMNOPQRSTUVWXYZ222 -rw-rw-rw- 1 root sys 0 Jul 22 09:49 ABCDEFGHIJKLMNOPQRSTUV WXYZABCDEFGHIJKLMNOPQRSTUVWXYZ22233 -rw-rw-rw- 1 root sys 0 Jul 22 09:49 ABCDEFGHIJKLMNOPQRSTUV WXYZABCDEFGHIJKLMNOPQRSTUVWXYZ22233 # exit :SELECT TESTNAMES 5 record(s) selected to SELECT list #0. :DELETE TESTNAMES You have an active SELECT list. Do you wish to DELETE the records previously SELECTed? The first record ID = ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ. Enter Y or N: Y File name ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ too long. Truncated to ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNO. Record ID ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ not found. File name ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 too long. Truncated to ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNO. Record ID ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 not found. File name ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 111222 too long. Truncated to ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNO. Record ID ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 111222 not found. File name ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 11122233 too long. Truncated to ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNO. Record ID ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 11122233 not found. File name ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 11122233 too long. Truncated to ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNO. Record ID ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ1 11122233 not found. 0 records DELETEd. :LIMIT Current Limits are: PROGRAMSIZE: UNLIMITED As you can see, HP-UX has no issue with the long filenames, but UV did when it was a Type 1 file. But Type 19 worked fine... Not sure if this helps or no considering the different platforms both on the U@ and OS side, but I thought it was interesting none-the-less. Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Symeon Breen syme...@gmail.com 7/22/2011 8:54 AM Which is odd, as linux has the files in the directory no problem and i can work with those files using shell commands, awk, python and php. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 22 July 2011 14:21 To: U2 Users List Subject: Re: [U2] udt dir file max key length Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 22 July 2011 13:55 To: 'U2 Users List' Subject: Re: [U2] udt dir file max key length MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number
Re: [U2] udt dir file max key length
Try ls -b at a linux prompt to see if there are any unprintable characters in any of the names Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, July 22, 2011 3:22 AM To: 'U2 Users List' Subject: Re: [U2] udt dir file max key length These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed Enter CR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 22 July 2011 09:51 To: U2 Users List Subject: Re: [U2] udt dir file max key length Hi Symeon, The DIR key length in UDT is 124. Sure you do not have an @VM in the key? That would give you this error. Thanks, Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 21 July 2011 20:38 To: 'U2 Users List' Subject: [U2] udt dir file max key length I have a dir type file in udt, at linux I can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB 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. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1390 / Virus Database: 1518/3779 - Release Date: 07/21/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada -Original Message- From: Symeon Breen Thanks - ud just has DIR type files no type 1 or 19. We have got round it anyway... -Original Message- From: Robert Porter I did a little experimenting with UV under HP-UX as I was curious... I first tried a Type 19 file, and it worked fine. Then tried a Type 1, and it truncated the IDs. SNIP :LIMIT Current Limits are: PROGRAMSIZE: UNLIMITED As you can see, HP-UX has no issue with the long filenames, but UV did when it was a Type 1 file. But Type 19 worked fine... Not sure if this helps or no considering the different platforms both on the U@ and OS side, but I thought it was interesting none-the-less. Robert Symeon Breen 7/22/2011 8:54 AM Which is odd, as linux has the files in the directory no problem and i can work with those files using shell commands, awk, python and php. -Original Message- From: Martin Braid Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: Symeon Breen MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 Is pretty small tho ... -Original Message- From: Symeon Breen These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed Enter CR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
Really! My machine looks like: 5 Dev (0)- LIMIT U_MAXFNAME: File name limit = 118. Windows 2008 R2 and UD v7.2.7 If this isn't configurable, as Wally says, I wonder what accounts for the difference between our two environments? Bill - Original Message - *From:* alfke...@hotmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 7/22/2011 9:13 AM *Subject:* Re: [U2] udt dir file max key length Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada -Original Message- From: Symeon Breen Thanks - ud just has DIR type files no type 1 or 19. We have got round it anyway... -Original Message- From: Robert Porter I did a little experimenting with UV under HP-UX as I was curious... I first tried a Type 19 file, and it worked fine. Then tried a Type 1, and it truncated the IDs. SNIP :LIMIT Current Limits are: PROGRAMSIZE: UNLIMITED As you can see, HP-UX has no issue with the long filenames, but UV did when it was a Type 1 file. But Type 19 worked fine... Not sure if this helps or no considering the different platforms both on the U@ and OS side, but I thought it was interesting none-the-less. Robert Symeon Breen 7/22/2011 8:54 AM Which is odd, as linux has the files in the directory no problem and i can work with those files using shell commands, awk, python and php. -Original Message- From: Martin Braid Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: Symeon Breen MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 Is pretty small tho ... -Original Message- From: Symeon Breen These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed EnterCR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
Earlier code branch (Windows vs UNIX) differences were made consistent at 7.2. This is an internal UniData limit. It is not configurable. What the OS supports is different (though must support at least the UniData limit). Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, July 22, 2011 11:52 AM To: U2 Users List Subject: Re: [U2] udt dir file max key length Really! My machine looks like: 5 Dev (0)- LIMIT U_MAXFNAME: File name limit = 118. Windows 2008 R2 and UD v7.2.7 If this isn't configurable, as Wally says, I wonder what accounts for the difference between our two environments? Bill - Original Message - *From:* alfke...@hotmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 7/22/2011 9:13 AM *Subject:* Re: [U2] udt dir file max key length Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada -Original Message- From: Symeon Breen Thanks - ud just has DIR type files no type 1 or 19. We have got round it anyway... -Original Message- From: Robert Porter I did a little experimenting with UV under HP-UX as I was curious... I first tried a Type 19 file, and it worked fine. Then tried a Type 1, and it truncated the IDs. SNIP :LIMIT Current Limits are: PROGRAMSIZE: UNLIMITED As you can see, HP-UX has no issue with the long filenames, but UV did when it was a Type 1 file. But Type 19 worked fine... Not sure if this helps or no considering the different platforms both on the U@ and OS side, but I thought it was interesting none-the-less. Robert Symeon Breen 7/22/2011 8:54 AM Which is odd, as linux has the files in the directory no problem and i can work with those files using shell commands, awk, python and php. -Original Message- From: Martin Braid Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: Symeon Breen MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 Is pretty small tho ... -Original Message- From: Symeon Breen These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed EnterCR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
I'm connected to a win 2000 UD 6.0.6 and a win 2003 UD 7.1.6 system and both are 198. I guess they had to lower it to make it consistent among the various OS's. Colin -Original Message- From: Bill Haskett Really! My machine looks like: 5 Dev (0)- LIMIT U_MAXFNAME: File name limit = 118. Windows 2008 R2 and UD v7.2.7 If this isn't configurable, as Wally says, I wonder what accounts for the difference between our two environments? Bill - Original Message - *From:* alfke Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
Its something like Static void installUdt(){ U_MAXFILENAME = random(254); } -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 22 July 2011 18:52 To: U2 Users List Subject: Re: [U2] udt dir file max key length Really! My machine looks like: 5 Dev (0)- LIMIT U_MAXFNAME: File name limit = 118. Windows 2008 R2 and UD v7.2.7 If this isn't configurable, as Wally says, I wonder what accounts for the difference between our two environments? Bill - Original Message - *From:* alfke...@hotmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 7/22/2011 9:13 AM *Subject:* Re: [U2] udt dir file max key length Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada -Original Message- From: Symeon Breen Thanks - ud just has DIR type files no type 1 or 19. We have got round it anyway... -Original Message- From: Robert Porter I did a little experimenting with UV under HP-UX as I was curious... I first tried a Type 19 file, and it worked fine. Then tried a Type 1, and it truncated the IDs. SNIP :LIMIT Current Limits are: PROGRAMSIZE: UNLIMITED As you can see, HP-UX has no issue with the long filenames, but UV did when it was a Type 1 file. But Type 19 worked fine... Not sure if this helps or no considering the different platforms both on the U@ and OS side, but I thought it was interesting none-the-less. Robert Symeon Breen 7/22/2011 8:54 AM Which is odd, as linux has the files in the directory no problem and i can work with those files using shell commands, awk, python and php. -Original Message- From: Martin Braid Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: Symeon Breen MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 Is pretty small tho ... -Original Message- From: Symeon Breen These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed EnterCR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1390 / Virus Database: 1518/3781 - Release Date: 07/22/11 ___ U2-Users
Re: [U2] udt dir file max key length
As Wally pointed out, this was standardized in U2 across OS releases as per 7.2 Earlier wasn't standardized across Windows and UNIX. Bill Haskett's was on UD 7.2.7 (post-standardization) Colin Alfke's was on UD 6.0.1 (pre-standardization) Regards, Dan McGrath U2 Product Manager Rocket Software 4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA Tel: +1.720.475.8098 * Fax: +1.617.630.7392 Email: dmcgr...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, July 22, 2011 2:51 PM To: 'U2 Users List' Subject: Re: [U2] udt dir file max key length Its something like Static void installUdt(){ U_MAXFILENAME = random(254); } -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 22 July 2011 18:52 To: U2 Users List Subject: Re: [U2] udt dir file max key length Really! My machine looks like: 5 Dev (0)- LIMIT U_MAXFNAME: File name limit = 118. Windows 2008 R2 and UD v7.2.7 If this isn't configurable, as Wally says, I wonder what accounts for the difference between our two environments? Bill - Original Message - *From:* alfke...@hotmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 7/22/2011 9:13 AM *Subject:* Re: [U2] udt dir file max key length Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada -Original Message- From: Symeon Breen Thanks - ud just has DIR type files no type 1 or 19. We have got round it anyway... -Original Message- From: Robert Porter I did a little experimenting with UV under HP-UX as I was curious... I first tried a Type 19 file, and it worked fine. Then tried a Type 1, and it truncated the IDs. SNIP :LIMIT Current Limits are: PROGRAMSIZE: UNLIMITED As you can see, HP-UX has no issue with the long filenames, but UV did when it was a Type 1 file. But Type 19 worked fine... Not sure if this helps or no considering the different platforms both on the U@ and OS side, but I thought it was interesting none-the-less. Robert Symeon Breen 7/22/2011 8:54 AM Which is odd, as linux has the files in the directory no problem and i can work with those files using shell commands, awk, python and php. -Original Message- From: Martin Braid Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: Symeon Breen MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 Is pretty small tho ... -Original Message- From: Symeon Breen These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed EnterCR to print non exist record ids
[U2] udt dir file max key length
I have a dir type file in udt, at linux i can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users