[U2] @VM in data from INPUT statement

2005-03-15 Thread Phil Walker
Hi, I have a barcode I am trying to decipher which when scanned returns a char(253) as part of the input variable. INPUT ABC ;* Scan barcode PRINT ABC ;* 1940^253 Obviously the barcode could contain a char(253), equivalent to our @VM, but as I said I seem to remember someone saying

Re: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Don Kibbey
I've found the best way for me to do what you are describing is to use UniObjects .Net to create a recordset from the UniData/UniVerse machine and then pass that recordset into a Crystal Report. Probably not what you want to hear, but it is a method to stitch together your current programs with

RE: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Alfke, Colin
Sorry, I haven't played much with our Crystal reports, but I think we had a similar problem. However, we didn't have the large library of paragraphs that we felt compelled to re-use. I didn't think it was all that slow. We did figure out how to do some neat things with Crystal though. What

[no subject]

2005-03-15 Thread Wong, Howard
To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a

[U2] Re: migration of old UV application on old Unix Server being replaced

2005-03-15 Thread Scott Richardson
Hello Howard, Welcome! You are on the right track and in the right place. In your original post, your assumptions #1 #2 are correct. There are many methods available. It would be most helpful if we know the platform manufacturer and model, the exact OS version, and the exact version of

RE: [U2] UV: Using UniAdmin/File Tool

2005-03-15 Thread karlp
That's easilly fixed. Add an entry in UV.ACCOUNT for each directory that has files you wish to show up in the file tool. Such as HIST with line 11 = /hist/PROGS/MFH.BP (that begs the question, why would you want to see what appears in your example as a source code file?). Karl quote

[U2] RE:

2005-03-15 Thread dsig
HW Am I on the right track? Can someone tell me if: HW 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? Yes .. back several years this was true HW 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark HW UniVerse DB? Yes .. this is also true HW 3) If

RE: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Jim Bullock
Thanks, Ross. Actually when we were looking for our reporting solution a couple of years ago we looked at the available 'native' U2 products and, for various reasons, decided against them in favor of Crystal Enterprise. Your reference to The Drumheller Trick sent me Googling, but also set the

RE: [U2]: Epicor

2005-03-15 Thread Allen E. Elwood
Me too. But that was a millions of lines of code ago. Totally different animal today. It didn't even do windows back then! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Monday, March 14, 2005 21:50 To: u2-users@listserver.u2ug.org

[U2] RE:

2005-03-15 Thread Jay Falck
I have experienced this same need in the past and found it to be much cheaper to upgrade Universe to a newer version with as few licenses as possible. In my case, I know the data structure and just maintain a copy of the data without the application. If you have the source code for the application

RE: [U2]: Epicor

2005-03-15 Thread Lettau, Jeff
So maybe Advante, Dataflo, infoflo, M2K and the like are not tier 1 multi-million dollar installs. But for ease of use and the ability to tweak the system to meet your needs. I'll take the tier 2 any day. Not intending to start an argument, but what can SAP or JD Edwards do that the smaller

[U2] UV migration

2005-03-15 Thread Robert.Porter2
Hi, Me again... Another thought occurred to me. You were saying this wasn't getting used all that often anymore. I take it this is just more or less for reference from time to time. Would it be feasible to move the data to a PC? You'd have limited access to it. I know you mentioned they weren't

RE: [U2] Re: migration of old UV application on old Unix Server being replaced

2005-03-15 Thread Piers Angliss
snip but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. /snip snip from your website CIBC History The largest merger of two chartered banks in Canadian history happened on June 1, 1961 - The Canadian Bank of Commerce (established 1867)

[U2] RE:

2005-03-15 Thread Wong, Howard
Hi David, Your feed back is much appreciated. The old app was on an AIX box (v 4.3). We were migrating to AIX 5.0, but at the time it was suggested that the app could be migrated from AIX 4.3 to AIX 5.0. So a new app written in Progress replaced it. There was nothing wrong with the app. We do

RE: [U2] UV: Using UniAdmin/File Tool

2005-03-15 Thread Hennessey, Mark F.
snip That's easilly fixed. Add an entry in UV.ACCOUNT for each directory that has files you wish to show up in the file tool. Such as HIST with line 11 = /hist/PROGS/MFH.BP (that begs the question, why would you want to see what appears in your example as a source code file?). /snip I suppose

RE: [U2] RE:

2005-03-15 Thread George Gallen
I agree. Get a Linux system and a 1 user license of Universe. Both combined should cost under $1000.00. You can even use the Linux system as a remote printer server for a parallel / serial / usb printer, or beef up the drives in the Linux system, and use it for online backups or a mail/fax

RE: [U2] Re: migration of old UV application on old Unix Server b eing replaced

