RE: [U2] Recommendations for reporting tools
We use Microgen MVQuery for extracting from the U2 database into Excel/Access/SQL. It works and its reasonably priced Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Manu Fernandes Sent: 07 June 2005 08:13 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Recommendations for reporting tools We use Hummingbird/BI Suite. http://www.hummingbird.com BI Manu Fernandes Infodata S.`r.l. Tel : (352) 33 16 48 Fax : (.352) 33 75 55 - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, June 06, 2005 11:04 PM Subject: [U2] Recommendations for reporting tools One of my clients has asked me what reporting tools, other than Crystal Reports other U2 shops favor. Any recommendations of what they might want to evaluate? Thanks in Advance. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata Indexing
That's not a naive question at all. I'll try and answer it. Creating an index on MY_FIELD will probably speed things up. It depends on the cardinality of the data and how many null values there are. For example, if this is a large file, say 10,000,000 records, and MY_FIELD contains something like a state code (MA, CT, CA, etc), your results will be better, but not by much. There are only 50 possible values*, so the index nodes will be rather large. If MY_FIELD contains something like a zip code, where there are thousands of possible values, the index nodes will be much smaller and your select statements should work faster. I don't understand all the internals, but from my experience, I have found that Unidata/Universe handle indexes with low cardinality better than other databases. For your specific question about nulls, it depends on how many nulls you expect to find. Using the above examples, if you only expect a handful of null values, your select statement should work the same in either case and it will be much faster with an index. Did that help? * Please forgive my usage of a possibly politically incorrect and USA-oriented example. Best I could think of on the spur of the moment and no disrespect of great countries like Australia, New Zealand, Puerto Rico, etc, was intended. Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315 x3498 860.523.3690 fax [EMAIL PROTECTED] wrote on 06/06/2005 08:58:28 PM: I've got a naive Unidata question, but figured I'd throw it out there anyway. In short, does indexing a field in a given file help performance when querying for an empty string? ie: SELECT MY_TABLE WITH MY_FIELD='' I've always assumed yes but would like to hear other's thoughts. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 ...our behavior matters more than the beliefs that we profess. Elizabeth Deutsch Earle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Recommendations for reporting tools
We love mvQuery and so do our clients. -Dianne Clifton Oliver wrote: One of my clients has asked me what reporting tools, other than Crystal Reports other U2 shops favor. Any recommendations of what they might want to evaluate? Thanks in Advance. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Printing from UniVerse
Maybe that was a Microdata rule, because I was taught the same exact thing! -Dianne Bill Haskett wrote: Charlie: It's funny you should raise Microdata. I was taught to never use EQUATEs unless I wanted to create a relationship between both sides of the equation. e.g I'd use the following: EQUATE APFILE$CUSTDATE TO APFILEREC(1) This would allow me to manipulate either side of the equate and know both sides would maintain their common value. I could MATREAD the APFILEREC and would know that the variable APFILE$CUSTDATE would be assigned appropriately. I could change the variable APFILE$CUSTDATE and know the record array would be updated simultaneously, so I could then just MATWRITE the APFILEREC and be done with it. However, with EQUATE VM TO CHAR(254) there is no such relationship, so I was taught not to do this as it wasn't the intention of the statement (even though I could). I think I was taught by someone who was very particular about these kinds of things. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Recommendations for reporting tools
On Tue, Jun 07, 2005 at 09:28:16AM -0400, Dianne Ackerman wrote: We love mvQuery and so do our clients. -Dianne How much does it sell for? Their website doesn't seem to say. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Recommendations for reporting tools
You can purchase it from this company : http://www.sandritech.com/ Sandri Technologies, Inc. Mark Ballinger [EMAIL PROTECTED] wrote: On Tue, Jun 07, 2005 at 09:28:16AM -0400, Dianne Ackerman wrote: We love mvQuery and so do our clients. -Dianne How much does it sell for? Their website doesn't seem to say. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing from UniVerse
Bill Diane, I'd hold suspect just about anything this teacher said. That is - to be polite - a unique way of thinking about EQUATEs. There are not 2 slots in memory to update simultaneously. I believe EQUATE on Microdata, UV, and ALL MV-Basics are substantially equivalent in that EQUATE is an instruction to the compiler to substitute the right half whenever it (the compiler) subsequently encounters the term on the left half of the EQUATE. On UV, a VLIST of the program should make that clear. Consider this simple program and its VLISTing: CT CDS.BP BILL 0001 EQUATE APFILE$CUSTNAME TO APFILEREC(2) 0002 DIM APFILEREC( 10 ) 0003 APFILE$CUSTNAME = 'C Stevenson' 0004 APFILEREC(2) = 'C Stevenson' 0005END Notice how line 1 does not actually produce object code. It is just something for the compiler to keep in mind. Notice how lines 3 and 4 compile exactly the same: VLIST CDS.BP BILL 1: EQUATE APFILE$CUSTNAME TO APFILEREC(2) 2: DIM APFILEREC( 10 ) 3: APFILE$CUSTNAME = 'C Stevenson' 3 0 : 0F8 move C Stevenson = APFILEREC [2] 4: APFILEREC(2) = 'C Stevenson' 4 6 : 0F8 move C Stevenson = APFILEREC [2] 5:END 5 C : 190 stop To be fair, said teacher must not have been too bad, though: you're both still here prospering! cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] When do globally cataloged programs get removed?
[EMAIL PROTECTED] wrote: If you can su to root, you can CATALOG the subroutine with the NEWVERSION qualifier, or you can use the 'newversion' command, if not, then you can use the NEWPCODE ECL command to make your current session see the new version, but it won't affect other sessions. We don't have root on this machine... We do have a user with some root privileges, but apparently not enough to use NEWVERSION. But that was enough of a hint to make me check who owns what. I knew that only the owner of the file (or root) can add a trigger to it, but apparently it also matters who owns the executable code for the trigger. I was compiling under my own userid yesterday when the changes were not taking effect. I just compiled as the privileged user, and now it's working. Thanks! -- Wendy Smoak Applications Systems Analyst, Sr. Arizona State University, PA, IRM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing from UniVerse
Thanks Charles! I get so frustrated when running debug and I can't see equates. Your simple statement explained it to me so that I can at least understand WHY I can't see them! Thanks! -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 9:43 AM To: u2-users@listserver.u2ug.org Subject:RE: [U2] Printing from UniVerse I believe EQUATE on Microdata, UV, and ALL MV-Basics are substantially equivalent in that EQUATE is an instruction to the compiler to substitute the right half whenever it (the compiler) subsequently encounters the term on the left half of the EQUATE. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] When do globally cataloged programs get removed?
I wrote: I was compiling under my own userid yesterday when the changes were not taking effect. I just compiled as the privileged user, and now it's working. I shouldn't try to figure things out this early in the morning. It wasn't file ownership or who compiled the trigger subroutine... it was the fact that I didn't realize that I needed to re-catalog globally cataloged programs when they're changed. At least, that's what makes sense right now... -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata Indexing
In a message dated 6/7/2005 6:37:39 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: For your specific question about nulls, it depends on how many nulls you expect to find. Using the above examples, if you only expect a handful of null values, your select statement should work the same in either case and it will be much faster with an index. I think we have to keep in mind what happens in the whole process. While the select itself will process faster (provided you have not specified NO.NULLS when creating the index), we have to ask what you're going to do next with that list ? If the amount of nulls exceeds perhaps, off-the-cuff, ten percent of your database, then you will not enjoy any end-to-end speed improvements in your process. This is because, in processing that list, you will be jumping all over your disk in semi-random order. (Let's assume the entire file is not resident in memory at once.) Because of this thrashing, each READ will take significantly longer than if you simply read the file, in hashed order, from beginning to end, and process only those records with nulls in your target field. So in the end, your timing may show, that an indexed SELECT on a value that is very common, followed by a loop of processing, is actually taking longer, than a non-indexed SELECT, followed by that same loop. And you thought this stuff was easy :) Will Johnson Fast Forward Technologies --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] When do globally cataloged programs get removed?
In a message dated 6/7/2005 8:34:14 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: ... it was the fact that I didn't realize that I needed to re-catalog globally cataloged programs when they're changed. Which reminds me of the trouble I had before I realized that memory-locked (we use to say Core-locked) routines, have to be re-locked before the system will utilize the new version. Not exactly your problem but related to it. Oh yeah in order for that routine to work, we always had to reboot the system (actually heard at a client site). Well , says I, let me show you a little trick. Will Johnson Fast Forward Technologies --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Recommendations for reporting tools
On Tue, Jun 07, 2005 at 07:42:51AM -0700, Dave S wrote: You can purchase it from this company : http://www.sandritech.com/ Yes, I know. I'm just wondering what it costs. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Seeing EQUATES in RAID
In a message dated 6/7/2005 8:34:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Thanks Charles! I get so frustrated when running debug and I can't see equates. Your simple statement explained it to me so that I can at least understand WHY I can't see them! Thanks! This ability should be on our U2 wish list. It seems to trip everyone up at least a few times before they realize what's going on. As I said earlier, an additional table in the op code would take care of the issue for the most part. Will Johnson Fast Forward Technologies --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Need developer with C/C++ experience for contract work
Hi, I realize this group deals primarily in PICK basic development, but hopefully there are some multi-talented individuals out there (or a reference to someone who is.) My company needs someone with C/C++ experience on AIX 5.x using XLC and/or gcc compilers. Specifically, we need someone to modify make files (that are configured for RH Linux) to compile a set of libraries that were provided by a third party. Work to be done remotely and I would estimate it would take 8 - 16 hours for this project. Rate is negotiable based upon level of experience. If interested or if you might know of someone who would be interested, please email me at [EMAIL PROTECTED] Thanks, Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] When do globally cataloged programs get removed?
Yeah, and watch the s__t fly when you find out that the globally cataloged routine is running in several other accounts and the object code for the locally or directly catalogued routine is different than the globally catalogued routine. Just a word of warning. Regards, Ian Renfrew - Original Message - From: Dave S [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, June 07, 2005 11:50 AM Subject: Re: [U2] When do globally cataloged programs get removed? I remember getting a tip from a co-worker to decatalogue the program twice. On the second decatalogue, the global catalogue is removed. [EMAIL PROTECTED] wrote: In a message dated 6/7/2005 8:34:14 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: ... it was the fact that I didn't realize that I needed to re-catalog globally cataloged programs when they're changed. Which reminds me of the trouble I had before I realized that memory-locked (we use to say Core-locked) routines, have to be re-locked before the system will utilize the new version. Not exactly your problem but related to it. Oh yeah in order for that routine to work, we always had to reboot the system (actually heard at a client site). Well , says I, let me show you a little trick. Will Johnson Fast Forward Technologies --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Discover Yahoo! Get on-the-go sports scores, stock quotes, news more. Check it out! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata Indexing
On Tue, 7 Jun 2005 [EMAIL PROTECTED] wrote: I think we have to keep in mind what happens in the whole process. While the select itself will process faster (provided you have not specified NO.NULLS when creating the index), we have to ask what you're going to do next with that list ? If the amount of nulls exceeds perhaps, off-the-cuff, ten percent of your database, then you will not enjoy any end-to-end speed improvements in your process. This is because, in processing that list, you will be jumping all over your disk in semi-random order. (Let's assume the entire file is not resident in memory at once.) Because of this thrashing, each READ will take significantly longer than if you simply read the file, in hashed order, from beginning to end, and process only those records with nulls in your target field. So in the end, your timing may show, that an indexed SELECT on a value that is very common, followed by a loop of processing, is actually taking longer, than a non-indexed SELECT, followed by that same loop. And you thought this stuff was easy :) Will Johnson Fast Forward Technologies --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 ...our behavior matters more than the beliefs that we profess. Elizabeth Deutsch Earle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing from UniVerse
At 18:22 -0700 2005/06/06, Bill Haskett wrote: However, with EQUATE VM TO CHAR(254) there is no such relationship, so I was taught not to do this as it wasn't the intention of the statement (even though I could). I think I was taught by someone who was very particular about these kinds of things. :-) Coming from a C background, I always use EQUates for any constant that isn't going to change. I look at EQUates the same as a C #define statement. I bet you instructor didn't like that use of EQUates because he's see too many times where somebody forgets that the variable is really a constant and gets an error when trying to assign a value to the constant. That is specifically why I like to use EQUates like this, so I don't have to worry about a constant getting clobbered. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)| .=. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing from UniVerse
One of the programming standards I've seen names all equates with a trailing $. System subroutines start with a $ and I thought this was a pretty slick way of knowing instantly that it's an equate, not a variable, while browsing the source code. BobW Coming from a C background, I always use EQUates for any constant that isn't going to change. I look at EQUates the same as a C #define statement. I bet you instructor didn't like that use of EQUates because he's see too many times where somebody forgets that the variable is really a constant and gets an error when trying to assign a value to the constant. That is specifically why I like to use EQUates like this, so I don't have to worry about a constant getting clobbered. Ray --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing from UniVerse
Bob, In all the places that I have worked without standards, I have applied the standard you refer to with variables names. It's great. Additional, I don't rust DICTs I look at the EQU item for a true description of what the field is and what it does. 016: * ITEM ID = CONO '!' REJECT# 017: 018: DIM MAT.REJ.REC(40) 019: 020: EQU MR.ENTER.DT$ TO MAT.REJ.REC(1) ;* S Entered Date 021: EQU MR.INSPECTOR$ TO MAT.REJ.REC(2) ;* S Inspector# 022: EQU MR.PONO$ TO MAT.REJ.REC(3) ;* S Purchase Order# 023: EQU MR.VENDNO$TO MAT.REJ.REC(4) ;* S Vendor# At 01:18 PM 6/7/2005 -0700, you wrote: One of the programming standards I've seen names all equates with a trailing $. System subroutines start with a $ and I thought this was a pretty slick way of knowing instantly that it's an equate, not a variable, while browsing the source code. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing from UniVerse
It is very time consuming to code this way. However, you do end up with self-documenting code. --- Peter Gonzalez [EMAIL PROTECTED] wrote: Bob, In all the places that I have worked without standards, I have applied the standard you refer to with variables names. It's great. Additional, I don't rust DICTs I look at the EQU item for a true description of what the field is and what it does. 016: * ITEM ID = CONO '!' REJECT# 017: 018: DIM MAT.REJ.REC(40) 019: 020: EQU MR.ENTER.DT$ TO MAT.REJ.REC(1) ;* S Entered Date 021: EQU MR.INSPECTOR$ TO MAT.REJ.REC(2) ;* S Inspector# 022: EQU MR.PONO$ TO MAT.REJ.REC(3) ;* S Purchase Order# 023: EQU MR.VENDNO$TO MAT.REJ.REC(4) ;* S Vendor# At 01:18 PM 6/7/2005 -0700, you wrote: One of the programming standards I've seen names all equates with a trailing $. System subroutines start with a $ and I thought this was a pretty slick way of knowing instantly that it's an equate, not a variable, while browsing the source code. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Again with Setting a Network Printer in Linux
Hola all - So, I've tried the various options outlined here in other related email, but our setup is failing consistently. What happens is this: I can setup a printer, B009A for example, in CUPS or as an lp printer, doesn't seem to matter. Linux (RH 3.5) printing is fine, test are all ok lp from the bash line are good as well, output is dandy. When printed from the TCL prompt like this: SP-ASSIGN F24 (and the printer B009A has form 24 loaded up) COPY CRIT PTEST (P I get good output. But when I try to print from within local PICK programs, which work fine on our hopefully-soon-to-be-replaced-if-I-can-fix-this-issue Irix system, nothing, they disappear entirely. My spooler log shows: P Print PR24 2 528 UniVerse 24 06/07/2005 18:49:51 lpstat is clear, but no output. The only exception to this is when I have the printer setup as a RAW printer, in which case I do get output but it is incomplete -- a few boxes are drawn a small amount of text is output at the top of the page. My programmer assures me he's doing nothing odd with the printing, and I believe him (can post some code here if that will help, I need to find the explicit printing code first) but damned if I can think of anything else going on. Again, all jobs are properly logged in my spooler log files but no output. ANY hints/thoughts/ideas greatly appreciated. Peter Stu Glancy wrote: You need to setup DEVICE by edit or uv admin. UV admin is best because you will need to reread the spooler configuration files and you are prompted for this. On my Linux the TCl command is MOTIF SYSTEM.ADMIN or SYSTEM.ADMIN in the uv account. Marc Hilbert wrote: I have tried reading the manual. How can I set up access to a network printer under UV 10 with Linux Redhat 9.0. From the Linux shell I can successfully print, but from UV all I get is the following message every minute or so... Unable to open device. Verify that the printer is on line... Thanks in advance, Marc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/