ODBC Universe (Unix) to MS Access

2004-04-27 Thread Norman, David (SAAS)
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

RE: [UV] Problem reactivating select list

2004-04-27 Thread Logan, David (SST - Adelaide)
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

RE: Calling UniData subroutines via OLEDB

2004-04-27 Thread Brian Leach
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

RE: [UV] Problem reactivating select list

2004-04-27 Thread Brian Leach
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

Redback SOAP requests from .NET

2004-04-27 Thread Kay, Malcolm
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

RE: ODBC Universe (Unix) to MS Access

2004-04-27 Thread Herve Balestrieri
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 :

D3 - Universe

2004-04-27 Thread Barry Brooks
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

RE: D3 - Universe

2004-04-27 Thread Rick Ramsey
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

Re: ODBC Universe (Unix) to MS Access

2004-04-27 Thread David Beahm
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

RE: [UV] Problem reactivating select list[Scanned]

2004-04-27 Thread Georgia L. Pritchett
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

.net provider from Raining Data

2004-04-27 Thread Björn Eklund
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

RE: D3 - Universe

2004-04-27 Thread Ross Ferris
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]

RE: [UV] Problem reactivating select list

2004-04-27 Thread Stevenson, Charles
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

Help on uv syntax, please

2004-04-27 Thread Susan Joslyn
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

Re: Help on uv syntax, please

2004-04-27 Thread Glenn Herbert
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

RE: anyone using Redback on Windows 3000 server?

2004-04-27 Thread Bobby Ramirez
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?

RE: Help on uv syntax, please[Scanned]

2004-04-27 Thread Susan Joslyn
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

RE: Help on uv syntax, please

2004-04-27 Thread Glenn W. Paschal
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

RE: Help on uv syntax, please

2004-04-27 Thread Gordon Glorfield
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)

RE: Help on uv syntax, please

2004-04-27 Thread Stevenson, Charles
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

RE: Help on uv syntax, please

2004-04-27 Thread Stevenson, Charles
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

RE: XML and U2

2004-04-27 Thread Dawn M. Wolthuis
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

Re: [UV] Problem reactivating select list

2004-04-27 Thread John Hester
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

RE: Help on uv syntax, please

2004-04-27 Thread Stevenson, Charles
-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

RE: anyone using Redback on Windows 3000 server?

2004-04-27 Thread John Jenkins
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

UNCLASSIFIED Performance tuning UV on Windows2003

2004-04-27 Thread HENDERSON MICHAEL MR
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

RE: D3 - Universe

2004-04-27 Thread Tony Gravagno
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

RE: XML and U2

2004-04-27 Thread Dawn M. Wolthuis
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:

RE: D3 - Universe

2004-04-27 Thread Barry Brooks
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

RE: Redback SOAP requests from .NET

2004-04-27 Thread Cameron Booth
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

RE: D3 - Universe

2004-04-27 Thread Tony Gravagno
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

RE: ODBC Universe (Unix) to MS Access

2004-04-27 Thread Hona, David S
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]

UVODBC/OleDB job Randomly hang

2004-04-27 Thread Bob Gerrish
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

Timestamp

2004-04-27 Thread Eugene Perry
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

Re: D3 - Universe

2004-04-27 Thread Trevor Ockenden
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

RE: Timestamp

2004-04-27 Thread Bill H.
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

NT files on Unidata

2004-04-27 Thread Eugene Perry
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