Re: [U2] Re: ODBC Connection Hanging Around

[Richard Taylor]

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

[Richard Taylor]

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.com>To 
 Sent by:  "'u2-users@listserver.u2ug.org'"
 [EMAIL PROTECTED]   
 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 '  '
  crt 

[U2] Richard Taylor/VERTIS is on vacation

[Richard Taylor]

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.

[Richard Taylor]

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

[Richard Taylor]

Jim,

You have two choices:

First you can pass in @RECORD 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:
 [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

[Richard Taylor]

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/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  06/02/2007 and will not return until
06/18/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] Why does the IF statement think these values are different?

[Richard Taylor]

   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: 
   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

[Richard Taylor]

   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: 
   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

[Richard Taylor]

   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: 
   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

[Richard Taylor]

   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

[Richard Taylor]

   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.

[Richard Taylor]

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

[Richard Taylor]

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/

RE: [U2] [EMAIL PROTECTED] - Email has different SMTP TO: and MIME TO: fields in the email addresses - RE: [U2] Steve Cashman

[Richard Taylor]

While I could hope for a better solution, what you suggest is not
realistic for some of us who work in large companies with many locations.

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 Jerry Banker
> Sent: Monday, February 27, 2006 2:37 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [EMAIL PROTECTED] - Email has different SMTP TO: and MIME
> TO: fields in the email addresses - RE: [U2] Steve Cashman
> 
> There is another option. Don't use auto-response messages. After all if
> the
> people in your office don't know you're gone then you've got to start
> interfacing more with the people you work with. If they don't notice
when
> you're gone then they probably don't notice when you're there.
> 
> - Original Message -
> From: "Glen B" <[EMAIL PROTECTED]>
> To: 
> Sent: Saturday, February 25, 2006 2:57 PM
> Subject: [U2] [EMAIL PROTECTED] - Email has different SMTP TO: and MIME TO:
> fields in the email addresses - RE: [U2] Steve Cashman
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Is there a Better Editor?

[Richard Taylor]

First, one comment, I believe that SE is an editor provided by System
Builder rather than directly in UniData.

As far as other Editors, if you are looking to work on items that are
stored in a DIR type file I would recommend UltraEdit.  This is a function
rich Windows based editor.  You can communicate with Unidata via FTP.  I
have had no problems doing this.  You can also get a configuration file
that allows you to have syntax highlighting for UniBasic.

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: Wednesday, February 22, 2006 8:59 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Is there a Better Editor?
> 
> Michael Caskey <[EMAIL PROTECTED]> wrote on Tue, 21 Feb 2006 16:10:06 -
> 0700
> 
> > I have been tasked with creating reports from our UniData
> > system using UniQuery. ...
> >
> > 1. Is there a better way to run these queries?
> > and
> > 2. Is there a better query editor; text-based or GUI or both?
> 
> Others have posted suggestions for external tools, but assuming you
don't
> have access to these, there are some things you can do within UniData to
> simplify your life a bit.
> 
> There are three editors that come with UniData: ED, AE and SE.  ED and
AE
> are line editors, and AE is the more powerful one.  Our system has ED
> remapped to AE, so we don't use ED at all.  SE is a screen editor, and
> some
> find it easier to use.
> 
> If you are setting up queries that you need to run on a regular basis,
> consider using UniData Paragraphs.  These can be run from the TCL prompt
> as
> commands once they're written.
> 
> Paragraphs are stored in VOC, and are similar to DOS Batch files.  You
can
> specify parameters and save queries for future use.  You can also put
> several commands together to create a process.
> 
> There are a few native ones that you can look at for reference.  Here
are
> three from our UniData/AIX system.
> 
> LISTDICT is used to list dictionary items.  The syntax is LISTDICT  NAME> [LPTR]
> 
> Top of "LISTDICT" in "VOC", 8 lines, 317 characters.
> 001: PA
> 002: IF <> = '' THEN GO L100
> 003: IF <> = 'LPTR' THEN GO L200
> 004: IF <> # 'lptr' THEN GO L100
> 005: L200: SORT DICT <> TYP LOC CONV MNAME FORMAT SM ASSOC
> BY
> TYP BY LOC BY @ID LPTR
> 006: GO DONE
> 007: L100: SORT DICT <> TYP LOC CONV MNAME FORMAT SM ASSOC
> BY
> TYP BY LOC BY @ID
> 008: DONE: *
> 
> Note that Attribute 1 is set to PA to indicate that this is a paragraph.
> The lines after that are processed.  Parameters are specified using
double
> angle brackets, and contain two fields.  The first field indicates the
> parameter type (I=Required Input, C=Conditional Input) and position.
The
> second field is a prompt to identify the parameter, and will be used if
a
> required input is not specified.
> 
> I wrote LP to list print jobs waiting to print in our AIX queues.  If no
> queue is specified, all items in all queues are listed, otherwise only
the
> specified queue is listed.  Note that I'm executing AIX commands from
TCL
> by prefixing the command with the "!" character.
> 
> Top of "LP" in "VOC", 6 lines, 96 characters.
> 001: PA
> 002: IF <> = '' THEN GO L100
> 003: !lpstat -p<>
> 004: GO DONE
> 005: L100: !lpstat | more
> 006: DONE: *
> 
> CP is a simple paragraph to alias the SPOOL command.
> 
> Top of "CP" in "VOC", 2 lines, 38 characters.
> *--: P
> 001: PA
> 002: SPOOL <> <>
> 
> Check the manuals for more help, or feel free to drop me a line
off-list.
> 
> --Tom Pellitieri
>   Toledo, Ohio
> ---
> 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] Training resources in India.

