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-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]On Behalf Of 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 or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at 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-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_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: <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-boun...@listserver.u2ug.org [mailto: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 ------------------------------ 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: <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-boun...@listserver.u2ug.org [mailto: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-boun...@listserver.u2ug.org [mailto: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 ----- 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 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