RE: [U2] Two Questions
Cesar, 1. Yes, you can use either: A. The BCI (Basic Calling Interface) to open an ODBC connection to SQL Server from within UniVerse BASIC. B. You can use SELECT ... TOXML ELEMENTS statements to generate XML using UniVerse SQL if you want to move static data. C. You can write a program on Windows to pass data between SQL Server and UniVerse, using OleDB and UniObjects. 2. Yes, you can use either: A. RedBack. This is the IBM product for creating Web sites using UniVerse. B. Any scripting tool that can create a UniObjects connection (e.g. ASP). C. Various commercial packages (Visage, DesignBAIS and others). This needs either a very short answer, or a very very long one. Tell us more about what you need to do. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cisar Riba Cervera Sent: 14 March 2005 07:38 To: u2-users@listserver.u2ug.org Subject: [U2] Two Questions Hello I'm have two questions 1.- There are some tools or some utility to trasspas de data from Universe to SQL Server. 2.- Can I connect to Universe from Internet? Regarts. Cisar (Spain) -- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Web Services for Dummies
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: 11 March 2005 21:00 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Web Services for Dummies Has anyone developed a web service for Universe ? Yes, I used Delphi to create an ISAPI DLL (a DLL that interfaces directly into Internet Information Server). This uses the regular Microsoft XML parser to generate and interpret SOAP and XML RPC requests and a UniObjects pool to make calls to BASIC subroutines. The key things are: I map each subroutine argument to a named type. These can be simple (string, date, integer etc) or complex types made up of simple types e.g. an Order Header, in which case each type element is mapped to field in the subroutine parameter. Repeatable types, like order lines, are mapped multivalued. The gateway DLL generates WSDL (Web Service Definition Language) to describe each subroutine that has been mapped in this way. This means that tools like Delphi and .Net can automatically generate class definitions based on the types I have defined, and the code to call the web service. I started off parsing the XML on the server, but found that there were just too many variations on the SOAP/XML formats to cater for all of them in a BASIC parser - it became too slow and top heavy. So I moved everything to the web server and it works fine. If you want to know more, contact me off line. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
Sorry Will, I'm in the UK and work a different time zone as such. But I see Martin has posted, so that should cover most requirements. Robert Paterson Technology Support Manager www.epicor.com Tel.: +44 (1344) 468231 Cell: +44 (7799) 348513 Fax: +44 (1344) 468050 E-Mail: [EMAIL PROTECTED] 1 The Arena, Downshire Way, Bracknell, Berks, UK, RG12 1PU This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 13 March 2005 17:58 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/
RE: [U2]: Epicor
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/
RE: [U2]: Epicor
Susan steps in, ugly baby on her hip Wow -- that wasn't a very strong endorsement of Epicor as a product. And I am surprised. I go to their user meetings all over the US and Europe and I have to say that there are a lot of really, really happy Avanti, Manfact and Dataflo customers around the world.I'm sure it has flaws and bugs -- I haven't met a perfect software application yet. But many people tell me that it has flexibility and functionality for many types of manufacturing and general ERP business applications that is far beyond what else is out there in the price range. But the part of this that brought me into this foray is the bit about how difficult patch releases are. This is something that I've been very involved with at Epicor. (PRC is the tool used internally and at customer site to manage the software configuration and the patches and releases.) Now granted, they don't do exactly the way I'd like them to. But they are a big company and for some silly reason they won't let me run it! Even so, I guess if they issue bug-fix documents and patch releases too frequently I can understand feeling overwhelmed. But let's face it, its a lot of software and the fact that they are working hard to keep it current is a good thing -- isn't it? One of the hallmarks of the success of the Avanti product has been Epicor's commitment to accommodating customization. To that end they have created a system for tracking, delivering and reintegrating what can be constant change. I heard recently that the ability to stay on current releases of Avanti and customize to your hearts content is well above industry standards. Most of the time you have to choose. Now -- there are some things that Avanti customers can do on their side that will help manage the constant influx of change. Things that many companies don't bother to do until the integration effort becomes cumbersome and then they may not realize how a few simple changes in procedure in-house could have a huge impact. I would be happy to elaborate on these simple changes but won't use list bandwidth on it. But get to me privately if I can help. I couldn't help but hop in, partly in defense of Epicor. Some good folks over there working hard to provide good solutions. But its more personal, too -- you may not have realized that you called my baby ugly. :) Susan Joslyn SJ+ Systems Associates, Inc. PRC (r) Real software configuration management for U2 development. Date: Sun, 13 Mar 2005 11:48:35 -0500 From: Debster [EMAIL PROTECTED] Subject: RE: [U2]: Epicor The Avante package I am working on uses UV. They seem to have Technical Bulletins on almost a bi-weekly basis of bugs within the system. The patches are a bear to install if there is even the normal end-user amount of customization on the existing system and a nightmare if it's extensive. Most of these bugs you find fixing well before the patch arrives if it's in an area that you utilize. There appears to be little to no respect for how Epicor handles support. Trying to gestimate learning curve for an individual is hard. What shortens the timeframe is the same for any package/tool. Just how familiar are you with the outside factors such as a extensive understanding of manufacturing business process flow and if you have ever utilized SB+ before. If you are unfamiliar with either than it of course extends the learning curve. I have seen both sides of the coin with other consultants at my current contract, one had extensive expertise in SB+ and very little Basic or manufacturing. The end result in his contribution was use of SB+ tools that were not utilized anywhere else within the Avante system, spaghetti in regards to the manufacturing functions, and misuse of SB+ tools where Basic was more appropriate. [Not even the illustrious SB+ guru Kevin King did that as he passed through their doors] On the other side, yet another consultant was unable to conform to the use of SB+ when appropriate. In other words, when enhancing, by conforming to the rest of the system it creates a better flow and less problems, it also strengthens your understanding of the system. I found Avante's extensive use of SB+ tools the biggest hurdle since other systems I had used it on primarily utilized it for forms and report design leaving the majority of processes to be written more in Basic. That is not the case with Avante, there is extensive use of paragraphs. I find this more cumbersome, more system use intensive with poor use causing gross inefficiencies. If you use debugger a lot to troubleshoot as I had in the past, it becomes a nightmare. You wind up using trace and display functions instead at various points to view what is actually occurring. Making sure you don't step on yourself as you pass through multiple paragraphs, screens to basic and back to the original screen depends on file use and preserving the work files utilized. Best bet when customizing Avante is to not screw too much with
RE: [U2]: Epicor
Three years ago, I did an Epicor Avante roll-out. Then, Avante ran on UniData and UniVerse, NT and Unix; I expect that it still does. It was a 400-person, annual sales $30 million UK battery comany, Hawker Eternacell, Inc., [part of www.Invensys.com] that was acquired by it's French rival, SAFT. SAFT moved the work from New Jersey to North Carolina. SAFT runs QAD there. After an in-depth review, we at Hawker settled on Avante. Other contenders [in descending order] were QAD, Glovia, Visual Mfg, Baan, and Fourth Shift. We did a big feature comparison matrix and had day-long demos from Epicor, QAD, Glovia, and Visual. The Avante installation was a major victory. Executives and end-users were rather happy with Avante and happy with Epicor. Feel free to contact me for further info... Regards, Bill Brutzman, Mgr IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 973.471.9666 [EMAIL PROTECTED] www.hkMetalCraft.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, March 11, 2005 8:52 PM To: u2-users@listserver.u2ug.org Subject: [U2]: Epicor Is anyone on this list an Epicor user ? I have a client who is examining Epicor as a possible solution to part of what they need and would like some input. Thanks Will Johnson Fast Forward --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Include Equate record Errors Compiler
Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? *** function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** ** Errors returned from the function (sql_write, sql_Read etc) will return ** with MV list of errors. mv1 will contain one of these codes ** ** NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through ** odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] disconnected index
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. Thanks, Josh Marcus University Relations, Information Systems University of California, Berkeley --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] IBM to Buy Ascential for $1.1 Bln
IBM announced this morning that it's agreed to buy software maker Ascential Software Corp. for $1.1 billion to bolster its information integration business, the companies said on Monday. For those interested in the details, there's a Reuters story at: http://news.moneycentral.msn.com/breaking/breakingnewsarticle.asp?feed=OBRDate=20050314ID=4302702 Enjoy, Tom - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Ascential?
I see that IBM is buying Ascential. Isn't that the company that broke away from VMark/Informix when IBM bought the U2 products? Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Contributed papers (was: Triggers docs?)
I think you are remembering the Files area I used to maintain, Dan. U2UG is also looking at this in light of legal ramifications of copyright, proprietary information, ability to properly vet documents for legal status, authenticity, accuracy, etc. Currently under discussion is whether or not to host (store) the papers or simply to provide a central library of links to papers people want to read. In other words, watch this space. grin -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Dan Fitzgerald wrote: Didn't there used to be a place to contribute and read docs? I poked around a bit, and didn't find one. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] OT: Ascential/IBM
I just heard a radio news spot announcing IBM had just purchased Ascential for 1 Billion US$. Hopefully that will bring development closer together..?.. -- 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] Ascential?
It sure is :) George R Smith Programmer / Analyst 479.684.3382 direct 479.684.3403 fax www.budgetext.com CONFIDENTIALITY NOTICE: The materials in this electronic mail transmission (including all attachments) are private and confidential and are the property of the sender. The information contained in the material is privileged and is intended only for the use of the named addressee(s). If you are not the intended addressee, be advised that any unauthorized disclosure, copying, distribution or the taking of any action in reliance on the contents of this material is strictly prohibited. If you received this electronic mail message in error, please immediately notify the sender by telephone at 888-869-0366 or send an electronic message to [EMAIL PROTECTED], and thereafter, destroy the electronic message immediately. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon J Glorfield Sent: Monday, March 14, 2005 10:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] Ascential? I see that IBM is buying Ascential. Isn't that the company that broke away from VMark/Informix when IBM bought the U2 products? Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- 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] Link to IBM acquiring Ascential story
Posted over on [EMAIL PROTECTED] Discussions over there, perhaps? -- Regards, Clif --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] disconnected index
Permissions, possibly? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Josh Marcus Sent: Monday, March 14, 2005 9:26 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] disconnected index 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. Thanks, Josh Marcus University Relations, Information Systems University of California, Berkeley --- 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] Include Equate record Errors Compiler
What's the possibility of a hidden character at the ^ position? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:25 AM To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? ** * function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** ** Errors returned from the function (sql_write, sql_Read etc) will return ** with MV list of errors. mv1 will contain one of these codes ** ** NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through ** odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- 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] Ascential?
Yes it is. This should prove interesting to watch over the next year or so. Hopefully our friends at Assential will remain employed or at least receive a large amount of stock options... Good Luck! On Mon, 14 Mar 2005 11:28:44 -0500, Gordon J Glorfield [EMAIL PROTECTED] wrote: I see that IBM is buying Ascential. Isn't that the company that broke away from VMark/Informix when IBM bought the U2 products? Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- 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] Include Equate record Errors Compiler
Forget my previous idea. Are you saying that if you bring in the lines from the includes into the main program (and comment out the $include lines) that it works? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:25 AM To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? ** * function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** ** Errors returned from the function (sql_write, sql_Read etc) will return ** with MV list of errors. mv1 will contain one of these codes ** ** NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through ** odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- 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] Include Equate record Errors Compiler
Dave, Just a thought - what are you using to edit the INCLUDE source? It is possible that the last line of the file does not end in a CRLF or LF (depending on the OS). I've seen that cause similar problems. If that is the case, go into each include in ED and FILE it. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 16:25 To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] disconnected index
I've only seen this when moving around files at the OS level. I certainly wouldn't trust this index and would delete and rebuild it. Colin Alfke Calgary, AB -Original Message- From: Josh Marcus 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. Thanks, Josh Marcus --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Include Equate record Errors Compiler
Make sure that the record SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV (or whatever the last include in your program is) has a correct end-of-marker. Editing and putting a blank line on the end will do it. Might not be your problem but I've had this several times in the past and the description you give fits exactly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 16:25 To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? *** function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** ** Errors returned from the function (sql_write, sql_Read etc) will return ** with MV list of errors. mv1 will contain one of these codes ** ** NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through ** odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Include Equate record Errors Compiler
Sure its that line, does it compile if you comment it out. -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: 14 March 2005 18:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Include Equate record Errors Compiler Forget my previous idea. Are you saying that if you bring in the lines from the includes into the main program (and comment out the $include lines) that it works? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:25 AM To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? ** * function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** ** Errors returned from the function (sql_write, sql_Read etc) will return ** with MV list of errors. mv1 will contain one of these codes ** ** NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through ** odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- 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] Contributed papers (was: Triggers docs?)
Dan Fitzgerald wrote: Didn't there used to be a place to contribute and read docs? I poked around a bit, and didn't find one. Speaking of contributing, you're all welcome to post anything you want to the Pick Wiki: http://www.pickwiki.com -- Wendy Smoak Applications Systems Analyst, Sr. Arizona State University, PA, IRM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Include Equate record Errors Compiler
Man I wish it was the easy .. I do most of my editing in Textpad (great editor .. using it for years) and it would show any 'hidden' character. If I comment out that line .. the error goes to the next line DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Include Equate record Errors Compiler From: Kevin King [EMAIL PROTECTED] Date: Mon, March 14, 2005 8:58 am To: u2-users@listserver.u2ug.org What's the possibility of a hidden character at the ^ position? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:25 AM To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? ** * function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** **Errors returned from the function (sql_write, sql_Read etc) will return **with MV list of errors. mv1 will contain one of these codes ** **NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through **odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- 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] Include Equate record Errors Compiler
It is possible .. I use TextPad and have for years .. but this is a new client .. who knows. I have noticed that since this problem started ... if I don't leave a blank at the end of equates the compiler will simply stop at the include. It just locks up the session and there is no way to kill the process/user/port. I now have 7 sessions (6 hung) from this mornings tracking .. I have never seen anything like this. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Include Equate record Errors Compiler From: Brian Leach [EMAIL PROTECTED] Date: Mon, March 14, 2005 9:09 am To: u2-users@listserver.u2ug.org Dave, Just a thought - what are you using to edit the INCLUDE source? It is possible that the last line of the file does not end in a CRLF or LF (depending on the OS). I've seen that cause similar problems. If that is the case, go into each include in ED and FILE it. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 16:25 To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? --- 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] Include Equate record Errors Compiler
it appears to be true that moving the equates (cut/past) into the program .. things work. I have just modified 4 routines and all is well. This started last friday and spent most all the day chasing this down. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Include Equate record Errors Compiler From: Kevin King [EMAIL PROTECTED] Date: Mon, March 14, 2005 9:03 am To: u2-users@listserver.u2ug.org Forget my previous idea. Are you saying that if you bring in the lines from the includes into the main program (and comment out the $include lines) that it works? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:25 AM To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? ** * function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** **Errors returned from the function (sql_write, sql_Read etc) will return **with MV list of errors. mv1 will contain one of these codes ** **NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through **odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- 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] Include Equate record Errors Compiler
Adrian .. thanks .. i have gone through the equates and put a blank line on them .. it appears to be ok now. Not sure why this should ever happen .. even to the point of hanging the seesion during the compile BUT as long as I know. thanks again DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Include Equate record Errors Compiler From: Adrian Matthews [EMAIL PROTECTED] Date: Mon, March 14, 2005 9:32 am To: u2-users@listserver.u2ug.org Make sure that the record SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV (or whatever the last include in your program is) has a correct end-of-marker. Editing and putting a blank line on the end will do it. Might not be your problem but I've had this several times in the past and the description you give fits exactly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 16:25 To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? *** function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** **Errors returned from the function (sql_write, sql_Read etc) will return **with MV list of errors. mv1 will contain one of these codes ** **NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through **odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be
[U2] UV: Using UniAdmin/File Tool
I wanted to use the UniAdmin File Tool feature. However when I open the Account Folder I only see files that exist 'within' the account. Most of our files are spread out away from our uv account. LISTF has no trouble showing that file XYZ is actually /dbms/subdirectory/XYZ. The VOC entry for XYZ would look like: F /dbms/subdirectory/XYZ /hist/dicts/D_XYZ Is there a way to get File Tool to see these remote files? Can file tool be run without using UniAdmin? I'm using uv 10.0.8 and UniAdmin 1.0. Also - anyone know what uvfilefix_server is? Any help would be appreciated. Mark Hennessey State of Connecticut DSS/MIS Child Support Systems Voice: 860-424-5261 Fax: 860-424-4956 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Include Equate record Errors Compiler
The compiler is a C-routine, right? Maybe if the text editor doesn't get the right end-of-file character in there, then the compiler never sees the end-of-string \0 character in the C string array, so it just keeps parsing in the next character off into the never-ending ether At least until it creates some sort of memory addressing error -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:30 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Include Equate record Errors Compiler Adrian .. thanks .. i have gone through the equates and put a blank line on them .. it appears to be ok now. Not sure why this should ever happen .. even to the point of hanging the seesion during the compile BUT as long as I know. thanks again DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Include Equate record Errors Compiler From: Adrian Matthews [EMAIL PROTECTED] Date: Mon, March 14, 2005 9:32 am To: u2-users@listserver.u2ug.org Make sure that the record SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV (or whatever the last include in your program is) has a correct end-of-marker. Editing and putting a blank line on the end will do it. Might not be your problem but I've had this several times in the past and the description you give fits exactly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 16:25 To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** ** ? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? ** ** *** function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** **Errors returned from the function (sql_write, sql_Read etc) will return **with MV list of errors. mv1 will contain one of these codes ** **NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through **odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only,
[U2] tossing another one
Hey, sweetie! I have a rumor of a chance of a possibility of a gig doing uv/odbc in Oregon. That's all I know, except that the source is as reputable as you can imagine, and the requirement is for UV ODBC experience they mentioned AIX. Shall I put you two kids in touch? Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama When buying selling are controlled by legislation, the first thing to be bought sold are the legislators - P.J. O'Rourke Dan Fitzgerald From: [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] Include Equate record Errors Compiler Date: Mon, 14 Mar 2005 11:09:27 -0700 it appears to be true that moving the equates (cut/past) into the program .. things work. I have just modified 4 routines and all is well. This started last friday and spent most all the day chasing this down. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Include Equate record Errors Compiler From: Kevin King [EMAIL PROTECTED] Date: Mon, March 14, 2005 9:03 am To: u2-users@listserver.u2ug.org Forget my previous idea. Are you saying that if you bring in the lines from the includes into the main program (and comment out the $include lines) that it works? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:25 AM To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? ** * function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** ** Errors returned from the function (sql_write, sql_Read etc) will return ** with MV list of errors. mv1 will contain one of these codes ** ** NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract:Simply holds the default login connection through ** odbc. ** **author: dsig (David Tod Sigafoos) **date:03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- 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
RE: [U2] Include Equate record Errors Compiler
It's the BASIC process itself that hangs if the end-of-file marker is incorrect. IF you kill those off it will release the session. We used to get it all the time when we first switched to using non-U2 editors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 18:12 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Include Equate record Errors Compiler It is possible .. I use TextPad and have for years .. but this is a new client .. who knows. I have noticed that since this problem started ... if I don't leave a blank at the end of equates the compiler will simply stop at the include. It just locks up the session and there is no way to kill the process/user/port. I now have 7 sessions (6 hung) from this mornings tracking .. I have never seen anything like this. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Include Equate record Errors Compiler From: Brian Leach [EMAIL PROTECTED] Date: Mon, March 14, 2005 9:09 am To: u2-users@listserver.u2ug.org Dave, Just a thought - what are you using to edit the INCLUDE source? It is possible that the last line of the file does not end in a CRLF or LF (depending on the OS). I've seen that cause similar problems. If that is the case, go into each include in ED and FILE it. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 16:25 To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: Using UniAdmin/File Tool
Is there an entry in UV.ACCOUNT for the account whose file you are trying to access? On Mon, 14 Mar 2005 13:40:50 -0500, Hennessey, Mark F. [EMAIL PROTECTED] wrote: I wanted to use the UniAdmin File Tool feature. However when I open the Account Folder I only see files that exist 'within' the account. Most of our files are spread out away from our uv account. LISTF has no trouble showing that file XYZ is actually /dbms/subdirectory/XYZ. The VOC entry for XYZ would look like: F /dbms/subdirectory/XYZ /hist/dicts/D_XYZ Is there a way to get File Tool to see these remote files? Can file tool be run without using UniAdmin? I'm using uv 10.0.8 and UniAdmin 1.0. Also - anyone know what uvfilefix_server is? Any help would be appreciated. Mark Hennessey State of Connecticut DSS/MIS Child Support Systems Voice: 860-424-5261 Fax: 860-424-4956 --- 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] [OT]- PRC Newsletter (pardon the *brief* intrustion)
Greetings. (I'll be quick -- and no replies here, please!) In cleaning up I've been a little surprised at the folks that weren't on my mailing list and should have been. The Loosely Q1 2005 edition is about to go out. If you've not been getting the PRC newsletter in the past and want it, please e.mail me. (Naturally if you get it and you don't want it, tell me!) Please reply privately to [EMAIL PROTECTED] (PRC News Source is a loosely Quarterly e.mag that covers issues of relevance to PRC users and friends.) Thanks, ducking out Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV - file load discrepancy found by uvfixfile
Does anyone have any idea what this means: Warning: file load discrepancy detected. It came from uvfixfile when it was run against a type 30 file that is performing poorly. No other errors were reported. However I can't seem to find file load referenced in the uvfixfile documentation. Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] System Builder
Before I write my own, is there a report in SB+ that will print what users have access to based on their group assignment? I have looked and I don't see anything useful. My Sarbox auditors are looking for this information. Thanks in advance. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
I can't stand it -- I have to correct. I know that Epicor's U2 product is Avante with an accent over the 'e'. My word processor knows to fix the spelling and include the accent-e. Whatever filters text for post changed e/accent to an 'i'. Makes me look foolish furiously defending a product if I don't know its name, doesn't it? Avante(accent). :) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - file load discrepancy found by uvfixfile
Mark, File load refers to the percentage full the file is and is used by dynamic (type 30) files to determine when to split and merge. The file load is compared to the SPLIT.LOAD and MERGE.LOAD parameters -- if file load SPLIT.LOAD then the current group splits; if file load MERGE.LOAD then the current group merges. If the file load is discreped up it might cause inappropriate splitting / merging or lack thereof and could certainly affect performance. I'd think a resize might be called for -- would fix the file load and also correct the file's size... Hope this helps! Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Monday, March 14, 2005 12:24 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - file load discrepancy found by uvfixfile Does anyone have any idea what this means: Warning: file load discrepancy detected. It came from uvfixfile when it was run against a type 30 file that is performing poorly. No other errors were reported. However I can't seem to find file load referenced in the uvfixfile documentation. Mark Hennessey --- 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] System Builder
Out of the box, no, there is not. We've had discussions about this kind of thing in months past over on SBSolutions. When you say what users have access to, what does this include? Processes? Menu options? Files? Fields? Tools? You might post over on the SBSolutions list, I seem to recall that others might have done this kind of thing already, though possibly not in the same way as your auditors may be needing. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lance Jahnke Sent: Monday, March 14, 2005 12:17 PM To: u2-users@listserver.u2ug.org Subject: [U2] System Builder Before I write my own, is there a report in SB+ that will print what users have access to based on their group assignment? I have looked and I don't see anything useful. My Sarbox auditors are looking for this information. Thanks in advance. --- 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
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/
RE: [U2] System Builder
Just SB Process and SB Process description e.g. I*AR.MASTER*REPORT123 and My AR Balance Report. I re-posted to sbsolutions. Thanks Kevin. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, March 14, 2005 2:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] System Builder Out of the box, no, there is not. We've had discussions about this kind of thing in months past over on SBSolutions. When you say what users have access to, what does this include? Processes? Menu options? Files? Fields? Tools? You might post over on the SBSolutions list, I seem to recall that others might have done this kind of thing already, though possibly not in the same way as your auditors may be needing. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lance Jahnke Sent: Monday, March 14, 2005 12:17 PM To: u2-users@listserver.u2ug.org Subject: [U2] System Builder Before I write my own, is there a report in SB+ that will print what users have access to based on their group assignment? I have looked and I don't see anything useful. My Sarbox auditors are looking for this information. Thanks in advance. --- 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]: 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/
RE: [U2]: Epicor
While I suppose that is true that Avante is not Tier One, Avante runs in some rather large organizations... perhaps 1000 users. Avante has quite a lot of features and functionality. I never considered Jeter to be a heavy-weight. Thus, a more meaningful analogy would be... a luxury van to a luxury bus. Let's go Mets. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 3:39 PM 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/
RE: [U2] UV - file load discrepancy found by uvfixfile
You don't mention which UniVerse version you are using there was an issue which was addressed a while ago. The file load discrepancy was an indicator and needed to be fixed (rapidly) as it could stop groups splitting (and merging??). The ones I saw went to a negative file load - and the workaround was to RESIZE. The fix was to upgrade. 10.0.19 release notes - Issue: 5195 When two different processes add records to or delete records from the same dynamic file, UniVerse no longer produces a negative load factor. Hope this helps Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: Using UniAdmin/File Tool
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/
RE: [OT][U2] IBM to Buy Ascential for $1.1 Bln
H, I wonder if this is one of the reasons why IBM doesn't distribute MITS anymore - I know the products are distinctly different, but a deal like this doesn't happen overnight Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Tuesday, 15 March 2005 3:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] IBM to Buy Ascential for $1.1 Bln IBM announced this morning that it's agreed to buy software maker Ascential Software Corp. for $1.1 billion to bolster its information integration business, the companies said on Monday. For those interested in the details, there's a Reuters story at: http://news.moneycentral.msn.com/breaking/breakingnewsarticle.asp?feed=OBR; Date=20050314ID=4302702 Enjoy, Tom - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- 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/
[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/
Re: [U2] UD: ODBC/OleDB access to selected records in a file
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? Don't do that Jim. I you have to use UniQuery, at least convert the text reports to PDF and email them to the users. Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] disconnected index
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/
[OT]RE: [U2] System Builder
There's an SB+ list? can you send me subscription link(s)? Thanks Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama When buying selling are controlled by legislation, the first thing to be bought sold are the legislators - P.J. O'Rourke Dan Fitzgerald From: Lance Jahnke [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] System Builder Date: Mon, 14 Mar 2005 15:26:17 -0600 MIME-Version: 1.0 Received: from listserver.u2ug.org ([66.98.176.5]) by mc7-f19.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 14 Mar 2005 13:33:12 -0800 Received: (from [EMAIL PROTECTED])by listserver.u2ug.org (8.11.6/8.11.6) id j2ELQxs19544for u2-users-outgoing; Mon, 14 Mar 2005 13:26:59 -0800 Received: from gabriel.angelichost.net ([EMAIL PROTECTED]) by listserver.u2ug.org (8.11.6/8.11.6) with ESMTP id j2ELQxU19538 for u2-users@listserver.u2ug.org; Mon, 14 Mar 2005 13:26:59 -0800 Received: from mail1.datalink.com (mail1.datalink.com [63.126.255.7]) by gabriel.angelichost.net (8.11.6/8.11.6) with ESMTP id j2ELQOf19475 for u2-users@listserver.u2ug.org; Mon, 14 Mar 2005 13:26:24 -0800 Received: from other.datalink.com ([192.168.1.106]) by mail1.datalink.com (Build 103 8.9.3p2/NT-8.9.3) with ESMTP id PAA07280 for u2-users@listserver.u2ug.org; Mon, 14 Mar 2005 15:25:24 -0600 X-Message-Info: pdGgd64CkwYEX8kXl8FCOsYNrRHBhjRZIZzV3wG6b2A= X-Authentication-Warning: gabriel.angelichost.net: listserver set sender to [EMAIL PROTECTED] using -f X-ClientAddr: 63.126.255.7 Content-class: urn:content-classes:message Thread-Topic: [U2] System Builder Thread-Index: AcUoym+LWIk0viI2T4uA1obntsrnMwACl7JgAAHdd5A= X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-MailScanner-SpamCheck: not spam, SpamAssassin (timed out) X-MIME-Autoconverted: from quoted-printable to 8bit by listserver.u2ug.org id j2ELQxU19539 Precedence: list Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 14 Mar 2005 21:33:12.0604 (UTC) FILETIME=[6CAC45C0:01C528DD] Just SB Process and SB Process description e.g. I*AR.MASTER*REPORT123 and My AR Balance Report. I re-posted to sbsolutions. Thanks Kevin. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, March 14, 2005 2:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] System Builder Out of the box, no, there is not. We've had discussions about this kind of thing in months past over on SBSolutions. When you say what users have access to, what does this include? Processes? Menu options? Files? Fields? Tools? You might post over on the SBSolutions list, I seem to recall that others might have done this kind of thing already, though possibly not in the same way as your auditors may be needing. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lance Jahnke Sent: Monday, March 14, 2005 12:17 PM To: u2-users@listserver.u2ug.org Subject: [U2] System Builder Before I write my own, is there a report in SB+ that will print what users have access to based on their group assignment? I have looked and I don't see anything useful. My Sarbox auditors are looking for this information. Thanks in advance. --- 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: [OT]RE: [U2] System Builder
To subscribe to the SBSolutions email list, send an email to [EMAIL PROTECTED] with one of the following in the BODY of the message: * subscribe sbsolutions (for individual delivery) * subscribe sbsolutions-digest (for a once-daily delivery) -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Monday, March 14, 2005 4:17 PM To: u2-users@listserver.u2ug.org Subject: [OT]RE: [U2] System Builder There's an SB+ list? can you send me subscription link(s)? Thanks Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama When buying selling are controlled by legislation, the first thing to be bought sold are the legislators - P.J. O'Rourke Dan Fitzgerald From: Lance Jahnke [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] System Builder Date: Mon, 14 Mar 2005 15:26:17 -0600 MIME-Version: 1.0 Received: from listserver.u2ug.org ([66.98.176.5]) by mc7-f19.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 14 Mar 2005 13:33:12 -0800 Received: (from [EMAIL PROTECTED])by listserver.u2ug.org (8.11.6/8.11.6) id j2ELQxs19544for u2-users-outgoing; Mon, 14 Mar 2005 13:26:59 -0800 Received: from gabriel.angelichost.net ([EMAIL PROTECTED]) by listserver.u2ug.org (8.11.6/8.11.6) with ESMTP id j2ELQxU19538 for u2-users@listserver.u2ug.org; Mon, 14 Mar 2005 13:26:59 -0800 Received: from mail1.datalink.com (mail1.datalink.com [63.126.255.7]) by gabriel.angelichost.net (8.11.6/8.11.6) with ESMTP id j2ELQOf19475 for u2-users@listserver.u2ug.org; Mon, 14 Mar 2005 13:26:24 -0800 Received: from other.datalink.com ([192.168.1.106]) by mail1.datalink.com (Build 103 8.9.3p2/NT-8.9.3) with ESMTP id PAA07280 for u2-users@listserver.u2ug.org; Mon, 14 Mar 2005 15:25:24 -0600 X-Message-Info: pdGgd64CkwYEX8kXl8FCOsYNrRHBhjRZIZzV3wG6b2A= X-Authentication-Warning: gabriel.angelichost.net: listserver set sender to [EMAIL PROTECTED] using -f X-ClientAddr: 63.126.255.7 Content-class: urn:content-classes:message Thread-Topic: [U2] System Builder Thread-Index: AcUoym+LWIk0viI2T4uA1obntsrnMwACl7JgAAHdd5A= X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-MailScanner-SpamCheck: not spam, SpamAssassin (timed out) X-MIME-Autoconverted: from quoted-printable to 8bit by listserver.u2ug.org id j2ELQxU19539 Precedence: list Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 14 Mar 2005 21:33:12.0604 (UTC) FILETIME=[6CAC45C0:01C528DD] Just SB Process and SB Process description e.g. I*AR.MASTER*REPORT123 and My AR Balance Report. I re-posted to sbsolutions. Thanks Kevin. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, March 14, 2005 2:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] System Builder Out of the box, no, there is not. We've had discussions about this kind of thing in months past over on SBSolutions. When you say what users have access to, what does this include? Processes? Menu options? Files? Fields? Tools? You might post over on the SBSolutions list, I seem to recall that others might have done this kind of thing already, though possibly not in the same way as your auditors may be needing. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lance Jahnke Sent: Monday, March 14, 2005 12:17 PM To: u2-users@listserver.u2ug.org Subject: [U2] System Builder Before I write my own, is there a report in SB+ that will print what users have access to based on their group assignment? I have looked and I don't see anything useful. My Sarbox auditors are looking for this information. Thanks in advance. --- 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] UD: ODBC/OleDB access to selected records in a file
Raining data has an interface with U2 and Microsoft Report Server. I have not used it, but it may make better use of the PICK facilities and you would not have to flatten files. Microsoft Report Server is not a bad product allowing reports to be produced to html, pdf and other formats, xml driven formatting, scheduling and a number of other features. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Tuesday, 15 March 2005 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD: ODBC/OleDB access to selected records in a file 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? Don't do that Jim. I you have to use UniQuery, at least convert the text reports to PDF and email them to the users. Craig --- 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
I agree. I've seen this when a user has moved an index file around at the OS level and there is a mismatch between the number of indexes recorded in the header of the primary file and the actual number of indexes in the index file. The advise to DELETE.INDEX fn ALL, and recreate and rebuild is appropriate. Wally Terhune Manager - U2 Advanced Technical Services IBM Information Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Alfke, Colin [EMAIL PROTECTED] To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] [UD] disconnected index 03/14/2005 10:14 AM Please respond to u2-users I've only seen this when moving around files at the OS level. I certainly wouldn't trust this index and would delete and rebuild it. Colin Alfke Calgary, AB -Original Message- From: Josh Marcus 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. Thanks, Josh Marcus --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic03337.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
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/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
Does UV SQL CALL syntax work for UD too? Can that be used to return the rows you need from basic or a paragraph? Stuart -Original Message- From: Jim Bullock 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. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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/
RE: [U2]: Epicor
Lemme hope that a former HK employee turned Avante rep now no longer with either company wasn't involved in the roll-out ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Monday, March 14, 2005 4:56 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2]: Epicor While I suppose that is true that Avante is not Tier One, Avante runs in some rather large organizations... perhaps 1000 users. Avante has quite a lot of features and functionality. I never considered Jeter to be a heavy-weight. Thus, a more meaningful analogy would be... a luxury van to a luxury bus. Let's go Mets. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 3:39 PM 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/
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Susan Joslyn Sent: Monday, March 14, 2005 9:11 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Susan steps in, ugly baby on her hip Wow -- that wasn't a very strong endorsement of Epicor as a product. And I am surprised. I go to their user meetings all over the US and Europe and I have to say that there are a lot of really, really happy Avanti, Manfact and Dataflo customers around the world.I'm sure it has flaws and bugs -- I haven't met a perfect software application yet. But many people tell me that it has flexibility and functionality for many types of manufacturing and general ERP business applications that is far beyond what else is out there in the price range. But the part of this that brought me into this foray is the bit about how difficult patch releases are. This is something that I've been very involved with at Epicor. (PRC is the tool used internally and at customer site to manage the software configuration and the patches and releases.) Now granted, they don't do exactly the way I'd like them to. But they are a big company and for some silly reason they won't let me run it! Even so, I guess if they issue bug-fix documents and patch releases too frequently I can understand feeling overwhelmed. But let's face it, its a lot of software and the fact that they are working hard to keep it current is a good thing -- isn't it? One of the hallmarks of the success of the Avanti product has been Epicor's commitment to accommodating customization. To that end they have created a system for tracking, delivering and reintegrating what can be constant change. I heard recently that the ability to stay on current releases of Avanti and customize to your hearts content is well above industry standards. Most of the time you have to choose. Now -- there are some things that Avanti customers can do on their side that will help manage the constant influx of change. Things that many companies don't bother to do until the integration effort becomes cumbersome and then they may not realize how a few simple changes in procedure in-house could have a huge impact. I would be happy to elaborate on these simple changes but won't use list bandwidth on it. But get to me privately if I can help. I couldn't help but hop in, partly in defense of Epicor. Some good folks over there working hard to provide good solutions. But its more personal, too -- you may not have realized that you called my baby ugly. :) Susan Joslyn SJ+ Systems Associates, Inc. PRC (r) Real software configuration management for U2 development. Date: Sun, 13 Mar 2005 11:48:35 -0500 From: Debster [EMAIL PROTECTED] Subject: RE: [U2]: Epicor The Avante package I am working on uses UV. They seem to have Technical Bulletins on almost a bi-weekly basis of bugs within the system. The patches are a bear to install if there is even the normal end-user amount of customization on the existing system and a nightmare if it's extensive. Most of these bugs you find fixing well before the
RE: [U2]: Epicor
and I'm at one of the largest installs... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Monday, March 14, 2005 4:56 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2]: Epicor While I suppose that is true that Avante is not Tier One, Avante runs in some rather large organizations... perhaps 1000 users. Avante has quite a lot of features and functionality. I never considered Jeter to be a heavy-weight. Thus, a more meaningful analogy would be... a luxury van to a luxury bus. Let's go Mets. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 3:39 PM 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/