Its amazing. In short...
You can schedule proper sizing of all your files in cron (if you have a *nix machine) and let it do its work. I use it once a week on Sunday nights. Its wonderful. On Tue, Oct 4, 2011 at 11:57 AM, Jeff Schasny <jscha...@gmail.com> wrote: > I've been using FAST pretty much since it has existed and I highly > recommend it for anyone using U2 databases. Also the folks at Fitzgerald and > Long are fantastic people whom I have known since the Prime Information > days. > > > Eric Armstrong wrote: > >> Would anyone who is using FAST (File Analysis and Sizing Tool) care to >> comment about it? Experiences with it, plus and minuses? Does it deliver as >> advertised? >> >> Thanks in advance, >> >> Eric Armstrong >> Programmer/Analyst >> Lobel Financial >> >> >> -----Original Message----- >> From: >> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org> >> [mailto:u2-users-bounces@**listserver.u2ug.org<u2-users-boun...@listserver.u2ug.org>]On >> Behalf Of >> u2-users-request@listserver.**u2ug.org<u2-users-requ...@listserver.u2ug.org> >> Sent: Monday, October 03, 2011 12:00 PM >> To: u2-users@listserver.u2ug.org >> Subject: U2-Users Digest, Vol 30, Issue 2 >> >> >> Send U2-Users mailing list submissions to >> u2-users@listserver.u2ug.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> >> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> >> or, via email, send a message with subject or body 'help' to >> >> u2-users-request@listserver.**u2ug.org<u2-users-requ...@listserver.u2ug.org> >> >> You can reach the person managing the list at >> >> u2-users-owner@listserver.**u2ug.org<u2-users-ow...@listserver.u2ug.org> >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of U2-Users digest..." >> >> >> Today's Topics: >> >> 1. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ? >> (Tony Gravagno) >> 2. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ? >> (Kevin King) >> 3. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ? >> (George Gallen) >> 4. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ? >> (George Gallen) >> 5. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ? >> (Symeon Breen) >> >> >> ------------------------------**------------------------------** >> ---------- >> >> Message: 1 >> Date: Sun, 2 Oct 2011 14:51:55 -0700 >> From: "Tony Gravagno" <3xk547...@sneakemail.com> >> To: u2-users@listserver.u2ug.org >> Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt >> ? >> Message-ID: >> <4876-1317592318-754880@**sneakemail.com<4876-1317592318-754...@sneakemail.com> >> > >> Content-Type: text/plain; charset="us-ascii" >> >> The easy answer is to pretend you're doing this from a web page, >> where the MP in LAMP is MySQL and PHP. From there you have a >> world full of answers rather than something U2-specific. Note >> that most shared hosts don't have a MySQL DBMS on the same system >> as the HTTP servers. They almost Always separate MySQL to a >> different box for queries, so examples for how to do this are >> plentiful. >> >> So write a small PHP script that does what you need, copy/paste >> from examples if required. Then invoke the script with a simple >> "SH" or "!" to execute the script, passing in params. Capture >> the result with an Execute Capturing clause, or have the script >> write data to a directory which you reference as a type 1 or type >> 19. >> >> That's it. This one is fairly easy - just think outside of the >> MV box. >> >> HTH >> T >> >> From: Manu Fernandes >> >> >>> From Universe/linux, I'll execute a mySQL sql phrase. >>> mySQL is installed on a remote server. >>> >>> - What is the mysql-client to be installed beside >>> Universe ? >>> - How to execute a sql-phrase from UV/BASIC >>> ? and capture the result !? >>> >>> >> >> >> >> ------------------------------ >> >> Message: 2 >> Date: Sun, 2 Oct 2011 19:32:30 -0600 >> From: Kevin King <precisonl...@gmail.com> >> To: U2 Users List <u2-users@listserver.u2ug.org> >> Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt >> ? >> Message-ID: >> <CA+v=tEJ9c8P_YYqffriA_9Z-3b3_**H9bhe1rm2Bh7sJD05UVzfA@mail.** >> gmail.com <tej9c8p_yyqffria_9z-3b3_h9bhe1rm2bh7sjd05uv...@mail.gmail.com> >> > >> Content-Type: text/plain; charset=ISO-8859-1 >> >> To followup to what Tony said, we do this with PHP by creating a >> JSON-formatted extract out of Unidata, then ftp it to the other >> system, then use Apache to kick off a job to post the file into MySQL >> and PostgreSQL. Works like a champ for small to medium data sets. >> For large datasets we do something significantly more complicated >> using triggers and a publisher that publishes changes to the Unidata >> files using the callHTTP interface to send data to a PHP script >> running on Apache. >> >> -Kevin >> http://www.PrecisOnline.com >> >> >> ------------------------------ >> >> Message: 3 >> Date: Mon, 3 Oct 2011 09:01:42 -0500 >> From: George Gallen <ggal...@wyanokegroup.com> >> To: U2 Users List <u2-users@listserver.u2ug.org> >> Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt >> ? >> Message-ID: >> <BE8D41DCF5C32D4C982DE29A5D883**8F705B6380581@DFW1MBX02.** >> mex07a.mlsrvr.com<be8d41dcf5c32d4c982de29a5d8838f705b6380...@dfw1mbx02.mex07a.mlsrvr.com> >> > >> >> Content-Type: text/plain; charset="us-ascii" >> >> This is what I do.... >> >> Since you are on Linux, chances are you already have what you need >> installed. >> >> I define a VOC item called "TMP" which looks like: >> >> 0001: F >> 0002: /tmp >> 0003: D_VOC >> >> And coding that looks like: >> >> OPEN "","TMP" TO F.TMP ELSE STOP "NO /tmp" >> USRNO=@USERNO >> HOSTNAME="" ; * example: http://servername (assumes port 3306) >> otherwise add --port=port#touse >> USERNAME="" >> PASSWORD="" >> * >> TEST="mysql --connect_timeout=15 --user=":USERNAME:" >> --password=":PASSWORD:" -h ":HOSTNAME:" > /tmp/output":USRNO:" <<EOF" >> TEST<-1>="use orders;" >> * >> TEST<-1>="select InvNo,TransID,GroupCode,Status from shippingdata where >> Status is not null;" >> * >> * >> TEST<-1>="quit" >> TEST<-1>="EOF" >> * >> WRITE TEST ON F.TMP,"TSQLCMD":USRNO >> CMD1="/tmp/MYSQLCMD":USRNO >> DELETE F.TMP,"output":USRNO >> EXECUTE "SH -c '":CMD1:"'" CAPTURING ERRORS >> * >> READ CRMDATA FROM F.TMP,"output":USRNO ELSE PRINT "NO MYSQLDATA FOR >> ":USRNO >> UU=DCOUNT(CRMDATA,CHAR(254)) >> BLANK=CHAR(9):CHAR(9) >> RESULT="" ; SKIP=1 >> FOR T=1 TO UU >> IF CRMDATA<T>#BLANK THEN >> IF INDEX(CRMDATA<T>,"InvNo",1)#0 THEN SKIP=0 ; CONTINUE >> IF SKIP=1 THEN CONTINUE >> RESULT<-1>=CHANGE(CRMDATA<T>,**CHAR(9),CHAR(253)) >> END >> NEXT T >> * >> DELETE F.TMP,"MYSQLCMD":USRNO >> >> >> When completed: >> RESULT will have a 2 dimensioned Dynamic array - with the X dimension >> being the columns, and the Y dimension being the Rows >> ERRORS will have any messages from the database >> >> -----Original Message----- >> From: >> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>[mailto: >> u2-users-bounces@**listserver.u2ug.org<u2-users-boun...@listserver.u2ug.org>] >> On Behalf Of Manu Fernandes >> Sent: Saturday, October 01, 2011 4:55 AM >> To: u2-users@listserver.u2ug.org >> Subject: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ? >> >> Hi group, >> >> I'm looking for your experiences... >> >> >From Universe/linux, I'll execute a mySQL sql phrase. >> mySQL is installed on a remote server. >> >> - What is the mysql-client to be installed beside Universe ? >> - How to execute a sql-phrase from UV/BASIC ? and capture the result !? >> >> Thanks for any advice. >> Manu >> >> >> >> >> ______________________________**_________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> >> >> >> ------------------------------ >> >> Message: 4 >> Date: Mon, 3 Oct 2011 09:14:07 -0500 >> From: George Gallen <ggal...@wyanokegroup.com> >> To: U2 Users List <u2-users@listserver.u2ug.org> >> Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt >> ? >> Message-ID: >> <BE8D41DCF5C32D4C982DE29A5D883**8F705B6380591@DFW1MBX02.** >> mex07a.mlsrvr.com<be8d41dcf5c32d4c982de29a5d8838f705b6380...@dfw1mbx02.mex07a.mlsrvr.com> >> > >> >> Content-Type: text/plain; charset="us-ascii" >> >> Points to keep in mind (misskeys) >> >> 1. change any referece of "TSQLCMD" to "MYSQLCMD" >> 2. If you need to add the --port=#, you need to add it to the TEST command >> and not to the HOSTNAME >> >> -----Original Message----- >> From: >> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>[mailto: >> u2-users-bounces@**listserver.u2ug.org<u2-users-boun...@listserver.u2ug.org>] >> On Behalf Of George Gallen >> Sent: Monday, October 03, 2011 10:02 AM >> To: U2 Users List >> Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ? >> >> This is what I do.... >> >> HOSTNAME="" ; * example: http://servername (assumes port 3306) >> otherwise add --port=port#touse >> * >> TEST="mysql --connect_timeout=15 --user=":USERNAME:" >> --password=":PASSWORD:" -h ":HOSTNAME:" > /tmp/output":USRNO:" <<EOF" >> * >> WRITE TEST ON F.TMP,"TSQLCMD":USRNO >> >> >> ------------------------------ >> >> Message: 5 >> Date: Mon, 3 Oct 2011 16:05:24 +0100 >> From: "Symeon Breen" <syme...@gmail.com> >> To: "'U2 Users List'" <u2-users@listserver.u2ug.org> >> Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt >> ? >> Message-ID: <005301cc81dd$e2067010$**a6135030$@gmail.com> >> Content-Type: text/plain; charset="us-ascii" >> >> The BCI works very well in such circumstances, I have used it lots of >> times. >> Take a read of the manual it is fairly easy to get going. >> >> >> >> -----Original Message----- >> From: >> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org> >> [mailto:u2-users-bounces@**listserver.u2ug.org<u2-users-boun...@listserver.u2ug.org>] >> On Behalf Of Manu Fernandes >> Sent: 01 October 2011 09:55 >> To: u2-users@listserver.u2ug.org >> Subject: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ? >> >> Hi group, >> >> I'm looking for your experiences... >> >> >From Universe/linux, I'll execute a mySQL sql phrase. >> mySQL is installed on a remote server. >> >> - What is the mysql-client to be installed beside Universe ? >> - How to execute a sql-phrase from UV/BASIC ? and capture the result !? >> >> Thanks for any advice. >> Manu >> >> >> >> >> ______________________________**_________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> >> ----- >> No virus found in this message. >> Checked by AVG - www.avg.com >> Version: 10.0.1410 / Virus Database: 1520/3930 - Release Date: 09/30/11 >> >> >> >> ------------------------------ >> >> ______________________________**_________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> >> >> >> End of U2-Users Digest, Vol 30, Issue 2 >> ***************************************** >> >> >> LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain >> confidential company information that is protected by federal law. Federal >> regulations prohibit the disclosure (or re-disclosure) of confidential >> information without the written consent of the person(s) to whom it >> pertains. Additionally, the views or opinions presented in this email are >> solely those of the author and do not necessarily represent those of the >> company. >> >> >> ______________________________**_________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> >> >> >> > > -- > ------------------------------**------------------------------** > ------------ > Jeff Schasny - Denver, Co, USA > jschasny at gmail dot com > ------------------------------**------------------------------** > ------------ > > ______________________________**_________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> > -- John Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users