Re: [U2] Suggestions for flattening Multivalues...

2011-11-09 Thread Robert Houben
Whenever the fields are related (an association) the related fields can all make a single table. The only other thing you can do is to explode the single values to match the multivalues, but with different multivalue counts, you wind up with lots of null values. To make it really useful, I'm

Re: [U2] [semi-ot] JE Sisk basic book on the eBay

2011-11-09 Thread Robert Porter
It's commonly available on Amazon's market in used condition for that range as well. http://www.amazon.com/gp/offer-listing/0830628452/ref=dp_olp_used Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-26 Thread Robert Porter
that it goes through this time. Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-26 Thread Robert Porter
any more real... sorry to burst your bubble. So you come on ... admit that programming for this is not a very easy solution. Robert Mecki Foerthmann mec...@gmx.net 10/26/2011 2:44 PM Come on, get real. Do you suggest the deadly embrace would be better and he would get his results any

Re: [U2] SLOW

2011-10-08 Thread Robert Houben
Just don't get both, or you may go to plaid... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: October-08-11 7:28 AM To: U2 Users List Subject: Re: [U2] SLOW Wouldn't that mean xlr8ing?

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-07 Thread Robert Porter
to look for a web designer (Webhostingtalk.com's forum comes to mind - no affiliation - just a forum I frequent). Back to everyone: The ads don't bother me provided they aren't excessive and they are relative to the discussion at hand. Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP

Re: [U2] FAST

2011-10-07 Thread Robert Porter
The minute the U2 listserver makes the term battle come to mind, is the minute I un-subscribe. Bill Brutzman bi...@hkmetalcraft.com 10/7/2011 8:31 AM In the book American Caesar - Douglas MacArthur, the author Wm Manchester makes the point that... arrogance is a good thing. The last thing

Re: [U2] Question about accessing external SQL database [AD]

2011-10-06 Thread Robert Houben
Two points: First, we have a product that does this for you. You can see it here: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxConnectAPI.aspx It uses Universe's built-in HTTP GET/POST capability to call a local web services layer that in turn uses the SQL Server JDBC

Re: [U2] Changing TCL prompt?

2011-10-05 Thread Robert Houben
It used to be byte 0 of frame 6, in the old Microdata Reality/R83 days... :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of gcan...@coverys.com Sent: October-05-11 11:06 AM To: u2-users@listserver.u2ug.org Subject:

Re: [U2] Ardent programmers

2011-09-09 Thread Robert Porter
I heard he was the first to use RTFM!. Charles Stevenson stevenson.c...@gmail.com 9/9/2011 10:07 AM I heard he designed and implemented the original Universe. He left a rather hefty manual. It was updated after his last visit. On 9/9/2011 8:23 AM, Glenn Sallis wrote: I guess he must be

Re: [U2] UniVerse backups to disk

2011-08-23 Thread Robert Porter
. Wols Lists antli...@youngman.org.uk 8/23/2011 6:28 AM On 22/08/11 14:56, Robert Porter wrote: ... Interesting. The reason I suggested breaking the mirror was that mirroring is a common technique. ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] UniVerse backups to disk

2011-08-22 Thread Robert Porter
roughly 24 hours - post was less than 3. Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including

Re: [U2] UniVerse backups to disk

2011-08-22 Thread Robert Porter
. But the snapshot LV is actually only holding the pending writes. Unmounting the snapshot writes all the data (in order) to the real LV. While snapshot'ed the OS knows what's changed and what hasn't and UV never knows the difference. Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer

Re: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer?

2011-08-10 Thread Robert Porter
Is the box able to resolve domain names properly? I suspect that would be a Reverse DNS issue. When a telnet or SSH connection is setup, the server does a RDNS lookup from ip to hostname. The LONG pause between connection and login is the 1st symptom of that problem. Robert F. Porter

Re: [U2] uniobjects question [AD]

