Will
What's your end point?
If you're trying to get an enquiry-like set of data and then mess around
with it in Basic, you can use UniVerse SQL to generate a data set then
iterate through it programmatically.
That's quick and unlike the external SQL access (e.g. ODBC) it doesn't try
to normalize it so you end up with sensible multivalued entries if you need.
Something along the lines of:
SQL = "SELECT col1, col2 FROM some_file WHERE some_criteria ORDER BY
some_fields"
Ok = SQLExecDirect(@HSTMT, SQL)
Ok = SQLNumResultCols(@HSTMT, NumColumns)
DIM COLS(NumColumns)
* bind these for each fetch
For I = 1 To NumColumns
Ok = SQLBindCol(@HSTMT, I, SQL.B.DEFAULT, COLS(I))
Next
Loop
Ok = SQLFetch(@HSTMT)
Until Ok = SQL.NO.DATA.FOUND Do
* COLS() now has the data for this row
For I = 1 To NumColumns
Crt COLS(I):"|":
Next
Crt
Repeat
Ok = SQLFreeStmt(@HSTMT, SQL.DROP)
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wjhonson
Sent: 10 October 2012 15:25
To: [email protected]
Subject: Re: [U2] Wouldn't it be nice if
Hmm I'd say build the structure.
I already have a verb WALK where you can give it a filename on the
commandline and it will build a BASIC program to select and readnext and
read each record in order.
But it's not yet smart enough to handle a request to SORT... BY that might
be a simple additional tweak.... not sure.
-----Original Message-----
From: Buss, Troy (Contractor, Logitek Systems) (Contractor, Logitek Systems)
<[email protected]>
To: U2 Users List <[email protected]>
Sent: Wed, Oct 10, 2012 2:13 am
Subject: Re: [U2] Wouldn't it be nice if
Hmm, I tend to work the other way and take basic programs that would be far
less maintenance being a query, even if it takes a little idescriptor work
to get it right.
What is your tweakery challenge?
-----Original Message-----
From: [email protected]
[mailto:[email protected]]
On Behalf Of Wjhonson
Sent: Tuesday, October 09, 2012 1:51 PM
To: [email protected]
Subject: [U2] Wouldn't it be nice if
We had a vendor provided command which would turn a Query statement into a
BASIC program ?
For those situations where you just want to make some tweaks to a query
that's basically working ok just not perfectly.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
____________________________________________________________________________
_
Scanned by IBM Email Security Management Services powered by MessageLabs.
For
more information please visit http://www.ers.ibm.com
This email is intended only for the use of the party to which it is
addressed
and may contain information that is privileged, confidential, or protected
by
law. If you are not the intended recipient you are hereby notified that any
dissemination, copying or distribution of the email or its contents is
strictly
prohibited. If you have received this message in error, please notify us
immediately, by replying to the message and deleting it from your computer.
WARNING: Internet communications are not assured to be secure or clear of
inaccuracies as information could be intercepted, corrupted, lost,
destroyed,
arrive late or incomplete, or contain viruses. Therefore, we do not accept
responsibility for any errors or omissions that are present in this email,
or
any attachment, that have arisen as a result of e-mail transmission.
____________________________________________________________________________
_
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
