RE: [U2] [UD] Possible causes of corrupt data on a UniData static file
[demime could not interpret encoding quoted-printable - treating as plain text] My guess is that you have real records with real Ids that you can access. Then you have other records that appear to have the same Ids but really don't. It sounds like these other records are hashed into the wrong groups - hence your inability to access them. I would try creating another file with a different modulo then copy the records from the current file to this new one. They should re-hash, and then maybe you can get to them. Dick Kryka | Director of Applications CCCS of Greater Denver | Paragon Financial Services a Division of Money Management International 10065 East Harvard Avenue | Suite 210 Denver, CO 80231 D: 303-632-2226 | F: 303-632-2101 | M: 303-907-1907 [EMAIL PROTECTED] -Original Message- I wish it were that easy. READNEXT and READ can't get it's hands on these records. The information in this email is intended only for the personal and confiden= tial use of the designated recipient above. If the reader of this message i= s not the intended recipient or an agent responsible for delivering it to th= e intended recipient, you are hereby notified that you have received this do= cument in error, and that any review, dissemination, distribution or copying= of the message is strictly prohibited. If you are not the intended recipie= nt, please contact the sender immediately by reply e-mail and destroy all co= pies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How does one safely validate that a session is connected in UniObjects (VB VB.Net)
Jef Lee wrote: I believe the IsActive property is not entirely accurate... From my tests, you are right about IsActive - it is the results of the last connection (I think) and has nothing to do with the current state. I added a timer function to our VB front end that runs every 60 seconds and just opens a file. If the connection has been lost, the open is unsuccessful. We display a message informing the user that the connection is broken and they need to log on again. This function has almost no overhead and keeps users from spending several minutes or more on a form, then discovering that nothing was saved. It also solved the timeout issue where people would go into a meeting or out to lunch and their connection would be timed out for inactivity. The function runs from only from 6am to 8pm, their local time. If users go home at night without logging out, their connection is still logged out for inactivity instead of being connected all night. Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Get a grip - was ads - was U2 University Last
I'm totally with Clif on this. I subscribe because there are a few nuggets that I grab onto and save. Most of the stuff that passes by really doesn't affect or interest me, but I just skim and delete it using my adult reasoning capacity - the same adult reasoning capacity that allows me to distinguish a sales pitch or opinion from information. BTW, I really don't care what anyone else's opinion is of SQL, Relational Databases, Cobb, coding style, editors, Unix, Windows, politics, etc, etc, etc. In fact, I find most of that irritating and condescending. When I get too tired of having to filter it out, I will unsubscribe. Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] -Original Message- I already explained the reason the U2 Community list was started. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Weird SEARCH Results
Original: No control characters. It doesn't matter what I search for, this program will never turn up in the results. If you SELECT ROM.BP, does this program get selected? I'd guess something wrong with the file so the SELECT doesn't get this program. Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I need a favor
I got stuck with file names like CLIENT-MASTER, CLIENT-CRED-FILE, etc. You should convert dashes in file names to periods or underscores in the variable names. Otherwise, you get: OPEN 'CLIENT-MASTER' TO CLIENT-MASTER.FILE ... READ CLIENT-MASTER.REC FROM CLIENT-MASTER.FILE, CLIENT-MASTER.ID ... UV compiler doesn't like variables with dashes. Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Thursday, July 26, 2007 9:02 AM To: u2-users@listserver.u2ug.org Subject: [U2] I need a favor All, I just put up a new (free) tool on my site. It takes very little time to use and I'd appreciate it if some of you would beat on it and let me know what you think. http://www.keyally.com/fasterskel/Main.php5 -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- 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] Universe Phantom
Is it possible to issue a phantom from OS? I have several jobs that are run through the Windows scheduler. Simply set up a batch file, and schedule the job to execute the batch file. Sample batch file: echo start UniVerse End Of Day job cd IBM\uv bin\uvsh.exe RUN UVSOURCE END.OF.DAY echo finished with End Of Day Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Phantom
These are all good suggestions, but the issue is I cannot tell if the job failed due to an out of licenses condition. I concur with prior respondents - if it is mission-critical, buy more licenses. The issue for me (and anyone who knows more can correct me) is that you are allowed 10 sessions from one workstation (or server) and these 10 sessions consume one license. So if you have several batch jobs that run concurrently during the day, they are just one license. Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Reverse calculating taxes
Here is a routine a very smart programmer showed me a long time ago, and I have used it many times since for all kinds of situations like this: TOT.TAX is the total you need to divide up TAX.PCT.ARR is the multi-valued array of various tax percents TAX.AMT.ARR is the returned multi-valued array of tax amounts for each tax percent Code to process and make sure the total of the individual taxes matches the TOT.TAX. You need to adjust where needed for decimals, etc: TAX.AMT.ARR = '' TOT.TAX.PCT = SUM(TAX.PCT.ARR) MAX = DCOUNT(TAX.PCT.ARR1,@VM) FOR K = 1 TO MAX TAX.AMT.ARR1,K = TOT.TAX * (TAX.PCT.ARR1,K / TOT.TAX.PCT) TOT.TAX -= TAX.AMT.ARR1,K TOT.TAX.PCT -= TAX.PCT.ARR1,K NEXT K The reason this works is the two lines of subtractions. In the last iteration, you are multiplying the remaining tax amount by 1. -Original Message- Any idea's! Does anyone think the current calculation is ok. Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Resize
Original Message: Just noticed something strange...I RESIZE to these specs and run HASH.HELP. My response: I have noticed that HASH.HELP is strange like this on UV W2K. You can end up resizing the file over and over and over because the recommendations, including the file type, change as you resize the file. Best bet is to stop after one use of HASH.HELP. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Programs slowing down after many iterations
Part of original message: We scratched our heads over this for quite a while. Eventually, we put a named COMMON statement in the program and listed all of the file variables as part of it. Then we put some code to check if the files were already open in front of the OPEN statements, to avoid re-opening. I'm not sure if this second step was really necessary. Response: I use named common extensively, and always use a convention like this because we have several accounts (including a test account) that look alike. COMMON /COMMONNAME/ FILE1, FILE2, ETC, ETC, INIT.PATH IF INIT.PATH # @PATH THEN OPEN FILES ETC INIT.PATH = @PATH END This way, the named common cannot jump to another account and reference files on a different account. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A Barrett Sent: Thursday, September 01, 2005 7:52 AM To: u2-users@listserver.u2ug.org Subject: [U2] Programs slowing down after many iterations Here's the situation. We noticed this first with a subroutine intended to be used as part of an I-descriptor in Universe. It's a program that we use all over the place because it looks into a number of places and comes up with the status of a policyholder on a particular date. It needs to open a number of files to do this. We did a SELECT using a dictionary item calling this routine, and noticed that it was taking forever. This was unusual. We killed it and started it again, and when it didn't improve we did some more investigation. What we found was that the LIST or SELECT started off very fast, but then got slower and slower over time. If we stopped the LIST/SELECT and restarted it right away it would start off very slow. If we stopped the LIST/SELECT, then QUITted out of UV, and then went back in and restarted it, it would start up fast but then eventually slow down. When we restested, we found that the LIST/SELECTs really flew, and set new speed records for completing. Something about file handling was the issue. This system has been in place for 10 years. We haven't upgraded Universe for several years (we're on version 10). This just started happening. Furthermore, when we checked our test system, we found that it also exhibited exactly the same behaviour. This would seem to rule out any system or hardware specific event. I consider the named common trick to be a work-around. Has anyone else noticed the same thing? If so, does anyone know any other way to stop this from happening? thanks, Dave Barrett, Lawyers' Professional Indemnity Company --- 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] Uvbackup to disk
Dan Fitzgerald wrote: Is there an option to uvbackup (without the uvadm gui) to direct output to disk instead of tape? Running UniVerse 10.0.10 on Windows MS 2000 Server, I use this batch file set up as a Windows scheduled job to send the uvbackup output to a another server: -- I:\Informix\uv\bin\uvbackup -f -v -s \\192.10.21.52\I$\Backup\Backup-CCCS-Denver.log -walk I:\Informix\uv\CCCS-Denver \\192.10.21.52\I$\Backup\Backup-CCCS-Denver.dat -- This gives me a backup file and a log. Note: this is one line all strung together. I use this batch file to restore: -- rmdir /s /Q I:\Informix\uv\CCCS-Denver I:\Informix\uv\bin\uvrestore -F I:\Informix\uv\CCCS-Denver\*=Informix\uv\CCCS-Denver\* -s I:\Backup\Restore-CCCS-Denver.log -U -noindexfix -v I:\Backup\Backup-CCCS-Denver.dat -- Again, the line starting with I:\ is one line. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVLICTOOL required often, why?
Part of original from Gwen Buck: Yay! Misery Loves Company! I have the same problem on Win 2K, running UV 10.0.21. My response: We are running UniVerse 10.0.10-2 on MS2000 Server, with up to 100 users with a VB front end using UniObjects. The only time I see an issue with having to use uvlictool is when we have a communications, network, or other problem where the users get disconnected and cannot log off normally. I also see this during testing program changes where the VB or UV programs abort. The users are left hanging in UV and I force log them off. Sometimes this leaves licenses hanging, sometimes not - I have not detected the pattern. In the normal course of events, I go several months without having to use uvlictool to clean up licenses because our users log off and disconnect in a normal manner. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Order of criteria
I agree with Kevin's answer. Also, it may depend on which U2 product/pick-like product you are using. I always try to order the WITH statements so the one selecting the fewest records is first. However, I always place the fields with translates last since I know that translates are much more expensive than looking at data within the record. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary? For example, if I wanted to select vendors who sell apples in Denver, is Select vendors with location='Denver' and products='Apples' the same as Select vendors with products='Apples' and location='Denver' Given that out of 300 vendors, 50 sell apples, and 100 are in denver, and 15 of those in Denver sell apples. If it does matter, should I put the criteria that is likely to return the smallest result set first? TIA, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe MALLOCTRACING
One of the things I have done in this situation is to have the purge program sleep for 10 or 15 seconds every several hundred records. I know this is hokey, but it seems to allow the file I/O buffers time to catch up. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Wednesday, February 23, 2005 3:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe MALLOCTRACING Ok then I'll leave that one alone. Maybe you can shed some light on this situation. I have a 'purge' program that takes invoices in OM, OI (header and line item files), writes them to OM.H, OI.H (history files), then deletes them from the OM, OI. When we were on DG/UX, this purge could run during the day and it really wouldn't affect 'things' too much. Now that we're on the IBM/Linux box, it really can't be run during the day, because it seems to be hogging up all the Universe resource and everyone comes to a complete crawl. The files are all Dynamic and pretty well overflowed. I know this is causing some of the grief (even though it didn't have the same effect on the DG system). What would you do to try to debug this situation ? For example, there a points in this process when the users will get processed, then everything seems to freeze, then it moves, then it freezes... I would love to know what Universe is doing during this 'freeze'. Thanks Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Meeks Sent: Wednesday, February 23, 2005 3:30 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Universe MALLOCTRACING No, it won't... I originally put this facility in as an alternative to commonly available memory tracing facilities, such as Purify and the like, due to it's unavailability on certain platforms. It allowed for the tracing of malloc/calloc/realloc/free calls across the product, checking for memory overruns, double frees, and other related memory corruption issues. Sadly, because it was put in at the very end of my time with VMark/Ardent/Informix (as I went with the Ascential crew), it was never fully implemented to hook into the tunable, at least to my knowledge. Right now, it requires a special build to enable it, and isn't tied to the tunable unless that special build has taken place. Even with it, it wasn't geared at being a performance or memory consumption utility, but rather, memory corruption checking. One thing to check is whether the CORE verb is enable on your system. If your version of UV has the CORE verb working, you can glean some information related to memory consumption that may provide some assistance. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Wednesday, February 23, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe MALLOCTRACING Has anyone got any information on this param in the uvconfig; # MALLOCTRACING - Turns on malloc tracing for UniVerse Support analysis. MALLOCTRACING 0 I am still having some performance problems that I am trying to get a handle on. I am interested in knowing if this would help me or not. Thanks Anthony Dzikiewicz --- 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/ --- 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] Checking the global catalog?
You can run MAKE.MAP.FILE and look in the _MAP_ file on UniData or MAP file on UniVerse. The dictionaries of these files is good, so you can list from there. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, February 11, 2005 2:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] Checking the global catalog? If I want to check whether I have accidentally globally cataloged something (a pattern) is there a way I can check, the way I can SELECT VOC WITH @ID...? Thanks, Wendy Smoak --- 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] Named Common Issues in UV
Colin Alfke wrote: In UniData (not sure about UniVerse) the named common name is only significant for the first 7 digits. So your VBNOTEPAGE3 will be the same as VBNOTEPAGE1. IE. you may think the name is unique but the system doesn't. The name looks like there might be others with a similar name so this could be your problem. In UniVerse, the first 31 characters of the name are used according to the documentation. I tested for this issue when I set up the names because I am used to this limitation on UniData. Thanks. Dick Kryka --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Testing if a Unidata file has records or not!
I would do this: SEL.8 = 8 OPEN '', 'TEST.FILE' TO OPEN.FILE THEN SELECT OPEN.FILE TO SEL.8 READNEXT ID FROM SEL.8 THEN HAVE.RECORDS = 1 END ELSE HAVE.RECORDS = 0 END CLEARSELECT SEL.8 END This should work on UV and UD. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- I am writing an interesting program. One that finds where a file is empty of records or not. I used the EXECUTE command with the COUNT command to get the number of records in a file. If its 0 then the file is empty. But is there a better way as the execution command causes problem in other parts of this program. So, if anyone has any ideas along the lines of telling if a file is empty (Unidata file), could you please give me a note! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT MV-Base
Mark Johnson wrote: I'm gonna try the method whereby all writes go to a single ported file and then UEXECUTE it to the desired destination. I can do multiple writes to different files, albeit they all remain locked. Mark: It has been a while since I wrote similar programs for an mvBase client, but I recall having the same problem when working remotely from my home office. When these same programs are run in the client office, they do not have this problem. Sorry, I never figured out the solution -- just learned to live with it by not doing this type of testing except when in the client office. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, November 22, 2004 6:48 AM To: [EMAIL PROTECTED] Subject: Re: [U2] OT MV-Base I'm gonna try the method whereby all writes go to a single ported file and then UEXECUTE it to the desired destination. I can do multiple writes to different files, albeit they all remain locked. Thanks. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PICK Assembler Language
I'm not in front of an MvBase system, but try .? to see a list of the . commands. I don't remember the command, but one of them turns off stacking all executed commands so it stacks just the commands entered at TCL. Unfortunately, as I recall, you have to do this each time you log in, and I could not get this to work in the login proc. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Wednesday, November 10, 2004 7:18 PM To: [EMAIL PROTECTED] Subject: Re: [U2] PICK Assembler Language Since we're on MVBase I have a bone to Pick (no pun intended). Is there any upgrade to their command stacker. It's pathetic, especially since it retains every executable statement, not just the ones I type. Thus, it very easily exceeds the display (20) and I spend more time finding the previous statement that it would take typing it. just asking. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] READU ... THEN _or_ ELSE but not both?
I like this format: READU RECORD FROM FILE, ID LOCKED END THEN END ELSE END Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, October 29, 2004 3:08 PM To: [EMAIL PROTECTED] Subject: [U2] READU ... THEN _or_ ELSE but not both? From the documentation: READU dyn.array.var FROM [file.var,] record.ID.expr [LOCKED statements] [ON ERROR statements] {THEN statements [END] | ELSE statements [END]} Am I reading this right? When I READU I can either have a THEN or an ELSE, but not both? (That it does not compile with both tends to confirm that...) er.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] LOGOFF Equivalent
Here is my process, gleaned from this group. UV 10.0.10 on MS2000 Server: Start with number 1 and work up to 4 when the lower number doesn't work. Use number 4 only as a last resort. The userno is from the LISTU command and is the same as the PID in the Task Manager. I have never had any luck using the Windows Task Manager on the server to log off a UniVerse process. LOGTO UV for all of these commands. 1) MASTER OFF userno Try this 2 or 3 times. Sometimes it takes more than one command. 2) DOS To open a DOS window. Then enter BIN\KILL userno Do this 2 or 3 times. It takes several seconds for the first command to finish. Sometimes the first time is not successful, but the second or third is. When finished, EXIT from the DOS window. This almost always works, and I do not have to resort to number 3 or 4 below. 3) DOS BIN\KILL -2 userno Again, try this 2 or 3 times, then EXIT back to UV. 4) DOS BIN\KILL -9 userno Again, try this 2 or 3 times, then EXIT back to UV. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- Can someone tell me what the best method is for gracefully terminating a Universe program? Something equivalent to a Pick LOGOFF ? Thanks. Perry Taylor Zirmed, Inc. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Comparison Unidata and Universe
I didn't mean to start the editor discussion, but it was informative. Anyway, AFAIK UniData supports only Prime-type dictionaries, while UniVerse supports both Pick and Prime style dictionaries. If converting from a Pick system, UniVerse is easier from a dictionary standpoint. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Beahm Sent: Friday, September 24, 2004 8:51 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Comparison Unidata and Universe I didn't voice my opinion earlier because I know this list has a lot of developers with more experience in both than I do, but here goes... flameproof suit on One of the most critical elements in the MV market has been cross-system compatibility. Companies have invested in systems and like what they've got -- they just want to move to a newer box and/or add new capabilities. UniData and UniVerse, having been originally developed by different companies, meet this need in different ways. In UniVerse, one creates an account and decides what flavor the account will be. Largely this is a matter of command line and BASIC syntax, although it also affects details such as how select lists are handled in certain situations, etc. There are some ways to add elements from alternate flavors, but things are generally set once you create the account. In UniData, the different syntaxes and behaviors are intermingled but can be specifically accessed by setting runtime variables (UDT options, BASICTYPE, ECLTYPE, using lowercase commands) at the command line or within programs. If you wanted to bring together code from a variety of systems, UD would probably support that better than UV. Even so, the syntax is about 80% identical between them. Each has unique methods for file processing, which comes dramatically into play when file sizes exceed 2GB. AFAIK UniData has one method for dealing with large files (make them dynamic), while UniVerse has a few (part files that break one file into many, 64-bit file addressing, maybe something else?) The UniData debugger is significantly better than UV's, however I believe if you use UniDebugger this point becomes less significant. Both provide nearly identical support for UniObjects in developing VB/VCC/.Net/Java applications. UD has a GUI tool for defining ODBC schema while UV relies on DICT entries and a few other settings. It seems to me that UV tries to figure things out for ODBC on the fly, while UD decides ahead of time and applies less forgiving but faster logic. There are dozens of little things that one offers that the other doesn't, things one person loves and another hates. For instance I wish UD supported Q-pointers (shortcuts to files in other accounts), and I wish UV allowed sending LIST output straight to a file the way UD does. In both cases I made workarounds for these, but it's always nicer to have these things out of the box. Fortunately, features added to one are also being added to the other, so IBM is doing a nice job with that. flameproof suit off I hope that helps clear things up, and I hope I didn't get too much wrong. ;^) I expect others will be along shortly with corrections/explanations/rationalizations/pontifications. Best, David Beahm Bob Little wrote: [EMAIL PROTECTED] wrote: Since this thread seems to be going on forever.. Yes, it does. But we've strayed considerably from my original question which was: What's the difference between UniVerse and UniData? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Comparison Unidata and Universe
I know this is probably not the highest on others lists, but the UniData editor is like god next to the pitiful excuse of an editor that UniVerse provides. I don't understand why IBM doesn't release the UniData editor with UniVerse and do away with the UniVerse version. In addition, the UniData debugger is at least an order of magnitude better than the RAID debugger on UniVerse. As someone who has spent the last 12 years fixing and debugging code written by other, these two issues are important to me. For Basic programming, UniData is IMHO much, much better than UniVerse! Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Smith Sent: Friday, September 17, 2004 2:21 PM To: [EMAIL PROTECTED] Subject: [U2] Comparison Unidata and Universe Group, I was just talking to someone like myself who is trying to decide between Unidata and Universe. We are coming from d3 and mvBase and really would like someone experienced with both to give and overview of the strengths and weakness of both - that is Unidata vs Universe. Thanks to all that reply. grs --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Correlative referencing multi-value field in another file
The translate returns MV data with spaces. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills Sent: Wednesday, September 01, 2004 9:11 AM To: [EMAIL PROTECTED] Subject: [U2] Correlative referencing multi-value field in another file We are trying to do a very basic PICK technique of summing a multi-value field in a F-type correlative. However, it appears uniVerse is not putting the multi-values onto it's stack as inividual values, but rather as one entry with the value markers replaced with blanks. Below are two dictionary definitions, the only difference is WO.COMPL.QTY does a sum as its last step. As can be seen by the LIST output, only single-value entries return a non-zero value. Anyone else come across this? And should it be working this way? We are on UV10.0.16 and HPUX11i. Thanks in advance -- Rod Hills WO.COMPL.QTY 0001 A 0002 0 0003 Wo Compl}Total 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8);S 0009 R 0010 8 WO.QTY.COMPL 0001 A 0002 0 0003 Wo Qty Compl 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8) 0009 R 0010 12 LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am 31 Aug 2004 PAGE 1 WIPOPERACT Wo Compl Wo Qty Compl Total... 89783*560 44 89433*111 0 14 1 78574*370 03 5 6 1 5 84804*780 0 2 2 3 3 5 3 88810*070 0 R7735*380 0 15 2 1 89922*630 0 60330*001 0 79101*000 0 18 60 5 2 10 3 2 90032*050 0 82930*110 0 88671*001 2937 2937 90449*260 0 3 20 4 3 60268*790 0 60129*720 0 79312*380 22 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Error 30107 when calling SubRoutines from UniObjects
I'm certainly not a VB expert, but I think the failure may have to do with this line: Dim cu As Object = m_uniobject.Subroutine(MVACNOT, 4) Here is a snippet of code from our application: Public Sub Load_Detail() 'Declarations Dim DetailObj As Object Dim ResultArray As Object Const TOTAL_PARAM = 11 'Main Set ResultArray = CreateObject(UV_DARRAY_OBJECT) Set DetailObj = uvSession.subroutine(VBDISTRIBUTEAR, TOTAL_PARAM) DetailObj.SetArg 0, txtCredId.Text DetailObj.SetArg 1, txtInvoiceNo.Text DetailObj.SetArg 2, cmbRfId.Text If OptWriteOff.Value = True Then DetailObj.SetArg 3, WriteOff Else DetailObj.SetArg 3, Receipt End If DetailObj.SetArg 4, strAcctClient DetailObj.SetArg 5, intAcctDebt DetailObj.Call ResultArray = DetailObj.GetArg(6) 'store array in this field for later use txtDetailAccept.Text = DetailObj.GetArg(6) strDistAmount = DetailObj.GetArg(9) strDetailBalance = DetailObj.GetArg(10) intDetailCount = ResultArray.Count End Sub Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: peter watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 8:12 AM To: [EMAIL PROTECTED] Subject: [U2] Error 30107 when calling SubRoutines from UniObjects Hi I am having problems with getting a response from any subroutine I get error number 30107 = The subroutine failed to complete successfully I have even tried setting Arg(0) to but nothing seems to work can anyone help me please. here is my code if anyone can tell me why its not working. Public Function doSubRout(ByVal sRoutine As String, Optional ByVal Params As String = ) As String ' if Connection failed exit function If Not Connect() Then MsgBox(No Connection, MsgBoxStyle.Critical) Exit Function End If Dim myErr As New UniErrors ' Exception on UniObjects Error m_uniobject.ExceptionOnError = True ' Create subRoutine Object Dim cu As Object = m_uniobject.Subroutine(MVACNOT, 4) If m_uniobject.Error 0 Then MsgBox(Error: ( m_uniobject.Error ) + myErr.getErrStr(m_uniobject.Error)) End If Try ' Get date in Universe format Dim Tod As New UniDate Dim sDate As String = Tod.GetUniDate(DateAdd(DateInterval.Day, 20, Now)).ToString() 'cu.Resetargs() ' Set subRoutine arguments cu.SetArg(0, ) If cu.Error 0 Then MsgBox(Error: ( cu.Error ) + myErr.getErrStr(cu.Error)) End If cu.SetArg(1, ZA4) If cu.Error 0 Then MsgBox(Error: ( cu.Error ) + myErr.getErrStr(cu.Error)) End If cu.SetArg(2, sDate) If cu.Error 0 Then MsgBox(Error: ( cu.Error ) + myErr.getErrStr(cu.Error)) End If cu.SetArg(3, OW) If cu.Error 0 Then MsgBox(Error: ( cu.Error ) + myErr.getErrStr(cu.Error)) End If ' call the subRoutine cu.call() If cu.Error 0 Then MsgBox(Error: ( cu.Error ) + myErr.getErrStr(cu.Error)) Else ' Display results MsgBox(Args: cu.GetArg(0) , cu.GetArg(1) , cu.GetArg(2) , cu.GetArg(3)) End If Disconnect() Catch ex As Exception ' Error handling If cu.Error 0 Then MsgBox(ex.Message + vbCrLf + UniVerse : Error: ( cu.Error ) + myErr.getErrStr(cu.Error)) End If Disconnect() System.GC.Collect() Return End Try ' Return Result Return Args: cu.GetArg(0) , cu.GetArg(1) , cu.GetArg(2) , cu.GetArg(3) End Function This is the first line of the subRoutine I need to call SUBROUTINE MVACNOT(RETURN.SUPPLIER,ACCOM.CODE,REPORT.DATE,SEARCH.TYPE) When the system calls this subroutine internally it uses the following SUBR(MVACNOT,@ID,'DATE()','OW') Pete The information in this electronic mail message is Confidential and may be legally privileged. It is intended solely for the addressees. Access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's employer is not liable for any loss or damage arising in any way from this message or its attachments. -VRG3a- --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] D3 Master Dictionary
Its been a while, but I seem to recall that Pick changed the name from MD to DM. Try placing your BOB there. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 3:46 PM To: [EMAIL PROTECTED] Subject: [U2] D3 Master Dictionary Pardon being a D3 question but someone may have run into this before. My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and 003=P, saved it and then type BOB at TCL and get [3] VERB?. I type LIST CUSTOMER and get output but when I type LIST MD = CUSTOMER I get nothing. I've found out that there's 2 MD's. One called MD which points to that accounts SYSTEM defined space and another called M/DICT which points to another account that contains the cataloged programs, filenames, verbs etc and lets BOB work. So my question is what would happen if I made MD point to that other account? Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to try this. Please no VOC flames. Thanks. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users