RE: [U2] Upper Case Only

2007-03-15 Thread Bill H
Ron: Sorry for the misstatement...I'm running UniData. UniData is occasionally much less forgiving than UV (sometimes it seems the engineers enjoyed tripping up PICK people). :-o Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent:

Re: [U2] Upper Case and Editors

2007-03-15 Thread MAJ Programming
Also recall that earlier typewriters didn't have a '1' key, rather you used the lower-case L. - Original Message - From: "Bill H" <[EMAIL PROTECTED]> To: Sent: Thursday, March 15, 2007 1:16 PM Subject: RE: [U2] Upper Case and Editors > Arnold: > > One can only hope the more "experienced"

Re: [U2] Reports In Universe BASIC

2007-03-15 Thread MAJ Programming
I agree that scanning programs for concepts is made harder with this. I inherit this kind of code and have been known to quote your quote. But I must repeat that the train has left the MV station at the highest level. Sure, a flavour (Ud/Uv/D3/Mvbase etc) may dictate standards but they have a lega

Re: [U2] Printing Reports In Universe BASIC

2007-03-15 Thread MAJ Programming
Could all of this SETPTR stuff be in a table that's easier to maintain. I've added such to my UD and D3 clients. - Original Message - From: "Brutzman, Bill" <[EMAIL PROTECTED]> To: Sent: Thursday, March 15, 2007 11:04 AM Subject: RE: [U2] Printing Reports In Universe BASIC > Consider the

Re: [U2] SQL SUM Function

2007-03-15 Thread MAJ Programming
Why show MD22 when MD2 is sufficient. The output 2 is implied if absent as the number values in MD are singular, ie not ten decimal places like MD10. If the data were pennies and you wanted whole dollars, then use MD02, ie the '0' is display and the '2' is the conversion. MD22 is redundant. My OC

RE: [U2] [UD] CALL @progname

2007-03-15 Thread David Wolverton
DEFFUN UTL.MULT.PERCENT.BY.NUMBER.FUNC(PERCENT,NUMBER) FOR ZZZ = 1 TO CYCLE.CNT RESULT = UTL.MULT.PERCENT.BY.NUMBER.FUNC(PERCENT,NUMBER) NEXT ZZZ Routine Function call I think > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach > Sent

RE: [U2] [UD] CALL @progname

2007-03-15 Thread David Wolverton
I don't know that UniData does that header work (reason for the forehead slaps??) - but there's lots about UniData under the covers I don't know - and don't know that many know! > > I missed the UD bit in the subject line. > Apologies. > > Brian > > > -Original Message- > > From: [EMA

RE: [U2] Upper Case Only

2007-03-15 Thread Ron Hutchings
I was using pick as a generic term. I am currently working on an AIX platform running Universe with the pick flavor and the LIKE keyword works. My point was that it has to be in upper case unless you have really mucked up the VOC with extaneous synonyms. ___

RE: [U2] Universe/UniObjects and Visual Studio

2007-03-15 Thread leslie chamberlin
IMHO, You rock, Brian!! That did the trick. Now off to play with other new toys.. <> -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday, March 15, 2007 3:28 PM To: u2-users@listserver.u2ug.org Subject: Spam:RE: Spam:RE: [U2]

RE: [U2] [UD] CALL @progname

2007-03-15 Thread Brian Leach
David If you look at the MAP command, globally cataloged programs keep track of the number of times they have been run since being cataloged. That suggests that their headers are updated when they are called, which would explain why they are slower. Normally UniVerse cached subroutine object in m

RE: [U2] [UD] CALL @progname

2007-03-15 Thread Brian Leach
Duh duh duh (slaps forehead). I missed the UD bit in the subject line. Apologies. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach > Sent: 15 March 2007 20:38 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] CALL @prog

RE: Spam:RE: [U2] Universe/UniObjects and Visual Studio

2007-03-15 Thread Brian Leach
Leslie HTH I did some poking around earlier and found that the GenerateXML actually seems to call down to a subroutine named GETXMLSUB held in the BP file of the uv account. On some 10.1 versions it is present, but not cataloged: I found when I added it to global catalog as *GETXMLSUB it worked f