[Richard Taylor]

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/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  12/23/2005 and will not return until
01/03/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] MVInternet Replacement

[Richard Taylor]

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-life"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 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

[Richard Taylor]

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

[Richard Taylor]

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
> 
> 
> > 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

[Richard Taylor]

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.

[Richard Taylor]

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.

[Richard Taylor]

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.

[Richard Taylor]

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.

[Richard Taylor]

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.

[Richard Taylor]

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.

[Richard Taylor]

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.

[Richard Taylor]

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.

[Richard Taylor]

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.

[Richard Taylor]

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] Unidata TCL - beginner question - correction

[Richard Taylor]

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] Lock Management (was part of 'Good Programming Practice')

[Richard Taylor]

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.



> 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] more serious notes on GOTO

[Richard Taylor]

Ross,

Please tell me you are kidding.  RETURN TO is worse than using a GOTO.
You think you are dealing with a nice neat subroutine and then the
'hidden' goto in the return bites you.

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: Wednesday, October 05, 2005 8:42 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] more serious notes on GOTO
> 
> Personally I prefer the RETURN TO syntax - all the 'elegance' of
> subroutines, with the bonus of conditional exits. Now THAT was a "nice
> innovation" in the language
> 
> Ross Ferris
> Stamina Software
> Visage > Better by Design!
> ---
> 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] more serious notes on GOTO

[Richard Taylor]

> From my experience working with a team of different developers this is
the
> worst possible and a very selfish scenario a developer might choose to
> follow. This is why in many cases the longer code exist the worse it is
> getting.
> GOTOing out of a jam simply add more garbage to the pot of garbage the
> code
> you describe is. I always insist that developers understand the code
they
> change before making any change and that the code is getting better not
> worse after they made that always urgent and small modification to it.

While I agree with you in principle, reality sets in real quick.
Sometimes you simply don't have the luxury of time & resources to
completely rewrite a module to bring the code up to today's standards.
This is especially true if you are a consultant that is being paid to
provide a specific solution, not update the entire code base.  I HATE this
too, but that is life.

Having said that, I still firmly believe that GOTO's are to be avoided at
all costs.  Yes, if you are careful you can write well structured code
using GOTO's, but what about the guy after you or next to you?  We don't
code in a vacum.  Using GOTO's creates code that is just too delicate.  If
you think you need to use one think about it again and be real sure.

When you think about it some of the newer commands are really modified
GOTO's.  Commands linke EXIT and CONTINUE jump to specific code lines. The
difference is that they are dynamic in that the jump point moves
appropriately as you change code.

< (The BNF is the table of valid statements.)>
 I have not heard reference to BNF grammars in a lnnng time.

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 Serguei
> Sent: Wednesday, October 05, 2005 3:45 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] more serious notes on GOTO
> 
> - Original Message -
> From: "Tony Gravagno" <[EMAIL PROTECTED]>
> To: 
> Sent: Wednesday, October 05, 2005 4:54 AM
> Subject: RE: [U2] more serious notes on GOTO
> 
> 
> 
> > Rather than completely re-writing client code to
> > my sense of what nice code looks like it's occasionally much easier to
> GOTO
> > to get out of a jam that someone else created.
> 
> 
> > - Because in the internal bowels of the BASIC compiler and runtime we
> find
> > that all GOSUBs are actually GOTOs with a little extra code.  The only
> > difference is that on a GOSUB you push the address of the next
> instruction
> > onto a stack before the jump.
> 
> Any compiler from any programming languages do that. But it does not
mean
> that we program in assembler all the time, does it?
> 
> > - Because almost all languages have some form of GOTO and we'd see as
> many
> > "why isn't there a GOTO" here if it wasn't in UniBasic.
> 
> Java does not have it.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] the 4 letter word

