RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R...

2005-06-17 Thread Bill Haskett
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, June 16, 2005 11:57 AM To:

Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...

2005-06-17 Thread Clifton Oliver
I came here for a flogging. No you didn't. Couldn't resist. Sorry. Serious reply to follow. -- Regards, Clif On Jun 16, 2005, at 12:31 PM, Bill Haskett wrote: However, it's always possible I could use a good flogging. :-) --- u2-users mailing list u2-users@listserver.u2ug.org To

RE: [U2] [List] Long Subject Lines

2005-06-17 Thread Tony Gravagno
Outlook users rejoice! :) I've been maintaining a small set of Outlook macros that fix subject mods made by Google, anti-spam programs, and various e-mail clients. These are available for free here: http://nebula-rnd.com/freeware/ Please read the README.txt to see what the files are. The file

Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...

2005-06-17 Thread Clifton Oliver
Yes, that was the point. A record counter contains no information about the record; it is an arbitrary pointer to the information. Our U2 (and other MV) databases do not provide for a key that is, to use some SQL implementation terms, AUTO_INCREMENT or INTEGER GENERATED AS IDENTITY. So we fake

[U2] IBM Ascential

2005-06-17 Thread phil walker
Ray, you should change the heading;-) Yes, who would ever have thought that the company which originally developed UV would be worth 2,100,000,000 USD. Vmark merged (tookover Unidata) to become Ardent. Ardent bought Prism (I think). Informix tookover Ardent (At least that is what they

Re: [U2] IBM Ascential

2005-06-17 Thread Ray Wurlod
What about the 800,000,000 that Informix handed over for Ardent? Now the total is 2,900,000,000 (woo hoo!). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] TRANS vs T-correlative: caching last record

2005-06-17 Thread Martin Phillips
Would you be willing to tackle any of these other questions? : - Is T-correlative smart enough to do the same caching as TRANS()? - The caching is only 1 record 1 file deep, just one single filerecord combo gets cached, right? - Does T-correlative use the same underlying code as

Re: [U2] Conversion Code - M

2005-06-17 Thread CWNoah2
Bill, Might I suggest that M be renamed to something a little more meaningful? Oh, and a flogging for the person who named it M to begin with? ;^) Actually, when I find these format variables, I replace them with the format literal. I know, it might make it a little harder to expand its

[U2] IBM ODBC vs Ardent ODBC driver

2005-06-17 Thread Peter Ivanick
Hola all - We've got a DTS in MS SQL Server 7 which pulls all 200k+ records out of a table from UniVerse 9.6 through the Ardent driver, weekly, to put it into a SQL Server table for easier access from some of our web apps. Works great, it's a relatively simple select of 8 fields. Same DTS

[U2] COMPARE function bug?

2005-06-17 Thread u2
Or am I being stupid? But it's breaking my sort routines and causing strange results. UV 9.6 on Windows. Try running the following program: PRINT COMPARE( 'Beijing', 'Beijing Shanghai', 'L') PRINT COMPARE( 'Beijing', 'Nanking', 'L') RETURN

Re: [U2] IBM ODBC vs Ardent ODBC driver

2005-06-17 Thread Don Kibbey
I gave up on the ODBC stuff a while back. I now build my SQL tables by producing text files on the HP/UniVerse machine and then launching a DTS job with an ftp module that pulls the data down to the SQL server and imports it that way. Much less twidling with drivers this way. --- u2-users

RE: [U2] IBM ODBC vs Ardent ODBC driver

2005-06-17 Thread David Jordan
The new IBM ODBC driver is a lot faster than the old Ardent driver. The problem may be that it is too fast for the SQL Server to handle and this is causing a buffer overflow. There are parameters within ODBC to change buffers and slow the transfer of records. Have you considered upgrading to

RE: [U2] Conversion Code - M

2005-06-17 Thread Brutzman, Bill
Yes... I make a living by doing code makeovers... --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, June 17, 2005 6:04 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Conversion Code - M Bill, Might I suggest

RE: [U2] IBM ODBC vs Ardent ODBC driver

2005-06-17 Thread Bob Witney
We are using the OpenLink ODBC software on a ibm 6c3 running aix 5.3 and universe 10.1 Both the drivers and the Basic SQL Client Interface are working fine here both into and out of MS SQL Server 2000 P'raps we are not being clever enough to break them :-) Bob -Original Message-

RE: [U2] IBM ODBC vs Ardent ODBC driver

2005-06-17 Thread Marc Harbeson
A vb.net program with UO.NET and SQL drivers can work this task also... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Friday, June 17, 2005 8:17 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] IBM ODBC vs Ardent ODBC driver I

RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...