RE: Spam:RE: [U2] Universe/UniObjects and Visual Studio

2007-03-15 Thread leslie chamberlin
Hello all, I worked through Brian's tutorial he mentions below and found it MUCH more helpful than anything else I have found so far. I am having one issue that I will work through shortly. The cmd.GenerateXML is not working with my test system according to the error due to my version of Univers

RE: [U2] Upper Case Only

2007-03-15 Thread Bill H
Ron: In PICK mode there is no "LIKE" keyword. Comparisons use the normal "=", "#", etc operators. So your example should be: LIST VOC WITH @ID = "XREF]" AND WITH TYPE = "F" ...or LIST VOC = "XREF]" WITH TYPE = "F" (notice the upper-casing) :-) Hope this helps. Bill >Ron Hutchings w

Re: [U2] [UD] CALL @progname

2007-03-15 Thread Allen Egerton
David Wolverton wrote: Anyone have a clue why the indirects are a hair faster? Or am I just getting lucky over and over? I always thought they were slower as well! In Prime's implementation, which I *believe* was carried over to Universe, the *first* reference to @PROGNAME has to "resolve" th

RE: [U2] [UD] CALL @progname

2007-03-15 Thread David Murray
David, The >HELP BASIC CALL help info explains how the CALL and CALL@ work. The variable setting should be included in the loop as it is a valid part of the CALL@ setup. Setting the variable will 'trigger' the CALL@ to find the program again. It is more of a real-life situation than setting the va

RE: [U2] Help with File Pointers

2007-03-15 Thread Michael Rajkowski
Another thing you can try is something like this: 001: * 002: OPEN "CUSTOMER" TO FILEONE ELSE STOP "" 003: OPEN "MYCUSTOMER" TO FILETWO ELSE STOP "" 004: * 005: READU REC FROM FILEONE, "MIKETEST" ELSE REC = "" 006: STATUS = RECORDLOCKED(FILETWO, "MIKETEST" ) 007: PRINT STATUS Note that the RECORD

RE: [U2] Help with File Pointers

2007-03-15 Thread Michael Rajkowski
Good point, so release it on the other file pointer, and then look at the locktable to see if it is gone. "Bob Woodward" <[EMAIL PROTECTED] sale.com> To Sent by:

Re: [U2] [UD] CALL @progname

2007-03-15 Thread Charlie Rubeor
Inefficient, but I check for Direct, Local and/or Global. Here is the subroutine that I use, which you can see has three opens. On the positive side, this has not failed me since I started using it. (Hopefully, there are no typos in this.) SUBROUTINE VERIFY.PROGRAM(PROGRAM.NAME,CATALOG.TYPE,

RE: [U2] Upper Case and Editors

2007-03-15 Thread Bill H
Arnold: One can only hope the more "experienced" engineers of the U2 products are listening. One "work-around" after another make life more difficult not less. In the 21st century a solution would be helpful. Case sensitivity is a "blight" on the landscape of computing perpetuated by systems wh

RE: [U2] DEBUGGER

2007-03-15 Thread brian
Sanjeeb As with everything in UniVerse there is more than one way to use it! There are two debugger environments - the client/server UniDebugger application, and the regular debugger in your UniVerse command session (TCL). To enter the debugger in TCL you can either: a) include a DEBUG stateme

RE: [U2] [UD] CALL @progname

2007-03-15 Thread David Wolverton
Actually - I just ran a test, and was surprised somewhat: 1,000,000 Iterations of ways to do a call... CALL PROGNAME (direct)7047 CALL *PROGNAME (global)7766 CALL @PROGNAME (indirect) 6984 GOSUB (logic contained in-line)1531 Call as Function

RE: [U2] [UD] CALL @progname

2007-03-15 Thread Baakkonen, Rodney A (Rod) 46K
If you were going to cover all the possible bases, you would need to do the: 1. VOC 2. OPEN 'CTLG' and read that. This covers 'LOCAL' catalogs 3. CREATE a temporary VOC entry where att1 is 'DIR' att2 is @UDTHOME/sys/CTLG/(first letter of program name) OPEN this file and read using program nam