[Richard Taylor]

You mean {Gasp..cough}  it's not {hack}

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 Serguei
> Sent: Wednesday, October 05, 2005 3:47 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] the 4 letter word
> 
> And the next thing GOTO supporters will try to prove to us is that the
> smoking is good for you? :)
> 
> - Original Message -
> From: "Bruce Nichol" <[EMAIL PROTECTED]>
> To: 
> Sent: Wednesday, October 05, 2005 3:58 AM
> Subject: RE: [U2] the 4 letter word
> 
> 
> > Goo'day, Stuart,
> >
> > At 12:19 05/10/05 +1000, you wrote:
> >
> > >I'd say it's more like collecting cigarette butts out of rubbish
> bins,
> > >wrapping the tobacco in old fish and chip paper and inhaling
> deeply...
> >
> > Just goes to show how much you know about the subject. 
> >
> > You have to light it  before inhaling.   If you don't, it lasts a
> *bit*
> > longer, but the full aroma and taste are just not there
> >
> > >If  you're an indigent nicotine addict, it's still satisfying,
you
> get
> > >your  hit  no  matter  what  and  you  don't  care if anyone
tells
> you
> > >otherwise. ;-)
> > >
> > >-Original Message-
> > >
> > >  The-command-that-must-not-be-named  is  like a fine cigar. You
> know
> > >  you
> > >  shouldn't.  You know it's bad for you. Nonetheless, it's
> satisfying
> > >  when
> > >  done right.
> > >
> > >
> **
> > >
> > >This email message and any files transmitted with it are
> confidential
> > >
> > >and intended solely for the use of addressed recipient(s). If you
> have
> > >
> > >received  this  email  in  error please notify the Spotless IS
> Support
> > >Centre (+61 3 9269 7555) immediately, who will advise further
> action.
> > >
> > >This footnote also confirms that this email message has been
> scanned
> > >
> > >for the presence of computer related viruses.
> > >
> > >
> **
> > >---
> > >u2-users mailing list
> > >u2-users@listserver.u2ug.org
> > >To unsubscribe please visit http://listserver.u2ug.org/
> > >
> > >
> > >--
> > >No virus found in this incoming message.
> > >Checked by AVG Anti-Virus.
> > >Version: 7.0.344 / Virus Database: 267.11.10/119 - Release Date:
> 04/10/05
> > >
> > >
> > >
> > >
> > >--
> > >No virus found in this incoming message.
> > >Checked by AVG Anti-Virus.
> > >Version: 7.0.344 / Virus Database: 267.11.10/119 - Release Date:
> 04/10/05
> >
> > Regards,
> >
> > Bruce Nichol
> > Talon Computer Services
> > ALBURYNSW 2640
> > Australia
> >
> > http://www.taloncs.com.au
> >
> > Tel: +61 (0)411149636
> > Fax: +61 (0)260232119
> >
> > If it ain't broke, fix it till it is!
> >
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.344 / Virus Database: 267.11.10/119 - Release Date:
> 04/10/05
> > ---
> > 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] Lock Management (was part of 'Good Programming Practice' )

[Richard Taylor]

