RE: Input weirdo...
Thanks Mark! Bjorn managed to find his reply (in an Advanced Pick manual) just after I'd sent the request, which kinda worked, but not exactly, but your length of inputbuffer works a charm. Speaking of these SYSTEM thangs - is there anywhere I can get a list of all the settings / variables included in SYSTEM(x)? -Original Message- [snip] SYSTEM(14) is the length of the typeahead buffer. D3 for sure and possibly UV/UD. The CLEARSELECT is UV/UD specific. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How far can U2 scale?
In reply to what Steve wrote re: app level problems with scability: In a way you're right, in that an app written for small scale systems cannot easily be scaled upward to infinity without having serious bottleneck issues. No matter what tool (read language/RAD/whatever) is used, if the design has built in toe-jammers, it simply aint gonna work. However, if the designers knew upfront what scale to aim at, it's easy. Keys are prefixed with some kind of sub-structure label to break-down the scale to managable levels, eg branch, warehouse, or if requiring specifically numeric, ranges of number are set for each sub-structure, eg 100,000 - 200,000 for New Jersey, with scalability built in with the same number range for each million increase, eg 1,100,000 - 1,200,000, 2,100,000 - 2,200,000, etc (many ways to skin said cat) The thing about bad design is that its faults exponentially increase by number of users. Bigger hardware doesn't help. Developers with tunnel vision don't help. Most of all, patch jobs don't help. Then again, if weren't for all these, we wouldn't have jobs. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Input weirdo...
We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: We need a web based Forum!
I think I have found the holy grail! Mr Hogan, Sir I do believe you have it... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: RE: We need a web based Forum!
It's been pointed out to me that my request for another position might have been taken in a light hearted manner It wasn't so intended! You don't have any positions vacant in sunny douglas do you? Anyone else? Anywhere in Africa? Preferably South Africa. Promise I'll be quiet as a mouse, and churn out lotsa useful utilities, plus any amount of real work... :-) -Original Message- From: Dennis Bartlett [mailto:[EMAIL PROTECTED] Sent: 21 April 2004 12:01 To: 'U2 Users Discussion List' Subject: OT: veryy OT: RE: We need a web based Forum! Schalk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: We need a web based Forum!
Definitely an honourable reply. The thing is tho', that if they don't do it in the most accepted/requested way, they'll have more hassle in the long run, forever being bombarded with petty whinging. 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 would work. Where you get this, how you write it, what bean you imbibe whilst contemplating it, is beyond me. I salute those who have shouldered the dragon, the feeding of which I fear may become an all-consuming task. Design it (him/her/Puff) well, feed it regularly, clean up the mountainous excretia, hell,even get the right fit for its racing leathers and pray it doesn't burn you, and all should bode well for a long and happy future. Puff? Hmm... Puff the Magic Dragon??? . (P)ost(U)2-Userlist(F)riends of the (F)orum Ok, so that's a little limp. Your turn... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kate Stanton Sent: 22 April 2004 01:36 To: U2 Users Discussion List Subject: Re: We need a web based Forum! Thanks. Sounds to me as though it should be the choice of whoever is shouldering the responsibility of looking after it. If they are prepared to do the work, then I applaud them and am privileged to be able to use it, in whatever way they choose. Cheers, Kate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: GUI as nice as character-based
Schalk, you don't have to send the screen layout up and down the lines - have locally installed GUI apps, pointing to remote site data. When the program loads up, it gets all it's programming power from the local workstation, and data transfer is at a minimum. I know this is a nirvana, and a real drag to implement on legacy systems, but it can be done. One solution I saw was to have every possible screen display / prompt string stored in files (this app was a library system, and different language interfaces were stored). These storage files were stored locally on LAN drives, with the data stored at one central place. It worked a bomb. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl Sent: 20 April 2004 12:52 To: U2 Users Discussion List Subject: Re: GUI as nice as character-based Dawn and all, Another aspect of GUI, which we sure have to consider, is data communication lines. Our operation is spread over 1000 kilometres, and sending GUI screens back and forth will certainly clog our lines. Except when you make use of local intelligence. The volume of data sent to paint a GUI screen must certainly be a factor of 50 more than with CUI. (?) Schalk On Tue, 20 Apr 2004 11:02:31 +0100, Brian Leach [EMAIL PROTECTED] wrote: To go back to Dawn's original post - Dawn, I've been writing GUI applications for UniVerse for about 15 years now. Some have worked, some have - well - been learning experiences. You shouldn't really compare GUI and character based. Why? Because then you inevitably start to think of the GUI in character based terms - the arrangement of controls on a form, or the addition of some buttons. That's my main beef with 'intelligent' terminals - they obscure the real picture. GUI is not about what you put on the screen. It's about the flow of information, and how that flow best suits the application in question. Data entry is part of that flow, but only part: character based is good for some data entry and for administration, but a good application is also about navigation, culture and the ease of finding information again. Here are two very different examples: I did a freight forwarding package for a company that previously was entirely paper based. They took a - let's say flexible - approach to rules, validations, pricing, descriptions etc - and wanted to keep that. Providing a traditional system, with a nailed down design and entry screens just wouldn't work for them. In fact I tried that first as a prototype, and it didn't. Not in their culture. So I designed a system that worked the same way as their forms. Every page matched the standard forms they used, except that information automatically infilled, was sent to their billing systems, collated to their work flow for follow ups and diarising etc ... But all invisibly. What they 'saw' were the forms they had used throughout. Even the validation was fairly soft, and consisted mainly of highlighting things that were suspect. Annoying popups were kept to an absolute minimum, text and codes expanded directly from typing, and generally the whole thing designed to look and feel as unobtrusive as possible: nothing to interrupt their work flow. I couldn't have done that with a character based system because it couldn't have represented the compexity of some of the forms (try doing an airway bill or customs declaration form and you'll see what I mean). As a more traditional example, I have a project management system that I both designed and use. This is based on drill down principles, allowing me to track projects, modules, scheduled and tasks. Here the advantage of a GUI is persistence and workflow: because a GUI allows me to have multiple windows open modelessly, I can track down from the projects or work lists into the individual tasks whilst keeping the lists (heirarchically arranged) still visible, so I don't have to keep closing down windows or reselecting: generally much more efficient. I can also display more, since most of the time I am interested in viewing information rather than changing it - and at the viewing stage I can use smaller fonts to display things that when amended need larger screen estate. The diary is a case in point: I can use colours and smaller fonts to show different entries in a way that a green screen application wouldn't accommodate. And naturally I keep a document path, so any documents/project plans/applications or other materials connected with a task can be opened directly on my desktop. I have seen good GUIs: ones that improve process and work flow and make life genuinely easier. I have seen bad GUIs that interrupt work flow, slow people down (bl**dy mice and message boxes). Good GUI works. Bad GUI is bad bad bad. But too often GUI is blamed for the lack of vision or competence of those implementing it. Brian -Original Message- From: [EMAIL
RE: GUI as nice as character-based
Dawn Why dispense with the work already done in Data/Basic - I know I plug the language, and y'all ignore me, but OpenInsight (the GUI version of Advanced Revelation) looks and feels just like the Gates product, _and_ has the wonderful facility to use your already existing DataBasic code. The basic is called R/Basic, looks just like DataBasic, with a few extra concepts like mouse control built in. Type ahead works just like it does in U2. You'd have to remove all screen displays (if you wanted to be a purist) or you could do a quick-n-dirty like we did, and get the character based screen output stored in COMO and then parse the required data from there (saved having to re-invent the functionality of each screen. That way the users using character based saw exactly the same data the GUI folk saw without having to create brand new code in an interface one wasn't so familiar with. All we did was write a fancy screen parsing routine, call it from a zillion places, populate a GUI screen and hey! Presto. Somethin' to think about.. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: GUI as nice as character-based
but remembered not to include the entire original post in my response this time -- sorry I forget that on Oops! Me too - sorry folks! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: We need a web based Forum!
The main argument against the forum is that some of you out their can not access the web. How can anyone in a development role do their job properly nowadays without being able to access the web. I am sure that if all we had was a forum on the web, admin departments would be told that X needs web access and they would get it. James Hogan, Sungard, Dear Sir, What a luvly world you live in. You have a boss who trusts you. You're allowed internet access. You live in a country where bandwidth isnt a problem. You have an admin dept that would be told. Of all this you are sure. The real world. Africa. The boss is paranoid. He's Austrian/German. He employs engineers and questions their every move. He employs programmers, and doubts their every move. If you're not in telnet you're not working (unles you're in excel), if you have time to load the net, you don't have enough to do. First hand from idiots is always preferable to learned advice from the user list. Programmers don't need to concentrate,keep interrupting them because it broadens their abilities to understand the company. F*** what world do you live in... Better you keep your job whatever the cost, coz they sure don't make 'em like that over here! You don't have a position in nirvana for me, do you? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Jbase handles multivalue on RDBMS
For what it's worth the Revelation / Arev / OpenInsight crowd have a thing called Bonding where in you can create a bond with another database structure, and natively list/sort/query that database. Bundled with Arev comes Dbase / Ascii bonds. I don't know what comes with OI, but I believe you get bonds for all manner of database(s). As far as I remember, the emphasis is on data movement _from_ the other data structure, altho' it handles creation of data within that structure, but only within the rules of that structure - ie you can't create multivalues within a normalised base, and it's up to your programming to convert mv files into flat form based files. The best people to ask about this sorta thing have got to be Sprezzatura (Andrew McAuley and co) at www.sprezzatura.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: 15 April 2004 02:04 To: 'U2 Users Discussion List' Subject: RE: Jbase handles multivalue on RDBMS Do you know if there is a flavor of the type-it-in multivalue query language (e.g. UniQuery) that can be executed against data stored in Oracle, DB2, SQL Server, etc? I know that DataBASIC can be with jBASE and ONGroup, for example. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of djordan Sent: Thursday, April 15, 2004 12:27 AM To: 'U2 Users Discussion List' Subject: Jbase handles multivalue on RDBMS Hi Steve Just to correct you, jbase does not require you to move to 1NF files to run on an RDBMS. Jbase will port multi dimensional data across to an RDBMS and automatically handle the conversion to multiple tables invisible to the application. The issue is in the quality of the dictionary, like lengths and data types that RDBMS do not handle breaking the rules. Jbase does handle a lot of these issues and I would assume IBM will incorporate that in U2. Also in such an environment you would not move all your files over to an RDBMS, it would make sense to leave work files and control files in Universe which are usualy the worst offenders. If you wish to make your application portable in a future environment like this, look at SQLising your files including multivalues and starting cleaning your data as this will be your biggest issue, not multivalues. Just another point, jbase does the same for Cache, which is another multi-dimensional database, although not PICK. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Mayo Sent: Thursday, 15 April 2004 4:01 AM To: U2 Users Discussion List Subject: RE: The future of U2 The way that jBase handles the problem is by requiring the database be flattened out (i.e., no multivalues) and strict data typing. This is of course the standard with 1NF databases. Unfortunately for most of us, it means a complete redesign of the existing mv database structure. Over the past several years, all new systems that I have developed have used 1NF. Still most of the data still uses multivalues and would take years to convert. :-) Steve -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The future of U2
U2 TO DB2 --- Best thing to Happen. Hopefully IBM will start integrating all IBM DB's into Flagship RDBMS UDB. Joe Eugene BOY! OH! BOY!This lad sure is a flamethrower. Wotsa matta boy, you have a bad childhood? Someone drown yer puppy? Wet the bed last night? You really got it bad. Why don't you let us all play in our sandpit, an' you go play in yer's... Yer cess pool, that is! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
*** END OF THREAD *** Oh, dear, Mr Oliver - havent you learnt yet... Put it in the subject line, dear boy! RE: The future of U2
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clif Oliver Sent: 15 April 2004 03:10 To: U2 Users Discussion List Subject: Re: The future of U2 *** END OF THREAD *** DO NOT REPLY TO THIS THREAD ANY FURTHER (That means *anyone* not just the poster of the message used for the Moderator reply) On Apr 14, 2004, at 13:39, Tom Firl wrote: U2 TO DB2 --- Best thing to Happen. H... I don't think I'll touch that one other than to say that only time will tell. Tom Firl Columbia Ultimate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
*** END OF THREAD *** Was: RE: Modern Universe (TESTING)
Hi Clif A bit late in the day, but it would be better if you put END OF THREAD in the subject line as those of us who selectively read posts often miss these posts. On any thread that wanders about one starts to get interesting snippets that are tempting to reply to... Thus inadvertently breaking this cardinal rule... dennis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clif Oliver Sent: 06 April 2004 06:06 To: U2 Users Discussion List Subject: Re: Modern Universe (TESTING) *** END OF THREAD *** DO NOT REPLY TO THIS THREAD ANY FURTHER (That means *anyone* not just the poster of the message used for the Moderator reply) On Apr 5, 2004, at 7:54 PM, Andrew Gissing wrote: If you Dont Agree, Prove it... Everybody can Talk.. Where are your Test Results? The problem with performance tests is that there are so many variables. And then if you remove a lot of the variables to perform a lab test, that does not reflect real world. So then you try and make your lab conditions simulate real world - and simply doing a COUNT on a file is not enough - sorry ! Yes, UV could count for 15 mins if say the file was really badly sized. So what does that mean ? It does not mean that UV is crap, it means it's not been tuned right. Send Michael Schumaker round the track with flat tyres - when he does not perform is that the fault of the car ? So my final point is that it takes time and effort to do proper testing - something most of us are not going to dedicate resources to just to prove a point here. Andrew Gissing -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Fora posts
In fact, knowing who wrote the message would help greatly too (as I always make a point of reading the posts from the greats...Glenn Herbert, Ray Wurlod, Leroy Dreyfuss...etc, and avoid those written by contentious souls, eg Joe...) Knowing a post comes from [EMAIL PROTECTED] really does nothing for me -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Data typing in MV Basic
Surely OneYear = 101 Current = 0203 * NextYr = ( Current + OneYear ) R(0)#4 would be simpler??? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of djordan Sent: 31 March 2004 12:36 To: 'U2 Users Discussion List' Subject: RE: Data typing in MV Basic The issue I have had to deal with, which may be common to this discussion is where we use fiscal year 0203 for 2002/2003. If you do A = 0203, then sometimes but not always it becomes 203. where a = 0203 it remains 0203. If you want to add a year to make 0203 to 0304 requires something like this A = 0203 B = ((1+A)[2,2])+101)[2,2]):(1+A)[2,2]) (This also takes Y2K into account that is why it looks more complex than it should) Regards David Jordan Senior Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418 8329 Fax 61 2 9427 2371 www.dacono.com.au -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
Wendy, All that subscribing to a forum will do for you is that you'll get an email telling you that someone has replied to something on the forum. The email will NOT contain the posting, nor any reference short of the subject line to the previous post. In short, all communication from the U2UG site will be encouraging you to return to the web site to view each individual thread. If, like me, you have no access to the net at work, then, like me, you are stuffed! The forum is of absolutely no use to me. The only way I can partake of anything is if it works the way Clif's list works: I have to receive all information by email I have to be able to interact by email That's it. No other way. Incidently, I actually learn a lot from posts made to other groups, eg UniData (I'm on UniVerse), SB+ (I'm on original SB)... Having to subscribe to individual forums and hop from one to the other is a tad time-consuming. Basically, without the list I'm left high and dry. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: 29 March 2004 06:23 To: U2 Users Discussion List Subject: RE: The lists are closing Lee Leitner wrote: The archives for the lists (which go back to the mid-90's) would remain for now at http://www.indexinfocus.com. 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? For me it has to be email or newsgroup. I will not be as active in a forum that requires using a web browser as I will in an email list or newgroup. However, it looks like you can subscribe to the forums on u2ug.org, which I hope means that forum postings will arrive via email. If that's true, then if you have only email access at work, you should still be able to participate once you join and subscribe. Thanks, Clif, for hosting these lists. Without them, I never would have gotten all of my UniObjects for Java stuff working, nor been able to help so many other people get started. -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
Listen, Will the blind, deaf and possibly dumb Johnson Are you hearing nothing? There are those of us who don't live in the land of the mighty dollar. We have to pay for our traffic, we have employment contracts that forbid us from internet access during the day, yet we still need access to U2 info. What do _you_ suggest we do? I've subscribed to your glorious forum, I get wee posties saying there are people talking about juicy thangs, but I cannot get to see these. What do _you_ suggest I do? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 29 March 2004 09:03 To: U2 Users Discussion List Subject: 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Question for Donald Kibbey
Ha! Will pernickty Johnson is at it again. 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? Damn! Sir, can't you also get a life? Ain't this a technical group? Can't we assume enough intelligence for you to get the drift? Dennis bugged by your attitude bartlett -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
Dennis Bartlett agrees that: Dennis Bartlett wrote: All that subscribing to a forum And that Dennis Bartlett was obviously smoking out of some BEEG pot resulting in the fact that Dennis Bartlett is truly soree errr.. oops -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing ** adulation to Clif ***
Clif, Like others I've selfishly used your lists for my gain, without thinking of the work involved. Like others,I've learnt so much, and probably given so little. Like others, I've flamed, been flamed, and duly reprimanded in such a loving way :) Like others, I've been awed at a 400 message inbox and loved picking through, grouping and storing Like others, I've been enraged self-righteous when others didn't understand Like others, I've had a life apart from the daily grind called oliver.com, home from home. Like others, I'm really grateful, all these things provided by you alone Like others, all I have are paltry thanks for what must have cost you much Thanks seem insufficient, yet they're all I have. I could not have done what you did, Dennis saddened by this bartlett -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Volunteer Board
The number of after-the fact non-volunteers pointing out what we *should* have done is always staggering... I think what you've done is excellent. I think that the who comparison thang came about as a result of the imminent demise of the oliver thing... Volunteer? No problem, only I wonder if - what I know - where I live - the currency I use would be of any use to you... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
So there Will Johnson Ha Will! So nice to see you're wearing a new style... Must say it really suits you... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniData Profiling
Somebody the other day said that if we all asked IBM (nicely) we might be able to get UniData-type profiling available on UniVerse... I sent a message to U2AskUs and got back a snotty (sorry Jackie!) reply The appropriate way to request an enhancement is to raise it with your support organization. A business case always helps. Business case? I have a legacy app that has been worked on by numerous programmers over ten years, and is mildly constipated. I have a 4 cpu server that's puffing its last, and I find that there's a way to identify and destroy (ok, fix up) the wee offenders, and to get this I have, in my abundant free time, to supply a business case??? IBM, baby, I need speed! I need efficiency! I need profiling! Is that close enough? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: U2UG Contract
Hey, Wol, wot's cdp? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SB+ Information
For what it's worth I'm writing a trigger-based solution in-house. Progress has stalled for the mo' for a lack of time, but basically it's as follows: The RC means Revision Control Two files: RC.PROJECTS -stores a description, creation author, date, time last change author date time put live author, date, time detail keys RC.PROJECT.DTL File Name Item Key The full item LOWER(d), stored on one attribute Event type, eg insert, update, delete One Trigger Program: Updates the master last change, and detail key Adds a record to detail file Trigger is added to every dictionary file by creating a VOC pointer directly to the DICT as if it were a file in it's own right, eg F G:\accounts\source\D_TEMP DICT.DICT That's as far as I've got, but plans are to: A) Create a trigger that keeps an index system for Type 1 / 19 files such that any additions / removals via the operating system, eg windows explorer, are monitored. B) A program is required to extract all details from the detail file and copy each into the right place in live. C) The users want to ultimately have a rollback facility, so any changes put live will first have to store the existing live records. This may help you to create one of your own, or you could always wait til mine gets on the road... [snip] For example, how does one stick a bunch of changes together and then migrate them from a test environment to a live one? It's a small site, so they can't afford a full-scale package like Susan's. I would like to set something up for them. Thanks, Keith Johnson 'tm'ing the post name space -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: Unidata Flashbasic
Just a reminder that to ask IBM for something, simply send a post to [EMAIL PROTECTED] Please ask..!!! -Original Message- Pity that's a UniData-only feature. [snip] Maybe if enough UniVerse users request it, it will be added. [snip] Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
How would I find the block size on a W2K Server?
Everything seems to revolve around block size. I know we've been over this a thousand times, but I'm trying to make sure (coz I'm being hounded to prove my theories) I've been using 2k as a general rule-of-thumb (on W2k NT), but have now been informed (albeit wrongly perhaps) that Pick is 2k, UniVerse may be different, W2K may be different, RAID may be different, SCSI may be different, etc and I'm to back up with facts what I've been doing. A CHKDSK on the server says 2048. The net is a myriad of transfer rates, and specific apps doing their own thing... So -what defines block size (app,disk,scsi,raid,???) in terms of resizing? Thanks for any pointers dennis -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
On the nail. Thanks WOL! CREATE TRIGGER has no problem with this. Now writing a proggie to create a dict pointer for every file required... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 05 March 2004 04:06 To: U2 Users Discussion List Subject: RE: How to Add Triggers on Dicts When you specify DICT FILENAME, UV treats it internally as if there existed a VOC entry 0001: F 0002: D_FILENAME 0003: \uv_account\DICT.DICT There is no reason whatsoever why you shouldn't create an explicit VOC entry of exactly this form. After all, as far as UV is concerned, the D_FILENAME file is a data file, just like any other ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daly, Mark Sent: 02 March 2004 14:28 To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts Well.. It wouldn't surprise me if the CREATE TRIGGER command doesn't recognize the 'DICT' keyword. Triggers generally deal with data updates. I guess you could create a dummy file pointer that points to the dictionary as though it were a data file. Then reference that pointer when creating the trigger. BUT - I haven't tried it. Not sure I would try it. Good luck! -Original Message- From: Dennis Bartlett [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:20 AM To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
How to Add Triggers on Dicts
I'm attempting to write a mini-revision control system. We use original System Builder, which stores file-related screens in the dict of those files, plus of course having to record changes to dict records too. I've tried the example posted to the list by Bryan Thorell, a work of beauty for adding triggers to data files. CREATE TRIGGER AUDIT_XXX AFTER INSERT OR UPDATE OR DELETE ON XXX FOR EACH ROW CALLING 'DATA.TRIGGER' ; I've tried various ways of modding this statement to add the trigger to a dict, but alas no success. Any ideas? dennis bartlett -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
Hi Vincent, Is your subroutine GLOBAL cataloged ? Thanks for the prompt reply! Yes, it is cataloged using the INFORMATION FLAVOR catalog command. (our system runs on a PICK flavor account) The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. dennis -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] How much do you pay for support each year?
Whoa! Hold on... The original poster of this thread never questioned the need for support - he just questioned the need for east coast support... All he was asking is is there a way to directly approach IBM for support, and if not, who can he go to as a VAR on the west coast... Not so difficult, hey? Perhaps the best response would be testimonials from those of you on the pacific seaboard about your VARs... A real no-brainer would be to read the question...grin -Original Message- From: Ross Ferris Sent: 24 February 2004 06:06 Subject: RE: [UV] How much do you pay for support each year? [snip] As others have responded, UV support is a GOOD idea - and a relatively cheap no brainer option. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse and Backup Exec
Hi Gwen We're running UniVerse 10.0.4 (a known baddie as it is) and Backup Exec, tho' which I don't know off hand. We also get plenty app errors We've had 47 system crashes sinces Aug '03, which IBM have first blamed on Backup Exec, then told us that 10.1 would fix it thereby admitting the problem lay in UV. When pressed to supply us 10.1 to fix the problem, the answer was that we'd have to wait for 10.1.1 as that was specific for our platform We originally thought the problem might lie in the way the system (incl W2K) had been loaded, and so re-installed W2K Server, then Backup Exec, then used that to restore the system. Didn't work. We're still running B/E on the UV server, the system crashed twice yesterday, and once today, and management still doesn't see the need to change servers / UV's just yet. One thing tho' we did do when tweaking the reloaded UniVerse - we modified a registry key that some bright spark had discovered helped B/E and UV to co-exist. What that tweak is I don't remember - but I know that the guy who does is also on this list - Kurt, please supply! Something else that IBM said might fix the problem was if we installed B/E on a different server and backed up over the network... dennis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of At 09:18 AM 2/17/04 -0500, you wrote: I am running: UniVerse 10.0.17 Windows 2000 SP 4 Veritas Backup Exec: Media Server Admin. Console: Ver 9.00 Rev 4454 snip much of message Thanks in advance for any help you can offer! Gwen Buck Gaska Tape Inc. [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
U2 List Archive... How big is it?
Sometimes (out here in Africa) we cannot get access to the internet - whilst I realise it would just be a snapshot without updating, would it be possible to use something like webstripper and copy the entire site to my HDD? dennis -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Proc or Para
Think of PROC as a type of dos BAT file... Sure you could write programs to schedule things to happen one after the other, but it sure is easier to just create a BAT file, ain't it? AUTOEXEC.BAT? Yeah, they evolved, perhaps too far, but essentially it was a simple procedural tool. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Sent: 05 February 2004 07:08 To: U2 Users Discussion List Subject: RE: Proc or Para Isn't it great to have choices. Choice, yeah sure; but um, why wouldn't you just write a program? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Proc or Para
Yeah, they evolved, perhaps too far, but essentially it was a simple procedural tool. Wrong way round. Huh? I said Procs in the PQ form came before PQN's... Waz wrong wi' dat? The evolution was PQ to PQN ... From simple batch (step 1 to 2 to 3) we moved to labels (step 1 to 2 to (if a = b) then step 1 else step 3) Anyhows... Forgive incorrectnesses... :) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VARIABLE-1 = '' Inconsistent behaviour
For what it's worth, the Arev knowledgebase has a great article on optimising BASIC code (for speed!), which mentions that the -1 concept is the slowest structure. Admittedly we have processors that thrash these things out in milliseconds today, but for the purist... The A = A : newvalue : @fm process is (to quote Andrew McCauley) 20-30 times faster dennis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 04 February 2004 03:06 To: [EMAIL PROTECTED] Subject: RE: VARIABLE-1 = '' Inconsistent behaviour -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users