RE: [U2] Upper Case and Editors

2007-03-15 Thread Sage, Ronald E \(Ron\)
If you don't want to change the LOGIN paragraph for everyone, create a VOC entry with your login name, universe will run it first, if you want it to still run the LOGIN after than then make that call in your login name... Example - Login name = YOURNAME >.L YOURNAME YOURNAME 001 PA 002 DI

RE: [U2] Help with File Pointers

2007-03-15 Thread Bob Woodward
But doesn't the locking let the same session set the same lock many times? BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Rajkowski Sent: Thursday, March 15, 2007 7:52 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@lis

RE: [U2] [UD] CALL @progname

2007-03-15 Thread David Murray
David, @CALL's are very inefficient and slow. It would be worth doing a speed test. Also, it might be prudent to have significant control over an external process calling an internal one. This is the source of many a virus on MS-Windows. I have used a CASE statement to check a variable and call

RE: [U2] [UD] CALL @progname

2007-03-15 Thread David Wolverton
This test shows the compiled source code exists - not that it's cataloged. If the VOC or CTLGTB were missing, the code shown would still allow the CALL @subroutine to fail. And I had not thought about checking that the compiled code existed! I guess it could happen that the VOC pointer is there,

RE: [U2] [UD] CALL @progname

2007-03-15 Thread Kevin King
>From David Wolverton >How do others handle CALL @ As you've pointed out, there's no really good way to do this, at least not one that's easy AND portable. So what about this idea? Create a configuration record or file that has information for all of the methods you know about, then verify again

RE: [U2] DEBUGGER

2007-03-15 Thread Bob Woodward
You don't compile with the DEBUG option. The Universe Debugger is an interactive debugger that you run the program inside of. It's more of an editor/debugger than just a debugger. Load the program you want to debug then use the "stepping" options to move from line to line and view the contents o

RE: [U2] Help with File Pointers

2007-03-15 Thread Michael Rajkowski
If you are trying to determine that two files are pointing to the same thing, you could set a lock on one and try to set it on the other. If it will not let you do it, then you have the same file. ( note that my first thought was to write an item, but that could cause problems if anyone else was

RE: [U2] [UD] CALL @progname

2007-03-15 Thread Vance E Alspach (J&L - SFD)
We do this all of the time for our EDI mapping. Since our code is all in 1 file, it is easy. PROG.NAME = "JLSH.EDI.OUT856" READV X FROM PROGFILE,"_":PROG.NAME:".":EDI.TPNAME, 1 THEN PROG.NAME = PROG.NAME:".":EDI.TPNAME END Obviously if your source code exists in multiple files, you would need

Re: Spam:RE: [U2] Printing Reports In Universe BASIC

2007-03-15 Thread Jerry
We use a user setup file with parameters for each user. The id's for the file are the user's login id. We store the users default parameters in the file. We have a program that reads the file when the user logs in for some things and other programs that use other features in the file. The file

AW: [U2] SQL SUM Function

2007-03-15 Thread Babic Marinko
Hello Ron You are right. I tested it now with MR22 and it works :-) Thanks, Marinko -Urspr|ngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Ron White Gesendet: Donnerstag, 15. Mdrz 2007 14:14 An: u2-users@listserver.u2ug.org Betreff: Re: [U2] SQL SUM Fu

Re:[U2] Upper Case Only

2007-03-15 Thread Mecki Förthmann
Hi, the Pick environment will not recognize non-ECL-type P statements, in your case *with @id like XREF...*, when you type the statement in lower case, because in the Pick environment the proper syntax would be IIRC *with @id = XREF:"]"* I think it works the other way round too. Mecki Ron

[U2] [UD] CALL @progname

2007-03-15 Thread David Wolverton
I am writing some code that will execute a variable passed in "progname" using CALL @progname. Question - what is the 'best' way to know that "progname" exists before I attempt the CALL. I thought about reading the VOC, but if it's globally cataloged, that won't work. I could read the VOC and th