2011-08-08 Thread Robert Houben
[AD]While it may be impossible with UO, FusionWare's Direct Data Access Server supports a mechanism called EXEC TCL in which you can call any program that can be run from TCL, and pass it inputs, like a PROC or a CGI program. If you miss an input, things will get kind of stuck, but if you know

Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix

2011-08-02 Thread Robert Houben
Just on the off chance that this helps, here are a few things we've run into in the past with SSL connectivity to Linux: 1. Depending on your Linux version, make sure that the firewall software is not blocking access to the uvtelnetd server. 2. Make sure that you have the certificate that

Re: [U2] CONV MCU on indexed field?

2011-07-26 Thread Robert Porter
Just curious and maybe I missed it... Has anyone tried LIKE and ... instead? I wouldn't think it would be any different, but then I would have thought the ] select would have worked. Robert Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services

Re: [U2] CONV MCU on indexed field?

2011-07-26 Thread Robert Porter
wouldn't think it would be any different, but then I would have thought the ] select would have worked. Robert Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments

Re: [U2] udt dir file max key length

2011-07-22 Thread Robert Porter
, but I thought it was interesting none-the-less. Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material

Re: [U2] Document Management

2011-07-22 Thread Robert Porter
it... roporter -at ochsner -dot- org Rob Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material

Re: [U2] Document Management

2011-07-22 Thread Robert Porter
://code.google.com/p/twaindotnet/ and Pdfsharp project is found here: http://www.pdfsharp.net/ Don't confuse it with sharppdf ... which I first tried to use but kept having issues with it crashing with image processing (it did textual PDFs fine). Robert F. Porter, MCSE, CCNA, ZCE, OCP

Re: [U2] Found something interesting.....Bug or No Bug....that is my question?

2011-07-07 Thread Robert Houben
While I agree that the user typing the commands may find the results unexpected, if you think about how the TCL commands are implemented, it actually makes sense. If I type: ED FOO BAR The ED command has been given an item-id so it attempts to read it. If I type: ED FOO it checks if there's a

Re: [U2] Verifying file existence

2011-06-28 Thread Robert Houben
Or you could simply do it like this: :ED USER.PROGRAMS RH.TEST Top of RH.TEST in USER.PROGRAMS, 9 lines, 230 characters. *--: P 001: FILEPATH=./D_VOC 002: CMD = if [ -e :FILEPATH: ]; then echo yes; else echo no; fi; 003: PCPERFORM CMD CAPTURING OUTPUT 004: PRINT OUTPUT=:OUTPUT 005: IF

Re: [U2] Verifying file existence

2011-06-28 Thread Robert Houben
Unidata on Windows version, change one line: CMD = 'if exist ':FILEPATH:' (echo yes) else (echo no)' -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Tuesday, June 28, 2011 11:53 AM To:

Re: [U2] Coversion Code for Date

2011-06-03 Thread Robert Porter
UV on HP-UX -- PI flavor : 0001: TODAY = DATE() : 0002: PRINT OCONV(TODAY,'D4-YMD') : 0003: END Bottom at line 3. : Q :RUN SRC RFPD4 2011-06-03 Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System

Re: [U2] Universe : different time zone from AIX

2011-05-24 Thread Robert Houben
It seems you can do so from this link: http://www.unix.com/aix/77811-setting-connection-time-zone.html YMMV... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marcos Fogaca Sent: Tuesday, May 24, 2011 8:00 AM To:

Re: [U2] Universe : different time zone from AIX

2011-05-24 Thread Robert Porter
, but type SET by itself at the os level and see what environment variables are there... Hope it helps. Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments

Re: [U2] Universe : different time zone from AIX

2011-05-24 Thread Robert Porter
care about any type of comparison across timezones. Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material

Re: [U2] 64 bit odbc/oledb drivers

2011-05-23 Thread Robert Houben
Not that I know of. We've looked at doing it here at FusionWare, and could do it with ours, but it would need enough customers interested, or one willing to fund the development. There are a bunch of places where a 32-bit integer is replaced with 64-bit in the API parameters, and then we have

Re: [U2] Saying Goodbye... Reasons not to say goodbye.

