RE: [U2] Type ahead buffer overflow

2008-02-25 Thread Robert Houben
I have had little to no success over the years in trying to convince various flavors of PICK to honor long strings passed in. The stty settings guarantee that the O/S gets the data, but does NOT guarantee that PICK can handle the long string. What has always worked for us is to insert CRs

[U2] RE: Sharepoint Pick[AD]

2008-03-05 Thread Robert Houben
We have a set of steps to import MultiValue Data into the BDC and to access it using InfoPath, and steps to link InfoPath forms into BDC lists, all using our FusionWare Direct ADO.NET Provider. Documentation from MS is not very complete, and their support has a pretty long wait-list right

RE: [U2] INCLUDE weirdo

2008-03-05 Thread Robert Houben
We had the same problem where the INCLUDE file was dropped onto a samba share from source-safe. The fix was to read each program entry in and write it out with a trailing attribute mark. This was a problem for more than includes. Once I did that, everything worked OK. It was some weird EOF

RE: [U2] blank lines in code / mixed case

2008-03-10 Thread Robert Houben
I've been listening to this with a mix of amusement and sympathy. I've been doing integration work between (originally DOS) and PICK since the early 80's, and have found myself shifting between C/C++/C#/Java/Other and PICK on a regular basis. I've come to accept that most of my customers want

RE: [U2] blank lines in code / mixed case

2008-03-10 Thread Robert Houben
: Robert Houben [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 10:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] blank lines in code / mixed case BTW, to the comment about straight guys not taking typing: I know that they didn't usually, but when I was in high school back

RE: [U2] UniData and Unicode

2008-04-03 Thread Robert Houben
Note, I've researched it in the past but not actually done it, so I may get something wrong here. This I do know, however: Unicode is not the default for Unidata. Note that some of the default MultiValue system delimiters conflict with Unicode characters. In addition to turning this on and

RE: [U2] UniData and Unicode

2008-04-03 Thread Robert Houben
What ODBC driver are you using? Is this Id Works using Unidata ODBC to retrieve data from Unidata? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Henderson Sent: Thursday, April 03, 2008 3:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]

RE: [U2] UniData and Unicode

2008-04-04 Thread Robert Houben
the ODBC driver that came on the middleware disk with Unidata 7.1. Drew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Houben Sent: Thursday, April 03, 2008 6:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData and Unicode What ODBC

RE: [U2] Keys with @AM in them...

2008-04-07 Thread Robert Houben
I believe that the problem is that the hash algorithm used to determine which group the item goes into uses the whole key as provided to it, but everything after the first attribute mark becomes part of the item, and from the point of view of the system, stops being part of the key. So a key

RE: [U2] Reading data from an SQL Server Database from Universe

2008-04-15 Thread Robert Houben
of the product, you could contact us at 1-866-266-2326, 1, 167 or send an email to sales at fusionware.net. [/AD] Robert Houben CTO FusionWare Corporation (formerly Liberty Integration Software) Original Message Subject: [U2] Reading data from an SQL Server Database from

RE: [U2] Reading data from an SQL Server Database from Universe

2008-04-15 Thread Robert Houben
Harold, The data.source in ODBC terms is usually a file that contains connection string information, or it is a connection string. On windows, you can see your data sources by running odbcad32.exe (use start, run, odbcad32.exe). The data.source, which on Unix would have to be a file, would

RE: [U2] Scientific Notation

2008-04-18 Thread Robert Houben
Actually, that gives you the wrong number (it gives you 489.00). Try this instead: OCONV(ICONV(FIELD(var,E,1),'MR4'),'MR4')*(10^FIELD(var,E,2)) Note that MR4 is for precision 4. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mecki

RE: [U2] Scientific Notation

2008-04-18 Thread Robert Houben
for a numeric character value. Enjoy! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Houben Sent: Friday, April 18, 2008 2:38 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Scientific Notation Actually, that gives you the wrong number

RE: [U2] Using ETL to extract data from UD to SQL[AD]

2008-05-08 Thread Robert Houben
We have a new product for Universe that allows you to do the equivalent of a read or write of single-valued PICK data directly to a relational table in SQL Server, Oracle, DB2, or whatever. We have customers doing this in real time on production systems, allowing them to keep their relational

