RE: [U2] Totaling an Oconv'd DICT column

2008-02-06 Thread Dennis Bartlett
Regards Dennis Bartlett DB Admin/Programmer [EMAIL PROTECTED] +27-21-526 4300 (tel) +27-21-555 3970 (fax) For what it's worth, I've been known to COMO the output of a LIST statement and then run the COMO file through a program that reformats the report... some things are just not possible

RE: [U2] Dynamic Connect keyboard definitions

2008-01-23 Thread Dennis Bartlett
Tim Are you sure you have removed the post session keyboard settings? grin At risk of being flamed by the group, this is the config script for mine... (I use Notepad++ which allows me to view and change beyond the gobbledygook...) * Full configuration script * Saved on Tue, 15 Jan 2008 11:29

RE: [U2] Problems with disconnects - telnet

2008-01-23 Thread Dennis Bartlett
Hi Gabe There is a guy who has written a terminal emulator with a bit of class. Its called BRIZ, the guy's name is Grygory Pryamov, and you can find him on Mytmppost [at] mail.ru. He is really keen and willing to adapt his emulator to do what you want it to do. As a matter of interest he has

[U2] What is the BREAK key setting for Dynamic connect?

2008-01-22 Thread Dennis Bartlett
-C I get a dialog saying noth is highlighted. I'm getting really bored opening another session to kill the looping process. (2) How do I set the terminal to 132 chars wide to view reports? Thanks Dennis bartlett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe

RE: [U2] Dynamic Connect keyboard definitions

2008-01-22 Thread Dennis Bartlett
After you change the Keyboard etc settings, you need to click Save under the File menu - this will preserve your settings. -Original Message- Subject: [U2] Dynamic Connect keyboard definitions I am trying to save keyboard definitions from one session to the next. Mainly the keypad. The

[U2] Problem un-subbing

2005-02-18 Thread Dennis Bartlett
Hi all I need to unsub for a while, and can't. I've been away for a day or two and received 665 U2 posts today. On going to the link I've entered both my email addresses and it cannot find any subscription details for No subscribed Lists For [EMAIL PROTECTED] Found.

RE: [U2] Universe upgrade 10.1.2 to 10.1.4

2005-01-27 Thread Dennis Bartlett
Further to my last post, Addressed directly to IBM The documentation that accompanies an install is so out of date - most of our install notes are scratched out options replaced by pencilled in notes - - the mount command did not work as instructed, - the fix for our problem, ie using REWIND

RE: [U2] [AD] Programmer needed in New Jersey

2005-01-27 Thread Dennis Bartlett
waal, ah'll be danged... you must be psychic.. ah'm 44 with 24 years... -Original Message- From: Phil Gurnee [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 January, 2005 9:44 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] Programmer needed in New Jersey Wouldn't that remove

[U2] Universe upgrade 10.1.2 to 10.1.4

2005-01-26 Thread Dennis Bartlett
for what its worth we did this upgrade last night, and had a problem in that the installation disk contained only a single directory in root, called Universe. The script however referenced the install scripts as being in root, and not in a second level directory. The install failed. We then

RE: [U2] How to exit out mulitple loops?

2005-01-20 Thread Dennis Bartlett
Since you insist... FOR T=1 TO 10 FOR Q=1 TO 6 FOR X=1 TO 9 IF CONDITION THEN EXIT ; EXIT OR IF CONDITION THEN CONTINUE T NEXT X NEXT Q NEXT T FOR T=1 TO 10 until abort.flag 0 FOR Q=1 TO 6 until abort.flag 0

RE: [U2] Universe ON.EXIT

2004-12-10 Thread Dennis Bartlett
On the contrary, the concept of a uvconfig switch that defaults to the way it currently is would be superb. If we're going to go on in life never changing anything because it was always done that way... a working resolution works as long as you know to add a quit. A better solution would be to

[U2] Begin Transaction / Commit without turning on transaction logging