2011-04-29 Thread Robert Porter
out there, it gets very confusing. People are making assumptions about free and open source software without looking at the terms they are accepting. Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System

Re: [U2] Saying Goodbye...

2011-04-27 Thread Robert Porter
modules in Perl, embed Perl code directly into Apache configuration files, and even use Perl in server-side includes. With mod_perl, Apache is not only a web server, it is a complete programming platform. Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst

Re: [U2] Mailing List Hacked

2011-04-19 Thread Robert Porter
I was about to mention that... his email address appears in 3+ dozen pages in google. So unless there's some other evidence, I'm not worrying about the list being hacked. Robert George Gallen ggal...@wyanokegroup.com 4/19/2011 7:26 AM not to mention that the list is on search engines

Re: [U2] PDF Files directly from UniData or UniVerse

2011-04-12 Thread Robert Porter
of other things like barcodes, forms, etc. They've also been VERY responsive when I've seen an issue or needed an enhancement. Disclosure (since this is such a big issue lately) - I have ZERO affiliation with the software except as a happy customer. Robert Robert F. Porter, MCSE, CCNA

Re: [U2] Disclosing technology

2011-04-12 Thread Robert Porter
not worth the trouble. Robert fft2...@aol.com 4/11/2011 9:28 PM I knew you were talking about me. I do not accept your claim that this decision is up to the company however. Any former employee can certainly state what technology a company used, and there is no legitimate contract which could

Re: [U2] Disclosing technology

2011-04-12 Thread Robert Porter
PHP isn't a database... apples and oranges. fft2...@aol.com 4/12/2011 12:18 PM You're speaking about technical specifications, not the freakin database :) Apples and oranges. If Google tried to stop an ex-employee for declaring that they use PHP, they'd be laughed off the planet.

Re: [U2] Disclosing technology

2011-04-12 Thread Robert Porter
Not skirting anything. The 1st line of my 1st reply ... consider everything inside the DC proprietary and confidential. You ignored that line apparently and decided to focus instead on the article was about the infrastructure and then changed from db technology to programming language in

Re: [U2] Opinions on Cache

2011-04-11 Thread Robert Porter
I can say that in the healthcare field Cache' is a significantly easier sell than U2. Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain

Re: [U2] Who is Ed Clark?

2011-04-11 Thread Robert Porter
I think he meant their as in Scotland's not InterSystems'. At least that's how I read it. The product was TrakCare I believe. Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission

[U2] [AD] RE: Accessing Pervasive SQL database from Universe

2011-04-08 Thread Robert Houben
Richard, We have products that work for both Universe and PI Open. You may wish to look at some of the products here: http://www.fwic.net/Products/MultiValueProducts.aspx Thank you, -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Databasic conversion

2011-04-08 Thread Robert Houben
It doesn't. You have to convert. If you have F or A correlatives, you may wish to consider something other than Unidata as the target to convert to. Universe supports them just fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] SOAP Services and Host Question

2011-04-01 Thread Robert Houben
Open a command shell on AIX and type: ping wsCatalog If that works (and returns a correct IP address), then use telnet and go to: telnet wsCatalog 80 If it connects it will appear to hang there. Carefully type in the following (you may not see it echo - return means press return): GET /return

Re: [U2] SOAP Services and Host Question

2011-04-01 Thread Robert Houben
Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Friday, April 01, 2011 8:28 AM To: U2 Users List

Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam

2011-03-22 Thread Robert Houben
...@listserver.u2ug.org] On Behalf Of Brett Callacher Sent: Tuesday, March 22, 2011 4:35 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam Actually Robert, I think English does have this word. You just used it - the rather unfashionable 'one'. Brett

Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam

