Re: [U2] Re: ODBC Connection Hanging Around
Kevin, It sounds as though the server is seeing the disconnects, but the client is not getting the response back to recognize that it is truly disconnected. Therefore the object is waiting on a response. I am not sure if the driver is thread safe, but I would not count on it. I might suggest putting all your communications code in a separate module and subroutine. Also don't wait on the response since it seems like the closing is actually happening. Make all the object variables local to that module/subroutine so that when that routine exits they will fall out of scope and should get cleaned up. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Record Locking Problems
I assume that the SUB.LOCKED.SOH.RO is called to do the lock and then returns. The problem is that you open the file in this routine to do the locking against. Once this subroutine ends that file handle will go out of scope (it was defined local to this subroutine) and the file is closed. That releases the lock. The best way would be to pass in an open file handle. If that is not possible for some reason then open the file to a variable defined in named common and test to see if it is already open using FILEINFO() before attempting to do the open. such as: COMMON /MY.FILE.HANDLES/ F.THIS.FILE IF FILEINFO(F.THIS.FILE,0) = 0 THEN OPEN . END I would prefer passing in the open file handle myself if possible. Named common is very useful, but care needs to be taken in it's use. For example the common memory defined is associated to the process and not the account. Therefore if you logto another account without first exiting U2 the file handle would still be open, BUT pointed at the file in the account where it was opened. You would need to have logic in the logins to test for this or add additional checks (using FILEINFO again for the path where the file is located) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 Brutzman, Bill [EMAIL PROTECTED] ft.comTo Sent by: 'u2-users@listserver.u2ug.org' [EMAIL PROTECTED] u2-users@listserver.u2ug.org stserver.u2ug.org cc Subject 05/07/2008 12:02 [U2] Record Locking Problems PM Please respond to [EMAIL PROTECTED] er.u2ug.org 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 '
[U2] Richard Taylor/VERTIS is on vacation
I will be out of the office starting 03/18/2008 and will not return until 03/27/2008. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting Tue 07/17/2007 and will not return until Mon 11/26/2007. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] I descriptor help
Jim, You have two choices: First you can pass in @RECORDxx where xx is the attribute number you want to work on. The other way is to not pass anything at all. The Global UV variables @RECORD and @MV are available in your program too. You could reference them directly. Of course this would make your routine less flexible if that is a consideration here. In either case remember that in UV you are dealing with the entire Multivalued field not just one value mark position. If your intent is to create data that is a correlated multivalue also then you must pass back a multi-valued field not a single value. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 Jim Koca [EMAIL PROTECTED] t To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] [UV] I descriptor help 10/02/2007 03:11 PM Please respond to [EMAIL PROTECTED] er.u2ug.org I need to call a basic subroutine to process a field. The field in the record is a multivalued field. How do I pass that field to the called subroutine ? The field is PARTNO which is defined as a MV field. I want to call a subroutine such as SUBR('ZGET.PCODE',@RECORD,@MV). I have them associated in the same PH record. Jim Koca --- 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] Changing ownership of an SQL Schema
We have a number of ODBC schemas setup in Unidata. Some have been around for quite awhile and the person who created them is no longer around. What is the methodology to change the documented ownership of these schemas? Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Why does the IF statement think these values are different?
You don't indicate whether this is Unidata or Universe or the flavor you are running in. However one suggestion I can make is to enclose your calculations in parenthesis to insure that operator precedence is not your problem. IF (INTREC+PRNREC) # (INTPAY+PRNPAY) THEN Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Ferries [EMAIL PROTECTED] Sent: Monday, November 06, 2006 10:14 AM To: u2-users@listserver.u2ug.org Subject: [U2] Why does the IF statement think these values are different? HI All, I don't understand why the IF statement THEN clause is executed in the following code: CUSTOMCALC: 447: IF INTREC+PRNREC#INTPAY+PRNPAY THEN :: S CUSTOMCALC: 448: ERRMSG='ACCT/CALCULATOR MISMATCH: ':(INTREC+PRNREC)'R2':'/':(INTPAY+PRNPAY)'R2' :: INTREC/ NUMBER: 24016.35 :: PRNREC/ NUMBER: 978.56 :: INTPAY/ NUMBER: 24016.35 :: PRNPAY/ NUMBER: 978.56 :: ERRMSG/ STRING: T r L=42 `ACCT/CALCULATOR MISMATCH: 24994.91/24994.91' To my tired eyes, they are equal and we should not take the THEN. What am I missing here? Thanks for your help! Steve Steve Ferries Vice President, Information Technologies Total Credit Recovery Limited 416 774 4250 [EMAIL PROTECTED] Note: This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier ilectronique est confidentiel et protigi. L'expiditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) disigni(s) est interdite. Si vous recevez ce courrier ilectronique par erreur, veuillez m'en aviser immidiatement, par retour de courrier ilectronique ou par un autre moyen. --- 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] [OT] Excel PivotTable Limitations
Try doing the ODBC Query, but tell Excel to generate an OLAP cube file instead of returning the results of to excel directly. This is an option off the last page of the query wizard. You can then run pivot tables off the cube file (a .cub file). You can also save the definition of the cube and then regenerate it simply by opening that definition file (a .oqy extension I believe) Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King [EMAIL PROTECTED] Sent: Tuesday, October 24, 2006 11:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] [OT] Excel PivotTable Limitations Is anyone aware of a PC-based tool that one can use to do analyses like Excel PivotTables but without the 65,636 rows by 256 columns limitation of Excel? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.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] Unidata/Oracle connection problem
Yes Actually we identified another problem. That being the fact that the Oracle client on Unix did NOT include an ODBC driver from what I am being told. We are investigating other commercial and open source drivers. If anyone has any suggestions it would be appreciated. Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo [EMAIL PROTECTED] Sent: Tuesday, August 01, 2006 4:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata/Oracle connection problem Richard, Did you do a relink.udlibs? That is what CONNECT uses. Cheers, Angelo More info on this: I was able to successfully use the Oracle Client using SQLplus. However attempts to use CONNECT from the tcl prompt return the following: SQLConnect error: Status = -1 SQLState = 0 Natcode = 3349920 We think our problem is in the libodbc.sl (HPUX version 11). This is still linked to the file in the Unidata application path. We can not find any other occurrence of this file. This is the ODBC Driver manager and I believe that this is necessary. Can anyone point out what you are using for this and where you got the file? Thanks Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor Sent: Monday, July 31, 2006 3:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata/Oracle connection problem I am attempting to setup a data source under Unix to allow access to an Oracle database. I am having a lot of trouble getting this to work. I have: 7 Installed the oracle client 7 Setup a place to hold the driving library 7 Setup a folder to hold my odbc.ini file and set the ODBCSYSINI environment variable to point there. 7 I created the odbc.ini file as shown below. 7 My oracle dba also did some configuration setup for the Oracle client and was able to connect through the client. [DV83] Driver=/usr/local/lib/hsdb_odbc.sl Description=Oracle ODBC on test system SERVER=testserver PORT=1521 USER=test_user Password=** Database=DV83 OPTION=3 SOCKET= TraceFile=/production/udtmp/odbc_rich.trace Trace=1 Can anyone tell me if they have successfully gotten a BCI connection going to Oracle and how you did it. By the way I am on an HP Unix system. Thanks in advance for any help. Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- 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] Unidata/Oracle connection problem
More info on this: I was able to successfully use the Oracle Client using SQLplus. However attempts to use CONNECT from the tcl prompt return the following: SQLConnect error: Status = -1 SQLState = 0 Natcode = 3349920 We think our problem is in the libodbc.sl (HPUX version 11). This is still linked to the file in the Unidata application path. We can not find any other occurrence of this file. This is the ODBC Driver manager and I believe that this is necessary. Can anyone point out what you are using for this and where you got the file? Thanks Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor [EMAIL PROTECTED] Sent: Monday, July 31, 2006 3:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata/Oracle connection problem I am attempting to setup a data source under Unix to allow access to an Oracle database. I am having a lot of trouble getting this to work. I have: 7 Installed the oracle client 7 Setup a place to hold the driving library 7 Setup a folder to hold my odbc.ini file and set the ODBCSYSINI environment variable to point there. 7 I created the odbc.ini file as shown below. 7 My oracle dba also did some configuration setup for the Oracle client and was able to connect through the client. [DV83] Driver=/usr/local/lib/hsdb_odbc.sl Description=Oracle ODBC on test system SERVER=testserver PORT=1521 USER=test_user Password=** Database=DV83 OPTION=3 SOCKET= TraceFile=/production/udtmp/odbc_rich.trace Trace=1 Can anyone tell me if they have successfully gotten a BCI connection going to Oracle and how you did it. By the way I am on an HP Unix system. Thanks in advance for any help. Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- 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] Unidata/Oracle connection problem
I am attempting to setup a data source under Unix to allow access to an Oracle database. I am having a lot of trouble getting this to work. I have: 7Installed the oracle client 7Setup a place to hold the driving library 7 Setup a folder to hold my odbc.ini file and set the ODBCSYSINI environment variable to point there. 7I created the odbc.ini file as shown below. 7 My oracle dba also did some configuration setup for the Oracle client and was able to connect through the client. [DV83] Driver=/usr/local/lib/hsdb_odbc.sl Description=Oracle ODBC on test system SERVER=testserver PORT=1521 USER=test_user Password=** Database=DV83 OPTION=3 SOCKET= TraceFile=/production/udtmp/odbc_rich.trace Trace=1 Can anyone tell me if they have successfully gotten a BCI connection going to Oracle and how you did it. By the way I am on an HP Unix system. Thanks in advance for any help. Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 06/07/2006 and will not return until 06/14/2006. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject file write in VB
I wrote an application that used uniobjects with a Universe backend. Here are some code fragments. You read a file using a UniFile object as follows. If the Record member is NOTHING then the record was not found Private rsFile As UniFile ' file handle to open file rsFile.RecordId = rsCurrentKey rsFile.Read If rsFile.Record Is Nothing Then Here is some record writing logic Note you have to set the record key too DIM WorkingRecord as UniDynArray add data to WorkingRecord rsFile.RecordId = rsCurrentKey rsFile.Record = WorkingRecord rsFile.Write If rsFile.Error 0 Or rsFile.Status = -3 Then ... If you have any ON ERROR RESUME NEXT lines comment it out so you can see if you are getting a runtime error Not you need to be create the Dynamic array either using the line above that defines WorkingRecord or use SET WorkingRecord as New UniDynArray Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 I am creating a VB project that accesses multivalues. How do I create a new record? Here is my approach. OpenFile ReadRecord Record Nothing ? (this is not nothing with new record) or Record.Count=0? No - get MV count +1, update field values and write -- this works Yes - create a new record UniDynArray (VB won't let me do this), insert values, set file.record=new rec, write -- this does nothing. No new record. Any suggestions? The documentation on VB uniobjects is real weak. Thanks, Jeff --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Training resources in India.
Does anyone out there have any information regarding U2 training availability in India? In particular the Kolkata area of India. Rich Taylor | Senior Programmer/Analyst --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MVInternet Replacement
Well, I did some checking. Yes the Pixius website is still up, but you can not find any mention of MVInternet from the main page. You can find information if you do a search. I placed a call to the main number and asked for information on MVI, but the person did not know what I was talking about. Their website currently only makes mention of custom programming services and web hosting. It looks like we can still get support, but the product is end-of-lifed. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Tuesday, December 06, 2005 6:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MVInternet Replacement FWIW the Pixius web site is still up ...? Our Visage product might be worth considering. It can be used in a dumbed down mvInternet/FlashConnect manner if you don't mind getting down into the trenches and playing with raw HTML such. You can generate pages entirely from basic, and/or use templates created with your web tool of choice and have Visage simply substitute data into the form. You can also stitch multi pages together in a web-part type manner which you can control/orchestrate with your own program. Of course the better (yes, I AM biased!) solution would be to use the whole toolkit, and design your forms/applications with our designers wizards. (Using current buzzwords Visage applications use AJAX technologies to provide a rich user interface delivered with thin client technology) Like RedBack, and ANY other solution you may consider, there will need to be changes to your existing applications to work with new plumbing. Assuming you move (if Pixius are gone this would appear prudent) part of your decision should also include ease of maintenance into the future. Send me an email, and/or drop by www.stamina.com.au if you would like more information, or one of our test-drive CD's, which include a few hours of multi-media training as well Regards, Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Andy Squires Sent: Wednesday, 7 December 2005 6:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MVInternet Replacement Rex, It's my understanding that the company which supports MvInternet (Pixius) is no longer in business. If anyone knows better please correct me. It's also my understanding that the folks at Sierra Bravo are the original developers of MvInternet, but now have a product of their own, i.e. SierraDBC. Andy On Tue, 6 Dec 2005, Rex Gozar wrote: Andy, I'm trying to find out more about MvInternet -- have you decided that it is not suitable or desirable in your upgraded system? If so, why? What are your thoughts about MvInternet (both good and bad)? rex --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ | Andy Squires -- Systems Analyst | | Office of Information Technology -- American University | | (202) 885-2785 | --- 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] Decompiler
I am going to risk the abuse and repeat a question from the past. Does anyone know where I can find a decompiler for UniData. Before I we start with the copyright discussion. This is homegrown, legacy code. We need to recover some of the source. So far the only resource I have found for UniData is Xtrico. I have put in an inquiry, but had no response yet. I am looking for options Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] BREAKING NEWS
Karl, Thanks for the laugh of the day :) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 5:18 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [OT] BREAKING NEWS quote who=Caryl Lange We missed you so...:) ... but our aim will get better . . . --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [OT] BREAKING NEWS
Rich Taylor is back in the office. For all my fans that breathlessly awaited the next automatic response...Sorry folks, forgot to set the exceptions list Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 10/14/2005 and will not return until 10/24/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Lock Management (was part of 'Good Programming Practice')
I would point out that this is only a deadlock if you make the further error of not doing proper error trapping. You can avoid the deadlock by adding the ON LOCKED clause to your read. If this condition happens you post/display the error, roll back the transaction and either abort or skip to the next iteration of the loop. No deadlock, disaster avoided. That is the beauty of transactions, the ability to roll back the whole, logical update. snip Then you introduce transaction processing and put the step of writing the journal and updating the balance into one transaction. Unfortunately locks are not released within a transaction until the whole transaction is finished (committed). So what happens is: - Program one writes to the journal. The lock is kept even after the write, because you are in a transaction. - Program two writes to the balance file. The lock is also kept because of the transaction. - Program one tries to obtain the lock on the balance file. - Program two tries to obtain the lock on the journal. - Deadlock! Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata TCL - beginner question - correction
It looks like date and part are multi-valued. You can create a dictionary that takes the MAX on the date field. Sort my descending and use SAMPLE 1 as others have indicated. This should give you just the ID of 1249. You can also defined this new data reference on-the-fly in the retrieve statement so you would not need the dictionary. This should be documented in the UV Reference manual. One other thought on this, you can use SQL statements in UV. This works fairly well if you are using standard SQL. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, October 06, 2005 2:03 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Unidata TCL - beginner question - correction Sorry, My first post on this had an example that was a little ambiguous. Not looking for GE or = Here is a more complete example * i.e. I have 8 records @ID Part Date 1234 1589 12/2/04 1235 1589 11/6/03 1236 1589 10/1/05 1249 1589 10/2/05 1234 1590 12/6/04 1235 1590 11/5/01 1236 1590 1/10/05 1249 1590 2/23/05 *** I only want to see: 1249 1589 10/2/05 1249 1590 2/23/05 Can this be done with TCL? I'm asking because I can do this in an Access query with MAX. Hoping TCL can do the same as it would save me a lot of trouble. If not TCL, then how about in a program? Thanks again, Bruce Ordway Viking Engineering 763-586-1228 [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] Good Programming Practice Question.........
I agree. Subroutines should be of a reasonable size for the task to be performed, but to limit by lines is really unnecessary. In fact it can lead to a over-use of subroutines (yes there is such a thing) that creates very fragmented code. I was guilty of this in a sizable utility and it became a real bear to debug and enhance. I do have to disagree with the statement of 10-line subroutines, though. Limit them to one function, okay, but limit the number of lines? Not even as a guideline in my list of standards. BobW Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Named Common
Named common can be a very powerful tool and where needed is often the best, if not only, way to create a solution that works for the user. Like any other tool it has its good and bad points. First and foremost is selecting a name that is as unique to the process (not filename) as possible. Then DOCUMENT YOUR SYSTEM!! Finally, manage your common. At least in UV we had a problem because named common persisted between accounts when a LOGTO was done. Yes there are ways around that problem, but it was a subtle problem to debug, when global settings were carried over from the other account. Any tool can be misused. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: Tuesday, September 06, 2005 9:57 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Named Common Yes it's a possible way of 'remembering' some values but we ruled it out for the same reason as unnamed common - sooner or later you'll interact with a subroutine or function that also uses them and then ... btw named common isn't quite safe either - it's possible that another routine uses the same name for it's common ... What's really needed is a 'local static' modifier. -- mats David A Barrett wrote: How on earth do You implement a persistent local variable without using named common ?? - -- mats @USER0 @USER1 @USER2 @USER3 @USER4 This is also in the manual. :) Dave Barrett, Lawyers' Professional Indemnity Company --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] New UV Accout VOC
Bill (and Will), As I stated I have done the directory copy many times with great success. It is not that difficult, but you have to be CAREFUL. See my earlier posts for some caveats to the process. As to the size of the files, Will has a point, but disk space is cheap. Also, if you are testing code having a full copy of the production data will allow you to better test your changes without having to recreate lots of master file data. At unix the process to copy an account located at /software/production to a sandbox account would be something like: Cp -R /software/production /software/sandbox You would then create a new UV account and point it at this new directory. I will repeat three major items to look out for in this process. 1) files with indexes as the index pointer is in the file header 2) Q-pointers and remote file pointers (F pointers with full paths to the file) as they will like still be pointing at the live account 3) Globally cataloged programs. If your 'sandbox' account is on the same box as the production account you should NEVER globally catalog from within your sandbox area. This will make your changes active everywhere which is probably not what you intended. snip I think you might even be able to just copy the whole directory, but I've never actually done it that way myself. In general, for a test account you don't really need files with a modulo of a hundred thousand and its pointless to create them and then have to DELETE-FILE and CREATE-FILE fifty times ... in my opinion. Creating a sandbox account isn't real easy. You should have saved the headaches and just hired me ;) Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] New UV Accout VOC
As a general statement, want you are doing is not something you want to experiment with unless you have a completely separate development machine to work with that you can refresh if you mess it up. You need to have a much better understanding of the file structure used by your application before proceeding further. See additional responses below: -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Monday, August 08, 2005 3:34 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] New UV Accout VOC [1] An example Q Pointer would help. It seems the downside to using Q-Pointers is that we would need a few hundred of them. On the other hand, for a SAND-BOX, the Q-Pointers could be added as needed. You miss-understand me. When you copied the VOC from another account it may have/probably contained Q-pointers that were valid for the production account. For example if you have a CORPORATE account with a file called GL there might have been a pointer that looked like: Q CORPORATE GL This would be potentially disastrous in your SANDBOX account as any writes performed to GL would up the live account. You should NEVER have a Q-pointer to a application file in the production/live account(s). In this scenario you would want to also create a SANDBOX-CORPORATE that is a copy of CORPORATE and change the Q-pointer in your. [2] I copied NEWACC to NEWACC.BAK and then overwrote NEWACC with VOC and then ran UPDATE.ACCOUNT. Doing so did not work. A message came back saying... The following records appear in NEWACC but not in VOC. Of course, these well all of the records that we need. I am not sure what you are trying to accomplish here. The NEWACC file is the repository for UV to keep the VOC entries it needs/wants in a clean account. Basically, you should NOT be doing what you did. As I said before my preferred method is to copy the account at the OS level then do an UPDATE.ACCOUNT to be sure the UV entries are correct for the development system. Alternatively you could have setup a new account, which would already have a clean VOC install. Then create a Q-pointer to the other VOC file and copy the entries from the Q-pointer with NO OVERWRITE. If there are any conflicts make a note of them and deal with them manually. [3] While our baseline ERP system is from www.GRMS.com, most of what we use is homegrown. I am not familiar with them so I can't help there. [4] Copies of VOC appear in half a dozen different places. When I change VOC in our baseline system, I can see the date change on the HP-Ux side. I was hoping that the only VOC that matters is the one under the account itself. Again, this is dependant on the application. If you are not familiar with the account structure this software you should contact your vendor before attempting something like this!!! [5] I am unable to get change directories to get to /u2/METAL/TEMP/NEWACC and /u2/SANDBOX/TEMP/NEWACC to try the above procedure. [6] Somehow our production system knows that the compiled code lives here /u2/METAL/SOFTWARE/ACC.BPAccounting Code /PUR.BPPurchasing Code ... /etc etc while the data files are in... /u2/METAL/* Further suggestions would be appreciated. Thanks to those who responded... --Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 [EMAIL PROTECTED] 973.471.7770 x145 .voice 973.471.9666 .fax Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] New UV Accout VOC
Bill, I see you have received many responses some of which give some hints as to finding your missing verb so I will respond in general. I often copied accounts to new directories and had little trouble as long as you know what you are working with. Remember that in UV the voc holds pointers to files (local and remote), commands (the VOCLIB file was mentioned by someone else), and cataloged programs. Here are some of the pointers I would make to you: - Run Update.Account AFTER copying the remote VOC. Any conflicts will be moved to a holding file where you can review them and copy them back to the VOC if appropriate. - Watch out for local files as copying the VOC does not copy the underlying files. I usually copied the account directories first at the OS level then created a new account that pointed to that new location. - Watch out for Remote files (Q-pointers or hard path pointers) that point to files that are part of your live application. You may need to create copies of these accounts too to completely replicate your application environment to provide a Sandbox account. - Write a program to remove all voc entries for programs cataloged from your application program files. Then re-catalog the libraries that you need. - DANGER Watch out for indexes in files copied!! In UV the file header contains the full path to the index as it was created. This will now point to the old account which will mess up your indexes. In the new account use the SET-INDEX command to reset or remove the pointer in the file header. - Watch out for any VOC entries that are part of the application you are copying. These might include control records and/or flags that may, themselves, have embedded file paths. I did not have many of these to worry about, but that could mess you up. The bottom line is that there is nothing in a simple UV account VOC that would prevent you from copying it. The problem lies in the application whose account you are copying and how complex that application is. As I said I have done this many times with an application that was made up of 2 accounts at a minimum with great success. If you have any specific questions I would be happy to respond. Out of curiosity what is the application whose accounts you are trying to copy? Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Monday, August 08, 2005 10:19 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] New UV Accout VOC We need to setup a Sand-Box account for piloting. I created an account with UV Admin. I copied the data files (including VOC) over. The command LOGTO SANDBOX seems to work ok. Upon issuing further commands from a TCL prompt, UniVerse comes back with an error message indicating... Verb MAIN.MENU is not in your VOC. We are on a newer version of HP-Ux. 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] [UV] Select Question
Well, I will admit that I have rarely used the SELECT filevar TO LIST syntax so I can not pull out a specific example. However, I have seen several occurrences where SELECT filevar missed records and when the syntax was changed to EXECUTE SELECT filename it worked perfectly. This has occurred on both Universe and UniData. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] writes: There can be a major problem with the second syntax depending on what you are doing to the file. The SELECT filevar syntax does not create a select list even in memory. It traverses each group in order as you perform the readnext command keeping a pointer to where it left off. It's my belief that both methods work the same way in this regard. Did you test to see that it actually traverses the entire file once to build LIST ? I'm not sure that's the case, but I might be wrong. Will 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/
RE: [U2] Internal date conversion
I have found that a general date conversion is pretty flexible in UV (not sure about Unidata yet) Try: I.DATE = ICONV(EXTERN.DATE,D) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Pankaj Gupta04 Sent: Thursday, July 14, 2005 12:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Internal date conversion I want to convert a date in following format to Universe internal format. Can anyone please provide me the specific format command? -MM-DD e.g. 2005-07-14 is the input format. I want to store it in equivalent Universe format i.e. 13710. Thanks and Regards Pankaj Gupta CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- 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] Select Question
There can be a major problem with the second syntax depending on what you are doing to the file. The SELECT filevar syntax does not create a select list even in memory. It traverses each group in order as you perform the readnext command keeping a pointer to where it left off. This is why is can be so much faster/more efficient than a select to a list which must: a) traverse the file to create the list and b) hold that list somewhere. The problem comes in if you write back to the file you are traversing. This will reorganize the group moving where records are located. You can end up records not being processed that you believed were going to be. You are much safer either Executing an Retrieve select or selecting to a list. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 14, 2005 12:05 AM To: u2-users@listserver.u2ug.org (u2-Users) Subject: [U2] [UV] Select Question Hi all, Can someone tell me the diference between the following two examples of executing an external select? SELECT FILE TO LIST LOOP READNEXT ID FROM LIST ELSE ID = @AM UNTIL ID = @AM DO REPEAT SELECT FILE LOOP READNEXT ID ELSE ID = @AM UNTIL ID = @AM DO REPEAT Someone pointed out to me that there is overhead in selecting to a list that I need not be exposing myself to. Aren't they both kind of reading from a list somewhere anyways? Thanks --- 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] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
Well, you raise a point, but not the one I think you intend. Transactions should be designed to be active for the minimum span of time to avoid the bottleneck mentioned. I would think very carefully about any transaction the cached a large group of updates for a long period of time, say all postings of a select list of transaction. Instead I would put the transaction inside the loop unless there was a very good reason to be able to back out the entire batch of selected updates. In either case the assignment of a sequential id from a control record is, in and of itself, a data change that should be cached. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Sunday, June 12, 2005 4:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... Charlie, I don't see how that addresses the TRANSACTION problem. If the call to your NEXT.AVAIL.ID routine happens after TRANSACTION START, the id control item will not be updated nor will its lock be released until TRANSACTION COMMIT (or rollback) is executed, even though the NEXT.AVAIL.ID routine says to write and release it. This is a potential bottleneck if other concurrent processes are wanting to do the same, waiting for that control item. cds --- 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] access via disabled accounts (solution) - How?
Not if you are using stored procedures (U2 basic subroutines) to do the file manipulation. Passing the record to the subroutine provides one layer of removal from the client program. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Friday, June 10, 2005 7:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] access via disabled accounts (solution) - How? How can you pull data from a U2 file, via UniObjects, manipulate it in VB.NET, and write it back to the file, via UniObjects, via stored procedures, and without directly accessing the files from UniObjects? That question contains a heavy duty internal inconsistency. It you write it back to the file via UniObjects then you ARE, necessarily, directly accessing the files from UniObjects. If you don't like the UniObjects methodology there are others, such as ADO, OLEDB, ODBC and so on. A bit more setting up required on the server side, but you only do that once. --- 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] Uniobjects hack
Actually, when you convert an account to a schema you can use SQL security to do this. This is what I am referring to. You need to setup SQL users in your schema (same login used to get into UV) or set privileges for PUBLIC. If the user exists in the Schema user table then those permissions are used otherwise the PUBLIC setting is used. Note that you can use an account as both a schema and a regular account. This is the reason I needed to set all permissions for PUBLIC. I have done this under Universe to provide some basic security related to using Uniobjects in the past. I am not sure if this will fully solve the issue being discussed here or if Unidata would behave the same way. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 Richard: Am I accurate in thinking Pick __USED__ to have file level security but it doesn't exist in the U2 products because, it was always said, the O/S takes care of security (aka: we don't need no stinkin file level security)! Perhaps, having dbms security isn't such a bad idea after all. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor Sent: Friday, May 27, 2005 8:09 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack [snipped] 2) Convert the account to an SQL schema. You can then attach file level security via the SQL user. Just remember to create a security entry for Public too otherwise you could end up locking out all the other users that are not subject to the tighter security. (i.e. GRANT ALL TO PUBLIC) If you are trying to allow them to access a file, but control what they do you may be out of luck. However you could use triggers to a least create audits. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] SB GUI controls attribute question
I am hoping that someone out there has some knowledge of SB control attributes. Specifically I am using GETATTR to examine all the attributes of a textclass control. I am interested in the Callbacks and Events attributes. My guess is that events tells you all the events defined for the control and Callbacks lists the specific events that are actually being trapped for. Callbacks is a write enabled attribute so I am guessing that I can add more callbacks. The question is how? The format of the callbacks is a Value mark separated list in the format of event char(6E) {a numeric value} char(6E). What does that number mean? If I add a new event callback how do I work with it in my code? Any help or suggestions would be appreciated. BTW, the background on this is I am working with a multi-valued dataset where I need to trap for additional actions like row change. I think I have found a way around it, but it is kludgy. Note to anyone from IBM here: Please provide better documentation of SETATTR and GETATTR in System Builder. I suspect I could do many of the things I want to if I only could figure out how to work with the control attributes that are available. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I'm in an Array quandry, any suggestions...
Dimensioned vs Dynamic--brain damaged code is still brain damaged code. I could not agree more! the music majors passing themselves off as Pick programmers For the record I almost failed music history :) For those keeping track of suggestions for IBM here is one that would help bridge this divide. Allow re-dimensioning of dimensioned arrays at runtime. In VB you have the REDIM command and in C you can re-dimension damn near anything. Having this capability would provide the best of both worlds. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 3:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I'm in an Array quandry, any suggestions... I think one of the the things that we are overlooking is the underlying philosophy that machine cycles are cheap, and anything that cuts development or modification time is a Good Thing. You and I may not agree with that philosophy (having been victimized by code that took the idea to it's illogical conclusion), but keeping track of how many elements you need in a dimensioned array is one of the icky programmer type things that, historically, the music majors passing themselves off as Pick programmers were loath to do. But in the Real World, these kind of things usually (note the disclaimer) do not make much difference. I always enjoyed blowing someone's benchmark out of the water by sticking a single READ statement in the middle of their CPU intensive loop. It's all about the disk, mon. -- Regards, Clif On May 17, 2005, at 10:18 PM, [EMAIL PROTECTED] wrote: And then by that time, system programmers would be saying Why can't they just all use dimensioned arrays dammit :) I suppose. --- 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] I'm in an Array quandry, any suggestions...
Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. Wol, I stand corrected. Guess I missed that earlier point. It would be great if this functionality were generically available. If I read the UD documentation correctly it 'may' be available in the flavors we are using. Guess I will just have to play with it. Not that it would help my situation that much (well using the 0 element for excess would). As I said earlier changing flavors in the program is not an option that would help. The issue is not the programs we are changing, but rather the legacy code we are not changing. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandry, any suggestions... Allow re-dimensioning of dimensioned arrays at runtime. In VB you have the REDIM command and in C you can re-dimension damn near anything. Having this capability would provide the best of both worlds. As others have pointed out, YOU CAN. You just need to be using one of PI-derived flavours. And someone said you can actually switch between PI and Pick style behaviour even within one program! provided you sprinkle the magic directives in the correct places. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I'm in an Array quandry, any suggestions...
Larry, Well, if you have to work in dimensioned arrays that would be the way to do it. Unfortunately, the code base I am working off of took this idea and completely messed it up. It is to the point that the dictionaries can not be trusted to truly represent the data. We are spending a great deal of time just dealing with this. As to the original topic, I will still stand by my earlier remarks, but I will qualify it by saying that performance (in ANY system) has a lot to do with how the system is designed in the first place. The code base that I came from previously was also of late 80s vintage and we did not see any benefit in moving to dimensioned arrays. I think that the difference is that we had records of a fairly manageable field count, but we used lots of value and even sub-value marked data. Dimensioned arrays don't really help you too much with that. We also sold systems based on the flexibility of the database and dimensioned arrays, even with tools like you describe, does lessen that flexibility (IMHO) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Friday, May 13, 2005 5:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandry, any suggestions... Richard Taylor wrote: Certainly not enough to justify throwing away one of the best features of the Pick database, or having to code work-arounds to deal with the short-comings of dimensioned arrays. I'm maintaining a system that was originally developed on Prime Information in the mid-80's, when performance between dimensioned and dynamic arrays WAS an issue. It uses dimensioned arrays and matread/matwrite, but the way it was designed, none of the short-comings you mention are really an issue. Every file in the system has an abbreviated name. For example, the abbreviation for the customer master file (CUST.MST) is CM. There is a utility program that selects every 'D' item from the dictionary, and builds an $INCLUDE file for all or selected files, named DIM.(filename) (eg DIM.CUST.MST). This DIM.xx file is included in every program that needs to access the customer master file, and includes the following statements: DIM D.CM(X) ; MAT D.CM = '';* Where X = number of fields in the file EQU CM.CUST.NAME TO D.CM(1) ... And so forth for every field in the file NOWHERE in any of the code is the customer name referenced as D.CM(1) or CM1 or anything similar. It is ALWAYS referenced as CM.CUST.NAME. Sub-valued fields are refenced as CM.ADDR1,x, for example. As new fields are added to the file, the inserts are re-created. Because extra fields are stored as a dynamic array in D.CM(0), programs that don't use the new fields don't need to be recompiled. Yes, I realize that the same thing can be accomplished with dynamic arrays (ie EQU CM.CUST.NAME TO CM1), but as I mentioned in the beginning of this post, this software was originally written back when there WAS a performance difference between using dimensioned vs dynamic arrays ... At least that's what the conventional wisdom told us at the time. Larry Hiscock Western Computer Services --- 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] I'm in an Array quandary, any suggestions...
Ken, Thanks for the suggestion, but that would require changing programs that we had no intention of changing. Further making such changes is much larger than can fit within the scope of the current enhancement project. A global system switch that effected just this one behavior would have been nice, but guess it is not to be. Honestly, I didn't hold out much hope, but it was worth a shot. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Friday, May 13, 2005 11:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandary, any suggestions... REC(0) references a dimensioned array and, apparently, in UV holds all fields that could not fit into the dimension of the array. UniData does not work this way, it puts it into the last dimension of the array which could result in data loss if you change that array position. We have confirmed this on our system as we are faced with the same problem. -- Here is a question to the group. Is this a behaviour in UD that can be changed in a configuration setting? Again, as with UV, UD is emulation dependant on this. Basictype 'u' and 'm' use element (0,0) IIRC, while 'p' and 'r' put the data at the end, or simply truncate it - I can't remember. If for some reason you need to operate your account with BASICTYPE 'p', then you can always drop a 'BASICTYPE u' statement into the top of a program you want to behave sensibly. HTH, Ken --- 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] I'm in an Array quandry, any suggestions...
Don't confuse Dimensioned (fixed) arrays with dynamic arrays. REC0 is a dynamic array reference and would always return the entire record. REC(0) references a dimensioned array and, apparently, in UV holds all fields that could not fit into the dimension of the array. UniData does not work this way, it puts it into the last dimension of the array which could result in data loss if you change that array position. We have confirmed this on our system as we are faced with the same problem. -- Here is a question to the group. Is this a behavior in UD that can be changed in a configuration setting? Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Clark Sent: Thursday, May 12, 2005 1:46 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandry, any suggestions... Sometimes, REC0 returns the entire string too. I ran into this once converting a program that actively used the assumption that REC0 would return nothing. Having REC(0) reserved for overflow seems convenient though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Thursday, May 12, 2005 11:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I'm in an Array quandry, any suggestions... I don't think MV participates with the OPTION BASE 0 or 1 that allows the use of REC(0) that VB etc does. MV tends to count things starting with 1 and MS starts with 0. REC0 etc tends to be confusing as it's not the primary key either. I use OPTION BASE 1 to keep my head on straight when progamming in VB. My 1 cent. - Original Message - From: George Gallen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, May 12, 2005 12:04 PM Subject: RE: [U2] I'm in an Array quandry, any suggestions... OK. ours is being stored in element zero. None of the programming use element zero so that is good. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: Thursday, May 12, 2005 11:36 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandry, any suggestions... George, It really matters what flavor you're running. If you run a flavor that puts the overspill in element zero, you may be ok. If you run a flavor that puts the overspill into the last element, that might mess up any accesses to that element in the existing code. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 12 May 2005 16:01 To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandry, any suggestions... WOW. I just found an interesting feature of UV. You can MATREAD a record that has more fields than are dimensioned, and you can MATWRITE that record back out INTACT without getting an error, It only bombs with an out of bounds error when you try to reference a subscript past the dimension. Soas long as any of those program dont try to mess with data it doesn't know about, we should be safe. George -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of George Gallen I'm modifying some programs that were written about 15-20 years ago, there must be 30 or 40 that interact with each other. Here is the problem. All the programs use dimensioned arrays, and they were dimensioned to exactly what was needed at the time, now I need to add 4 fields to one program. But I'm afraid if another program reads this newly created array, it will bomb out with an array out of bounds error. What is on my side, is all the programs that reference these files, all use the same variable name. My initial thought was to write a small program that will 1. open a program 2. search for a dimension of the suspect variable(s) 3. increase it's dimension level 4. write the program back out 5. recompile the program (I don't believe any are cataloged) Any other ideas? --- 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
RE: [U2] I'm in an Array quandry, any suggestions...
We are faced with this same situation and the thought behind this truly baffles me. Why take a flexible, dynamic database system and force it to be fixed length. This is what you are doing using dimensioned arrays and MATREADs. The most common justification I have heard is performance and this simply doe not hold water. I started in Pick in R83 and have never used a dimensioned array to hold record structure and I have not seen performance issues. This to the extent that we ran an MRP run on a 286 Wyse PC that choked the mainframe at this company. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I'm in an Array quandry, any suggestions...
Yes I have compared the performance. Within the ERP system I worked in we saw little difference. Yes dimensioned arrays MAY have some advantage under certain circumstances, but reading and accessing fields in a record is not one of them. Certainly not enough to justify throwing away one of the best features of the Pick database, or having to code work-arounds to deal with the short-comings of dimensioned arrays. Again I am referring to the use of MATREADS and WRITES primarily here. When you do this the dim'd array only provides any benefits when accessing fields. When you get to dealing with value and sub-value mark separated data you are back to the 'slower' text extraction. I generally don't like using dimensioned arrays at all, but outside of handling actual record structures they do have their uses. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, May 13, 2005 2:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandry, any suggestions... Richard Taylor [EMAIL PROTECTED] wrote on 05/13/2005 02:05:51 PM: ... Why take a flexible, dynamic database system and force it to be fixed length. This is what you are doing using dimensioned arrays and MATREADs. The most common justification I have heard is performance and this simply doe not hold water. Have you ever compared performance between dynamic and dimensioned arrays, or are you just saying that you've never notice problems but have never tried dimensioned arrays? I've seen it make a HUGE difference in Pick, UniVerse, and UniData. If you reference many elements of a dynamic array many times, you'll burn a lot of CPU cycles just to locate the data. When you reference an element of a dimensioned array, it's stored in separate address space, and is immediately referenced. I have a standard way to avoid problems with the last attribute folding into the highest array element. Just dimension the array one element larger than the highest attribute you reference in the program. So if the highest attribute you reference is number 72, dimension the array at 73 or higher. Where I used to work, we had an automated process that created file definitions, including standard equates and the code to dimension arrays. We always created the arrays at one more than the highest attribute, and never had problems. This won't be necessary in environments where the extra attributes are placed on element zero, but it won't hurt anything, either. That way your code will be portable. Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [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: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series]
LeRoy, Perhaps I don't fully understand your example, but I don't see the distinction here. If I have a webpage that sends a request to the U2 database (via any method mentioned in this thread) and waits for it's response then goes on with it's own life each web site vistor would only be using the database services for the duration of the request. Now if I have a service (phantom) that is trying to service these web requests it can only service one at a time. Stated another way only one web-user is accessing the database at a time. Are you saying that this violates the license? I can understand your position only if each of the web sessions maintains some kind of persistent connection to the database. A request/response messaging system should not violate the concurrent license restrictions. BTW, thank you for posting in this thread. I don't think I have seen another IBM person respond (if I missed one I apologize) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 Craig, Since MQ is designed to be send and forget technology, and because you can have multiple listeners, there is nothing to stop you, and is, in fact, the purpose of the technology. However, remember that if you are using MQ as a means of users communicating with the database in the scenario you describe, you are using MQ as a de facto connection pool and violating your U2 license agreement if you don't have the equivalent number of U2 licenses that match the interactive users. Regards, LeRoy F. Dreyfuss --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] IBM Licensing Requirement
Just to clarify this discussion, you only get this if you purchase device licensing. The last time I had the need to look into this you could still purchase U2 via a concurrent user license model. This did not care about IP addresses for license verification. If you opened up two sessions on your client you consumed two licenses. As to the rest it comes down to a definition of concurrent user. The generally accepted definition is something like a user that is connected to and having access to the database services. I agree with the example given by many. The web services model is no different than purchasing 25 licenses, but having 50 users that may, and any time, attempt to connect to the database. Only 25 at a time can use the services of the DB so no violation here. That would be the same for web services users that only connect long enough to request the db services then disconnect. Again, no violation here. Now if you were to come up with a multiplexing solution where several users maintained a persistent access to the DB through a single connection then you may have a problem. However if each user connects, does something, then disconnections I would not lose any sleep over it. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 snip With device licensing, you can get ten connections per license. When all the connections are coming from one 'factory' that can vary the device subkey after each ten connections... there you go, potentially ten different users on one license. -- Wendy Smoak Applications Systems Analyst, Sr. Arizona State University, PA, IRM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MvInternet
I believe that you are incorrect on this. My company recently purchased this product and the company's website seems to still be active. I am sending the link below http://www.pixiussoftware.com/mvinternet.php Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brown, Rick (brownri) Sent: Thursday, April 14, 2005 8:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] MvInternet It seems that the MvInternet product is no longer available. Is there some transport to get Unibasic or XML output to the web that does not entail spending 16,000 dollars? Our budget is way too tight for that kind of money, and the MvInternet product seemed priced in our range.. around three thousand. MvInternet seemed to be EXACTLY what we wanted. WebWizard (which seems to run on that engine) seems way too expensive. If anyone has any ideas they would share, please contact me at [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: RE: [U2] Extending U2 with gci/CALLC -- Factory Floor Automation -Serial
Well, as I tell people about an IT career today The great thing about my job is I can do it anywhere, the bad thing about my job is I can do it anywhere Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Wednesday, April 13, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: OT: RE: [U2] Extending U2 with gci/CALLC -- Factory Floor Automation -Serial snip It's pretty neat to be in say, an airport terminal that has wireless access and go to your web site with your PocketPC, run a report and view it as a pdf while waiting to board your plane. /snip Brian - If you do it once, it's kinda neat, if you do it more than once I think you need help... ;) --- 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] Complicated Select
Actually, that looks like an attempt to adapt an SQL syntax. That type of logic is common in SQL statements Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Tuesday, April 12, 2005 2:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Complicated Select No, it's not just you. I read it three times and still am amazed that the syntax was even allowed. I have never seen anyone use more than one file in a select list in 17 years of using pick out of my 31 years of programming... Live and learn! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 12, 2005 10:05 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Complicated Select Maybe it's just me, but I read your email multiple times and don't really know what you are asking. Are you saying you have two files FILE_A and FILE_B and a select list of IDs you wish to omit? In other words, select all records in FILE_A that have the same item ID in FILE_B and then MERGE-LIST DIFF with the omit list? Bruce M Neylon Health Care Management Group Aherne, John [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/11/2005 07:04 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:[U2] Complicated Select Hi all, I want to do a complicated select statement in UD. Basically, I have a list of items AA, BB, CC. I want to do a select along these lines: SELECT FILE_A WITH RECORD_A IN (SELECT FILE_B WITH NO @ID = AA BB CC) RECORD_A is MV Is there a way to do this in UD? TIA, John Aherne --- 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] [UV] Hashed file size
From what I know (other replies indicate that newer version may have a higher limit) the limit on a single part, hashed file is 2gb. You can exceed this by making the file a multi-part file where the physical files at the OS level are split, but you still reference a single file name in UV. You can start looking at the Create-file command documentation for more information on that. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Tuesday, March 01, 2005 12:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Hashed file size I seem to recall a limitation on the size of a hashed file. I believe it was 2gigs. I've tried looking for an explaination in the U2 library on the IBM site , but haven't come across anything regarding UV file limitations. Can someone please refresh this aging memory of mine or link me to the appropriate documentation. thx, rudy Rudy Cooper Sage Publications I.T Development Thousand Oaks, California (805) 499-0721 #7724 --- 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] and FoxPro?
Not FoxPro, but I have done things with Access. I used basic ODBC connections to UV to create GUI, client-based front-ends in Access. It was mostly an experiment, but it worked fairly well. If FoxPro supports DB connections via ODBC (as it should) then you would need to install the U2 ODBC client and configure a connection. This is explained in a manual covering Writing ODBC Applications. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Wednesday, March 02, 2005 8:35 AM To: u2-users@listserver.u2ug.org Subject: [U2][UV] and FoxPro? I am just wondering if anyone has ever written an app in FoxPro to access UniVerse, or UniData for that matter? Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- 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] Default Catalog?
If no catalog exists for a called subroutine UV looks in the same program library as the calling program. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Wednesday, February 23, 2005 1:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Default Catalog? I've been working on a Universe 10.xx on an Dec Alpha machine, I found an account where a subroutine was being called and the routine wasn't catalogued in that account. It wasn't catalogued globally as well. There seems to be some default at work where if the subroutine isn't catalogued, it checks in the library of the calling program ? (Like the include statement ?). I've previously worked on versions 6.xx to 9.xx on a HP-UX and I don't remember it doing this. (But then, most of the routines I used were usually in a different library there) Is this something new ? __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_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] Re-Catalog?
Which is exactly why it is a BAD IDEA to allow multiple programs to exist in different code files with the same name, especially in the same account. There would be no way to properly catalog those programs meaning you need to use the RUN command to execute them all the time. The ability is to catalog programs, globally or locally, is a very useful capability. Even a necessary one when you deal with callable subroutines that can reside in different code libraries. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 11:18 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Re-Catalog? In a message dated 2/22/2005 7:00:17 AM Pacific Standard Time, [EMAIL PROTECTED] writes: SELECT BP CATALOG BP LOCAL Danger Will Robinson! Warning! Warning! Do not do this. Stop. No. Baddog. If you have three different programming files like :BP, NEW.BP and VENDOR.BP this will overwrite any same-name items in the VOC. NOT a good idea. trust me ... not that this has screwed me over a few dozen times myself or anything... no .. Will 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/
RE: [U2] uv pe
John, Basically, it comes down to a cultural (as in PICK community preference). The logic is that dictionaries are cheap, easy, and reusable, so why not create a virtual field. Back in the bad old days database structures were fairly rigid constructs. PICK was one of the only models that maintained a very clear separation of data field definition from the actual data. So the habit/technique/culture was to take advantage of that flexibility. Today you have a choice. You can create virtual fields on the fly in a retrieve statement. At least you can in UV. The exact syntax is not at my finger tips as I don't use it often (I prefer to create a dictionary) but it is covered in the manuals. As I recall it is only slightly more complicated than a similar function in SQL. Of course, as someone mentioned earlier, you do have the option of doing SQL syntax in UV today too. Having created complex reports both in UV and in native SQL (non-U2 database) my opinion is that SQL is stronger in creating complex relational reporting and retrieve is better at quick column oriented reports. Once you know the language neither is significantly more difficult than the other. They both have strengths and weaknesses. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 17, 2005 6:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe True, I really shouldn't write off anything that I am not informed about, but we have programmers here that have been programming Unidata since time immemorial and they don't know how to do something like a select statement that converts criteria into caps for comparison. E.g. SELECT blah WITH UPCASE(x) LIKE ...HELLO... (Doesn't work, but is what I want to do). The best answer I got was create a virtual field that stored the field in caps and then use that in the select. In fact, the example in an old Unidata manual I found says to do just that. Perhaps there is good reasoning behind that method, but the logic of it completely escapes me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Lakeland Sent: Thursday, February 17, 2005 2:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe John, There is also a huge amount of things which can be done with a single line query in both UD and UV. Because you don't know how to do them does not mean they cannot be done. As you say, you are new, it's an unwise man who rubbishes a product he knows little about. Suggest you ask a few questions, especially on the issues which take so much time to do. Andy -Original Message- From: Aherne, John [mailto:[EMAIL PROTECTED] Sent: 17 February 2005 20:31 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Ease of development? Very little support required? I have just started to use UD, and development is horrific, it take 10 times longer to do things that can be accomplished by a single line query in an RDBMS'. Our system requires constant attention, more attention than even MS Sql server on a bad week. But the thing that annoys me most is the poor support from IBM. I cannot get access to some of their tech docs because our UD license is held by our VAR (Don't ask). What kind of policy is that? For any other DBMS I can get access to vast amounts of information, and I don't even need to have seen the software, nevermind have a license. I looked forward to working with UD when I found out I would be developing on it, I have never used an mvdbms before, and the concept intrigued me. But so far, I do not see any benefit to using UD for anything what-so-ever, and nothing IBM or our VAR has provided has even hinted that UD, and UV are anything but an archaic relic of times gone by, like COBOL. Why else would a company make it so difficult for someone to learn about development on their software, if not because they didn't really have any interest in supporting it, and believe that you should have upgraded to more modern technology already? Regards, John Aherne --- 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 pe
Leroy, I am sorry, but that argument doe not hold water. The client has purchased, whether directly or indirectly, a U2 database product. They have full access to the system to do their own development if they desire. They should be able to review any available knowledge-base. I can not think of any other database product or associated development tool that does not have this. It may not be a good one, but they don't wave information in front of people then say you can't have it. The client is the one that ultimately paid for the license not the VAR. If the VAR wants to lock-down their client to prevent modifications that is their responsibility. I feel safe in saying this as I used to be a VAR working for a company that marketed an ERP system on UV. Perhaps IBM could work with this group to establish a generally available knowledge-base within this community's web-space. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, February 17, 2005 11:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe IBM isn't treating you unfairly, John. We sell through business partners and they act according to their own business models and contractual obligations with their clients as well as with their vendors. For technical information, your reseller (in your case, your Master VAR) would be the responsible party to provide it- that is the agreement your business has with your reseller. That is the agreement they have with us. A very good way to obtain technical information is to attend our annual technical conferences. An excellent (and quicker) way is to post your questions here on the u2-users list server, run by the U2 Users Group. This is a great community of very knowledgeable and helpful individuals. Having said that, U2TechConnect did not prevent you from accessing the personal editions. Anyone, including those folks that do not work for a business using U2 products could download them. That was the point. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 John Kent [EMAIL PROTECTED] m.au To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject Re: [U2] uv pe 02/16/2005 03:19 PM Please respond to [EMAIL PROTECTED] er.u2ug.org What a joke Leroy I cant get access to Tech connect as we get our universe licenses through a master var This annoys us plus our client sites with inhouse programmers Its hard to defend IBM when they treat you like this jak - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 16, 2005 4:05 PM Subject: RE: [U2] uv pe They are coming. We haven't broken any promises. The quarter is only half over. I would have thought a fair number of you folks would have downloaded earlier versions by now as they were on the U2TechConnect Website for a couple of years. We know you all want the latest and greatest features we have to experiment with, and you'll have them with just a little patience. Because they are free evaluation copies, we are required to package them a bit differently, and the U2 group was not the only group involved in the process. We, too, had to wait. They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. Thanks again for waiting. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Marc Harbeson [EMAIL PROTECTED] .com To Sent by: u2-users@listserver.u2ug.org, [EMAIL PROTECTED]
RE: [U2] uv pe
What an absolutely wonderful idea! Glad I thought of it ;) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Richard wrote: Perhaps IBM could work with this group to establish a generally available knowledge-base within this community's web-space. I believe Richard, that on the www.u2ug.org website there is a place there somewhere to suggest enhancements. So this request doesn't get lost, maybe you would be interested in posting it there? HTH Will 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/
RE: [U2] Basic program editor for Windows
I would add my vote for UltraEdit. As has been mentioned you can do syntax highlighting, but more important for me is the project organization tools. You can very effectively organize files you are working on into projects for easy retrieval. This works with files opened via FTP too. The only caveat I can add is that you are working OUTSIDE the U2 environment so source code management tools like PRC will not be directly integrated. You will have to add items you edit this way to your projects by manually adding them or editing them in U2. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, February 13, 2005 1:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Basic program editor for Windows When I'm teaching my Basic programming courses, I am frequently asked about any Windows editors which might be used to edit the source programs which are held in DIRECTORY / DIR type files. Can anyone suggest any suitable software which I might recommend? It would be nice if the software had facilities for highlighting keywords, labels, variables and so on, and if it could indent the source code. Regards Malcolm Bull --- 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 to Web interface
Sounds like you want to look into a product called MVInternet. We are just starting to use this here, but from what I have seen it is easy to use. Here is a link: http://www.pixiussoftware.com/mvinternet.php Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 1:30 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe to Web interface In a message dated 2/9/2005 5:34:48 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I still don't get why you want to use a BAT file to do this at all. IF you're using IIS, you should really be using ASP. I don't. Here is what I want From a web page, click on something, which in ANY fashion reaches into Universe and displays the results on that web page. Focusing on the ANY fashion, any way, any how, any method, with example code please so I don't go insane trying to follow the hand-waving. And preferable I'm looking for the absolutely simplest manner of doing this. And the free way too ... btw. PS thanks for those of you who sent various examples of doing this. Will --- 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 CREATE SCHEMA
One other thing to watch out for is when you make an account into a Schema normal, non-sql users, will not have access to the files anymore. If you want to use the account as a Schema and as a regular UV account you can do so but you will need to grant permissions to the non-sql defined users. TypeGRANT ALL TO PUBLIC (I think I got the syntax right). If you want to limit some people create an SQL user for them and set more limited permissions. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Friday, February 04, 2005 1:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe CREATE SCHEMA You need to login as the administrator, which is the initial SQL User. Then GRANT Connect and then resources, etc to alternative users. Then you can logout and login under the new user and you will have SQL access rights. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, 4 February 2005 10:14 AM To: U2-Users List Subject: [U2] Universe CREATE SCHEMA Hi folks. I'm trying to get my feet wet with SQL and I've got what seems like a simple question to ask but one that is proving to be rather difficult to find an answer to. I'm wanting to issue a CREATE SCHEMA command but when I do I get an error message that I'm not an SQL user. How do I go about setting myself up as an SQL user? I'm logged into our domain and my UID is in the Administrators group so I should have rights to just about everything. The environment is Win2003 server, UV 10.1.3. I've searched FAQ's, PDF's, DOC's, websites, Google and still am having no luck finding anything that tells me how to set myself up as an SQL user. Any direction would be greatly appreciated. BobW --- 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 CREATE SCHEMA
You are correct. I made an assumption regarding what he was doing. I know, I know assuming anything is not great practice. I humbly beg forgiveness from the group :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 04, 2005 11:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe CREATE SCHEMA Richard Taylor wrote: One other thing to watch out for is when you make an account into a Schema normal, non-sql users, will not have access to the files anymore. If you want to use the account as a Schema and as a regular UV account you can do so but you will need to grant permissions to the non-sql defined users. This is only true if you *convert* an account to a schema. Merely creating a schema on an account does *NOT* convert existing files to SQL tables. You will still be able to access your existing traditional Universe files as you always have. --- [This E-mail scanned for viruses by Declude Virus] --- 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] Running a stored procedure from Excel
I have a co-worker that is trying to get a stored procedure to run from Excel via an ODBC connection. What he is trying to do is have a routine that will regenerate some data whenever this query is run or the refresh button is clicked. This is a straight ODBC connection run against UniData Any help would be appreciated. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe CREATE SCHEMA
I had converted normal UV accounts to a schema for one client because it improved the access via ODBC/ADO. You could then access the data files externally as SQL tables or normally in UV. Just remember to grant 'public' sufficent access for the normal UV users to work. You can do SQL statements in a UV account without doing any of this as someone else suggested. -Original Message-- Now, if you are talking about *converting* the tables in question to SQL tables (which allows you to use constraints, but, as far as I can think of, that's the only benefit), you would probably want to make a complete copy of the data (or a subset adequate for testing/playing around with). Bob Woodward wrote: So if I have an account and want to access the data from my SQLPLAY account, how do I set this up so I can use SQL in SQLPLAY but not change the other accounts access? Can I create VOC entries that point to the same DATA files but have different DICT's? Is that enough? -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Richard Taylor Sent: Friday, February 04, 2005 10:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe CREATE SCHEMA You are correct. I made an assumption regarding what he was doing. I know, I know assuming anything is not great practice. I humbly beg forgiveness from the group :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 04, 2005 11:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe CREATE SCHEMA Richard Taylor wrote: One other thing to watch out for is when you make an account into a Schema normal, non-sql users, will not have access to the files anymore. If you want to use the account as a Schema and as a regular UV account you can do so but you will need to grant permissions to the non-sql defined users. This is only true if you *convert* an account to a schema. Merely creating a schema on an account does *NOT* convert existing files to SQL tables. You will still be able to access your existing traditional Universe files as you always have. --- [This E-mail scanned for viruses by Declude Virus] --- 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/ --- [This E-mail scanned for viruses by Declude Virus] --- 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] Transaction Compile Failure
A transaction may only have a single BEGIN and END statement. You are basically creating a logic block that contains the code that makes up the 'transaction'. In your case you have two choices First, you could move the begin transaction above the LOOP and the End transaction after the REPEAT. This would put all work done within the loop into a single transaction. This has some obvious disadvantages if you are looping through many records and hold locks. The Second is the way you coded it except you should not have the end transaction prior to the UNTIL. This is an error because no BEGIN TRANSACTION occurs before it. This is like having an REPEAT statement with no LOOP. Keep in mind that you MUST use a ROLLBACK or COMMIT if you try to use an EXIT or CONTINUE statement within the loop. This will 'end' the transaction and allow a new Transaction to be started. If memory serves if the code encounters the END TRANSACTION without having had a COMMIT or ROLLBACK done it would do an implicit commit, but I am not sure of that. I have always preferred to explicitly do a COMMIT at the end as you have done. Hope that helps. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Tuesday, February 01, 2005 1:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Transaction Compile Failure Logically there *is* an END TRANSACTION at two places. One at the bottom of the loop.. COMMIT END TRANSACTION And the other at the top of the loop... IF @TRANSACTION THEN ROLLBACK END TRANSACTION END This being the case it would seem to me that the compiler cannot deal with a transaction not being in purely straight-line code. The only alternative I see at this point is to put an explicit ROLLBACK / END TRANSACTION at every point along the loop where I would need to bail out of the transaction. Seems to reduce the usefulness of @TRANSACTION and structured programming. Any other suggestion? Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, February 01, 2005 10:04 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Transaction Compile Failure END TRANSACTION is at the wrong level in the clip you sent us. Here is an example from the manual. BEGIN TRANSACTION READU data1 FROM file1,rec1 ELSE ROLLBACK READU data2 FROM file2,rec2, ELSE ROLLBACK WRITE new.data1 ON file1,rec1 ELSE ROLLBACK WRITE new.data2 ON file2,rec2 ELSE ROLLBACK COMMIT WORK END TRANSACTION - Original Message - From: Perry Taylor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 01, 2005 9:39 AM Subject: [U2] [UV] Transaction Compile Failure I have an archiving program that I am porting from another platform which I cannot get to compile on UniVerse. I have included a stripped-down test version incorporating the basics below. The compiler seems to have issue with IF @TRANSACTION THEN ROLLBACK END TRANSACTION RELEASE F.HDR, REC.ID END ... as indicated by the compiler message... Compiling: Source = 'PBP/PTEST', Object = 'PBP.O/PTEST' * 13ROLLBACK ^ Cannot COMMIT or ROLLBACK - no transaction. 14END TRANSACTION ^ TRANSACTION unexpected, Was expecting: ';', End of Line 19 UNTIL LEN(ERRMSG) DO ^ WARNING: Text found after final END statement 2 Errors detected, No Object Code Produced. A guess is that the compiler is eating up the END from END TRANSACTION to satisfy IF @TRANSACTION THEN but not sure about that. Anyone have any ideas on what's going on here? Thanks. Perry Taylor -- ERRMSG = '' REC.ID = '' OPEN 'HDR' TO F.HDR ELSE STOP 201,'HDR' OPEN 'HDR.ARCHIVE' TO F.HDR.ARCHIVE ELSE STOP 201,'HDR.ARCHIVE' OPEN 'DET' TO F.DET ELSE STOP 201,'DET' OPEN 'DET.ARCHIVE' TO F.DET.ARCHIVE ELSE STOP 201,'DET.ARCHIVE' SELECT F.HDR LOOP IF @TRANSACTION THEN ROLLBACK END TRANSACTION RELEASE F.HDR, REC.ID END UNTIL LEN(ERRMSG) DO READNEXT REC.ID ELSE EXIT NULL; * SEE IF THE RECORD IS OLD ENOUGH TO ARCHIVE READV HDR.DATE FROM F.HDR, REC.ID, 1 ELSE CRT REC.ID: ' not found in HDR file.' RETURN END IF HDR.DATE DATE() - 90 ELSE RETURN NULL; * OK WE HAVE A KEEPER, LET'S READ THE ENTIRE HDR RECORD, NULL; * TAKING A
RE: [U2] ThoroughBred to U2 file conversion
Wow, I have not heard that name in a while. I had to convert a client off ThoroughBred to a Universe base ERP system many years ago. We never did find a good, direct export function. Instead we printed reports to text files then used a product called Monarch to map these files and covert the data to a format we could import into U2. A bit tedious yes, but it worked fairly well. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Wednesday, January 26, 2005 3:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] ThoroughBred to U2 file conversion Hi guys: I am looking at dumping data held in a ThoroughBred system, which I understand uses its own ISAM/B-Tree file access methods, to delimited flat ascii so that I can then upload onto a U2 database (Universe 10 under AIX 5.2) Does anyone know of software which will do this or is there anyone out there who has done it and could point us in the right direction ? Bob Witney Senior Sage Seer EXPLORE! 1 Frederick Street Aldershot, Hampshire GU11 1LQ, UK Tel: 01252-760329 Fax: 01252 760001 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Richard Taylor/VERTIS is out of the office.
I will be out of the office starting 01/27/2005 and will not return until 01/31/2005. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Edit / Remove a record with no ID
SSELECT the file SAVE-LIST MYLIST EDIT-LIST MYLIST You will probably see the offending item at the top or bottom of the list. To see what is actually in the key try using 'up-arrow' mode in the line editor; Type '^' an redisplay the record. To remove delete from the list all the records you should be KEEPING GET-LIST MYLIST 1 Record selected DELETE file Give it a try. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Adams Sent: Tuesday, January 18, 2005 5:02 PM To: [EMAIL PROTECTED] Subject: [U2] Edit / Remove a record with no ID Running in UniVerse on Windows. I have a select list of say 140 records from a file, then when I drill down further by say a 'list' or 'sort' on the selected list, I only have 139 records shown. I suspect I have a record with no 'real' ID. How can I select and / or remove this record ? Cheers, Simon. ** *** ** This e-mail, including any attachments to it, may contain confidential and/or personal information. If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action based on the information contained within it. Please notify the sender immediately by return e-mail of the error and then delete the original e-mail. The information contained within this e-mail may be solely the opinion of the sender and may not necessarily reflect the position, beliefs or opinions of Salmat on any issue. This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems. For more information, visit our website at www.salmat.com.au. ** *** ** --- 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-piopen TRANS function
I don't know of any configuration setting for this. This is actually a 'feature' of the TRANS function in UV. You could pass in a multi-valued list of keys to translate and get a multi-value list of the entire record back, hence the need to lower the record. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, January 19, 2005 10:05 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UV-piopen TRANS function We are doing a conversion from PI/Open v3.5.r3 on a Prime EXL (mips) to universe 10.1.4 on AIX 5.3, All the occurrences of the TRANS function return the wrong answer, and appear to be lowered. Simple testing indicates that using the RAISE function in front of the TRANS expression returns the correct result. However, we have thousands of occurrences of such in dictionary I-descriptors. Do you know of any global way to tell uv to not require the use of RAISE to produce the correct answer in this case. Or, do you know of a replacement function that will work the way needed? I have searched the archives and found one homegrown subroutine but I can't seem to get it work reliably. Thanks for any help. Andrea Charles --- 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] Uniobjects automation error
I remember having similar problems and the issue came down to how I referenced the library. Are you doing a 'Reference' or a createobject? I think the solution for me was to do a createobject, but it has been awhile. Another thing to keep in mind is that when you work in the IDE sometimes objects and connections persist when you think that they should not. So a program runs in the IDE then blows chow when run independently. Hope those few thoughts help you track it down. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Leckie Sent: Monday, January 17, 2005 9:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] Uniobjects automation error I'm trying to develop a small application using UniObjects with Visual Basic 6.0. Program is running on Windows XP connecting to a UniData database across a TCP/IP connection. I can run the program inside Visual Basic IDE and the program runs fine but when the program is compiled I get an automation error: Run-time error '-2147417848 (80010108): Automation error The object invoked has disconnected from its clients Anyone know why this is and how it can be fixed. I have never seen this type of problem before. -- * This message has been scanned for viruses and dangerous content by * Blairs of Scotland MailScanner, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to which they * are addressed. * * If you have received this email in error please notify us at Blairs * of Scotland via email at [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] Named Common Issues in UV
I used UV subroutines extensively from VB6 and never had any problems. I am not sure at this point how named common was used in that area. I can tell you that my previous company tried to use named common in a manner similar to what you are trying, but this was in straight UV programming. We did experience strange problems with the file variables too. In the end we had to back off on using named common to track file variables as a global solution. This was back in UV 9.6.?. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kryka, Richard Sent: Tuesday, January 11, 2005 12:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] Named Common Issues in UV Has anyone seen any issues with using named common in UV subroutines called by VB6? I ran some tests and determined that named common works in this environment, but have experienced some strangeness since implementing it. We have around 300 UV subroutines, with named common in fewer than 25. The goal is to keep from having to open the files every time the subroutine is called. The problems seem to occur in the routines with named common. Strangeness includes not being able to find a file, and getting data from the wrong file or ID. These 25 routines are used extensively, but the failures happen very rarely and sporadically, so are difficult to monitor. I have temporarily removed the named common to see if the strangeness goes away. All named common names are unique.UniVerse 10.0.10-2 on MS2000 Server. Sample VB6 code: Public Sub Get_Notes() On Error GoTo Form_Err Dim NoteObj As Object Dim ResultArray As Object Dim ArrayIndex As Integer Dim ArrayEnd As Integer Const RETURN_PARAM = 3 Const TOTAL_PARAM = 4 Const PAGE_RETURN = 1 lstNotes.Clear Set ResultArray = CreateObject(UV_DARRAY_OBJECT) Set NoteObj = uvSession.subroutine(VBNOTEPAGE3, TOTAL_PARAM) NoteObj.SetArg 0, txtNoteID.Text NoteObj.SetArg 1, CurPageNo NoteObj.SetArg 2, txtTypeNote.Text NoteObj.Call ResultArray = NoteObj.GetArg(RETURN_PARAM) ArrayEnd = ResultArray.Count If ArrayEnd = 1 Then For ArrayIndex = 1 To ArrayEnd lstNotes.AddItem ResultArray.Field(ArrayIndex) Next ArrayIndex End If txtPageDisplay = Page CurPageNo of PageLimit Form_Exit: Exit Sub Form_Err: MsgBox Error # Err.Number vbCrLf vbCrLf Err.Description, , frmNoteMaint: Get_Notes Resume Form_Exit End Sub Sample UV code: 0001: SUBROUTINE VBNOTEPAGE3(NOTE.ID,NOTE.PAGE,FILE.ID,RET.ARRAY) 0002: * -- 0003: * PROGRAM NAME : VBNOTEPAGE3 0004: * CREATED BY: TODD C. SELLS 0005: * PROGRAMMER: TSELLS 0006: * DATE CREATED : 0007: * -- 0008: * LAST MODIFIED : 0009: * 09/30/04 KRYKA - DISPLAY ONLY FIRST OCCURANCE OF DATE, SHIFT AUTO NOTE S TO RIGHT 0010: * 10/14/04 KRYKA - CLONED FROM VBNOTEPAGE. ADD USER AND TIME 0011: * 10/20/04 KRYKA - ADD NAMED COMMON 0012: * 01/11/05 KRYKA - REMOVE NAMED COMMON 0013: * -- 0014: * -- 0015: * INITIALIZE STANDARD VARIABLES AND INCLUDE FILES 0016: * -- 0017: EQU TRUE TO 1 0018: EQU FALSE TO 0 0019: * -- 0020: * INITIALIZE VARIABLES 0021: * -- 0022: COMMON /VBNOTEPAGE3/ INIT.PATH, 0023: CLIENT.NOTE.MASTER, 0024: DELETED.NOTES, 0025: APPT.NOTES, 0026: CRED.NOTES, 0027: POLICY.NOTES 0028: * 0029: IF INIT.PATH # @PATH THEN 0030: OPEN CLIENT-NOTE-MASTER TO CLIENT.NOTE.MASTER ELSE 0031: RET.ARRAY = CANNOT OPEN CLIENT-NOTE-MASTER FILE 0032: RETURN 0033: END 0034: OPEN DELETED.NOTES TO DELETED.NOTES ELSE 0035: RET.ARRAY = CANNOT OPEN DELETED.NOTES FILE 0036: RETURN 0037: END 0038: OPEN APPT-NOTES TO APPT.NOTES ELSE 0039: RET.ARRAY = CANNOT OPEN APPT-NOTES FILE 0040: RETURN 0041: END 0042: OPEN CRED-NOTES TO CRED.NOTES ELSE 0043: RET.ARRAY = CANNOT OPEN DELETED.NOTES FILE 0044: RETURN
RE: [U2] LOOP or GOTO on READNEXT
I have to weigh in on this a bit. The issue with GOTOs is not one of performance (as someone else pointed out a loop compiles down to GOTOs at a low level) nor is it an instant sign of sloppy code. The problem is that it is far easier to degrade into sloppy code. In a complex program it can make a program much tougher to read maintain for any programmer that follows the original author. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter D Olson Sent: Wednesday, December 29, 2004 10:12 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] LOOP or GOTO on READNEXT the use of goto's or lack of shouldn't be a judge of sloppy coding . sloppy coding is just sloppy coding. remember one persons slop is another persons pudding :) example 1: y=0 loop readnext z else y = 1 if y = 1 then exit do stuff repeat more stuff vs example 2: 10: readnext claim_id else goto 20 do stuff goto 10 20: more stuff vs example 3 loop readnext claim_id else exit do stuff repeat more stuff LoopForEver 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 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] The list format and usefulness
My $0.02 I strongly disagree with this approach. 1) I think you would lose some valuable and useful responses as not all summaries will be posted 2) I like to see the alternative approaches as my particular problem may not be exactly like the one posted, but one of the solutions might well work for me. 3) I can easily delete threads I don't want to read so this is not a bother. I consider the risk of missing useful information more important. (BTW, GOTO's are the root of all evil :) ) 4) In today's world bandwidth is simply not the issue it used to be. Give me the information and let me search. If it is of concern to someone then can select digest mode which would at least control when the impact is seen. I am not say that Dave it doing this, but please don't let this board turn into a place where people get flamed for asking a repetitive or dumb question. I have seen this happen in other forums and it really turns off active participation by all but a few 'elite' members. For me I would rather see folks spend a little more time on the subject line to make searching easier then worry about posting summaries. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Logan, David (SST - Adelaide) Sent: Monday, December 20, 2004 7:41 PM To: [EMAIL PROTECTED] Subject: [U2] The list format and usefulness Hi Folks, After becoming a little frustrated of seeing and reading the same old stuff, day in and day out, and IMHO the list not having the same useful content as previously, I have number of suggestions. With a number of other groups, a different format is used, a question is asked, replies are sent directly to the person asking the question and this person then summarises for the groups benefit. This has couple of immediate advantages : 1) stops arguments on the relative benefits of a GOTO over a LOOP for the 53rd time. (30 replies on the last one). 2) stops multiple answers clogging bandwidth of everybody on the list. eg. being told how to MAT var = '' 9 times. People need to also have a little more discipline and perhaps utilise the community list when appropriate. I choose not to subscribe so am not aware if it gets much of a hammering but perhaps it could do with a little more. This format provides that discipline. I am aware there useful posts and the responses can be very helpful but we could also promote the use and searching of the archives prior to posting. This would trim down a number of the duplicate posts. I feel these simple measures would cut down considerably on duplicate and unnecessary traffic. Donning asbestos underpants now. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax --- 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] uvodbc truncating field
SQL statements are limited by the SQL definitions held at the end of the dictionary item. These fields contain both a type and a length. SQL standard requires that these be strongly applied so data that is acceptable to U2 will give a data type error if the wrong SQL type is used and the field will be truncated to the maximum length defined. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills Sent: Friday, December 03, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: [U2] uvodbc truncating field I've wrote a small program to return a record set of part numbers and part descriptions. Then I wrote a data query under MS Excel and ran the SQL process as follows- { CALL TALKTOME (19) } I get 2 columns returned, the first being the part numbers, but for some reason the part descriptions are being chopped at 8 characters. Here is the subroutine- 0001 SUBROUTINE TALKTOME(CPN) 0002 OPEN ITMMST TO IM ELSE GOTO 99 0003 EXECUTE SELECT ITMMST = ':CPN:]' 0004 MOREDATA=1 0005 DARRAY= 0006 LOOP 0007 READNEXT ITMKEY ELSE MOREDATA=0 0008 WHILE MOREDATA 0009 READ IM.REC FROM IM,ITMKEY ELSE GOTO 99 0010 PNBR=IM.REC1 0011 DESC=IM.REC2 0012 IF DARRAY THEN DARRAY := @FM 0013 DARRAY := PNBR:@TM:DESC 0014 REPEAT 0015 SELECTN DARRAY TO 9 0016 ST=SQLExecDirect(@HSTMT, SELECT F1,F2 FROM @TMP SLIST 9 ORDER BY 1) 0017 RETURN 0018 99: 0019 PRINT ERROR IN OPEN OR READ FOR ITMMST 0020 RETURN 0021 END I am using the technique described in the UCI documentation for Universe 10.0.16. It is discussed in chapter 6. Anyone have any ideas what would cause this? Thanks in advance -- Rod Hills --- 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] PICK Assembler Language
I think the basic concept here has very little to do with any kind of low-level tweaking or variations on versions. Let me explain by example: Software I used to work in had a financial ledger for material transactions that could get to be VERY large. If I wanted to run a Account analysis for a particular period it was always faster to do an initial select based on date (particularly if you indexed that field :) ), then doing the additional selects and sorts on the lesser record pool. My rules were to try and do non-sorted selects first on fields that are indexed and/or do not involve wild cards. Then do the any additional selects and the sorting in a stacked statement. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 11, 2004 2:01 PM To: [EMAIL PROTECTED] Subject: Re: [U2] PICK Assembler Language With one exception, I agree with Charlie. Just because the hardware speeds allow us to write crap doesn't mean we should. There is, of course, a limit to cycle-tweaking. I am not going to spend my time looking for the fastest way to prepend a floating dollar sign, for example. If I have a case of a large number of transactions triggering secondary reads (code file lookup, for example), I will certain take a few minutes to 'ask the system' if a dynamic array cache with locate would be worthwhile. The exception I mention is done once in the development cycle. What was efficient at release x may not be efficient at release y. Thus I am a big proponent of constant refactoring. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ [EMAIL PROTECTED] wrote: Just because we have a quadrillion microseconds to play with, instead of a 50 millisecond timeslice, doesn't mean we have to waste them. A few moments to consider performance, done once in the development cycle, will pay benefits every time a more efficient program is run. I have to believe that Adm Grace Hopper is smiling down on you both. Regards, Charlie Noah --- 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] PICK Assembler Language
-Original Message- snip I can't imagine anyone on this forum having to break up this sentence likewise on the current platforms. On this client's older MCD, it truly makes a difference. /snip - Ah, Mark..I do this all the time for the performance reasons mentioned :) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse to Linux mySQL
Our company does some work with U2 interfaced to a website and we are looking at doing more. You might want to check-out the MV/Internet product. This basically allows you to have a website that can talk directly to a Universe database. You write your site scripts in UniBasic and do cgi calls to interact with them (very rough description). We are just starting with this tool, but from what I have seen so far this is definitely the way to go if you want to put U2 data and functions out to a website. Another method would be to interface your MySql tables to Universe using ODBC or code written using the UniObjects api. Your call, it depends on what you have setup for security, existing web code, and requirements. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAREN LORD Sent: Friday, November 05, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: [U2] UniVerse to Linux mySQL I am a bit of novice when it comes to the UniVerse database but I am trying to dive into it and learn as much as I can. I am also new to the mailing list, so my apologizes if I have gone about this the wrong way. My problem is this: I am running an AIX 4.3.3 with UniVerse database 10.1 installed. I am hosting my companies website from Linux running the osCommerce shopping cart that backends all the information in a mySQL database. Instead of having to type in all 250,000 items into the mySQL database, I want to real time the lookups with our own database. Is there a way for mySQL to look up the tables in UniVerse, or is there a better way? Thanks for the help Daren Lord [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/
RE: [U2] Uniobjects.NET speed/performance
I certainly don't want this to become a compiler war, but for the sake of a alternate opinion. I would agree with another post in that you can code efficient code in .net. You DO need to override some of the defaults assumed by the ide when you create project though. It seems like MS wants to reference everything under the sun when you create a project. I have written some extensive applications in VB 6.0 (interfaced to Universe using Uniobjects to emulate and ADO-like interface [keeps me on topic :)]). I would have greatly appreciated the improvements in .net where I can gain access to more of what VB6 hid from the developer. Being more of a real object oriented language helps too. Just my $0.02 Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Friday, November 05, 2004 4:24 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Uniobjects.NET speed/performance I find .net to be slow and cludgy in virtually all situations - even with a fast processor and 512MB RAM. I've been completely unimpressed with it since it was released. The classes never seem to expose what I need, and you don't get source code to feel safe changing them. The WebForms are primitive and ugly to work with, there isn't enough cross-platform support to justify the run machine, and the only thing advantage seems to be that it doesn't use COM to bind everthing. Web services are cool, but there are other tool to create those, and the .NET version needs tailoring to work with many web service clients. I understand the advantages of turning the WinAPI into a class structure (the old WInAPI was horrible to use) but there are far better wrappers already out there. It just seems another piece of M$ bloatware that really doesn't deliver enough new quality functionality to justify the performance overheads. If you want a truly fast, clean, fully OO environment that delivers the WinAPI in a sensible structure, provides all of the functionality you could require, doesn't rely on installing huge run machines and a stack of libraries, offers source code to the class libraries and is designed for professionals, use Delphi. Yes it has a learning curve, but it is still vastly better than any other Windows tool around. My 2 cents. Brian used VB and Delphi since version 1 Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kate Stanton Sent: 05 November 2004 00:37 To: [EMAIL PROTECTED] Subject: Re: [U2] Uniobjects.NET speed/performance Yes! We found it so slow we immediately reverted to the VB3 version, while seeing if we can find a way around it. We have put very little time into it since - rather discouraged. - Original Message - From: Chris Ahchay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 04, 2004 11:27 PM Subject: [U2] Uniobjects.NET speed/performance Is anyone else experiencing speed problems with Uniobjects.net? I've just upgraded our core application from Uniobjects to UONET (a non-trivial exercise as I'm sure you're aware) but the response times are atrocious. Opening a file has gone from being a virtually instant response to taking well over a quarter of a second. Any thoughts? Cheers Chris --- 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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PICK Assembler Language
IBM mainframe assembler difficult??? Not really, compared to microprocessor assembly it was almost a high-level language. I had a lot of fun with it way back when. Never used it in 'real' life, but it was fun. Ok, so I'm a geek. What can I say? :) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Friday, November 05, 2004 4:07 PM To: [EMAIL PROTECTED] Subject: RE: [U2] PICK Assembler Language I learned assembly on the IBM 370. Took two whole years of it. What a waste of time...never used it once. My teacher was an ex IBM employee that used to exclusively write I/O routines. Last I heard he had gone insane. This gives a bit of insight into the difficulty of that language. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chuck Mongiovi Sent: Friday, November 05, 2004 11:42 To: [EMAIL PROTECTED] Subject: RE: [U2] PICK Assembler Language Pick *has* an assembly language???!!! Back when PICK ran native instead of under Unix (or whatever) .. And some of us even programmed in it .. -Chuck --- 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] telnet problem
Well, one thing I can see and that is the 192 address is internal only. The actual STATIC IP of your connection is the only thing the outside world sees. You will either need to setup the router to forward that port to the internal address you mentioned or enable VPN tunneling. I have a similar internet connection setup and I have tried the latter, but never had any success in getting the VPN to work. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Smith Sent: Tuesday, November 02, 2004 4:28 PM To: [EMAIL PROTECTED] Subject: [U2] telnet problem Hi all - need your help. I am trying to telnet to a windows 2003 machine that is running unidata 6.1 from the outside world. Having no success. Cox-internet -- static IP - cable modem - LinkSys BEFSR41 V3 router / hub - 3 machines One of the machines (windows 2003) has a static ip of 192.168.1.201. Can not telnet to the 192.168.1.201 from outside - can another give me the correct settings or any other help Does Unidata listern on the regular telnet port 23 ?? Thanks grs --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connect to an access database
Many people have emailed to ask for the attachment since it got filtered. I am inserting it as text below my signature. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 **\/\/\/\/\/\//\/\/\/\/\/\/\/ $INCLUDE UNIVERSE.INCLUDE ODBC.H * PROGRAM = 'SOSHIP.UPDATE' ERROR.NO = 0 *--- *Preparing the SQL processes *--- SQL.OK = TRUE ; * error flag for sql processes SQL.STATUS = ClearDiagnostics() * setup the ODBC connection to the SOSHIP.mdb file SQL.STATUS = SQLAllocConnect(@HENV,SOSHIP.MDB.CONNECT) IF SQL.STATUS SQL.SUCCESS THEN MESSAGE = Could not establish a connection to the Access workspace: MESSAGE := Failed to allocate a CONNECTION environment GOSUB ERROR.PROCESS SQL.OK = FALSE END IF SQL.OK THEN GOSUB MDB.CONNECT END; * endif sql.ok (SOSHIP.MDB.CONNECT) * Setup the ODBC connection to the LOCAL UV account SQL.STATUS = SQLAllocConnect(@HENV,SOSHIP.UV.CONNECT) IF SQL.STATUS SQL.SUCCESS THEN MESSAGE = Could not establish a connection to the Universe Database environment: MESSAGE := Failed to allocate a CONNECTION environment GOSUB ERROR.PROCESS SQL.OK = FALSE END IF SQL.OK THEN SQL.STATUS = SQLConnect(SOSHIP.UV.CONNECT,localuv,'','') IF SQL.STATUS SQL.SUCCESS THEN MESSAGE = Could not establish a connection to the Universe Database environment: MESSAGE := Failed to connect to data source GOSUB ERROR.PROCESS SQL.OK = FALSE END END; * endif sql.ok (SOSHIP.UV.CONNECT) * setup customer table transfer sql statement environments SQL.STATUS = SQLAllocStmt(SOSHIP.UV.CONNECT,CUSTOMER.SEL.STMT) IF SQL.STATUS SQL.SUCCESS THEN MESSAGE = Could not access the CUSTOMER file in Universe: MESSAGE := Failed to allocate a STATEMENT environment (select) GOSUB ERROR.PROCESS SQL.OK = FALSE END SQL.STATUS = SQLAllocStmt(SOSHIP.MDB.CONNECT,CUSTOMER.INS.STMT) IF SQL.STATUS SQL.SUCCESS THEN MESSAGE = Could not access the CUSTOMER file in Universe: MESSAGE := Failed to allocate a STATEMENT environment (insert) GOSUB ERROR.PROCESS SQL.OK = FALSE END * SQL statement objects to access SOSHIP.MDB parts Allocations table SQL.STATUS = SQLAllocStmt(SOSHIP.MDB.CONNECT,SOSHIP.PARTS) IF SQL.STATUS SQL.SUCCESS THEN MESSAGE = Could not access the SOSHIP parts allocations table in SOSHIP.mdb: MESSAGE := Failed to allocate a STATEMENT environment GOSUB ERROR.PROCESS END * SQL statement objects to access SOSHIP.MDB Order Allocations table SQL.STATUS = SQLAllocStmt(SOSHIP.MDB.CONNECT,SOSHIP.ORDERS) IF SQL.STATUS SQL.SUCCESS THEN MESSAGE = Could not access the SOSHIP Orders Allocations table in SOSHIP.mdb: MESSAGE := Failed to allocate a STATEMENT environment GOSUB ERROR.PROCESS END IF NOT(SQL.OK) THEN CLOSE SOSHIPF STOP END; * endif not(sql.ok) ... *--- * End of SQL Preparation *--- LOOP SQL.STATUS = ClearDiagnostics() SQL.OK = TRUE GOSUB RESET.SQL.STATEMENTS GOSUB PREPARE.SQL.INSERT.COMMANDS IF NOT(SQL.OK) THEN EXIT SQL.STATUS = ClearDiagnostics() ' code removed UNTIL RET.VALUE1 = CANCEL DO SOSHIP.ID = PART.NO:*:LOCATION * get the inventory balance and part description INV = RAISE(TRANS('INV',PART.NO,-1,'X')) LOCATE(LOCATION,INV,2;LOC.VMC) THEN INV.BAL = OCONV(INV3,LOC.VMC,'MR4') END ELSE INV.BAL = 0 END ; * endlocat(location,inv PART.DESC = TRANS('PARTS',PART.NO,1,'X') * calculate header totals ALLOC = OCONV(SUM(SOSHIP14),'MR4') ON.ORDER = OCONV(SUM(SOSHIP4), 'MR4') BACKORDER = ON.ORDER - ALLOC NUM.ORDER = 0 NUM.CUST = 0 * select the customer data add to soship.mdb database