[U2] @VM in data from INPUT statement
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 somewhere that UV did this under certain conditions. Can anyone shed some light? Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Gnosys Consulting Limited is not responsible for any changes made to this message and / or any attachments after sending by Gnosys Consulting Limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD: ODBC/OleDB access to selected records in a file
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 your spiffy new Crystal Reports. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
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 about calling a pre-process that creates a work file for reporting? Colin Alfke Calgary, AB -Original Message- From: Jim Bullock We are having quite a bit of success writing reports with Crystal Reports, using ODBC to access our UD6 database. We have gone through the exercise of flattening files, creating new dicts, etc. It's slow, but we are usually able to get what we need. We serve up the reports to the users with Crystal Enterprise and Apache. We are not, however, able to take advantage of one (IMHO) of the most powerful features of a U2 database, the ability to manipulate sets of id's through the use of SELECT, SAVE.LIST, GET.LIST, MERGE.LIST, etc. We have a very large library of UniQuery paragraphs which do multiple selects on multiple files, saving foreign keys, eliminating duplicates, etc., to arrive at a final savedlist of id's of records to be put on a report. Currently we use this list of id's to write a report in UniQuery. We would love to be able to write this report instead in Crystal. There would be no SQL SELECT at all in the Crystal report, the selection of the proper records having already been accomplished by the server-based procedure. The natural, or so I thought, place to do this sort of thing is in a stored procedure. I got as far as seeing the stored procedure name via the OleDB driver, but was unsuccessful in actually seeing any data. Many e-mails and phone calls with our VAR and IBM later, we were pointed to a place in the UD documentation where it says stored procedures are not supported by UniData. We have racked our brains and have been unable to come up with a workaround for this gaping hole in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Thanks in advance, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[no subject]
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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: migration of old UV application on old Unix Server being replaced
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 UniVerse. - Original Message - From: Wong, Howard [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 15, 2005 9:45 AM 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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] UV: Using UniAdmin/File Tool
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 who=Hennessey, Mark F. Nick: snip Is there an entry in UV.ACCOUNT for the account whose file you are trying to access? /snip Yes. Field 11 is populated with the unix path to the account. It's the only entry in the record. Here's my problem. UV.ACCOUNT knows about my production account. Let's say the path in the UV.ACCOUNT entry is /dbms/PRODUCTION. When I open FILE TOOL in uniadmin, only those files that are right underneath that path are visible. Such as: /dbms/PRODUCTION/HOLD /dbms/PRODUCTION/VOC but for my files that reside elsewhere, it simply doesn't see them... For example, suppose MFH.BP was in /hist/PROGS/MFH.BP, FILE TOOL won't see the file. But if I move MFH.BP to /dbms/PRODUCTION/MFH.BP, then FILE TOOL will see it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE:
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 (2) is correct, then is there any tool or utilities that can either HW (a) extract the structure and content of the database and perhaps migrate HW them to another DBMS (Unix or Windows), There are those of us (like myself and my associates) to do data migration from/to MV/Sql and we have *some* tools which make the conversion easier. The real problem is understanding your current *structure*. Although there are *tools* which can help with this it does take time to analyse. Moving from the MV world (uniVerse) to the relational world is not simple but doable .. the real work, as I mentioned is the analysis. Without good documentation on your system this will take some time. I would have to ask (not trying to sell either way), other than having an old box that needs to be replaced .. are there any other reasons for moving away from MV. Does the application do all you need it to do. Are the connectivity problems with other applications? OR are you simply looking for an 'updated' system. HW or (b) let us understand the structure and content of the DB? Once again, there are no specific tools that I know of for this process. Those of us in the business have our own tools to do this type of thing. Possibly a better understanding of where you are trying to get to would help us give a better answer. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: From: Wong, Howard [EMAIL PROTECTED] Date: Tue, March 15, 2005 6:45 am To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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] UD: ODBC/OleDB access to selected records in a file
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 wheels turning in my head. Maybe, just maybe... Thanks again. Jim --- Ross Ferris [EMAIL PROTECTED] wrote: Jim, Probably way to late in the day, but there are a number of non-ODBC/OleDB solutions that might have solved this problem for you. Names like mvQuery, Informer, and our own Visage.Reporter come to mind. I assume the other products have something similar to our facility where you can CALL a subroutine that returns a list of ID's to be processed, and we don't really care HOW the list is generated in the first place. So, as to the problem at hand, would a variation of the Drumheller Trick work ? SO that you operate on a file with a single, known key, BUT the field that you return is actually the result of a subroutine which has the necessary logic in it to manipulate your select lists - and from there traverse to the real file ? Never having played, not sure if this would work, but perhaps may trigger a thought in those with more first hand experience Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jim Bullock Sent: Tuesday, 15 March 2005 9:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] UD: ODBC/OleDB access to selected records in a file We are having quite a bit of success writing reports with Crystal Reports, using ODBC to access our UD6 database. We have gone through the exercise of flattening files, creating new dicts, etc. It's slow, but we are usually able to get what we need. We serve up the reports to the users with Crystal Enterprise and Apache. We are not, however, able to take advantage of one (IMHO) of the most powerful features of a U2 database, the ability to manipulate sets of id's through the use of SELECT, SAVE.LIST, GET.LIST, MERGE.LIST, etc. We have a very large library of UniQuery paragraphs which do multiple selects on multiple files, saving foreign keys, eliminating duplicates, etc., to arrive at a final savedlist of id's of records to be put on a report. Currently we use this list of id's to write a report in UniQuery. We would love to be able to write this report instead in Crystal. There would be no SQL SELECT at all in the Crystal report, the selection of the proper records having already been accomplished by the server-based procedure. The natural, or so I thought, place to do this sort of thing is in a stored procedure. I got as far as seeing the stored procedure name via the OleDB driver, but was unsuccessful in actually seeing any data. Many e-mails and phone calls with our VAR and IBM later, we were pointed to a place in the UD documentation where it says stored procedures are not supported by UniData. We have racked our brains and have been unable to come up with a workaround for this gaping hole in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Thanks in advance, Jim ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard
RE: [U2]: Epicor
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 Subject: RE: [U2]: Epicor Yes...and I was privy to M2K back when it went through ADP doors and was sold back out again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Monday, March 14, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I believe that Jeff was speaking about Manage-2000. Polk audio, in addition to making great speakers, is a Manage-2000 user. Now if I could just get them to send a couple of studio monitors my way for the plug. ;-) When I was working for M2k under ROI Systems, there were several companies that choose it over JD, SAP as well as Epicor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor X-Squeeze me But comparing Avante to JD Edwards Sap is like putting a 2.5 foot T-ball player up against Derek Jeter..its not in the same league Avante is not a tier 1 no matter how much you would like to think that its playing with the big boys... -- Debster -- Original message -- There are a few Epicor people that do read this list. They just tend to lay low unless the discussion effects them directly. I can say a that there are a few people still in the Manage-2000 group that are very good with the interfaces to U2. From my past experience with Epicor, they are a very good company for support, and regardless of how many developers you have, there will always be bugs in the software that require patches. Many times these bugs are not evident due to the fact that everyone will use the software slightly different. I think their long term plan is to take the many packages they have and migrate them all into one package that is all inclusive and database independent. Although making it database independent may be counter productive to their plan on consolidating the software packages. If you look at who the other choices are for software, I'd say Epicor is still one of the top choices. Especially when you consider the flexibility needed in dealing in a manufacturing environment. What are your other choices? JD Edwards? SAP? They are also trying to focus on integrating all of their other packages together into a complete solution. Kind of like cross selling. If you run ERP and want CRM then they want to integrate the 2. They have many initiatives that are good ideas, in my humble opinion, but it will take them years to make it work. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, March 13, 2005 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Another interesting consideration is seeing no response from anyone within Epicor to this thread. That tells me they have little to no interest in U2 which is a red flag in my book. Certainly implies that they don't have knowledgeable or extensive support for how Epicor interfaces or doesn't with U2 in general. Will 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/ --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE:
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 you should be able to just re-compile the application and be good to go for several more years. All in all, a great deal less expensive than trying to migrate the data to another home. My $0.02. Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 8:46 AM To: 'u2-users@listserver.u2ug.org' Subject: 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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]: Epicor
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 Epicor products can't do? What makes them worth the added cost? I don't' buy into that they can handle more users. That is mostly a matter of database management, hardware and infrastructure. You also have to consider who is buying what system and what their intensions are. What do you really get out of a standard SAP or JD Edwards install that you can't get from any system provided by Epicor or similar smaller priced package? I'm not being rhetorical.(again spell checker saves the day, I didn't know a word could start with rh.) P.s. you can get the Monitor Series at a Circuit city store or other high end audio stores near you! You can't seriously expect me to send you something for free! I can't get stuff for free. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Debster Sent: Tuesday, March 15, 2005 12:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Yes...and I was privy to M2K back when it went through ADP doors and was sold back out again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Monday, March 14, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I believe that Jeff was speaking about Manage-2000. Polk audio, in addition to making great speakers, is a Manage-2000 user. Now if I could just get them to send a couple of studio monitors my way for the plug. ;-) When I was working for M2k under ROI Systems, there were several companies that choose it over JD, SAP as well as Epicor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor X-Squeeze me But comparing Avante to JD Edwards Sap is like putting a 2.5 foot T-ball player up against Derek Jeter..its not in the same league Avante is not a tier 1 no matter how much you would like to think that its playing with the big boys... -- Debster -- Original message -- There are a few Epicor people that do read this list. They just tend to lay low unless the discussion effects them directly. I can say a that there are a few people still in the Manage-2000 group that are very good with the interfaces to U2. From my past experience with Epicor, they are a very good company for support, and regardless of how many developers you have, there will always be bugs in the software that require patches. Many times these bugs are not evident due to the fact that everyone will use the software slightly different. I think their long term plan is to take the many packages they have and migrate them all into one package that is all inclusive and database independent. Although making it database independent may be counter productive to their plan on consolidating the software packages. If you look at who the other choices are for software, I'd say Epicor is still one of the top choices. Especially when you consider the flexibility needed in dealing in a manufacturing environment. What are your other choices? JD Edwards? SAP? They are also trying to focus on integrating all of their other packages together into a complete solution. Kind of like cross selling. If you run ERP and want CRM then they want to integrate the 2. They have many initiatives that are good ideas, in my humble opinion, but it will take them years to make it work. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, March 13, 2005 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Another interesting consideration is seeing no response from anyone within Epicor to this thread. That tells me they have little to no interest in U2 which is a red flag in my book. Certainly implies that they don't have knowledgeable or extensive support for how Epicor interfaces or doesn't with U2 in general. Will 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/ --- 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
[U2] UV migration
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 likely to put money out to upgrade to a new version of UV. And with the costs of UV licenses, I can't say that I'd blame them. BUT, there is a UniVerse Personal Edition that may be the trick for you. It doesn't come with support, but you can find support other places (contractors, VARs, etc. - I actually do a little of that in the healthcare field where I came from on the side as time permits). The UV Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 simultaneous connections to it. Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ The PE version has been temporarily removed from the site, but it is possible to get a hold of them. I might still have a CD around, or may be able to get it. I'm dealing with UD more at the moment. Does this sound like something that may be of use? Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 9:46 AM To: 'u2-users@listserver.u2ug.org' Subject: 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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] Re: migration of old UV application on old Unix Server being replaced
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) and the Imperial Bank of Canada (established 1875) merged to form the Canadian Imperial Bank of Commerce (CIBC). Its history spans nearly two centuries and is full of adventure and enterprise. /snip So, you're not exactly short of a cent or two then If the manager wants to access the data he's probably going to have to spend some money, good or bad 1. If nobody knows the structure of the data then unless it's very simple migrating to another dbms it will take a bit of time and money - the mechanics aren't difficult but restructuring could be. You then have to let your users access it without the old application s/w 2. Keeping it in Universe is simple, you just have to get onto an up-to-date platform. It is possible (but unlikely) that the old version of Universe will run on an updated version of the same OS but that may cost you for proprietary h/w OS, alternatively get a new version of universe to run on Windoze or Linux and minimise the h/w OS costs (sorry, just joking about Windoze). How many concurrent users do you need, what make / model of hardware is it on now, what OS and what version Do you know what version of Universe it is running now (or how to find out ?) Piers --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE:
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 not know why newer version of UniVerse (if it was available) was not used for the migration instead. The AIX 4.3 box will be replaced either by a new AIX box or new Solaris box, the latter being our new institution-wide standard. The old app and DB was kept around because we still inquire on the older data from time to time. So we don't need full blown app development but just need to extract the data for inquiry purpose. BTW, we have no idea which version of UniVerse was used to develop the old app. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:27 AM To: u2-users@listserver.u2ug.org Cc: Wong, Howard Subject: RE: 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 (2) is correct, then is there any tool or utilities that can either HW (a) extract the structure and content of the database and perhaps migrate HW them to another DBMS (Unix or Windows), There are those of us (like myself and my associates) to do data migration from/to MV/Sql and we have *some* tools which make the conversion easier. The real problem is understanding your current *structure*. Although there are *tools* which can help with this it does take time to analyse. Moving from the MV world (uniVerse) to the relational world is not simple but doable .. the real work, as I mentioned is the analysis. Without good documentation on your system this will take some time. I would have to ask (not trying to sell either way), other than having an old box that needs to be replaced .. are there any other reasons for moving away from MV. Does the application do all you need it to do. Are the connectivity problems with other applications? OR are you simply looking for an 'updated' system. HW or (b) let us understand the structure and content of the DB? Once again, there are no specific tools that I know of for this process. Those of us in the business have our own tools to do this type of thing. Possibly a better understanding of where you are trying to get to would help us give a better answer. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: From: Wong, Howard [EMAIL PROTECTED] Date: Tue, March 15, 2005 6:45 am To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much
RE: [U2] UV: Using UniAdmin/File Tool
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'll have to setup each directory for uv, no? And my example was indeed a poor choice (notional though it is)... I really should have used something like: /hist/alcohol/BEER/AMERICAN/Put_it_back_in_the_horse --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE:
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 gateway. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jay Falck Sent: Tuesday, March 15, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: 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 you should be able to just re-compile the application and be good to go for several more years. All in all, a great deal less expensive than trying to migrate the data to another home. My $0.02. Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 8:46 AM To: 'u2-users@listserver.u2ug.org' Subject: 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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/
RE: [U2] Re: migration of old UV application on old Unix Server b eing replaced
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 Progress was created to replace it. The old AIX 4.3 has since been maintained with the UniVerse app and data on it, but we use it only to do inquiry on some old data that was not migrated. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: Scott Richardson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Re: migration of old UV application on old Unix Server being replaced 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 UniVerse. - Original Message - From: Wong, Howard [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 15, 2005 9:45 AM 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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/
[U2] RE:
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 upgrade to uniVerse 10.x with as few license as you need. This should allow you to inquire without costing too much. If you don't need to migrate to another platform, especially if you are just using it for inquiry, i would strongly suggest you stay with uniVerse. As long as it makes financial sense. Is the box being gotten rid of? If not .. just leave it on your network and put it in a closet G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: From: Wong, Howard [EMAIL PROTECTED] Date: Tue, March 15, 2005 8:09 am To: '[EMAIL PROTECTED]' [EMAIL PROTECTED], u2-users@listserver.u2ug.org 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 not know why newer version of UniVerse (if it was available) was not used for the migration instead. The AIX 4.3 box will be replaced either by a new AIX box or new Solaris box, the latter being our new institution-wide standard. The old app and DB was kept around because we still inquire on the older data from time to time. So we don't need full blown app development but just need to extract the data for inquiry purpose. BTW, we have no idea which version of UniVerse was used to develop the old app. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:27 AM To: u2-users@listserver.u2ug.org Cc: Wong, Howard Subject: RE: 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 (2) is correct, then is there any tool or utilities that can either HW (a) extract the structure and content of the database and perhaps migrate HW them to another DBMS (Unix or Windows), There are those of us (like myself and my associates) to do data migration from/to MV/Sql and we have *some* tools which make the conversion easier. The real problem is understanding your current *structure*. Although there are *tools* which can help with this it does take time to analyse. Moving from the MV world (uniVerse) to the relational world is not simple but doable .. the real work, as I mentioned is the analysis. Without good documentation on your system this will take some time. I would have to ask (not trying to sell either way), other than having an old box that needs to be replaced .. are there any other reasons for moving away from MV. Does the application do all you need it to do. Are the connectivity problems with other applications? OR are you simply looking for an 'updated' system. HW or (b) let us understand the structure and content of the DB? Once again, there are no specific tools that I know of for this process. Those of us in the business have our own tools to do this type of thing. Possibly a better understanding of where you are trying to get to would help us give a better answer. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: From: Wong, Howard [EMAIL PROTECTED] Date: Tue, March 15, 2005 6:45 am To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post:
Re: [U2] RE:
[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 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 you should be able to just re-compile the application and be good to go for several more years. All in all, a great deal less expensive than trying to migrate the data to another home. My $0.02. Jay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
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 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 Subject: RE: [U2]: Epicor Yes...and I was privy to M2K back when it went through ADP doors and was sold back out again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Monday, March 14, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I believe that Jeff was speaking about Manage-2000. Polk audio, in addition to making great speakers, is a Manage-2000 user. Now if I could just get them to send a couple of studio monitors my way for the plug. ;-) When I was working for M2k under ROI Systems, there were several companies that choose it over JD, SAP as well as Epicor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor X-Squeeze me But comparing Avante to JD Edwards Sap is like putting a 2.5 foot T-ball player up against Derek Jeter..its not in the same league Avante is not a tier 1 no matter how much you would like to think that its playing with the big boys... -- Debster -- Original message -- There are a few Epicor people that do read this list. They just tend to lay low unless the discussion effects them directly. I can say a that there are a few people still in the Manage-2000 group that are very good with the interfaces to U2. From my past experience with Epicor, they are a very good company for support, and regardless of how many developers you have, there will always be bugs in the software that require patches. Many times these bugs are not evident due to the fact that everyone will use the software slightly different. I think their long term plan is to take the many packages they have and migrate them all into one package that is all inclusive and database independent. Although making it database independent may be counter productive to their plan on consolidating the software packages. If you look at who the other choices are for software, I'd say Epicor is still one of the top choices. Especially when you consider the flexibility needed in dealing in a manufacturing environment. What are your other choices? JD Edwards? SAP? They are also trying to focus on integrating all of their other packages together into a complete solution. Kind of like cross selling. If you run ERP and want CRM then they want to integrate the 2. They have many initiatives that are good ideas, in my humble opinion, but it will take them years to make it work. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, March 13, 2005 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Another interesting consideration is seeing no response from anyone within Epicor to this thread. That tells me they have little to no interest in U2 which is a red flag in my book. Certainly implies that they don't have knowledgeable or extensive support for how Epicor interfaces or doesn't with U2 in general. Will 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/ --- 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/ --- 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] UV migration
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 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 likely to put money out to upgrade to a new version of UV. And with the costs of UV licenses, I can't say that I'd blame them. BUT, there is a UniVerse Personal Edition that may be the trick for you. It doesn't come with support, but you can find support other places (contractors, VARs, etc. - I actually do a little of that in the healthcare field where I came from on the side as time permits). The UV Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 simultaneous connections to it. Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ The PE version has been temporarily removed from the site, but it is possible to get a hold of them. I might still have a CD around, or may be able to get it. I'm dealing with UD more at the moment. Does this sound like something that may be of use? Robert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Tuesday, March 15, 2005 10:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor 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 Epicor products can't do? What makes them worth the added cost? I don't' buy into that they can handle more users. That is mostly a matter of database management, hardware and infrastructure. You also have to consider who is buying what system and what their intensions are. What do you really get out of a standard SAP or JD Edwards install that you can't get from any system provided by Epicor or similar smaller priced package? I'm not being rhetorical.(again spell checker saves the day, I didn't know a word could start with rh.) P.s. you can get the Monitor Series at a Circuit city store or other high end audio stores near you! You can't seriously expect me to send you something for free! I can't get stuff for free. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Debster Sent: Tuesday, March 15, 2005 12:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Yes...and I was privy to M2K back when it went through ADP doors and was sold back out again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Monday, March 14, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I believe that Jeff was speaking about Manage-2000. Polk audio, in addition to making great speakers, is a Manage-2000 user. Now if I could just get them to send a couple of studio monitors my way for the plug. ;-) When I was working for M2k under ROI Systems, there were several companies that choose it over JD, SAP as well as Epicor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor X-Squeeze me But comparing Avante to JD Edwards Sap is like putting a 2.5 foot T-ball player up against Derek Jeter..its not in the same league Avante is not a tier 1 no matter how much you would like to think that its playing with the big boys... -- Debster -- Original message -- There are a few Epicor people that do read this list. They just tend to lay low unless the discussion effects them directly. I can say a that there are a few people still in the Manage-2000 group that are very good with the interfaces to U2. From my past experience with Epicor, they are a very good company for support, and regardless of how many developers you have, there will always be bugs in the software that require patches. Many times these bugs are not evident due to the fact that everyone will use the software slightly different. I think their long term plan is to take the many packages they have and migrate them all into one package that is all inclusive and database independent. Although making it database independent may be counter productive to their plan on consolidating the software packages. If you look at who the other choices are for software, I'd say Epicor is still one of the top choices. Especially when you consider the flexibility needed in dealing in a manufacturing environment. What are your other choices? JD Edwards? SAP? They are also trying to focus on integrating all of their other packages together into a complete solution. Kind of like cross selling. If you run ERP and want CRM then they want to integrate the 2. They have many initiatives that are good ideas, in my humble opinion, but it will take them years to make it work. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, March 13, 2005 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Another interesting consideration is seeing no response from anyone within Epicor to this thread. That tells me they have little to no interest in U2 which is a red flag in my book. Certainly implies that they don't have knowledgeable or extensive support for how Epicor interfaces or doesn't with U2 in general. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit
RE: [U2] UV: Using UniAdmin/File Tool
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 source code file?). /snip I suppose I'll have to setup each directory for uv, no? No you don't. If there's an entry in UV.ACCOUNT, File Tool should see all the files there. Only if you logto the account will you need to have a VOC, etc. And my example was indeed a poor choice (notional though it is)... I really should have used something like: /hist/alcohol/BEER/AMERICAN/Put_it_back_in_the_horse Okay, I tend to be a bit anal... Nice point. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
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 got better. I can respond more in detail privately (I have Powerpoint presentations and stuff) or take this to the Avante newsgroup - But I wanted to state here that there are probably things that you/we can do (within PRC and procedurally) to ease your situation. I would love to hear specifically what the more open source control tools could do for you because I'm always interested in making PRC work the best for its users. I suspect that ANYTHING would be more open than PRC Lite. But I am always keen to hear ideas for improvement - or help iron out a difficult situation. For folks who have developer seats of the newer (Rel 5) PRC, there are a few things that people don't tend to do (to know about) which can have a huge impact on the amount of time it takes to install patches and releases. In your case specifically, Deb, it sounds like you are on an older release of Avante and PRC and it may be that you are caught there . Although with a little careful handling we can arrange it so that you can upgrade to a developer seat of the newer PRC without upgrading Avante. Then you could put some procedures in place that might ease things up quite a bit. I reckon there are always happy and not-so-happy customers of any product, particularly software. That is why its good to have this forum to air those. Let us hope that Epicor are watching keenly as well. Chers, Susan -Original Message- From: [EMAIL PROTECTED] [] On Behalf Of Debster Sent: Monday, March 14, 2005 10:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Sorry Susan Your baby ain't butt ugly but no mother thinks her baby has flaws... But -- I've worked on alot of packages, and yes even extensive tier 1 packages that are well out of price points for some. Yes with Avante there are alot of bells and whistles, but ofttimes when trying to be all things to all manufacturing markets you miss the mark by being too convoluted to use effectively without customizing it to meet the individual company needs and throwing out a good portion that you paid for. Remember KISS? Sometimes simple is better, or something geared toward more specific target market, ala flavors like we are all familar with. Problems do arise with Avante and trying to administer the patches without total disruption. The location I am at was virtually shut down for more than just a day or two due to patches in the past. Even when initially bringing the system up, they were shut down due to screw ups by Epicor tech reps in regards to system set up functions. I know its your baby, but I loathe the fact that you are forced to utilize PRC. Granted my current location runs the light version along with the fact that there are few software version control systems available for the U2 market, but I have utilized more open home grown systems that provided better ease of use while providing just as much or a higher level of control and deployment functions. Sometimes the client actually does know best when administering their system controls. Even though there may be many happy as a clam Avante users, and you see those in attendance at user meetings, but what percentage does that represent of the actual number of end-users? Pissed off customers rarely attend those functions unless it's to sit at the back of the room and heckle. Someone asked for an opinion from users, and I gave it from my 15+ years in manufacturing as a resource... Sorry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE:
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 [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: 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 you should be able to just re-compile the application and be good to go for several more years. All in all, a great deal less expensive than trying to migrate the data to another home. My $0.02. Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 8:46 AM To: 'u2-users@listserver.u2ug.org' Subject: 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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/
Re: [U2] RE:
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 another platform you really need to know what's in the database and how it's structured. A few hours with a consultant might get you headed in the right direction. You may find that extracting only the subset of stuff your users are really interested in will be more cost effective than upgrading or converting the entire application. I don't do outside consulting, but I know there are a few on this list who do. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV migration
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, 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 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 likely to put money out to upgrade to a new version of UV. And with the costs of UV licenses, I can't say that I'd blame them. BUT, there is a UniVerse Personal Edition that may be the trick for you. It doesn't come with support, but you can find support other places (contractors, VARs, etc. - I actually do a little of that in the healthcare field where I came from on the side as time permits). The UV Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 simultaneous connections to it. Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ The PE version has been temporarily removed from the site, but it is possible to get a hold of them. I might still have a CD around, or may be able to get it. I'm dealing with UD more at the moment. Does this sound like something that may be of use? Robert --- 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] UV migration
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] Sent: Tuesday, March 15, 2005 11:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV migration 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 likely to put money out to upgrade to a new version of UV. And with the costs of UV licenses, I can't say that I'd blame them. BUT, there is a UniVerse Personal Edition that may be the trick for you. It doesn't come with support, but you can find support other places (contractors, VARs, etc. - I actually do a little of that in the healthcare field where I came from on the side as time permits). The UV Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 simultaneous connections to it. Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ The PE version has been temporarily removed from the site, but it is possible to get a hold of them. I might still have a CD around, or may be able to get it. I'm dealing with UD more at the moment. Does this sound like something that may be of use? Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 9:46 AM To: 'u2-users@listserver.u2ug.org' Subject: 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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/
RE: [U2] RE:
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 Aix/Solaris/Universe. 4. Extract the data into a format you are currently more comfortable with. Extracting the data may be a chore, depending on the application that created it. There are some commercial reporting and extraction tools; however, depending the application you may just end up with tables of data with no idea what they mean. Having someone who knows (or can figure out) the application may help. Colin Alfke Calgary, Canada -Original Message- From: David Tod Sigafoos 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 upgrade to uniVerse 10.x with as few license as you need. This should allow you to inquire without costing too much. If you don't need to migrate to another platform, especially if you are just using it for inquiry, i would strongly suggest you stay with uniVerse. As long as it makes financial sense. Is the box being gotten rid of? If not .. just leave it on your network and put it in a closet G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message From: Wong, Howard 2ug.org 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 not know why newer version of UniVerse (if it was available) was not used for the migration instead. The AIX 4.3 box will be replaced either by a new AIX box or new Solaris box, the latter being our new institution-wide standard. The old app and DB was kept around because we still inquire on the older data from time to time. So we don't need full blown app development but just need to extract the data for inquiry purpose. BTW, we have no idea which version of UniVerse was used to develop the old app. Regards, Howard Wong --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV migration
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 the data format from one machine type and version to another. Using a 1-2 user developers license for UniVerse 10 and a pc running windows or linux would probably be the most cost effective solution if general lookup is all you want to do. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE:
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: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: [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 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 you should be able to just re-compile the application and be good to go for several more years. All in all, a great deal less expensive than trying to migrate the data to another home. My $0.02. Jay --- 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] RE:
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, 2005 12:03 PM To: u2-users@listserver.u2ug.org; '[EMAIL PROTECTED]' Subject: RE: [U2] RE: A few years back I did an archive system for someone, I restored their AIX database straight onto a PC from Tape and then saved the database onto DVD as a zip file. I did this for various end of months, they then unzipped which every file they needed back from the DVD to the hard disk and the system was back to which every point they needed. It was a lot cheaper than migrating and they simply have a 4 user license on a PC. Also remember which ever option you choose you will need to know the database. Migrating can be very labour intensive which would probably incur most costs. As you need to know the database which ever route you take, I'd suggest you document it and get someone to do your extractions when and IF you need them. You can also get someone to setup an ODBC link to your universe database so your could build your own reports from EXCEL, for example. Once the files are setup for access they are automatically flattened and appear in an MSquiry as list of files and fields. Regards Andy -Original Message- From: Wong, Howard [mailto:[EMAIL PROTECTED] Sent: 15 March 2005 17:09 To: '[EMAIL PROTECTED]'; u2-users@listserver.u2ug.org Subject: [U2] RE: 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 not know why newer version of UniVerse (if it was available) was not used for the migration instead. The AIX 4.3 box will be replaced either by a new AIX box or new Solaris box, the latter being our new institution-wide standard. The old app and DB was kept around because we still inquire on the older data from time to time. So we don't need full blown app development but just need to extract the data for inquiry purpose. BTW, we have no idea which version of UniVerse was used to develop the old app. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:27 AM To: u2-users@listserver.u2ug.org Cc: Wong, Howard Subject: RE: 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 (2) is correct, then is there any tool or utilities that can either HW (a) extract the structure and content of the database and perhaps migrate HW them to another DBMS (Unix or Windows), There are those of us (like myself and my associates) to do data migration from/to MV/Sql and we have *some* tools which make the conversion easier. The real problem is understanding your current *structure*. Although there are *tools* which can help with this it does take time to analyse. Moving from the MV world (uniVerse) to the relational world is not simple but doable .. the real work, as I mentioned is the analysis. Without good documentation on your system this will take some time. I would have to ask (not trying to sell either way), other than having an old box that needs to be replaced .. are there any other reasons for moving away from MV. Does the application do all you need it to do. Are the connectivity problems with other applications? OR are you simply looking for an 'updated' system. HW or (b) let us understand the structure and content of the DB? Once again, there are no specific tools that I know of for this process. Those of us in the business have our own tools to do this type of thing. Possibly a better understanding of where you are trying to get to would help us give a better answer. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: From: Wong, Howard [EMAIL PROTECTED] Date: Tue, March 15, 2005 6:45 am To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org 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 mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB,
RE: [U2] UV migration
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 exactly is the problem? They have already said they want to extract the data. We aren't talking about running a production system on it. Maybe my mentioning that support is limited for PE caused this. I was simply pointing out there's another option, but that they would have limited resources, from IBM anyway, if they ran into problems. And let's see... (Pretending to be Mr IBM Lawyer) Hmm, here's a place that already owns a valid albeit older UV license, but wants to use our current UV PE to extract the data. They aren't running production on it, just working out how to extract the data. And they are even considering moving the data into OUR DB2 database... Do we sue them??? And if so, for what? Using a product we give away to extract data from one of our licensed databases, and perhaps move it into another one of our licensed databases? The only valid argument I saw against it so far is the comment about large datasets. And I did mention that briefly (too briefly apparently) with Would it be feasible to move the data to a PC? We don't know anything about this database in terms of size or much else for that matter. Only they can determine the answers to what is the appropriate route for them to take. They're looking for options. I gave them one. Come on people... I'm a software developer. I don't exactly go around suggesting people steal software. They need a temporary solution to get the data out. Throw money at it is rarely a good idea and for a temporary need almost never. Robert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE:
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 cost of my eating my own foot. As a consultant, I would love to bill you for a few hundred hours to build routines to extract the data. However, it would be far cheaper (orders of magnitude) to simply get a PC, a new version of Universe, and port your application software and data to that, and build a tie-in to allow the database to be queried from your existing other application-face. This is especially true if this older database will be phased out over the next five to ten years. Will Johnson Fast Forward Technologies --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
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 statement. -Original Message- 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 about calling a pre-process that creates a work file for reporting? Colin Alfke Calgary, AB Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV migration - Maybe [OT]
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 more you love it)... Porting is not either of those things. And the license doesn't say 'or commercial purposes for 3 months or less' (I don't think!!) We're not being mean or trying to extract another dollar from anyone by stating the facts. IBM has their rules on how these things work. It's the agreement we all entered into when we accepted the license to use the database. This customer can use their current environment perpetually with no additional costs, ever, but it seems they need to move to another platform - and for that, there is a fee to be paid to someone - namely, IBM and the new hardware and O/S vendors! If they are just moving data, they could buy a ONE or TWO SEATS in the workgroup license for probably way under $1000 - it's not going to break their budget - heck, I bet it's less than the consultant will charge for doing the research! g We have to be careful on the Personal Editions - they are not OURS to distribute (having a CD or copy of the download does NOT make you an Authorized Distribution Point!) or decide what they are 'supposed' to be used for. Those are legal issues covered in the User License. IBM decides what terms they want to offer - we don't. However, if we are not careful, PE versions may go away or become impossible to get without blood typing!! The most any of us can ever LEGALLY do is provide the URL to the PE versions (when they are back up and running!). I hope IBM makes gazillions of dollars off U2, because if they do, we'll make a LOT more! I don't think any of the policies or pricing I've seen thus far are that bad or unfair. This client has had years of use of the database for the one time, up front costs. It appears they are not under maintenance and have not kicked anything into the coffers for a while. And, IMHO, asking a customer, who after years of no maintenance needs to migrate to another platform, to cough up under $1k is not 'throwing money' at the issue. I suspect the data is worth a magintude more than IBM would ever ask them to pay! And that the consultant(s) involved will get far more than IBM will out of the deal. But the client gets the joy of continued access to the data - priceless. DW - snippage Come on people... I'm a software developer. I don't exactly go around suggesting people steal software. They need a temporary solution to get the data out. Throw money at it is rarely a good idea and for a temporary need almost never. Robert --- 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] [UD] disconnected index
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 UniData file have its index become disconnected from the data file? I have a file that used to have indexes. I can verify that because I have a LIST.INDEX printout from a few months ago showing them. However, they are no longer in place. When I run LIST.INDEX against the file, it reports there are none. I checked at the Unix level and there was still an index file (X_TX.ARCHV) next to the data file. Not knowing what else to do, I tried to add one of the indexes back to the file. I got this: CREATE.INDEX TX.ARCHV TXA.CAMPAIGN TXA.CAMPAIGN: can not create multiple indices on same location After that, the index showed up in LIST.INDEX. Furthermore, LIST.INDEX tells me the index is built, and selections on the file behave like there are built indexes in place. Anyone have any ideas as to what's going on here? Should I be concerned? The file in question is a dynamic file, if that is of any relevance. System info: UniData 6.0.11 on Tru64 Unix 5.1a. The index for a dynamic UniData file is not stored as X_file. Instead, the index is stored in idx00n partitions inside the directory that holds the primary and overflow partitions. Is it possible that someone converted this file to dynamic recently and the index conversion part of the process didn't go through properly - maybe because of permissions? I've seen scenarios where over zealous system administrators imposed a 0111 umask which meant you could create a new directory for a dynamic file, but couldn't subsequently do much with it because you couldn't list its contents! Anyhow, the X_TX.ARCHV is certainly not related to any indexes on TX.ARCHV if TX.ARCHV is really a dynamic file, in which case TX.ARCHV will be a directory at the OS level. You CAN disconnect an index from a file but leave the OS index files in place, but you either have to have some file corruption, or someone playing cleverly (or stupidly) with fileview. I'd strongly recommend you check the VOC pointer for TX.ARCHV and make sure that the one you are looking at at the OS level is the same one being accessed when you are inside UniData. I'd then check if it really is a dynamic file, and if so, then simply rename your X_TX.ARCHV as something which will remind you to delete it after a day or so. Then run guide against the file to check for any corruption, fix that up with fixfile, and then re-address the indices question. If LIST.INDEX shows you that there really is an index, run guide_ndx against it and consider doing as Colin suggests and DELETE.INDEXing everything before CREATE.INDEXing them again. Cheers, Ken --- 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] UV migration
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 folks what is in the system, where it's stored and the quickest and cheapest way to get it out of there. I guess the moral of this story is you ask a broad question, you get lots of broad answers. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
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 haven't found an easy way to build, odbc-enable, and then destroy workfiles, but this is a method that bears further investigation. Thanks again to everyone who responded. Jim --- Jeff Schasny [EMAIL PROTECTED] wrote: 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 statement. -Original Message- 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 about calling a pre-process that creates a work file for reporting? Colin Alfke Calgary, AB Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Getting strange error messages in Universe on AIX
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 terminated. Tue Mar 15 06:23:38 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:23:39 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:24:02 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:25:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:26:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:28:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:29:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:30:02 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:30:04 0 PHANTOMU Program /bin/sh terminated. Any ideas where these may be coming from and how to stop them? Thanks! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [ud] TRANS
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 is mv'd. I would probably write a subr for this in most cases, but I just wanted to see what the list had to say. What are the gotchyas, and are there some other UD function combos that can do this job more efficiently? TIA * * Shawn Waldie Programmer/Analyst * * SUNGARD Collegis, Inc. * * serving * * San Juan College * * 4601 College Blvd * * Farmington, NM 87402 * * Email: [EMAIL PROTECTED] * * Phone: (505)566-3072* * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
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 access to selected records in a file 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 statement. -Original Message- 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 about calling a pre-process that creates a work file for reporting? Colin Alfke Calgary, AB Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- 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] UD: ODBC/OleDB access to selected records in a file
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 was. Colin Alfke Calgary, Canada -Original Message- From: 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 haven't found an easy way to build, odbc-enable, and then destroy workfiles, but this is a method that bears further investigation. Thanks again to everyone who responded. Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
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 children...most will be ok but someone __WILL__ get hurt. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Tuesday, March 15, 2005 8:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Tuesday, March 15, 2005 10:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor 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 Epicor products can't do? What makes them worth the added cost? I don't' buy into that they can handle more users. That is mostly a matter of database management, hardware and infrastructure. You also have to consider who is buying what system and what their intensions are. What do you really get out of a standard SAP or JD Edwards install that you can't get from any system provided by Epicor or similar smaller priced package? I'm not being rhetorical.(again spell checker saves the day, I didn't know a word could start with rh.) P.s. you can get the Monitor Series at a Circuit city store or other high end audio stores near you! You can't seriously expect me to send you something for free! I can't get stuff for free. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Debster Sent: Tuesday, March 15, 2005 12:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Yes...and I was privy to M2K back when it went through ADP doors and was sold back out again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Monday, March 14, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I believe that Jeff was speaking about Manage-2000. Polk audio, in addition to making great speakers, is a Manage-2000 user. Now if I could just get them to send a couple of studio monitors my way for the plug. ;-) When I was working for M2k under ROI Systems, there were several companies that choose it over JD, SAP as well as Epicor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor X-Squeeze me But comparing Avante to JD Edwards Sap is like putting a 2.5 foot T-ball player up against Derek Jeter..its not in the same league Avante is not a tier 1 no matter how much you would like to think that its playing with the big boys... -- Debster -- Original message -- There are a few Epicor people that do read this list. They just tend to lay low unless the discussion effects them directly. I can say a that there are a few people still in the Manage-2000 group that are very good with the interfaces to U2. From my past experience with Epicor, they are a very good company for support, and regardless of how many developers you have, there will always be bugs in the software that require patches. Many times these bugs are not evident due to the fact that everyone will use the software slightly different. I think their long term plan is to take the many packages they have and migrate them all into one package that is all inclusive and database independent. Although making it database independent may be counter productive to their plan on consolidating the software packages. If you look at who the other choices are for software, I'd say Epicor is still one of the top choices. Especially when you consider the flexibility needed in dealing in a manufacturing environment. What are your other choices? JD Edwards? SAP? They are also trying to focus on integrating all of their other packages together into a complete solution. Kind of like cross selling. If you run ERP and want CRM then they want to integrate the 2. They have many initiatives that are good ideas, in my humble opinion, but it
Re: [U2] RE:
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 is on the second line: ED VOC RELLEVEL 5 lines long. : P 0001: X 0002: 9.6.2.3 0003: REALITY 0004: REALITY.FORMAT 0005: 9.6.2.3 Bottom at line 5. : Q Jerry - Original Message - From: Wong, Howard [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 11:52 AM Subject: RE: [U2] RE: 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, 2005 12:03 PM To: u2-users@listserver.u2ug.org; '[EMAIL PROTECTED]' Subject: RE: [U2] RE: A few years back I did an archive system for someone, I restored their AIX database straight onto a PC from Tape and then saved the database onto DVD as a zip file. I did this for various end of months, they then unzipped which every file they needed back from the DVD to the hard disk and the system was back to which every point they needed. It was a lot cheaper than migrating and they simply have a 4 user license on a PC. Also remember which ever option you choose you will need to know the database. Migrating can be very labour intensive which would probably incur most costs. As you need to know the database which ever route you take, I'd suggest you document it and get someone to do your extractions when and IF you need them. You can also get someone to setup an ODBC link to your universe database so your could build your own reports from EXCEL, for example. Once the files are setup for access they are automatically flattened and appear in an MSquiry as list of files and fields. Regards Andy -Original Message- From: Wong, Howard [mailto:[EMAIL PROTECTED] Sent: 15 March 2005 17:09 To: '[EMAIL PROTECTED]'; u2-users@listserver.u2ug.org Subject: [U2] RE: 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 not know why newer version of UniVerse (if it was available) was not used for the migration instead. The AIX 4.3 box will be replaced either by a new AIX box or new Solaris box, the latter being our new institution-wide standard. The old app and DB was kept around because we still inquire on the older data from time to time. So we don't need full blown app development but just need to extract the data for inquiry purpose. BTW, we have no idea which version of UniVerse was used to develop the old app. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:27 AM To: u2-users@listserver.u2ug.org Cc: Wong, Howard Subject: RE: 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 (2) is correct, then is there any tool or utilities that can either HW (a) extract the structure and content of the database and perhaps migrate HW them to another DBMS (Unix or Windows), There are those of us (like myself and my associates) to do data migration from/to MV/Sql and we have *some* tools which make the conversion easier. The real problem is understanding your current *structure*. Although there are *tools* which can help with this it does take time to analyse. Moving from the MV world (uniVerse) to the relational world is not simple but doable .. the real work, as I mentioned is the analysis. Without good documentation on your system this will take some time. I would have to ask (not trying to sell either way), other than having an old box that needs to be replaced .. are there any other reasons for moving away from MV. Does the application do all you need it to do. Are the connectivity problems with other applications? OR are you simply looking for an 'updated' system. HW or (b) let us understand the structure and content of the DB? Once again, there are no specific tools that I know of for this process. Those of us in the business have our own tools to do this type of thing. Possibly a better understanding of where you are trying to get to would help us give a better answer. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message
RE: [U2] Getting strange error messages in Universe on AIX
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 Phantom process that executed an OS command, but did not specify the full path and was terminating. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 4:31 PM To: u2-users@listserver.u2ug.org Subject: [U2] Getting strange error messages in Universe on AIX 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 terminated. Tue Mar 15 06:23:38 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:23:39 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:24:02 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:25:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:26:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:28:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:29:01 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:30:02 0 PHANTOMU Program /bin/sh terminated. Tue Mar 15 06:30:04 0 PHANTOMU Program /bin/sh terminated. Any ideas where these may be coming from and how to stop them? Thanks! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] finding a source code file
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 direct varieties? My challenge is that I see subroutine calls in I-descriptors or programs and can't find the corresponding source code. (We have dozens of source code files.) TIA for your help. ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Sports - Sign up for Fantasy Baseball. http://baseball.fantasysports.yahoo.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] finding a source code file
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 file 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 direct varieties? My challenge is that I see subroutine calls in I-descriptors or programs and can't find the corresponding source code. (We have dozens of source code files.) TIA for your help. ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Sports - Sign up for Fantasy Baseball. http://baseball.fantasysports.yahoo.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/