RE: [U2] [UV] Scared to recompile

2008-05-08 Thread Robert Houben
The date and time of compilation are stamped into the object code. This means that you will always have a different binary and a different checksum. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 08, 2008 10:02 AM

[U2] RE: U2 - SQL Server ODBC Connection via Universe[AD]

2008-05-08 Thread Robert Houben
We have a product that uses JDBC to connect to SQL Server (various flavors - we've had to do both 2000 and 2005). It allows you to call subroutines that mimic the functionality of WRITE, READ, COPY and other commands to let you read/write single valued data to/from SQL Server, Oracle and

RE: [U2] Blink Error - Dictionary Related

2008-05-12 Thread Robert Houben
Blink is short for Backward link. Two blocks of random memory that represent a logically contiguous object that is = two blocks large will have header data that point to each other. The first will have a forward link to the second and a zero in the backward link to indicate it's the first in

RE: [U2] blink questions

2008-05-12 Thread Robert Houben
a blink error? thanks! dougc Robert Houben wrote: Blink is short for Backward link. Two blocks of random memory that represent a logically contiguous object that is = two blocks large will have header data that point to each other. The first will have a forward link to the second and a zero

RE: [U2] Creating a file in a different account

2008-05-16 Thread Robert Houben
If you copy the VOC entry, you may wish to remove the absolute path references and make it relative, otherwise, if you ever move the account, the VOC entry will break. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Friday, May 16,

Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture [AD]

2010-04-08 Thread Robert Houben
Hi Baker, There's no way to respond to this that doesn't sound like an ad, so I marked the response as an ad... We have multiple product lines and numerous customers who do various types of GUI interfaces to MV, with some great successes in the list. Most of our larger customers that do these

Re: [U2] Common Table Expressions

2010-04-08 Thread Robert Houben
I'd have to think about it a bit, but wouldn't your scenario be a good case for a BY-EXP clause? I haven't used a BY-EXP in years! :o -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday,

Re: [U2] import data to excel sheet...

2010-04-12 Thread Robert Houben
Hi Jaweed, I haven't looked too closely at your code, but I did notice on thing that I would consider the most likely candidate: CHAR(13) is a carriage return, not a line feed. Try using CHAR(10) instead for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I think

Re: [U2] import data to excel sheet...

2010-04-12 Thread Robert Houben
Always glad to help! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed Sent: Monday, April 12, 2010 9:23 AM To: 'U2 Users List' Subject: Re: [U2] import data to excel sheet... Hey Robert Houben, It worked

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Robert Houben
We have a customer who does this in large volumes, both to SQL Server and Oracle from a Universe system. They are using a product of ours called the Legacy2SQL Bridge. There are APIs for doing the equivalent of read/write from BASIC and there are bulk copy to/from routines as well.

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Robert Houben
Of Robert Houben Sent: Wednesday, April 14, 2010 12:30 PM To: U2 Users List Subject: Re: [U2] Updating SQL database from Universe 10.3 We have a customer who does this in large volumes, both to SQL Server and Oracle from a Universe system. They are using a product of ours called the Legacy2SQL Bridge

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Robert Houben
Free is definitely less expensive, but your time is probably worth something. I guess I need to blog about the bridge... :) The bridge lets you create a dynamic array of data, and pushes it into SQL Server or Oracle. You have to make the data types match, of course, but otherwise it works like

Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread Robert Houben
/EntryId/17/Easy-access-to-SQL-data-from-MV-BASIC.aspx Very easy to use, also easy to configure and setup. It's not free, though... We do like to get paid. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert

Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB

2010-04-19 Thread Robert Houben
Windows authentication cannot be forwarded to another system. For security purposes it is not possible. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, April 19, 2010 7:23 AM To: U2 Users

Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB

2010-04-19 Thread Robert Houben
Linux security. :-) Bill Robert Houben said the following on 4/19/2010 7:47 AM: Windows authentication cannot be forwarded to another system. For security purposes it is not possible. -Original Message- From

Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB

2010-04-19 Thread Robert Houben
I would try renaming the old one and copying in. That should normally be a safe test, as you can always just put it back. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, April 19, 2010

Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB

2010-04-20 Thread Robert Houben
And, are they both configured to participate in the same domain? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Whitehorn Sent: Tuesday, April 20, 2010 4:04 PM To: 'U2 Users List' Subject: Re: [U2] [ud]

