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
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
a
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.
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 somethin
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 se
I believe you'll need an ODBC driver for MySQL. You would then use the
syntax described in UniVerse's Basic Calling Interface (BCI) documentation.
On Sat, Oct 1, 2011 at 4:55 AM, Manu Fernandes wrote:
> Hi group,
>
> I'm looking for your experiences...
>
> >From Universe/linux, I'll execute a
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