2005-03-15 Thread Wong, Howard
Hi Scott, It does look like I'm on the right tack because I've got six replies within an hour of my post. Of the information that you've sought, I only know that the OS is AIX 4.3. The app was to be migrated to AIX 5.0 but the developer at the time advised against it. So a new app written in

[U2] RE:

2005-03-15 Thread dsig
Howard, If you are simply using it for inqiry I would suggest you *might* be able to just get by with the app/uniVerse as it stands on a newer AIX. As I don't know your current uniVerse version we cant guess if it will run on the newer box .. but might be worth a shot. But if not then a simple

Re: [U2] RE:

2005-03-15 Thread Key Ally
[AD] Jay is right. If you maintain the data in the UniVerse system, you could use a tool like Zeus (www.MtOlympus.us) to move data as needed to feed summary reports on the other system [AD]. - Chuck [EMAIL PROTECTED] Barouch Jay Falck wrote: I have experienced this same need in the past and

RE: [U2]: Epicor

2005-03-15 Thread Marc Harbeson
Now she eats XML like candy. :-) and uses buzz words like Dot Net -m -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Tuesday, March 15, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Me too. But that

Re: [U2] UV migration

2005-03-15 Thread Key Ally
Robert, PE is not for use in commercial ventures except for prototyping. - Chuck We Abuse It, We'll Loose It Barouch [EMAIL PROTECTED] wrote: Hi, Me again... Another thought occurred to me. You were saying this wasn't getting used all that often anymore. I take it this is just more or less

RE: [U2]: Epicor

2005-03-15 Thread Marc Harbeson
Being a Manage-2000 client, and having been an Oracle client in the past (10.x) and having seen a JD demo I must say of the t1 suppliers, they did put on a nice show. (They could export directly to excel, change data, and re import the data back into the erp) :-) -Original Message-

RE: [U2] UV: Using UniAdmin/File Tool

2005-03-15 Thread karlp
quote who=Hennessey, Mark F. snip That's easilly fixed. Add an entry in UV.ACCOUNT for each directory that has files you wish to show up in the file tool. Such as HIST with line 11 = /hist/PROGS/MFH.BP (that begs the question, why would you want to see what appears in your example as a

RE: [U2]: Epicor

2005-03-15 Thread Susan Joslyn
Deb, Sometimes the client actually does know best when administering their system controls Actually I couldn't agree with you more, especially about PRC Lite. It was early days and even then I didn't completely agree with the philosophy. On the more recent versions of Avante and PRC things

RE: [U2] RE:

2005-03-15 Thread Wong, Howard
Jack, Thanks for the advice. One other reply suggested the same thing, while others think it shouldn't take much to extract the data. We'll see if any consensus come out of this. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: Jay Falck

Re: [U2] RE:

2005-03-15 Thread Don Kibbey
Installing a current version of UniVerse onto a Solaris box would be the quickest way to move the application. If your not familiar with UniVerse, you would be wise to invest in a few hours of consultant time for someone else to perform the upgrade for you. To move the data out of UniVerse to

Re: [U2] UV migration

2005-03-15 Thread Don Kibbey
In addition to piqueing the interest of the IBM lawyers, using the PE addition in this manner may lead to an issue with large datasets. The PE edition just won't do large files. It's meant as a demo, tire kick tool. On Tue, 15 Mar 2005 11:35:34 -0500, Key Ally [EMAIL PROTECTED] wrote: Robert,

RE: [U2] UV migration

2005-03-15 Thread Wong, Howard
Robert, Yeah, I was looking for the free PE too. But how to get the data from the UNIX box to a PC? Does this goes back to the extract problem? Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: [U2] RE:

2005-03-15 Thread Alfke, Colin
I'll second the motion. Other solutions: 1. Determine some method to keep the current box. 2. Print out reports. Pray that you have all you need and retire the box. - this can be to paper or a report data extraction program. 3. Migrate the application to the current versions of

Re: [U2] UV migration

2005-03-15 Thread Don Kibbey
Getting the data from unix to a pc running windows or linux can be done any number of ways. The basic receipe is copy, fnuxi, resize, recompile, run. You can use nfs, ftp, tape, rsync, samba shares, etc to get the data from one machine to another. The fnuxi part is a UniVerse command to convert

RE: [U2] RE:

