Re: [U2] Reporting Tools

2014-03-04 Thread Riverman
The program does use the heading from DICT as a default column heading. I included 65 lines of explanations and examples in the program but left out some of the information for this post in the interest of brevity. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.co

Re: [U2] Reporting Tools

2014-03-04 Thread Will Johnson
How option an (Option to include or not include column headings ? -Original Message- From: Riverman [via U2 (UniVerse & UniData)] To: Will Johnson Sent: Tue, Mar 4, 2014 10:53 am Subject: Re: Reporting Tools I created a program (LIST.EXPORT) that works similar to the LIST c

Re: [U2] Reporting Tools

2014-03-04 Thread Riverman
I created a program (LIST.EXPORT) that works similar to the LIST command. The report has tab delimited columns and is output to the &HOLD& file. The command line command LIST.EXPORT allows conv and col.hdg column modifiers. The command requires a saved list name to know which records to select. I s

Re: [U2] Reporting Tools

2014-03-03 Thread McGowan, Ian
Monday, March 03, 2014 1:42 PM To: u2-users@listserver.u2ug.org<mailto:u2-users@listserver.u2ug.org> Subject: Re: [U2] Reporting Tools Ian you don't happen to have an example of what this code *does* do you? IMPORTANT NOTICE: This message is intend

Re: [U2] Reporting Tools

2014-03-03 Thread Bill Haskett
t; TO 0 UDT.RESPONSE = ■1436 records selected to list 0.■■ Destination 0 Named List 0 (Delete Temp File) LSELECT0031 file deleted... > Makes one wonder...h. Bill Untitled Page ---------------- - Original Message - *From:* r

Re: [U2] Reporting Tools

2014-03-03 Thread Wjhonson
Ian you don't happen to have an example of what this code *does* do you? -Original Message- From: McGowan, Ian To: U2 Users List 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

Re: [U2] Reporting Tools

2014-03-03 Thread McGowan, Ian
ata) 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/

Re: [U2] Reporting Tools

2014-03-03 Thread Rotman, David
As a work around, would this work: * produce file1 with record key and then 100+ data fields * produce file2 with remaining data fields * execute Linux command: paste file1 file2 >myrealdata.csv David Rotman, Ph.D. Associate Vice President for Technology Chief Information Officer Cedarville

Re: [U2] Reporting Tools

2014-03-03 Thread jeffrey Butera
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

Re: [U2] Reporting Tools

2014-03-03 Thread Daniel McGrath
On Behalf Of jeffrey Butera Sent: Monday, March 03, 2014 1:34 PM To: U2 Users List; jscha...@gmail.com Subject: Re: [U2] Reporting Tools On 3/3/14, 3:21 PM, Jeff Schasny wrote: > Jeff, > > What I think many of us are suggesting is essentially "if it hurts > when you do that, do

Re: [U2] Reporting Tools

2014-03-03 Thread Rutherford, Marc
-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Monday, March 03, 2014 12:34 PM To: U2 Users List; jscha...@gmail.com Subject: Re: [U2] Reporting Tools On 3/3/14, 3:21 PM, Jeff Schasny wrote: > Jeff, > > What I think many of us are

Re: [U2] Reporting Tools

2014-03-03 Thread jeffrey Butera
On 3/3/14, 3:21 PM, Jeff Schasny wrote: Jeff, What I think many of us are suggesting is essentially "if it hurts when you do that, don't do that" i.e. if the query language won't accomplish what you want to do, use something else. Jeff Believe me - I hear you (and others). But my administr

Re: [U2] Reporting Tools

2014-03-03 Thread Jeff Schasny
Jeff, What I think many of us are suggesting is essentially "if it hurts when you do that, don't do that" i.e. if the query language won't accomplish what you want to do, use something else. jeffrey Butera wrote: On 3/3/14, 2:58 PM, Brian Leach wrote: Jeff Try mvQuery, that should not have

Re: [U2] Reporting Tools

2014-03-03 Thread jeffrey Butera
On 3/3/14, 2:58 PM, Brian Leach wrote: Jeff Try mvQuery, that should not have any problems with those volumes. Hi Brian We've isolated the problem to Unidata itself, not the reporting tool. In short, when we do a LIST with about 150 fields, it throws: "too many items in LIST" As soon as

Re: [U2] Reporting Tools

2014-03-03 Thread Brian Leach
Jeff Try mvQuery, that should not have any problems with those volumes. Brian PS Of course for actual reports rather than CSVs, there's mvPDF.. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: 2

Re: [U2] Reporting Tools

2014-03-02 Thread Jeff Schasny
ruary 28, 2014 9:42 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reporting Tools On 2/28/14, 9:29 AM, Jeff Lettau wrote: In the past I've made dictionary names that are very short to save characters. But my real reason for responding is I can't help but wonder what you need 200+ columns for? M

Re: [U2] Reporting Tools

2014-03-01 Thread dale kelley
ug.org] On Behalf Of jeffrey Butera Sent: Friday, February 28, 2014 9:42 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reporting Tools On 2/28/14, 9:29 AM, Jeff Lettau wrote: In the past I've made dictionary names that are very short to save characters. But my real reason for respon

Re: [U2] Reporting Tools

2014-02-28 Thread Jeff Lettau
--Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Friday, February 28, 2014 9:42 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reporting Tools On 2/28/14, 9:29 AM, Jeff Lettau wrote: > In the p

Re: [U2] Reporting Tools

2014-02-28 Thread Baakkonen, Rodney A (Rod) 46K
. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Lettau Sent: Friday, February 28, 2014 8:29 AM To: U2 Users List Subject: Re: [U2] Reporting Tools In the past I've made dictionary names that are very short to

Re: [U2] Reporting Tools

2014-02-28 Thread jeffrey Butera
On 2/28/14, 9:29 AM, Jeff Lettau wrote: In the past I've made dictionary names that are very short to save characters. But my real reason for responding is I can't help but wonder what you need 200+ columns for? My first instinct when hearing this is that a report is not what you need. To

Re: [U2] Reporting Tools

2014-02-28 Thread Dave Laansma
-6142 www.hubbardsupply.com "Delivering Products, Services and Innovative Solutions" -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Lettau Sent: Friday, February 28, 2014 9:29 AM To: U2 Users List S

Re: [U2] Reporting Tools

2014-02-28 Thread Jeff Lettau
In the past I've made dictionary names that are very short to save characters. But my real reason for responding is I can't help but wonder what you need 200+ columns for? My first instinct when hearing this is that a report is not what you need. How many rows are in this report? Please note