2011-03-18 Thread Robert Houben
Good point, Bill, I think one sometimes uses you when one means someone other than themselves, without intending to pin the reader with the crime being mentioned. The English language does not differentiate plural, general you from singular, specific you (unless you're from the deep south, in

Re: [U2] [SPAM?] PROC language documentation

2011-03-15 Thread Robert Houben
That's the Reality New PROC variant. Check with Northgate for their Reality user guides. They have online versions. http://www.northgate-reality.com/products.php?pageId=77 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] PROC language documentation

2011-03-15 Thread Robert Houben
Hopefully, Unidata's implementation of the Reality New PROC variant is fairly accurate. I would still go with the Reality guides. Your mileage may vary... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

Re: [U2] 'U2 Market Place' {Unclassified}

2011-03-07 Thread Robert Porter
Don't know anything about u2marketplace.com -- looks to be brand new with basically empty forums, etc. but serverphase.com is a hosting company. They are legit, but I suspect their only connection is they are being paid to host u2marketplace... Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java

Re: [U2] Is this worth rewriting?

2011-03-02 Thread Robert Houben
That *is* cool! I still remember helping my dad with his tube tester. He'd repair radios and TVs for his friends from work. In return he got their rejects for parts. We never had to buy a TV... There's something about the sound from an old tube radio that you can't beat! Sometimes when I

Re: [U2] U2 soap server on startup

2011-02-24 Thread Robert Houben
Look at this source-forge project: http://sourceforge.net/project/shownotes.php?release_id=60527 It allows you to wrap any java server provided the server does not try to get interactive (the usual caveats). Also, be aware that this will then run in the context of the machine user, so you

Re: [U2] [SPAM?]Re: silly company names

2011-02-19 Thread Robert Houben
Then what about biff? Named after the writer's dog. Anyone remember Seattle Lab? It was named for the owner's black lab. My first computer company that I worked for was called Toga Computer Services. Named after the owners, Tony and Gary. We actually got calls from people who thought we

Re: [U2] [UV] UniVerse Uptime

2011-02-17 Thread Robert Porter
Interesting question... Don't know how accurate it would be but on my box /usr/uv/VOC has a timestamp of the last time I brought uv up. I'll be interested to see what others have to say on this. Rob Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java6 Lead Sr. Programmer / Analyst

Re: [U2] Pick Dinosaurs

2011-02-07 Thread Robert Houben
The first machine I worked on was a Microdata 1600 with 4 50 MB Winchester washtub drives. It ran 16 users on 64K of core memory. That was back in 1981. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

Re: [U2] What do you do with CallHTTP? [AD]

2011-01-28 Thread Robert Houben
We use CallHTTP with some of our customers to push/pull data between Universe BASIC and SQL Server, Oracle, etc..., through a connection-pooled HTTP(s) server. We provide an API of subroutines to manage the interface. It's part of our mvLynx Connect API product. We have customers doing a

Re: [U2] Refresh UV user permissions without restarting UV Service ?

2011-01-28 Thread Robert Houben
It's one thing if you change the permissions for a resource that the user is trying to access, but when you change the rights that a user is assigned, any session that is already active for that user already has all its access tokens and won't reflect your change. You will have to log that

Re: [U2] What do you do with CallHTTP?

2011-01-28 Thread Robert Houben
Somewhere embedded in those 20 lines are the two special instructions: RMM (read my mind) DWIM (do what I meant) :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Friday, January 28, 2011

Re: [U2] Data in Dict

2011-01-26 Thread Robert Houben
In Java, you have the same problem. The UID is only unique for the machine, so the common trick is to take the IP address of the local machine and use it as a prefix (should be unique within your network anyways). -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] CoRelating Two Arrays

2011-01-26 Thread Robert Houben
Nothing is resetting Where.We.Left.Off to 1. The code that you are providing below sets it to 1 at the beginning and NEVER CHANGES IT! The only place you reference it in your code is the for Receiver.Count... loop, and there it is only used to set the initial value of Receiver.Count. Its

Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64

2011-01-26 Thread Robert Houben
It is possible that this is a permissions problem. Try the following: - Disable UAC and rerun the app. - Disable UAC and run the app as Administrator. If that still doesn't work, then I'm out of rabbits, or need a closer look at the hat. If either one works, then you have hit a UAC problem.

Re: [U2] LIST.READU - clear lock table ?