Re: Spam:RE: [U2] Reports In Universe BASIC

2007-03-15 Thread Jerry
This situation can be alleviated by setting up certain standards in your company and sticking to them. You don't have to go back and redo your legacy code but any new programs should stick to the new standards. If you need to do some extensive changes to an older program then perhaps you can bri

RE: [U2] Printing Reports In Universe BASIC

2007-03-15 Thread Brutzman, Bill
Consider the following Universal UniVerse printer handler... *--- -- *R0 Bill Brutzman Aug.2006 SUBROUTINE PRINTER.SETUP.R2 ( Mode ) *-- Printer.Setup : begin case

RE: [U2] SQL SUM Function

2007-03-15 Thread David Murray
Marinko, The U2 database is an integer only system, when it comes to using the inbuilt calculations. Numbers should be normalized using the input and output conversions. For instance, money is stored as total number of cents rather than dollars. The conversion code of MD22 will shift the decimal

Re: [U2] SQL SUM Function

2007-03-15 Thread Ron White
Check the file dictionary to see if the conversion is set to MD0. If so, the value will round up to 1679. Change it to MD2 and you should get the correct result. Ron Babic Marinko wrote: Hello I have a single value field EX.NUMBER with the following values: KeyEX.NUMBER A 12

RE: [U2] Reports In Universe BASIC

2007-03-15 Thread Kevin King
From: MAJ Programming >Like helping the newbies with MV, I can now add this >little tidbit to my mental library of techniques >should the need arise. Just because one can doesn't mean one should. In the case of PRINT ON working properly without a corresponding PRINTER ON, imagine six months lat

Re: [U2] Upper Case and Editors

2007-03-15 Thread brian
Arnold Well spoken. I think you will find everyone on this list is in agreement. The difficulty is, that U2 is such a broad technology that giving a short answer to a question is often impossible without referring to other knowledge areas - and giving a long answer can be too much for someone

[U2] DEBUGGER

2007-03-15 Thread Sanjeebkumar Sarangi
hi, How do i use Debugger to debug a Universe basic program.RAID command helps me doing that but I need to know how to use a debugger while compiling with DEBUG option. Thanks, Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may

Re: *** GMX Spamverdacht *** [U2] SQL SUM Function

2007-03-15 Thread Mecki Förthmann
Hi At TCL all calculations are done with whole numbers. Therefore your raw data schould NEVER contain decimal points. I guess the SQL SUM is equivalent to the TOTAL statement in the LIST processor, which would return the same result. As a workaround, you can crate a new dictionary item with a c

Re: [U2] Upper Case and Editors

2007-03-15 Thread Jeff Schasny
Add a line to the bottom of your login paragraph: IF @LOGNAME = "YOURLOGNAME" THEN PTERM -CASE INVERT Arnold Bosch wrote: Thanks Craig - I'm aware of PTERM -CASE INVERT. Unfortunately updating the LOGIN paragraph is not an option, as it impacts 75+ other users. The best I can do is to manua

Re: Spam:Re: [U2] Upper Case and Editors

2007-03-15 Thread Jerry
You can also create a VOC paragraph or sentence with your login ID as the record ID and it will be executed instead of the LOGIN paragraph. - Original Message - From: "Arnold Bosch" <[EMAIL PROTECTED]> To: Sent: Thursday, March 15, 2007 5:56 AM Subject: Spam:Re: [U2] Upper Case and Ed

[U2] Upper Case Only

2007-03-15 Thread Ron Hutchings
Within the pick environment there is situation where you are forced to use upper case: List Voc with @id like XREF... and with Type = "F" The interpreter won't recognize most of this statement. _ Mortgage rates a

RE: [U2] SQL SUM Function

2007-03-15 Thread Dave Davis
First, what are the INTERNAL values of the fields when you look at them in the editor? Are they 12345, 56789, and 98765? Does the field have a conversion of MD2 or MR22? Second, if they are not, are they something weird like 12345.1, 56789.9, 98765.2? Your conversion code may be hiding fractiona

