Thanks - ud just has DIR type files no type 1 or 19. We have got round it anyway...
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Robert Porter Sent: 22 July 2011 15:55 To: 'U2 Users List' Subject: 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 WXYZABCDEFGHIJKLMNOPQRSTUVWXYZ111111111111111111111111222 -rw-rw-rw- 1 root sys 0 Jul 22 09:49 ABCDEFGHIJKLMNOPQRSTUV WXYZABCDEFGHIJKLMNOPQRSTUVWXYZ111111111111111111111111222333333 -rw-rw-rw- 1 root sys 0 Jul 22 09:49 ABCDEFGHIJKLMNOPQRSTUV WXYZABCDEFGHIJKLMNOPQRSTUVWXYZ11111111111111111111111122233333344444444 # 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 "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ11111111111111111 1111111222" too long. Truncated to "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNO". Record ID "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ11111111111111111 1111111222" not found. File name "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ11111111111111111 1111111222333333" too long. Truncated to "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNO". Record ID "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ11111111111111111 1111111222333333" not found. File name "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ11111111111111111 111111122233333344444444" too long. Truncated to "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNO". Record ID "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ11111111111111111 111111122233333344444444" 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" <[email protected]> 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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:[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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 [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/cEhBHztrnE!TndxI!oX7UpIe2cJSs1Vg4i!ocMhca Y+Nwo1dRRiefi0mV47D3UFTaE21WAAq94YDNW0+5ADKWw== to report this email as spam. -------------------------------------------------------- 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. _______________________________________________ U2-Users mailing list [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
