ODBC Universe (Unix) to MS Access
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 others ? I am getting info from easysoft and openlink - anyone else worth talking to ? Thanks, David Norman Senior Systems Engineer SA Ambulance Service Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 fax +61 8 8271 4844 * [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Problem reactivating select list
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 according to your own flavour. It is all documented in the manual 8-)) or use a SAVE-LIST and then use the DATA statement to stack a GET-LIST command before you execute your ED statement. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 27 April 2004 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [UV] Problem reactivating select list Other things to consider: 1. What happens if someone uses XEQ within ED to edit another record. 2. What about people using UPDATE.RECORD 3. And what about REVISE (ENTRO/MODIFY) There are many different ways to get around audit trails if people want to. AdrianW -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 April 2004 05:22 To: U2 Users Discussion List Subject: [UV] Problem reactivating select list I wrote a wrapper for the ED command last week to keep an audit trail of any changes made to files outside our applications. I'm just writing a before and after version of an edited record to a temp file and comparing afterwards. All seemed fine until one of my coworkers informed me he could no longer use X to drop back to TCL after editing from a select list. This was due to the fact that I was processing the select list in the wrapper program and just executing ED once for each record. For X to work as it used to, I need to write out all the selected records at the beginning, let ED process the select list, then go back through the list again for comparison. snip Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Calling UniData subroutines via OLEDB
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 considered by ADO to be an SQL command, not a stored procedure). This returns either: A) any printed output as a single column named 'PRINTED OUTPUT', or B) you can execute native uvSQL commands using SQLExecDirect and capture the result into a system variable named @HSTMT. This then passes the results back as an ADO RowSet. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 26 April 2004 23:36 To: [EMAIL PROTECTED] Subject: Calling UniData subroutines via OLEDB Hello We're struggling through the IBM documentation to figure out how to call a subroutine on UniData via OLEDB. (The OLDB.pdf) I'm hoping some one can point us in the direction of some additional documentation or code examples. I've begun searching in the archives, but only limited success so far. thanks in advance for any info. Steven Covey Senior Business Analyst JIA, Inc. (Jenkon) [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Problem reactivating select list
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 reactivating select list I wrote a wrapper for the ED command last week to keep an audit trail of any changes made to files outside our applications. I'm just writing a before and after version of an edited record to a temp file and comparing afterwards. All seemed fine until one of my coworkers informed me he could no longer use X to drop back to TCL after editing from a select list. This was due to the fact that I was processing the select list in the wrapper program and just executing ED once for each record. For X to work as it used to, I need to write out all the selected records at the beginning, let ED process the select list, then go back through the list again for comparison. Here's the problem: No matter what I do, I can't get ED to recognize an active select list that is activated within the wrapper program. I use READLIST ITEMS at the beginning to get the list of items to write to the temp file, then SELECTN ITEMS TO 0 prior to executing ED. I also tried writing the list to SAVEDLISTS and executing GET.LIST :TEMP.LIST prior to executing ED, but got the same result. These two test programs illustrate the problem: BP TEST.READLIST 0001: READLIST ITEMS ELSE ITEMS = '' 0002: PRINT 'CONTENTS OF ITEMS=':ITEMS 0003: SELECTN ITEMS TO 0 0004: EXECUTE 'RUN BP TEST.READLIST2' 0005: LOOP 0006: READNEXT ITEM ELSE EXIT 0007: PRINT 'READNEXT ITEM=':ITEM 0008: REPEAT 0009: END BP TEST.READLIST2 0001: READLIST ITEMS ELSE ITEMS = '' 0002: PRINT 'CONTENTS OF ITEMS=':ITEMS 0003: END Output: SELECT BP SAMPLE 10 10 record(s) selected to SELECT list #0. RUN BP TEST.READLIST CONTENTS OF ITEMS=1 2 3 4 5 DD FF MCT1 T2 CONTENTS OF ITEMS= READNEXT ITEM=1 READNEXT ITEM=2 READNEXT ITEM=3 READNEXT ITEM=4 READNEXT ITEM=5 READNEXT ITEM=DD READNEXT ITEM=FF READNEXT ITEM=MC READNEXT ITEM=T1 READNEXT ITEM=T2 Clearly the select list is activated by SELECTN because the subsequent READNEXT works, but the executed program can't see an active select list. Is there any way around this? I'd hate to have to make a modified copy of the UV ED command, but that's the only alternative I see at this point. TIA, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Redback SOAP requests from .NET
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 Web: http://www.tauntondeane.gov.uk IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ODBC Universe (Unix) to MS Access
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 : http://www.datadirect.com/aboutus/strategicpart/index.ssp they demonstrate that many database and database management solutions vendors such as Progress Software and IBM (for Websphere and Websphere MQ) are embedding the DataDirect products into their products. The interesting point is that they are the ONLY licensed by Microsoft to have access to the source code and developments Microsoft does around ODBC, so they can port to UNIX and Linux the ODBC drivers developped by Microsoft. Hervé BALESTRIERI Support Technique Avancé - IBM Data Management - Produits U2 - Forwarded by Herve Balestrieri/France/IBM on 27/04/2004 12:10 - Hona, David S [EMAIL PROTECTED]To: 'U2 Users Discussion List' [EMAIL PROTECTED] om cc: Sent by: Subject: RE: ODBC Universe (Unix) to MS Access u2-users-bounces@ oliver.com 27/04/2004 09:47 Please respond to U2 Users Discussion List IBM/Informix/Ardent has apparently utilised the Merant ODBC Driver Manager, in the past...the company spun-off the ODBC business into another company at http://www.datadirect.com/products/odbc/odbcunix/index.ssp Data Direct has been acquired by Progress Software now. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Norman, David (SAAS) Sent: Tuesday, April 27, 2004 5:16 PM To: '[EMAIL PROTECTED]' Subject: ODBC Universe (Unix) to MS Access 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 others ? I am getting info from easysoft and openlink - anyone else worth talking to ? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
D3 - Universe
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 PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 - Universe
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 from Binary Star). I think you can get a free trial copy of AccuTerm from their site. Rick Ramsey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brooks Sent: Tuesday, April 27, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: D3 - Universe 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 PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: ODBC Universe (Unix) to MS Access
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 client-side program (VB/Java) that reads the Access database through ODBC/JDBC and writes to UV thru UniObjects. (Okay, it could be server-side also, but you'd have to shell execute / cron it.) Best, David Beahm Norman, David (SAAS) wrote: 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 others ? I am getting info from easysoft and openlink - anyone else worth talking to ? Thanks, David Norman Senior Systems Engineer SA Ambulance Service Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 fax +61 8 8271 4844 * [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Problem reactivating select list[Scanned]
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 application. Rather than select the persons with a specific name and then look for the crime records for that person, we keep the person names in an attribute in the crime report records. Note, we did efficiency analysis on PI rev 7 to determine which made the most sense. I'm not sure if it would make as much sense now but it was significantly faster back then to handle it this way. 2. Track the records that have changed to handle updates of other databases. We have GIS applications that use other databases. These databases are updated at night from our main Universe system based on what records have changed during the day. My late co-worker, Rob Fisher, and I used stuff from several sources including Gyle Iverson and Lee Leitner to flesh out this idea. We even wrote our own paper on it way back in 1991. Georgia Pritchett City of Salinas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hona, David S Sent: Monday, April 26, 2004 11:04 PM To: 'U2 Users Discussion List' Subject: RE: [UV] Problem reactivating select list[Scanned] Triggers have more overhead associated with them: - you have install the trigger in all your hashed files/tables IIRC, you can't have triggers on non-hashed file types. Regards, David -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
.net provider from Raining Data
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 issue? We have some problem with saving a record to the uniData server. we try to write a record to the table see code snippet - connection cn; openconnection(cn); ... cn.getDatabase().getTable(Tablename).Write(record.getField(@ID).getValue (),record.ToString()); - The code does not work as expected. The call returns true but the cn seams to be destroyed after this line and nothing is written to the database. Are we using this method wrong? Are there any other ways to uppdate a table in the database? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 - Universe
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] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brooks Sent: Tuesday, 27 April 2004 8:59 PM To: [EMAIL PROTECTED] Subject: D3 - Universe 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 PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.667 / Virus Database: 429 - Release Date: 23/04/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.667 / Virus Database: 429 - Release Date: 23/04/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Problem reactivating select list
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 by wrapper. In wrapper, just capture/save the active select list, then reuse it 3 times: (1st) to capture the before version of all records, (2nd) to do ED, UPDATE.RECORD, REVISE, DELETE, or whatever else you are wrapping, then (3rd) to compare the before after versions. How to capture reactiveate the list is up to you, but I guess that's the root of the question, isn't it? The flavors handle list variables differently: getlist, savelist, formlist, passlist, etc. $OPTIONS IDEAL makes pgm conform to documentation. Pick flavor is poorly documented (in my exalted opinion). There is a config option for PERFORM EXECUTE. The following silly example uses methods that do essentially what you need, (uv 10.0, pick flavor account): CT CDS.BP HESTER HESTER 0001 $OPTIONS -VAR.SELECT ;* (I like ideal behavior, not Pick) 0002 READLIST LIST FROM 0 ELSE LIST = something from command line? 0003 FORMLIST LIST TO 0 0004 DATA 'Y' 0005 PERFORM 'COPYI FROM VOC TO VOCLIB' 0006 FORMLIST LIST TO 0 0007 PERFORM 'ED VOC' 0008 LOOP 0009 REMOVE ID FROM LIST SETTING MORE 0010 CRT ID, 'compare old to new...' 0011 WHILE MORE 0012 REPEAT 0013END SELECT VOC SAMPLE 10 record(s) selected to SELECT list #0. NSELECT VOCLIB 10 record(s) selected to SELECT list #0. RUN CDS.BP HESTER You have an active SELECT list. Do you wish to copy the records previously SELECTed? The first record ID = HASH.TEST. Enter Y or N: 10 records copied. SELECTed record name = HASH.TEST. 8 lines long. : 1 0001: V : A X 0001: V X : FI HASH.TEST filed in file VOC. SELECTed record name = QUIT.KEY. 2 lines long. : 1 0001: X : A 0001: X X : FI QUIT.KEY filed in file VOC. SELECTed record name = CLEAR.LOCKS. 4 lines long. : X HASH.TEST compare old to new... QUIT.KEY compare old to new... CLEAR.LOCKS compare old to new... compare old to new... =compare old to new... DIVX compare old to new... =compare old to new... T.LOADcompare old to new... =compare old to new... MENU.DOC compare old to new... 2UP VOC VOCLIB HASH.TEST QUIT.KEY CLEAR.LOCKS /home_app/cds3389612:19:42pm 27 Apr 2004 Pg . 1 File: VOC VOCLIB Rec: HASH.TEST HASH.TEST ---1: V X # V 0002: hash.test | hash.test 0003: E | E 0004: GSP | GSP 0005: | 0006: | 0007: P}N | P}N 0008: LPTR}NOPAGE | LPTR}NOPAGE 1 difference(s) __ Rec: QUIT.KEY QUIT.KEY ---1: X X # X 0002: ACLQ | ACLQ 1 difference(s) __ Rec: CLEAR.LOCKS CLEAR.LOCKS 0001: V | V 0002: CLEAR.LOCKS | CLEAR.LOCKS 0003: I | I 0004: G | G 0 difference(s) .L RELLEVEL RELLEVEL 001 X 002 10.0.16 003 PICK 004 PICK.FORMAT 005 10.0.16 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Help on uv syntax, please
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 could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help on uv syntax, please
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 one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. (p.s. if you could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: anyone using Redback on Windows 3000 server?
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? Subject: anyone using Redback on Windows 3000 server? Wow.. must be some early pre-alpha version of Windows. Is that one code-named Longwaysaway? If so, have there been any issues? Problems? You probably meant '2003 Server', in which case I can say that we've installed the RedBack Gateway on Windows 2003 Server, and have not run into any issues or problems yet. -Tony Tony Evans Web Developer Richmont Direct -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please[Scanned]
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 NEWARRAY = CHANGE(OLDARRAY,SVM,VM) Would change the char(252) to char(253) in the string 'OLDARRAY' Thanks a mil, Susan -Original Message- From: Georgia L. Pritchett [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 12:59 PM To: U2 Users Discussion List Cc: [EMAIL PROTECTED] Subject: RE: Help on uv syntax, please[Scanned] Actually CONVERT will only work to replace 1 character with 1 other character (well, it's more complicated than that because you provide a list of character to replace and another list of character to use for replacement but it's positionally dependant). It's what I use for converting 1 single character to another single character myself. But the CHANGE function, which is available in Universe, is more powerful since it can take a substring and convert it to a different length substring. So you convert all the OUT's in your string to IN's. Georgia Pritchett -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kishor Parmar I use CONVERT expression1 TO expression2 IN variable -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: 27 April 2004 17:48 To: [EMAIL PROTECTED] Subject: Help on uv syntax, please 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. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
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 PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, April 27, 2004 11:48 AM To: [EMAIL PROTECTED] Subject: Help on uv syntax, please 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 could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
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) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, April 27, 2004 12:48 PM To: [EMAIL PROTECTED] Subject: Help on uv syntax, please 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 could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
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
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 even for those of us who don't speak Welsh. cds P.S. Last week I said REPLACE() instead of CHANGE() in the following post. I've corrected it ( i.e., CHANGE( 'REPLACE()', 'CHANGE()', MSGBODY ) ) here: -Original Message- From: Stevenson, Charles Sent: Thursday, April 22, 2004 2:41 PM To: 'U2 Users Discussion List' Subject: RE: How do we convert lowercase letters to uppercase in Pick basic and just cuz no one mentioned it ( not cuz it's better than UPCASE() DOWNCASE() ), CONVERT does character for character swapping: CONVERT 'abcdefghijklmnopqrstuvwxyz' TO 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' in ANYSTR and CONVERT 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' TO 'abcdefghijklmnopqrstuvwxyz' in ANYSTR or UPSTR = CONVERT( 'abcdefghijklmnopqrstuvwxyz', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', ANYSTR ) and DNSTR = CONVERT( 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz', ANYSTR ) depending on your mood. Note the difference between CHANGE() CONVERT(). Use CHANGE() to replace an entire substring with another substring. CONVERT does char by char. A common misconception. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML and U2
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 gets created and then when a dictionary is populated, it is descriptive of the data (so not quite the same as an RDBMS that way) and can include sub-fields. The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Let me know if that doesn't quite answer the question. Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, April 27, 2004 11:30 AM To: U2-Users Subject: Fw: XML and U2 I finally got an answer back from Ron Bourret and he has added the U2 products to his XML enabled list of databases. Anybody want to answer his question? I could do it but I'm kind of busy right now. Jerry - Original Message - From: Ronald Bourret [EMAIL PROTECTED] To: Jerry Banker [EMAIL PROTECTED] Sent: Monday, April 26, 2004 6:32 PM Subject: Re: XML and U2 This is to let you know that I've finally added UniVerse and UniData to the list. You can see the entries at: http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#unidata http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#universe Comments / corrections welcome. (One question I had was whether UniVerse supports multi-subvalued columns as well as multi-valued columns. There are a number of references to subvalues in the documents, but the UniVerse CREATE TABLE command does not seem to support them...) Thanks for you patience, -- Ron Jerry Banker wrote: Ronald Bourret, Looking over your list of XML enabled databases I was impressed however I noticed that you included IBM's DB2 product but excluded IBM's most XML like databases referred to as their U2 product line (uniVerse and Unidata). Both U2 products are post-relational and use a nested file architecture very much similar to XML design and do have XML transformation tools (uniVerse more so than Unidata at the latest revision). XML documents can be output through their query language and imported into the database through simple commands. Another advantage is that the database can be accessed through it's native query language or with SQL. You should look into these products if you have not already. http://www-3.ibm.com/software/data/u2/ Jerry Banker Member U2UG -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Problem reactivating select list
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 PICK flavor, but I forgot. Reading through all the posts jogged my memory. To answer some of the questions as to why I chose this particular route: I prefer to never copy and modify the system utilities themselves because I'm then relegated to that version of the tool and miss out on any fixes/enhancements in later UV releases. There's also the possibility that the current version won't work correctly in later releases. I'd rather not have the ongoing maintenance and overhead of adding triggers to every file in the database (and can't in UV 9.6 anyway). Also one of the main benefits of the audit trail is capturing changes to BPs and procs that reside in type 19 files. As to the issue of people finding loopholes in ED to get around the auditing, that's not really a big concern. We have good people here and this is more of a tool to assist them rather than being big brother. If someone has to quickly fix some data on the fly and they fail to document it, now they have automatic documentation to fall back on. Thanks, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
-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 mean there are no legitimate uses for CONVERT. In the spirit of Abraham Lincoln who once said, For people who like this sort of thing, this is exactly the sort of thing they'd like, I'll say, Do not use CONVERT except for exactly the sort of thing CONVERT should be used for. Ok, Abe's was better. I use convert a lot. Examples: 1. When I'm trying to debug a complicated multivalue-handling i-descriptor that isn't acting like I expect, I tack a convert on the end LIST to see what I've got: 01 I 02 [complicated buggy mv expression] ; CONVERT( @IM:@AM:@VM:@SM:@TM, 'iavst', @ ) 05 80L--- wide enough to see string 06 S --- it's not M anymore. 2. To yield a dyn array of question marks or blanks depending on whether corresponding values are equal: 01 I 02 CONVERT( '01', '?', EQS( MV.THING1, MV.THING2 ) ) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: anyone using Redback on Windows 3000 server?
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 Survival kit CD... Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobby Ramirez Sent: 27 April 2004 17:59 To: 'U2 Users Discussion List' Subject: RE: anyone using Redback on Windows 3000 server? 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? Subject: anyone using Redback on Windows 3000 server? Wow.. must be some early pre-alpha version of Windows. Is that one code-named Longwaysaway? If so, have there been any issues? Problems? You probably meant '2003 Server', in which case I can say that we've installed the RedBack Gateway on Windows 2003 Server, and have not run into any issues or problems yet. -Tony Tony Evans Web Developer Richmont Direct -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED Performance tuning UV on Windows2003
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 'Pages/sec' count is not measuring what I expect it to, but it seems odd to me for the system to be paging (i.e. swapping program code segments in and out of memory) in this situation. I'd except the disk system to be getting a thrashing as the two processes want to read different bits of the same file, but not paging. Can anyone tell me 1) Do I understand correctly what is happening? If not, what _is_ going on? 2) Are there any UV configuration tunables which could improve the situation? If so, which one(s)? 3) Are there any Windows configuration tunables which could improve the situation? If so, which one(s)? Oh, it's UV 10.0.15, but I don't think that's terribly relevant Thanks Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 - Universe
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 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 ? Sorry Ross, that won't work because the D3 ODBC client driver is Win32 only. Barry said he's running on Linux. Although he CAN create some code in a Win32 middle-tier and use that as a hub between the Linux boxes. Chuck suggested: Set up the D3 files you need to access as FSI (external file format) and point to them from UniVerse (SAMBA, VisionFS, or file mapping) as Type 19. No... FSI doesn't work like that, FSI files are still mini blobs unto themselves. And here too, there is no FSI over Linux. Barry - there are a few ways to do this, one of which might be to use CallHTTP (or another HTTP call) from Universe and FlashCONNECT or a home-grown HTTP interface with D3. The solution will depend on how transparent or tightly integrated you want these environments to be. If you want a READ in UV to read a record in D3 then some creative coding is required, but it's possible. I'll be happy to discuss solutions with you for free but some coding/services will be required to make this happen. Tony [EMAIL PROTECTED] Former DBMS Product Manager, Raining Data, including D3. Currently specializing in communications interfaces for MV platforms and applications. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML and U2
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: Ronald Bourret [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 4:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML and U2 Thanks. That clarifies things and I'll modify the entry for UniVerse to account for this. You do raise a new question when you say: The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Does this mean that you can have sub-sub-values, sub-sub-sub-values, and so on, ad infinitum? If so, do the XML tools handle this, adding more sub-elements as needed? The XML = DB mapping languages for UniData and UniVerse don't seem to handle this, except that the documentation for UniData seems to allow one level beneath sub-values, saying something about adding another sub-element in the case of text marks. (I dutifully ignored this, having spent too much time on the entries already :) -- Ron Dawn M. Wolthuis wrote: 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 gets created and then when a dictionary is populated, it is descriptive of the data (so not quite the same as an RDBMS that way) and can include sub-fields. The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Let me know if that doesn't quite answer the question. Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, April 27, 2004 11:30 AM To: U2-Users Subject: Fw: XML and U2 I finally got an answer back from Ron Bourret and he has added the U2 products to his XML enabled list of databases. Anybody want to answer his question? I could do it but I'm kind of busy right now. Jerry - Original Message - From: Ronald Bourret [EMAIL PROTECTED] To: Jerry Banker [EMAIL PROTECTED] Sent: Monday, April 26, 2004 6:32 PM Subject: Re: XML and U2 This is to let you know that I've finally added UniVerse and UniData to the list. You can see the entries at: http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#unidata http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#universe Comments / corrections welcome. (One question I had was whether UniVerse supports multi-subvalued columns as well as multi-valued columns. There are a number of references to subvalues in the documents, but the UniVerse CREATE TABLE command does not seem to support them...) Thanks for you patience, -- Ron Jerry Banker wrote: Ronald Bourret, Looking over your list of XML enabled databases I was impressed however I noticed that you included IBM's DB2 product but excluded IBM's most XML like databases referred to as their U2 product line (uniVerse and Unidata). Both U2 products are post-relational and use a nested file architecture very much similar to XML design and do have XML transformation tools (uniVerse more so than Unidata at the latest revision). XML documents can be output through their query language and imported into the database through simple commands. Another advantage is that the database can be accessed through it's native query language or with SQL. You should look into these products if you have not already. http://www-3.ibm.com/software/data/u2/ Jerry Banker Member U2UG -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 - Universe
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 Rick We use wintegrate bridge copy to achieve copies of files but what we are attempting to do is real-time enquiry from Universe to D3 files Barry 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 from Binary Star). I think you can get a free trial copy of AccuTerm from their site. Rick Ramsey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brooks Sent: Tuesday, April 27, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: D3 - Universe 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 PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Redback SOAP requests from .NET
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 www.ultradata.com.au -Original Message- From: Kay, Malcolm [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 April 2004 6:29 PM To: U2 Users Discussion List Subject: Redback SOAP requests from .NET 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 Web: http://www.tauntondeane.gov.uk IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately on +61 3 9291 1600. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. To unsubscribe from receiving commercial electronic messages from Ultradata Australia please email [EMAIL PROTECTED] with the subject heading Unsubscribe. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 - Universe
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 for processing. For large reports coming back, this will be an issue and some code will need to be built around the request to page the data back to Universe. If you want to do this sort of thing on your own, then AccuTerm scripting can be used to do the data exchanges. The AccuTerm session doesn't need to be on the same desktop as the user, and in fact you can have one system doing the connectivity for many users. This isn't elegant either, but a lot of people like using familiar tools. If you want a more elegant solution, then more coding is required. We're doing some development now which allows one MV platform to integrate very closely with other MV platforms, almost seamlessly, but it's not ready yet. If you're interested, please e-mail. Tony [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brooks Sent: Tuesday, April 27, 2004 3:58 PM To: U2 Users Discussion List Subject: RE: D3 - Universe 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 Rick We use wintegrate bridge copy to achieve copies of files but what we are attempting to do is real-time enquiry from Universe to D3 files Barry 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 from Binary Star). I think you can get a free trial copy of AccuTerm from their site. Rick Ramsey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brooks Sent: Tuesday, April 27, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: D3 - Universe 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 PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ODBC Universe (Unix) to MS Access
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] [mailto:[EMAIL PROTECTED] Behalf Of Herve Balestrieri Sent: Tuesday, April 27, 2004 8:18 PM To: [EMAIL PROTECTED] Subject: RE: ODBC Universe (Unix) to MS Access 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 : http://www.datadirect.com/aboutus/strategicpart/index.ssp they demonstrate that many database and database management solutions vendors such as Progress Software and IBM (for Websphere and Websphere MQ) are embedding the DataDirect products into their products. The interesting point is that they are the ONLY licensed by Microsoft to have access to the source code and developments Microsoft does around ODBC, so they can port to UNIX and Linux the ODBC drivers developped by Microsoft. Hervé BALESTRIERI Support Technique Avancé - IBM Data Management - Produits U2 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UVODBC/OleDB job Randomly hang
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 performance is greatly degraded and interactive users cannot log in. When this happens, they have been forced to restart UniVerse. They have a uvodbc user set up that is called via the .NET calls. Most of the processes are owned by the user uvodbc, however, the common thread is that there are a number that are owned by root. They are the processes that tend to be the ones that hang about especially when the system slows down. Has anyone seen this sort of behavior, any suggestions? Thanks, Bob Gerrish - [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Timestamp
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
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 this request on the D3 machine etc. A little work but fun I dare say. Cheers Trevor Ockenden Open Systems Professionals PS This technique then allows for all sorts of requests that may go way beyond Retrieve type requests. - Original Message - From: Barry Brooks [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 8:58 AM Subject: RE: D3 - Universe 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 Rick We use wintegrate bridge copy to achieve copies of files but what we are attempting to do is real-time enquiry from Universe to D3 files Barry 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 from Binary Star). I think you can get a free trial copy of AccuTerm from their site. Rick Ramsey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brooks Sent: Tuesday, April 27, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: D3 - Universe 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 PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.669 / Virus Database: 431 - Release Date: 26/04/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Timestamp
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Eugene Perry Sent: Tuesday, April 27, 2004 8:06 PM To: [EMAIL PROTECTED] Subject: Timestamp 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
NT files on Unidata
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