RE: [U2] Two Questions

2005-03-14 Thread Brian Leach
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

RE: [U2] [UV] Web Services for Dummies

2005-03-14 Thread Brian Leach
-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

RE: [U2]: Epicor

2005-03-14 Thread Robert Paterson
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

RE: [U2]: Epicor

2005-03-14 Thread Lettau, Jeff
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

RE: [U2]: Epicor

2005-03-14 Thread Susan Joslyn
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

RE: [U2]: Epicor

2005-03-14 Thread Brutzman, Bill
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,

[U2] Include Equate record Errors Compiler

2005-03-14 Thread dsig
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] [UD] disconnected index

2005-03-14 Thread 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

[U2] IBM to Buy Ascential for $1.1 Bln

2005-03-14 Thread Thomas Derwin
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:

[U2] Ascential?

2005-03-14 Thread Gordon J Glorfield
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

[U2] Contributed papers (was: Triggers docs?)

2005-03-14 Thread Clifton Oliver
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

[U2] OT: Ascential/IBM

2005-03-14 Thread karlp
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

RE: [U2] Ascential?

2005-03-14 Thread George Smith
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

[U2] Link to IBM acquiring Ascential story

2005-03-14 Thread Clifton Oliver
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

2005-03-14 Thread Kevin King
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

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread Kevin King
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

Re: [U2] Ascential?

2005-03-14 Thread Don Kibbey
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

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread Kevin King
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]

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread Brian Leach
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

RE: [U2] [UD] disconnected index

2005-03-14 Thread Alfke, Colin
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?

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread Adrian Matthews
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

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread Andrew Lakeland
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

RE: [U2] Contributed papers (was: Triggers docs?)

2005-03-14 Thread Wendy Smoak
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,

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread dsig
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

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread dsig
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

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread dsig
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

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread dsig
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.

[U2] UV: Using UniAdmin/File Tool

2005-03-14 Thread Hennessey, Mark F.
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

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread Pingilley, Ron
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

[U2] tossing another one

2005-03-14 Thread Dan Fitzgerald
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

RE: [U2] Include Equate record Errors Compiler

2005-03-14 Thread Adrian Matthews
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

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

2005-03-14 Thread Nick Cipollina
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

[U2] [OT]- PRC Newsletter (pardon the *brief* intrustion)

2005-03-14 Thread Susan Joslyn
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,

[U2] UV - file load discrepancy found by uvfixfile

2005-03-14 Thread Hennessey, Mark F.
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.

[U2] System Builder

2005-03-14 Thread Lance Jahnke
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

RE: [U2]: Epicor

2005-03-14 Thread Susan Joslyn
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

RE: [U2] UV - file load discrepancy found by uvfixfile

2005-03-14 Thread Jeff Fitzgerald
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

RE: [U2] System Builder

2005-03-14 Thread Kevin King
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

RE: [U2]: Epicor

2005-03-14 Thread ASTARTE00
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

RE: [U2] System Builder

2005-03-14 Thread Lance Jahnke
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:

RE: [U2]: Epicor

2005-03-14 Thread Allen E. Elwood
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

RE: [U2]: Epicor

2005-03-14 Thread Brutzman, Bill
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

RE: [U2] UV - file load discrepancy found by uvfixfile

2005-03-14 Thread John Jenkins
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

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

2005-03-14 Thread Hennessey, Mark F.
Nick: snip Is there an entry in UV.ACCOUNT for the account whose file you are trying to access? /snip Yes. Field 11 is populated with the unix path to the account. It's the only entry in the record. Here's my problem. UV.ACCOUNT knows about my production account. Let's say the path in

RE: [OT][U2] IBM to Buy Ascential for $1.1 Bln

2005-03-14 Thread Ross Ferris
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:

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

2005-03-14 Thread Jim Bullock
We are having quite a bit of success writing reports with Crystal Reports, using ODBC to access our UD6 database. We have gone through the exercise of flattening files, creating new dicts, etc. It's slow, but we are usually able to get what we need. We serve up the reports to the users with

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

2005-03-14 Thread Craig Bennett
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

RE: [U2] [UD] disconnected index

2005-03-14 Thread [EMAIL PROTECTED]
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

[OT]RE: [U2] System Builder

2005-03-14 Thread Dan Fitzgerald
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

RE: [OT]RE: [U2] System Builder

2005-03-14 Thread Kevin King
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]

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

2005-03-14 Thread David Jordan
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

RE: [U2] [UD] disconnected index

2005-03-14 Thread Wally Terhune
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

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

2005-03-14 Thread Ross Ferris
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

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

2005-03-14 Thread Stuart . Boydell
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

RE: [U2]: Epicor

2005-03-14 Thread Debster
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

RE: [U2]: Epicor

2005-03-14 Thread Debster
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:

RE: [U2]: Epicor

2005-03-14 Thread Debster
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

RE: [U2]: Epicor

2005-03-14 Thread Debster
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