Well, there may be situations where this would be an acceptable practice.
For most general maintenance screens and functions I would not do this.
You will not have happy users if they spend an hour entering a large
purchase order only to find that someone else has modified a file that is
to be update while they were working.  Yes, you could do some work to code
around that, but why?  If you are going to update a record (and the update
is a replace and not adding to a statistics file) then you should lock the
record as soon as possible and keep it locked until you write 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:owner-u2-
> [EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney
> Sent: Friday, September 30, 2005 11:14 AM
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] Lock Management (was part of 'Good Programming
> Practice' )
> 
>   How about not locking records until you really are going to write
> them. I worked in several places where this was done. There was a
concept
> of
> before and after images. At a user request for update, the record was
> reread
> setting the lock. At this point the program was aware of the before
image
> (prior to this user updating anything), the after image (what the
current
> user had updated) and the current image (the locked record from the data
> base). These three images of the record were compared to see if anybody
> else
> had updated the same fields the current user was updating. If not, the
> record was written to the data base. If conflicts were found, the
current
> user was notified that someone else had updated this record, and their
> changes would have to be redone.
> 
>   One other complication is if there are many writes associated with
a
> transaction. You either have to use transaction logging/journaling to
> commit/rollback the transaction, have a loop to read/lock all the
records
> before updating anything for the current screen, or have a home grown
> process to roll back the before images. The place where I used this
> concept
> the most was in the early 80's before TRANSACTION.START and
> TRANSACTION.COMMIT were around. So we had a home grown commit/rollback
> system. It worked well for a now  defunct Pick Billing application from
> around 1985 to 1999. (Year 2000 scared the last company into
converting).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Good Programming Practice Question.........

[Richard Taylor]

Sometimes the choice is not ours.  This could be a complex algorithm or a
particular workflow that is difficult to code without getting tricky.  It
will help people that look the program later to know why this was done and
what the code is attempting to accomplish.

As programmers we need to remember out job is NOT to make our job easier.
If the solution that works for the client requires we get 'tricky' in code
then we do.

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 Serguei Poliakov
> Sent: Thursday, September 29, 2005 5:10 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Good Programming Practice Question.
> 
> I thinks the better to say - if the code looks tricky, there is
something
> wrong with it. The advice would be - don't write tricky-looking code. :)
> 
> Serguei
> 
> - Original Message -
> From: "Dianne Ackerman" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, September 27, 2005 7:56 PM
> Subject: Re: [U2] Good Programming Practice Question.
> 
> 
> > I like these and would add another one - Add comments to
tricky-looking
> > code!
> > -Dianne
> >
> > David A. Green wrote:
> >
> > >I've been teaching UniBasic for over 10 years and here are some of
the
> > >methods I teach:
> > >
> > >* Subroutines should only have one job.
> > >* Subroutines should be short. (less than 10 lines)
> > >* Subroutines should have one entrance and one exit.
> > >* Use meaningful variable names and subroutine names.
> > >* Be consistent in your naming conventions.
> > >* Don't hard code Numbers, Strings, or Attributes.
> > >* Use CASE over IF...THEN when there are more than two options.
> > >* Use LOOP...WHILE/UNTIL...REPEAT over FOR...NEXT with IF Conditions.
> > >* Use REMOVE to traverse a dynamic array.
> > >* Use a Simple Variable on Conditional Statements.
> > >* Use UniData Internal Variables whenever possible; i.e. @AM, @VM,
> @DATE.
> > >
> > >Thank you,
> > >David A. Green
> > >DAG Consulting
> > >(480) 813-1725
> > >www.dagconsulting.com
> > >
> > >
> > >-Original Message-
> > >From: [EMAIL PROTECTED]
> > >[mailto:[EMAIL PROTECTED] On Behalf Of Fawaz
Ashraff
> > >Sent: Tuesday, September 27, 2005 8:23 AM
> > >To: u2-users@listserver.u2ug.org
> > >Subject: [U2] Good Programming Practice Question.
> > >
> > >Hi All,
> > >
> > >We are planning to train some of our new programmers
> > >to use good programming practices when using U2 Basic.
> > >I can remember in Unidata days us having some tech
> > >support documents that talked about this. Example such
> > >as when is the best time to use CASE instead IF & ELSE
> > >or not to use GOTO statments.
> > >
> > >I am sure some of you may have some input in this
> > >topic. If you have some documents, notes or thoughts
> > >on this, can you please share with us?
> > >
> > >When I get all the technical tips, I can compile this
> > >to a document and share with our new programmers as
> > >well as U2 listserver community.
> > >
> > >Thanks
> > >
> > >Mohamed
> > ---
> > 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] Good Programming Practice Question.........

[Richard Taylor]

I would agree with this in principle.  Now I will tell you that I have
(and still do) use this type of commenting.  What we found we had to do at
my last job with a software company was clean out in-line change comments
that were more than two releases prior.  When making large number of small
changes in the code I would also indicate in the revision history that
individual changes are not commented and not do the in-line comments.

I would agree that with a good source-code control program and/or
procedure and the ability to do compares between versions you could
successfully not comment the changes.

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 Jeff Schasny
> Sent: Wednesday, September 28, 2005 11:56 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> I've got to disagree with this one. This is the job of your source code
> control system. I've seen applications which were commented in this
manner
> over a number of years and they are almost unreadable due to the sheer
> volume of mod tags.
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED] Behalf Of Marilyn Hilb
> Sent: Wednesday, September 28, 2005 8:48 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> 
> Two items I have thought of.
> 
> 1. In addition to putting a modification tag at the top of the code with
> who/date/what, we also will assign a job number to the mod in addition
to
> a
> No for the mod. Such as mod 01. Then throughout the code where the
changes
> are made we put a tag such as *<<01>> start  and *<<01>> end or, just a
> single tag at the end of the line if only one or two lines being
changed.
> This makes the changes very easy to search for and spot should there be
> problems in the new code.
> [snip]
> ---
> 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.........

