RE: [U2] Mits Web
If you have a MITS Hypercube built against an ORDER file, and you split the ORDER file into ORDER1, ORDER2, and ORDER3 - you will require 3 Hypercubes. MITS can access any UniData account. UniData is one of the more popular MITS platforms. You can get more help with MITS from your MITS Support 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 Information Tools, Inc. -- Date: Tue, 23 Nov 2004 17:02:03 - From: Nick Liebmann [EMAIL PROTECTED] Subject: [U2] Mits Web Wondering if this usergroup could help. We run Mitsweb on our unidata database. We are going through a process of database separation ( due to stability ). So essentially we are splitting the main database into 3 different databases. Can a Mits account access all 3 databases? Has anyone had experience with using Mits with Unidata? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Finding last day of month
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 Manyevere Sent: Thursday, June 02, 2005 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Finding last day of month Given a date like 20040203, I want to return the last valid date for that month and year (20040229 in this case). What is the shortest code fragment to achieve this? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe config etc.
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- From: Anthony Caufield [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe What is the TCL command for showing current Universe config. I cant seem to recall I don't do it all the time. Thanks in advance. Tony --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
REMOVE - post 31 (was: RE: [U2] THE variable names)
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 MORE.DATA DO REPEAT END However, I've had a couple of situations where I was parsing a string with multiple levels of delimiter where nested loops would have been ugly. This is cleaner and clearer: IF (ODDLY.DELIMITED.STRING[1,1] NE ) THEN LOOP REMOVE ELEMENT FROM ODDLY.DELIMITED.STRING SETTING DELIM * Take Delimiter-specific action BEGIN CASE CASE (DELIM EQ 2) ;* AM-Specific Code CASE (DELIM EQ 3) ;* VM-Specific Code END CASE WHILE DELIM DO REPEAT END That being said, I'm glad we have REMOVE available for both uses. Thanks, Ross. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 8:28 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] THE variable names ... I have yet to hear of a good, legitimate, use for REMOVE. Even after 30 or so posts on this topic ;) Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort
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 projects, but this has some firm numbers attached. After almost 2 years, less than 1 percent of their customer base switched over to the new system, and they wrote off the development effort for $67 million dollars. RR Earnings report: http://biz.yahoo.com/prnews/050721/clth018.html?.v=16 The company announced the discontinuance of the Reynolds Generations Series Suite DMS software product, installed in over 70 dealership locations since its introduction in September 2003. As a result, in its fourth fiscal quarter ending September 30, 2005, the company will write off about $67 million of capitalized software development. The company is currently evaluating any other potential impacts of this decision and may recognize additional costs in the fourth fiscal quarter. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Java theme at Seattle Area Pick Users Group 9/15 meeting
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 two of Seattle's largest Multivalue shops will talk about the how and why of Java/Multivalue integration. Speakers: Richard Nuckolls - Sr. Technical Analyst - Lynden Inc. . Prior to taking up Java, Rick had coded in Fortran, C, and Pick Basic (Prime Information and Universe) for more than 20 years. . He was originally attracted to object-oriented programming in the 1990's by Smalltalk as well as the works of Bertrand Meyer. By the time that Ardent introduced UniObjects for Java in 1999-2000, Rick had taught himself the language and taken several classes. . Rick was responsible for much of the design and coding of the class libraries used by Lynden for access to Universe through U2 as Java classes. Shawn Dodd - Sr. Developer - Management Information Tools, Inc. . Shawn is a server-side enterprise web application developer. He's been working in Java/J2EE and C++/COM since 1996. Shawn has developed portable web applications for MITI for almost two years now. The Seattle Area Pick Users Group still meets at the... Place that was Small Doubletree Inn, before that was Small Red Lion, etc. Then it was the Ramada Inn and now it is the Paragon but still at 818 112th Ave NE, Bellevue. Networking begins at 5:30 pm and lasts till 6:30 pm, followed by a Buffet Dinner. The meeting costs $30.00 if you register in advance ($35.00 if you just show up). 3:00 - 5:00: Multivalue/Java Tactics Why Java? Why keep your business logic in MultiValue? How do you make it available to Java? Getting loose integration between Java and MV is easy: launch a TCL shell process or open a Telnet connection. But to build robust applications, you'll need tighter integration. Proprietary RPC protocols like UOJ help tighten up the communication channel and XML helps add structure to requests and responses. 5:30 - 6:45: Networking 6:45 - 8:00: Dinner 8:00 - 9:00: Multivalue/Java Strategy Why consider Java? Business reasons to adopt Java in a Multivalue environment from both the end-user and reseller perspectives. Java is widely adopted in the enterprise, so you've got a plethora of tools, technology, and processes to choose from. And Java has become very popular in the Open Source world, so you don't have to spend a lot to benefit. MVDBs work on several operating systems, why shouldn't the rest of your technology stack? Note the date and times and RSVP today to Connie Eaton mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] or call her at: (206) 298-0278 (can leave voice mail) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Java theme at Seattle Area Pick Users Group 9/15 meeting
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 presentation slides available after the meeting? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Counting (was: RE: [U2] TCL beginner)
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 equivalent Paragraph) and it would work on any file. This works for Virtual Fields in UniData too (where EVAL 1 doesn't always work). Thanks, Ross -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, September 02, 2005 8:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TCL beginner I use a TCL command that I created called COUNTER. It requires the dict item in the file called COUNTER that represents the value 1. At tcl type COUNTER CUSTOMER STATE The proc goes like this: PQN HSORT A2 H BY A3 H BREAK-ON A3 H TOTAL COUNTER DET-SUPP P I use this quite extensively for this exact purpose. It will also work with an active list. It's pretty revealing. My 2 cents. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 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 tens of thousands of historical transactions to give any code changes a real workout. No barcodes typed, and as a bonus, the logic was easily re-deployed to a manual interface later on. Thanks, Ross. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Saturday, November 19, 2005 9:14 PM To: u2-users@listserver.u2ug.org Subject: [U2] 20 Digit Number General Question. A client has just taken on a new major customer and we have to keep track of their product codes. These codes are 20 numbers long with no real prefixing, suffixing or patterns. Is there any way to abbreviate numbers. I know this is a weird question but I know that I may be entering these codes manually during the testing and/or installation phase of this project and 20 numbers is a lot of typing. I've run out of ideas that simplify as most tend to complicate matters. The users will eventually be using bar code, scanning off of printed documents. As I develop, I will not have that benefit. I can calculator-enter numbers pretty effeciently given my accounting background. But 20 digits is a lot. I'm open to any ideas even if to know there are none. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Fun with Robots (was: FW: [U2] 20 Digit Number)
I'm not sure what you mean - there was no encryption in this app. Data entry applied barcodes to film canisters. The film sorting robot read the barcode and passed it (through DEVICE - what fun) to a routine that looked up order characteristics (e.g. 2 sets of 4x6 prints, slides, CD, express shipping) and calculated a bin number and returned the bin value to the robot. If the robot didn't hear back in less than .05 seconds, it defaulted to an error bin. The robot then dropped the roll into the target bin (actually it spun a J-shaped tube on a carousel the size of a Volkswagen and blasted the film down the tailpipe with a burst of compressed air). Testing this was similar to your issue of typing in long barcodes. I needed to type in thousands of barcodes and validate the results against (table driven) business logic changes - i.e. sort express and retail together. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, November 20, 2005 8:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] 20 Digit Number So what was the secret and was it human-able. I can code anything. I can't encrypt in my head 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 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 tens of thousands of historical transactions to give any code changes a real workout. No barcodes typed, and as a bonus, the logic was easily re-deployed to a manual interface later on. Thanks, Ross. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Saturday, November 19, 2005 9:14 PM To: u2-users@listserver.u2ug.org Subject: [U2] 20 Digit Number General Question. A client has just taken on a new major customer and we have to keep track of their product codes. These codes are 20 numbers long with no real prefixing, suffixing or patterns. Is there any way to abbreviate numbers. I know this is a weird question but I know that I may be entering these codes manually during the testing and/or installation phase of this project and 20 numbers is a lot of typing... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Anyone know how to define dict item to count lines
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] Anyone know how to define dict item to count lines Good Day! For the life of me I cannot remember how nor can I find how to define a dict item to print a line count on an Info/Access statement. On the old PICK O/S we create a dict item and do something with NV (value counter) and our report would have the lines numbered as it goes down the page. Anyway, I'm pretty sure I've seen it in one of the UniData or UniVerse Guides but cannot locate it. I really appreciate your help! Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] SAPUG - Seattle Area Pick Users Group - U2 Meeting Thursday - Dec 8, 2005
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 hear what this major MulitValue player is doing. Don't forget, this is our Holiday meeting, so in addition to the IBM sponsorship of the networking hour, we will have prizes! For those who might want to stay over Thursday night, the hotel is offering a special rate of $69.00 per night. If you're interested in that option, call the Hotel event manager, John Wessel at (425) 450-4712 and tell him you'd like the SAPUG rate. The Seattle Area Pick Users Group still meets at the... Place that was Small Doubletree Inn, before that was Small Red Lion, etc. Then it was the Ramada Inn and now it is the Paragon but still at 818 112th Ave NE, Bellevue. The meeting costs $30.00 if you register in advance ($35.00 if you just show up). If you come to any part of the meeting, you need to pay since we will be charged whether you eat dinner or not. 3:00 - 5:00: Universe/UniData Integration with other IBM Technologies Bill Winter will conduct the afternoon session on Universe/UniData integration with other IBM technologies such as WebSphere. Bill Winter is a senior IT Specialist focused on the IBM U2 databases and tools. 5:30 - 6:45: Networking 6:45 - 8:00: Dinner 8:00 - 9:00: IBM/U2 Update by Jackie Burhans If you have already responded, Thank you... Otherwise, note the date and times and RSVP today to Connie Eaton [EMAIL PROTECTED] or call her at: (206) 298-0278 (can leave voice mail) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] - word Document
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] On Behalf Of Bjorn Behr Sent: Friday, December 02, 2005 3:52 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] - word Document We generate a 'text/word' document from Universe. What I would like to know is does anybody know what characters I need to place in the document so that when it is opened up in Word, it is in landscape format? Many Thanks Bjorn Behr Programmer (TSD) Tel : +27 11 523 4202 Email : [EMAIL PROTECTED] Web Site: www.supergrp.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] DesignBais at Seattle Area Pick Users Group February 16th
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. In the afternoon, Rick will provide a technical overview of the features of DesignBais, a functionally rich toolset that enables MultiValue developers to design and create enterprise wide web-based applications. DesignBais makes MultiValue developers into web developers without needing to know technologies such as Java, HTML, or ASP required. After dinner, Dave will cover news about the company and its future plans for features and functionality. The Seattle Area Pick Users Group meets at the Paragon (formally Ramada Inn, formally the small Doubletree Inn, formally the small Red Lion, etc.) and it is still at 818 112th Ave NE, Bellevue. The meeting costs $30.00 if you register in advance ($35.00 if you just show up). If you come to any part of the meeting, you need to pay since we will be charged whether you eat dinner or not. 3:00 - 5:00: DesignBais technical overview. 5:30 - 6:45: Networking 6:45 - 8:00: Dinner 8:00 - 9:00: DesignBais presentation by Dave Bryant Note the date and times and RSVP today to William Timbrook at williamt@(removethisstuff)gmname(removethistoo)plate.com or call at: (206) 436-6965 (can leave voice mail) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [AD] Free MITS Usability Webinar - September 6th.
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 of the tools and techniques used on this Project - information that is valuable to anyone considering updating their user interface for the Web. Details and registration at: http://www.mits.com/reg-mitsdiscover-webinar.htm?u2 Join us to find out why affordances are obvious choices! Ross Morrissey, CBIP Channel Solutions Architect MITS voice: 206-789-8313 email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [AD] MITS Report Webinars
Webinar: Announcing MITS Report, the Revolutionary New Operational Reporting Environment from MITS. Based on freedback from partners and customers for our MITS Discover analytical reporting product, we've taken a unique approach to operational reporting against MultiValue databases. Join us 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-8313 email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [AD] MITS Report Webinars
Webinar: Announcing MITS Report, the Revolutionary New Operational Reporting Environment from MITS. Based on freedback from partners and customers for our MITS Discover analytical reporting product, we've taken a unique approach to operational reporting against MultiValue databases. Join us 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-8313 email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] mvEnterprise to UniVerse Account Restore
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 http://listserver.u2ug.org/
Re: [U2] Binary data corruption on copy
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. All the image metadata was stored in UniVerse on a separate server. The only software running on the image server was Apache and a couple of shell scripts (and the embedded Tivoli HSM software - yes all the images were backed up off site). I understand PhotoWorks has moved off their IBM archive in the last few years. On 8/23/07, Martin Phillips [EMAIL PROTECTED] wrote: Hi Harold, The simplest solution - that of simply copying the JPG files to one type 19 directory - is working, to my amazement. There are 171,000 mugshots in one directory and they are being handled correctly. Remember that the process of searching an operating system directory is essentially a linear scan. This will need to examine, on average, half the entries before finding the one you want when reading. A write may have to scan the whole directory. There probably isn't much you can do about this aside from moving to a hashed file which might be a tuning nightmare. Also, if this is Unix, each file takes an inode so you need to keep an eye on the file system limits. Martin Phillips, Ladybridge Systems Ltd --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
SAPUG Meeting September 20th (was: Re: [U2] User Groups)
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 Ritchie, VP of R/D and founding member of Market America to hear about how Universe is being in numerous unique ways to run their company as well as their growth financially and the steady buildup of their IT department. Steve will talk about challenges with rolling out a truly massive UniVerse project and about how the power of UniVerse has helped propel Market America to a billion dollar company in 5 countries. This is the project that elicited gasps at the U2UG Meeting at last year's Cincinnati Spectrum show. Our afternoon session will feature a technology preview from MITS looking at some of the technology underlying the advanced features in the next releases of MITS Discover and MITS Report. Special thanks to MITS for making their expertise available and underwriting this meeting. For details, see http://www.sapug.org and make sure to RSVP soon. Thanks, Ross VP Events - SAPUG --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [AD] SAPUG mtg, Tony Gravagno - .NET - Oct 18th
Please join the Seattle Area Pick Users Group next Thursday, Oct 18th as we welcome prolific U2-Users contributor Tony Gravagno for afternoon and evening sessions. Tony Gravagno has been in the Pick market for over 25 years. In 1995 he joined Pick Systems where he served as Support Technician, QA Manager, Corporate Technical Account Manager, and finally as DBMS Product Manager for Raining Data. In 2001 Tony started Nebula Research and Development to focus on providing unique services and products for all Pick/MV platforms, allowing VARs to sell more software and end-users to get the most from their IT investment. Today Nebula RD has partnerships and distribution agreements with companies and individuals around the world. Tony has collaborated on published books and magazine articles related to .NET, and has authored many articles for the MV market on a variety of topics. He comes to us as a community pundit - always thought provoking, often controversial - with information and insight for all IT and management levels. Afternoon: The Afternoon session will be on the .NET Framework: what it is and is not, who can use it, alternatives to .NET, where it fits with *nix, and how all of this applies to MV. This is intended for decision makers looking for strategic direction, IT staff who want to know what this means for them, and vendors who want to know what they should be recommending to their clients. This presentation should lead you to that final Oh, I get it! Evening: Following up on the afternoon session, the evening session is intended for those now considering solutions which make use of .NET. This discussion will profile mv.NET as a valuable tool for a variety of applications. Details include a brief look at code to access MV structures 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 Morrissey, VP Events, SAPUG ** Have an MV story to tell in Seattle? Email [EMAIL PROTECTED] ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Via SystemsAD
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... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] EQUATEs Using System Delmiiters
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
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 the environment up so that the same SELECT statements each return just one record? Note that I'm not looking for SELECT AR 001278310 More info: ECLTYPE 2 U_PSTYLEECL ON Top of @ID in DICT AR, 7 lines, 16 characters. 001: D 002: 0 003: 004: AR 005: 20L 006: S 007: Thanks, Ross. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Odd UD SELECT Behaviour with Trailing Period
That did it. Thanks Wally. On Wed, Jan 7, 2009 at 3:22 PM, Wally Terhune wal...@us.ibm.com wrote: UDT.OPTIONS 22 ON might help. Read about it in the UDT.OPTIONS manual.. Wally Terhune U2 Support Architect IBM Information Management Software Tel: (303) 773-7969 T/L 656-7969 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 Sent by:owner-u2-us...@listserver.u2ug.org 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 the environment up so that the same SELECT statements each return just one record? Note that I'm not looking for SELECT AR 001278310 More info: ECLTYPE 2 U_PSTYLEECL ON Top of @ID in DICT AR, 7 lines, 16 characters. 001: D 002: 0 003: 004: AR 005: 20L 006: S 007: Thanks, Ross. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Simple Export to Excel
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 to get you started. On Mon, Jun 22, 2009 at 7:29 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: That would not work. We use double and single quotes in descriptions for describing lengths. For example, we might sell something whose dimensions are: 2x3x10' Even so, your info was helpful if I know my data will not have double quotes. Anyone else have an idea? John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Monday, June 22, 2009 10:25 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel Dunno, how about converting double quotes in the data to single quotes? Or stripping them out entirely? Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 22 June 2009 15:22 To: 'U2 Users List' Subject: Re: [U2] Simple Export to Excel Cool. Here is the next wrinkle. What if my UniData data has (or may have) quotes in it? Am I out of luck or is there some alternate way to get the same result? Is there something like in other languages that you could convert double quotes in the raw data to /q or whatever, and Excel would know how to handle this? John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Monday, June 22, 2009 9:58 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel Yes, if you quote-delimit all your fields then it's possible to pass @VMs as line feeds, and it will do what you want. Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 22 June 2009 14:56 To: 'U2 Users List' Subject: [U2] Simple Export to Excel We have lots of programs that export our data from UniData to tab-delimited text files. Some of these are opened by Excel (which has its faults), some are imported into other databases. These files will be 1) E-mailed as attachments or written to specific location on the network. If I know that the users will always use Excel to open the attachment, I usually make the file extension xls so that it simply fires up Excel when double-clicked and parses everything out reasonably cleanly (but still drops leading zeros, converts big numbers to scientific notation, etc). We are using UniData on HP-Unix. Is there a good way to convert @VMs to something that Excel will correctly convert to what would be equivalent to the Alt+Enter in Excel? I do not want the data on multiple rows - I want multiple lines with breaks within a single row/cell. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney,
Re: [U2] Simple Export to Excel
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, and tell excel explicitly what to do with each column of data. Absolutely. But what a time-consuming chore that can be... :-) -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Error 4 22 from PHP exec of uv on AIX
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 at the shell as user nobody: 'cd /u2/uv/HS.SALES; /u2/uv/bin/uv display 42' I can get a CGI script to return 'cd /u2/uv/HS.SALES; /u2/uv/bin/uv display 42' correctly With PHP, I can't exec ' /u2/uv/bin/uv display 42' (after a chdir). UV throws this error (into the Apache logs): An error has occurred during uniVerse initialization Please contact the system administrator Error code: 4 22 The codes translate into: 4. System V semaphores are probably not configured in the kernel. 22. (EINVAL) Invalid argument. Here are some examples of invalid arguments: dismounting a nonmounted device, mentioning an unknown signal in signal, reading or writing a file for which seek has generated a negative pointer. EINVAL is also set by math functions. Has anyone else bumped into this? IBM support suggested it might be an issue with SIGTTOU but this seems unlikely to me - especially for a one-line command. PHP is a bit outside their bailiwick. Thanks, Ross. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error 4 22 from PHP exec of uv on AIX
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 working in UniData so it may be different, but the user has to have their environment setup to the correct paths to UniData bin, etc (UDTBIN = /blablabla/ud/bin). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error 4 22 from PHP exec of uv on AIX
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 get this working using PHP as an Apache module, maybe I'll hook it up via CGI. Thanks again U2-Users! On Fri, Jul 24, 2009 at 6:54 PM, Henry Unger hun...@hitech.com wrote: Permissions, perhaps? Running it using syscalls might provide some clues. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error 4 22 from PHP exec of uv on AIX
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 unidata program
$udtCmd=LANG=en_US.UTF-8;export LANG; cd
/usr/ud/accounts/$account;/usr/ud71/bin/udt RUN $BP flyGen $noads $style
$uid $keywords -G;
$result = array();
$i=1;
$done=0;
$time_start = microtime(true);
exec( $udtCmd, $result);
$time_end = microtime(true);
foreach ( $result as $v )
{
Notice i do set an env var in the same command as the udt command and i put
the full path in as well. This works fine.
Rgds
Symeon.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using PHP
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 generate pages with the Smarty template engine, invoking it from UniVerse (see: http://www.rossmorrissey.com/uv/beyonded.htm slide 30...). Thanks, Ross. On Wed, Jul 29, 2009 at 6:54 AM, Brutzman, Bill bi...@hkmetalcraft.comwrote: While it makes sense to me to consider using PHP as middleWare to do SQL things... What are the advantages of using PHP with U2 rather than UniObjects for Java or .Net? Insights would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] the XML/DB Tool
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 for each xml file - it is in a way an addendum to the xsd and allows you to only import parts of the xml. If this is what you call hardcoding then i disagree it is a configuration. If however you are hardcoding your databasic for each xml file then yes that is hardcoding and i agree you should not do it that way ! Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Performance query
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 shed light on which is better: SSELECT MYFILE WITH FIELD1 = RED AND FIELD2 = BLUE or SSELECT MYFILE WITH FIELD1 = RED AND WITH FIELD2 = BLUE Does it make a difference if one or both are indexed. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
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 On Wed, Sep 9, 2009 at 2:24 PM, Bessel, Karen karen.bes...@tylertech.comwrote: I am not a UV newbie by any means, but I've never used indexing, and I need to know where to start, with reading to gain some knowledge on the documentation. Any particular area of the IBM technical documentation that might be particularly helpful to this noob to the wide world of indexing? Thanks! Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3780 Email: karen.bes...@tylertech.com Web: http://www.tylertech.com Tyler is proud to be the Platinum Sponsor of The Court Technology Conference 2009 Sept. 22-24, 2009 | Denver, CO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 is now Rocket U2
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-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Better and Better Triage Gurus Needed
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, and forwarding some gems directly to Rocket. The problem we have today is that some of the requests are real edge cases dealing with interaction with other technologies and development environments. If you're a guru's guru and think you can be the alpha geek on some compelling conference calls, please swagger forward (i.e. email me at u...@rossmorrissey.com). Curious about Better and Better? Log in to http://www.u2ug.org to learn more. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building an Excel File [AD]
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 with data from U2, you need to get this tool. It will pay for itself day one and spare you a lot of grunt work. On Mon, Feb 6, 2012 at 2:56 PM, Tony Gravagno 3xk547...@sneakemail.comwrote: [AD] NebulaXLite creates rich XML workbooks (multiple sheets) which can be opened by Google Docs and Open Office, in addition of course to Excel. The XML isn't Excel-specific, it conforms to open standards, and Excel happens to open those files as well. remove.pleaseNebula-RnD.com/products/xlite.htm When I got my Android, I didn't look for Excel for Android, I just viewed docs as Google spreadsheets. Your BlackBerry and iPhone users would probably do well to do the same. NebulaXLite is free for all developers and only a one-time $200 purchase price for end-users with completely free support. Many people here use NebulaXLite over Universe and Unidata, and I hope a few of our clients will comment on their experience. Some months ago I also announced NebulaXPlus which exports XLite documents to a local Windows box to convert to a real Excel ..xls file. This allows even more complex documents to be created - yes, without user intervention. NebulaXPlus is now in beta. Thanks for you time. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno NEW! http://groups.google.com/group/mvdbms/about From: Israel, John R. We are running UniData on a UNIX platform. We create tab-delimited txt files (and tab delimited txt files with xls extensions) all the time that users open with Excel. Many of these jobs are run in the middle of the night or in a trigger program. In all cases, there is no direct user interaction building these files. We also have some XML files that are coded so that Excel opens them with formatting, colors, filters, etc. Unfortunately, our BB users and iPhone users can not open these files up in a meaningful way. Is there a way to build a TRUE Excel file without any user intervention from UniData or UNIX? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
