Evening all,
I want to be able to write and read an Access database on the LAN, from
UniVerse 10.0.16 HP-UX 11i. Ray Daignault's comment about this in the
archives (2001) is that a Unix ODBC driver and Driver Manager are required.
Does anyone have any opinions on what drivers are better/worse than
Hi John,
I think the problem you are seeing is a result of the EXECUTE command
being executed in a separate shell or workspace. It can't see your
select list. There are a couple of ways around this, use the PASSLIST
keyword in the EXECUTE command (that is for ideal flavour, your mileage
may vary
Steven,
Sorry I don't know this for UniData, but I posting just in case it may use
similar techniques to those under UniVerse.
On UniVerse you can use the CALL statement (that's CALL as in SQL CALL not a
BASIC CALL)
CALL subroutine(Args)
MyCmd.Text = 'CALL MySub(1)'
(NOTE : This is
John,
Why write a wrapper?
ED is a scrudgy BASIC program - (uv Account BP ED.B). You could just modify
that.
Brian
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of John Hester
Sent: 26 April 2004 22:22
To: U2 Users Discussion List
Subject: [UV] Problem
We've been trying to create Redback SOAP requests from VB .NET, but the requests
always timeout. We think it must be a malformed request. Has anyone else tried this?
And do you have a successful example of some code please?
Malcolm Kay
Development Team Leader
IS Unit
Tel: 44 (0) 1823 356396
David,
Looking in DataDirect history from their web site at page :
http://www.datadirect.com/aboutus/history/index.ssp
shows that the company is still an independant company, and has not been
purchased by Progress Software.
Though, as quoted in their Strategic Partnership at page :
Hi everyone
I have a client who is running D3 and Universe on seperate servers. They
wish to be able to directly access D3 files from Universe. Does anyone
know the best (or any) way to do this.
D3 and Universe are running on Linux Redhat 9.
Barry Brooks
--
u2-users mailing list
[EMAIL
When you say 'access D3 files from UniVerse' it's not really clear what
you mean (copy files? Real-time queries?) For simple copying from one
MV system to another we've had good experience with AccuTerm
(www.asent.com) which is our terminal emulator, copying tool and GUI
enabler (with Nucleus
To get BCI working from HP-UX 11.00 we had to use the Easysoft ODBC-ODBC
Bridge, as it was too hard finding and compiling all the necessary parts
as 64 bit. It's good software from good guys at a good price (~$1500
US), but it might be overkill for your situation. You could also write
a
We've used alternate indexes to do trigger type processing since 1990.
In our case, we do it to handle two situations:
1. Track the records that have changed to handle secondary key updates
for files where the secondary data isn't really in the file. We have
a master person file for our police
Hi,
we have students working for us on a project evaluating Raining Data's .net
provider. They have had a lot of problems and some of them we have found
workarounds for. Now they try to update a file but it doesen't seem to work.
Anyone with knowledge of this product who could help us with this
You MIGHT be able to use ODBC from UV, but ODBC with D3 has never been great -
depending on volumes, there is always OSFI (on D3) being mapped to a UV type 19 file ?
Ross Ferris
Stamina Software
Visage an Evolution in Software Development
-Original Message-
From: [EMAIL PROTECTED]
Triggers would be nice, but the'd have to work on type19 files.
Modifying ED is simple, but you might want to wrap other verbs, so
generalized wrapper pgm is good. Protect the vanilla versions of ED,
DELETE, UPDATE.RECORD, REVISE as 'remote-controlled' R-items that will
only execute if executed
Hi.
Anybody got the syntax for universe for changing one string to another in an
array? Mostly I use it for changing a subvalued field into a multivalued
one.
In Unidata, for example, its
NEWARRAY = CHANGE(OLDARRAY,SVM,VM)
I'm looking for a similar function in universe.
(p.s. if you
By array I assume you mean dynamic array and, as such, would use:
NEWARRAY = CHANGE(OLDARRAY,@SVM, @VM)
At 12:47 PM 4/27/2004, you wrote:
Hi.
Anybody got the syntax for universe for changing one string to another in an
array? Mostly I use it for changing a subvalued field into a multivalued
Doh!
Bobby Ramirez
Senior Programmer
Body Wise International
714-368-1260
http://www.bodywise.com/
-Original Message-
From: Tony Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 27, 2004 9:51 AM
To: U2 Users Discussion List
Subject: RE: anyone using Redback on Windows 3000 server?
So I could use the exact same 'CHANGE' syntax on Universe, then? That would
be ideal -- even though I'm only converting the one character -- so could
use CONVERT -- but if the same syntax will work as on UD then that's even
better!
Does this work with the exact same syntax? Where
UniVerse format:
NEWARRAY = CONVERT(VM,SVM,OLDARRAY)
Assuming VM = @VM or char(253) and SVM = @SM or char(252),
This will use the data in OLDARRAY, convert all Value Marks to Sub-Value
Marks, and assign the new data to NEWARRAY.
Thanks,
--Glenn.
-Original Message-
From: [EMAIL
To do what you are saying I would use the RAISE function.
NEWARRAY = RAISE(OLDARRAY)
This would change all @SVM to @VM. Of course you would have to be kind of
careful with it as it would also change all @VM to @AM.
Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
http://publibfi.boulder.ibm.com/epubs/pdf/25119090.pdf
10.1 Basic Ref, pg 162
CHANGE (expression, substring, replacement [ ,occurrence [ ,begin] ] )
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
I use CONVERT expression1 TO expression2 IN variable
Don't use CONVERT! Example:
CRT CONVERT( 'Muffet', 'Piggy', 'Little Miss Muffet sat on a tuffet
eating her curds and whey.' )
yields the string:
Lily Piss Piggy sa on a iggy yaing hyr cirds and whyy.
which is offensive enough
Hi Rob --
It is the rare table, indeed, that is created with a sql CREATE TABLE
statement in a U2 database. U2 has SQL as a second language. It is not
really an RDBMS, but uses a data model very similar to the one used by XML
(a tree or di-graph structure).
With the CREATE-FILE command a file
Thanks to everyone for all the suggestions. Turns out the solution was
relatively simple. I just needed to use PERFORM ED instead of EXECUTE
ED to make ED run in the wrapper program's workspace. This is in PICK
flavor. Seems like I once knew the difference between EXECUTE and
PERFORM in
-Original Message-
From: Stevenson, Charles [mailto:[EMAIL PROTECTED]
[snip]
Don't use CONVERT! Example:
[snip]
But it's great for things like:
LINE = PRINT.ARRAYLINE.CTR
CONVERT @VM:0.- TO IN LINE
IF LINE # THEN
GOSUB PRINT.LINE
END
I stand corrected. I don't
Yep
You've heard about software that uses *undocumented* opcodes?
Well, Microsox used the *unimplemented* opcodes for this one !
(hee hee)
Seriously - there is a howto doc available on installing on Windows 2003
server ... Available on request from your local RedBack support shop, also
on the
Folks,
I notice that when I do two concurrent processes (like ANALYZE.FILE from one
window and SELECT from another window) on the same large (3GB,64-bit) file,
the 'Pages/sec' count in Win2K3 goes through the roof, even though the
'memory commit charge' is only 176MB out of 2465MB.
Maybe the
Barry Brooks asked:
I have a client who is running D3 and Universe on seperate servers.
They wish to be able to directly access D3 files from Universe. Does
anyone know the best (or any) way to do this. D3 and Universe are
running on Linux Redhat 9.
Ross Suggested:
You MIGHT be able to use
You are correct that the built-in XML -- U2 utilities go to sub-values and
I think it makes sense to ignore the text values information at this point.
Thanks. --dawn
Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com
Take and give some delight today.
-Original Message-
From:
Thanks Rick
We are trying to achieve 'Real-Time, Online' enquiry to d3 files from
Universe.
Cheers ... Barry
-Original Message-
From: Rick Ramsey [SMTP:[EMAIL PROTECTED]
Sent: Tuesday, 27 April 2004 9:40 PM
To: U2 Users Discussion List
Subject: RE: D3 - Universe
Thanks
Redback should respond to a request even if it is to report that the request
is malformed.
The rgw.log file should show some activity of what's going on if the log
levels in rgwresp.ini are turned on high enough.
Cheers,
Cam Booth
Analyst Programmer
Ultradata - Vision to Reality
If all you want is to do is Access queries, then you can build the query,
then pass it to D3 through a combination of rlogin and d3tcl. That's a
little cludgy. Or, again, you can go through a Win32 middle-tier. The
results can be returned to Universe through stdout or captured into a
variable
Hervé
On their Web front page, there is a announcement Progress Software Acquires
DataDirect Technologies and links, including this one:
http://phx.corporate-ir.net/phoenix.zhtml?c=86919p=IROL-NRTextt=Regularid
=480278
Regards,
David
-Original Message-
From: [EMAIL PROTECTED]
I have a client running AIX, UniVerse 9.5.1.1 and UVODBC 3.7 which they are
connecting to via .NET / OleDB. They see occasional hangs from their
DataReader and consequently, kill their process and reissue a query. Now
we are seeing some hangs on the UniVerse side such that UniVerse
Hello,
On Unidata, is there an equivalent of D3's SYSTEM(19)?
Thanks
Eugene
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Barry
My suggestion is to set up a set a requester on the UV machine and a
responder on the D3 machine. By this I mean you write the Basic routines
that use say named pipes on one or other of the machines that allow for a
request of one machine, a suitable background process could then respond to
For those not familiar:
SYSTEM(19) on D3:
Returns a unique item-id consisting of the current system date in internal
format, followed immediately by the current system time in seconds. If more
than one item-id is generated in a second, an alpha character is appended to
the item-id.
Bill
How does one open files in the NT file system on Unidata?
Thanks
Eugene
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
37 matches
Mail list logo