[Richard Taylor]

I forgot about that one.  I do the same thing with most commands that have
an THEN-ELSE-END structure.  I add the command to the final end

IF ERROR.STATUS = 1 THEN
   ...commands...
END ELSE
   ...commands...
END; * if error.status = 1 ...

> Since the RETURN statement actually has 2 meanings, I add a comment at
the
> end of the RETURN that concludes a called subroutine, especially if
there
> are internal subroutines within it.
> 
> RETURN ;* TO 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
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Good Programming Practice Question.........

[Richard Taylor]

I would add a few:

1) no multi-command lines (i.e.  command ; command; command

2) Use Continue and Exit inside loops to handle error conditions.

3) I then to prefer the following for working with select lists
LOOP WHILE READNEXT ITEM.ID DO
Some commands
REPEAT

4) No MATREAD & MATWRITE.  Some will probably disagree, but to me this
takes a wonderfully dynamic system and hamstrings it.  I have also seen
data corruption happen when you have a large file dictionary than the
array dimension.  This is definitely platform dependant though.  Unidata
just puts all remaining fields into the last array position.  If you then
change that position expecting it to be just the one field you want to
work with, the remainder of the data is lost.  Universe behaves
differently, but I still don't think using these commands is a good idea.


Ok, let the flame war begin.

5) Proper variable names; no single character variables, variable names
should indicate there purpose.

6)INDENT YOUR CODE.  This may be obvious to most here, but I have worked
with programmers that seem to have a phobia about this.

Generally, I have always had three general rules that I apply up front.
All the specific standards created work to support those three rules.

1) A program must work.  By that I mean that it solves the client's
problem and gives them what they need.  It is NOT simply that the program
was syntactically or even logically correct.

2) The code must be readable by any one.  Indentation, comments, variable
names are things that support this.

3)  The code must be maintainable.  Proper structure, NO use of the
'command-that-must-not-be-named'

One other thought, since you are talking about new programmers.  You will
likely need to train them on proper testing/debugging technique.  The
basic mistake I see many programmers make in testing is that they test to
see that it works.  What you should be doing is trying to break it!  Lord
knows the users will.

That is my $0.02 such as it is.

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] Good Programming Practice Question.........

[Richard Taylor]

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] Good Programming Practice Question.........

[Richard Taylor]

The problem with numeric labels is:

1) they are not self-documenting WHERE USED.  The comment at the
definition of the routine does not help you here.

2) There is not complier requirement that the labels be in order and more
often than not, either through laziness or mistake, the labels get out of
order.