2011-01-19 Thread Robert Porter
When I've seen a large Userno like that in LIST.READU, it's a PHANTOM holding the lock. Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential

Re: [U2] Fault type is 11. Layer type is BASIC run machine.

2011-01-18 Thread Robert Porter
(file) actually exist already? If so, check the perms on the file itself. Those will override the directories if they're tighter. Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission

[U2] [AD] New product mvLynx 2SQL is FusionWare's upgrade path for mv2SQL

2011-01-18 Thread Robert Houben
[AD] New product mvLynx 2SQL is our upgrade path for mv2SQL. http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynx2SQL.aspx?s=lrd=20110118c=1 Robert Houben CTO FusionWare Integration Corp. p: 604-777-4254 x158 m:604-219-8394 f: 604-608-5544 http://www.fwic.net LinkedIn http

Re: [U2] Migration

2010-12-28 Thread Robert Houben
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Friday, December 24, 2010 1:41 AM To: U2 Users List Subject: Re: [U2] Migration Oh, one more point. What if your SQL environment had NOT defined a primary key for APPOINTMENTS, but had multiple indexes, one

Re: [U2] Migration

2010-12-26 Thread Robert Houben
-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Sunday, December 26, 2010 4:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Migration On 24/12/10 15:50, Robert Houben wrote: SQL will beat MV every time when you sort fields that are indexed. Huh? Ime (UniVerse), that's wrong

Re: [U2] Migration

2010-12-26 Thread Robert Houben
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Sunday, December 26, 2010 4:42 PM To: U2 Users List Subject: Re: [U2] Migration Should have clarified when you sort *multiple* fields that are indexed. I still haven't heard anyone tell me that either

Re: [U2] Migration

2010-12-26 Thread Robert Houben
employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-26-2010 6:50 PM, Robert Houben wrote: I should also clarify that we have a lot of customers we support on mvBase, mvEnterprise, D3 and lots of other platforms, and yes, we do have PI Open

Re: [U2] Migration

2010-12-24 Thread Robert Houben
A read on a primary key is about as efficient as an MV hashed read. Each has their trade-offs. Get the modulo wrong and your MV read can be nasty. You can get a SQL table in trouble, too. You really can't beat getting all your data in one disk head movement, but we were talking about just

Re: [U2] Migration (OT)

2010-12-24 Thread Robert Houben
fields. And that's where any attempts to fully automate this process has to fail. On 24/12/2010 15:50, Robert Houben wrote: A read on a primary key is about as efficient as an MV hashed read. Each has their trade-offs. Get the modulo wrong and your MV read can be nasty. You can get a SQL table

Re: [U2] Migration [AD]

2010-12-23 Thread Robert Houben
I've been watching this thread with some interest. Because I'm going to reference our product, I'm putting th [AD] marker on this. One of our best-selling products assists our customers in rapid migration/data warehousing of Multivalued and Subvalued data to either SQL Server, Oracle, DB2,

Re: [U2] Migration

2010-12-23 Thread Robert Houben
, December 23, 2010 4:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Migration On 24/12/10 00:07, Robert Houben wrote: I've been watching this thread with some interest. Because I'm going to reference our product, I'm putting th [AD] marker on this. One of our best-selling products

Re: [U2] Migration

2010-12-23 Thread Robert Houben
I may have been unclear in my earlier post, so I'll clarify. Consider a CUSTOMER file and an APPOINTMENTS file. The item-id of the CUSTOMER file is the customer number. The item-id of the APPOINTMENTS file is CUSTOMERNO*APPTDATE*APPTTIME*APPTTYPE. When you have a parent/child relationship in

Re: [U2] Migration

2010-12-23 Thread Robert Houben
-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Thursday, December 23, 2010 10:36 PM To: U2 Users List Subject: Re: [U2] Migration I may have been unclear in my earlier post, so I'll clarify. Consider a CUSTOMER file and an APPOINTMENTS file. The item-id of the CUSTOMER file

