Re: jdbc

[Bob Coleman/FCA]

If you don't want to bother with cygwin you may want to look into http://gnuwin32.sourceforge.net/ where you can get just those tools you need and no more. -Bob -------- Original Message -------- From: Simon Verona Date: 9/27/2010 2:13 PM: Jim I'll try cygwin...  last time I used it (many years ago) it killed my pc!  It's been years since I've used Reformat...   If I recall correctly, it creates new items in a new file based on the columns reported in the remainder of the reformat statement.   So, I guess I can us reformat to generate an interim "workfile" of the summary lines and then report on that...        I'll see if I can package that up into a single command...   (I'm actually trying to get to a simple command that a non-techie front line helpdesk person can use to find errors in a file...  I may still just have to write a program to find them!). Regards Simon On 27/09/2010 22:02, Jim Idle wrote: Cygwin bare minimum install will do it for you.   Also, talking to John you could look at:   REFORMAT xxx BREAK-ON ACCT  TOTAL AMT DET.SUPP       Might need ’V’ after the break on. Then use the xxx temp file to find the non zero stuff.   Jim       From: jbase@googlegroups.com [mailto:jbase@googlegroups.com] On Behalf Of Simon Verona Sent: Monday, September 27, 2010 1:58 PM To: jbase@googlegroups.com Subject: Re: jdbc   Jim Good thoughts...  Can you recommend a suite of "unix" tools that I can use under Windows for this ?   I'm a big proponent of using non-jBase tools with jBASE (which I do) -  I was hoping that I was missing something in my knowledge of jQL which might do the exclusion for me (I note another similar thread today on the  same subject).    Thanks Simon On 27/09/2010 21:45, Jim Idle wrote: Execute it in a bash script and grep –v “0\.00” Or SORT it with the total displayed in the first column  and pipe the output to sort -rn Or SORT it and [ipe the output to awk   Etc etc.   Don’t limit yourselves to the MV only way of doing things as that was the whole point of jBASE.   Jim   From: jbase@googlegroups.com [mailto:jbase@googlegroups.com] On Behalf Of Daniel Klein Sent: Sunday, September 26, 2010 6:12 AM To: jbase@googlegroups.com Subject: Re: jdbc   There's no iphone app that will do that? ;-)   Seriously, you would spool the report to a file and then post-process the file.   Dan   On Sun, Sep 26, 2010 at 7:00 AM, Simon Verona <si...@dmservices.co.uk> wrote:  Hi all This may or may not be a stupid question. I have a transaction file, with many thousands of entries in, which should total zero both on a daily basis (there is a date field in the file) and overall. If I have a problem, then a check is to find which dates do not come back to zero... So, I execute a jQL query like : SORT TRANSACTIONS BY DATE BREAK-ON DATE "'VL'" TOTAL 2 (D) Which produces a list like  :               02/07/2010       0.00               01/07/2010       0.00               30/06/2010       0.00               29/06/2010    -585.31               28/06/2010       0.00               27/06/2010       0.00                etc etc All I want to see though is the dates that don't come to zero.... Can this be done using jQL? Thanks Simon -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en   -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines   IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines   IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en   -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines   IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines   IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines   IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines   IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en