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
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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
[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
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
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
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-
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
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
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
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
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,
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]
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
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
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:
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
48 matches
Mail list logo