Re: [U2] Strange index issue (nothing to do with last question)

2010-11-09 Thread Robert Porter
Check out the SET.INDEX command... SET.INDEX filename TO NULL Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged

Re: [U2] Strange index issue (nothing to do with last question)

2010-11-09 Thread Robert Porter
through the account to change the rest of the files? Thanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Tuesday, November 09, 2010 4:54 PM To: U2 Users List Subject: Re: [U2] Strange

Re: [U2] Upgrading and Migrating from Unix to Windows

2010-11-09 Thread Robert Houben
Hi Richard, We have both a Relational Data Access Server and a Direct Data Access Server that are written in fairly generic PICK/BASIC but with specific subroutines to do platform-specific stuff. We run on pretty well all MV platforms including Unidata, Universe, PI/Open and even some very

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Robert Houben
If your batch file is named myfile.bat, then try executing the DOS command cmd.exe /c myfile.bat. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 12:35 PM To: 'U2 Users

Re: [U2] how to round to 2 decimals?

2010-10-13 Thread Robert Porter
OCONV(X,MD2) Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor

Re: [U2] EMailing from Universe

2010-09-12 Thread Robert Houben
You'll have to install the SMTP service on your system and configure it to connect to your mail server. That server may have to be configured to allow you to allow mail from your SMTP service on your system. SMTP service is an optional component. I'm not sure that it's available on XP Home

Re: [U2] Sequential Files Question

2010-09-09 Thread Robert Houben
Use echo . to get just a carriage return into the file. Note that you don't have permissions to write the file, therefore any attempt to create it from BASIC will also fail. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] [UV] Shared Record Locks {Unclassified}

2010-09-01 Thread Robert Houben
Note that I have had customers who have had conformance requirements (FDA) that do not allow them to use optimistic locking. It is not appropriate in all cases. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

Re: [U2] possible to reverse engineer unibasic object?

2010-08-31 Thread Robert Houben
A long time ago, I wrote a reverse compiler for Reality. It even found the variable map if you compiled with the M option and put the right variable names back. Yes, it can be done, but I don't have the source for the reverse compiler anymore, and it wouldn't work for UniBASIC anyways.

Re: [U2] Ordinal could not be found in dynamic link library

2010-08-24 Thread Robert Houben
Hi Charles, Native NT dlls expose the entry points to publicly exposed methods in a table. The named methods are mapped to that table. When you link to a method in a dll, the compiler loads the external dll, looks up your method in the table, and actually links to it by the ordinal offset of

Re: [U2] Ordinal could not be found in dynamic link library

2010-08-24 Thread Robert Houben
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Tuesday, August 24, 2010 7:50 AM To: U2 Users List Subject: Re: [U2] Ordinal could not be found in dynamic link library Hi Robert, Thank you for the explanation. I see what the error means

Re: [U2] Ordinal could not be found in dynamic link library

2010-08-24 Thread Robert Houben
If they were in your path before, everything would have worked. Dependencies have been known to drive programmers crazy. They used to call it dll-hell. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

[U2] TCL command history

2010-08-20 Thread Robert Porter
Are TCL command histories stored in a file by any chance? I'm trying to find how a record got updated, and it doesn't appear to have gone through our standard program which updates the record with a who/when timestamp. TIA, Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer

Re: [U2] TCL command history

2010-08-20 Thread Robert Porter
Sorry, it's UV. Thanks! Searching now... Robert Dan Goble dgo...@interlinebrands.com 8/20/2010 9:13 AM If you are using Universe the TCL command history is stored in the SAVEDLISTS file. If you are using unidata they are stored in the users home directory in a file .ustk_loginid

Re: [U2] TCL command history

2010-08-20 Thread Robert Porter
...@youngman.org.uk 8/20/2010 3:53 PM On 20/08/10 15:08, Robert Porter wrote: Are TCL command histories stored in a file by any chance? I'm trying to find how a record got updated, and it doesn't appear to have gone through our standard program which updates the record with a who/when timestamp. You can do

