RE: [U2] Mits Web

2004-11-23 Thread Ross Morrissey
Provider. If you're in the Seattle Area, the December 7th SAPUG meeting will feature MITS and there will be a number of MITS staff and customers on hand. Details at http://www.sapug.org/mtgsched.htm. Thanks, Ross Ross Morrissey MITS Product Specialist - Professional Services Management

RE: [U2] Finding last day of month

2005-06-02 Thread Ross Morrissey
Aiming for SHORT (not clean, clear, or any of that other good stuff): PRINT D: ; INPUT D PRINT D[1,6]:MOD(D[5,2]+D[5,2]7,2)+30-(D[5,2]=2)*(2-MOD(D[1,4],4)#0) D?20040203 20040229 D?20030303 20030331 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco

RE: [U2] Universe config etc.

2005-06-30 Thread Ross Morrissey
You might also find this useful: .L RELLEVEL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Thursday, June 30, 2005 9:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe CONFIG ALL -Original Message-

REMOVE - post 31 (was: RE: [U2] THE variable names)

2005-07-20 Thread Ross Morrissey
I'll jump in with a good, legitimate REMOVE usage. Most of what we hear about is something like: IF (LONG.DELIMITED.STRING[1,1] NE ) THEN LOOP REMOVE ELEMENT FROM LONG.DELIMITED.STRING SETTING MORE.DATA * Take Element-specific action WHILE

[U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort

2005-07-25 Thread Ross Morrissey
Last week, in their quarterly earnings report, Automobile Dealer Software manufacturer Reynolds Reynolds announced they were no longer selling their RGS product - a replacement of their UV based product written using .NET and SQL Server. I've seen several anecdotal accounts of failed MV to SQL

[U2] Java theme at Seattle Area Pick Users Group 9/15 meeting

2005-08-31 Thread Ross Morrissey
Lately this list seems to be a Java list :) Here's a meeting that will be of interest to current and future UniObjects for Java users in the Pacific Northwest (and anyone wishing to stay in touch with their MV community). Thanks, Ross. VP Programs - http://www.sapug.org = Java Gurus from

RE: [U2] Java theme at Seattle Area Pick Users Group 9/15 meeting

2005-08-31 Thread Ross Morrissey
There's a much bigger chance now :) I will do what I can. Thanks, Ross. -Original Message- From: Wendy Smoak Sent: Wednesday, August 31, 2005 3:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Java theme at Seattle Area Pick Users Group 9/15 meeting Any chance you'll have the

Counting (was: RE: [U2] TCL beginner)

2005-09-04 Thread Ross Morrissey
In UniVerse, I create an I-descriptor @COUNT that evaluates to 1 in a local dictionary, then copy the compiled dictionary item into the VOC *file*. This makes @COUNT available in any LIST or SORT command on *any* file. You could combine this technique with your COUNTER TCL command (or an

RE: [U2] 20 Digit Number

2005-11-21 Thread Ross Morrissey
I worked on the back end system for a film sorting robot. It read barcodes off 35mm film cartridges and I had to generate a bin number based on some complex logic. I put the logic in a subroutine, made an I-descriptor-callable shell, then wrapped it in a paragraph that allowed me to test against

Fun with Robots (was: FW: [U2] 20 Digit Number)

2005-11-22 Thread Ross Morrissey
that well. Thanks. - Original Message - From: Ross Morrissey [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 21, 2005 1:24 PM Subject: RE: [U2] 20 Digit Number I worked on the back end system for a film sorting robot. It read barcodes off 35mm film cartridges and I

RE: [U2] Anyone know how to define dict item to count lines

2005-11-22 Thread Ross Morrissey
You're probably looking for @NI Try LIST VOC EVAL @NI or create an I-descriptor with @NI on line 2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien Sent: Tuesday, November 22, 2005 11:02 AM To: u2-users@listserver.u2ug.org Subject: [U2]

[U2] SAPUG - Seattle Area Pick Users Group - U2 Meeting Thursday - Dec 8, 2005

2005-12-01 Thread Ross Morrissey
Meet fellow U2-Users members in person! Find out the latest U2 developments directly from IBM! Please join SAPUG on December 8, 2005 for our annual Holiday meeting sponsored by IBM and featuring Jackie Burhans and Bill Winter. Even if you don't use one of the U2 products, you will want to

RE: [U2] [UV] - word Document

2005-12-02 Thread Ross Morrissey
You might try saving the XXX.DOC as a new file type XXX.DOCL, then associate the .DOCL file type with word.exe run with a command line switch that referenced a macro to switch to landscape when it started. Thanks, Ross. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

[U2] DesignBais at Seattle Area Pick Users Group February 16th

2006-02-02 Thread Ross Morrissey
Please join SAPUG on Thursday, February 16th for an afternoon technical workshop and evening presentation by DesignBais. Dave Bryant, President, and Rick Weiser, Technical Manager at DesignBais International will be on hand to present the features and benefits of the DesignBais environment.

[U2] [AD] Free MITS Usability Webinar - September 6th.

2006-09-01 Thread Ross Morrissey
MITS Discover 6.0 contains significant usability improvements developed through extensive testing and prototyping with key partners and customers. In a free Webinar, Channel Solutions Architect Ross Morrissey and Senior UI Developer Sam Alston will walk through the MITS approach and discuss some

[U2] [AD] MITS Report Webinars

2006-09-13 Thread Ross Morrissey
for a free architectural overview and demonstration. This one-hour webinar will be held twice: September 19th at 11:00 AM Pacific September 20th at 8:00 AM Pacific. Details and registration at: http://www.mits.com/events.htm?u2 Ross Morrissey, CBIP Channel Solutions Architect MITS voice: 206-789

[U2] [AD] MITS Report Webinars

2006-09-14 Thread Ross Morrissey
for a free architectural overview and demonstration. This one-hour webinar will be held twice: September 19th at 11:00 AM Pacific September 20th at 8:00 AM Pacific. Details and registration at: http://www.mits.com/events.htm?u2 Ross Morrissey, CBIP Channel Solutions Architect MITS voice: 206-789

[U2] mvEnterprise to UniVerse Account Restore

2007-08-15 Thread Ross Morrissey
Has anyone had experience with account restores from mvEnterprise to UniVerse on AIX? T-LOAD of an mvE T-DUMP works, but acct.restore of an account save does not seem to. Thanks, Ross. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

Re: [U2] Binary data corruption on copy

2007-08-23 Thread Ross Morrissey
At PhotoWorks circa 2003, we had approximately 500,000,000 jpegs of various sizes sitting in Unix directories on one IBM RS6000. We got around the OS limitations by storing image 12345678a.jpg as /12/34/12345678a.jpg, and the top level directories were on 50 different filesystems as I recall.

SAPUG Meeting September 20th (was: Re: [U2] User Groups)

2007-09-13 Thread Ross Morrissey
Speaking of User Groups... If you're in the Northwest, you definitely want to attend the next SAPUG - Seattle Area Pick User Group meeting next Thursday September 20th. We're going to hear details about the most ambitious UV project I know of from Steve Ritchie of Market America: Join Steve

[U2] [AD] SAPUG mtg, Tony Gravagno - .NET - Oct 18th

2007-10-08 Thread Ross Morrissey
and programs, update relational data, and allow your MV application to provide Web Services. The goal is to help bridge the mental gaps, and clarify how to get from here to there when connecting your MV application with the world. For further details, and to RSVP, visit http://www.sapug.org today. Ross

Re: [U2] Via SystemsAD

2007-11-19 Thread Ross Morrissey
Mike left Via a while back. AD C7 Reporting is a Via Distributor - Larry Christensen's address is good and he's glad to help - [EMAIL PROTECTED] /AD On 11/19/07, Eric Armstrong [EMAIL PROTECTED] wrote: Here's a contact that we picked up at the MV conference in Long Beach. Michael Hannigan...

Re: [U2][UV] EQUATEs Using System Delmiiters

2008-10-12 Thread Ross Morrissey
If you can live with value marks instead of attribute marks, why not try something like: EQU AB TO A]B (i.e. EQU AB TO A^253B) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Odd UD SELECT Behaviour with Trailing Period

2009-01-07 Thread Ross Morrissey
The UniData SELECT occasionally seems to ignore trailing periods in keys. The following two SELECT statements return the same two records. SELECT AR WITH @ID EQ 001278310 2 records selected to list 0. SELECT AR WITH @ID EQ 001278310. 2 records selected to list 0. Is there a way to tighten

Re: [U2] Odd UD SELECT Behaviour with Trailing Period

2009-01-07 Thread Ross Morrissey
Mobile: (303) 807-6222 Email: wal...@us.ibm.com http://www.ibm.com/software/data/u2/support From: Ross Morrissey u...@rossmorrissey.com To: u2-users@listserver.u2ug.org Date: 01/07/2009 04:17 PM Subject:[U2] Odd UD SELECT Behaviour with Trailing Period

Re: [U2] Simple Export to Excel

2009-06-22 Thread Ross Morrissey
Tony Gravagno would put an AD around it, but I've had great luck with his NebulaXLite product. You populate a dynamic array, call Tony's routine, and you get an Excel 2003 XML document with whatever formatting you want. He even has a program to generate Basic code from any existing spreadsheet

Re: [U2] Simple Export to Excel

2009-07-06 Thread Ross Morrissey
ad (actually endorsement from happy user) Which is why Tony G's NebulaXlite exists. /ad On Mon, Jul 6, 2009 at 9:54 AM, Kevin King precisonl...@gmail.com wrote: On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock lar...@wcs-corp.com wrote: Or, you can create your export in the Office XML format,

[U2] Error 4 22 from PHP exec of uv on AIX

2009-07-24 Thread Ross Morrissey
This is a bit of a stumper (for me, anyway). I'm having issues trying to exec uv from PHP on AIX. Things work just fine in Windows (Apache or IIS) or Linux (Apache) so I know my PHP syntax is fine. On the AIX (5.2 uv 10.2.7) box: Using PHP, I can exec 'echo 1 + 2 | bc' and get 3 I can run this

Re: [U2] Error 4 22 from PHP exec of uv on AIX

2009-07-27 Thread Ross Morrissey
Good guess, but I *always* use the full path to executable when I'm using anything other than telnet. On Mon, Jul 27, 2009 at 7:23 AM, shaun.fergu...@ferguson.com wrote: Sorry, I'm on digest... Does the user executing this command have a profile setup with the paths to Universe? I've been

Re: [U2] Error 4 22 from PHP exec of uv on AIX

2009-07-27 Thread Ross Morrissey
Thanks Henry, this sent me down another path of exploration. I ran my PHP script from the command line (php connect.php) and it got through to uv just fine - which makes it difficult to debug further. I was able to compare user and environment variables and there are no smoking guns. If I can't

Re: [U2] Error 4 22 from PHP exec of uv on AIX

2009-07-28 Thread Ross Morrissey
Thanks Symeon, that looks very similar to what I'm doing - and what works flawlessly on Linux/Apache, Windows/Apache, and Windows/IIS!!! The darn thing just won't work on AIX. On Tue, Jul 28, 2009 at 2:07 AM, Symeon Breen syme...@gmail.com wrote: This is a snip from my php handler for a

Re: [U2] Using PHP

2009-07-29 Thread Ross Morrissey
I have three reasons to use PHP as a CGI Bridge - Sessions, Cookies, and Query Parsing. These are things PHP is good at. In the past I would have added that it ran on a host of platforms, like UniVerse, but I'm having issues on AIX these days. I've also PHP in the past as a command-line tool to

Re: [U2] the XML/DB Tool

2009-07-30 Thread Ross Morrissey
Hardcoding and Handcoding are subtly different. On Thu, Jul 30, 2009 at 12:59 AM, Symeon Breen syme...@gmail.com wrote: Just one point - where you say hard code - I am not entirely in agreement - my xml handling code is generic for all the xml file i suck into u2, the EXT file is different

Re: [U2] Performance query

2009-09-02 Thread Ross Morrissey
If this is UV, try the two sentences with the EXPLAIN qualifier appended... SSELECT MYFILE WITH FIELD1 = RED AND FIELD2 = BLUE EXPLAIN This will tell you the strategy UV is using for the query. Thanks, Ross. On Wed, Sep 2, 2009 at 12:42 AM, Jef Lee jef@itvision.com.au wrote: Can anyone

Re: [U2] Indexing

2009-09-15 Thread Ross Morrissey
It's not IBM technical documentation, but several years ago I published a number of push the envelope techniques for UniVerse Secondary Indexes in an article for the OSDA Newsletter. The prose is dated, but the techniques aren't. It's at: http://www.rossmorrissey.com/uv/rossmorrissey_indexes.pdf

[U2] U2 is now Rocket U2

2009-09-30 Thread Ross Morrissey
http://www.rocketsoftware.com/u2/ is up, with trial version requests, certification, U2U, and a letter to the U2 Community A number of questions over the past couple of weeks appear to have been answered. ___ U2-Users mailing list

[U2] Better and Better Triage Gurus Needed

2010-08-19 Thread Ross Morrissey
The U2UG Better and Better Committee receives enhancement requests from the U2 community and attempts to triage them - discarding some because equivalent (occasionally obscure) functionality exists, augmenting some by working with the submitter to clarify and develop a compelling business case,

Re: [U2] Building an Excel File [AD]

2012-02-09 Thread Ross Morrissey
Sorry to come in a bit late here. I have worked through a couple of versions of NebulaXLite and must say I am very impressed, with both the astounding results and the thoughtful improvements Tony has made to this breakthrough tool. If you have a requirement to clone an existing spreadsheet, but