2005-06-17 Thread Stevenson, Charles
Fine by me, but get your own thread; this one's taken. (Or at least add another sentence to the subject line.) From: Clifton Oliver ...Control numbers, on the other hand, are a completely different issue Anyone want to discuss why most MultiValue systems don't know the concept of

RE: [U2] Pdf Software Upgrade

2005-06-17 Thread Paul Trebbien
For our 'Kourier Publisher' package we use PCL2PDF from Visual Software (over in the UK) to convert documents from our U2 to the PDF format for Archiving and/or Emailing. They offer an 'Evaluation' copy of their software on their website - visual.co.uk. Cheers, Paul Trebbien Kore

RE: [U2] Using httpout / UV based webserver / images?

2005-06-17 Thread George Gallen
I'll have to generalize them firstI'll see what I can do next week. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 16, 2005 7:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using httpout / UV

Re: [U2] COMPARE function bug?

2005-06-17 Thread Jerry Banker
You're right. If you do an 'R' compare it comes out correctly. Which to me means that the compare function is not truly doing a left to right comparison. Try doing the following: PRINT COMPARE( 'Beijing', 'Beijing Shanghai', 'L') PRINT COMPARE( 'Beijing', 'Nanking', 'L')

RE: [U2] Using httpout / UV based webserver / images?

2005-06-17 Thread George Gallen
One downside to this, is that you need to know HTML and javascripting. Basically, the output are UV programs that produce HTML coding. There is no automation with these programs/routines. And the output HTML is not cross browser compatible, unless that's the HTML output you provide. But...It

RE: [U2] COMPARE function bug?

2005-06-17 Thread Glenn Herbert
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

RE: [U2] Using httpout / UV based webserver / images?

2005-06-17 Thread Raymond DeGennaro II
At 11:25 -0400 2005/06/17, George Gallen wrote: And the output HTML is not cross browser compatible, unless that's the HTML output you provide. One little nit-pick here. HTML/XHTML is a standard and is browser-neutral. I think what you technically mean is that there will be no Netscape or

RE: [U2] COMPARE function bug?

2005-06-17 Thread Glenn Herbert
I will try this once again... if it doesn't work then I don't know how to get Notes to send to the list and I guess I will have to not post. Yes, this is a bug in the low level function qcomp(). I fixed this within the DataStage Engine code back in 2002 (after version 9.6 of universe).

[U2] [UD] In-Line Prompting - UniData 5.1.7

2005-06-17 Thread Hruby, Paul
Greetings, I am trying to utilize In-Line Prompting with conversion code MCU using the following syntax, without much luck. 001: PA 002: SELECT ITEM.FILE WITH SCANNED EQ R,Scan Barcode,(MCU) 003: LIST ITEM.FILE SCANNED REQUIRE.SELECT The manual states: [options,]prompt_text[,check | (conv)]

Re: [U2] Using httpout / UV based webserver / images?

2005-06-17 Thread FFT2001
In a message dated 6/17/05 8:42:00 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: George, do you, or would you be willing to, have your code up on the pickwiki ? Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UD] In-Line Prompting - UniData 5.1.7

2005-06-17 Thread Martin Phillips
I am trying to utilize In-Line Prompting with conversion code MCU using the following syntax, without much luck. 001: PA 002: SELECT ITEM.FILE WITH SCANNED EQ R,Scan Barcode,(MCU) 003: LIST ITEM.FILE SCANNED REQUIRE.SELECT ...snip... The conversion code element of an inline prompt checks

RE: [U2] Using httpout / UV based webserver / images?

2005-06-17 Thread Ian McGowan
From [EMAIL PROTECTED] George, do you, or would you be willing to, have your code up on the pickwiki ? Not to discourage anyone from posting on pickwiki, but Glen's new site http://mvdevcentral.com/ has much better support for code submissions - the wiki format doesn't really lend itself

RE: [U2] [UD] In-Line Prompting - UniData 5.1.7

2005-06-17 Thread Janke, Mark
The following is true in UniVerse. I don't know whether UniData works the same, but it would be worth investigating. If the dictionary entry for SCANNED has MCU as the conversion specification (field 3 in a UV 'D' or 'I' type), then you could do SELECT ITEM.FILE WITH SCANNED EQ R,Scan Barcode

Re: [U2] IBM ODBC vs Ardent ODBC driver

2005-06-17 Thread Peter D. Ivanick
Bob Witney wrote: P'raps we are not being clever enough to break them :-) If only our problem was that we were too clever... Seemingly, although we've been at a retreat all day haven't fully tested this out, it's actually a matter of some bad data -- we fixed a lot of fields so that

[U2] OCONV of no affect.

2005-06-17 Thread Mark Johnson
Is there an OCONV method that does nothing, ie IF X=OCONV(X,CONV) THEN TRUE. I've had a situation where I could use this before and one crept up today. No biggie. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/