Any good editor has search capability (my favorite is UltraEdit) so
locating the subroutine should not be a problem.

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 Kevin King
> Sent: Tuesday, September 27, 2005 4:04 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> 
> Numeric labels are good.  Not ordering or commenting them is bad.  And
> not putting comments around all labels to make them more easily
> distinguished from the rest of the program is near unforgiveable.
> 
> -K
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Allen E.
> Elwood
> Sent: Tuesday, September 27, 2005 12:40 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> My addition to this would be to use alphanumeric labels, and to *have*
> a main calling section.  A main calling section that looks like:
> 
> GOSUB OPEN.AND.INIT
> GOSUB SELECT.FILE
> GOSUB PRE-PROCESS.VALIDITY.CHECKS
> GOSUB PRINT.INVOICES
> GOSUB UPDATE.FILES
> 
> Looks so much better and is so easier to figure out than
> 
> GOSUB 100
> a bunch of statements
> a bunch of statements
> a bunch of statements
> GOSUB 1250
> a bunch of statements
> a bunch of statements
> a bunch of statements
> GOSUB 1375
> a bunch of statements
> a bunch of statements
> a bunch of statements
> GOSUB 4000
> a bunch of statements
> a bunch of statements
> a bunch of statements
> GOSUB 9755
> a bunch of statements
> a bunch of statements
> a bunch of statements
> 
> IMNSHO - *=aee=*
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of George Gallen
> Sent: Tuesday, September 27, 2005 12:12
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> 
> Also, how about a change log at the top of the program
>   that lists, who, when and what/why a change was made.
> 
> add to that a short description as to what the function
>   of the program is for.
> 
> * this program does .
> *
> *
> * date who changes made
> * date who changes made
> 
> *
> 
> George
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Dianne
> Ackerman
> Sent: Tuesday, September 27, 2005 2:57 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Good Programming Practice Question.
> 
> 
> I like these and would add another one - Add comments to
> tricky-looking code!
> -Dianne
> 
> David A. Green wrote:
> ---
> 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/
> 
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.11.7/112 - Release Date:
> 9/26/2005
> ---
> 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: Named Common

[Richard Taylor]

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

[Richard Taylor]

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. 

>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

[Richard Taylor]

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

[Richard Taylor]

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

[Richard Taylor]

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] dll File (u2libeay32.dll)

[Richard Taylor]

A quick search of my hard drive (with a local UV installation) turned up
three different versions (distinguished by Modified dates) in 5 different
folders.  This would seem to support this theory.  The most recent version
appear to be in the C:\IBM\UniDK\bin.

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 Tony Gravagno
> Sent: Tuesday, July 19, 2005 9:06 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] dll File (u2libeay32.dll)
> 
> The fact that renaming it makes things work OK seems to point out a
> versioning issue.  This file is based on SSLEAY, from which OpenSSL is
> derived.  It looks like each U2 DBMS product and UniDK installs its own
> version of this u2libeay32.dll and u2ssleay32.dll too.  By commenting
one
> file out, you're causing Windows to search further up the executable
PATH
> for another file by that name, and it's apparently finding one that it
> likes better.  Your third-party products may rely on an older version of
> this DLL, and you are accidentally providing it somewhere up the path.
OR
> - your third party products require a more recent version and you
somehow
> had an older version installed which you renamed to .old.  I have two
> versions of that file on my system too.  It might help some of our
> colleagues here if you could identify the products and the files that
they
> choke on, so that no one else trips on this - the product vendor(s) may
be
> interested as well.
> 
> HTH,
> Tony Gravagno
> Nebula Research and Development
> TG@ removethisNebula-RnD
> .com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Select Question

[Richard Taylor]

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] Internal date conversion

[Richard Taylor]

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] Voc pointer not working (fwd)

[Richard Taylor]

The I_ files are Universe indexes.  It seems like the you don't have
indexes on the file on Live, but the header still believes that you have
them.  I would use the SET-INDEX command to clear the path from the
header.  The exact syntax escapes me at the moment, but online help should
give you 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:owner-u2-
> 
> I am aware there are two different levels of indexes in play here. SB+
and
> Universe. Which level is the I_ ?
> 
> TEST ACCOUNT: LIST fails when pointing to the test account
> 
> >CT VOC SM.ORDERS
>  SM.ORDERS
> 0001 F
> 0002 \\VPIMP2\MP6VPITEST\SM.ORDERS
> 0003 E:\CADTEST\D_SM.ORDERS
> 
> >LIST.INDEX SM.ORDERS ALL
> Program "LIST.INDEX": pc = 3E0, Unable to open index map
> "g:\mp6vpitest\I_SM.ORD
> ERS/INDEX.MAP" for read/write,Unable to open "SM.ORDERS".
> 
> >SET.INDEX SM.ORDERS INFORM
> Program "SET.INDEX": pc = CD6, Unable to open index map
> "g:\mp6vpitest\I_SM.ORDE
> RS/INDEX.MAP" for read/write,File SM.ORDERS has no secondary indices.
> Header incorrectly contains path indicating indices should exist!
> (g:\mp6vpitest\I_SM.ORDERS)
> 


