Ian you don't happen to have an example of what this code *does* do you?
-----Original Message----- From: McGowan, Ian <james.mcgo...@bankofthewest.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Mon, Mar 3, 2014 1:35 pm Subject: Re: [U2] Reporting Tools If you're not already, it's a really good idea to consider creating something that will make producing excel files (the number one choice of accounting groups everywhere) from your "reports" easily. Many years ago we used to physically print a bunch of reports each night, but since creating a tool the users can easily use, almost everything is electronic. http://www.pickwiki.com/cgi-bin/wiki.pl?DumpRecall shows one way to do it, though it's pretty specific to our needs. It wouldn't be hard to use this as inspiration for something that works in your own environment. I'd forgotten about the 150 field limit in unidata, but this comment remembers: * We have a list of field names and a select, parse them the hard way * and write a tab-seperated file. This is slower but avoids limitations * on the number of columns (of unidata) and the perl module WriteExcel -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Monday, March 03, 2014 1:05 PM To: U2 Users List; dmcgr...@rocketsoftware.com Subject: Re: [U2] Reporting Tools On 3/3/14, 4:01 PM, Daniel McGrath wrote: > Hi Jeff, > > In case you missed it before: > > " Does your query use the LIMIT keyword? This is an internally hardcoded > limit that was increased, IIRC, in 7.3.6 to 250." > > On further checking, here is the issue, along with fix version. I suggest you update to the latest UDT version. > > UDT-4284 -> Request for UniQuery hard limit of 150 attributes (in LIST > or REFORMAT commands) to be increased > > A change was made to increase this to 250 attributes in 7.3.5. The actual limit has now been added to the report from the LIMIT verb so you can see limitation as "U_ATTRLIST" Thanks Dan - this helps immensely. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ----------------------------------------- IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. _______________________________________________ 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
