[U2] Wellington, New Zealand User Group
I have recently moved back to Wellington. Anyone interested in getting together informally or even formally to establish a user group around U2? You can email here or contact me directly if interested. Cheers, David Murray [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Record Locking Problems
Bill, The RECORDLOCKED returns a number of values, the value of 1 states that this user has a record lock, not another user. Try using an else on the case structure. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, May 07, 2008 11:00 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Record Locking Problems I am trying to make sure that if one Customer.Service rep is updating a Sales Order, then the other Cust.Svc rep is blocked from accessing the same record. The following code will indicates that the record is locked but when the 2nd user goes in (in an independent session), the second user gets in no problem. Since it does not seem to do what I think that it should, [1] I am wondering if I am missing something. [2] I am inclined to create a file to handle this (brute force) with multivalues for user, port, time, date, program, file, record. Comments would be appreciated. --Bill SUBROUTINE SUB.LOCK.SOH.R0 ( Record.ID, Error.Code ) prompt '' open 'SOH' to F.This.File else gosub Error.Opening.File gosub Lock.And.Hold goThe.End *--- -- *--- -- Lock.And.Hold: Lock.Test = recordlocked (F.This.File, Record.ID) crt '**11 Lock.Test ' : Lock.Test : ' [] ' input Ans begin case case Lock.Test = 0 ; recordlocku F.This.File, Record.ID case 1 ; gosub Error.Record.Locked end case Lock.Test = recordlocked (F.This.File, Record.ID) crt '**12 Lock.Test ' : Lock.Test : ' [] ' input Ans return *--- --- Error.Record.Locked: Lock.Test = recordlocked (F.This.File, Record.ID) crt '**13 Lock.Test ' : Lock.Test : ' [] ' input Ans Error.Code = 'E' crt @(-1) crt @(-5) crt crt crt crt crt crt crt crt crt crt '' : @(-6) crt crt ' ___ ' crt ' \ \ ' crt ' \ Error, Record Locked \' crt ' \__\Try Later ' crt ' ' crt ' ' crt ' [X] ' crt ' ' : input Ans, 1 Ans = upcase(Ans) begin case case Ans = 'X' ; null case 1 ; go Error.Record.Locked end case return *--- --- Error.Opening.File: crt @(-1) crt @(-5) crt crt crt crt crt crt crt crt crt crt crt crt ' Big Problem...' : @(-6) crt crt ' _ ' crt ' \\ SOH' crt ' \ Error Opening File \' crt ' \\Contact HK.IT ' crt ' [X] ' crt '' : input Ans, 1 Ans = upcase(Ans) begin case case Ans = 'X' ; null case 1 ; go Error.Opening.File end case return to The.End *--- --- The.End: RETURN END --- 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(VAR,DB)
Irina, I do not think that a ICONV conversion code of 'DB' is actually valid. 'DMB', DWB' etc for short codes for month and day respectively are OK. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 2:21 PM To: u2-users@listserver.u2ug.org Subject: re:[U2]ICONV(VAR,DB) Hey all, We are using ICONV(VAR,'DB') and it works perfectly except one case when the date is the last day of February any year. For instance for VAR=31-MAR-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR=14335 For VAR=28-FEB-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' In case VAR=29-FEB-2008 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' We tested it with STATUS() and in both cases it returns 0 which is considered as successful conversion. If we are using ICONV(VAR,'D') there is no problem in conversion to internal representation. Is anybody familiar with 'DB' conversion and what the difference between 'DB' and 'D' except the one we've already known it doesn't convert the last day of February? Irina Lissok. --- 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: [?? Probable Spam] RE: [U2]ICONV(VAR,DB)
Irina, Err, no. It is possible to include text within a ICONV or OCONV for formatting. So, the compiler is assuming that it valid format text. It is not in the manual, so I would state that it is not valid. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 4:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [?? Probable Spam] RE: [U2]ICONV(VAR,DB) David, It is possibly valid because it passed the compilation. If it will not pass the compilation we would know it is not valid and just do not consider this conversion. The point is that is probably legitimate conversion because it still works for other date conversion except the last day of February. Irina Lissok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Murray Sent: Wednesday, May 07, 2008 3:24 PM To: u2-users@listserver.u2ug.org Subject: [?? Probable Spam] RE: [U2]ICONV(VAR,DB) Irina, I do not think that a ICONV conversion code of 'DB' is actually valid. 'DMB', DWB' etc for short codes for month and day respectively are OK. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 2:21 PM To: u2-users@listserver.u2ug.org Subject: re:[U2]ICONV(VAR,DB) Hey all, We are using ICONV(VAR,'DB') and it works perfectly except one case when the date is the last day of February any year. For instance for VAR=31-MAR-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR=14335 For VAR=28-FEB-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' In case VAR=29-FEB-2008 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' We tested it with STATUS() and in both cases it returns 0 which is considered as successful conversion. If we are using ICONV(VAR,'D') there is no problem in conversion to internal representation. Is anybody familiar with 'DB' conversion and what the difference between 'DB' and 'D' except the one we've already known it doesn't convert the last day of February? Irina Lissok. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Guaranteed unique sequential keys
Marco, I have used similar processes in the past, but also have appended port number to the beginning of the key. Separating the fields with '*' so the date and time can also be used as a time stamp rather than duplicate the same info in the record. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: Thursday, April 24, 2008 5:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] Guaranteed unique sequential keys What is the most reliable way to generate unique sequential keys without having to resort to a record on disk updated through readu/write? The keys don't have to be contiguous but only be sortable in the order in which they were generated by several phantom processes running concurrently. I'm currently approximating this using a concatenation of date and time with millisecondsB but I'm worried about the possibility of two phantoms generating exactly the same key. B Although no collision has been detected so far, I have added an extra check where after generating the key I first test if a record with that key exists. If so IB increment and append aB serial number and repeat the test until aB unique key is found. ItB seems to be working well but I still think there is a better way to do this. B Thanks for any help. B Marco. __ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html --- 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] Indexes have disappeared
Louie, Within each file 'header' is a pointer to the index file. It is stored as a full path name (unless specified otherwise). If the account is moved and the file paths change, then the link/pointer to the index file will break (no longer point to the index file). The SET.INDEX enables you to reset the pointer/link back to the index file. For more info, see the latest UniVerse User Reference manual, pages 1-488 to 1-490. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Tuesday, April 22, 2008 7:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexes have disappeared We've never done a SET.INDEX, but the indexes used to work just fine. I wonder if they have to be set once and they work until the next upgrade? -- Louie --- 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] Downloading and Installing RHEL Desktop 5.1 From Scratch
Dave, Sounds like the ISO was not burned to the CD/DVD correctly. A ISO is a CD/DVD image file and has to be burned to a CD/DVD in a special way. Products like Nero do this. MS-Windows does not. Hope this helps, Cheers, David Murray RCHE * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Saturday, April 19, 2008 3:09 PM To: u2-users@listserver.u2ug.org Subject: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch Well, here it is Saturday morning and my long-anticipated weekend project of installing Universe on Linux has just come to a screeching halt. I downloaded RHEL 5.1 Desktop and burned the disk1 cd image to a CD-ROM using Windows XPPro. When I install the the CD-ROM on the new machine with only the CD-ROM drive designated as a bootable device, I get a message: Boot Error. System Halted. I tried to install it on my laptop and it failed to install there also. The CD-ROM drive read lite came on in both cases, so I believe that it's reading the CD-ROM but not finding what it expects to find. Using Explorer to view the download or the burned image, I see only one icon representing an unknown file type. I don't see any individual folders or files within the image. To fail this early in the process suggests that I'm doing something very wrong. Any suggestions? tia, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.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] Downloading and Installing RHEL Desktop 5.1 From Scratch
Dave, I use Nero. Most versions of Nero have the iso ability. The easiest way is to start Nero Express and then select the 'Image, Project, Copy' menu option. Then look for the 'Record a disk from disk image previously recorded onto hard drive' option. Then when prompted, navigate to the ISO (you may have to change the file type to see the ISO as Nero has a .nrg format by default) and way you go. If you want to purchase, I have found Nero to rather buggy and the latest release (Nero 8) is just bloatware that continuously aborts and breaks. Good luck. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Saturday, April 19, 2008 8:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch Larry, Bill, Allen, David, You all hit the bulls-eye. But, I'm running XP Pro 2002 SP2 and I can not find any mention of BURN CD or DVD Manager or CopyToDVD in the help section. I have old copies of both Nero and Roxio, but they do not mention iso type files. Since I need to purchase a current copy of either Nero or Roxio, do any of you have a preference between the two? Thanks again for your help, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, April 19, 2008 2:28 PM Subject: RE: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch Dave: I hate to suggest this but did you burn an ISO image with the proper XP burning software that does this properly? If not, then the drag'n drop won't read. So, on my machine I use CopyToDVD (I think) and open the DVD manager. I then drag'n drop the ISO image and the software puts it properly on my machine. Sorry if you've already done this. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Saturday, April 19, 2008 12:09 PM To: u2-users@listserver.u2ug.org Subject: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch Well, here it is Saturday morning and my long-anticipated weekend project of installing Universe on Linux has just come to a screeching halt. I downloaded RHEL 5.1 Desktop and burned the disk1 cd image to a CD-ROM using Windows XPPro. When I install the the CD-ROM on the new machine with only the CD-ROM drive designated as a bootable device, I get a message: Boot Error. System Halted. I tried to install it on my laptop and it failed to install there also. The CD-ROM drive read lite came on in both cases, so I believe that it's reading the CD-ROM but not finding what it expects to find. Using Explorer to view the download or the burned image, I see only one icon representing an unknown file type. I don't see any individual folders or files within the image. To fail this early in the process suggests that I'm doing something very wrong. Any suggestions? tia, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Reading data from an SQL Server Database from Universe
Harold, I did a similar exercise accessing MySQL from UniVerse. There are a few tricks, see : http://u2blog.org/2007/10/08/universe-odbc-to-mysql/ Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Monday, April 14, 2008 7:43 PM To: u2-users@listserver.u2ug.org Subject: [U2] Reading data from an SQL Server Database from Universe I am simply trying to read data from a SQL Server database into Universe. It's all supposed to be explained in the document BASIC SQL Client Interface Guide, but am missing one key point, it seems... One defines the ODBC data source in the uvodbc.config file. According to the documentation the only information one puts into this parameter file are data source name and dbms type. For example: mysqldb DBMSTYPE = ODBC are two lines in this file. This says the data source name is 'mysqldb' and it's an ODBC type of database. OKfine. That's it! For sources which are Universe databases, one also enters a service type and host. That makes sense. Well - the SQL Server database I am interested in reading is on another server. WHERE do I specify the name of the server and the database name? Is it even possible in Universe to connect to a SQL Server database on another server? Thanks for any help on this. Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- 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] Indexes
Dennis, Create a subr/function routine to open the REPAIRS file, use BSCAN to find the required records (using the passed STOCK code) and then DCOUNT the BSCAN result. You can then return this value. Create an ITYPE dictionary field (in STOCK file) which calls this routine, passing the required STOCK key/code. It would be a good idea to cache the file open using one of the methods which was discussed some months ago in this mail list. Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Friday, March 14, 2008 6:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] Indexes My dumb question for the day (just cant remember how to... and the manual's example is too simplistic...) How do I programmatically get an index value out, eg I have a STOCK file, and a REPAIRS file. Whoever designed this needs their head read, but the repairs file only has the stock code as a reference in the record. I have indexed the repair file on stock code, and need to create a report on the stock file of how many items are under repair. 1. UniverseBASIC code? 2. is this possible from an Itype? --- 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] Embed Dynamic Connect in a Browser
Ed, It is possible to embed Dynamic Connect as UniDebugger does it. As to how, I have never tried. Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Ed Sent: Wednesday, March 12, 2008 10:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Embed Dynamic Connect in a Browser A department here is purchasing a web-based application from XYZ company. The users need access to our UD app and don't want to switch back and forth. XYZ is willing to embed a Dynamic Connect window into their app (for a fee, of course) and they are asking me for advice. It looks like the wIntegrate API can do this? If anyone has done this with Dynamic Connect, then we won't need to purchase any wIntegrate licenses. We are running UniData 7.1 on top of AIX 5.3 and we are using Dynamic Connect. Thanks in advance. Ed Burwell Consultant Data Processing CASIO AMERICA, INC. 570 Mt. Pleasant Avenue Dover, NJ 07801 973-361-5400 x1512 email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.casio.com http://www.casio.com __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.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] blank lines in code / mixed case
Hi all, One of the sites I worked at has always had a string of contractors (short term and long term). One of the philosophies was to always make changes within a program in the same style of the original program, unless it is completely refactored (rewritten and replaced). If it was written in UPPER case, modify in UPPER case. Maybe the best situation is to petition IBM to make sure that different case styles will work within the editor, compiler and utility (SEARCH) programs. Then the issue is a matter for the user/developer/shop. But, with the introduction of eclipse this year from IBM as their preferred development environment for U2, this issue is NOT going away. Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, March 10, 2008 11:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] blank lines in code / mixed case I understand your point Brian. So what do we do with the situation where upper case is actually more readable to me and yet less readable to you? How do we rationalize such a dichotomy? -K --- 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] INCLUDE weirdo
Oh, the good old days... My first experience with computers was paper tape. Version control was performed with a pencil on the leader of the tape. I do miss the flashy lights though... Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Stokes Sent: Friday, March 07, 2008 3:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] INCLUDE weirdo We must remember that programming and computers in general has changed much since the beginning. How many remember punch cards. Can programmers today relate to a time when programmers submitted there code to be placed on punched cards? How about a half a day turnaround to see if your program compiled? And the fun task of reading core dumps. There are many factors to consider. --- 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] Excel downloads
Laure, How about XML? You can take the output of a LIST/SORT and add TOXML at the end to generate XML. Then print to a HOLD file (HOLD), pick it up and import into MS-Excel. MS-Excel will import XML in a number of forms, including as a sort-able list. It you setup a schema at both ends, then you should be able to get the exact format that you want. Getting info into MS-Excel has always been an issue - careful use of the XML in U2 and MS-Excel may hold the key... Mmmm, worthy of an article... Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Tuesday, February 12, 2008 7:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Excel downloads Hi Louie, You are correct, it does - however I am dealing among others with a set of files that contain about 85000 individual records: too much for Excel in the first place, and also, updating the MITS data source takes simply too much time, especially when adding break/sort fields. A simple Universe report using DET-SUP takes a couple of minutes to run. The equivalent using MITS Reports with a data source update to grab the latest data literally takes hours. So, I am looking for a solution that allows me to do the equivalent of a LIST DET-SUP in Universe, and convert the output into true Excel. Thanks, Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Tuesday, February 12, 2008 3:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Excel downloads Laure, MITS Reports does export detail-suppressed information to an Excel spreadsheet. Just - click on column heading, then - click Display Totals, then - add a break on the field you want totaled. - click the Suppress Details tab - export to Excel Louie Bergsagel North Coast Electric --- 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] Excel downloads
Laurie, For simple totals, it is possible to add an EXCEL formula into a cell by starting the cell/formula with an '=' sign. This also works with CSV structured files, which EXCEL will load and convert on the fly. Create a virtual/correlative field which will simply output the formula as text and add it to the CSV file e.g. =SUM(An). Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Tuesday, February 12, 2008 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Excel downloads Hello, We are looking for a simple way to drop aggregate totals type reports out of Universe into Excel. Our users are using AccuTerm and we also have MITS Reports installed. But, neither one does the trick for summarized reports that use the DET-SUP option. Having the detail and forcing the users to do their own grouping/sub-totals in Excel is simply not an acceptable option here. UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be happy to develop a simple (key word...) VB.Net executable that works smoothly regardless of the version of Excel, as our users work on anything from Office 2000 and above. Any suggestions welcome. TIA, Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- 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] U2 SOAP Server for Linux
Sara, As the soap server is part of the U2 client package, I thought that it is not available for Linux yet. There were murmurs at the U2 University that it was under consideration. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Tuesday, February 05, 2008 4:38 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 SOAP Server for Linux Can anyone tell me where we can find the software for the Linux version of the U2 SOAP Server. We have looked on the IBM web site but cannot find this software to download. We have the Windows version but want to run this on Linux. Any assistance will be very much appreciated. Sara Burns IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- 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 20.1 itype perf enhancer
Hi all, UniVerse and SB+ also have this technique built in. UniVerse is via the OPEN.FILE.B in the APP.PROGS file (uv account) and SB+ via the SB.FILEVAR.S subroutine. I had written an article regarding the UniVerse routines: http://u2blog.org/2007/11/05/appprogs-open-tools/ Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Thursday, January 24, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe 20.1 itype perf enhancer Hi John, As you surmised, this is not a new trick. Here is my version: SUBROUTINE OPEN.FILE.SUB(FILENAME,FILEVAR,ERROR) * open filename to filevar, keep opened files in named common * 01-20-01 asb COMMON /OPEN.FILE.SUB/ FILENAMES,FILEVARS(1000) IF ASSIGNED(FILENAMES) ELSE FILENAMES = END ERROR = LOCATE(FILENAME,FILENAMES;POS) THEN FILEVAR = FILEVARS(POS) END ELSE OPEN FILENAME TO FILEVAR THEN IF POS LE 1000 THEN FILENAMESPOS = FILENAME FILEVARS(POS) = FILEVAR END END ELSE FILEVAR = ERROR = 1 CRT @(0):ERROR! can't open :FILENAME:@(-4) END END RETURN In use, you CALL OPEN.FILE.SUB(MYFILE,FILEVAR,ERR) ; IF ERR THEN Interestingly, on D3 this does not seem to have much benefit, where the OPEN function seems faster than the LOCATE. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Jan 24, 2008 6:56 AM, john reid [EMAIL PROTECTED] wrote: I just saw this today, and although i am certain that everyone must know it already, i am including it. For itypes that call subroutines, where the subroutines open lots of files, put a named common in the subroutine that contains what amounts to dimensioned arrays that hold the file vars. Put a switch in so that the files are opened only once. Anecdotally, this appears to work more efficiently than not having the common. If there are reasons why this is ill-advised, I'd like to see that as well. thanks. John COMMON /SETUP.STUFF/MY.FILES(15),FIRST.IN.SWITCH -- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Problem installing System Builder PE
Bob, Try removing the 'c' from the option list. See - http://u2blog.org/2007/10/01/universe-on-linux/ Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Little Sent: Thursday, January 17, 2008 3:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Problem installing System Builder PE Ibm trying to install SB 5.4.1 PE on Fedora 8 and Ibm getting an error: sh-3.2# cpio -icvBdum pe_sb541_uv_cpio cpio: premature end of file Does anybody know what I can do to get this thing installed? I though perhaps the file was corrupted so I re-downloaded and tried it again and received the same error. Bob Little UniVerse Developer Market America 336-478-1694 --- 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] accessing U2 with PHP
Charles, Brian I am just as we speak (mail-list?) doing some work with php within UniVerse for the reason of web services and web page scraping. Check out http://u2blog.org/2008/01/10/php-in-universe/ Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Saturday, January 12, 2008 6:09 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] accessing U2 with PHP Charles PHP has good support for Web Services, so you could surface some UDT functionality that way. There was also an article on DeveloperWorks on creating a custom PHP module that exposed some of the InterCall library, though it was a long way from a complete solution. I also dimly remember someone writing an article on using a java bridge to expose either RedBack objects or UOJ to PHP. Some time ago I asked IBM whether they would be willing to publish the UniObjects protocol so that third parties could write clients for those environments it doesn't support, like PHP - but that wasn't too well received and I didn't follow up on it. Instead, I wrote a web services library (before IBM released theirs) and tested that through with PHP's SOAP support. Regards Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 11 January 2008 21:13 To: u2-users@listserver.u2ug.org Subject: [U2] accessing U2 with PHP Does anyone know of any PHP classes that allow access to Unidata data? Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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] -UV- HTTP secure logins
Karl, Yes, and it does not actually cost you anything (open source), but it is another 3rd party product. I had a similar problem some years ago. For password handling, which can end up being a cookie issue, I used curl - http://curl.haxx.se/. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 19, 2007 10:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] -UV- HTTP secure logins [skip to paragraph 4 for the question] Our business application is a green screen legacy app. We have no desire to change. It's not broken and doesn't need to be fixed. We enhance it with 2 developers and a consultant, who we bought the system from some decades ago. I've finally figured out that I don't need http:// on the front of the createRequest URL. That was breaking everything for my earlier attempts which were in 2005. Now it's much later than that, and my boss, the C.O.O. asked if I could figure out a way to retrieve some information off our primary vendor's website and put it up on a sales screen. Done and folks are thinking I walk on water. Now for the tough part, which I seem to remember someone mentioning recently, but since it wasn't on my plate yet, I didn't pay much attention... (Isn't that like keeping something for years, then deciding to throw it away, just to need it a few days after?) Is there a way to access a web page that requires a login and password and then retrieve data from another page behind the login page? Please say yes (without lying and without the need for me to purchase a third party product). TIA -- 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/
RE: [U2]U2 Postion Available
It would be nice if IBM setup a 'Cert Central' similar to what RedHat have for their certified RHCE,RHCT, RHCA etc. for people and consultants who have done the exams. See https://www.redhat.com/training/certification/ for a list of what RedHat offers. It could also be one way to solve the access to support resolutions issue that was discussed some months back. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Alparone Sent: Wednesday, October 03, 2007 1:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]U2 Postion Available Does anyone have any idea of where one might find a list of companies that use Multivalue products. I would like to send a resume. Robert Alparone -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 12:21 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; 'u2-users@listserver.u2ug.org' Subject: Re: [U2]U2 Postion Available Dave, Any thing going on in the St. Louis area? Charles Shaffer Senior Analyst NTN-Bower Corporation Dave Walker [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/03/2007 10:10 AM Please respond to u2-users To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org cc: Subject:[U2]U2 Postion Available Ivy Hill Packaging, in Louisville, KY, has an opening for a Unidata/PRIMAC Developer Consultant. We'd like: - 5+ Years of Unidata programming and database experience - Preferable (but not mandatory) PRIMAC Application Experience - Prefer hours to be worked onsite, but willing to work a flexible schedule for the right consultant - 1 to 3 months for initial assignment. 40+ Hours a week Contact me at [EMAIL PROTECTED], and I'll forward to the powers-that-be. You may also send snail mail/risumi to: Ivy Hill Packaging Attn: IT Dept. 4325 Shepherdsville Rd. Louisville, Ky 40218-0640 Thanks, -- Dave Walker Programmer/Analyst Ivy Hill - Louisville (502) 473-2811 *IBM Certified Solutions Expert *U2 Family Application Development --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [SBS] Usage of a semicolon in a string within a paragraph
Hi all, I was wondering if anyone else has experienced this weird issue: UniVerse PE 10.2.0 on Linux, Pick Format account SB+ Server PE 5.4.1.4022 In a Paragraph: EQUATE SEMICOLON TO ; Will not save (F2) and returns an 'error in expression' Also: @VALUE = ; Returns the same error. Actually, any expression which includes a semicolon as a ; (double quotes) or a ';' (single quotes) is an error. I cannot remember ever coming across this error before in previous versions of SB+ Server. I actually cannot remember if I ever wanted a semicolon as a string before either. Cheers, David Murray --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe PE - Fail to install
Sara, Hi. I have had a similar problem when the security of the user has been restricted. It was a 'standard' user with weird policy changes to limit disk/directory changes and some application installs. There are also two IBM support issues dated 2004/07/22 regarding something similar with Windows NT/2000: quote During a UniVerse install on Windows NT/2000 at about 80% completion, the install may abort with the message: Could not load universe.dll c:\ibm\uv\bin\universe.dll. Unhandled exception 0x80040702 description, failed to load dll:universe - setup will now terminate. /quote If someone in the list has complete access to the IBM support could add further details... Have you thought of using a virtual os/application install on the desktop? It can be tidier and easier to manage, in particular by setting up a standard Universe install/setup, including any applications for learning on. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Thursday, September 27, 2007 7:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe PE - Fail to install I was trying to use the excellent tutorial written by Brian Leach to introduce a new staff member to the world of UniVerse. When I tried to install the PE version of UniVerse on her PC it failed to Register the universe.dll and terminated the install. I then tried it on my own PC with the same effect. Both these PCs are newly built with an Intel dual core CPU. This seemed to be a possible common denominator as we tried the same zip file on a slightly older single core CPU and had no problem. All these PCs are running XP with SP2. Does anyone know if the PE version is not available for dual core or is this likely to be something else we have done. Any suggestions welcomed. For the record this tutorial is an excellent introduction to UniVerse. Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- 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] SBClient - vt220 CHAR mode - How to colors ?
Manu, What terminal definition have you setup within SB+ for the user/port? Definition VT220 in SB+ does not support colour. Definition TU.VT220 does support colour. You may have to tweak one of the existing SB+ terminal definitions to get the correct functionality required. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: Thursday, September 20, 2007 4:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ? Hi all, I've a project to convert a old PICK basic application to Universe/NT. I want to use SBClient in character mode, with vt220 terminal emulation. (We build new modules with SB+.) In BASIC, I convert colors sequences like background black from @(-40) to @(-38,0) and so on for all colors. But SBClient don't display any colors Is there someone with experience or any advice Thanks. Manu --- 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] SBClient - vt220 CHAR mode - How to colors ?
Manu, OKies, There is an ANSI colour/color option within the SBClient VT220 configuration: Menus - SetupTerminalEmulation: VT200Configure buttonANSI Color tick box Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: Thursday, September 20, 2007 12:23 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ? Hi, Precision, I do'nt login into SB+, I do'nt use it ! I'll use SBClient like a character based term emulator without SB+. SB+ interface is the next step ~future not defined. Thanks for help Manu - Original Message - From: David Murray [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, September 20, 2007 1:19 PM Subject: RE: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ? Manu, What terminal definition have you setup within SB+ for the user/port? Definition VT220 in SB+ does not support colour. Definition TU.VT220 does support colour. You may have to tweak one of the existing SB+ terminal definitions to get the correct functionality required. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: Thursday, September 20, 2007 4:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ? Hi all, I've a project to convert a old PICK basic application to Universe/NT. I want to use SBClient in character mode, with vt220 terminal emulation. (We build new modules with SB+.) In BASIC, I convert colors sequences like background black from @(-40) to @(-38,0) and so on for all colors. But SBClient don't display any colors Is there someone with experience or any advice Thanks. Manu --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to use LOCATE in an I Descriptor
Doug, The latest UniVerse U2 System Description Chapter 5 - page 5-29 lists all the UniBasic functions that can be used directly within an I-Type. LOCATE does not seem to be listed. You could create a small UniBasic using a LOCATE to simulate one within an I-Type. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Thursday, August 09, 2007 2:44 PM To: u2-users@listserver.u2ug.org Cc: Vicki Gabler Subject: [U2] How to use LOCATE in an I Descriptor I have someone asking me how to use a LOCATE statement in an I Descriptor. I have never done that and would not know if it is possible, or what the syntax is. Does anyone know if you can do this, and what the syntax would be to use the resultant location? Thanks Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software 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] UniData 7.1 vs. MS SQL 2005 performance
The IBM U2 products are marketed as 'High performance, scalable information management environments for embedding in vertical applications.' See http://www-306.ibm.com/software/data/dbservers.html IBM has a large reseller or value-added partnerships which they wish to preserve. One of the side-effects is the 'ownership' of a client; it is the resellers not IBM's. One way to manage this is to provide access to the knowledgebase only to the resellers and software houses, as they generate sales and also manage the database problems as it is the application which is being sold, not the database. This is a problem for in-house software development and orphans from software house collapses. This has always been a problem as long as I can remember - 15 years or more. And it is the reason that I would never recommend in-house software development with any U2 products. You will always be flying blind. There was some chat some months back about creating a free virtual image of U2 with some supplied software etc. etc. It must always be remembered that U2 is not open-source or a community built product. It is a proprietary database product owned and developed by IBM. If IBM do not and will not recognize the in-house development and consultant markets, then move on. There are massively larger databases and more in number using MySQL, Oracle and MS-SQL. Other developers seem to be able to use these products and produce reasonable applications. On the other hand, I have found that I can produce and manage a U2 database simpler and cheaper than others; but not because of the MV factor. It is the ability to write complex business rules and processes directly in the one environment (with the database structure) that I find invaluable. But alias, as the increase of BPEL and such high-end tools come available for other database products, even this feature of U2 is starting to wear thin. My $1.22 + tax input. Cheers, David Murray P.S. The direct relationship between BPEL and SB+ is so similar that it is scary, but no development by IBM of BPEL on U2 seems to be on the cards. .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nancy Fisher Sent: Wednesday, July 18, 2007 12:03 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance Why doesn't IBM allow access to all information that would help users - we've already bought the product? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] KB access - with var permission
Marc, While I was contracting to an organization in New Zealand whom had developed an in-house Universe application with SB+, I was able to get access to the IBM knowledge base with permission of the VAR. It was complicated and it took the VAR three sessions on the phone with me before access was eventually working. It was a mine of information and I immediately solved 6 nagging bugs. From memory, you access the knowledgebase as a sub-agent of the VAR, so the VAR has to provide multiple levels of access using their own access codes initially. It is possible, yes. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Wednesday, July 18, 2007 1:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] KB access - with var permission Does anyone have a known process that works for getting this access setup? I've been round and round on this access, and my var does not know what else to do. The var has no issue granting the access - but IBM has made it SO complicated that apparently it takes a rocket scientist to figure it out. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, July 18, 2007 12:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance Nancy this was discussed in the past at great length! To summarize: When the U2UG was formed, we petitioned for IBM to open up their knowledge sources. The problem is their vars, some of whom do not want their users to get access (and presumably show up how p*ss p**r their support may be). So a compromise was reached - if the var agrees, you can get access. Of course, some vars won't - but then you could always buy a single user UV from a sensible and capable var who will. that's probably worth the cost of the material anyway. it's also one of the reasons we started the U2UG knowledge base - and we're about to launch a Wiki on the same site. Brian --- 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 7.1 vs. MS SQL 2005 performance
Jerry, Do you have currently have access to the knowledgebase? It is possible (as I have had access before), but access by an end-user seems to be the exception rather the norm. Is anyone from IBM in this mail list want to comment? Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, July 18, 2007 2:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance So what you are saying is that a shop like ours that has over the years developed everything in-house and the applications are specifically geared to our business and can be changed as our business changes is out of luck when it comes to getting into the knowledgebase. Just because we don't buy an application from anyone we are excluded from something that might help us build it better and faster. -Original Message- From: David Murray [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 1:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance And it is the reason that I would never recommend in-house software development with any U2 products. You will always be flying blind. --- 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 7.1 vs. MS SQL 2005 performance
Bill, I am sorry if what I stated was inappropriate. I was replying to a comment about the lack of access to the IBM U2 knowledgebase and other privileged/restricted information to end-user in-house developers. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, July 18, 2007 3:43 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Ditto... Almost everybody using U2 is doing in-house software development. We are the opposite of blind because we can see all of the source code that we write. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker Sent: Wednesday, July 18, 2007 2:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance So what you are saying is that a shop like ours that has over the years developed everything in-house and the applications are specifically geared to our business and can be changed as our business changes is out of luck when it comes to getting into the knowledgebase. Just because we don't buy an application from anyone we are excluded from something that might help us build it better and faster. -Original Message- From: David Murray [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 1:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance And it is the reason that I would never recommend in-house software development with any U2 products. You will always be flying blind. --- 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] New UV system
Wol, One reason for using uvbackup is that the index file path names within UV are hard coded and I have had interesting issues when not using uvbackup to move work directory/accounts around between machines. Also, it gets rather tedious setting up the many VOC entries for the OS files again. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, June 13, 2007 12:05 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] New UV system Why do you need uvbackup? I'm NOT recommending that you don't use it, but a while ago I had a linux box, a SCO box, and a Windows box, and quite happily copied UV files between all three of them using the OS-level copy command. Bearing in mind they all run on Intel chips, and byte order is a chip problem NOT an OS problem, you shouldn't have problems just copying the os-level directories around. DO play and test before you do anything for live, though! Cheers, Wol -Original Message- From: Manu Fernandes [mailto:[EMAIL PROTECTED] Sent: 13 June 2007 15:46 To: u2-users@listserver.u2ug.org Subject: Re: [U2] New UV system Hi, You can run a 5 users of uv on a lite box (I do it on a notebook) Use W2003 server (W2003 is more demanding in ressource like UV, it can run on XP too ). To switch from sco to windows, you must use *uvbackup* tool into sco to prepare a file, then copy these file to windows and use *uvrestore* to restore the datas. (problem with special chars on unix vs windows)) There is a trouble with Type1 file, convert it to Type19 before copy. Under Windows, you must upgrade all your VOC entry where there is OS full path (check your datas eventually) I hope this help. Manu - Original Message - From: MAJ Programming [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, June 13, 2007 3:17 PM Subject: [U2] New UV system All: I have a client running UV on SCO on a 486/Pentium-1 looking box. They would like to move everything to a contemporary box. While I don't create systems, I would like some suggestions on which kind of W2000-class server to hold a 5 user version of UV. I don't want to switch databases to UD or D3 etc as the $ isn't there for the conversion (me). Unless absolutely imperative, I do not want a unix-based system. I would also be in the market for some phone-based assistance on the backup as it's done through an automated process in the UV app and I'm not that familiar with UV/UD backups or restores. One thing I would like would be to resize (down) most of the data files. I think it is a dds4 tape. I'm even game for a gently-used smaller system. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Incubator - News from the board
The basic 'Direct Connect' terminal emulator is bundled with the U2 windows client package. What would be nice is SBClient to be bundled, so the capabilities of SB+ can be demonstrated. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 10, 2007 11:04 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Incubator - News from the board Is there a possibility of adding a Terminal emulator? Accuterm for instance? Bruce M Neylon Health Care Management Group Charles Barouch [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/09/2007 11:39 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] Incubator - News from the board All, The U2UG board has been discussing the 'incubator plan' and we will soon be presenting a draft proposal to membership. Here's what we are discussing in broad brushstrokes - all feedback appreciated. We want an *easy* *legal* way to get PE editions into the hands of business people, college students, entrepreneurs, and other market expanders. More than that, we need to get people a version of the PE software which is chock full of examples, training materials, and useful information. Here's what we have in mind: We want to build an installer which pulls the PE editions from the IBM website (allowing the user to sign the IBM agreement), pulls Learner Packs from the U2UG website (allowing the user to sign the U2UG agreement - designed to protect the content all of you will - hopefully - contribute). Finally, the installer will bootstrap the Learner Packs into the PE installation, so the accounts, files, and programs, etc. are all in place. The end result will be a full install, with URLs to get them to the U2UG and other key locations. It will allow people to see our technology in the best light possible. Opinions? Flames? Offers to Help? Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- 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] Incubator - News from the board
What about a fully installed, configured and ready to run VMWare image of U2 on linux? VWmare now have a free runtime/player and there are already a number of linux and such images available under their 'Virtual Appliances Marketplace' - http://www.vmware.com/vmtn/appliances/ All that has to be installed then is the vmware player on a MS-Windows platform. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Thursday, May 10, 2007 3:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Incubator - News from the board Well, for distribution - this would need to be Linux - as I doubt Microsoft will grant re-dist rights on Win32. IBM seems to support Linux... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 10, 2007 1:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Incubator - News from the board It strikes me that one good way to deliver this would be using VMware or some other similar virtualisation technology that can be run in a free player (VMware Player) on any Windows or Linux operating system. This would make the install easy and all the databases and documentation etc. could be pre-installed. --- 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] Incubator - News from the board
I was assuming that IBM would do this. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, May 10, 2007 5:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Incubator - News from the board But you can't do that due to the IBM License on the PE version - the end user *must* navigate through that license during the installation was my understanding. They HAVE to pull the PE from the IBM site directly. Meaning, no way to build ready-to-run PE Virtual Machines DW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Normandin, Jerry Sent: Thursday, May 10, 2007 3:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Incubator - News from the board Sounds like a great Idea! I'm willing to put together a tuned cookie cutter vmplayer image. This will yield a usable demo that can run on windows and linux. ... as the guiness commercial goes... A VM of U2 on Linux, BRILLIANT! Jerry Normandin | System Level II Intuit Eclipse Distribution Management Solutions 75 Perseverance Way Hyannis, MA 02601 T 508.778.9151 Ext. 1245 F 508.778.6443 www.eclipse.intuit.com [EMAIL PROTECTED] *This e-mail message is intended for the named recipient(s) above only, and may contain information that is confidential and/or privileged. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this e-mail and any attachment(s) thereto is prohibited. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Murray Sent: Thursday, May 10, 2007 4:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Incubator - News from the board What about a fully installed, configured and ready to run VMWare image of U2 on linux? VWmare now have a free runtime/player and there are already a number of linux and such images available under their 'Virtual Appliances Marketplace' - http://www.vmware.com/vmtn/appliances/ All that has to be installed then is the vmware player on a MS-Windows platform. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Thursday, May 10, 2007 3:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Incubator - News from the board Well, for distribution - this would need to be Linux - as I doubt Microsoft will grant re-dist rights on Win32. IBM seems to support Linux... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 10, 2007 1:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Incubator - News from the board It strikes me that one good way to deliver this would be using VMware or some other similar virtualisation technology that can be run in a free player (VMware Player) on any Windows or Linux operating system. This would make the install easy and all the databases and documentation etc. could be pre-installed. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -ve INDEX,OCONV
Sanjeeb, The D2/ is a conversion code and specifies a date with 2 digits in the year and to use '/' as delimiters e.g. 03/19/07 rather than 03/19/2007 (D4/). You can get a list of conversion codes at ECL: HELP CONV And the manuals cover conversion codes in significant depth. Cheers, dAVID mURRAY - case sensitive? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Monday, March 19, 2007 9:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] -ve INDEX,OCONV
Sanjeeb, A -1 used in a dynamic array means to append to the end of the array. See HELP at ECL: HELP BASIC ARRAY.VARIABLES, HELP BASIC DYAMNIC.ARRAY.OPERATIONS, HELP BASIC REUSE(), and HELP BASIC INSERT. There are some differences how -1 is used between U2 account flavours. This is explained in some detail in the HELP BASIC INSERT online help. Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Monday, March 19, 2007 9:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] -ve INDEX,OCONV Hi, What does a negative index mean in an array .If LIST-1=ID is a segment of the code what does this -ve number mean is it by default the first element. If we do a external conversion usng OCONV(sysdate,'D2/'),the D indicates the date conversion specification but why is the 2/ being used here...what can be the change in the conversion? Thanks Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] SQL SUM Function
Marinko, The U2 database is an integer only system, when it comes to using the inbuilt calculations. Numbers should be normalized using the input and output conversions. For instance, money is stored as total number of cents rather than dollars. The conversion code of MD22 will shift the decimal point two places to the left during display. Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Babic Marinko Sent: Thursday, March 15, 2007 8:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] SQL SUM Function Hello I have a single value field EX.NUMBER with the following values: KeyEX.NUMBER A 123.45 B 567.89 C 987.65 The result of the following SQL Statement using BCI (UniVerse BASIC SQL Client Interface) is SELECT SUM(EX.NUMBER) FROM YYEXAMPLE USING DICT DYYEXAMPLE; Result: 1679 The result should be 1678.99. The statement PRECISION 4 does not affect the result. Any idea? Kind regards, Marinko --- 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] CALL @progname
David, @CALL's are very inefficient and slow. It would be worth doing a speed test. Also, it might be prudent to have significant control over an external process calling an internal one. This is the source of many a virus on MS-Windows. I have used a CASE statement to check a variable and call the appropriate routine. This way, only processes which have been tested and approved can be called by the external process. Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, March 15, 2007 11:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] CALL @progname I am writing some code that will execute a variable passed in progname using CALL @progname. Question - what is the 'best' way to know that progname exists before I attempt the CALL. I thought about reading the VOC, but if it's globally cataloged, that won't work. I could read the VOC and then the CTLGTB -- but that was two reads just to 'know' the routine wasn't going to blow up. Is there a more efficient or systemic way to do this? **Typically** progname will reference a real program, so this testing is 'overhead' for 99.9% of the time - but if someone were to pass in a bad 'progname', I want to be more graceful (and secure!) just falling over. Since some of the calls will come from 'web connected' clients, and some of the clients may not know for sure that the host cannot handle the request - if the client has a different function list than the host at that point and time... I'm just trying to plan for 'worst case'. How do others handle CALL @ --- 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] CALL @progname
David, The HELP BASIC CALL help info explains how the CALL and CALL@ work. The variable setting should be included in the loop as it is a valid part of the CALL@ setup. Setting the variable will 'trigger' the CALL@ to find the program again. It is more of a real-life situation than setting the variable out of the loop. Nevertheless, it is interesting results, as CALL@ used to be rather slow. But debugging will be very stressful with [EMAIL PROTECTED] As a side note, I am finding similar zero-speed differences between dynamic and static array usages in large array's. The internals of U2 must be getting more interesting... Cheers, David Murray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, March 15, 2007 1:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] CALL @progname Actually - I just ran a test, and was surprised somewhat: 1,000,000 Iterations of ways to do a call... CALL PROGNAME (direct)7047 CALL *PROGNAME (global)7766 CALL @PROGNAME (indirect) 6984 GOSUB (logic contained in-line)1531 Call as Function 10203 I've rearranged the order the routines are called in, and run the test suite over and over... The Indirect calls are CLEARLY faster, with all numbers moving +/- 50, EXCEPT the indirect, which only moved +/- 25 or so. Note that I set the @PROGNAME outside of the call loop - this was not testing how fast the system could set variables - just the difference on the 'calls'. If I include the setting of the name WITHIN the loop, the indirect call went to 7290 or so -- the difference in the 'direct' call vs the 'indirect' call efficiency appears to be in the Variable handling! But both are still faster than use of Global catalogs. Anyone have a clue why the indirects are a hair faster? Or am I just getting lucky over and over? I always thought they were slower as well! DW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Murray Sent: Thursday, March 15, 2007 11:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] CALL @progname David, @CALL's are very inefficient and slow. It would be worth doing a speed test. --- 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/