2005-03-15 Thread Wong, Howard
Chuck, Thanks for the info. If it works and no other hidden costs, $920.00 is certainly a bargain. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: Key Ally [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 11:33 AM To:

RE: [U2] RE:

2005-03-15 Thread Wong, Howard
Andrew, Thanks for your suggestion. I'll forward it to the team for considering adding to the list of possible solutions. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: Andrew Lakeland [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15,

RE: [U2] UV migration

2005-03-15 Thread Robert.Porter2
Apparently I didn't get my point across as intended... BUT (and a big hairy one at that)... the OP has already stated: Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. Sounds to me like they've already made up their minds to convert away from UV. So where

Re: [U2] RE:

2005-03-15 Thread FFT2001
In a message dated 3/15/2005 9:06:11 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Thanks for the advice. One other reply suggested the same thing, while others think it shouldn't take much to extract the data. We'll see if any consensus come out of this. Howard I have to agree at the

RE: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Jeff Schasny
To expand on Colins idea of a work file: What about creating a process which can be passed a list of column definitions (title,width,datatype, etc) and a set of report data thenand creates an ODBC enabled work file which could be accessed by crystal reports with a simple SELECT * FROM SQL

RE: [U2] UV migration - Maybe [OT]

2005-03-15 Thread David Wolverton
PE is **not** licensed for **ANY** commercial use, even temporary, stop-gap, limited, minor, etc. etc. etc. The only thing you can use PE for in a commercial environment is development (on the idea more seats will ultimately be sold) or Personal (again, prior logic, the more you know it, the

Re: [U2] [UD] disconnected index

2005-03-15 Thread Josh Marcus
Thanks to everyone who responded to my post. I will DELETE.INDEX ALL and recreate and rebuild them. It must have been related to something we did at the OS level, though I am not exactly sure what that was. Thanks, Josh [EMAIL PROTECTED] wrote: Josh Marcus wrote: Has anyone ever seen a

Re: [U2] UV migration

2005-03-15 Thread Don Kibbey
Sorry, I work for lawyers were throw money at it is S.O.P. Getting the data out of the old system and onto brand X database system does not require either a new UniVerse license or an install of PE. It would however go much easier with an install of a consultant type who could quickly show the

RE: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Jim Bullock
Thank you both for the workfile suggestion. We have toyed a bit with this idea. One of the challenges we face is that we have 200 users who can run reports via the Web and the Crystal Enterprise reporting engine. Two simultaneous users couldn't use a single workfile simultaneously. We

[U2] Getting strange error messages in Universe on AIX

2005-03-15 Thread eds
We're getting the following popping up, and the frequency is worrysome: Tue Mar 15 06:03:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:04:02 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:06:00 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:23:38 0 PHANTOMU Program /bin/sh

[U2] [ud] TRANS

2005-03-15 Thread Shawn Waldie
Scenario: Say I'm LISTing from file1 and I want to return the value of field4 from file4...and I have to go through 2 intermediate files to get what I need. I define an idesc like: TRANS('file2',pointer,'field2','X');TRANS('file3',@1,'field3','X');TRANS ('file4',@2,'field4','X') ...and field2

RE: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Aherne, John
If you really want to do selects on the fly, you might want to look into unibojects or uniobjects for java. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Tuesday, March 15, 2005 12:10 PM To: U2 Group Subject: RE: [U2] UD: ODBC/OleDB

RE: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Alfke, Colin
There are a couple of ways around that: you can use a different file for each user or you can put some sort of identifier in the key for each user. We did find some neat functionality in Crystal that meant we could use multiple data files with one report. I forget what their terminology for it

RE: [U2]: Epicor

2005-03-15 Thread Bill H.
Marc: It is possible that this sort of data movement is precisely the reason financial information, at numerous companies, is difficult to attest to, let alone use for analysis. :-) When I see this benefit (capability), red flags go up all over the place. It's like giving a gun to

Re: [U2] RE:

2005-03-15 Thread Jerry Banker
If you want to find out what release of uniVerse you are on and can get to the TCL level (the command level usually a symbol) type in using all caps: ED VOC RELLEVEL then type in P with a return to print the lines you will something like the following, you type in Q to quit then release level

RE: [U2] Getting strange error messages in Universe on AIX

2005-03-15 Thread Anthony Dzikiewicz
Take a look at the PH file (in unix) and try to match an entry there with the time/date of one of the Phantoms that are terminating based on what looks like a snippet of your errlog file. There may be a clue as to what process is running and such. Something I bumped into the other day was a

[U2] [UD] finding a source code file

2005-03-15 Thread Jim Bullock
We have a mix of locally-, globally-, and directly-catalog'ed subroutines on our UD6 system. Does anyone know of a single place one can look to find the location of the source code for ANY cataloged subroutine? I know about CTLGTB for globally-cataloged programs. But what about the local and

Re: [U2] [UD] finding a source code file

2005-03-15 Thread Ian Renfrew
Follow the path of the VOC entry, if one exists then its either direct or local, otherwise global. ... Ian Renfrew - Original Message - From: Jim Bullock [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 15, 2005 8:35 PM Subject: [U2] [UD] finding a source code