> Thanks,
> 
> Marilyn A. Hilb
> Value Part, Inc
> Direct: 847-918-6099
> Fax: 847-367-1892
> [EMAIL PROTECTED]
> www.valuepart.com
> 
>  -Original Message-
> From: Brian Leach [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 11, 2005 3:02 AM
> To:   u2-users@listserver.u2ug.org
> Subject:  RE: [U2] Voc pointer not working (fwd)
> 
> > Marilyn Hilb wrote:
> > >The trigger here seems to be files that have I_ folders on them,
> > >Index Map?.
> 
> As Karl stated, the index file location is hard coded into the file
> header.
> You can amend this using the SET.INDEX command. This can either reset
the
> index path to the local location OR clear the index path so you can
> rebuild.
> 
> Copying files with indices attached is one of those gotchas that
> frequently
> messes up systems, particularly if someone wants to make a test account
on
> the same machine and ends up with test files accessing live indices.
> 
> Brian
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
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...

[Richard Taylor]

I would disagree with that having done it several times.

If a program is reasonably structured to begin with it is not too hard to
retro-fit transaction logic.  In the example given simply putting the
transaction inside of the loop rather than outside would have solved the
problem.

The first step in using transaction logic needs to be defining the
transaction. Again, using the batch program mentioned before the
transaction is probably the update done on each record not the entire
batch.  If not then transaction sets are probably not the way to go.

You also need to keep in mind that U2 does not allow for nested
transactions like SQL/ADO programming does.


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: Thursday, June 23, 2005 10:37 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION
START
> & COMMIT/RO...
> 
> In my opinion...
> 
> NO : Retrofitting TRANSACTIONs into existing programs would be a
> nightmare.
> 
> YES: Definitely use them when writing a new application from scratch and
> even a new sub-system enhancement if it is pretty much self-contained
> with limited, well-defined interfaces that write into the parent system.
> 
> NO : I would caution against writing them into new programs that are
> enhancements to existing (sub-)systems.
> 
> cds
> 
> From: Les Hewkin
> > we had a batch process that processed lots of data and I mean
---
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...

[Richard Taylor]

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?

[Richard Taylor]

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

[Richard Taylor]

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/

RE: [U2] Uniobjects hack

[Richard Taylor]

I can make a couple of suggestions based on past experience.  I am
assuming that you want to primarily limit 'which' files they are allowed
to work with.

1) create a separate account (VOC) that only contains the files that they
are allowed to work with.  By limiting their login to that account only
using OS level security you will effectively stop them from working with
any other files.

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.  

3) Create your own wrapper api for Uniobjects. You could do this in VB or
C++ fairly easily.  Then give them your new library instead of the raw
UniObjects dll.  Of course this only works if you also restrict what they
can install on their machines.

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 John Kent
Sent: Wednesday, May 25, 2005 8:37 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Uniobjects hack

Does anyone have any suggestions on how to contain an advanced user from
attaching the uniobjects control as a reference in excel and working out
how
to get access to the system.

Uniobjects doesnt go in through a login paragraph.

Thanks in advance

jak
---
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] SB GUI controls attribute question

[Richard Taylor]

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...

[Richard Taylor]

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...

[Richard Taylor]

> 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 quandary, any suggestions...

[Richard Taylor]

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...

[Richard Taylor]

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
CM<1> or anything similar.  It is ALWAYS referenced as CM.CUST.NAME.
Sub-valued fields are refenced as CM.ADDR<1,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 CM<1>), 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 quandry, any suggestions...

[Richard Taylor]

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: [U2] I'm in an Array quandry, any suggestions...

[Richard Taylor]

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...

[Richard Taylor]

Don't confuse Dimensioned (fixed) arrays with dynamic arrays.

REC<0> 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, REC<0> returns the entire string too. I ran into this once
converting a program that actively used the assumption that REC<0> 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. REC<0> 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: 
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 htt

RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series]

[Richard Taylor]

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

[Richard Taylor]

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

<<>>
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: RE: [U2] Extending U2 with gci/CALLC -- Factory Floor Automation -Serial

[Richard Taylor]

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


 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.


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] MvInternet

[Richard Taylor]

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: [U2] Complicated Select

[Richard Taylor]

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: 
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] Factory Floor Automation - Serial Connectivity ?

[Richard Taylor]

Why not use VB (or C++, or Java ) with UniObjects to drive a direct
connection between the sensors and UV.  I would suggest keeping an offline
SQL or text file of activity at the same time you update UV directly.
This would allow for resilience the case of a lose of connectivity.

You should also be able to get sensors that are network enabled.  If you
can do this then you can do sockets programming directly in UV to talk to
poll those devices.

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 Brutzman, Bill
Sent: Monday, April 11, 2005 3:02 PM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Factory Floor Automation - Serial Connectivity ?

