Re: EXECUTE COMMAND CAPTURING OUTPUT
In a message dated 4/30/2004 2:07:27 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: What we have is a case where an open file error may occur and we need to have the user go back into a menu, but we do not want them to see the error. Problem is that the error is waiting for user input to continue and user thinks the session is hung up or locked, or they start hitting returns and log themselves off. If we can tell we are in capturing output, we can force the session to end the capture and return to a menu. Isn't one of the SYSTEM() values the number of nested execute levels? If so, you could check if the level is higher then zero and if so, within the target program, you could have it act differently. For example doing a STOP or ABORT instead of an INPUT. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UD] Union Query
In a message dated 4/30/2004 10:12:57 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: I have 2 files in separate accounts that are structured the same. I want to do something like: SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE 01/01/2004 NAME ADDRESS CITY STATE ZIP Is there any logic in why an id would be in ORDER.FILE versus ORDER.FILE.OTHER ? If so, maybe you could setup a distributed file so that it points at both of these files? I thought I had read of someone doing something like that. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
In a message dated 4/30/2004 10:11:05 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: 001: I 002: TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,) 003: 004: NAME 005: 25L 006: S But could'nt you do something like IF TRANS(ORDER.FILE,@ID,3,) = THEN TRANS(ORDER.FILE.CAN,@ID,3,) or something of that nature? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How far can U2 scale?
In a message dated 4/24/2004 2:32:16 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: Again, what would an 'x' be in MHZ. Or for that fact, what would a MCD spirit 600 be. One of my clients still has one and I could reference it against some of my 2.4Ghz D3 clients. There is no comparison because the 'X' was a measurement of the transaction speed, not the clock speed. There are several layers between clock speed and transaction speed. Ted was trying to measure the real-world, business needs as opposed to the propeller-head ones which MHZ measures :) My own 2 cents and a pickle. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: We need a web based Forum!
In a message dated 4/23/2004 4:16:59 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: So will the U2 user group, like to look at this solution? This would give us both a web and mail list presence and would make ALL of us happy. It will also show that this community is happy to embrace new technology when it gives benefits (explained below). James Hogan Sungard I move that we nominate James to investigate this possibility further, including testing this beta software and report back on its feasibility. Do I have a second? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: OT RE: We need a web based Forum!
In a message dated 4/23/2004 11:32:32 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: I would whole-heartedly agree with this. BUT I have never seen such an animal in action myself. I think it's mythical. Will It is not mythical, one of the forums I use works exactly like that. I'm a show-me kind-of-guy, so name the forum or post a link so we can all see that it works that way :) Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: We need a web based Forum!
In a message dated 4/22/2004 12:29:03 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Seems to me a system where *email (the list) carries on as usual *All emailed responses are submitted as forum responses *All forum responses are whooshed out to the list as email I would whole-heartedly agree with this. BUT I have never seen such an animal in action myself. I think it's mythical. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: We need a web based Forum!
In a message dated 4/21/2004 9:43:04 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: I think there are better solutions out there. For example searching the web (having web access allows staff to find solutions for your company!) I was able to find this http://phorum.org/ - Phorum is a web based message board written in PHP. Phorum is designed with high-availability and visitor ease of use in mind. Features such as mailing list integration, easy customization and simple installation make Phorum a powerful add-in to any website. It is also very common for newgroups to have mail integration e.g. http://gaffa.org/faq/faq_1_2.html I disagree that its very common to have what I posted. But I'm not sure you understood me. Let's say I'm subscribed to both the forum and its corresponding email list. If I send a message to the email list only, will it appear on the forum site? Or alternatively will it appear in the archives of the forum site? That's the question. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI as nice as character-based
In a message dated 4/19/2004 10:57:17 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: Well, perhaps not DOS or dumb terminal vendors g wanna bet ? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI as nice as character-based
In a message dated 4/20/2004 7:21:58 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Or if you want browser based cross platform - is anyone on the list using Macromedia flash to talk to U2 through web services? Brian Aren't you missing something there? Or can web services speak directly to a U2 database? And if so ... how? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Computer Languages gripe was Re: GUI as nice as character-based
In a message dated 4/20/2004 8:19:38 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: (scary how much php has moved up lately!) Actually I find it reassuring to know that PHP is still more popular than C# Brian Wasn't C# writen by a programmer who could only type 10 words a minute? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: What client platform do YOU use (Parallel to GUI thread)
In a message dated 4/20/2004 10:01:51 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: However my previous employer (7 years ago) which was based in Portland, Oregon had 90% Macs and 10% MS Windows. The accounting department had the Windows machines. Everyone else (about 200 or so) had Macs. In fact we did all of our UD/SB+ development on Macs. My understanding is that they still have that setup at the headquarters but UD/SB+ was replaced with a system utilizing Oracle. Are you saying UD/SB+ runs *natively* on Macs? Or that UD has an OS layer for Macs? Or that you used Accuterm/Wintegrate to talk to some kind of server ? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: We need a web based Forum!
In a message dated 4/20/2004 11:34:46 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Yahoo groups works this way. You can either post via the web, or from Email, and receive either web only or also via email. Of course, if the forum being used is canned, and doesn't have those options, it might be a bit more difficult to do what we want. George But if this works like boards.ancestry.com or www.genforum.com then if you post via the email, your posting does not show up integrated into the boards. So some information is lost unless we have also an archival engine that saves all emails, integrating them into archived forum posts to re-form the consistent thread Sounds pretty messy. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI as nice as character-based
In a message dated 4/20/2004 12:34:33 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: I'll accept that restatement, Will. My intent was not that there was no footprint on the client, but that the user could go to a URL and would be able to launch what they need to from there. So, shockwave is fine, Java Web Start is fine and anything else that could be installed by users going to this web page and clicking here and that is maintained something like Adobe pdf readers would be fine. Anything else that could be installed... covers a lot. So that would cover things like new fonts, flash, MrSid and other viewer plugins, RealAudio and other sound plugins, etc. So it seems you're just advocating basically a browser interface, and the caveat that anything that a programmer might realistically think a user doesn't have installed should have a link to how to install it. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI as nice as character-based
In a message dated 4/20/2004 12:43:37 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Also, IMHO the primary usefulness of a GUI (lets face it folks, we're talking about the Microsoft Windows GUI) is the fact that so many people already know how to use it. Wait do you mean the Windoze GUI that MS shamelessly stole from Macintosh ? Ok then Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: MactoPick was Re: What client platform do YOU use
In a message dated 4/20/2004 2:36:02 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: It is very creatively called MacToPick http://www.carnationsoftware.com/carnation/HT.Carn.Home.html Will Are you saying UD/SB+ runs *natively* on Macs? Or that UD has an OS layer for Macs? Or that you used Accuterm/Wintegrate to talk to some kind of server ? Will [snip] No no, UD and SB+ were running on Sun Boxes. The Macs were desktop clients. We ran an emulator from Carnation Software. The actual name escapes me right now. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Uniobjects / php
In a message dated 4/20/2004 2:20:23 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Not that I'm aware of, but if you're brave you can convince UniObjects for Java and PHP to work together. Look on http://www.pickwiki.com for more information, at least two of us here have done it. So are you saying that with Universe, Uniobjects and Java only I can have a web presence directly talking to my Universe database? Is that what you're saying? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Uniobjects / php
In a message dated 4/20/2004 3:12:12 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Do you have a specific project in mind? There are at least half a dozen ways to get U2 data to appear on a web page, the best way depends on what expertise you already have in-house and how complex the problem is. -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management -- Here's my expertise: 1) Pick BASIC 2) I can write HTML and I wrote a few javascripts! 3) I setup Apache as a web server But the problem has always been the equivalent of what mvInternet does. That is, connect Apache to Universe. So you have another idea of how to connect Apache (or really any other page server) to Universe? I don't understand what open port 80 means or whether this actually allows Apache to talk directly to Universe or whatever. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Drilling cubes was Re: Crystal Reports
In a message dated 4/19/2004 1:34:50 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Now, would anyone care to post any experiences on performance of implementing a star schema in a set of normalized U2 files and doing drill down and roll up strictly with LIST, SORT, and its options? Post numbers, not guesses. Oooo I feel dirty just reading that. Why would you normalize U2 files if you're going to use LIST and SORT ? Isn't that the whole beauty of mv that we don't HAVE To normalize ? Yes I wrote a system where I could do what Pick historically called cruising and double-clutching ... that is link to another record, and drill down into details without much effort. Of course, looking back at my collection of 500 useless utilities, I was the only one who figured out how to use it well. I tried to teach my programmers, but, well So you pull up a list of say ORDERS, you select a link field say PART 110192-5 and it allows you to see the details of that PART record which then links to SALES.HIST or BILL.OF.MATERIAL or VENDOR or whatever. So you can go down, sideways, backup, go over there, jump here, and return to where you started, still in the original list you started with. The concepts are not horribly trickly, but the implementation is a rhymes with switch. And you have to ensure that your linking fields are all built so the system can understand how to get the foreign record from the foreigh key i.e. your Tfile translates or TRANS functions have to be present. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI or Event ? as nice as character-based
In a message dated 4/19/2004 11:59:57 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Does the requirement to have no client-side setup (other than pointing a user to a web page in a std web browser) eliminate accuterm or not? If not, then does this permit drop-down boxes, combo boxes, calendars for date entry and the usual icons one might expect for various features? I'm talking about the U2 database, but the tools on the mv side need not be more than UOJ, for example (with support for update of stored fields and preferably also virtual fields as read-only). yes Dawn, Accuterm does support a web browser interface I've not worked closely with that implementation, I usually use the telnet terminal emulator thingie. But I did dink around with it slightly just to make sure it works. I would expect since its running in a browser that you could do any java thingies you do with any other page if you want Or any HTML or whatever. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI from Mv code Re: Crystal Reports
In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: For example, aligning this back to the original post, rather than attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to give the users free-form enquiry and data exploration facilities into their UV database. In our case we have replaced 300 sales analysis reports currently provided in our R5 system with a single Sales Cube - and this is one of the facilities that makes Viságe better than AccuTerm ! Warning! Salesman quote! C'mon Ross :) A dataset that includes 50 fields and I only want to see 6 on my report. So you replace that report with a cube where I (the user) have to figure out exactly what I want to see, build the proper query statement, format statement, display statement etc and then figure out how to tell the system to remember my statement so next time I don't have to THAT all again. You replaced the 300 reports, with one huge cube where you STILL have users recreating (or trying to) their original 300 reports... Users don't want to see 50 fields, they want to see the 6 fields they've been analyzing for the past 3 years ... Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI from Mv code Re: Crystal Reports
In a message dated 4/18/2004 6:08:53 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Sorry, I'm not going to publish the code here :-) suffice to say that BECAUSE we have had the luxury of time to develop Viságe, we have overcome MANY problems that face this type of technology - and this isn't even the most difficult ! There's a big difference between publish the code and explain how you do this. So are you also not willing to explain how you do this? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI from Mv code Re: Crystal Reports
In a message dated 4/18/2004 9:46:12 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: So YOU, as a developer, would construct a cube with the 6 key fields that the user is interested in. You also get to do things like define an opening view of the information - AND also the query that is used to generate the cube (BTW, did I mention that Visage has a drag'n'drop query facility :-) I don't think you understood me. There isn't the user and there isn't 6 key fields. There are 500 reports, some have three fields, some have twelve fields. The entire data set of reports in total utilizes 50 different numeric or date fields. So no I wouldn't create a cube with 6 fields. I would create a cube with 50 fields and create 500 views into it.. or your software would have to allow users to easily create and save their own views. The point being that it's not a magic bullet. I or they STILL have to create those 500 views ... Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: GUI from Mv code Re: Crystal Reports
In a message dated 4/17/2004 9:10:12 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: The tools are there to produce applications on par with anything on the market. Web interfaces via tools like Redback. UOJ, .Net PDP, or the java interfaces are all there to produce great solutions for U2. And I would like to mention Accuterm. I have built several scripts in Accuterm that do Gui like functions, and are launced from inside the mv Code. Accuterm has the ability to watch for a command that is directed at it and then take actions in Windoze. So for example, one client, has an application where they have to pull up a record in an mv screen and then listen to a person speaking (off a MP3 file) and then process the record based on that speech. So my solution was to write an accuterm script that launches Windows Media Player to the location specified from the mv code. Another script launches web requests from inside mv code, scraps the contents, and presents partial information within an mv application. All in basically a green-screen format, inside an Accuterm window. But I digress. My main point was, that the tools are here. Are you ready to learn how to use them? That's the sticking point. Will Johnson Fast Forward Technologies -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: can we stop with the pointless displays? was Re: Crystal Reports
In a message dated 4/17/2004 7:35:30 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: and had to watch the compiler meticulously display those line-by line asterisks during compiling. O speaking of that, thank you that reminds me. When doing BUILD-INDEX is it really necessary to display an asterisk with every ten items indexed? That is consuming more CPU time that doing the index! [IMHO] Get rid of it! Out! Vamoosh! Be gone with your evil self! I don't find value-added to displaying asterisks. If you must display anything, display a counter every thousand 1000 , 2000, 3000 or something or base the display on the apparent speed of the processing. Like every 5 seconds display the current count. That would help and it should be a very trivial fix. Do we have a fix it list yet up on the web site? Or can we start one? Or what? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
In a message dated 4/17/2004 6:14:32 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Perhaps we should all capitulate start to use flat CSV files ? Ross Ferris Stamina Software Visage an Evolution in Software Development Having created a system on a MAC that does use flat CSV files to mimic mv, I feel able to say ... its a pain in the butt. But a great learning experience. Doing this gave me a new understanding and appreciation for what the system programmers did when they created the mv system. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
In a message dated 4/17/2004 4:06:38 PM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
Another standard is that used by the UNLOAD.FILE.B program and its
corresponding bulk loader utility loadfile.
Here, a line beginning with other than a TAB character or one of /}, /]
or \{ contains a key value, a tab and the first element of the data dynamic
array.
A line beginning with a tab contains the first element of the next field in
the data dynamic array.
A line beginning with /} and a tab contains the next first element of the
next value in the currently-being-processed multi-valued field.
And so on
Easy for you to say.
Will
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI from Mv code Re: Crystal Reports
In a message dated 4/17/2004 4:16:06 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: A key factor that makes CUI non-portable to GUI is the embedded Input and Print statements in the code. I respectfully disagree that this is key. After all event oriented apps also have input statements I think you mean the key factor is that the programs are not event oriented. That is, on a typical GUI form I can click and fill in any field in any order, and then I submit the entire form. In a typical mv app, most programmers would write it so the inputs happen in a definite order and there is no way to change that order, on the fly. If programs were rewriten so that the inputs were all seperated from each other logically, and could be entered in any order. (Tab forward, tab back between fields, or point and click since mouse clicks are captured by accuterm and wintegrate among others). Then some of the validation (two field interactions) should be relegated to the On.SUBMIT part of the program, etc. If we could code in this fashion, then any app can be GUIized with less effort. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI from Mv code Re: Crystal Reports
In a message dated 4/17/2004 10:21:26 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: AFIK, Visage offers users a GUI in a TOTAL WINDOWS LOOK AND FEEL/BROWSER environment, without having to do a total rewrite, but a rewrite none the less, re-using some portions, perhaps, of existing code. Visage seems to be more than a user interface. It's also supposedly (sorry, Ross, I've got no experience in Visage) a much less involved NEW development environment Other MV so-called GUI approaches, (AccuTerm and wIntegrate scripts, for example) are offering the user a GUI with an almost-modern Windows look and feel, but without the bells and whistles, and are offering a GUI by applying Band-Aids to existing code. I really don't think that's a development environment.I don't think new development is covered by this approach. What? How exactly do you get this? A script is not an almost modern Windows look and feel... it is the look and feel. The script calls windows exectuables underneath it, thats how it works. If a programmer chooses not to utilize all the various objects and methods etc that Accuterm reveals, thats their own choice, not the fault of the product. I'm not sure exactly how Visage is that much better than Accuterm in that regard. Are you? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: You can use the UniVerse ODBC Driver to pull the data from UniVerse to Excel, using correct dictionaries UniVerse will normalise the data and sort out the VM and SVM for you. Jonathan can you give a exact method for sorting of SVM's within Universe using an ODBC (or really any tool). I am not aware of this Thank you Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Database decoupling (Was: Future of U2)
In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Without this ability, I see no reason why anyone would commence new application development on the U2 platform. Since you will always require another application server (Websphere, Tomcat, Bea, Jboss, etc.) to talk to the U2 server, that would in-turn interact with the database. I'm sure Mark you mean New application development that must have a web presence. Unless you feel that all application development must have a web presence. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
In a message dated 4/15/2004 6:12:27 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Will - your posting mentioned CONVERT(VM,|, mydata) - my version of UV does not seem to like that. Jim, Excel CAN read comma delimited data. Ask again why the requirement for fixed length? Excel DOES NOT NEED fixed length :) Ok now having said that. Type HELP BASIC CONVERT to see what options you have and what the syntax is for your version. Barring that, presumably you are using UV 8.0 or lower or something... Then you can achieve the same result with a loop on WhereVM = INDEX(MYSTRING,@VM,1) mystring = mystring[1,wherevm-1]:,:mystring[wherevm+1,len(mystring)] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Jbase handles multivalue on RDBMS
In a message dated 4/15/2004 9:53:43 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: And for the not so faint of heart, jBASE provides the capability to roll your own driver(s) to transform your MV database definition into the relational database without using the jEDI development kit. Tom Firl Columbia Ultimate And I can use my shoe as a hammer, but of course it doesn't work so well that way. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Database decoupling (Was: Future of U2)
I'm just not seeing a great demand for this sort of thing from the majority 10 to 100 user businesses that typically utilize multi-value products. I mean some of my clients, and myself are only just NOW playing with Triggers and transaction sets. Most application are very business oriented, and even getting them up and running with FTPing a product list to a web page, or browsing documentation in HTML or PDF format is a major leap forward. Not saying all businesses are this way. But I'm saying I don't think that is where most of the traditional multi-value market is focused. Will In a message dated 4/16/2004 1:09:48 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Well no, not really. I was thinking more in the line of New application development that would like to provide the ability to utilize modern Internet protocols. A web presence would be included in that - but was actually furthest from my mind. B2B interaction for example. Or even internal application integration. Being able to publish web services etc. etc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Database decoupling (Was: Future of U2) In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Without this ability, I see no reason why anyone would commence new application development on the U2 platform. Since you will always require another application server (Websphere, Tomcat, Bea, Jboss, etc.) to talk to the U2 server, that would in-turn interact with the database. I'm sure Mark you mean New application development that must have a web presence. Unless you feel that all application development must have a web presence. Will -- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV Crash on W2K3
In a message dated 4/16/2004 3:38:16 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: 1.is this a problem with PROCS - does anyone else run a UniVerse system on NT which relies on PROCS to launch several layers of programs? Sara can you explain this more? Perhaps with an example of exactly what you mean? Thanks Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Productivity metrics
In a message dated 4/14/2004 6:36:10 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: I've worked with the function point methods for some time and I don't think MV BASIC has been mapped. You could check with Dave Garmus, who is a central figure in FP (Google him, he comes up near the front). http://www.ifpug.org Will Johnson Fast Forward Santa Cruz Surf City -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
Jim the short answer is you can't. You can however strip all non printable characters by passing the data through OCONV(mydata, MCP) This turns all non printables into the period character . To seperate your fields, pass the data through a conversion like CONVERT(VM,|, mydata) which will turns all VM's into the vertical bar character and so on Excel has no problem with variable length fields, it has a problem with how to determine where they end. It can read standard comma-seperated data however, so pass your data through CONVERT(AM,,,mydata) to indicate where each field ends. However Multi-value data is not first normal form, it has embedded tables whenever you have VM, SVM or TM characters within one field. Excel will not understand what to do with this. For that you would need a programmer. Let me see if I know one around here Will Johnson Fast Forward Technologies -- I put the ech in tech In a message dated 4/14/2004 7:35:05 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: I am hopeful someone can offer me some guidance. I have to move data off of my Universe system and send it to a PC for inclusion in a Excel Spreadsheet. Some background: Source data is alpha/ numeric and contains VM's, SVMs and TM Source data fields are variable lengths Requirements: Output must be fixed length Output must be importable into Excel (column definitions will be based on a fixed length map) My problem: I think Excel will choke on VMs, SVMs and TM characters. Is there a standard , ASCII character that I should use to represent them? To further complicate things, sone of the fields represent data that was input with little (or no restrictions), ie. any character on the keyboard was considered valid. Thanks Jim -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
In a message dated 4/14/2004 8:29:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: If you are normalizing the data, you can dump the data into an XML format using an exploded SORT with the TOXML keyword. You can then load that directly, at least if you are running Excel 2003. Brian, not every implementation supports TOXML keyword Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Performance
In a message dated 4/8/2004 12:20:45 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: 1.) Application files have all been analyzed and sized correctly. 2.) IBM U2 support analyzed Universe files, locking, swap space and all have been adjusted accordingly or were 'ok'. 3.) We are running RAID 5, with 8G allocated for Universe 4.) We are already running nmon, which is how we identified the paging faults and high disk I/O Indexes created without suppressing NULLs -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Objectcall headache...
In a message dated 4/8/2004 8:01:13 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: We have a DataStage job which is still relying on ObjectCall (until we can rewrite it to utilise the new UniData6 stage), unfortunately, after the UniData upgrade ObjectCall ceased to function no matter what we do we just cannot get it to work again Maybe until has arrived ... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: BETWEEN in a CASE structure
In a message dated 4/8/2004 8:58:16 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Case VALL#3 = 600 I don't want to start a flame war but, to me, this falls in the category of unnecessarily complicated programming tricks. I'd kill one of my programmers who did that. Testing the end values is definitely more straight forward. Not to mention that this would fail if VAL = 600... - jmh Case (val matches ''6001N') -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: BETWEEN in a CASE structure
In a message dated 4/8/2004 12:10:33 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: And yet it is between 6000 6999. 6555.555 is another example. (There might be even more examples, but I haven't checked!) The context is integer. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Pro-4
In a message dated 4/7/2004 6:53:52 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: I'm looking for someone who maybe be able to assist with support of a customer using PRO-4 (ex McDonald Douglas ALL) I think. Support will be required in Sydney, Australia. My first job was on a Reality 800 I think it was called. Had some horrendous amount of memory like... 512k and something like 20Meg disk or whatever. (Who can remember things 20 years ago?) At any rate, when they came out with the Super Sequels it was like night and day. Imagine sorting a 50,000 item file in Ten minutes! Wow that's fast! Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Modern Universe (TESTING)
In a message dated 4/4/2004 11:28:33 PM Eastern Standard Time, [EMAIL PROTECTED] writes: The other day.. i was inspecting a UV File with a UV Developer, he ran a COUNT FILENAME on our Customer Master... (BTW Quad CPU 4GHZ)... It took 12-15 Minutes to get a result back from UV. The file only had 800,000 Records. This kind of Operation normally takes ZERO Milliseconds in any Enterprise RDBMS. I had nothing to say but LAUGH!. Joe Eugene Joe I think Zero is an exagerration. However, if this file had an INDEX on it, you could get a COUNT by merely doing a LIST-INDEX filename indexname someoptions One of the output is the number of items indexed for each index entry, the total is identical to the number of records in the file. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Modern Universe (TESTING)
In a message dated 4/4/2004 11:30:24 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Personally I would be surprised if either database had a way of handling leading wildcards other than an exhaustive scan. Use Contains/English Query. See MS-SQL Server Docs. Joe Eugene Joe you didn't understand my point. What I was saying wasn't whether you could FORM a query to do this, but rather exactly HOW the query would be executed (in the run engine). What I was saying is a query on trailing wildcards does not need to do an exhaustive scan, since BRAD PITT doesn't match SARA% and you can tell right away that it doesn't, you don't have to read the whole entry to determine that. However to determine if ABERCROMBIE matches %CROMBIE you DO have to read the entire entry. And in fact you have to read every index entry. Whereas with SARA% you only need to read those entries that start with SARA% and in a B-Tree these are clumped together, not spread out all over the tree. With leading wildcards, the index entries that may match could be spread out all over the tree nodes, there's no way to tell. -Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Modern Universe (TESTING)
In a message dated 4/4/2004 9:11:10 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: One thing I think everyone's missed (deliberately or otherwise) wildcard (WHERE address LIKE '%EXPLORATION'). I brought this up a couple of times, nobody seemed to be interested to check the difference. Joe Eugene Personally I would be surprised if either database had a way of handling leading wildcards other than an exhaustive scan. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Humour: was Re: Conversions
In a message dated 4/2/2004 10:06:39 PM Pacific Standard Time, [EMAIL PROTECTED] writes: Tony, Stupid question... If you and I built a company which was strictly Hey my name's not Tony but if there's money involved you can call me anything you want. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: XML or WORD Format???
In a message dated 4/1/2004 5:40:16 PM Pacific Standard Time, [EMAIL PROTECTED] writes: The resulting documents can be re-purposed with a variety of applications, including word processors and screen reader software. Is re-purposed the same as read because if it is I prefer read Will newspeak Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to launch remote browser from UniVerse server?
In a message dated 4/2/2004 5:27:20 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. Bruce the Help on QVT might indicate the ability to run scripts, launch windows, etc so that's where to start. However, there are two very different requirements for web content. One is to launch a browser so that a human can view, interact, manipulate that window. The other requirement is merely to get the web page contents INTO your MV (Unidata) environment. For this latter requirement, you do not need to launch a browser then scrape it. So would just getting the contents into your app be sufficient? Or do you need the user to interact with the window in some way? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to launch remote browser from UniVerse server?
In a message dated 4/2/2004 5:27:20 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. Bruce the Help on QVT might indicate the ability to run scripts, launch windows, etc so that's where to start. However, there are two very different requirements for web content. One is to launch a browser so that a human can view, interact, manipulate that window. The other requirement is merely to get the web page contents INTO your MV (Unidata) environment. For this latter requirement, you do not need to launch a browser then scrape it. So would just getting the contents into your app be sufficient? Or do you need the user to interact with the window in some way? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to launch remote browser from UniVerse server?
In a message dated 4/2/2004 5:52:10 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I've created the html file from a spooled hold file and placed it in a Samba drive, but the icing on the cake would for the user to generate the file and launch the browser from within the unidata session. QVT/Term Help does not mention anything about launching windows, and the scripts seem limited to starting up QVT/Term sessions. It may not be a really fully featured emulator. Is there any barrier to moving to Accuterm or Wintegrate? You could at least do a proof-of-concept with one of them and present it to your bean counters to see if they'd go for it. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Modern Universe - was: The lists are closing
In a message dated 3/30/2004 12:35:32 AM Eastern Standard Time, [EMAIL PROTECTED] writes: You are partly correct when you say UV treats all data as strings. However, if the UV programmer is careful he/she can get it to do maths processing. Variables within UVBasic are string unless the result of an expression is numeric whereby it becomes numeric. UV stores numeric data such as dates, time and numbers as a string value with no decimal point etc. quite deliberately. Trevor partly right. However the MvBASIC statement A = 1 makes the variable A into a numeric typed datum. I'm not sure you could say this is the result of an expression being mathematical, after all Store is both a string and a numeric command. The system converts the loading of a purely numeric argument into a LOADN or STOREN type command on some MV systems, which the loading of a string is a LOAD or LOADS or STORES or something similar to that. Of course the programmer just says A = 1 or A = DOG and doesn't have to worry about how the argument is typed in the run engine. Run Engine Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The lists are closing
In a message dated 3/30/2004 5:18:37 AM Eastern Standard Time, [EMAIL PROTECTED] writes: Listen, Will the blind, deaf and possibly dumb Johnson Are you hearing nothing? Please don't start insulting me you ignorant fat slob. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The lists are closing
In a message dated 3/30/2004 11:02:13 AM Eastern Standard Time, [EMAIL PROTECTED] writes: 6. The U2UG web site has U2 fora as the means of communication, something which people have been asking for for a long time. The decision to start the fora was made when the lists were also available so it was then considered as something in addition to, not instead of, the lists. It is possible to setup forums in such a way that: 1) You can respond in the forum OR 2) You can respond via email I am subscribed to some genealogy lists that work exactly this way. We get postings via emil (if subscribed) on every post that goes into the forum. You can respond to the email directly OR you can click a link and go back to the forum and respond in the forum. So there Will Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: U2UG Contract
In a message dated 3/30/2004 11:24:36 AM Eastern Standard Time, [EMAIL PROTECTED] writes: There have been *zero* discussions as to what our TOS should be other than to make sure that we indemnify U2UG from copywrite issues. If you are concerned about the wording of any part of the TOS suggest an alternative wording. All postings to this forum remain the sole property of the poster. Postings however can be copied, observing US copyright law, for non-profit purposes. U2ug does not take any responsbility for any postings to this forum. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Modern Universe - was: The lists are closing
In a message dated 3/30/2004 7:34:27 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Trevor, I *think* the issue is that the mv runtime does typecast variables on the fly, transparently. Which means that assigning a number or the result of a numeric expression (AVAR = 1 * 3) results in AVAR becoming an Integer variable. If you then say something 'string-ish' (AVAR = The answer is : AVAR) then the variable is recast on the fly into a String variable. - Charles Constant Barouch Chuck (if that is your real name) yes you are correct. The runtime engine recasts on the fly, but it leaves the recast variable as the new type until required to change it so A = 1 ; * a is cast as numeric PRINT Hello world ; * A is still numeric A = A:stuff ; * A is now recast as a string OPEN MYFILE TO XXX ; * A is still a string A = A + 0 ; * A is now recast as a numeric again My point is that any intervening operations on other variables don't change the last casting of A, only a forced become a string! or become a numeric! will recast it. Recasting beings in ten minutes Will Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Data typing in MV Basic
In a message dated 3/30/2004 8:19:18 PM Pacific Standard Time, [EMAIL PROTECTED] writes: A = 1 assigns a numeric integer. The expression need not contain operators (+,-,etc) to be numeric. A = 1 assigns a string however, as you have explicitly declared it to be string. A = 1 + 2 assigns a numeric integer value (3) as the result is numeric. A = one + 2 assigns a zero - according to the error message. yes no yes yes they all assign numerics imho 1 is cast as a numeric because the system is smart enough to realize its a numeric string and has no purpose casting it as a string Any idea how to test which it is? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The lists are closing
1) We DO want to leave the archives at indexinfocus. 2) We DONT want to replicate the archives onto u2ug 3) We DONT want the lists to continue Go to the web site, and enter each forum you are interested in and click on SUBSCRIBE this will make all responses come to your email box just as they do now. You can register, but if you dont SUBSCRIBE you wont be seeing nothing Will In a message dated 3/29/2004 11:02:57 AM Eastern Standard Time, [EMAIL PROTECTED] writes: The archives for the lists (which go back to the mid-90's) would remain for now at http://www.indexinfocus.com. But I don't yet see a way to go forward on our site archiving the IBM web content so they'd be static. We do plan real soon now to add other content. Is there a general opinion that the email lists should continue? How can we avoid then having two separate, disconnected places for information -- the list and the U2UG forums? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Modern Universe - was: The lists are closing
In a message dated 3/29/2004 11:07:24 AM Eastern Standard Time, [EMAIL PROTECTED] writes: 1. Populate UV and Oracle with around 10 Million records. 2. Write fairly complex Web Application against it. 3. Run a Web Application Stress tool(around 1000 Users) switching Databases within the same DB Machine. You don't have to be a scientist to look at Performance Monitor. That's an excellent suggestion JOE Can you please tell me how to write an interface from Apache to Universe ? Or something similiar? Because I'm too ignorant to know how to connect my Universe 9.4 to the web Thanks for your superior intellect that can solve issues like this PURELY in Universe BASIC (of course) since you're saying its Universe that is the problem here. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Modern Universe - was: The lists are closing
In a message dated 3/29/2004 11:27:02 AM Eastern Standard Time, [EMAIL PROTECTED] writes: e.g. We pull XML Reports from our Vendors Real Time. I have to parse through the XML and give UV/PICK Guys a FLAT TEXT File... cause either UV Cannot handle the storage and Retrival of XML Data Using XPath/XQuery Techniques. Joe there is a big difference between these two statements: 1) Our UV programmers DONT KNOW how to handle XML and 2) UV cant handle XML Ever think maybe your company should spend a little money getting programmers who DO know how to make UV understand XML? Your being cheap is not our failure. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: What are embedded databases
In a message dated 3/29/2004 11:55:51 AM Eastern Standard Time, [EMAIL PROTECTED] writes: embedded data base support The other day, someone asked me if I used an embedded database. And I was like ... what? Can someone give ten words or less of what an embedded database is? And then maybe an example of a database that is NOT embedded? Thanks Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[OT] Joe Eugene was Re: Modern Universe - was: The lists are closing
Please Speak LOUDER!!! *throws you a raw steak* Will raw steak Johnson In a message dated 3/29/2004 12:26:29 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Going MainStream and staying with BIG THREE is Better for the future of the Company's Needs. BIG THREE has A LOT OF INVESTMENT in RD and they are constantly on TOP OF TECHNOLOGY!. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: COMMON Variable.
In a message dated 3/29/2004 1:11:11 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Is there a way to pass some common variable to a Phantom program - which will be called using EXECUTE 'PHANTOM '. I've even tried named COMMON and it lost its value. Yes Carolina. There are a few ways 1) EXECUTE PHANTOM some other stuff interpreted as variables 2) MYSTUFF = here are some more arguments WRITE MYSTUFF TO FILE, ITEM EXECUTE PHANTOM (which starts by reading MYSTUFF) 3) disconnected processes process A writes stuff and moves on process B at some other disconnected time EXECUTE PHANTON which reads the stuff writen by process A five minutes or five days ago 4) process A, B, C, D, E, etc write various stuff at various times process P starts the PHANTOM at boot time and it runs forever. The phantom periodically wakes up and looks for something to do, does it, then goes to sleep for a minute or so. Will Phantom Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Question for Donald Kibbey
In a message dated 3/29/2004 2:28:38 PM Eastern Standard Time, [EMAIL PROTECTED] writes: George, the best commercial integration option available for MV right now is the Pick Data Provider .NET from Raining Data. But doesn't .NET take up like a gazillion bytes of space? And doesn't integration require an object? As in... integration with .. what? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Question for Donald Kibbey
MvBase? I think he was saying best provider for MV not for MvBase Right? And I didn't say it, he did. Will the real Will not the fake posing Will's Johnson In a message dated 3/29/2004 3:09:59 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Will, Unless something has changed since Friday, Raining Data's .NET provider does not connect to mvBase. There are only 10 people in the world who understand binary and I am not one of them. George Smith [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 29, 2004 1:57 PM To: U2 Users Discussion List Subject: Re: Question for Donald Kibbey In a message dated 3/29/2004 2:28:38 PM Eastern Standard Time, [EMAIL PROTECTED] writes: George, the best commercial integration option available for MV right now is the Pick Data Provider .NET from Raining Data. But doesn't .NET take up like a gazillion bytes of space? And doesn't integration require an object? As in... integration with .. what? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Question for Donald Kibbey
In a message dated 3/29/2004 3:15:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I don't really know what you are after with the integration requiring an object. Can you be more specific? Regards, Jim Yes. Integrate as a verb I think applies to mathematics. But if I say My software integrates well I think most people would think A) you have math software ? or B) Your English is bad? Integrate in this sense requires a with and then an object with which it integrates. In other words My software integrates well with SAP, not just My software integrates well. Unless of course you are a salesman who was merely told to repeat that line and hope no one calls you out on it. Will Calling you Out Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VB / SQL questions
OK thanks for the heads up on using SQL INSERT and UPDATE instead of ADO Recordsets and also using the Prepared property. That made my program run about 7 times faster. Can someone tell me why I need INSERT INTO test([field1], field2 instead of INSERT INTO test(field1, field2 in other words what is the [] doing? I never saw that in any examples yet the SQL builder/browser thingie puts it in if I build the statement using it. AND putting it into my program fixed a nasty bug about SQL syntax. But... what is it doing? What does it mean? Also on a seperate note, here is a snippet of what I am doing and would appreciate any comments. Please realize this is only a snippet, not the whole program. Do I need that first open in order to set up cnn1? b = Will Set cnn1 = CurrentProject.Connection Set adocmd = New adodb.Command Set adocmd.ActiveConnection = cnn1 adocmd.Prepared = True openmsg$ = Select * from test Set rstTest = New adodb.Recordset rstTest.CursorType = adOpenKeyset rstTest.LockType = adLockBatchOptimistic rstTest.open openmsg$,cnn1 execmsg = SELECT * from test where Field1 = ' b ' adocmd.CommandText = execmsg Set rstTest = adocmd.Execute() If rstTest.BOF = True then cntnew = cntnew + 1 *dostuff for new records Else cntold = cntold + 1 *dostuff for old records End -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[OT] Airplane flights and stuff was Re: Optimisation ?
The Russians flew an aircraft in 1857! No no the Japanese had one flying in 1831! So? The Chinese flew one in 731 In a message dated 3/26/2004 9:10:14 AM Eastern Standard Time, [EMAIL PROTECTED] writes: I knew this!!! I believe there was also a New Zealander, Richard Pearce, who is eye witnessed to have flown in March 1903. Check out: http://www.nzedge.com/heroes/pearse.html At 03:02 AM 03/26/2004, you wrote: Did you know the Americans weren't even the first to build a successful aeroplane? The first aircraft built that flew successfully (note my strange word order :-) was built in 1896, in England. Unfortunately, it had to be rebuilt, and the first successful flight was (iirc) 1912. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Memory resident hash tables/files
In a message dated 3/23/2004 2:05:41 AM Eastern Standard Time, [EMAIL PROTECTED] writes: I would like to store records from small static parameter files that are accessed frequently in a memory resident hash table in the common area. What would it take to achieve this in UV BASIC? What would it take for IBM to introduce internal hashtable type variables (such as those found in some C++ class libraries) in UV. Yes you can effectively. Write one Phantom routine that selects these files, one by one and loops through every record just reading it then moving on. This will smoothly keep the records in memory even if your actual user-accessing of them is chunky. And yes you can create your own internal hashtable. Just DIM an array to the modulo you want and then apply the standard routine to determine which cell your id goes to and put it there or get it from there. Will smooth not chunky Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
In a message dated 3/18/2004 3:26:32 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Sent: 17 March 2004 19:40 To: U2 Users Discussion List Subject: Re: Setting up SQL step 1 Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. Okay remember that on the test server I had said the two UV_USERS were NT Authority\System and Primo\Administrator. The test server is Tregundo and Primo is another server. So now on the test server, we reinstalled Universe 10 and this time it created two UV_USERS as NT Authority\System and Tregundo\Administrator. Now logging on as administrator I was able to GRANT CONNECT to Will.Johnson and also GRANT DBA to Will.Johnson So it seems like two things. One when it was setup initially maybe the server names were subsequently changed and two this was enough to confuse the hell out of SQL. Reinstalling, like you suggested, just reinstalls the UV account, doesn't overwrite files in other accounts and so that worked out fine. And it fixed the UV_USERS file. Another thing I found out was that, only in one obscure location in the documentation (and NOT in the online HELP command documentation) it states that a TRIGGER program must be globally catalogued. I think it also says it can be normally (but not locally) catalogued but that didn't seem to work. On a PICK flavor account you cannot, as far as I could figure globally catalog. I tried what the documentation said and it didn't work. So I had to log to uv, create a Q pointer to the BASIC program file on the other account, then globally catalog it. Also in order for changes to your trigger to take affect you have to DROP TRIGGER, then globally catalog, the CREATE TRIGGER once more. Will battle scarred Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. Okay it sounds like this might be related. On machine 1 which is called PRIMO the UV_USERS file says the user is OSP\Administrator While on machine 2 which is called TREGUNDO the UV_USERS file says the user is PRIMO\Administrator. So I would guess that possibly based on what you said, if I reinstall the upgrade tape on TREGUNDO maybe it will helpfully ask me what the admin user is and I either: 1) I can say TREGUNDO\Administrator or 2) I can say just Adminstrator and it will put the TREGUNDO (domain name) part in front for me. I did try logging on AS PRIMO\Administrator with the explicit domain name as part of the login and it still didn't work. But at least this other idea is a possibility. Maybe one of the things the board should ask is for IBM to assign a helpdesk person TO this list :) Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help Needed regarding performance improvement of delete query
In a message dated 3/15/2004 9:54:01 AM Eastern Standard Time, [EMAIL PROTECTED] writes: 10 READNEXT ID ELSE STOP READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10 IF DTE GT DEL.DATE THEN GOTO 10 DELETE F.MASTER, ID DELETE F.REFERENCE, ID GOTO 10 I count three goto's So three times through the spank machine. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help Needed regarding performance improvement of delete query
Gives Mark the most improved player award. Will In a message dated 3/16/2004 5:07:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: LOOP WHILE READNEXT ID DO READV DTE FROM F.MASTER, ID, 5 THEN IF DTE LE DEL.DATE THEN DELETE F.MASTER, ID DELETE F.REFERENCE, ID END END REPEAT there you go (to). -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Looking for associated multi-value algorithm...
It looks like you are using SPECIAL and STARTPOS as paired dummy buffers to walk across the SPECIAL.PARTS, each iteration only searching the remainder from where you left off. That's a little counter-intuitive :) Maybe better nomenclature would make that more apparent. Like Startpos and Currentpos ? I can see why you got this response however, because at first I thought you were wrong again Jason ;) then I read the code again and it hit me what you were doing. Will In a message dated 3/16/2004 6:04:48 PM Eastern Standard Time, [EMAIL PROTECTED] writes: There can, and usually are, multiple instances of the same part number. What makes a row unique is part number + from qty. Thanks for pointing out the doubling up of the SPECIAL.FROM.QTY assignment though. -Original Message- From: Jeff Fitzgerald [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 4:28 PM To: 'U2 Users Discussion List' Subject: RE: Looking for associated multi-value algorithm... Well, the first thing I notice is that your for/next counter, SPECIALPART, isn't used anywhere... Using LOCATE will search for the PART.NBR in the whole SPECIAL.PARTS field, so the for/next isn't needed. Next, I notice that this assignment: SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL is duplicated, once just before the IF and once just after the THEN. One of them can probably be dropped. Hope this helps some Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 3:18 PM To: [EMAIL PROTECTED] Subject: Looking for associated multi-value algorithm... I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to return is the Unit Price (F16) given PART.NBR and QTY.REQUESTED. I've got a code snippet of what I think will work, but I'd like to get some feedback on it...it won't work because, there's a better way of doing this, etc. Thanks. SPECIAL.PARTS = SPECIAL.REC12 SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM) SPECIAL.FROM.QTY.TEMP = 0 FOR SPECIALPART = 1 TO SPECIALCOUNT LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE EXIT SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTYQTY.REQUESTED AND SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) R#12 SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END STARTPOS = SPECIAL + 1 FIRST = 0 NEXT SPECIALPART DATA.OUT=TEMP.OUT RETURN -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
I have a client who has never used SQL on their system and I'd like to set it up. It is a Universe 10.0 on Windows setup. When I look at UV_Users I see two users one is NT Authority/System and the other is OSP/administrator My first question is: Is there really a windows login called System ? Can a person log in as system? I have tried various ways to log in as administrator and cannot seem to let it GRANT DBA to Will.Johnson whenever I try it just complains that administrator is not an SQL user or something like that. So what could be wrong? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Mvquery Client Not Responding
In a message dated 3/11/2004 8:12:17 AM Pacific Standard Time, [EMAIL PROTECTED] writes: 1. Please do not post mvQuery questions to this list. Either send them to your mvQuery supplier, or to mvquery support. I'm going to buy mvQuery just so I can post twelve questions a day on it to this list. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse 10 :Network writes not allowed within a transacton.
In a message dated 3/6/2004 10:54:23 PM Pacific Standard Time, [EMAIL PROTECTED] writes: As far as I know, the u2 databases and some other Pick-like databases do support some TPM connectivity, but are currently lacking the full functionality required for the phases of 2pc. That's not true. You could say, there is no widely accepted and implemented method of doing it. However you can roll your own. I've done it. Will If you can roll it, you can smoke it Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Brower based terminal emulator
In a message dated 3/5/2004 5:58:24 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Fire up an xterm, or konsole, or whatever you fancy, on the client desktop. Telnet into the uv server, SET.TERM.TYPE VT100, and off you go. And you're confident that any old xterm, konsole, or whatever will ACCURATELY emulate every feature of vt100 ? I think you will find that some of the more obscure features are not really implemented that well in most emulators. At least I did. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VB primer help ?
In a universe database I have a file Customers. In an Access database I have some of the fields of that same file as well, populated from the source universe file via a flat file transport and import. Now however I need to just update those rows that have changed. So in Universe I already have a way (I think) to find just what's changed and make a flat file. So now I want to just load those changes to the Access database. So I figured out how to open a macro and played around with the VB language somewhat but I wonder if someone could give me a few lines of help. I can already open the flat file in VB and read a line out of it. I can also open the access database in VB and read a row/field out of that. I figured that out so far. The flat file will have as its first field the primary key which is already setup to match between the uv and access files. So what I want to do is select the row with that key, which I already know how to do. But the part I'm getting stuck on is how exactly do you do the update? I tried something like this file!field = newvalue file.update and it complains along the lines of that process cannot do that function or something like that. Maybe one of you has a trivial example of updating a row in a VB macro? All the examples I can find are doing it using a macro EXTERNAL to the database, when the one I'm using is run from inside the project... did that make sense? Anyway... Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Ever wondered how something works...
In a message dated 3/3/2004 10:03:01 PM Pacific Standard Time, [EMAIL PROTECTED] writes: Even quicker, who [Enter] Regards T. Are you sure? I think on native pick systems you can use any command. However on Universe you have to use a command that actually uses up a select list. Since who is a Type 1 verb it neither expects, nor consumes a select list, so I have to think the list will still be active after the WHO is completed. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Pick AP-Pro Discs
In a message dated 2/29/2004 7:42:56 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I would like to acquire or purchase the complete box, manual and all diskettes for an older Pick AP-Pro system or someone's retired AP-Pro system (133-166 P1 preferably). I only need 3-5 users. I think the minimum is 3. I have a new client that I want to break into the Pick world with an inexpensive application to start. I can develop their new app on my own AP-Pro yet in 2 months they will want their own system. We've explored the concepts of a W2K/D3 or U2 box and its cost would kill the deal. I want to get my foot in the door and as they grow, we can convert later. How about an Adds Mentor 1800 ? Will Johnson Fast Forward Technologies -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Printing to local printer
In a message dated 2/26/2004 12:07:35 PM Pacific Standard Time, [EMAIL PROTECTED] writes: We use AUX ON / AUX OFF for local printers already. The problem is, we want to be able to specify which local printer to use as the AUX. So, when the user is printing a CC receipt, it would print to the printer attached to the PC that is defined as the CC receipt printer. But, when the user is trying to print a report, it would print to the local laser printer (which could also be a networked printer). One way to do this is to have the user switch the local printer within SmartTerm, but we wanted to try to handle this in the software, if possible, because...well, you know how users are. Dana I'm a little confused. You are using local printers using Aux on/Aux off. This means that the printer must be directly connected to the terminal/PC right? So I thought it sounded like you wanted to have two printers directly attached to one terminal/PC. If this is *not* what you want to do, then why not just network all your printers? If it *is* what you want, you also have the option of using two serial ports off your terminal/PC. Some terminals have two serial and one parallel port as well. And for PCs you can always add another serial or parallel card to add another port. So can you tell us how many CC printers you have, and can each device that needs to print to one have its own? Or do you have something like 100 terminals wanted to print and only 12 CC printers? Thanks Will Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: WinteGrate
In a message dated 2/21/2004 10:23:37 AM Pacific Standard Time, [EMAIL PROTECTED] writes: A simpler way would be: PCFILE=C:\FOLDER\PICTURE.JPEG CALL WIN.PCRUN(IEXPLORE, PCFILE) It opens up a new window with the aforementioned picture. Of course you assume the system has such a command CALL WIN.PCRUN and you are opening up the same picture over and over using that. I was specifying a way to open whatever picture UNIVERSE wants to open, as opposed to whatever picture WINDOWS wants to open. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Swap array values? In UV
In a message dated 2/13/2004 11:10:14 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Within BASIC, try array(x)=BITXOR(array(x),array(y)); array(y)=BITXOR(array(y),array(x)); array(x)=BITXOR(array(x),array(y)); No temp variable used. ROFL. Nice way to take a simple process and make it unintelligible. You get the gold ribbon. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Hashing Algorithm
In a message dated 2/13/2004 6:18:30 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I have the algorithms (from a legal source long before IBM acquired the product) but because they are now secret I cannot divulge the details. They are, however, extremely simple except for the dynamic algortihms which are rather more exciting. That's a interesting question. I have to say that in general IMHO a company cannot retroactively seize control of something that at one time was freely available. Something in the US about seizure without a warrant? Bill of rights or something? Will I'm not a lawyer, but I play one on the Internet Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The result of VARIABLE[1,3] + 0
In a message dated 2/2/2004 9:06:43 AM Eastern Standard Time, [EMAIL PROTECTED] writes: It's been affirmed here and other places that MV considers everything as a text variable (keep file handles and arrays out of this discussion) and its numerological properties come into play only when we expect it to behave as a number. No that's not so. There is a numeric variable (internally stored), in MV. It is not a string and only translated to a number when needed, rather it's a number. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Proc or Para
In a message dated 2/4/2004 11:40:41 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Earlier PQ proc didn't have read/write so they developed a sideline language called BATCH which did these tasks. BATCH is officially removed from the direct decendancy of R80/83 as D3 doesn't recognize it and i haven't seen it on any U2 systems. RPL, which predates this further never made it past the mid 1970's. Actually RPL was alive and well into, at least, the early 80s. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The result of VARIABLE[1,3] + 0
There is a numeric type or datum as some people call it. Since we are talking MV here and not specifically one vendor. If you look at the opcode of an ADDS machine there is a code for LOADS (string) and also a seperate one for LOADN (numeric). This implies that there are in fact two seperate types of variables. If you inquire into the frame where the variable map is being stored as it's running (workspace not object code) you will see that yes a string variable starts with a 09 and a numeric I forgot I think its a 01 or 02 ... At any rate, its not stored as a string while running, but rather I believe its probably stored based on whatever the last action was on it. A numeric action returns a numeric value and is stored as a numeric. A string action like concatenation would probably switch it to be stored, at that moment, at any rate, as a string. I didn't test *this* behaviour explicitly, so I'm not quite sure. Will In a message dated 2/6/2004 3:29:01 PM Eastern Standard Time, [EMAIL PROTECTED] writes: It's been affirmed here and other places that MV considers everything as a text variable (keep file handles and arrays out of this discussion) and its numerological properties come into play only when we expect it to behave as a number. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
