Re: [U2] MS-SQL Question
You can't use the Column alias directly in a where cause, you need to put in a derived dataset (table) i.e. SELECT * FROM ( SELECT substring(colname ,charindex('|',colname)+1, charindex('|',colname, charindex('|',colname)+1) - charindex('|',colname) -1) as PID FROM SomeTable ) as DerivedTable WHERE DerivedTable.PID = something Don Verhagen www.REMOVEemjackTHIS.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, December 28, 2011 3:38 PM To: U2 Users List Subject: Re: [U2] MS-SQL Question It came back with unknown column error. I'll have to play with it again, it's possible I typed something wrong, But at least for now, it's working the other way I set it up. Thanks George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 29 December 2011 2:51 AM To: U2 Users Subject: [U2] MS-SQL Question I'm querying a sequel server , I have a column in one table that the data is in the form of X|Y|Z. I have the following in my SELECT: substring(colname ,charindex('|',colname)+1, charindex('|',colname, charindex('|',colname)+1) - charindex('|',colname) -1) as PID Is there anyway that I can then use the PID designation in a where clause, without having to retype the string again? I can't add a virtual column to the table , and I can't add a procedure either. ___ 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-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] Testing . . .
4 ... 5 ... 6 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Thursday, November 24, 2011 8:34 AM To: U2 Users List Subject: [U2] Testing . . . 1 ... 2 ... 3 ___ 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] Opinions on Cache
First I like to thank all that have responded to my query. I knew that posting a question that may lead me to dropping U2 as a database may cause some concern as to whether that is appropriate for this list. I believe it is, because I want the opinions of people who have experience/exposure in both U2 and Cache. There was a bit of confusion about U2 and SB. If I decide to go with Cache, I would abandon the SB platform for GUI UI. I was interested if there was any conversion utilities between SB and .NET forms. Specifically if Cache has .NET DLLs/providers for connectivity and databinding in .Net controls, etc. I haven't looked at SB/XA yet, which I believe is the XAML (WPF) replacement for SB. The candidate application is approx 15 years old (last used 3 years ago) and is due for a major rewrite/overhaul. I have used WebDE (Redback) in the past and was satisfied with it as middleware. After the comments from this forum, I am going to request an evaluation version from Intersystems. Again, I just wanted to thank all for their comments, both online and offline. Thanks, Don Verhagen Emjack Group LLC. u2-us...@southeast-florida.com -Original Message- Various Posters =) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Opinions on Cache
Group, I want to ask if anyone has had any experience with Cache and also has experience with U2 and SQL. I have been out of the MV (U2) since then of 2008, currently .NET (C#) and MSSQL. I have a large MV application written in SB and Unidata that I would like to re-develop. The basic roundup: Entity Files - Employees (1M+ records) - Customers (1M+ records) Transactons: - Payroll/Timecard/Invocing related files (10M+ records each file). Binary Files: - Photos, Documents (resumes, HR Forms) (2-3M records) This will be a small/midsize enterprise application that will have both desktop, web, and mobile modules. Areas of interest: - Speed (I know this is difficult without hardware/etc). - File / Program Architecture - Development Language/Environment - Change Management (SDLC) - Deployment I just looking for an over feel and professional opinions as compared to other platforms. The biggest issues I have with SQL is the shear about of tables and their inflexibility with max sizes and such. The toughest question I hate to answer what is: The maximum size for column/field Last Name/Surname, Answer: How the hell do I know! Thank you in advance for any and all opinions related to Cache, online or offline. P.S. I have been on this list for at least a decade, please don't hold that against me. =) Don Verhagen Emjack Group, LLC. Email: u2-us...@southeast-florida.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata/SBClient/SBServer Pricing - USA
Group, I'm looking for ballpark pricing for the following Unidata/SB setup for development. I used to deal with IBM directly not a var. I prefer this arrangement but it's not mandatory. I have lost all my US IBM contacts over the last 2 years. What I need is pricing for the following: 5-User Development license for Unidata 7.x for Windows Development License for SBServer or whatever the most current incarnication is. I know there was talk about making SB a .Net component(s). 1-5 SBClient licenses (if the .Net components aren't production ready). Plus Annual support/maintenance for the above. Please feel free to contact me OFFLINE as I don't want to make your pricing info public. =) Thanks, Don Verhagen (donrem...@thissoutheast-florida.com) (please make sure to remove the rem...@this from the email address). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] More questions on indexing
In Unidata (v6.x) you can issue the command BUILD.INDEX MYFILE ALL. With the KEYWORD ALL it's builds/rebuilds all the indexes that have been created on the file. I would hate to have to remember that INDEX_1 is say, Customer Name, verus a dictionary named CUST_NAME. I would agree with others, I rarely had any need to rebuild any indexes with Unidata, other than part of a file resizing/space considerations. Donald Verhagen People 2.0 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, July 16, 2009 4:52 PM To: U2 Users List Subject: Re: [U2] More questions on indexing Brad: I've defined indexes in my files with dictionary items like INDEX_1, etc. Thus only these dictionaries are ever used for indexing. A file may have 4 or 5 indexes (INDEX_1 - INDEX_4). I wrote another program to do the indexing for a single file or an entire account by executing the command... :ACCT-INDEX CUSTFILE -IINDEX_ ...which will create all the indexes on the CUSTFILE. Also, my dictionary listing will show these indexes separately so it looks like: Dictionary of File: APPO 13:48:38 Jul 16 2009 Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt Assoc... @UQ Phr VENDNO CLIEN TNO DISSUE A UTH DESCT DC LOSED INDEX_1 Indx IF DCLOSED N 18L S E THEN CL IENTNO R(%4 ) : UNITNO R(%7) : SE QNO R(%7) @ID D 0 APPO 6RS PONOD 0 PO# 7RS VENDNO D 1 VEND# 5RS CLIENTNOD 2 CLNT 4RS We don't normally rebuild indexes on UD v7.1 or v7.2. HTH, Bill -- -- bradley.sch...@usbank.com said the following on 7/16/2009 1:18 PM: Thanks, Rod. One more thing. I've written a test program to simplify index creation and building. When I run it under type U or type P using BUILD.INDEX or BUILD-INDEX, it gives me the Enter New line to continue... prompt after each screen of *'s. Definitely not desirable for an automated process. It doesn't do this at TCL. How can I work around this? I'd rather not throw a bunch of DATA statements in there. EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY' DATA 20 EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY' EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY' TIA, Brad. Please respond to U2 Users List I think Oracle's indexing scheme is much more complicated that Unidata's, so I don't think you can compare the two. I do rebuild some of the dynamic files on occasion to get some space back. Other than that, I leave them alone and haven't had problems. - Rod Research continues and I have more question for the group: my Oracle buddies rebuild their indexes at least weekly. Seems to be a best practice. Seems odd to not be able to trust that your index is correct. Is this a concern for ud 7.1? TIA, Brad. ud 7.1 AIX 5.3 U.S. BANCORP made the following annotations U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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] Simple Export to Excel
Group (I didn't see who the OP was), I have a perl script/unidata program which will do XLS (Excel 2003 and before). It requires that perl be installed and a few *excel.ppms* freely available. The black box unidata driver program handles column heading, formatting, justification, sorting, subtotaling and grouping. I'm working through the OpenXML formats for Office, I've conquered Word 2007 and moving onto Excel 2007 (openxml) next. I will update the group when I finish. If anyone wants the perl/excel2003 scripts and unidata programs let me know. (email: u2ex...@remove-thissoutheast-florida.com) south east (dash) florida dot com Don Verhagen (Plugging along in SQL and .Net where a simple generic empty validation ain't so simple!) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, July 06, 2009 12:55 PM To: U2 Users List Subject: Re: [U2] Simple Export to Excel On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock lar...@wcs-corp.com wrote: Or, you can create your export in the Office XML format, and tell excel explicitly what to do with each column of data. Absolutely. But what a time-consuming chore that can be... :-) -K ___ 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] [u2u] UV on Windows question
My Outlook Express 2003 directs replies directly back to the list. -- Don V -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: Monday, June 01, 2009 6:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2u] UV on Windows question How interesting, you can't just reply to the email anymore, you have to change the to address. Jerry Banker From: Dave R [mailto:dave.ra...@juno.com] Sent: Monday, June 01, 2009 3:54 PM To: jpb-u...@hotmail.com Subject: Re: [u2u] UV on Windows question Unix has it's own set of administration tools different the windows administration tools, I don't believe they require about the same knowledge to use, if you are a windows engineer you would like a windows platform and if you are a Unix engineer you would prefer Unix. Even thought I use a Windows platform I prefer Unix systems as a platform for a Multi-Value system. If you want to purchase a new system then I would go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the rated by the experts as the best of the systems, Unidata would be next, and UniVerse would be 3rd. The first reason is that Unix systems are not susceptible by Windows viruses. The second reason is security, Most windows hackers are complete lost in UNIX. The Unix systems are more robust. The file management is improved in Unix and The Unix OS was designed for multi users and by mainframe software engineers who have a far more knowledge of multi user environments. Most companies hire windows network engineers and they don't like the idea of Unix platforms. However most large companies run Unix or Aix or Hpux for the platform for Reality or U2. Some other considerations would be if you are coming from a different Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have switches to creating an environment to run that flavor of Multi-Value, requiring little to no conversion of the software and database. A big cost factor in the conversion. Dave R. 949 757 8519 (work) eFax (815)4259364 -- Original Message -- From: JPB-U2UG jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Subject: [u2u] UV on Windows question Date: Sat, 30 May 2009 16:00:37 -0500 I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. Criminal Lawyers - Click here. http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2j cygQ1UHaGxeSYzU7qCu4EnncAfGU1lK5Ikr5JJDuhy/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Leaving U2 World to the Dark Side (SQL)
Brian, Thanks for book suggestions as this is one of the concepts that I am having issues with. Understanding the database/languages, SQL and Csharp, are just a how-to problem which I've got a pretty decent grasp of. However, RECORD LOCKING and concurrency seems to be the white elephant in room that I have seen less written about and worse even less thought out in the application(s) that I'm having to deal with. Thanks, Don Verhagen -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Sunday, February 22, 2009 12:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Leaving U2 World to the Dark Side (SQL) Hi Don I'm sure you'll excel there - especially with your depth of real-world (ie multivalue) knowledge behind you! But I would highly recommend reading whatever is the latest book on SQL Server and .Net by Roger Jennings before you do (check out Wrox press). Apart from the stuff pointed out here about maintaining three tier architectures and not just using data binding (actually, data binding to classes is fine, just binding to data sets is crap) the real bitch is concurrency control and how to handle it when you need to start looking at merge processing. There's a lot of good advise on that in the Roger Jennings books - and details on some hidden language features to make SQL Server access in .Net a lot more performant... Best of luck. Brian -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Don Verhagen Sent: 19 February 2009 11:04 To: u2-users@listserver.u2ug.org Subject: [U2] Leaving U2 World to the Dark Side (SQL) To those that know me on this group. I have been using the Unidata databases since 1998 when introduced to it by my former CIO. Over the years and throughout my IT career, it has served me well. Decreasing software production and maintenance costs, while at the same time increasing the value of the software I (we) developed to solve complex business solutions. I have accepted an Application Development management position with a company here in the Philadelphia area. However, they are not a U2 shop. I view this opportunity as a chance to build my skills in and around the .NET platform and evaluate the use MSSQL in a true business application that I myself have built on a U2 platform in a previous time. While this doesn't exclusively rule out U2 in the future, for now, I'll be in SQL-land. Just wanted give a heads up to those that know me here. Don Verhagen Application Development Manager People 2.0 www.people20.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Leaving U2 World to the Dark Side (SQL)
To those that know me on this group. I have been using the Unidata databases since 1998 when introduced to it by my former CIO. Over the years and throughout my IT career, it has served me well. Decreasing software production and maintenance costs, while at the same time increasing the value of the software I (we) developed to solve complex business solutions. I have accepted an Application Development management position with a company here in the Philadelphia area. However, they are not a U2 shop. I view this opportunity as a chance to build my skills in and around the .NET platform and evaluate the use MSSQL in a true business application that I myself have built on a U2 platform in a previous time. While this doesn't exclusively rule out U2 in the future, for now, I'll be in SQL-land. Just wanted give a heads up to those that know me here. Don Verhagen Application Development Manager People 2.0 www.people20.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Green Software - Green Business
Susan, While the below changes may result in green results I tend to believe the main motivation behind most of the changes were monetary not environmental. Every green change has monetary benefit to the business owner. 1) Software and Documentation - No CD production costs / No Reams of Paper 2) Don't commute / Employees don't commute -- No office building rent/lease, a/c, water, etc. 3) Travel -- Obvious, however, it may be like me and I like to keep me shoes on in public. =) I think the question is what really motivated the change. Money (and convenience) or green? Would you make a green change if it *cost you more* money than not going green. And as a side note, I hate green, the movement, the color. Can't we go blue? The sky is blue, so is the ocean, so is the porn..., damn it, blue is out. Don Verhagen Commuting 60 miles a day in 5.7L Hemi SUV with the a/c on high and the windows open. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Friday, July 25, 2008 7:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] Green Software - Green Business This idea is interesting, though. Is this bordering - or boldly going - into an off-topic discussion? Software companies (and departments) are among the types of organizations that can most easily lend themselves to Kermit-chrome. I can't say that I require payment by Paypal - my customers' are businesses that have accounting departments and pay cycles and all kinds of things that I don't feel are my right to force them to circumvent in order to do business with me. But I do provide the software and the documentation via electronic media, I avoid unnecessary paper, I don't commute and the folks that do work for me also do it from home. I do upgrades and training remotely with more and more use of web-based meetings. So less flying my carbon footprint around (which also conserves my more personal energy!) So far my efforts to go green have been very easy. They corresponded with technology advances, good sense budget monitoring and convenience. That's a triple win! I would be interested in hearing about other companies who are making any efforts and what kind of efforts to go green. Replacing monitors? Lowering the power settings? (I'd have a hard time seeing my laptop screen!) What else is anyone doing or thinking of doing? Curiously and even spuriously yours, Susan J. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD
John, Try using lower case list, this will force ECLTYPE U (Unidata) flavor. Don Verhagen - Original Message - From: John Kent [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, June 03, 2008 6:41 PM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | Bill, |not for me though | | LIST STK EVAL DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 09:01:48 04 Jun 2008 1 | STK... | | Illegal attribute: | select criteria EVAL is not a field. | | whereas an itype will | ED DICT STK JAK | Top of JAK in DICT STK, 6 lines, 50 characters. | 001: I | 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) | 003: MD0 | | i am not familiar with Unidata nor they way this machine is configured but | it annoying when simple things like this dont work | | jak | | - Original Message - | From: Bill Haskett [EMAIL PROTECTED] | To: u2-users@listserver.u2ug.org | Sent: Tuesday, June 03, 2008 7:06 PM | Subject: RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | | | Jak: | | This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = | Pick. | | :list APOPEN ACCTS AMTS EVAL DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM) | COL.HDG Cnt | | APOPEN ACCT. ACCT/AMTS Cnt... | | 69*7 2090270.06 1 | 830*38779 3060120.64 2 |3070111.13 | 830*38750 3060 63.03 2 |3070 51.78 | 830*38895 3060 37.15 2 |3070 52.51 | | Bill | | -Original Message- | From: [EMAIL PROTECTED] [mailto:owner-u2- | [EMAIL PROTECTED] On Behalf Of John Kent | Sent: Monday, June 02, 2008 8:11 PM | To: u2-users@listserver.u2ug.org | Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | | Jeff, | what actually worked was... | | DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) | | doesn't seem to work in an EVAL though | eg | LIST STK EVAL DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) A30 | | jak | - Original Message - | From: John Kent [EMAIL PROTECTED] | To: u2-users@listserver.u2ug.org | Sent: Tuesday, June 03, 2008 11:38 AM | Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | | | Jeff, | that'll do, thanks | jak | - Original Message - | From: Jeff Butera [EMAIL PROTECTED] | To: u2-users@listserver.u2ug.org | Sent: Tuesday, June 03, 2008 11:08 AM | Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype | @RECORD | | | On Tue, 3 Jun 2008, John Kent wrote: | | Ken, | i want to create a simple dict item like | | ED DICT STK JAK | Top of JAK in DICT STK, 6 lines, 38 characters. | *--: P7 | 001: I | 002: DCOUNT(@RECORD30,@VM) | | Try this: | | DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) | | Jeff Butera, Ph.D. | Administrative Systems | Hampshire College | [EMAIL PROTECTED] | 413-559-5556 | --- | u2-users mailing list | u2-users@listserver.u2ug.org | To unsubscribe please visit http://listserver.u2ug.org/ | --- | u2-users mailing list | u2-users@listserver.u2ug.org | To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] OT: Textpad Syntax File for Unidata
Group, I was wondering if any else out there uses a text editor TEXTPAD and has already created a syntax file for it. If so, please email offline or link. Thanks, Don Verhagen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time Travel
I own the domain. It's not hosted by myself here in the frigid 82F degree winter. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Monday, November 26, 2007 2:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I thought that the list server was located in Australia but when I looked it up in whois it shows up in Florida and administered by Donald Verhagen!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I have to add my two bits. Okay, I don't 'have' to... I use the exact same email group software (majordomo 1.94.5) on my 'home' system with over 7000 subscribers to over 180 different email groups. Our groups never see the delays the members of this group see, so with all due respect, there's something different happening that's causing the lags. We often see as many as 200 emails a second going out of our server, which is an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and running fedora core 4 (old...). Our group members get their emails back within seconds, literally. I send an email to this group, and it sometimes takes an hour or so before I see it come back to me. I send an email to one of my groups at home, and I get it back within seconds. Now then, with that said, I've also added bulk_mailer to my email group server so maybe that speeds things up a great deal. I don't know. I did it so I would quit getting the annoying 'too many email connections from your server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero, juno, gmail, . . . ad infinitum of the 'big' email hosts. My point? none really, other than to show that Charles' nice numerically explained _time travel_ doesn't match my real-life experience with my own majordomo server... I don't know why, they just aren't the same. Karl quote who=Symeon Breen Or upgrade to a forum based group - just my standard gripe about email lists ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: 26 November 2007 06:03 To: u2-users@listserver.u2ug.org Subject: [U2] Time Travel To fix this problem, you'd have to redesign the methods under which the internet manages and routes mail. - Charles Barouch, Moderator --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time Travel
Let me rephrase that. I donated the funds for the domain name and registered it. U2UG owns the domain in whole. I love whois..I should have paid for that privacy thingie too. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Monday, November 26, 2007 2:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I thought that the list server was located in Australia but when I looked it up in whois it shows up in Florida and administered by Donald Verhagen!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I have to add my two bits. Okay, I don't 'have' to... I use the exact same email group software (majordomo 1.94.5) on my 'home' system with over 7000 subscribers to over 180 different email groups. Our groups never see the delays the members of this group see, so with all due respect, there's something different happening that's causing the lags. We often see as many as 200 emails a second going out of our server, which is an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and running fedora core 4 (old...). Our group members get their emails back within seconds, literally. I send an email to this group, and it sometimes takes an hour or so before I see it come back to me. I send an email to one of my groups at home, and I get it back within seconds. Now then, with that said, I've also added bulk_mailer to my email group server so maybe that speeds things up a great deal. I don't know. I did it so I would quit getting the annoying 'too many email connections from your server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero, juno, gmail, . . . ad infinitum of the 'big' email hosts. My point? none really, other than to show that Charles' nice numerically explained _time travel_ doesn't match my real-life experience with my own majordomo server... I don't know why, they just aren't the same. Karl quote who=Symeon Breen Or upgrade to a forum based group - just my standard gripe about email lists ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: 26 November 2007 06:03 To: u2-users@listserver.u2ug.org Subject: [U2] Time Travel To fix this problem, you'd have to redesign the methods under which the internet manages and routes mail. - Charles Barouch, Moderator --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Unidata 7.1 / HPUX 11.11i
I have a question for the group. Mainly because I'm too lazy to go to the IBM product matrix and also wondering if anyone else is running this configuration. I was told by people inside my organization that UD 7.1.x only runs on HPUX 11.x in 64-bit mode and I find that hard to believe. Currently we are running UD 6.0.9 on HPUX 11.11i in 32-bit (non 64-bit mode). So my question is, is UD 7.1.x only available on HPUX in 64bit versions? Thanks for advice or experiences. -- Donald Verhagen Director Of Application Development [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Union Query
I'd have to second David on this. I wish in Unibasic there was a program/function to create temporary user files that get cleaned-up on exit and let UD/UV determine the area to create these on the file system. Donald Verhagen Never clean my room when I was younger either -- Donald Verhagen Director Of Application Development [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 5/16/2007 at 12:26 pm, in message [EMAIL PROTECTED], David Wolverton [EMAIL PROTECTED] wrote: Question for everyone then: Should IBM invent a method to extend the Query languages of UniData/UniVerse to do this 'Temporal File' - a Cross Data File SELECT/LIST/SORT? That is, should the logic for handling multiple datafiles with a common dictionary basis be 'native' to the processes? Would we gain significantly from this? If so, this should go to the Better n' Better group and U2AskUs... Have to contemplate how it would work though - essentially, they would have to have back TWO elements on 'READNEXT' - the datakey and the file But I could see TREMENDOUS use on some new fuctionality here... David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Norman Morgan Sent: Wednesday, May 16, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Union Query I'm with you, Charles. We face this all the time, since Prelude's ADS splits data into open and history files. Merging lists is all well and good, but I still have to retrieve data from two separate files. I always wind up writing Basic to do it, making independent selects from each file and writing the keys to a work file with a tag indicating where the data resides. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
So Simple, yet effective. Regards, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 3/15/2007 at 10:52 am, in message [EMAIL PROTECTED], Michael Rajkowski [EMAIL PROTECTED] wrote: If you are trying to determine that two files are pointing to the same thing, you could set a lock on one and try to set it on the other. If it will not let you do it, then you have the same file. ( note that my first thought was to write an item, but that could cause problems if anyone else was using the file. ) give the lock a unique name like testingFilePointerTestProgram so you don't have issues with existing data. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with File Pointers
Susan, I noticed that err..that other software...had problems with relative paths. With SB Installed (and maybe without) you can get the base path of the ACCOUNT that the VOC from DMACCOUNTS1. You can then work with what the VOC entry from the path ACCOUNT in the account. I think you're asking how to determine the full path even when you're not LOGGED to the ACCOUNT, correct? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 3/12/2007 at 5:18 pm, in message [EMAIL PROTECTED], Jeff Schasny [EMAIL PROTECTED] wrote: This: ../.. means the directory above the directory above the one I'm in right now, so by knowing where you are right now (pwd) you can fill in the complete path.and compare apples to apples Susan Joslyn wrote: Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Redback on Windows 2003 Server
The first Redback that installs correctly on Windows 2003 is 4.2.5, but if you're upgrading from 3.2.3, you might as well upgraded to the newest 4.3. 3.2.3 will not work on WIn2003 Server. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 1/20/2007 at 12:56 pm, in message [EMAIL PROTECTED], Susan Lynch [EMAIL PROTECTED] wrote: Jan, Given that the earliest release of Redback that shows W2003 in the Product Availability matrix is 4.2.3, and 3.2.3 is not even on the Product Availability list, I think you probably want to upgrade Redback. Susan Lynch - Original Message - From: Jan Darr [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, January 19, 2007 5:31 PM Subject: [U2] Redback on Windows 2003 Server I'm attempting to install Redback, version 3.2.3 onto a Windows 2003 Server, will this load properly? Is there something different that needs to be done, once installed to allow it to run? I've noticed that the scripts folder did not get created, in addition to the Redback programs not getting installed. Do I need a later release? Any and all help is greatly appreciated. Thanks, Jan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Program Mgmt System
Barry, So Susan J (list member) doesn't have to toot her own horn, I will. We have been using PRC Revision Control Software since 2001 and could be happier with it. (www.sjplus.com) Handles programs, data items (if desired), etc... Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 12/1/2006 at 9:02 am, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: To all, We are in process of getting new systems here, which will be allowing us to segregate the programming people from the live system In this light, we will actually be setting up a form testing to implementation environment. Question: Does anybody know of a good 'software management' program out there that will allow us to manage program version control, implementation process, auditing capabilities, etc, etc.Any suggestions will be much appreciated. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Program Mgmt System
That was suppose to say Couldn't be happier with it. Sorry, I'm not very good at this plugging stuff. Thanks, Don V -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 12/1/2006 at 10:49 am, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: Barry, So Susan J (list member) doesn't have to toot her own horn, I will. We have been using PRC Revision Control Software since 2001 and could be happier with it. (www.sjplus.com) Handles programs, data items (if desired), etc... Thanks, --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] OpenXMLData error
Jason, Unless it's a typo, you quoted the TEST_XML_HANDEL variable in your OpenXMLData statement Should by STATUS = OpenXMLData(TEST_XML_HANDEL,.) not OpenXMLData(TEST_XML_HANDEL,...) Don V On 11/17/2006 at 7:11 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: Hi guys. I am doing some testing of receiving XML data into Universe database and I and kind of stuck with the OpenXMLData function which keeps returning a INVALID.XML.HANDEL error. Here is what I attempted to do in a BASIC program mostly by following the examples in BASIC Extension documentation. $INCLUDE UNIVERSE.INCLUDE XML.H STATUS = PrepareXML(TEST_FILE/TEST.xml, TEST_XML_HANDEL) IF STATUS # XML.ERROR THEN STATUS = OpenXMLData(TEST_XML_HANDEL, XML/TEST_EXTRACT_RULES, TEST_XML_DATA) END STATUS returned by OpenXMLData always gives me -2 which is XML.INVALID.HANDLE. All examples I have found for OpenXMLData are passing quoted string for the xml handle and I don't know why. If OpenXMLData depends on a valid xml handle created by PrepareXML, I imagine the variable TEXT_XML_HANDEL should be passed to OpenXMLData. However, examples I have seen in Universe docs all have the xml handle name quoted. (Here I am thinking the xml handle variable works like a opened file variable). If I remove un-quote the xml handle name, STATUS returned will be -1. Does any know anything wrong with my usage of OpenXMLData? Thanks. Jason --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Sort / Select keyword
John, I think the keyword is EXPLAIN. I don't have a copy of Universe nearby. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 10/13/2006 at 10:02 am, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I seem to recall that there is a keyword / option / modifier which will display more details about the internals of a select statement. Am I hallucinating again or is there really such an animal ? We are on UniVerse 9.6.1 Cheers John Rodgers --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV 10.2 Data encryption/ Unidata Soon?
Steve, Are they plans to include this in a Unidata release anytime soon? I have a few hundred thousand SSN numbers that are feeling a bit unprotected in the big bad cold world of ours. =) Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 9/29/2006 at 10:14 am, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: OK Gals Guys! This has a really big feature in it... Data encryption at rest! Stated another way... You can encrypt individual fields of a file, like the CREDIT CARD NUMBER, with little or no programming changes! From the announcement UniVerse 10.2 automates encryption of data at rest, protecting important information and meeting government standards. This advanced technology utilizes today's modern cryptology techniques to secure data at rest with little to zero changes to applications. Utilizing a new graphical interface, administrators can create the security rules needed for their organization, thus protecting sensitive information at the field or record level. FYI... Steve Stephen M. O'Neal Lab Services Sales for U2 IBM SWG Information Management Lab Services Hennessey, Mark F. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/29/2006 06:56 AM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] UV 10.2 has been announced Did everyone get their marketing-gram from Janet Oswald? --- We are pleased to announce that IBM UniVerse. 10.2 will be generally available on September 29, 2006. This release protects personal data, supports U2 Web Services, strengthens and streamlines high availability, and more! Read the full product announcement at http://www.ibm.com/software/data/u2/universe/universe10-2.html If you have any questions on the information, please send them to [EMAIL PROTECTED] --- It appears that the product availability page has not been updated yet Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Personal Editions
It says right in this email below: - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 29, 2006 4:33 PM Subject: [U2] UniVerse Personal Editions All, Because the current UniVerse 10.1.11 (Windows) and 10.1.12 (Linux) Personal Editions were about to expire (31 August 2006), we have reloaded them with a new expiration date. The updated copies will expire on 31 October 2006, and will be replaced by UniVerse 10.2 versions about a month before then. If you are running either 10.1.11 or 10.1.12 Personal Edition, you should download and install the replaced copies to avoid interruption. So it looks like the new date for UV10.2PE is around 31 Oct 2006 Don On 8/31/2006 at 12:00 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I was told 10.2 would be released in August back in June while I was at a training class in December. Then through something else (this list I believe) the date became 8-31-2006. That is today. Since that hasn't happened, any idea when? Brenda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: Thursday, August 31, 2006 8:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Personal Editions All, Only the two 10.1 servers were updated. There is no need to download the clients again until they are replaced with those from 10.2. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Data Servers [cid:_2_0A4857540A4855478B87872571DB] Tel: 303-773-7783 Fax: 303-773-5915 Mobile: 720-341-4317 Tie-line: 656-7783 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Information On Demand conference 2006-[cid:_2_0A486E080A486AC000478B87872571DB] jpb [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/30/2006 03:10 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject Re: [U2] UniVerse Personal Editions My bad, I found the problem. Was using an old link to the program. - Original Message - From: jpb [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, August 30, 2006 3:13 PM Subject: Re: [U2] UniVerse Personal Editions I also tried the new UniAdmin and now It won't connect to my servers. One is the PC I am on, another is our Linux server, and the last is our Solaris test system. None will connect. What's up? Jerry - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 29, 2006 4:33 PM Subject: [U2] UniVerse Personal Editions All, Because the current UniVerse 10.1.11 (Windows) and 10.1.12 (Linux) Personal Editions were about to expire (31 August 2006), we have reloaded them with a new expiration date. The updated copies will expire on 31 October 2006, and will be replaced by UniVerse 10.2 versions about a month before then. If you are running either 10.1.11 or 10.1.12 Personal Edition, you should download and install the replaced copies to avoid interruption. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Data Servers [cid:_2_0BF4A3E80BF4A19400765456872571D9] Tel: 303-773-7783 Fax: 303-773-5915 Mobile: 720-341-4317 Tie-line: 656-7783 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Information On Demand conference 2006-[cid:_2_0BF4BA9C0BF4B75400765456872571D9] [demime 1.01d removed an attachment of type image/jpeg] [demime 1.01d removed an attachment of type image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg] [demime 1.01d removed an attachment of type image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] VAR[1] was Encrypt...
I don't agree that RESULT[1] is any clearer/cleaner than RESULT[LEN(RESULT),1]. Does the [1] represent the FIRST character or the LAST character? I will agree that it's shorter to write. =) -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 8/25/2006 at 1:26 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: David A. Green wrote: Why do programmers use result[LEN(result),1]? Doesn't result[1] do the same thing but easier, quicker, and more readable? snip variable[1] to reference the last byte of variable is a relatively recent addition to Universe. Where relatively refers to the lifeline of the Pick/PI/U2 product family. So you'll typically see it either in older code, or in code written by guys who've been programming a while and haven't picked up on all of the newer facilities. I vaguely remember it being introduced and enjoying the fact that I could write less code and have it more readable. So it became one of the things I tended to retrofit as I was working on existing code, not worth looking for, but worth cleaning up while I was in the neighborhood. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Hosted UniData
We've colo'd at an SBC (ATT) data center also for the last 2+ years. The best thing about the ATT center is the communications connected to the Matrix [smirk]. With the 4 hurricanes last year and 3 the previous, Our US locations didn't even blink (I on the hand, beg, borrowed, and yes, even stole fuel). We use to have it in our own site with generators, the servers were up, but no one could connect because the telecom lines were down. David W, If you want some pricing info call me direct, you know the numbers. Thanks, Don Verhagen Tandem Staffing Solutions, Inc. On 8/9/2006 at 1:40 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Wednesday, August 09, 2006 7:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] Hosted UniData We have a customer wanting to review options for 'Outsourcing' their servers - either to a CoLocation facility, or a fully hosted site. Does anyone have their servers for UniData CoLo or Hosted, and if so, would you mind sharing your provider and experience? We've had our UV server colo'd at one of SBC's (now ATT) data centers for about 5 years, and have been happy with their service. They provide what you'd expect from a hardened data center: Multiple layers of physical security - you pass through 2 man traps and a biometric palm scan to get on the data center floor. Connections to multiple power grids and redundant diesel generators. 24x7 access. 24x7 staffed NOC if you need something power-cycled (i.e. a hung Windows server). Data center floor elevated above the flood plane. Built to withstand a 7.4 earthquake. A fire suppression system that won't damage electronics. Redundant internet connections to your cabinet. As Symeon noted, the software you're running is irrelevant to your colo provider since you manage the servers yourself. AFAIK, SBC only had 2 data centers prior to the merger with ATT (southern California and west Texas), but I think ATT had a few more. They also offer some degree of managed hosting, but I've never checked into the details. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ICONV 'DW' [was:UniVerse Internal Date Blackout]
On 6/13/2006 at 5:38 am, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: Brian, [snipped...] As far as ISO conversion goes - here's a hypothetical question for you: If 2 book orders came in from the web each for 1 Da Vinci Code, you only have 1 in stock, which order gets priority? The one dated 2006-04-30T02:56:32+11:00 or the other dated 2006-04-29T11:56:32-05:00? That's right, you have to cut the book in half... even though one order was dated the 30^th and the other the 29^th they were raised at exactly the same moment in time (spooky music plays - camera pans to cryptic symbols ...) and have the same temporal priority. The fact that ISO date time is a recognised international standard and is used extensively in XML, is language and OS independent and that it DOESN'T separate date and time is actually something I wish Pick did better. It is functionality that IBM already have in other products and could easily incorporate into a U2. I agree with Stuart on this. I do a lot of TIME calculations. including time zone conversions, in which the date is vital. i.e. Tuesday June 13th 1:00AM EDT is converted to Monday June 12th 10:00PM PDT. Here the date is affected as well as the time. And it *is* an ISO standard, so it would be nice if it was supported. Yeah yeah, I wrote a function. =) Don Verhagen Cheers, Stuart __ Stuart Speaking of ICONV, anyone noticed that `DWx' conversions are fubar. Sorry to sound negative and apologies if I'm misunderstanding your gripe but.. How can you ICONV with a DW? Date conversions should ICONV to a specific date to be meaningful: if you want to convert a Monday - which Monday? This Monday, last Monday, nearest Monday, the first Monday (this year), first Monday ever? (give or take a couple of billion years). And if IBM did pluck one of those out of a hat, you can bet your bottom dollar half the people on the list would complain that it wasn't *their* interpretation. Some conversions just ain't meant to be reversible. This, along with my other gripe of not easily handling ISO standard dates (-mm-ddTHH:mm:ssZ) it seems like an That really stems from the fact that MVDBMS sensibly separate date and time: something I so often wish other languages did! You can get the date format using: D-YMD[4,2,2] Eg. LIST BOOK_SALES SALE_DATE CONV D-YMD[4,2,2] LIST BOOK_SALES SALE_DATE SALE_DATE CONV D-YMD[4,2,2] 09:26:16am 13 Jun 2006 PAGE 1 BOOK_SALES... Sale Date.. Sale Date.. 13660*37800*1 25 MAY 2005 2005-05-25 13512*63000*1 28 DEC 2004 2004-12-28 13715*54000*3 19 JUL 2005 2005-07-19 Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Phantom Question
Are you closing the printer. The printer is automatically closed once the program ends. PRINTER ON PRINTER OFF PRINTER CLOSE Otherwise it's held in the print buffer until the program ends. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 4/19/2006 at 3:12:50 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: RedHat 8 Unidata 6.0 I use PHANTOM to run a proc that starts a program that continuously checks an item looking for work to do. The terminal output from that program is recorded in the como file, but any output sent to the printer does not print until the process is instructed to end. Then everything it has been asked to send to the printer shows up all at once. This rather defeats the purpose of the routine. Any ideas? Thanks, Kebbon Irwin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TIME
I have to agree. We are in 4 times zones in the US and 2 Daylight Savings Time (Arizona and parts of Indiana do not observe DST). We store all our DATES and times in EST. You have to always include the DATE when dealing with time because 04/04/2006 12:30AM PST is 04/03/2006 11:30PM MST (notice the date). And you have to account for Daylight Savings Time. Warning Code Below * FUNCTION B.OFFSET.TIME(cDateTime,cToTimeZone,cFromTimeZone) INCLUDE DMSKELCODE COMMON ** * Meta Comment Header * ** * @AUTHOR = DON * @CDATE = 03/04/04 * @VERSION= 1.0.39 * @LMOD = 01/19/06}16:36:20}DON * @SDESC = Convert A Date and Time to An Offet Date and Time * cDateTime * 1 - Time To Be Converted (If Blank, Assume Current EST Time) * 2 - Date (If Blank, Assume Current EST Date * 3 - Use DST (Y/N) (Default is Y) * ReturVal * 1 - Offset Time * 2 - Offset Date * Needs a TimeZone Record (EST | CST | MST | PST) * TZ.REC * 2 Holds the offset from the BASE ZONE (In this case Base Zone is EST) ** ReturnVal = '' IF LEN(cDateTime1) = 0 THEN cDateTime1 = TIME() IF LEN(cDateTime2) = 0 THEN cDateTime2 = DATE() IF LEN(cDateTime3) = 0 OR cDateTime3 # 'N' THEN cDateTime3 = 'Y' * * OffsetDate = cDateTime2 OffsetTime = cDateTime1 + 0 OffsetYear = OCONV(OffsetDate,'DY') OffsetDST = (IF cDateTime3 = 'N' THEN 0 ELSE 1) ** * Determine If Daylight Savings Time is in Effect * DST Starts on the FIRST Sunday of APRIL * DST Ends on the LAST Sunday of OCTOBER ** BEGIN CASE CASE OffsetYear = 1917 * No Daylight Savings Time DSTSDate = '' DSTEDate = '' CASE OffsetYear = 1918 AND OffsetYear = 1919 * Last Sunday Of March / Last Sunday Of October DSTSDate= ICONV('03/31/':OffsetYear,'D4/') DSTEDate= ICONV('10/31/':OffsetYear,'D4/') * DSTStart.Found = 0 LOOP WHILE (DSTStart.Found = 0) DO IF OCONV(DSTSDate,'DW') = 0 THEN DSTStart.Found = 1 END ELSE DSTSDate -= 1 END REPEAT * DSTEnd.Found = 0 LOOP WHILE (DSTEnd.Found = 0) DO IF OCONV(DSTEDate,'DW') = 0 THEN DSTEnd.Found = 1 END ELSE DSTEDate -= 1 END REPEAT CASE OffsetYear = 1920 AND OffsetYear = 1941 * No Daylight Savings Time DSTSDate = '' DSTEDate = '' CASE OffsetYear = 1942 AND OffsetYear = 1945 * Observed Continuously Due To WWII DSTSDate= ICONV('02/09/1942','D4/') DSTEDate= ICONV('09/20/1945','D4/') CASE OffsetYear = 1946 AND OffsetYear = 1965 * No Daylight Savings Time DSTSDate = '' DSTEDate = '' CASE OffsetYear = 1966 AND OffsetYear = 1973 * Last Sunday In April, Last Sunday In October DSTSDate= ICONV('04/30/':OffsetYear,'D4/') DSTEDate= ICONV('10/31/':OffsetYear,'D4/') * DSTStart.Found = 0 LOOP WHILE (DSTStart.Found = 0) DO IF OCONV(DSTSDate,'DW') = 0 THEN DSTStart.Found = 1 END ELSE DSTSDate -= 1 END REPEAT * DSTEnd.Found = 0 LOOP WHILE (DSTEnd.Found = 0) DO IF OCONV(DSTEDate,'DW') = 0 THEN DSTEnd.Found = 1 END ELSE DSTEDate -= 1 END REPEAT CASE OffsetYear = 1974 * Changed By The Energy Commission DSTSDate = ICONV('01/06/1974','D4/') DSTEDate = ICONV('10/27/1974','D4/') CASE OffsetYear = 1975 * Changed By The Energy Commission DSTSDate = ICONV('02/23/1974','D4/') DSTEDate = ICONV('10/27/1974','D4/') CASE OffsetYear = 1976 AND OffsetYear = 1986 * Last Sunday In April, Last Sunday In October DSTSDate= ICONV('04/30/':OffsetYear,'D4/') DSTEDate= ICONV('10/31/':OffsetYear,'D4/') * DSTStart.Found = 0 LOOP WHILE (DSTStart.Found = 0) DO IF OCONV(DSTSDate,'DW') = 0 THEN DSTStart.Found = 1 END ELSE DSTSDate -= 1 END REPEAT * DSTEnd.Found = 0 LOOP WHILE (DSTEnd.Found = 0) DO IF OCONV(DSTEDate,'DW') = 0 THEN DSTEnd.Found = 1 END ELSE DSTEDate -= 1 END REPEAT CASE OffsetYear = 1987 * First Sunday In April, Last Sunday In October DSTSDate= ICONV('04/01/':OffsetYear,'D4/') DSTEDate= ICONV('10/31/':OffsetYear,'D4/') * DSTStart.Found = 0 LOOP WHILE (DSTStart.Found = 0) DO IF OCONV(DSTSDate,'DW') = 0 THEN DSTStart.Found = 1 END ELSE DSTSDate += 1 END REPEAT * DSTEnd.Found = 0 LOOP WHILE (DSTEnd.Found = 0) DO IF OCONV(DSTEDate,'DW') = 0 THEN DSTEnd.Found = 1 END ELSE DSTEDate -= 1 END REPEAT END CASE * DSTInEffect = (IF OffsetDate DSTSDate OR
Re: [U2] check signature [Possible AD]
We currently print about 500,000 checks a year (past 6 years) using a set of programs (Unibasic) that I wrote that will/can print the following: 1) Signature (Black White Tiff) or signature lines if above a pre-signed limit 2) The MICR Line (Can either use a secured DIMM chip or not) 3) Any number of graphics (boxes, logos, etc) 4) Multiple Check Forms (ie A/P, Payroll, etc..) Email me off line at (don at southeast-florida dot com) if you want more info. This may be an AD, however, I never released the code outside the company I work for, although I been tweaking for years here and there. I'm think I'm willing to give it try with outside company. Lastly you didn't say what platform and o/s you are on. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 3/9/2006 at 4:44 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I am converting our AP Checks from tractor fed continuous forms to laser print. They currently have a check signing machine that they feed the stack of checks into after they have printed. How do other companies handle check signing? Is there a way to print a digitized signature from the basic program? Any other ideas? Thank you. Steve Kunzman ASI DataMyte 2800 Campus Drive, Suite 60 Plymouth, MN 55441 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [Redback] Upgrading from 4.2.5 to 4.2.6
I'm going to be upgrading my Redback Server and Gateway from 4.2.5 to 4.2.6 and I have one question about the Gateway. Currently I have my web server (open to world) on ServerA and I have the Redback Server on a server on the inside (ServerB). I wanted to do a 2 step Upgrade. That is upgrade the Redback Server (ServerB) first to 4.2.6 and then, at a later point, upgrade the web server Gateway on ServerA. Does anyone know if the Gateway (4.2.5) will run/connect with the Server (4.2.6) properly? The reason for this is that I have other websites running on ServerB and don't necessarily want to disrupt them until some schedule offline time. Thanks for any heads up. -- * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata XML
I found this out the hard way also. I believe the documentation is wrong (for Unidata). Thanks, -- * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 2/5/2006 at 3:33 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I originally wrote about a compilation error with: X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE) X.STATUS = OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE, X.XML.DATA.HANDLE) On Sun, 5 Feb 2006, Allen Egerton replied: The compiler is seeing what you're defining as functions as matrixes. Which means that you've got a more basic problem 'cause you're not trying to use matrixes. You need to somehow define the subroutines/functions you're trying to use. Funny solution here - In Unidata 6.1.4, I have to enter these function names in uppsercase to compile cleanly (although the document indicates these are case-sensitive). After uppercasing everything, it compiles cleanly. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a Folder
CREATE.FILE DIR NEW.BP You need the Keyword DIR (For directory/folder) in the CREATE.FILE command. It basically creates the DIRECTORY NEW.BP and the DICTIONARY D_NEW.BP (As a file at the same level as the directory, not IN the directory) The VOC entry should look something like: 1] DIR 2] NEW.BP 3] D_NEW.BP With your brute force method you also need to copy an EMPTY DICT (Except for @ID). I've done this before: 1] DIR 2] NEW.BP 3] D_VOC Just for a temporary look at a directory. However, it's very dangerous using D_VOC, because if you delete.file NEW.BP, there goes your VOC (MD). I've done that before too..heh. Hope this helps, -- * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 1/27/2006 at 3:58 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP for UniBasic code... Now we have /u2/METAL/ DATA1 DATA2 /u2/SOFTWARE/... AP.BP/ APP.1 APP.2 PUR.BP/ APP.98 APP.99 NEW.BP Without luck, I tried it brute-force in Unix; UV did not recognize it. I tried CREATE.FILE; I need a folder, not a file. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata on XP Lap Top
* Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 [EMAIL PROTECTED] 3:39 pm 01/17/2006 [SNIPPED..] And.I'd LOVE to make this available to all the diet groups, but telling everyone to install Unidata PE sort of makes that OVERKILL to the max for someone that just wants to see what their favorite recipe comes out per serving [..SNIPPED] Not to mention a clear violation of IBM's copyright. Direct from the website when you download, in this case UD7.1PE You may 1) use the Program only for internal evaluation, testing, or demonstration purposes, on a trial or try-and-buy basis; and 2) make and install a reasonable number of copies, including a backup copy, of the Program to support such use. The terms of this license apply to each copy You make. You will reproduce all copyright notices and all other legends of ownership on each copy, or partial copy, of the Program. Thanks, --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
Or you can use a PERL script to take a File that is delimited by @AM (rows) and @VM (columns) and create an XLS binary file. I currently do this on an HPUX 11.x running Unidata 6.X. Did I mention it was free? Email me offline if you would like details. Thanks, * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 [EMAIL PROTECTED] 2:45 pm 01/13/2006 Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse - file importation
If you email offline (see email below) I will send you a DBF converter I have written in Unidata (surely easily converted to Universe) that can read the DBF file DIRECTLY in it's binary format and create a unidata file (complete with dictionaries from the DBF structure) . Thanks, Don Verhagen [EMAIL PROTECTED] [EMAIL PROTECTED] 4:16:54 PM 11/10/2005 Perhaps a nightly (or hourly) Windows script to create a .txt file from dBase to a Windows network drive. I presume that wIntegrate has some (cron) scripting functionality. From wIntegrate, run a UniBasic application to thing to grab the .txt file and save the data to a UV file. As an alternative, I expect that an ODBC/JDBC/XML thing could be setup. A challenging task... --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen Sent: Thursday, November 10, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse - file importation Does anybody know of a good way (or program/utility) to import (translate as it were) dBase IV data onto a UniVerse system. We have a shipping package that uses dBase IV and I would love to be able to utlize that data from UniVerse. As always, any help is greatly appreciated. UV :10.0.19 HPUX: 11.0 Cheers, Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] NFA and Triggers
Wendy, We use NFA pointers on our web server, so basically the kiddies can't get all of our production files [grin]. Triggers get executed on the server where the files live (aka not the remote server). However, you will not be the Enviroment of the account, it's just Unidata running. We for example have SB+ Accounts, the SB enviroment is NOT loaded (ie @ACNT.NAME, @USER.ID, @PORT are initialized but values are not set.) So if your triggers depend on these things you may have to setup a program in your login process to load these enviroment variables. Hope this helps, * Please NOTE NEW Telephone Number * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8118 [EMAIL PROTECTED] 4:58:43 PM 11/01/2005 Wendy: I have not tried this, but I would expect the trigger defined on the file on the remote system would work fine. There is no NFA file on the 'client' system - just an 'FX' style file pointer - so you couldn't define a trigger to fire on an FX pointer in the 'client' environment. (using 'client' loosely - as the system with the FX pointer to a file on a 'remote' system) Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 New Number! Fax: 303.773.5915 New Number! [EMAIL PROTECTED] Wendy Smoak [EMAIL PROTECTED] g To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] NFA and Triggers 11/01/2005 10:47 AM Please respond to u2-users Given a file with a trigger, where does the trigger code actually execute when you open a file with (over?) NFA and write a record to it? We have some trigger code that needs a certain environment (Datatel's Envision) to run, and that environment exists where the file lives... but not in the account from which we're opening files with NFA. The backup plan is to get rid of the trigger and simply write records to a file that gets processed later by a cron job. Any advice or discussion to help me understand this better? -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic07440.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [RANT] HTH
CTDSL = CHANGE THE DAMN SUBJECT LINE. Re: [U2]UD Login User There we more postings under the original subject line related to HTH than the OP (Original Post). * Please NOTE NEW Telephone Number * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8118 [EMAIL PROTECTED] 12:04:14 PM 09/14/2005 Hope that helps!(You can check out acronyms like that at http://www.ucc.ie/cgi-bin/acronym/acro.html) Susan - Original Message - From: Marilyn Hilb [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, September 14, 2005 11:00 AM Subject: RE: [U2]UD Login User Ok. I have to ask.. What does hth mean?? HTH, Jeff Fitzgerald Fitzgerald Long, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [Redback] multi-valued data displays strangely
Adrian. Using RBOScope, I don't think so. The RBOScope asp/uv/ud code Magically converts new lines characters into Value Marks, this is, as I believe also, useful when testing and have to enter multivalue data into a RBO property. Using a textbox outside of RBOScope does not exhibit (magically) this behaviour. I suppose you may be able to ScopeProps.asp to get the behaviour you are looking for. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 3:40:57 AM 07/14/2005 Using RBOScope for testing - if I press enter to get a new line in a text box and then call a validation routine which returns an error - the new line in the text box has magically transformed into a } character. When the data arrives in my universe subroutine the new line is a value-mark (which is fine by me). Is there a way to keep the new line as a new line instead of a } ? I've tried defining the field as a Field and later as a mvField in redback designer, and it made no difference. AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Spam/Virus?
Return Your IT badge to lady at the front desk, you're being phished. [EMAIL PROTECTED] 4:31:23 PM 06/03/2005 I just received an email from the admissions server at Hamilton College in New York. Any of you people on the list? It said my email account would be closed if I didn't fill out a form that was attached. Of course I didn't open it because I have nothing to do with Hamilton College. Anybody else receive this email? Sounds like a virus. Jerry Banker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Finding last day of month
* User Supplied ISO Date UserDate= '20040203' UserDateYear= UserDate[1,4] + 0 UserDateMonth = UserDate[5,2] + 0 UserDateDay = UserDate[7,2] + 0 * First Day Of The Next Month NextMonthYear = UserDateYear + (IF (UserDateMonth + 1) 12 THEN 1 ELSE 0) NextMonthMonth = (IF (UserDateMonth + 1) 12 THEN 1 ELSE (UserDateMonth+1)) NextMonthDay= 1 NextMonthIDate = ICONV(NextMonthMonth:/:NextMonthDay:/:NextMonthYear,D4/) *Subtract 1 day from the first day on the next month to get the last day of the month supplied UserDateIEOM = NextMonthIDate -1 UserDateEOM = OCONV(UserDateIEOM,'DY'):OCONV(OCONV(UserDateIEOM,DM),MR(%2)):OCONV(OCONV(UserDateIEOM,DD),MR(%2)) * PRINT 'NextMonthYear = ':NextMonthYear PRINT 'NextMonthMonth = ':NextMonthMonth PRINT 'NextMonthDay = ':NextMonthDay PRINT 'EOM Internal = ':UserDateIEOM PRINT 'EOM ISO Date = ':UserDateEOM * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 1:31:17 PM 06/02/2005 Hi, Given a date like 20040203, I want to return the last valid date for that month and year (20040229 in this case). What is the shortest code fragment to achieve this? At the moment I'm replacing the day with 01, then iconv, add 35 days to the internal date and then oconv and replace the day again with 01. I'm then on the first day of the next month. I then iconv, subtract 1 day and oconv. Thanks for any help. - Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] uniadmin without having to be in administrators group?
If you're on *nix platform you may be able to use SUDO ( http://www.sudo.ws/ ) that allows you to run certain commands as that may require root (or root-like access). I think many of the UVADMIN (or UDAMIN) commands require root or admin (WINDOWS) access to run O/S commands that require that access level. Then again it's almost Friday, and I don't want to overwork myself. =) Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 4:30:20 PM 05/05/2005 Your idea about UV administrator group is one that we have wanted on our UV/Linux server too. Too many of the UV admin tools require root priviledges on the Unix servers. UV should not require root or system administrator privileges, but the admin functions should be assignable to a group of users. I agree IBM needs to make this type of mod to Universe. Ken Hall At 11:32 AM 5/5/2005, you wrote: JayJay, Thanks for the reply. I guess my point is that we WANT to grant a user complete usage of ALL the functions within uniadmin. However, we specifically do not want them to be a windows system administrator in order to use the tool. And yes, its ok if this individual can stop and start UV services - just those 2 or 3 services that are IN the uniadmin tool. But we don't want them to control other aspects of the server that are inherent when you are in the administrator's group. It seems like there is a need to have a administrator maintained group code that can be associated with users that need to use the tool and the tool checks to make sure the user trying to use it is a member of said group. This would accomplish our objective without granting unnecessary priveleges. (this sounds like a mod request for IBM to implement for uniadmin) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Wednesday, May 04, 2005 3:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] uniadmin without having to be in administrators group? Troy This is not a good idea - you will be giving non-administrators the right to change Windows services.??? [snip] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Ken R. Hall Information Technology Manager Western States Electric, Inc. a Hughes Supply Company 9151 SE McBrod Street Portland, OR 97222 503-653-8619 fax: 503-653-2279 mailto:[EMAIL PROTECTED] www.wselectric.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Redback Startup
Or you can separate out the data layer from the presentation layer. Programmers - Respsonsible for Redback object properties (fields) and methods (databasic programs) REAL Web Designers - Responsible for website presentation. Redback allows web designers to be web designers and programmers, dba's, etc. to stay in their own little data world. My 2cents, Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 12:23:18 PM 02/18/2005 [Snipped..]' As a minimum you will need to know: Database programming (UniBasic or UniVerse Basic) HTML Active Server Pages VBScript You will also need to be confident designing and building web sites. RedBack is an enabling tool, not a site builder. That means you need all the attendant page design, validation and navigation skills (CSS, JavaScript and so forth). You also need to be able to write fast, efficient database code. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Conversion to Windoze % vs ? character
You cannot use ? in a filename on Windoze (Same as *) that you may have used on Unix. I know my FTP client switches any * in filenames (record id in a directory file) to @ when I ftp from UNIX to Windows. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 1:46:26 PM 02/17/2005 I'm attempting to convert a system using a uvbackup tape from hpux to windows. I've noticed that many cataloged items now have a name that ends in the % character wheras on the production system they end in a ? character. Is there something I'm missing here as far as a conversion command or something? Since I used uvbackup and uvrestore, I'm thinking that doing a fnuxi is not required. Any ideas? Thanks, Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniBasic CRLF over NFS mount
If you're using FTP to do the transfer from UNIX to DOS (which you say you are) then make the the FTP Transfer mode is ASCII, it usually defaults to BINARY (BIN). Most FTP clients will automatically convert CR to CRLF when transfering in ASCII mode. ASSIGN 1 to SYSTEM(1017) In Unidata the equivalent command for no conversion is NOCONVERT [ON | OFF] Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 7:37:01 PM 02/09/2005 There should be a ux2dos or unix2dos program in the operating system you can use to convert cr to crlf. Example: cat foo.txt| ux2dos new.txt ; mv new.txt foo.txt You can execute this statement from your basic program etc... -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Wed Feb 09 16:33:13 2005 Subject: [U2] UniBasic CRLF over NFS mount I'm building a flat file in UniBasic on a unix system, then writing it to an NFS mount point. The file attributes are interpreted as CRLF's when I ftp the file over to the windows system, but when I write or move the file over to the NFS mount, the attributes are only separated by unrecognizable characters (to notepad). The problem is, the version of the (BarTender) application I'm upgrading to, requires a CRLF before/after one of the attributes. Any suggestions/thoughts? TIA, Amy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UD] Using Environmental Variables in VOC...
It works on UNIX, however, you could have a program get the environment variable and write out the voc with the path information. UDTBIN_PATH = GETENV(UDTBIN) SAVEDLOG_PATH = UDTBIN_PATH:saved_logs VOC.REC= DIR VOC.REC2 = SAVEDLOG_PATH VOC.REC3 = D_BP It would seem unnecessary, but hey it's Friday and I'm leaving for the beach (bar). Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 3:30:06 PM 01/28/2005 How can I get this to work as I would like: I want to have a VOC entry called UDT_SAVED_LOGS 001: DIR 002: $UDTBIN\saved_logs 003: D_BP The Dict section doesn't matter, it just has to exist... And I would have thought the $UDTBIN would map correctly, but it does not (6.0.6, NT) -- Should it? Or is this one of those where each site would have to be hard-coded to the path?? My goal is an 'In-App' test of logs - things like Replication can die quietly..., and with no effect on the end user to warn them... I want to test the file for size and content and decide if I should raise a 'Red Alert' within the appication - I can hard code the path per site, but seems like enrvironmantals *should* work... David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UD] Using Environmental Variables in VOC...
For the benefit of the group (I emailed David offline). In windows it's the @ sign not $ sign for environment variables. ie. 002: @UDTBIN\saved_logs Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 3:30:06 PM 01/28/2005 How can I get this to work as I would like: I want to have a VOC entry called UDT_SAVED_LOGS 001: DIR 002: $UDTBIN\saved_logs 003: D_BP The Dict section doesn't matter, it just has to exist... And I would have thought the $UDTBIN would map correctly, but it does not (6.0.6, NT) -- Should it? Or is this one of those where each site would have to be hard-coded to the path?? My goal is an 'In-App' test of logs - things like Replication can die quietly..., and with no effect on the end user to warn them... I want to test the file for size and content and decide if I should raise a 'Red Alert' within the appication - I can hard code the path per site, but seems like enrvironmantals *should* work... David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Precision
Maybe they are paid semi-monthly (24 periods) rather than Bi-weekly (26 periods). -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 3:52:25 PM 11/30/2004 52/2 = 26 paychecks ? 2 * 12 = 24 paychecks where the 2 missing paychecks ? This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] XML Parse/Open/ReadXMLData
I'm having a problem with creating an extraction file in Unidata 6.0.9 on HPUX 11.11i. It's not writting to the correct attribute as defined by the dictionary item named in field. Simple XML Doc(test.xml): root node1Node1/node1 node2Node2/node2 node3Node3/node3 /root - Extraction Record (text.ext) ?xml version=1.0? U2XML_extraction file_extraction start=/root dictionary=TEST.FILE null=EMPTY/ !-- UD.NODE3 is attribute 1 -- field_extraction field = UDNODE1 path = node1/text() / !-- UDNODE3 is attribute 3 -- field_extraction field = UDNODE3path = node3/text() / /U2XML_extraction - Test Program *$BASICTYPE U SUBROUTINE B.TEST.XML OPEN '','TEST.FILE' TO F.TF ELSE RETURN * XML.FNAME = _XML_/test.xml EXT.FNAME = _XML_/TEST.EXT * STATUS = PREPAREXML(XML.FNAME,F_XML) IF NOT(STATUS) THEN STATUS = OPENXMLDATA(F_XML,EXT.FNAME,D_XML) IF NOT(STATUS) THEN MOREDATA = 1 LOOP WHILE (MOREDATA=1) DO STATUS = READXMLDATA(D_XML,THIS.REC) IF NOT(STATUS) THEN WRITE THIS.REC ON F.TF,'DON.XML' MOREDATA = 0 END ELSE MOREDATA = 0 STOP 'XML ERROR' END END REPEAT * STATUS = CLOSEXMLDATA(D_XML) STATUS = RELEASEXML(F_XML) END ELSE PRINT 'OPENXML ERROR' END END ELSE PRINT 'PREPARE ERROR' END - Results of Test record (DON.XML) written to TEST.FILE: 1 node1 2 node3 - Unidata appears to just be writing the data out sequentially rather than using the attribute number in the dictionary item. Any ideas? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Initialization Error
The Not a typewriter is indictative of the a term type not being set correctly or blank. On all our unix cron jobs a wrapper functions sets these enviroment variables since cron only sets a few enviroments by default. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 10:53:56 AM 11/19/2004 Wow. Have never seen this one. Though I am not certain how to resolve this, the error codes mean: 1: Unable to create a signature; the getid system call failed. 25: (ENOTTY) Not a typewriter. The file mentioned in an ioctl is not a terminal or one of the other devices to which these calls apply. Anyone have more? At 10:39 AM 11/19/2004, you wrote: I am receiving an error when trying to run a phantom: An error has occurred during uniVerse initialization Please contact the system administrator Error code: 1 25 I have not been able to find a listing of what the error codes translate to. Does anyone have an idea? Thanks, Bryan Haglund Haglund Consulting Inc. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] thoroughbred basic
Throughbred basic as far as I know isn't Pick. The last time I saw this was with a software package called Payplus. -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 11:27:22 AM 09/29/2004 Does anyone know the dbms this runs on Is it PICK based ? Bob __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Editors [TEXTPAD]
Speaking of Textpad. I use this. Does anyone have a syntax file for UD using Textpad? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 10:25:09 PM 09/23/2004 From: djordan [mailto:[EMAIL PROTECTED] I occasionaly need to edit a type 1 file of around 30-50 megabytes. The problem is most editors want to load the file into memory before working on it. Does anyone know an editor that would handle big files like this Emacs can handle 128MB files out of the box. Bigger with some tweaking. http://www.emacswiki.org/cgi-bin/wiki?EmacsFileSizeLimit Though you might have to buy more memory just to be able to run emacs :-) Textpad is a great windows editor (we have a site licence and install it on all systems). Claims to handle files up to the limits of virtual memory. I know I've edited some very large delimited files with it. It has nifty regular expression search and replace that makes stripping or adding funny characters easy. http://www.textpad.com/products/textpad/features.html Hth, Ian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RedBack # of responders configuration
A better resource may be: rbsolutions http://groups.yahoo.com/group/rbsolutions/ Don [EMAIL PROTECTED] 6:15:12 AM 09/24/2004 Hello there, I know this is the U2 mailing list and sorry for sending a RedBack related message but figured someone out there may have the answers. Recently, I've tweaked our production environment's rgwresp.ini to lower the # of responders (er UDT processes) eaten up by rgwsched. Is there any sort of rhyme or general rule behind defining a set number of responders and if so, what is it? TIA, Andy Pflueger Webmaster Ivy Hill Corp. Louisville, KY -- Sent using http://gmail.google.com/ :-P --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
OT: [U2] spammed
-- [EMAIL PROTECTED] 12:08:42 PM 09/21/2004 -- It's illegal to send UBE (unsolicited bulk e-mail) here in the states, but that doesn't stop people from finding loopholes in the FCC regs or spoofing source addresses and IPs. If the post office didn't track where mail came from/went, you could put any return address on an envelope and no one would ever know it wasn't accurate. Heck, you might still be able to do that in some cities. *-- The US post office doesn't track the return address on US mail, it tracks which post office it was processed in. You can put *anything* as the return address on a piece of mail. Look at the anthrax, mail fraud, and other cases. Considering one of my US credit card companies preprints *their* address as the return address on my payment remittance envelopes is proof enough that it's not illegal, it's widespread. -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC first query
I know this happens even with TELNET on Window Servers. It has something do with the first time it looks up a username in the doman and then it caches the the user tree (probably wrong term) of all the users. So each login after than does NOT have to retrieve a list of users. Does that make sense? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 We are using UVODBC to connect our web site to our production UV database and we also experience a FIRST CONNECT lag time. Subsequent queries are processed almost immediately. We have considered creating a routine on the server to periodically query UV so that any user would hopefully be the SECOND CONNECT. Garry Smith Dir. Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 CONFIDENCE NOTICE: This is an e-mail message, theretofore may have many accompanying documents, and is truly for the intended recipient(s) and heretofore may contain data and information. Surely any unauthorized review, use, disclosure, distribution or copying could become arum nauseous. If you are not the intended recipient, please look deep within yourself by any means and immediately forgo digesting the original message. -Original Message- From: Andy Moore [SMTP:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 3:42 AM To: [EMAIL PROTECTED] Subject: [U2] UVODBC first query We are using a report writer called Bi/Query with Universe via the UVODBC and have noticed that once connected to the database, the first query has a delay of about 20 seconds before it returns any results. Further queries after this time run immediately without the delay, but leaving the session without activity for about 5-10 minutes means that the next query again has a 20 second delay before returning any results. We have noticed this on many of our customer sites, has anyone else experienced this delay with the UVODBC or aware of what may cause this or how to fix it? Thanks Andy Moore Selima Software Ltd Tel: 0114 2815000 Fax: 0114 281 email: [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Pyramid HR
It's HRPyramind. We have use this since 1998 for our core inhouse payroll about (200-600 employees) and we used it briefly for our PEO business but we sold that division off. I have nothing but praise for the software and the company and it's well supported. It's put out by a company FW Davison. Website: www.fwdco.com If you would like to discuss offline please email or call me directly at the numbers in my signature. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 9:06:55 AM 08/05/2004 Has anyone worked on a package called Pyramid HR? It uses Unidata for its database. Any details would be appreciated. TIA Steve Kunzman Minneapolis, MN (612)750-3899 cellular --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
WebEX Recommendation was [U2] Univere Login Security
We use WebEx on our HPUX machines to allow HP techs in to help us with supporting our servers. I whole heartedly (sp.?) endorse it over netmeeting. -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 12:15:26 PM 08/04/2004 I recently had a sys admin try to get me to use webex instead of netmeeting. He said it works much better because it's browser based. www.webex.com says they are cross platform (HPUX, Linux etc). It's a full blown video-tel-white board conferencing application but from what I understand you could just use it as a telnet session. It's a web based version of Net Meeting which I've used as a virtual console. They offer a free-trial for 15 days, so if you are willing to be our guinea pig you can let us know if it works. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 12:45 PM To: u2-Users Subject: [U2] Univere Login Security Hi all, A buddy of mine wants me to be able to login to his computer on a routine basis to give him a hand with some development. Currently, he has a process that matches the ip address to the username and if it does not match, the user gets booted. The problem that I have is that my ip address is dynamic. Given the fact that this is a unix machine that I will be logging into, I assume that I cannot use a mac address or anything like that, Can someone out there give me a simple and effective solution for this? Thanks, Scott --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Database Hang
We had this problem but it was related to Vertias Replication software. Are you by chance running Vertias on HPUX? Sorry deleted the original post if that had the OS info in it. Don Verhagen Tandem Staffing Solutions, Inc. [EMAIL PROTECTED] 11:56:10 AM 06/21/2004 Ang Suan Yong wrote: Do anyone having experience on Universe Database hang. ( note that existing user process still able to run the process and access the database only user which using new session log to the database will hang over there ? Not UniVerse, but UniData was doing that to us intermittently. Nobody new could log in, but users who were already in didn't experience any problems. I don't think we ever figured out what the issue was, but we moved up to UD6 and it hasn't happened again. -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniBasic Performance Question
EQU V.SEC.SYNONYM TO COURSE.SECTIONS.REC.TABLEI.COURSE.SECTIONS,15 PRINT.VAR = V.SEC.SYNONYM verus PRINT.VAR = COURSE.SECTIONS.REC.TABLEI.COURSE.SECTIONS,15 I'm not sure but I think, in this case, elimating the EQUATE would be less keystrokes. Don [EMAIL PROTECTED] 4:03:24 PM 05/18/2004 Fawaz, No, it won't speed up your app. It will speed up your getting carpel tunnel syndrome. Equates are used for several purposes. In this case it looks as if they are being used to reduce the number of keystrokes the programmer will have to make. HTH, Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [snip] I have a UniBasic program with hundreds of equate statements like EQU V.SEC.SYNONYM TO COURSE.SECTIONS.REC.TABLEI.COURSE.SECTIONS,15 and only thing they do is assign it to a PRINT.VAR PRINT.VAR = V.SEC.SYNONYM: :.. I am planning to take off the equate and assign the variable directly to the PRINT.VAR PRINT.VAR = COURSE.SECTIONS.REC.TABLEI.COURSE.SECTIONS,15: :.. Will this speed up the process? Since we are passing the information to .NET with XML tags, any improvement to the speed is desirable. [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users