We would like to be able to gather machine motion into UniVerse.  TTL data
from a sensor could go to a serial or USB port on a PC indicating when a
die
tool is up or down.  Thus, we would be able to capture press activity,
logging data.

There are a few books on www.amazon.com on how to write a VB/serial/USB
application.  This data could be sent to a SQL database to talk with
UniVerse.

There must be a better/cheaper/faster/more_direct way.  Perhaps something
with Java or a PLC thing.  We are using Dynamic Connect.

One of those "stamp" controllers to ethernet or wireless would be ideal.

Suggestions would be appreciated.

Bill Brutzman  
Manager, IT
HK MetalCraft Mfg Corp
PO Box 775
35 Industrial Road
Lodi  NJ  07644-0775
 
973.471.7770 x145
973.471.9666 .fax
 
www.hkMetalCraft.com  

[demime 1.01d removed an attachment of type application/octet-stream which
had a name of Brutzman, Bill.vcf]
---
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?

[Richard Taylor]

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] Hashed file size

[Richard Taylor]

>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] Default Catalog?

[Richard Taylor]

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?

[Richard Taylor]

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

[Richard Taylor]

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] uv pe

[Richard Taylor]

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:  
 [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: 
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:  ,
> [EMAIL PROTECTED] 
> stserver.u2ug.o

RE: [U2] uv pe

[Richard Taylor]

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] Basic program editor for Windows

[Richard Taylor]

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

[Richard Taylor]

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

[Richard Taylor]

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/

[U2] Running a stored procedure from Excel

[Richard Taylor]

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

[Richard Taylor]

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/

RE: [U2] Universe CREATE SCHEMA

[Richard Taylor]

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] [UV] Transaction Compile Failure

[Richard Taylor]

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: 
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 LOCK FOR CONTROL, A

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

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] ThoroughBred to U2 file conversion

[Richard Taylor]

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/

RE: [U2] UV-piopen TRANS function

[Richard Taylor]

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] Edit / Remove a record with no ID

[Richard Taylor]

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] Uniobjects automation error

[Richard Taylor]

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

[Richard Taylor]

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.NO

RE: [U2] LOOP or GOTO on READNEXT

[Richard Taylor]

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

[Richard Taylor]

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

[Richard Taylor]

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.REC<1>
0011  DESC=IM.REC<2>
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

[Richard Taylor]

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] UV to Access via ODBC - driver issue

[Richard Taylor]

Try running repair on the Access database.  You can often get subtle
corruption that can prevent ODBC connections from working properly.
In my experience Access is not the most stable of databases.

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 John
Koch-Northrup
Sent: Sunday, November 07, 2004 12:44 PM
To: [EMAIL PROTECTED]
Subject: [U2] UV to Access via ODBC - driver issue

I've been struggling through this one the last few days - any help
would be GREATLY appreciated.

Platform:   Dataflo 5.8.4 on Universe 10.0.10 on Win2000 sp 3  (though
I don't think Dataflo is an issue here...)

Previously working state:  

Dataflo screen via the Universe BCI module calls ODBC on the server -
in Data Sources (ODBC) System DSN tab I have a pointer to a Microsoft
Access 2000 file.Screen sends an id to the Access database - a total
number of parts on a reel is returned from the Access database and
placed into the screen.   It's been working nicely for about 6 months.

How it was broken:   

The system that stores data in the Access file was upgraded on
Thursday.   The Access file is now (I believe) at XP level.   The ODBC
connection is broken.

Attempted fix (that failed):

Research on Microsoft's site led me to believe that upgrading to Jet
4.0 sp 8 and MDAC 2.8 would fix the problem.   I found an article (which
I oddly can't find now...) that stated that Access beyond version 2000
no longer had a specific ODBC driver to connect to it - you now
connected through the Oracle driver.   Admittedly - I thought that was
an odd statement and I'm trying to get back to that article and read it
through again. 

At the moment - I have the server sitting with Jet 4.0 sp 8 and MDAC
2.8 - and cannot connect to the Access file correctly.   Anyone run into
something similar?  

Thanks!

John Koch-Northrup
---
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

[Richard Taylor]

-Original Message-


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.


-

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] PICK Assembler Language

[Richard Taylor]

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] Uniobjects.NET speed/performance

[Richard Taylor]

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] UniVerse to Linux mySQL

[Richard Taylor]

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/