Re: [U2] easiest way to COMPILE/CATALOG for a build?

2010-08-18 Thread Robert Houben
Try running it from the directory where the VOC resides with the C:\IBM\UV\bin directory added to your path. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, August 18, 2010 2:00 PM To:

Re: [U2] easiest way to COMPILE/CATALOG for a build?

2010-08-18 Thread Robert Houben
- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, August 18, 2010 2:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build? Thanks Robert, That actually worked

Re: [U2] Unix to SQLServer[AD]

2010-08-13 Thread Robert Houben
At the risk of being roasted for mentioning my vendor product (see other threads - it seems to be unpopular) I'd like to point out that there is a 4th option. We have an API layer (UV/BASIC subroutines) that allow you to do semantically the same as OPEN, READ/WRITE/DELETE statements with

Re: [U2] mv.NET and U2.NET [AD]

2010-08-02 Thread Robert Houben
Hi Bill, [AD] There is another ADO.NET option available to you, which you may not be aware of, which is our FusionWare Direct ADO.NET provider. Information on this option is available at http://www.fwic.net. Our customers get excellent stability and performance from our direct product line,

Re: [U2] Universe Triggers

2010-07-30 Thread Robert Porter
How real-time does it need to be? Could you write them to a queue file and have a small batch process pick them up and email them? Rob Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any

Re: [U2] Unidata 7.1.9 and .Net DLL

2010-07-20 Thread Robert Houben
Check out regasm.exe (part of the .NET SDK). You can use it to create a COM Interop interface to an assembly. Note that on a x64 system there is one version for 32 bit, and another one for 64 bit access. You can add these lines to a PostBuildEvent:

Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 03/07/2010)

2010-07-02 Thread Robert Houben
Note that it says This is the only notification you will receive while this person is away. Since we get a new one every once in a while, does that suggest that he was briefly in, and is now away AGAIN!?!?!? Inquiring minds need to know... :o -Original Message- From:

Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 03/07/2010)

2010-07-02 Thread Robert Houben
European date format vs. North American date format. Can be set when you configure your PICK system (how, depends on your version of PICK.) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc Harbeson Sent:

Re: [U2] pick item date/time modification

2010-06-21 Thread Robert Houben
Not without creating a trigger and explicitly adding it. Sorry. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Monday, June 21, 2010 11:51 AM To: U2 Users List Subject: [U2] pick item date/time

Re: [U2] SQL server to Universe via ODBC problems [AD]

2010-06-15 Thread Robert Houben
[AD]This is clearly an ad, but I think it's also clearly on topic, given some of the concerns mentioned below: I'm wishing you the best of luck solving your problems with the current tools, since you've probably invested a lot in that infrastructure, but if you can't find a way to solve you

Re: [U2] XPath queries

2010-05-21 Thread Robert Houben
] On Behalf Of Boydell, Stuart Sent: Thursday, May 20, 2010 10:48 PM To: U2 Users List Subject: Re: [U2] XPath queries Thanks Robert and Brian, As you pointed out, having a default namespace was the issue. However it took me awhile to work out that the nsMap parameter of the Locate statement can't have

Re: [U2] XPath queries

2010-05-20 Thread Robert Houben
Beware of default namespaces. If you have one defined, then XPath needs to have a namespace mapped to a dummy prefix, and you have to qualify the prefix. The following can be referenced using /x/y. xysomething... But this has a problem: x xmlns=fooysomething... Internally, XML tracks this

Re: [U2] Just testing (O.T.)

2010-05-10 Thread Robert Houben
'Twas brillig and the slythy tothes... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John J. Wahl Sent: Monday, May 10, 2010 9:04 AM To: U2 Users List Subject: Re: [U2] Just testing (O.T.) And dark too,

Re: [U2] as.java.unirpc.UniRPCException

2010-05-06 Thread Robert Houben
I don't remember the details off the top of my head, but there is a place to tell Tomcat of jars you want it to include. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shawn Hayes Sent: Thursday, May 06, 2010 9:40

<    1   2   3   4   5   >