Re: [U2] Viewing HTTP headers when using UniData submitRequest()

2010-04-22 Thread Robert Houben
Try something like fiddler2, or some other packet sniffer. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Graham, Dave Sent: Thursday, April 22, 2010 8:06 AM To: U2 Users List Subject: Re: [U2] Viewing HTTP headers

Re: [U2] UniODBC/UniOLEDB and Win2008?

2010-04-22 Thread Robert Houben
Hi Kevin, On Windows 64 bit, there is a 64-bit odbcad32.exe (ODBC Administrator) and a 32-bit one. You have to run the 32-bit one to see 32-bit data sources like the UniODBC driver: C:\Windowsdir odbcad32.exe /s /p Volume in drive C is Preload Volume Serial Number is BCAB-EEE5 Directory

Re: [U2] UniODBC/UniOLEDB and Win2008?

2010-04-23 Thread Robert Houben
Hi Kevin, 64 bit applications will not be able to directly access 32 bit drivers. There are some tricks for working around this, but they are NOT elegant. We're looking at what we need to do to enable our older ODBC drivers to work with 64-bit apps and we're unfortunately probably looking at

Re: [U2] UniODBC/UniOLEDB and Win2008? [ad]

2010-04-23 Thread Robert Houben
Hi Kevin, [ad] (I thought I'd be honest and put this tag in here...) We can and do connect people to U2 data. We have customers doing some very interesting things with our products. And we support not just current U2, but PI/Open, mvEnterprise, mvBase, D3, and the list goes on... Our

Re: [U2] UV JDBC SQL syntax

2010-04-23 Thread Robert Houben
Depending on what tool you are using, the dots will get you into big trouble. For most compliant SQL engines the dot has special meaning, separating qualifiers. If you don't want that to be the case, try putting double quotes around the fields that contain embedded dots in them, including the

Re: [U2] AccuTerm File Transfer

2010-04-29 Thread Robert Houben
Back in 1985/86 I helped design and develop a terminal emulator, the first one for PICK, called PK Harmony (based on the PC-Harmony Business Basic emulator family). We designed all these useful escape sequences so you could have a PICK/BASIC program run a DOS command, or drive a printer,

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

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] 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] XPath queries

2010-05-21 Thread Robert Houben
Yuck! That sounds like a bug to me. Anywhere else, the quotes would be mandatory. Always glad to help! Default namespaces have always felt like a bad compromise to me... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

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] 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] 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] 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] 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] 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] 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
You could probably just do the compile from the folder where your VOC is. I believe the basic.exe command opens the VOC and uses it to resolve the reference to the file, so the fact that it is elsewhere should work. Flying half from memory, so it might not work... -Original Message-

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
When loading a dependent dll, the loader also tries to load all statically linked dependent dlls of the dependent dll. What could be happening is that either the unioledb.dll or uniobjects.dll that you are linking to is a different version, and expects to link to a different unirpc32.dll. If

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

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] [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] 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] 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] 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] 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] 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] 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

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-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

[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] 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] 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] 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] [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] 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] 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] [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] 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] U2UG Elections 2010 - Request For Comment - The I-Beam

2011-03-22 Thread Robert Houben
Robert Houben robert.hou...@fwic.net wrote in message news:9c300472e764f645b1bab4571ac8d12601d461579...@bc-comm.fusionware.net... 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

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

[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] 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] 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] 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] 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] 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] 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] 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] 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] 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] Suggestions for flattening Multivalues... [AD]

2011-11-09 Thread Robert Houben
[AD]Hi George, Our 2SQL product allows you to map graphically, then automatically creates all the tables for multivalues and subvalues. This youtube video shows how we mapped the table: http://youtu.be/-blc5rE1_CM and this one shows how we used the mapped view to create SQL Server tables (or

Re: [U2] Extracting XML attributes

2011-11-09 Thread Robert Houben
It would look like this: /*/Data/Products/Product/@ProductId Note that the document element has a namespace attached so if you assigned the namespace-uri urn_someurl to the prefix pr you could make that: /pr:Feed/Data/Products/Product/@ProductId The '@' specifies an attribute as opposed to an

  1   2   >