2004-11-30 Thread Dennis Bartlett
Hi All I've been told that using BEGIN TRANSACTION at the start of an update routine, and COMMIT at the end will cause the system to store (in memory) all pending updates until the commit... how true is this, and are there any caveats? -

RE: [U2] UV 10.1.2 ?

2004-11-11 Thread Dennis Bartlett
... -Original Message- From: Mats Carlid [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 November, 2004 10:54 AM To: [EMAIL PROTECTED] Subject: Re: [U2] UV 10.1.2 ? Did You by chance have a UV.PROMPT ... in the login paragraph in the uv account ?? -- mats Dennis Bartlett wrote

RE: [U2] UV 10.1.2 ?

2004-11-11 Thread Dennis Bartlett
Yo Mats! The funny thing is that our system used to do that too, ie ACCT when we were on 10.0.x Of course, that was before we downgraded to 10.1.2 -Original Message- From: Mats Carlid [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 November, 2004 3:11 PM To: [EMAIL PROTECTED] Subject: Re:

RE: [U2] UV 10.1.2 ?

2004-11-10 Thread Dennis Bartlett
We're on AIX 5.2 UV 10.1.2... when we upgraded - we lost the one usually gets when having a select list active ... - uvlictool no longer just cleans locks - it completely loses all trace of logged in users The lictool thang only becomes an issue at crisis time, but the missing

RE: [U2] RE: running a subroutine [AD]

2004-10-21 Thread Dennis Bartlett
wow, the mighty (friendly) joslyn lives and breathes..smile hi susan! -Original Message- From: Susan Joslyn [mailto:[EMAIL PROTECTED] - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS

RE: Memo: RE: [U2] Spooler question

2004-10-20 Thread Dennis Bartlett
Hi Piers/Anthony Yes I've looked at classes - the idea would hold is we only wanted to print to any one of several available printers... the bummer is getting the month-end / genled reports to come out one after the other (ie on one printer) There've been some great ideas - I'm rudimentary at

[U2] Spooler question

2004-10-19 Thread Dennis Bartlett
We have two system printers, and would like to set up the following scenario... One form queue that prints the next incoming job on any of the two printers, BUT allows us to specify certain reports that need to come out one after the other (ie on one printer) Thanks dennis

[U2] UV licencing - Machine hangs

2004-10-15 Thread Dennis Bartlett
We have a problem... UniVerse 10.1.2 AIX 5.2 IBM p615 184 user licence Today we had 174 users working. There was a power dip at one of our remote sites (WAN), and the users there attempted to log in again. Naturally the user licences were fully used up (the pre-dip users were still logged in).

RE: [U2] [UD] BASIC COMPILE ERROR: Too many constants near line

2004-10-13 Thread Dennis Bartlett
Craig Cant it be read ONCE and put into one (or more) named common variables? Split over several variables the size won't count, various programs can reference it, you can consolidate multiple constants into one delimited variable (thus reducing number of constants) -Original Message-

RE: [U2] [UV] Max Files Per Directory

2004-10-01 Thread Dennis Bartlett
Stephen We just had to laugh - Literally, we have seen directories (accounts) with upwards of 4,000 files dictionaries! We have around 100 000 files (incl dicts)... We just have to ask now, in light of our recent conversations regarding triggers, file performance, and JFS2, do your statements

RE: [U2] Comparison Unidata and Universe

2004-09-28 Thread Dennis Bartlett
You can afford a version control system? -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Sunday, 26 September, 2004 9:41 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Comparison Unidata and Universe Surely you use a version control system in a multi-programmer

RE: [U2] [UV] Processing a string

2004-09-20 Thread Dennis Bartlett
an alternative approach would be to write your string once-off to a sequential file, then do READBLK's of one char in a loop... READBLK's work at an amazing rate -Original Message- From: Nick Cipollina [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 September, 2004 2:32 PM To: [EMAIL

RE: [U2] U2 User Group Charter

2004-09-20 Thread Dennis Bartlett
Thanks for the offer, but as I am around 17000kms from Las Vegas this weekend, I think I'll pass (ref http://www.wcrl.ars.usda.gov/cec/java/lat-long.htm) -Original Message- From: Dana Baron [mailto:[EMAIL PROTECTED] If you're planning to be in town [a fine example of misquoting and

RE: [U2] ANNOUNCEMENT: Commercial MultiValue Database released as Open Source under GPL

2004-09-17 Thread Dennis Bartlett
When I last looked for an alternative position (read job) I found a possible three positions. Like most multivalue professionals I've wondered what was to become of the MV world, and my security in the furure... Why? The multivalue world has always been a closed shop, a dying (or at least never

RE: [U2] UK U2 Account managers

2004-09-10 Thread Dennis Bartlett
It's general, methinks... -Original Message- From: Ian Byrne [mailto:[EMAIL PROTECTED] [snip] I just want to know if we are the only ones experiencing this problem or is it much more general? Regards, Ian Byrne --- to unsubscribe please visit http://listserver.u2ug.org/ PRE

RE: [U2] Anyone have experience mirroring a HDD over a WAN

2004-09-06 Thread Dennis Bartlett
Ok, so something has to be different... we still think you're smoking something... my ratio is somewhere around 1 to 10 your ratio is 1 to 1.15 with your ratio I'd happily embrace triggers. Please post (possibly privately?) your uvconfig file, what the specs of your machine

RE: [U2] Anyone have experience mirroring a HDD over a WAN

2004-09-03 Thread Dennis Bartlett
Jeff Triggers that have little effect on performance would indeed be ideal. Alas, our experiments (prompted by Adrian Matthews post) have lead to the firm decision to stay away from triggers as implemented in UniVerse... A trigger that merely activated (ie a two line program having a RETURN

RE: [U2] Trigger problem!

2004-09-02 Thread Dennis Bartlett
Funny that. My catalog verb is identical, but I think it is the actual wording of the statementthat is different.. I've been ICAT {file} {program name} where as you've been CAT {file} {*program name} {program name} -Original Message- From: John Reid [mailto:[EMAIL

RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands

2004-09-02 Thread Dennis Bartlett
Alas! I have to return with my tail 'tween my legs! --- IBM P615 AIX 5.2 Universe 10.1.2 2 cpu --- Test Data : 500,000 invoice records, a trigger with a

[U2] Trigger not intensive, it's what you do with trigger! Was RE: [U2] Dot Commands

2004-08-31 Thread Dennis Bartlett
A trigger need not necessarily be intensive - tho' admittedly the concept of an audit or any process requiring a write will mean the extra overhead of that write. The thing to watch out for is the temptation to read lots and write lots... Then imagine this blowing out exponentially as 3 zillion

RE: [U2] Trigger problem!

2004-08-31 Thread Dennis Bartlett
Good point tho', Rich. My problem was a file that I'd not checked existed. I come from a site that used .s in file name creation, this site uses -s, so I had created a file called TRX.TRANSACTIONS, not TRX-TRANSACTIONS... oh well My programs are globally cataloged, so what is needed to have a

RE: [U2] [UV] Dynamic Array Delimiters

2004-08-26 Thread Dennis Bartlett
Please ignore - testing - have been unable to post to list - list's anti-spam filter considered the company sig line to be spam... PRE - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB

[U2] Trigger problem!

2004-08-26 Thread Dennis Bartlett
I have a situation in which I need to store data to be moved elsewhere I have a working trigger attached to a local file - works brilliantly LIST.SICA TRX-TRANSACTIONS 03:45:34pm 26 Aug 2004 Page1 == Sica Region for Data File TRX-TRANS000

RE: [U2] Trigger problem!

2004-08-26 Thread Dennis Bartlett
Oops! Sorry... I overlooked that concept - it couldn't find a file, and therefore bombed! Thanks! On the same score tho - the trigger is passing the file name as the short form, ie TRX-TRANSACTIONS is arriving in the trigger as TRX-TRANS000 Is there any way of getting the full name? (The

RE: [U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Dennis Bartlett
Hi Andy Yes I got your post, but didn't reply as I had only an inkling of what possible direction you could choose. I toddled off to the manuals, and as yet haven't found anything of value, so ... here's my theory: why can't you use the mkdbfile executable in UV\bin? Or it's pal create.file?

RE: [U2] problems with XP and PE

2004-07-02 Thread Dennis Bartlett
XPHome cannot run anything that requires you to login as administrator, as you cannot login as administrator unless you do so from safe mode, and safe mode won't allow you to do anything! XP Pro is more lenient In your first post you said XP Pro In the last one you said XP Home which is it?

RE: [U2] Available Memory Exceeded

2004-06-29 Thread Dennis Bartlett
politically incorrect question - hey, just what is your name? do we call you ang or is that your surname? just asking.. -Original Message- Our settings: DELL POWEREDGE 6300 1GB RAM (small I know - getting new server with more) 130 users WAN with 6 branches Wind0ws 2000 Server Current

RE: [U2] Available Memory Exceeded

2004-06-28 Thread Dennis Bartlett
Hi Ang Suan You'll have to give us more information: - what machine (IBM RS600, or HP, or whatever) - what operating system? (Windows 2000, Unix, ?) - how much memory in machine? - how many users at time of error? What you might look at though is that the program

RE: [U2] COMO capturing EXECUTE output

2004-06-28 Thread Dennis Bartlett
Hi Chuck drop the hush commands. just execute the COMMAND EXECUTE COMMAND CAPTURING X RETURNING Y the X will stop any output appearing on the COMO and the Y will stop any universe system messages like 102 records selected the X will contain all the results of the command the Y will contain

RE: [U2] Performancing of File Universe

2004-06-25 Thread Dennis Bartlett
Hi Cisar Type 30 is a dynamic file, so it should be looking after itself pretty well. I believe there are time one of these needs resizing, but as I have none here, I cannot tell you how/where/when 200,000 records is not really very much. I have some with 2,000,000. What WOULD help you

RE: [U2] Propagating an array

2004-06-23 Thread Dennis Bartlett
well, if you want to be truly esoteric, dim array( {big enough to cater for WorkCount} ) matparse array from WORK1 using @VM mat array = WorkValue matbuild Work2 from array using @VM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Sent: 23

RE: [U2] [UV] WHILE READNEXT id DO {{not a holy war,just a code example)

2004-06-22 Thread Dennis Bartlett
Just a quick look, it appears the code is adding to the city and state totals before checking if the city or state values have changed. Allen, have you had this vision problem for long - quick look, my apple! *test if city has changed? IF (CITY NE LAST.CITY) THEN GOSUB

RE: [U2] [UV] WHILE READNEXT id DO {{not a holy war,just a code example)

2004-06-22 Thread Dennis Bartlett
This code example is also flawed in that a break-on state should automatically break-on city first regardless if the city has changed. As it is, it assumes that there could never be this situation: Agreed... knew there was summat I was missin' :0) --- u2-users mailing list [EMAIL

RE: [U2] [UV] WHILE READNEXT id DO {{not a holy war,just a code example)

2004-06-22 Thread Dennis Bartlett
(A) Also, what do the CRT SPACE(40) lines do besides CRT? (B) And shouldn't this have been written using PRINT in case the output wishes to go to the printer and you can use PRINTER ON instead of changing the CRT lines. (A) The crt space(40) lines line up the totals under the relevant

RE: [U2] Piotr KIRYLUK/RCB-WARSAW/PL : nie ma mnie w pracy.

2004-06-21 Thread Dennis Bartlett
dear Peter (Piotr) whilst we are deeply moved by your sentiments, we're awfully sorry, old chap, to do this to you, but we sincerely believe that, to quote a local song, a leetle beet of eenglish might just serve here... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE:[OT] [U2] Piotr KIRYLUK - Seriously OT

2004-06-21 Thread Dennis Bartlett
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 21 June 2004 09:56 To: [EMAIL PROTECTED] Subject: RE: [U2] Piotr KIRYLUK/RCB-WARSAW/PL : nie ma mnie w pracy. dear Peter (Piotr) whilst we are deeply moved by your sentiments, we're awfully sorry, old chap

RE: [U2] [UV] WHILE READNEXT id DO

2004-06-18 Thread Dennis Bartlett
My first job was in Fortran. I understand why GOTO's are evil. That said, I can see where someone in that frenzy of getting an idea down, and not having time to return and tidy one's code, can end up (only too soon) with an un-manageable system. Long-time maintenance programmers have things they

RE: [U2] [UV] 'Press any key...'

2004-06-18 Thread Dennis Bartlett
Hi Alexey All the other replies have focussed on pressing N (or setting NO.PAGE) If you're in a program you could always do the select in such a way that no text appears on the screen, but that you have the results in variable that you can test, eg CMD = SELECT FILE EXECUTE CMD CAPTURING X

RE: [U2] Craig Coe passed away

2004-06-14 Thread Dennis Bartlett
Kevin You also make the people on this list sound like stalkers. Ever since this list became a web site, anybody can view the post. I'm not casting aspersions on the legitimate technical members, but pointing out that since there are privacy issues on the web, and companies are doing what they

[U2] FILEIOSUBR ???

2004-06-09 Thread Dennis Bartlett
I got so excited at the reply to the triggers thang regarding a call to FILEIOSUBR that I deleted the post - now that is dumb! Anyway - I've searched the archives, searched my mail, searched, and searched, and have no record of such a proggie... Two requests: (1) Could someone forward me their

RE: [U2] [OT] Cost of Oracle vs PICK

2004-06-09 Thread Dennis Bartlett
Ta mate! -Original Message- Here you go. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [OT] My company is complaining about the U2 emails

2004-05-17 Thread Dennis Bartlett
How about cleaning up our mouths. No offence, but I've found using my mouth as a means of typing to be strangely inefficient. However, I will take your advice, and will retest after having cleaned up my mouth. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users

RE: [U2] My company is complaining about the U2 emails

2004-05-17 Thread Dennis Bartlett
I believe that phraseology that is both commonplace and inoffensive where I am (Australia) would be targeted by their email filter software. Well put - the same holds true for sou theffrican ing lish. Andra might get better mileage if she pointed out to her colleagues that a truly

RE: [U2] [UV] INPUT madness

2004-05-17 Thread Dennis Bartlett
Surely a simple: Hilite.ON = @(whatever esoteric highlighting I feel like) Crt @(10,20): Hilite.ON : MY.STRING : Hilite.OFF : @(10,20) : Input MY.STRING would work? --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users

[U2] [OT] mindless stocktake

2004-05-08 Thread Dennis Bartlett
Sitting here browsing the week's post, noticed that I sent the wrong addy for the pnet/1time comparison. Should have been www.pnet.co.za versus www.1time.aero. The remarkable thing I found was that the universe site, pnet, has comparable performance with the 1time, oracle based, site. Why this

RE: [U2] UniVerse telnet session terminating...

2004-05-05 Thread Dennis Bartlett
Leroy Dreyfuss Administrators experiencing such an issue will need to grant the proper permissions to the required directories and files before turning their systems over to users. As an example, the 'users' group may loose its previous access rights and be set to Windows 2003 defaults.

RE: [U2] When does common sense in thread ending begin?

2004-05-05 Thread Dennis Bartlett
Oh, get a life! A little humor makes for a better life style.. And yes, I did spend the whole of Easter here... ME = TECHNICAL ; GOSUB HOW.AM.I IF (life+humor+the del key) = OK THEN * life is ok ME = CAN.COPE END ELSE IF NOT(CAN.COPE) THEN ME = OLD.FART ** NOT(CAN.COPE) IF

[U2] My sincere condolences

2004-05-04 Thread Dennis Bartlett
Condolences? The list appears to be suffering from asthma - no-one has wot it takes to blow bags of hot air around this mortal coil. Huh? Wot ya on about? Just seems there're only a few brave souls able to post. Tis very sad! --- u2-users mailing list [EMAIL PROTECTED]

<    1   2