RE: [U2] Upper Case and Editors

2007-03-15 Thread Baakkonen, Rodney A (Rod) 46K
You could put an IF @LOGNAME = and fix it in the LOGIN Paragraph for yourself. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Arnold Bosch Sent: Thursday, March 15, 2007 4:56 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Upper Case and Editors Than

[U2] SQL SUM Function

2007-03-15 Thread Babic Marinko
Hello I have a single value field EX.NUMBER with the following values: KeyEX.NUMBER A 123.45 B 567.89 C 987.65 The result of the following SQL Statement using BCI (UniVerse BASIC SQL Client Interface) is SELECT SUM(EX.NUMBER) FROM YYEXAMPLE USING DICT DYYE

Re: [U2] Upper Case and Editors

2007-03-15 Thread Charles Barouch
Arnold, Brian Leach is the guy to talk to about the Knowledgebase, which would be an excellent place to host any/all how-tos. You can contact himn for details: Brian Leach <[EMAIL PROTECTED]>. The lack of visibility for the Knowledgebase is being addressed as part of the move to the new we

Re: [U2] Upper Case and Editors

2007-03-15 Thread Craig Bennett
Such nobility of spirit! Arnold Bosch wrote: Thanks Craig - I'm aware of PTERM -CASE INVERT. Unfortunately updating the LOGIN paragraph is not an option, as it impacts 75+ other users. The best I can do is to manually issue the command each time I get to TCL. So sometimes one has to suffer a

Re: [U2] Reports In Universe BASIC

2007-03-15 Thread MAJ Programming
You CAN teach an old dog new tricks. Given the endless combinations of using the statements, it hadn't occurred to me that PRINT ON automatically prints to the printer as if PRINTER ON were processed. I used PRINT ON twenty years ago for some simultaneous reports that I was creating as new code bu

Re: [U2] Upper Case and Editors

2007-03-15 Thread Allen Egerton
Arnold Bosch wrote: Thanks Craig - I'm aware of PTERM -CASE INVERT. Unfortunately updating the LOGIN paragraph is not an option, as it impacts 75+ other users. The best I can do is to manually issue the command each time I get to TCL. So sometimes one has to suffer at the expense of others :-

Re: [U2] Upper Case and Editors

2007-03-15 Thread Arnold Bosch
Thanks Craig - I'm aware of PTERM -CASE INVERT. Unfortunately updating the LOGIN paragraph is not an option, as it impacts 75+ other users. The best I can do is to manually issue the command each time I get to TCL. So sometimes one has to suffer at the expense of others :-) Regards Arnold

Re: [U2] Reports In Universe BASIC

2007-03-15 Thread Anthony W. Youngman
In message <[EMAIL PROTECTED]>, MAJ Programming <[EMAIL PROTECTED]> writes No offense but what does PRINT ON have to do with PRINTER ON/OFF. They're sorta unrelated. But using PRINT ON means you don't need to use PRINTER ON/OFF Most of my programming always sent reports to print unit 1. That w

Re: [U2] Error in report generation.

2007-03-15 Thread Anthony W. Youngman
In message <[EMAIL PROTECTED]>, Norman Morgan <[EMAIL PROTECTED]> writes I'm with you on the CAPS issue. I do find the code in caps easier to read. Perhaps I'm just used to it from the first 20 years of my career spent writing COBOL. I think the layout of the code and choice of variable and p

Re: [U2] Upper Case and Editors

2007-03-15 Thread Craig Bennett
Hi Arnold, I haven't really been following this thread -- I gave up and learned to love THE BOMB years ago (despite coming to UV from a C background). With all the above (and more!) happening, I find it annoying having to switch caps-lock all the time - what happens a lot is that I switch to an

Re: [U2] Upper Case and Editors

2007-03-15 Thread Arnold Bosch
I have been following this thread (and some other threads resulting from fairly obvious newcomers to UV/UD) with interest. Being pretty much a newbie to UV myself I'd like to throw in a few comments: Many, if not most, of the regular posters in this list seem to have MANY years of experience in t