[U2] Business ?
Does anyone know much about FW Davidson http://www.fwdco.com? They came across my radar and I see references to Unidata along with SQL and Oracle. Just curious if anyone know precisely what solution(s) they run on Unidata... -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] unidata index
Stupid index question: does indexing a field help performance when sorting BY that field but it's not otherwise involved in the query? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
On 3/3/14, 2:58 PM, Brian Leach wrote: Jeff Try mvQuery, that should not have any problems with those volumes. Hi Brian We've isolated the problem to Unidata itself, not the reporting tool. In short, when we do a LIST with about 150 fields, it throws: too many items in LIST As soon as we erase a field (any field), the LIST statement runs properly. Unfortunately, I cannot locate any parameter that might control this. I thought we were hitting U_SENTLEN - but we're nowhere near that value. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
On 3/3/14, 3:21 PM, Jeff Schasny wrote: Jeff, What I think many of us are suggesting is essentially if it hurts when you do that, don't do that i.e. if the query language won't accomplish what you want to do, use something else. Jeff Believe me - I hear you (and others). But my administration isn't listening because they all think this is a reasonable request (excel can handle 200+ columns). So if I can't make this work in Unidata I'll have to move to MSSQL which I really, really, really don't want to do. At this point I'm just trying to understand the limit on the number of fields in a LIST statement. I know in my case that it's not a sentence length issue as I might've thought earlier so I'd like to know what is causing this (with the understanding that I very well may not be able to solve this). Jeff jeffrey Butera wrote: On 3/3/14, 2:58 PM, Brian Leach wrote: Jeff Try mvQuery, that should not have any problems with those volumes. Hi Brian We've isolated the problem to Unidata itself, not the reporting tool. In short, when we do a LIST with about 150 fields, it throws: too many items in LIST As soon as we erase a field (any field), the LIST statement runs properly. Unfortunately, I cannot locate any parameter that might control this. I thought we were hitting U_SENTLEN - but we're nowhere near that value. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
On 3/3/14, 4:01 PM, Daniel McGrath wrote: Hi Jeff, In case you missed it before: Does your query use the LIMIT keyword? This is an internally hardcoded limit that was increased, IIRC, in 7.3.6 to 250. On further checking, here is the issue, along with fix version. I suggest you update to the latest UDT version. UDT-4284 - Request for UniQuery hard limit of 150 attributes (in LIST or REFORMAT commands) to be increased A change was made to increase this to 250 attributes in 7.3.5. The actual limit has now been added to the report from the LIMIT verb so you can see limitation as U_ATTRLIST Thanks Dan - this helps immensely. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Reporting Tools
I'm looking for feedback from those in any industry about your report needs with U2 and what tools you use to solve them. In short, Entrinsik has serious inroads in the academic community and Informer is a reasonably good and inexpensive tool for most reports. However, we are running into issues with some users like to write large reports. Large, by out standards, are reports with 200+ columns in the output. Are others writing reports with this many output fields? If so, are you ever running up against limits in the sentence size (U_SENTLEN)? Our limit is about 9700 chars and we have some reports hitting this limit. I'm having a hard time explaining to some VP types that the database can't handle this size report... Any feedback is welcome. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
On 2/28/14, 9:29 AM, Jeff Lettau wrote: In the past I've made dictionary names that are very short to save characters. But my real reason for responding is I can't help but wonder what you need 200+ columns for? My first instinct when hearing this is that a report is not what you need. To be clear - this is not MY choice of report, I'm trying to explain that they are using a report as a poor person's ETL tool to dump vast amount of data to Excel and manipulate offline. But I though I'd ask the question anyway. How many rows are in this report? Perhaps 10,000 - 30,000 -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Report Limit
Several have responded to my request about U2 reporting with feelings that mirror my own, but now I have a different yet related question. On Unidata 7.3.3, what limit is causing the following in a report: too many names in LIST It seems to appear around 150 fields - if I drop to 149, it runs fine. I'm not running up the @SENTENCE length (9247). I'm not sure if it's simply a limit on the number of fields or something else.A search of both Uniquery Commands Reference and Unidata Commands Reference doesn't reveal anything about this errror (nor does google). My LIMITS only show a cap for virtual fields at 256: U_MAXFNAME: Unix file name limit = 118. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 512. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 20480. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Encryption of data in place
So with the Univ of Maryland's data breach, everyone is starting to ask questions (again). Can someone remind me which Unidata manual covers encryption of data in place? Unfortunately Datatel/Ellucian does not support this, but it wouldn't be the first feature of Unidata we've used without their support... -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Report Generation
Entrinsik Informer does all of that and more. On 1/16/2014 10:23 AM, charles_shaf...@ntn-bower.com wrote: I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other possible solutions. The user has asked for Ability to schedule queries to run at night Ability to automatically distribute reports. I think saving them in a shared area is good enough. Ability to generate charts as part of the scheduled run. Any ideas are appreciated. Charles Shaffer Senior Analyst NTN-Bower Corporation -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Pick 7.3 What is this?
On 01/10/2014 12:57 PM, Wjhonson wrote: On someone's resume I see Pick 7.3. When I try to google for that, I get nothing useful. 7.3 is the latest release from Unidata - just a guess. -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging program execution in Unidata?
On 1/6/14, 7:08 PM, McGowan, Ian wrote: We're looking into a major conversion late this year, which will involve checking out several thousand programs (mostly opens, reads or writes). Some programs are run many times a day, whereas some were throwaway and haven't been touched in years. It would be great to get some sense of which ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Can I assume you're not excited about inserting some logging code into each program simply do to the number of pieces to edit? We have done this programatically with all paragraphs and I image the same approach would be possible with programs. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata index/query ?
Unidata 7.3.3 on RedHat: I have a table with numerous indicies built: File.. H08.CR.COURSE.EVALS Alternate key length.. 20 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed) Indices... 6 (6 D-type) Index updates. Enabled, No updates pending Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr XCCE.STUDENT.ID D NumYes Yes Yes Yes S 8 XCCE.STATUS D TxtYes No Yes Yes S 17 XCCE.COURSE.NAME D TxtYes No Yes Yes S 14 XCCE.TERM D TxtYes No Yes Yes S 12 XCCE.TYPE D TxtYes No Yes Yes S 22 XCCE.SUBJECT D TxtYes No Yes Yes S 23 Since these are data fields (nothing computed on-the-fly) and indexed, queries should be fast.The table has approximately 737,000 records. This query runs in under 1 second: SELECT H08.CR.COURSE.EVALS WITH XCCE.TERM EQ '2013F' However this query takes 10+ seconds (or longer) - even with two indexed fields: SELECT H08.CR.COURSE.EVALS WITH XCCE.TERM EQ '2013F' AND XCCE.TYPE EQ 'FINCRSE' I'm at a loss to explain the second, any insight appreciated. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Calling UniObject directly from Linux?
On 12/02/2013 01:54 PM, McGowan, Ian wrote: http://stackoverflow.com/questions/5877575/a-way-for-c-code-to-access-records-from-the-universe-database https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/unidata/7.2/intrcall.pdf We've used InterCall to write a small C program for direct Unidata access and used it without a hitch for 12+ years. While originally designed for web forms to read/write data, we also have branched out and use it within shell scripts from our linux servers. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso Sent: Monday, December 02, 2013 10:31 AM To: U2 Users List Subject: [U2] Calling UniObject directly from Linux? Hi all. Does anyone know a way to call UniObject directly from Linux? Not UniObject for Java, but directly from a C++ program or similar. I have looking for it but I haven't found anything Any suggestions? Thanks in advance. -- Augusto Alonso I.T. Manager QUITER SERVICIOS CENTRALES ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Large DICT affecting I/O
Thanks to those who replied. 1) we have tools to easily edit dictionaries of any size (one of the few benefits of Datatel/ Ellucian) 2) we have tools to monitor and resize dictionaries just like any other file ( also a Datatel benefit) It's more of a general question about performance. We import data from the Common Application which has almost 2000 data attributes per person. Thus having a large DICT isn't sloppy or lazy work on our end, it's a necessity of the data. Thus the question is better stated as: Is unidata performance better if we stuff all 2000 elements in a single DICT or break the data into multiple (eg: 4) files of 500 elements each? When we work with this data we need all 2000 elements so is reading 4 or 5 separate tables any more efficient than reading a single large table of 2000 elements? Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 On Aug 6, 2013, at 11:16 PM, Doug Averch dave...@u2logic.com wrote: Hi Jeffery: We have a client with 6,000 dictionaries items and they have no performance problems If the dictionary is sized correctly, there generally is no performance hit. However, editing it with some tools is a pain because it takes quite a long time to read them. Regards, Doug www.u2logic.com XLr8Dictionary Editor for large dictionary editing On Tue, Aug 6, 2013 at 9:08 PM, jeffrey Butera jbut...@hampshire.eduwrote: I'm curious how large of a DICTionary some of you have worked with and, in particular, how very large DICTs can adversely affect applications. We have a DICT approaching 1500 data elements (no idescs) - which is quite large for us. But I'm curious if others have DICTs this large or larger and have no adverse affect on their application performance. This is Unidata 7.3.4 if it matters. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Large DICT affecting I/O
I'm curious how large of a DICTionary some of you have worked with and, in particular, how very large DICTs can adversely affect applications. We have a DICT approaching 1500 data elements (no idescs) - which is quite large for us. But I'm curious if others have DICTs this large or larger and have no adverse affect on their application performance. This is Unidata 7.3.4 if it matters. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata configuration question
Looking at a couple of Unidata parameters: SHM_GNPAGES=64 SHM_GPAGESZ=2048 EXPBLKSIZE=16 I'm curious about EXPBLKSIZE. The doc says: EXPBLKSIZE Number of local pages used for expression buffers. udt keeps a buffer of this size for intermediate results. ibm recommends you set this parameter so the buffer is one-quarter to one-half the size of a global page. SHM_GPAGESZ Size of each global page, in 512-byte units. SHM_GNPAGES Number of global pages in a shared memory segment. From my parameters, it appears EXPBLKSIZE is 1/4 of the number of global pages, but the doc says it should be 512 if I use 1/4 of the SIZE of each global page. I'm certainly open to advice on this topic. -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata Index question
I have two question about how indicies affect queries: 1) If I have an index built for a given field FOO, and perform a query with like such as FOO LIKE 'ABC...' does it benefit from the index? Or is it only queries with equality conditions that benefit from the index (eg: FOO EQ 'ABC' )? 2) If I have an index built with Empties=NO and then query with that indexed field =, how does it handle the query? Does it not use the index at all? TIA, Jeff -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
On 04/23/2013 12:04 PM, Wjhonson wrote: Try a different file, that A) you have just created and B) you know certainly is not being used. Same result. Created brand new file from scratch, copied 2000 records into it and attempted to resize: :CREATE.FILE JVB.RSZ 1029,1 :SELECT PERSON SAMPLE 2000 :COPY FROM PERSON TO JVB.RSZ :RESIZE JVB.RSZ 1237,1 CONCURRENT Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. Nobody could've been accessing this file other than me. To be clear - we're not running RFS or replication in our database. I don't think the bit is the issue here. I think that's just a message like can't GET the file OK, but I guess I'm confused. I thought that was the whole point of CONCURRENT - it could resize the file while others were accessing it. Are you claiming that RESIZE CONCURRENT must (initially) have exclusive access and then, while resizing, it's OK if others happen to access it? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
On 04/22/2013 09:49 PM, Jeffrey Butera wrote: I'm attempting some experiments with RESIZE CONCURRENT on Unidata 7.3.3 (RedHat) but failing miserably. I didn't think there was any configuration I needed to enable before using CONCURRENT, perhaps I'm misunderstanding the error message: :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT RESTORE H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. I determined that the problem is RESTORE. If we eliminate that keyword, RESIZE CONCURRENT works. :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. The temporary file for RESIZE is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP.resize. H08.FACULTY.WL.SNAP RESIZED from 3359 to 3593 I'm not yet sure of implications of not using RESTORE or CONTINUE, but I'm ok for now. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata RESIZE CONCURRENT
I'm attempting some experiments with RESIZE CONCURRENT on Unidata 7.3.3 (RedHat) but failing miserably. I didn't think there was any configuration I needed to enable before using CONCURRENT, perhaps I'm misunderstanding the error message: :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT RESTORE H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. I've read all the manuals and cannot find anything referencing the RESIZE_CONCURRENT bit. Any insight appreciated... -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] unidata env var
We've had some issues with i-desc failing over years and the solution was to set the evironment variable VFIELDSIZE to some amount (6000 or more). My real question is does unidata care about case for this variable (on *nix, not windoze)? I've seen it documented both as VFIELDSIZE and vfieldsize and not sure unidata sees one or both of these. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] unidata env var
Blame the vendor (Datatel) for piggish code. Jeff Butera -- A tree falls the way it leans. Be careful which way you lean. The Lorax On Mar 21, 2013, at 9:37 AM, Dave Davis dda...@harriscomputer.com wrote: Uppercase has always worked for me. $VFIELDSIZE and $vfieldsize are distinct variables to the operating system, so I suspect you should stick with uppercase. 6000 - that's huge - what are you putting in these things? I've had to increase to 380 or so before. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Thursday, March 21, 2013 6:52 AM To: U2 Users List Subject: [U2] unidata env var We've had some issues with i-desc failing over years and the solution was to set the evironment variable VFIELDSIZE to some amount (6000 or more). My real question is does unidata care about case for this variable (on *nix, not windoze)? I've seen it documented both as VFIELDSIZE and vfieldsize and not sure unidata sees one or both of these. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] unidata env var
Yup, we've bumped higher than 6000 before. Jeff Butera -- A tree falls the way it leans. Be careful which way you lean. The Lorax On Mar 21, 2013, at 11:19 AM, Colin Alfke alfke...@hotmail.com wrote: Then I'm not going to say anything about the 16384 we used to set it to :) Colin -Original Message- From: Dave Davis Sent: Thursday, March 21, 2013 7:38 AM To: U2 Users List Subject: Re: [U2] unidata env var Uppercase has always worked for me. $VFIELDSIZE and $vfieldsize are distinct variables to the operating system, so I suspect you should stick with uppercase. 6000 - that's huge - what are you putting in these things? I've had to increase to 380 or so before. -Original Message- From: Jeffrey Butera Sent: Thursday, March 21, 2013 6:52 AM To: U2 Users List Subject: [U2] unidata env var We've had some issues with i-desc failing over years and the solution was to set the evironment variable VFIELDSIZE to some amount (6000 or more). My real question is does unidata care about case for this variable (on *nix, not windoze)? I've seen it documented both as VFIELDSIZE and vfieldsize and not sure unidata sees one or both of these. -- Jeffrey Butera, PhD ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata WHEN/ASSOCIATED
Stupid question: is there a good reason why WHEN/ASSOCIATED can only be used with LIST and not SELECT? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata WHEN/ASSOCIATED
On 03/08/2013 03:47 PM, David A. Green wrote: Jeff, This could be a good enhancement. How do you want it to work? 1. SELECT just the IDs or whatever the SAVING clause points to. Or 2. SELECT the IDs,MV pointers that match But until it goes through I'm sure someone has already written the code to do it in a UniBasic program. Um, yeah - that someone would be me: I write this code all the time in programs or using I-desc but would be thrilled with (1) just to run queries and return matching record IDs. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Friday, March 08, 2013 1:23 PM To: U2 Users List Subject: [U2] Unidata WHEN/ASSOCIATED Stupid question: is there a good reason why WHEN/ASSOCIATED can only be used with LIST and not SELECT? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata index and short-circuit evaluation
While I'm on a roll... I often look at how to make queries run faster. In short, we index all the commonly used data fields we can and (of course) it makes world of difference. However, I have some questions about optimal ways to query data using a mix of indexed data, non-indexed data and i-descriptors. Let's say that in a table FOO I want to do SELECT FOO WITH A='foo' AND B='bar' AND C='bang' where: A = indexed data field B = non-index data field C = I-descriptor (assume it's time-consuming: 2 seconds per record) Which is the optimal way to attack? 1) I could just go for it with: SELECT FOO WITH A='foo' AND B='bar' AND C='bang' 2) I could do the following: SELECT FOO WITH A='foo' AND B='bar' SELECT FOO WITH A='foo' AND B='bar' AND C='bang' REQUIRE.SELECT 3) I could do the following: SELECT FOO WITH A='foo' SELECT FOO WITH A='foo' AND B='bar' AND C='bang' REQUIRE.SELECT I've done benchmarks, but really curious about the innards of Unidata and how/when it does short-circuit evaluation of AND clauses, etc. My gut tells me that (3) should be good because it first weeds out bad records based solely on an indexed data field, thereby reducing the number of records that C needs to be evaluated. Conversely, if it's doing a good job with short-circuit evaluation then (3) and (1) shouldn't be terribly different because failure of A='foo' would imply that C never gets evaluated. -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata RESIZE CONCURRENT
So is anyone using Unidata's RESIZE CONCURRENT in production environments? I have a dedicated maintenance window, so performing regular file resizing usually isn't a problem here but I'm considering moving over to using the CONCURRENT feature - particularly if a fire crops up in our production environment. Just curious about people's experience with it and the possible impact on performance in a production environment. -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
note that I am only available on Tuesdays and Wednesdays. ** -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Tuesday, March 05, 2013 1:43 PM To: U2 Users List Subject: [U2] Unidata RESIZE CONCURRENT So is anyone using Unidata's RESIZE CONCURRENT in production environments? I have a dedicated maintenance window, so performing regular file resizing usually isn't a problem here but I'm considering moving over to using the CONCURRENT feature - particularly if a fire crops up in our production environment. Just curious about people's experience with it and the possible impact on performance in a production environment. -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 7.3.x
Ellucian finally certified Unidata 7.3, so can anyone tell me what whiz-bang features I should look at that weren't found in 7.2.x? Thanks, -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.3.x
On 02/22/2013 09:39 AM, Howder, Scott wrote: The following document lists the new features: http://www.rocketsoftware.com/u2/products/unidata/resources/manuals/unidata-7.3-documentation/unidata-7.3-new-features Thanks Scott - I am aware of that document. I was looking for what people using it already found to be most important... -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] : Evaluating DCOUNT
On 02/11/2013 12:14 AM, Peter Cheney wrote: Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1 to dcount(array,@fm) *commands here next i versus totalattributes = dcount(array,@fm) for i = 1 to totalattributes *commands here next i Apart from readability and perhaps easier debugging is there an actual internal difference? I know it was an issue on older pick releases but I cannot remember if it ever affected UV? Not sure about universe, but unidata defintely checks the DCOUNT for each iteration. This produces 4 (not 2): CT=0 X=45:@VM:58 FOR I=1 TO DCOUNT(X,@VM) CT+=1 IF I=2 THEN X1,-1 = 99 END NEXT I CRT CT -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] : Evaluating DCOUNT
David is correct (re: performance). Most of our app here have MV lists under 40-50 so it's not a huge issue. If you app has hundreds+ this could be a big challenge. Jeff Butera -- A tree falls the way it leans. Be careful which way you lean. The Lorax On Feb 11, 2013, at 8:30 AM, Dave Laansma dlaan...@hubbardsupply.com wrote: I would HOPE that it evaluates it each time since the size of array could change within the loop. Personally if the size of array is relatively small, DCOUNT is alright. However I've found REMOVE to be EXTREMELY faster and therefore use it whenever possible, even on small arrays. For example, we have two files, a 'header' and 'detail' file. The keys to the 'detail' file are stored in attribute 200 of the header file. So I'll pull the keys out of the header record, such: LINE.KEYS = HEADER.REC200 D1 = LOOP UNTIL D1 = 0 REMOVE LINE.KEY FROM LINE.KEYS SETTING D1 loop statements REPEAT As opposed to: FOR V1 = 1 TO DCOUNT(HEADER.REC200,@VM) LINE.KEY = HEADER.REC200,V1 loop statements NEXT V1 Based on historical dialogs on this subject on this forum, I have seen an improvement in overall performance. Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, February 11, 2013 7:55 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] : Evaluating DCOUNT On 02/11/2013 12:14 AM, Peter Cheney wrote: Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1 to dcount(array,@fm) *commands here next i versus totalattributes = dcount(array,@fm) for i = 1 to totalattributes *commands here next i Apart from readability and perhaps easier debugging is there an actual internal difference? I know it was an issue on older pick releases but I cannot remember if it ever affected UV? Not sure about universe, but unidata defintely checks the DCOUNT for each iteration. This produces 4 (not 2): CT=0 X=45:@VM:58 FOR I=1 TO DCOUNT(X,@VM) CT+=1 IF I=2 THEN X1,-1 = 99 END NEXT I CRT CT -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata submitRequest
I'm trying my hand at some http interation from within Unidata. I'm unclear about the proper way to POST data as the manual is vague. In short, I'm trying to POST two variables foo and bar to a given url: X.URL = 'http://some.url.com/script.cgi' X.METHOD='POST' X.HANDLE = '' X.RESULT = createRequest(X.URL,X.METHOD,X.HANDLE) X.TIMEOUT=2000 X.POST.DATA = ?? X.RESULT = submitRequest(X.HANDLE,X.TIMEOUT,X.POST.DATA,X.RESPONSE.HEADERS,X.RESPONSE.DATA,X.HTTP.STATUS) I'm not clear how to properly format the post data - the documentation says it ignores previously set addRequestParameters. I'm guessing X.POST.DATA should be something like: X.POST.DATA = 'foo':@VM:'foo value':@FM:'bar':@VM:'bar value' But that's a complete guess. Thanks, Jeff (thawing from loads of snow) -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata submitRequest
Thanks-I was reading the unibasic commands reference, but I'll give extensions a read as well. Jeff Butera -- A tree falls the way it leans. Be careful which way you lean. The Lorax On Feb 9, 2013, at 8:16 PM, Kevin King ke...@precisonline.com wrote: This is somewhat described in Submitting a Request on page 62 of the Unidata 7.1 UniBASIC Extensions manual, where it states: *For a POST request with non-empty post_data, the data is attached to the request message as is. No encoding is performed, and any parameters added through addRequestParameter() will be totally ignored. Otherwise the following processing will be performed:* * * *For a POST request with default content type, the parameter string is assembled, a Content-Length header created, and then the string is attached as the last part of the request message.* * * *For a POST request with multipart/* content type, a unique boundary string is created and then multiple parts are generated in the sequence they were added through calling addRequestParameter(). Each will have a unique boundary, followed by optional Content-* headers, and data part. The total length is calculated and a Content-Length header is added to the message header.* Bottom line, use addRequestParameter to add your fields to the POST data and send this parameter into submitRequest as an empty string. Otherwise, if you want to send in something like an XML document that has no particular name associated with the value, put that value here and it will be sent exactly as you put it in there without encoding of any kind (or so the manual suggests). -K On Sat, Feb 9, 2013 at 4:36 PM, Jeffrey Butera jbut...@hampshire.eduwrote: I'm trying my hand at some http interation from within Unidata. I'm unclear about the proper way to POST data as the manual is vague. In short, I'm trying to POST two variables foo and bar to a given url: X.URL = 'http://some.url.com/script.**cgi http://some.url.com/script.cgi ' X.METHOD='POST' X.HANDLE = '' X.RESULT = createRequest(X.URL,X.METHOD,**X.HANDLE) X.TIMEOUT=2000 X.POST.DATA = ?? X.RESULT = submitRequest(X.HANDLE,X.**TIMEOUT,X.POST.DATA,X.** RESPONSE.HEADERS,X.RESPONSE.**DATA,X.HTTP.STATUS) I'm not clear how to properly format the post data - the documentation says it ignores previously set addRequestParameters. I'm guessing X.POST.DATA should be something like: X.POST.DATA = 'foo':@VM:'foo value':@FM:'bar':@VM:'bar value' But that's a complete guess. Thanks, Jeff (thawing from loads of snow) -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData 64 bit sanity check
Last check there are no 64 bit builds for intel (win/Linux) Jeff Butera -- A tree falls the way it leans. Be careful which way you lean. The Lorax On Feb 8, 2013, at 9:57 PM, Jeff Fitzgerald j...@fitzlong.com wrote: Hi all, Just want to get confirmation or a slap upside the head It looks to me like all the UDT Windows versions are 32 bit and that there isn't a 64 bit version - true? Thanks! Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Large File Operations Kill Linux
Perry I'm curious how large large is for you? Jeff Butera -- A tree falls the way it leans. Be careful which way you lean. The Lorax On Feb 5, 2013, at 5:45 PM, Perry Taylor perry.tay...@zirmed.com wrote: I have engaged Redhat Support and it has already been escalated to their Kernel team so at least it seems I have their attention :). I'll provide updates as they become available. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Monday, February 04, 2013 3:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Large File Operations Kill Linux Other users could have been hanging at malloc. With a swappiness of 100 (on some kernels) or 100 (on others) or not 0 or 100(not sure which behavior you get on 2.6.18), pages wouldn't be getting freed up quickly enough duing the creation/copying of a large file. Another thing to look at (although I prefer the support route, since you have it), is /sys/kernel/mm/transparent_hugepage/defrag. Other people who have had this problem alleviated it by setting this to never. Of course, others fixed it by updating the kernel. My aged eyes read what you have as 2.6.8.1... Date: Mon, 4 Feb 2013 21:15:25 + From: antli...@youngman.org.uk To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Large File Operations Kill Linux On 04/02/13 21:05, Dan Fitzgerald wrote: What's the value in /proc/sys/vm/swappiness? How will that make any difference? 2.6.18-348 SOUNDS like an ancient (in linux terms) kernel. Are you on RedHat support? This is a problem with the linux kernel that was addressed recently, iirc. Large amounts of io from a single process can swamp the queue, and the latest kernels have it fixed. If you've got RH support, see if you can find out if that's been backported into your kernel. Cheers, Wol From: perry.tay...@zirmed.com To: u2-users@listserver.u2ug.org Date: Mon, 4 Feb 2013 20:53:13 + Subject: Re: [U2] [UV] Large File Operations Kill Linux We're on RHEL5 (2.6.18-348.el5), ext3 and 132GB ram. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, February 04, 2013 9:23 AM To: 'U2 Users List' Subject: Re: [U2] [UV] Large File Operations Kill Linux A few questions - What linux version/distro are you on and what type of file system, and how much ram do you have -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: 04 February 2013 15:57 To: U2-Users List Subject: [U2] [UV] Large File Operations Kill Linux Looking for some ideas on how to keep Linux from becoming largely unresponsive when creating large files. What happens is as the new file is being created the I/O buffer cache quickly fills up with dirty buffers. Until the kernel can flush these out to disk there is no avail buffers for I/O operations from other processes. . The most troubling manifestation of this is the transaction logging check point daemon gets *way* behind putting us as risk if we were to have a failure of some kind. I have tried using ionice and renice to slow the file creation down as much as possible. This help a little but is still a big problem. Any ideas how to get CREATE.FILE/RESIZE to play nice on Linux? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata DICT size
So I'm curious how large a dictionary of Data elements (not I-desc) people have used on a single table in Unidata. We have a couple of tables with 200ish data elements in them and I'm facing a project that could see single tables with 400+ data elements. I assume this is no issue assuming the DICT is resized appropriately (like any other table), but curious to here people's input regarding performance and other factors. -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Speeding sort
Stupid question of the day on unidata 7.2.x I build indexes all over to speed queries - I have plenty of disk to burn. However does having an index help when sorting on a field that's not part of the selection criteria? For example we often do this dance between two files: SELECT FILE WITH FIELD='VALUE' SAVING UNIQUE SOME_KEY NO.NULLS SELECT ANOTHER_FILE BY SORT_FIELD I know indexing FIELD helps the first question, but does having an index on SORT_FIELD help the second? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Downloads
Where on Rocket's site can I get my hands on downloads for VSG and the eclipse-based admin tool? I can't seem to login and find them... -- Jeffrey Butera Associate Director of Information Technology for Applications and Web Services Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Downloads
On 07/30/2012 02:32 PM, Wally Terhune wrote: http://www.rocketsoftware.com/u2/resources/downloads no login required. Thanks Wally. Is VSG under dbtools or something else (I can't seem to locate it)? -- Jeffrey Butera Associate Director of Information Technology for Applications and Web Services Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] matrix dimension
I don't work with MATrices much in Unidata. If I have my hands on a matrix setup from another program is there a function to determine it's dimensions? My reading of DIM doesn't indicate it can do this and I don't see anything in the various MAT... commands that looks promising. -- Jeffrey Butera Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ
On 4/30/2012 9:12 PM, Buss, Troy (Contractor, Logitek Systems) wrote: We recently upgraded to a virtual server and just using more current technology hard drives we doubled all of our disk I/O from what we had 5 or 6 years ago. CPU speed increased as well, but that was not as suprising. Same here - two years ago we moved from Solaris with dedicated RAID with hardware controller to virtualized RedHat and no hardware RAID, yet improved disk I/O by factor of 2 or more. Ditto on CPU... -- Jeff Butera Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Job: Hampshire College
We have an opening and someone with good U2 skills could certainly be an asset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you in industry, we offer a competitive salary for this market and great benefits (4 weeks paid vacation from day 1, among others). https://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 Hampshire College, an independent, innovative liberal arts institution and member of the Five College consortium in Amherst Massachusetts, is accepting applications for a Database Systems Developer in its Information Technology Department. The Database Systems Developer is the lead developer and administrator providing a variety of technical and user support for the college’s Colleague administrative computing system; develops programs to augment vendor-supplied software; and enhance web-based services. This position analyzes, develops, implements and documents custom administrative software enhancements, and supports end-users by creating ad-hoc reports and providing application training. The developer creates new applications, determines user needs, and implements efficient solutions to end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in information systems and software design or equivalent training and experience. Application programming and analysis experience in the design, development and implementation of administrative application functions such as Finance, Human Resources, Student and Academic records and Development or equivalent systems highly desirable. Five years of experience with at least one relational database, using a query language and with several programming languages, especially BASIC, is also required. Previous experience with Colleague highly desirable. Prior web programming experience, knowledge of Java, PERL, Python or PHP, and experience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a competitive salary and excellent benefits program. Please submit your cover letter, resume and names/phone numbers of three professional references via our website at http://jobs.hampshire.edu -- Jeff Butera Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] guide problem
On 11/18/11 14:02, charles_shaf...@ntn-bower.com wrote: Does anybody know what would cause a segmentation fault while running guide? Red hat 2.6.9-5.ELsmp Unidata 7.1 Haven't changed the OS or Unidata version for a long time. Not offhand -- we're RHEL 5.5 2.6.18-274.el5 with Unidata 7.2.9 I'm sure you've checked, but does it seg fault on the same single file or any file you attempt? -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues...
On 11/09/11 14:05, Steve Romanow wrote: Are any of the multivalued fields associated to each other? You would have a subtable per association, not per column. This is precisely how Datatel reverse-engineered their back end from Unidata to MSSQL. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SLOW
On 10/10/11 09:52, bney...@hcmg.net wrote: Some 15 years ago I worked for a place that put together a team to speed up their UniData machines. We found Stupid Coding Practices and other things that slowed the systems to a crawl. Tim Snyder of Rocket was on that team. You can hire him through Rocket to check out your system. I'm sure it would be well worth it. This is humorous. I'll assume Drew is a Datatel client. Let's just say that their code is less than optimal in many cases, particularly course registration. But like any product, anything that has millions of lines of source code and is 20+ years old (or older, in some cases) is likely to be inefficient. Likewise, rewriting it from the ground up isn't going to happen (until Datatel moves everything to MSSQL, but that's a whole different thread). From: Drew William Hendersond.hender...@moreheadstate.edu To: U2-Users@listserver.u2ug.orgU2-Users@listserver.u2ug.org Date: 10/07/2011 04:26 PM Subject:[U2] SLOW Sent by:u2-users-boun...@listserver.u2ug.org with apologies to Jeff and Peggy...and, ok, everyone else, too! My boss has noticed today that we've been running SLOW, and isn't happy about it. He wants to know if SLOW is industry standard, and what other U2 shops might be running SLOW. I told him that I didn't know about other U2 shops, but that I know a lot of SQL shops have been running SLOW for years, and seem to be very satisfied. I also let him know that running SLOW on Friday afternoons was almost industry standard, but I'm not sure he's buying it. So, if you're running SLOW in your environment, please let me know; otherwise, we might not be running SLOW on Monday morning. (sorry...couldn't help myself! Have a good weekend, all!) Drew Henderson Director, Enterprise Systems Architecture and Security Morehead State University 301 Howell-McDowell Bldg Morehead, Ky 40351 606/783-2445 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Finding Triggers on files
Unidata 7.2.9 on RedHat Is there a programmatic way to determine if a file has a trigger on it? I've looked at FILEINFO and it doesn't indicate that any parameter would return trigger information. I know I can do something like: EXECUTE LIST.TRIGGER MY_FILE CAPTURING X.RESULT and parse X.RESULT, but was curious if there's a better way. I've occasionally been bitten by converting a file from static to dynamic hashing, losing an update trigger in the process so I want to write some code to check these and let me know if something's awry. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniSubroutineException
On 08/09/11 14:28, charles_shaf...@ntn-bower.com wrote: I am calling a UniBasic subroutine that gets a list of account numbers and returns information about them. On calls with a few account numbers, it works fine. On calls with a lot of account numbers, I am getting a UniSubroutineException. This makes me suspect that there is a maximum string length that can be returned from a subroutine. Does anyone know if that is true and what the length might be? Charles: I too have suspected this, but don't have a definitive answer. Can you quantify a lot? -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniSubroutineException
On 08/09/11 14:59, charles_shaf...@ntn-bower.com wrote: I would guess that the largest string returned is at least 55K. That is a wild guess though. That's a decent size. We're doing some work which can return upwards of 200k and haven't had any issues. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Triggers
On 06/14/11 10:54, shaun.fergu...@ferguson.com wrote: We are creating a trigger on a file that is used extensively in the system. Is it necessary to logoff users when creating an update trigger on a file or does UniData handle that when updating the trigger information to the header of the file? The 'help' does not specify whether trigger creation requires exclusive access to the file or not. I've had no issues setting up triggers on our production system with users logged in. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
On 05/19/11 09:26, John Thompson wrote: My understanding of UniObjects is that it is a connector into Universe or Unidata. Yes, but: You have to have a windows machine as the go between. Not true - you can do this with *nix. So for example, if you wanted to use some .NET language or C#, or PHP, or whatever to connect your Universe or Unidata database to a web form, etc., you could use UniObjects running on a Windows Server running IIS or Apache (a web server) that sits alongside your U2 database server. It doesn't have to be web apps I don't think... For example, some of the software offered as part of the Client CD you get from Rocket uses it to edit dictionaries, programs, etc. As far as other technologies that are out there... I am still pretty much a noobie myself, but, there are a ton out there that you can use to talk to Universe or Unidata. I know more about the Linux/AIX side of things than I do Windows, but, in most cases if you get to the point where you can make a programming language (PHP/Perl/Python, etc. etc.) launch a Universe or Unidata session, read in some data, and write some data back out, then you are a great deal of the way there (and of course security is always part of the design, in whatever you build). I currently have been having a lot of fun with the following scenario: Using Ubuntu Linux as a web server running Apache/PHP Sending http requests to the AIX server running Universe/Apache/PHP which then launches a Universe session to pick up the data and write it back out which then sends the result back to the Ubuntu web server. (JSON is used as the standard data interchange format) (JQuery is used to make the web forms pretty and work with data - not required really) (PHP is used to send the requests and also work with the data) Of course, like anything... in a production environment (which this is not currently in), you have to lock down your U2 machine to only receive requests from that Web Server, etc. I got the idea (and help) from another gentleman named Kevin King. I have been having a lot of fun with it. Like anything though, everybody has their tools that they like. The beauty of this in my opinion is that you can try it out for free, and if you don't like it, the only thing you have possibly wasted is some time. On Thu, May 19, 2011 at 8:42 AM, Steve Romanowslestak...@gmail.com wrote: Uniobjects is a C module that has been wrapped and packaged for java, vb, and .NET. PickWiki has several examples, as well as the rocket software docs. If you upgrade to the new WebDE you will be using uniobjects for communication (really deep down.) On Thu, May 19, 2011 at 8:37 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: I have been in the PICK world for decades and have worked with several interfaces. Green screen, SB, BlackSmith and Redback/web are my biggest areas of expertise. I have simply never worked with anything else because these are the tools at the places I have worked. I am embarrassed to ask, but need to do so. What are UniObjects? Other than what I mentioned above, what other technologies are out there are rock solid? Where can I go to get an get your feet wet intro? If our business is doing fine without them, why would I want to use them? What can I do with them? We are a SB Redback/web shop. What benefit would there be to my company to have me learn these other technologies? I am not saying that we don't want any of these technologies, but if we don't even know what it is or are aware of what it can do, we will never look to it for a solution. I understand that this is a VERY broad question, but if I don't start asking, I will never learn. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Purposefully Breaking a UniVerse File
On 05/05/11 11:52, Perry Taylor wrote: I'm trying to determine the various error and warning messages that might be presented by uvbackup. I think I have determined most of them but I don't know what uvbackup would say when it encounters a broken file. Is there an easy way to break a file in a way that would be interpreted as such by uvbackup? Not sure about UV, but this breaks things nicely in Unidata: echo '0' FOOBAR :LIST FOOBAR File size (4098) is not a multiple of block size(1024). FOOBAR is not a UniData data file Open file error. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
On Wed, Apr 27, 2011 at 2:04 PM, Allen E. Elwoodaelw...@socal.rr.com wrote: I'd love to see a U2 server, connected directly to the internet, with *no other software* serving up secured web pages. To have the entire www available with new U2 commands added by Rocket's Scientists. Other db's do not do this. mysql, db2, mssql, etc all have another product involved to serve their data to the web. Many older db's do not. However, some newer ones (Cache') have figured out that what Allen is asking for is expected in this day of web 2.0 - so why not build this functionality in? -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mailing List Hacked
On 04/19/2011 07:22 AM, u2list0...@curt.com wrote: I just received a phishing attack addressed to my U2 Mailing list email address. That doesn't mean the list was hacked (eg: found a way to scrape addresses from the outside). Anyone can join the list, harvest email from it and then use it for bad things. I've seen this before on other high-traffic lists I'm on. -- Jeffrey Butera Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] OCONVS for MV I-desc
On Unidata 7.2.x OCONVS is the MV equivalent for OCONV that works wonders in Unibasic. However, I have the need to create an I-descriptor which uppercases a MV field and OCONVS isn't allowed in an I-desc whereas OCONV is. However, OCONV uppercases the @VM and screws up the MV nature. To be clear, this is what I'm trying to do: OCONVS(X.SOME.FIELD,'MCU') -- Jeffrey Butera Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OCONVS for MV I-desc
On 03/08/2011 08:26 PM, Kate Stanton wrote: Try the MCU as conversion code in F3 of the dict. Thanks Kate - after almost 12 years of Unidata, I can say I never thought of that approach but duh!, I should have! -- Jeffrey Butera Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 7.2.5 error
Can anyone shed light on this error: In BP/_H08.P.IMPORT.AD.SEARCH at line 106 Index: invalid OV element: (1221,91). In BP/_H08.P.IMPORT.AD.SEARCH at line 106 Index: invalid OV element: (1221,91). In BP/_H08.P.IMPORT.AD.SEARCH at line 106 Index: invalid OV element: (870,26). In BP/_H08.P.IMPORT.AD.SEARCH at line 106 Index: invalid OV element: (1185,24). Memory fault line 106 in the program is WRITE XADS.REC TO XF.XADS,XADS.ID There is a single indexed field in this record, but I allow for null values so I'm not sure if something with the index is tripping it up. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A new DML?
On 2/4/2011 11:10 PM, DavidJMurray (mvdbs.com) wrote: Yes, it is possible to use intercall with Python using the ctypes module: http://mvdbs.com/2010/07/05/python-to-intercall/ We previously attempted to use SWIG to get python to call InterCall, but ran into issues with python (64 bit) and intercall (32 bit). We didn't want to completely reinstall python from source and compile as 32 bit. Does the ctypes module in python allow calling 32-bit intercall libs from a 64-bit install of python? -- Jeff Butera Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
On 01/31/11 11:02, Steve Romanow wrote: I like George's solution. On 1/31/2011 9:12 AM, George Gallen wrote: Am I missing something, or would CONVERT CHAR(253) TO IN FXI not do the job? or FXI=CHANGE(FXI,CHAR(253),) Maybe: EQU CLEARVM TO CONVERT CHAR(253) TO IN ... ... ... CLEARVM FXI This would work if your data was a single non-null field with numerous null values. But if your list had more than a single non-null value this would be bad. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata can't build index
Can anyone shed light on this (other than the obivous) - I'm unclear about why this is occurring: :BUILD.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID Can not lock index file No indices are built This is a new file so I originally thought perhaps OS permissions where incorrect, but after checking I verified the permissions on the index file are 770. I don't have anything writing to this file so I'm not clear why it can't get a lock on the index file. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata can't build index
On 01/28/11 14:11, Susan Lynch wrote: Jeff, did you do a CREATE.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID first? Yes, LIST.INDEX properly displayed all the indices including XPL.PERSON.ID which was new (but not built). -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Need help with MV assoc/I-desc
I need insight from the U2 faithful. This is Unidata 7, if that affects the answer... I have a file which has 2 associated fields, such as: XEM.PERSON = 1737292:@VM:1818182:@VM:9187311 XEM.VALUE = 23:@VM:14:@VM:99 What I'd like is a field which sorts by XEM.VALUE for the associated person querying the records. That is, if person 1737292 is selecting records it would use 23 for purposes of sorting this record. If 1818182 is selecting, it would use 14 for sorting. I've done plenty of i-descriptors both with and without subroutines, but I don't have insight as to any method of allowing the query to know who's running it. I've dreamed about WHEN...ASD but Unidata only allow this in a LIST statement and it doesn't really do what I need, even if it were allowed in a SELECT. I need the data stored as listed above, but I am open to using a database trigger to store this in some alternative form that makes the query easier to deal with - but I can't think of how this might be accomplished. Any insight is appreciated. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, one [dollar bills] are good but tens are way better. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 7.2.3 and Windows auth
I've got a client running unidata 7.2.3 on Windows 2003. In short, they're trying to swap to a new Domain Controller, but everytime they do this Unidata logins fail. They keep telling me that Unidata must have some internal configuration re: which DC to contact. I claim no, it's just using the underlying OS to authenticate the users and I think they haven't got the server configured correctly. Can anyone confirm this or indicate where I'm wrong... Many of you know I'm a *nix guy so I surely don't have the definitive answer for this. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, one [dollar bills] are good but tens are way better. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 7.2.5 and Digest
Unidata 7.2.5 on RedHat 5. I'm trying to SHA1 some data and get it back with some human readable output (hex is fine). This snippet works for other Unidata people (who have emailed me privately) but not me: X.DATA = '1234567' X.ERROR=DIGEST('SHA1',X.DATA,1,X.OUT) CRT 'DIGEST err=':X.ERROR X.RESULT = OCONV(X.OUT, MX) CRT 'OCONV res=':X.RESULT Instead of giving me a nice hash result, I get binary output: DIGEST err=0 OCONV res=ê¾]d°âynORÖз2ü I'm trying to determine why this would cause problems on my server but not for others. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.2.5 and Digest
How big is your input string? In the past, I've had to break down the input into smaller 100 byte chunks and concatenate to get the result. Tiny: 20 ascii chars or less. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, September 20, 2010 3:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 7.2.5 and Digest Unidata 7.2.5 on RedHat 5. I'm trying to SHA1 some data and get it back with some human readable output (hex is fine). This snippet works for other Unidata people (who have emailed me privately) but not me: X.DATA = '1234567' X.ERROR=DIGEST('SHA1',X.DATA,1,X.OUT) CRT 'DIGEST err=':X.ERROR X.RESULT = OCONV(X.OUT, MX) CRT 'OCONV res=':X.RESULT Instead of giving me a nice hash result, I get binary output: DIGEST err=0 OCONV res=ê¾]d°âynORÖз2ü I'm trying to determine why this would cause problems on my server but not for others. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.2.5 and Digest
Big thanks to Bill and Rex for getting me started, but Andy wins the gold star - this indeed resolved my issue! On 9/20/2010 8:05 PM, andy baum wrote: Try using a conversion of MX0C, using a conversion of MX I get the same results as you using the latest version of Unidate PE on Windows 7 but MX0C seems to give proper results. -- Jeff Butera Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] @LOGNAME on Unidata
We recently migrated from Unidata 7.1.8 on Solaris to Unidata 7.2.5 on RedHat. We make use of @LOGNAME quite a bit to determine a person's username. Since our migration, however, we've documented some cases where @LOGNAME is not returning the proper username - it returns someone else's. What's bizarre is that most of the time it's right, but occasionally it's not. Has anyone seen or heard of this? When we had a report of this (with documentation) I thought it was weird. Today we just got a call about a different problem which I'm 99% sure is tied to this since it makes use of @LOGNAME. Like the above, sometimes it's correct, sometime it's wrong. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] @LOGNAME on Unidata
On 06/17/10 14:20, Dan Goble wrote: I have seen this in the past where the file wtmp usually found in /var/adm is corrupt or too big ( over 2 meg ). To correct this just type at the unix prompt wtmp And it will clear the file.I recommend doing this just before a reboot of the system. Thanks Dan. Our wtmp is under 1Meg and just rotated this week, so I can't imagine this is the culprit, but I'll give it a whirl... -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata Write Error
We just moved to unidata 7.2.5 on RHEL 5 from unidata 7.1.8 on Solaris 9. In the conversion I ran convcode, convdata and convidx across the board. Generally speaking, things have generally gone smoothly but I just ran into an error which I can't track back to conversion, permissions or triggers, but I'm open to thoughts. When attempting to delete a record, here's what happens: :AE H08.WEB.USERS 11196 --: fd Record 11196 in file H08.WEB.USERS * You are about to DELETE the ENTIRE record from the file! OK? n/y y In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,89). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,303). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,102). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,169). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,210). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,17). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 [AE] UniBasic WRITE failed, STATUS=1, check triggers. If instead of going thru AE I attempt a DELETE I get this: :DELETE H08.WEB.USERS 11196 Index: invalid OV element: (34,89). Index: invalid OV element: (34,303). Index: invalid OV element: (34,102). Index: invalid OV element: (34,169). Index: invalid OV element: (34,210). Index: invalid OV element: (34,17). 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 '11196' is not a record id in H08.WEB.USERS I reran convdata to ensure that this file was processed and Unidata thinks it's fine. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Write Error
On 06/03/10 13:54, Wally Terhune wrote: If the index on this file was heavily overflowed, it is possible that convidx didn't successfully convert the index Thanks Wally. Actually, in our conversion we ran convidx and also rebuilt indicies for ALL files. That said, after disabling both indicies and triggers for this file and recreating them, the problem has been resolved so I'll assume that the index file indeed was the culprit. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Silly Gripe
Really? We have large trees with code placed all around. If we had a single folder it might have 1 files in it-ugly. Sent from my iPhone Jeff Butera jbut...@hampshire.edu On Mar 25, 2010, at 8:35 AM, Symeon Breen syme...@gmail.com wrote: Probably because you would never have subdirectories in your program directory. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: 25 March 2010 10:58 To: U2 Users List Subject: [U2] Unidata Silly Gripe I know most won't care, but since I'm in the midst of a lot of Unidata migrations... Unidata provides three nifty tools: convcode, convdata and convidx for use in migrating a database. Can anyone tell me why the syntax for the three aren't the same? convdata and convidx use a unix-like -r flag for recursive, whereas convcode does not: convdata -r dirname convidx -r dirname convcode dirname I know this is absolutely trivial, but I've run into problems before scripting a moving and making the incorrect assumption that convcode took a -r flag. Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Life is a giant weenie roast and I'm the biggest weenie. Rose, The Golden Girls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Silly Gripe
We're with Larry and have truckloads. As the one who started the thread, let me be clear: i'm grateful these utilies have recursIve option and just curious why syntax might differ between them. Sent from my iPhone Jeff Butera jbut...@hampshire.edu On Mar 25, 2010, at 12:23 PM, Larry Hiscock lar...@wcs-corp.com wrote: Really? We have more than 20 subdirectories in our program directory. Each of them is defined as a DIR in Unidata, but at the Unix level (and convcode is a system-level command, not a Unidata verb) each is simply a sub-directory of the source directory. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, March 25, 2010 5:35 AM To: 'U2 Users List' Subject: Re: [U2] Unidata Silly Gripe Probably because you would never have subdirectories in your program directory. snip ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Guide leaving lots of empty files
Yes to all of those points. Sent from my iPhone Jeff Butera jbut...@hampshire.edu On Jan 15, 2010, at 4:56 PM, Wally Terhune wterh...@rocketsoftware.com wrote: Had that reported this week. U2 Support is currently isolating the circumstances. Initial view seems to be: Windows, guide run from a UniBasic program with PCPERFORM (or EXECUTE !guide...), AND the program is PHANTOMed. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, January 15, 2010 2:41 PM To: U2 Users List Subject: [U2] Guide leaving lots of empty files Unidata 7.2.2 on windows. We run guide on all our files nightly, and with the upgrade from 7.1.x to 7.2.2, we now find guide is leaving us hundreds of empty presents each night. We're just deleting them, but it's getting old. Any inshgt? 01/15/2010 01:51 AM 0 Guide9904_a02776_3_ChildSuccess 01/15/2010 01:24 AM 0 Guide9912_a05556_0_ChildSuccess 01/15/2010 01:24 AM 0 Guide9912_a05556_1_ChildSuccess 01/15/2010 01:24 AM 0 Guide9912_a05556_2_ChildSuccess 01/15/2010 01:24 AM 0 Guide9912_a05556_3_ChildSuccess 01/15/2010 01:12 AM 0 Guide9916_a04324_0_ChildSuccess 01/15/2010 01:12 AM 0 Guide9916_a04324_1_ChildSuccess 01/15/2010 01:12 AM 0 Guide9916_a04324_2_ChildSuccess 01/15/2010 01:12 AM 0 Guide9916_a04324_3_ChildSuccess 01/15/2010 02:57 AM 0 Guide9920_a05456_0_ChildSuccess 01/15/2010 02:57 AM 0 Guide9920_a05456_1_ChildSuccess 01/15/2010 02:57 AM 0 Guide9920_a05456_2_ChildSuccess 01/15/2010 02:57 AM 0 Guide9920_a05456_3_ChildSuccess 01/15/2010 01:57 AM 0 Guide9924_a04236_0_ChildSuccess 01/15/2010 01:57 AM 0 Guide9924_a04236_1_ChildSuccess 01/15/2010 01:57 AM 0 Guide9924_a04236_2_ChildSuccess 01/15/2010 01:57 AM 0 Guide9924_a04236_3_ChildSuccess Jeff Butera Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
Thanks Don - I did already run all three and still encountered issues. Sent from my iPhone Jeff Butera jbut...@hampshire.edu On Nov 20, 2009, at 7:35 PM, Don u2-us...@southeast-florida.com wrote: On Unidata the byte conversion program are: In [ud install]\ud\bin convdata.exe - Data files convidx.exe - Indexes (you may be better off rebuilding indexes). convcode.exe - the compile code/object files just type the command with no arguments for their usage. Don Verhagen People 2.0 Global -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, November 20, 2009 7:23 PM To: Ray Wurlod Cc: U2 Users List Subject: Re: [U2] Migrating OS You need to byte-swap data as part of the migration process. For example, what's stored as (hex) 004E on the Solaris machine (unless it uses Intel chips) is stored as (hex) 4E00 on the Intel-chipped Linux machine. UniVerse, as someone else noted has a utility called fnuxi (also known as format.conv) for implementing byte swapping - like that poster I am not familiar enough with UD to advise on the equivalent utility for that product. Thanks. To my knowledge, Unidata does not have fnuxi, but I know others have tackled this problem so it's solvable. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata odd error
Thanks Wally - that sounds right since this is a repurposed account in which I did unmount and remount the filesystem yesterday. We'll be moving from solaris 7.1.8 to RedHat 7.2.x shortly so it's no big deal in the long run. I worked around the problem anyway. Sent from my iPhone Jeff Butera jbut...@hampshire.edu On Nov 14, 2009, at 10:02 AM, Wally Terhune wterh...@rocketsoftware.com wrote: I wonder if this may apply - fixed at 7.1.9 (from the latest 7.1.x readme) The first entry for that device ID will be the one the udt process is checking for available space and may not be the file system you expect. Issue 9209 - Problem Description UniData -- The smm daemon maintains a table in shared memory that lists available file systems and the space available in each file system. You can view the table using the sms -F command. Prior to this release, if a new file system was mounted, a new entry was added to the table. Entries were not removed when a file system was unmounted. This may have resulted in entries in the table for two different mount paths that had the same ID. The problem has been fixed. Wally Terhune U2 Support Architect Rocket Software Tel: (720) 475-8055 Mobile: (303) 807-6222 wterh...@rocketsoftware.com u2supp...@rocketsoftware.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] tape backups
quote who='Edward Brown' date='Thursday 14 August 2008' There's a dbpause / dbresume command on unidata that looks like it would make backups safer. If your system supports filesystem snapshots, a really effective means is to: 1) dbpause the database 2) take file system snapshot of database 3) dsresume the database 4) perform tape backup from snapshot 5) release the snapshot once backup completes This typically results in very little downtime (as long as it takes to pefrom a snapshot of the filesystem) often 5-10 seconds or less. Yes, you should wait a few seconds after dbpause to allow any pending writes to complete. dbpause is a UniData system-level command that blocks most updates to the database made in a UniData session. Any updates made from the operating system level are not blocked. You can use this feature to perform some tasks that normally require UniData to be stopped, such as backing up your data. When the dbpause command is issued, all current writes and transactions complete before UniData pauses. Updates are blocked until the system administrator executes the dbresume command. Edward -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Email gives the illusion of progress even when nothing is happening. unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata upgrades
quote who='Buffington, Wyatt' date='Thursday 10 July 2008' I would like to get some good or bad issues/concerns in regards to upgrading Unidata from version 6.0.4 to 6.1 Also in anybody has experienced any problems when upgrading Unidata from version 6.1 to 7.1. We are running on an HP machine with Unix 11. When we moved our production server (Solaris 9) from 6.1 to 7.1 it went like butta - smooth and no issues at all. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Email gives the illusion of progress even when nothing is happening. unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Friday query logic
quote who='Eric Armstrong' date='Monday 23 June 2008' Jeff, In Universe there is a (apparently undocumented) keyword ANY which can be used, i.e. SELECT FILE WITH ANY FIELD UNLIKE SF... OR WITH ANY FIELD UNLIKE SH... which may be just what you want. Eric: You get the prize - I'm on Unidata but ANY works the same and it's exactly what I want. On your next hot day I owe you a cool beverage of your choice... -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Email gives the illusion of progress even when nothing is happening. unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Calling shell script from virtual field
quote who='Noah Hart' date='Friday 23 May 2008' Is it possible to define a virtual field in such a way that it can call a unix shell script? Sure, if the virtual field in turn called a subroutine which did the underlying PCPERFORM. I'm not sure if you can do this directly from a virtual field without going thru a subroutine. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 He works out of his home office doing technical training. I call it gambling. Overheard at grocery store. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a file in a different account
quote who='David Wolverton' date='Friday 16 May 2008' There is not a version of this for UniData is there?!? There is a 'udfile' in $UDTBIN, but not sure if it's the same as mkdbfile on Universe. Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 He works out of his home office doing technical training. I call it gambling. Overheard at grocery store. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a file in a different account
quote who='Thomas Derwin' date='Friday 16 May 2008' Unidata's CREATE.FILE command allows you to specify the directory path. Sure, but this isn't a OS command. I think he was excited about the possibility of creating a new database file on the fly from the OS, not from within Unidata. (But perhaps I misunderstood his ?!?) So you could replace the mkdbfile commands in steps 3 and 4 with CREATE.FILE DICT /dir/subdir/FILENAME mod,sep and CREATE.FILE DATA /dir/subdir/FILENAME mod,sep In step 5, copy VOC FILENAME to the remote VOC and optionally delete it from the current VOC Hope this helps, Tom Derwin [EMAIL PROTECTED] 05/16/08 12:30 PM There is not a version of this for UniData is there?!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Friday, May 16, 2008 4:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Creating a file in a different account Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation Depending on how you want to do this, here is a suggestion: 1. Create a Q pointer to the remote VOC 2. Open the Q pointer and get the path (use Status27 and strip out the /VOC at the end) 3. Call mkdbfile to create the data file in that path. 4. call mkdbfile to create the dict file in that path as D_name 5. Write a new file pointer to the remote VOC. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- 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 He works out of his home office doing technical training. I call it gambling. Overheard at grocery store. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata @LOGNAME
Under Unidata 7.1.x on Solaris (9/10) we're seeing @LOGNAME truncated to 8 characters. Others on different OSes are not seeing this behavior. Does anyone know if this is a Unidata setting or how Unidata is interacting with a system call (eg: and therefor cannot be changed)? -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Consultants don't necessarily know more than you, they just get paid more than you. Me --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata @LOGNAME
quote who='JPB-U2UG' date='Thursday 17 April 2008' If I remember correctly, Solaris only looks at the first 8 characters as the user name and the password. If you have a password longer than 8 characters you're wasting keystrokes. I don't know if there is a setting to change it. You're correct on the password but since Solaris allows usernames longer than 8 we were surprised that @LOGNAME wasn't returning them. I'll assume it a Solaris system call that Unidata is using to populate @LOGNAME. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Consultants don't necessarily know more than you, they just get paid more than you. Me --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] COMMON
quote who='Dennis Bartlett' date='Friday 04 April 2008' Following up on the common thread, can one OPENSEQ to a COMMON variable? Sure - same approach. OPENSEQ FILE,RECORD TO F.HANDLE THEN * add F.HANDLE to the common array and list of open files... END -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Where I'm from, we believe all sorts of things that aren't true. We call it history. The Wizard, Wicked --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] COMMON
quote who='Mats Carlid' date='Friday 04 April 2008' With file pointers, the trick is to set flags so that you know that they're open or closed. Actually there is a way to test if a variable is an open file-handle or not ( at least in uv): I have the following code in som subroutines that you can feed with a open file handle or a file name in FN. This may be universe only - don't know. Works on Unidata as well. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Where I'm from, we believe all sorts of things that aren't true. We call it history. The Wizard, Wicked --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] COMMON
quote who='Dennis Bartlett' date='Thursday 03 April 2008' Hi I have a subroutine that WRITESEQ to a record in a type 1 file called INTEGRITY. Is there anyway I can open the file once (in the subroutine) and thereafter use the same file handle (to avoid opening the file each time the subroutine is called) ? All the code on this site opens the file in the calling routine and passes the handle to the subroutine. I want to rather make the subroutine a stand-alone, not requiring more than the subroutine call added to the calling programs. I have a suspicion I can use named common - if so, does this have to be declared in the calling routine (which would negate my purpose!). Yes - I use this approach and it works fine. In short, I build a COMMON array with file handles and a dynamic array with the names of the open files. At first invocation, you need to check to see if the COMMON vars are initialized or not - if not, you initialize them. Once this is done I merely look for a filename in the dynamic array, if found it returns the file handle for I/O. If it's not present it opens the file, adds the filename to the list and you go on. At the end of the process, it loops over all open file handles and closes them. Depending on your application, you can figure out optimal places to open/close the file handles. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Where I'm from, we believe all sorts of things that aren't true. We call it history. The Wizard, Wicked --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AE editor replacement
quote who='Andy Squires' date='Wednesday 27 February 2008' All, Is there such an animal as an AE editor replacement which can log changes to the database done through AE? I use database triggers for these things because it doesn't care how the record got updated or deleted - it just runs the trigger when asked to do so. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Where I'm from, we believe all sorts of things that aren't true. We call it history. The Wizard, Wicked --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AE editor replacement
Is there such an animal as an AE editor replacement which can log changes to the database done through AE? To be clear - I still maintain triggers are superior for this type of work as any security you slap on AE doesn't help you with things like: :DELETE PERSON 1234567 or :MODIFY PERSON FIRST.NAME = Idiot WITH @ID = 1234567 -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Where I'm from, we believe all sorts of things that aren't true. We call it history. The Wizard, Wicked --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] question(s)
quote who='Anthony Youngman' date='Wednesday 06 February 2008' The one problem with SAMPLE and SAMPLED is that, afaik, they are pseudo-random. Unless your file is volatile, you are likely to get approximately the same result set every time (or exactly the same result set, if your file hasn't changed). Correct - when we want psuedo-random, we create a i-desc which calls RND to generate a 6 digit integer. Then you can select against it (either sort or pattern match or whatever) and the results will vary from run to run. It's not truly random, but reasonable enough for most uses (far better than SAMPLE or SAMPLED). For example, to randomly select approx 10% of records: :GET.LIST SOMELIST (or SELECT...) SELECT FILENAME WITH XRANDOM LIKE ...0 or: :GET.LIST SOMELIST (or SELECT...) SELECT FILENAME BY XRANDOM SELECT FIELNAME SAMPLED 10 To randomly select 10 records: :GET.LIST SOMELIST (or SELECT...) SELECT FILENAME BY XRANDOM SELECT FIELNAME SAMPLE 10 -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Where I'm from, we believe all sorts of things that aren't true. We call it history. The Wizard, Wicked --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Wierd voc item problems
quote who='Jeff Fitzgerald' date='Saturday 05 January 2008' What is ELE? I don't see it as a standard verb in either UV or UDT, so assume it is a user or vendor written program? I notice that the actual data displayed in the two examples is identical; just the DICT name associated with the data has changed. I'm suspicious of ELE - perhaps it uses some special record or table or perhaps it has a bug. ELE is a Datatel-hacked editor, ala AE. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Where I'm from, we believe all sorts of things that aren't true. We call it history. The Wizard, Wicked --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT: Email encryption
quote who='Brenda Price' date='Friday 16 November 2007' We sometimes have to email csv files with sensitive information to our clients. Right now we are just setting a password to the zipped files. We really need to encrypt either the whole email or just the attached files. We are using Microsoft Outlook. We're using gpg to encrypt files and it's available for windows, unix and many other platforms. The only issue with gpg is the recipient must have it installed and you have to exchange keys for them to decrypt the file once received. You only need to exchange keys once and then can encrypt and decrypt as many files as you'd like... If you want more details let me know - I just documented this for another audience. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 That's why you have two ears and one mouth - use them accordingly. Mike Golic --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Possible causes of corrupt data on a UniData static file
quote who='Burwell, Ed' date='Friday 02 November 2007' Are there any known issues with UPDATE triggers that write to records that have UPDATE triggers? As long as you don't get into a cycle where trigger A invokes B, B invokes C and then C invokes A. That turns into a nasty infinite loop fast. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 That's why you have two ears and one mouth - use them accordingly. Mike Golic --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata Manuals
Can anyone shed light on what manual(s) provide information about the various udtconfig variables? I've looked in both Administering Unidata on Unix as well as Installing and Licensing UniData with no luck. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 That's why you have two ears and one mouth - use them accordingly. Mike Golic --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata Manuals
quote who='Kathy Tymoczko' date='Monday 01 October 2007' Appendix A Unidata Configuration Parameters in Administering Unidata on Unix isn't what you're looking for? Yes Kathy, you found it. In my haste I performed a poor search and missed this. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 That's why you have two ears and one mouth - use them accordingly. Mike Golic --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Internal Cache in Unidata
Can anyone speak factually about internal cache in Unidata? In short... I often look at performance and attempt to improve things by changing queries, using indicies, rewriting source and so on. In doing so I perform timing and consistently note that the second time a query is performed, it executes considerably faster than the first. As an example, here's the first execution of a series of queries: SELECT H08.CR.DIV.DATA WITH XCDD.HAMP.CMTE.MEMBER=0202736 time=18ms SELECT H08.CR.DIV.DATA WITH XCDD.DIV EQ D2 time=988ms SELECT H08.CR.DIV.DATA WITH XCDD.REV EQ P time=5ms And then immediately peforming these again: SELECT H08.CR.DIV.DATA WITH XCDD.HAMP.CMTE.MEMBER=0202736 time=18ms SELECT H08.CR.DIV.DATA WITH XCDD.DIV EQ D2 time=9ms SELECT H08.CR.DIV.DATA WITH XCDD.REV EQ P time=5ms To be clear - the difference between 988ms and 9ms is not a typo, it's real. Likewise this is not the result of server load. I can consistently reproduce the above scenario with different queries at different times of the day (and wee hours of the morning with few users). I'm not complaining - it's a perfectly good feature - it's just hard to get accurate timings on things so I often perform queries numerous times and dump the first few executions. Of course, this isn't reality as many queries only get executed once in a blue moon... -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Mom - Daddy knows everything. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Internal Cache in Unidata
quote who='Anthony Youngman' date='Monday 24 September 2007' What OS? How much RAM does your server have? Etc etc. What's the likelihood that the data was on disk when you first ran the query, and was pulled into the OS cache as a result? Second time round, the OS didn't bother to access the disk because it was all in cache ... Good point. This is UD 7.1.8 on Solaris, so your thoughts are on target. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Mom - Daddy knows everything. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Internal Cache in Unidata
It's interesting to note that your second of three queries changes drastically during the second invocation while the others remain the same. Without knowing anything about your files or the dictionary items involved, I'm going to guess that XCDD.DIV involves one or more file translates. Nope. For all three of those queries the fields are Data, single valued and indexed. That's why I'm looking at this... -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Mom - Daddy knows everything. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata PE
Where can I get Unidata PE for Linux? When I search on the IBM site and select the link: U2 Personal Editions and Trials (UniData 7.1.0 Personal Edition) Downloads I keep getting taking to System Builder 5.4.1 download - which I don't want. Anyone with a correct link? -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Mom - Daddy knows everything. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniData 7.1 and ODBC
I'm having some basic trouble getting ODBC setup with Unidata. In Developing UniData ODBC Applications under Before You Begin it says: * Make sure the files you want to access in UniData are ODBC/SQL accesible. See Using VSG and the Schema API Yet in Using VSG and the Schema API under Before You Begin it says: * Setup your ODBC server and database information so that the files are accesible to VSG. Here's what I tried and isn't working too well. I edited uci.config file and added the entry testr18 DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = quicksilver.hampshire.edu account = /datatel/coll18/test/apphome When I attempt to run VSG, I see my testr18 definition in the server drop-down, and then enter: Database Name: testr18 User: my_username Password: my_password and get: Died in UCI::SQLConnect() with SQLSTATE 08001, Native error: 0 [IBM][SQL Client][UNIDATA] Database testr18 doesn't exist. Any pointers appreciated. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Daddy - did you lose your mind? Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/