Re: [U2] terminfo issues after a UV restore

[Ray Wurlod]

To recompile the terminfo definitions use uvtic -a < vt100.src where vt100.src 
is the source definition file that you altered (presumably created initially by 
uvtidc).
If you want to recompile the originals, there is a terminfo.src in the sample 
directory (under the UV account) that you can use.
After you've run uvtic also run tiindex to rebuild the list of terminal types 
used by ? in the SET.TERM.TYPE command.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] FIND vs LOCATE- speed?

[Womack, Adrian]

If you don't care about the resulting position - i.e. you just want to
know if the list contains the item, then the absolute quickest method is
to use INDEX().

Eg looking for "JKL" in "ABC}DEF}GHI}JKL}MNO}PQR" 

THE.LIST = @VM:"ABC}DEF}GHI}JKL}MNO}PQR":@VM
IF INDEX(THE.LIST,@VM:"JKL":@VM,1) THEN found

The extra value marks at the beginning and end are required to ensure
the value you're looking for isn't contained within another value.

Even if you do need the position, INDEX can be quicker, just use COUNT
afterwards to determine the number of marks that appear before the INDEX
position.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik
Sent: Thursday, 3 August 2006 8:24 AM
To: U2-users (E-mail)
Subject: [U2] [UV] FIND vs LOCATE- speed?

When using FIND or LOCATE on a dynamic array, is one faster than the
other, and is there any reason to sort the array to (hopefully) improve
the speed of FIND or LOCATE?

I don't need to use LOCATE... BY... SETTING, I'm just doing a raw FIND
or LOCATE.

Barry Brevik
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [UV] FIND vs LOCATE- speed?

[Barry Brevik]

When using FIND or LOCATE on a dynamic array, is one faster than the other, and 
is there any reason to sort the array to (hopefully) improve the speed of FIND 
or LOCATE?

I don't need to use LOCATE... BY... SETTING, I'm just doing a raw FIND or 
LOCATE.

Barry Brevik
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Getting information on udt processes

[Wendy Smoak]

On 8/2/06, Tom Dodds <[EMAIL PROTECTED]> wrote:


If you are on UniVerse it is LAYER.STACK instead of CALL.STACK.


Thanks!  I created a page on the wiki with an example of PORT.STATUS:

  http://www.pickwiki.com/cgi-bin/wiki.pl?ViewCallStack

--
Wendy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Unidata/Oracle connection problem

[Sara Burns]

We have been transferring data from UniVerse to Oracle and SQLServer for
many years now using the BCI.  We also query those databases and bring data
to UniVerse also using BCI.
 
We use Openlink software  http://www.openlinksw.com/
   as the ODBC Manager which is linked into
UniVerse.  Works very well.  Our users expect real-time replication of data
as they create it in UniVerse and expect to be able to use in immediately in
Oracle.  Normally this expectation is satisfied.
 
Sara Burns
 
Sara Burns (SEB) 


Integration Manager

Public Trust 
Phone: +64 (04) 978 4534 (DDI) 

Mobile: 027 457 5974
<  mailto:[EMAIL PROTECTED]>

 
The information contained in this communication (including any attachment)
is confidential. If you are not the intended recipient, please destroy this
communication. You must not disclose, copy or use in any way the information
contained in this communication. Any views expressed in this communication
are not necessarily the views of Public Trust. No representation is made
that this communication is free of error, virus or interference.

.

 

A family trust can help you protect your assets if the unexpected happens. 
To find out how a family trust works and if one's right for you, call 0800 505 
405.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] part files

[David Wolverton]

YES - but we would have to open the explicity/correct 'Multifile' to read
and write - the programs would not 'know' to put HISTORY orders in the
HISTORY part and ACTIVE orders in the ACTIVE part.  UniVerse can do this
natively - not something we UniData'ers have a choice on.  As well, all
MULTIFILES **share** a dictionary, but are not seen as one large logical
file as in UniVerse.

Eveyone has the 'MultiFile' stuff - we had it in R83! But UniVerse's Part
File I think is fairly unique.

DW 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder
Sent: Wednesday, August 02, 2006 2:48 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] part files

[Posted on behalf of Wally Terhune, who is experiencing email problems]

David W wrote: UniData does not have the 'part' files like UniVerse

UniData does not have UV distributed files, but it does support MULTIFILEs
with single shared dictionary and multiple parts
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] OT: Email Attachment Universe Linux

[Larry Hiscock]

Some mail readers don't understand uuencoding.  You'd be better off base64
encoding the PDF, then building a MIME-encoded email, and sending it via
sendmail.


Larry Hiscock
Western Computer Services
http://www.wcs-corp.com 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz
Sent: Wednesday, August 02, 2006 7:57 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] OT: Email Attachment Universe Linux

Hey guys,

We have a program that distributes information via various methods.  One
of which is to email the file as a PDF.  So, one of our users was on AOL
and then switched to Cox.  They read their email via the cox webmail
site on a browser.  The problem is that the attachment is coming over as
part of the message now and not as an attachment.  However, if they use
outlook as the email client, then the file is presented as an
attachment.  So, webmail client is doing something different than
outlook.  If I send an attachment to the person using outlook on my PC,
then the attachment comes thru as an attachment on the webmail client.

So, I think the problem is the way I am sending the email / attachment.
I am using the following;

uuencode MYFILE.PDF MYFILE.PDF | mail -s MYFILE.PDF -n
[EMAIL PROTECTED] 

This is being done on a Linux machine and we are shelling out of
Universe to issue the command.  Any suggestions on how to make it better
?

Thanks

Anthony
---
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] Getting information on udt processes

[Wendy Smoak]

On 8/2/06, Timothy Snyder <[EMAIL PROTECTED]> wrote:


Try PORT.STATUS PID 9 CALL.STACK.  It reports the call stack,
including the current line number for all executed programs and external
subroutines.


Thank you!  That's *exactly* what I need.  Now I just have to wait for
it to happen again. :)

--
Wendy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] part files

[Ron Hutchings]

This does not give you access to the entire file at once like the multi-part 
files!


Original Message Follows
From: Timothy Snyder <[EMAIL PROTECTED]>
Reply-To: u2-users@listserver.u2ug.org
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] part files
Date: Wed, 2 Aug 2006 15:47:47 -0400

[Posted on behalf of Wally Terhune, who is experiencing email problems]

David W wrote: UniData does not have the 'part' files like UniVerse

UniData does not have UV distributed files, but it does support MULTIFILEs
with single shared dictionary and multiple parts

:CREATE.FILE MULTIFILE PURCHASE_ORDERS 11,1
Create DIR type file PURCHASE_ORDERS.
Create file D_PURCHASE_ORDERS, modulo/1,blocksize/1024
Hash type = 0
Added "@ID", the default record for UniData to DICT PURCHASE_ORDERS.
Create file PURCHASE_ORDERS/PURCHASE_ORDERS, modulo/11,blocksize/1024
Hash type = 0
Added "@PURCHASE_ORDERS" to DICT PURCHASE_ORDERS.
:
:CREATE.FILE MULTIFILE PURCHASE_ORDERS,HISTORY 11,1
Create file PURCHASE_ORDERS/HISTORY, modulo/11,blocksize/1024
Hash type = 0
Added "@HISTORY" to DICT PURCHASE_ORDERS.
:
:LIST PURCHASE_ORDERS,HISTORY

LIST PURCHASE_ORDERS,HISTORY 12:51:33 Aug 01 2006 1
PURCHASE_ORDERS


No records listed.
---
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: Email Attachment Universe Linux

[Scott Ballinger]

Ok, here is my annual pitch for a cool product (that I use everywhere,
so I want the developer to stay in business!).

Yes, I know you can roll-your-own for sending emails, but there is a
great little command line email tool called postie
(http://infradig.com/) that does it all for you, and costs only  75 us$.
It handles attachments, cc's, bcc's etc. It can send & get both pop and
imap email, and can manage messages in imap folders too.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo
Sent: Wednesday, August 02, 2006 9:12 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OT: Email Attachment Universe Linux

Anthony,

If you look at the properties of your outlook email (the one that worked
properly), you will see this text "MIME-Version: 1.0" Content-Type:
multipart/mixed.. "This is a multi-part message in MIME format. ".
You need to echo this text, see below: The key is "multipart/"

Hope this helps,
Cheers,

Angelo

***
CMD = ''
CMD<-1> = 't="':EMAIL:'"'
CMD<-1> = 'f="x.com"'
CMD<-1> = 'F="The IBM"'
CMD<-1> = 'a="/tmp/':TNAME:'"'
CMD<-1> = 'A="':TNAME:'.txt"'
CMD<-1> = 's="Emailing: ${A}"'
CMD<-1> = 'p=`perl -e ':SQ:'printf "_NextPart_%03D_%04D_%08X.%08X",'
CMD<-1> = '   rand(1000), rand(1),time(),time()+1':SQ:'`'
CMD<-1> = '('
CMD<-1> = 'echo "Return-path: <${f}>"'
CMD<-1> = 'echo "From: \"${F}\" <${f}>"'
 

***
CMD<-1> = 'echo "To:
\"${t}\""'
CMD<-1> = 'echo "Subject: ${s}"'
CMD<-1> = 'echo "MIME-Version: 1.0"'
CMD<-1> = 'echo "Content-Type:
multipart/mixed':SEMI:'\n\tboundary=\"=$
CMD<-1> = 'echo "This is a multi-part message in MIME
format.\n--=${p}"
CMD<-1> = 'echo "Content-Type:
text/plain':SEMI:'\n\tcharset=\"iso-8859-1\"
CMD<-1> = 'echo "Content-Transfer-Encoding: 7bit\n"'
*!*CMD<-1> = 'if [ ! -z "${b}" ]'
*!*CMD<-1> = 'then'
*!*CMD<-1> = '  cat "${b}"'
*!*CMD<-1> = 'fi'
CMD<-1> = 'if [ ! -z "${a}" ]'
CMD<-1> = 'then'
CMD<-1> = '  echo "--=${p}"'

CMD<-1> = '  echo "Content-Type:
octet-stream':SEMI:'\n\tname=\"${A}.gz\""'
CMD<-1> = '  echo "Content-Disposition:
attachment':SEMI:'\n\tfilename=\"${
CMD<-1> = '  echo "Content-Transfer-Encoding: base64\n"'
CMD<-1> = '  cat "${a}" | /tcpprint/crnl | gzip |'
CMD<-1> = 'perl -MMIME::Base64 -0777 -ne ':SQ:'print
encode_base64($_)'
CMD<-1> = 'fi'
CMD<-1> = 'echo "--=${p}--"'
CMD<-1> = ') | /usr/sbin/sendmail ':SENDMAIL.OPTS:' "${t}"'

***





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anthony
Dzikiewicz
Sent: Wednesday, August 02, 2006 10:57 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] OT: Email Attachment Universe Linux

Hey guys,

We have a program that distributes information via various methods.  One
of which is to email the file as a PDF.  So, one of our users was on AOL
and then switched to Cox.  They read their email via the cox webmail
site on a browser.  The problem is that the attachment is coming over as
part of the message now and not as an attachment.  However, if they use
outlook as the email client, then the file is presented as an
attachment.  So, webmail client is doing something different than
outlook.  If I send an attachment to the person using outlook on my PC,
then the attachment comes thru as an attachment on the webmail client.

So, I think the problem is the way I am sending the email / attachment.
I am using the following;

uuencode MYFILE.PDF MYFILE.PDF | mail -s MYFILE.PDF -n
[EMAIL PROTECTED]

This is being done on a Linux machine and we are shelling out of
Universe to issue the command.  Any suggestions on how to make it better
?

Thanks

Anthony
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] part files

[Timothy Snyder]

[Posted on behalf of Wally Terhune, who is experiencing email problems]

David W wrote: UniData does not have the 'part' files like UniVerse

UniData does not have UV distributed files, but it does support MULTIFILEs 
with single shared dictionary and multiple parts

:CREATE.FILE MULTIFILE PURCHASE_ORDERS 11,1  
Create DIR type file PURCHASE_ORDERS.  
Create file D_PURCHASE_ORDERS, modulo/1,blocksize/1024  
Hash type = 0  
Added "@ID", the default record for UniData to DICT PURCHASE_ORDERS.  
Create file PURCHASE_ORDERS/PURCHASE_ORDERS, modulo/11,blocksize/1024  
Hash type = 0  
Added "@PURCHASE_ORDERS" to DICT PURCHASE_ORDERS.  
:  
:CREATE.FILE MULTIFILE PURCHASE_ORDERS,HISTORY 11,1  
Create file PURCHASE_ORDERS/HISTORY, modulo/11,blocksize/1024  
Hash type = 0  
Added "@HISTORY" to DICT PURCHASE_ORDERS.  
:  
:LIST PURCHASE_ORDERS,HISTORY  
  
LIST PURCHASE_ORDERS,HISTORY 12:51:33 Aug 01 2006 1  
PURCHASE_ORDERS  
  
  
No records listed.  
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Getting information on udt processes

[Tom Dodds]

If you are on UniVerse it is LAYER.STACK instead of CALL.STACK.

Tom Dodds
[EMAIL PROTECTED]
513-563-2800 Cincinnati Office
708-234-9608 Chicago Office
630-235-2975 Anywhere Cell
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder
Sent: Wednesday, August 02, 2006 2:45 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Getting information on udt processes

[EMAIL PROTECTED] wrote on 08/02/2006 01:57:45 PM:

> Rather than just kill the process, is there some way to get a stack
> trace from it?  I'd love to find out what subroutine it's running.

Try PORT.STATUS PID 9 CALL.STACK.  It reports the call stack, 
including the current line number for all executed programs and external 
subroutines.


Tim Snyder
Consulting I/T Specialist
U2 Consulting
North American Lab Services
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] Getting information on udt processes

[Timothy Snyder]

[EMAIL PROTECTED] wrote on 08/02/2006 01:57:45 PM:

> Rather than just kill the process, is there some way to get a stack
> trace from it?  I'd love to find out what subroutine it's running.

Try PORT.STATUS PID 9 CALL.STACK.  It reports the call stack, 
including the current line number for all executed programs and external 
subroutines.


Tim Snyder
Consulting I/T Specialist
U2 Consulting
North American Lab Services
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/

RE: [U2] Unidata/Oracle connection problem

[Angelo Collazo]

Here you go.
http://www.easysoft.com/

Cheers,

Angelo

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Richard Taylor
Sent: Wednesday, August 02, 2006 9:54 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata/Oracle connection problem

   Yes

   Actually  we  identified another problem. That being the fact that the
   Oracle  client  on  Unix did NOT include an ODBC driver from what I am
   being  told.   We  are  investigating other commercial and open source
   drivers.  If anyone has any suggestions it would be appreciated.

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
   __

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of  "Angelo
   Collazo" <[EMAIL PROTECTED]>
   Sent: Tuesday, August 01, 2006 4:36 PM
   To: 
   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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit ht

[U2] Getting information on udt processes

[Wendy Smoak]

Occasionally we have some udt process that take up lots of resources
and never finish.  Most likely there's an endless loop in some
subroutine.

I know it's coming through unirpcd, because the processes are owned by
a user that is only allowed to connect that way.  Most likely it's in
a subroutine called by one of the Java apps.

We just kill the processes and life goes on.  Somewhere, someone's
browser has probably timed out, but no one has called to complain so
it's hard to figure out what's going on.

Rather than just kill the process, is there some way to get a stack
trace from it?  I'd love to find out what subroutine it's running.

Thanks,
--
Wendy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] Indexing 'Best Practices'

[David Wolverton]

UniData does not have the 'part' files like UniVerse - it would be cool -
but not a choice for us without 'doing it manually'.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Wednesday, August 02, 2006 11:11 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Indexing 'Best Practices' 

Hi David,

Don't know if this is possible or not but couldn't you write your COMPLETE
records to a .HIST file, keeping the rest of the data in a .CURR file.  Then
have a PART file definition that binds the two parts into what is the
current filename?  
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] Indexing 'Best Practices'

[Bob Woodward]

Hi David,

Don't know if this is possible or not but couldn't you write your
COMPLETE records to a .HIST file, keeping the rest of the data in a
.CURR file.  Then have a PART file definition that binds the two parts
into what is the current filename?  You could then index and select off
the .CURR file and be able to process off either the PART filename or
the .CURR filename.

I'm not real familiar with PART files but it seems like it should work.
I'm not even sure if PART files are available in UD but thought the
suggestion was worth mentioning.

Good luck,

Bob Woodward
Senior Programmer/Analyst
Harbor Wholesale Grocery

 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Wednesday, August 02, 2006 6:53 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Indexing 'Best Practices' 

OK - sold!  Virtual field to move COMPLETE to NULL is the answer... As I
was
driving back to the hotel after doing that post last night, I got to
thinking that the Virtual Field computation would strictly be
CPU/Memory,
which means I can do A LOT of that for the cost of a single disk access.
And with the B+Tree design, we are doomed to at least TWO disk reads in
every case (unless you happen to hit the Root record!) - the first to
the
'lead' block, and then a read either 'left' or 'right' - and fresh from
sleep, I can see that as the index grew, that could turn into 3, 4, or
50
traversals (aka Disk reads) left or right to position the key on write.
The
leaf size is 4K - PERIOD. So every 100 or so records in a leaf, there
would
be some sort of shift of level push that would involve even more write
traffic.

More than likely I'll create a new dictionary that is a Virtual Field,
and
index that NO.NULLS and change the routines that need expedited selects
that
we were using the index for anyway - any report that would allow
"COMPLETE"
as an option will probably have to go through the whole file, so we may
have
to create 'versions' of the report - a faster "Select Only From
non-COMPLETE" Version that can use Indexes, and a slow, but inclusive
"Can
Include COMPLETE" version which will use the unindexed attribute.

Thanks for all who responded on and off list!  If anyone else knows
magic
that goes on behind the scenes on indexes, or has recommendations,
please
continue to chime in!
---
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: Email Attachment Universe Linux

[Angelo Collazo]

Anthony,

If you look at the properties of your outlook email (the one that worked
properly), you will see this text "MIME-Version: 1.0" Content-Type:
multipart/mixed.. "This is a multi-part message in MIME format. ". You
need to echo this text, see below: The key is "multipart/"

Hope this helps,
Cheers,

Angelo
***
CMD = ''
CMD<-1> = 't="':EMAIL:'"'
CMD<-1> = 'f="x.com"'
CMD<-1> = 'F="The IBM"'
CMD<-1> = 'a="/tmp/':TNAME:'"'
CMD<-1> = 'A="':TNAME:'.txt"'
CMD<-1> = 's="Emailing: ${A}"'
CMD<-1> = 'p=`perl -e ':SQ:'printf "_NextPart_%03D_%04D_%08X.%08X",'
CMD<-1> = '   rand(1000), rand(1),time(),time()+1':SQ:'`'
CMD<-1> = '('
CMD<-1> = 'echo "Return-path: <${f}>"'
CMD<-1> = 'echo "From: \"${F}\" <${f}>"'
 ***
CMD<-1> = 'echo "To: \"${t}\""'
CMD<-1> = 'echo "Subject: ${s}"'
CMD<-1> = 'echo "MIME-Version: 1.0"'
CMD<-1> = 'echo "Content-Type: multipart/mixed':SEMI:'\n\tboundary=\"=$
CMD<-1> = 'echo "This is a multi-part message in MIME format.\n--=${p}"
CMD<-1> = 'echo "Content-Type: text/plain':SEMI:'\n\tcharset=\"iso-8859-1\"
CMD<-1> = 'echo "Content-Transfer-Encoding: 7bit\n"'
*!*CMD<-1> = 'if [ ! -z "${b}" ]'
*!*CMD<-1> = 'then'
*!*CMD<-1> = '  cat "${b}"'
*!*CMD<-1> = 'fi'
CMD<-1> = 'if [ ! -z "${a}" ]'
CMD<-1> = 'then'
CMD<-1> = '  echo "--=${p}"'

CMD<-1> = '  echo "Content-Type: octet-stream':SEMI:'\n\tname=\"${A}.gz\""'
CMD<-1> = '  echo "Content-Disposition: attachment':SEMI:'\n\tfilename=\"${
CMD<-1> = '  echo "Content-Transfer-Encoding: base64\n"'
CMD<-1> = '  cat "${a}" | /tcpprint/crnl | gzip |'
CMD<-1> = 'perl -MMIME::Base64 -0777 -ne ':SQ:'print encode_base64($_)'
CMD<-1> = 'fi'
CMD<-1> = 'echo "--=${p}--"'
CMD<-1> = ') | /usr/sbin/sendmail ':SENDMAIL.OPTS:' "${t}"'
***





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz
Sent: Wednesday, August 02, 2006 10:57 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] OT: Email Attachment Universe Linux

Hey guys,

We have a program that distributes information via various methods.  One
of which is to email the file as a PDF.  So, one of our users was on AOL
and then switched to Cox.  They read their email via the cox webmail
site on a browser.  The problem is that the attachment is coming over as
part of the message now and not as an attachment.  However, if they use
outlook as the email client, then the file is presented as an
attachment.  So, webmail client is doing something different than
outlook.  If I send an attachment to the person using outlook on my PC,
then the attachment comes thru as an attachment on the webmail client.

So, I think the problem is the way I am sending the email / attachment.
I am using the following;

uuencode MYFILE.PDF MYFILE.PDF | mail -s MYFILE.PDF -n
[EMAIL PROTECTED]

This is being done on a Linux machine and we are shelling out of
Universe to issue the command.  Any suggestions on how to make it better
?

Thanks

Anthony
---
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] Index files

[Stevenson, Charles]

Tim,

Six & a half thoughts:

1. You say 1:1 correspondence for ID:PHYS.PALLET.ID,  meaning no
multivalues, right?
I ask about multivalues because if there are repeated identical mv
entries in a record, SELECTINDEX performs differently in PI vs PICK
flavours.  
See $OPTIONS PIOPEN.SELIDX.

2. And no null PHYS.PALLET.IDs, right?

3. It is possible to corrupt an index if the primary data file were
copied using an OS-level utility so that the header in the copy still
contains pointers to the index.  for example you CTRL+[mouse right
click] and drag a copy to your sandbox to test with.  To search for all
indexes, in each VOC do:
   SELECTF
   SETINDEX INFORM

4. Corruption can occur if there is a VOC pointer to the path of the
type-25 index file itself.  (i.e.,, VOC <2> will look something like
...\I_[datafilename]\INDEX.004).  That allows you to edit or otherwise
manipulate the index valued directly.
For that matter basic's OPENPATH could do the same w/o a VOC reference.

4a.  You might want to ~temporarily~ create such a VOC item so you can
examine the contents of the index just for troubleshooting.

5. If you rebuild the index does it work right at first, then somehow
get corrupted?  Or is it always wrong?

6. TCL SELECT works correctly? only Basic's SELECTINDEX fails?  How
about BSCAN?

Beyond that, maybe you could post an example of where it fails?  (w/o
=0D=OA's?)

cds
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] OT: Email Attachment Universe Linux

[Glen Batchelor]

 I based64 encode my PDFs, build the e-mail and MIME envelopes for the text
and PDF sections, write the entire email blob to a local file, and then use
sendmail to send the email using the head inside the e-mail. That way, I can
specify the disposition of the envelope contents as in-line or attachment.
That's been working fine for years for electronic invoicing.

---
Glen Batchelor
IT Director
All-Spec Industries
phone: (910) 332-0424
fax: (910) 763-5664
e-mail: [EMAIL PROTECTED]
---
www.allspec.com
---
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz
> Sent: Wednesday, August 02, 2006 10:57 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] OT: Email Attachment Universe Linux
> 
> Hey guys,
> 
> We have a program that distributes information via various methods.  One
> of which is to email the file as a PDF.  So, one of our users was on AOL
> and then switched to Cox.  They read their email via the cox webmail
> site on a browser.  The problem is that the attachment is coming over as
> part of the message now and not as an attachment.  However, if they use
> outlook as the email client, then the file is presented as an
> attachment.  So, webmail client is doing something different than
> outlook.  If I send an attachment to the person using outlook on my PC,
> then the attachment comes thru as an attachment on the webmail client.
> 
> So, I think the problem is the way I am sending the email / attachment.
> I am using the following;
> 
> uuencode MYFILE.PDF MYFILE.PDF | mail -s MYFILE.PDF -n
> [EMAIL PROTECTED]
> 
> This is being done on a Linux machine and we are shelling out of
> Universe to issue the command.  Any suggestions on how to make it better
> ?
> 
> Thanks
> 
> Anthony
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UD] Indexing 'Best Practices'

[TPellitieri]

"Kate Stanton" <[EMAIL PROTECTED]> wrote on 2 Aug 2006 18:11:11 +1200

> I would go for the simplest solution to operate and maintain,
> almost to hell with machine efficiency.  You (or anyone else
> trying to follow you) are probably the most critical and
> expensive resource.

I must disagree with your reasoning.  System response time is critical in a
customer service situation.  If a customer has to wait a noticeable time
because the programmer didn't make an effort to provide efficient code,
it's a waste of the customer's time - and I would suggest that a customer's
time is a company's most critical resource, and wasting it is your most
expensive mistake.

--Tom Pellitieri
  Century Equipment
  Toledo, Ohio
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] OT: Email Attachment Universe Linux

[Mark Ballinger]

On Wed, Aug 02, 2006 at 10:57:16AM -0400, Anthony Dzikiewicz wrote:
> Hey guys,
> 
> We have a program that distributes information via various methods.  One
> of which is to email the file as a PDF.  So, one of our users was on AOL
> and then switched to Cox.  They read their email via the cox webmail
> site on a browser.  The problem is that the attachment is coming over as
> part of the message now and not as an attachment.  However, if they use
> outlook as the email client, then the file is presented as an
> attachment.  So, webmail client is doing something different than
> outlook.  If I send an attachment to the person using outlook on my PC,
> then the attachment comes thru as an attachment on the webmail client.
> 
> So, I think the problem is the way I am sending the email / attachment.
> I am using the following;
> 
> uuencode MYFILE.PDF MYFILE.PDF | mail -s MYFILE.PDF -n
> [EMAIL PROTECTED] 
> 
> This is being done on a Linux machine and we are shelling out of
> Universe to issue the command.  Any suggestions on how to make it better
> ?

Instead of uuencode you might look at "mpack".  It may not be included
in your Linux distribution, but it's easy to find.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] OT: Email Attachment Universe Linux

[Anthony Dzikiewicz]

Hey guys,

We have a program that distributes information via various methods.  One
of which is to email the file as a PDF.  So, one of our users was on AOL
and then switched to Cox.  They read their email via the cox webmail
site on a browser.  The problem is that the attachment is coming over as
part of the message now and not as an attachment.  However, if they use
outlook as the email client, then the file is presented as an
attachment.  So, webmail client is doing something different than
outlook.  If I send an attachment to the person using outlook on my PC,
then the attachment comes thru as an attachment on the webmail client.

So, I think the problem is the way I am sending the email / attachment.
I am using the following;

uuencode MYFILE.PDF MYFILE.PDF | mail -s MYFILE.PDF -n
[EMAIL PROTECTED] 

This is being done on a Linux machine and we are shelling out of
Universe to issue the command.  Any suggestions on how to make it better
?

Thanks

Anthony
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata/Oracle connection problem

[Shin.Tanaka]

Did you run $UDTBIN/relink.udlibs ?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor
Sent: Tuesday, August 01, 2006 3:05 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata/Oracle connection problem

   More info on this:

   I  was  able  to  successfully  use  the  Oracle Client using
SQLplus.
   However  attempts  to  use  CONNECT  from  the  tcl  prompt return
the
   following:

   SQLConnect error:  Status = -1  SQLState = 0  Natcode = 3349920

   We  think our problem is in the libodbc.sl (HPUX version 11).  This
is
   still  linked to the file in the Unidata application path.  We can
not
   find  any  other  occurrence  of  this  file.  This is the ODBC
Driver
   manager and I believe that this is necessary.

   Can anyone point out what you are using for this and where you got
the
   file?

   Thanks

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the
most
   complex,   time-sensitive  marketing  challenges  through
consulting,
   creative,   research,   direct,   media,  technology,  and
production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
 
__

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of
Richard
   Taylor <[EMAIL PROTECTED]>
   Sent: Monday, July 31, 2006 3:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] Unidata/Oracle connection problem

   I am attempting to setup a data source under Unix to allow access to
   an Oracle database. I am having a lot of trouble getting this to
   work.
   I have:
   7 Installed the oracle client
   7 Setup a place to hold the driving library
   7 Setup a folder to hold my odbc.ini file and set the
   ODBCSYSINI environment variable to point there.
   7 I created the odbc.ini file as shown below.
   7 My oracle dba also did some configuration setup for the
   Oracle client and was able to connect through the client.
   [DV83]
   Driver=/usr/local/lib/hsdb_odbc.sl
   Description=Oracle ODBC on test system
   SERVER=testserver
   PORT=1521
   USER=test_user
   Password=**
   Database=DV83
   OPTION=3
   SOCKET=
   TraceFile=/production/udtmp/odbc_rich.trace
   Trace=1
   Can anyone tell me if they have successfully gotten a BCI connection
   going to Oracle and how you did it. By the way I am on an HP Unix
   system.
   Thanks in advance for any help.
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UD] Indexing 'Best Practices'

[Raymond DeGennaro II]

At 20:59 -0500 2006/08/01, David Wolverton wrote:

So we have tens, and hundreds of records (and have to think about thousands)
in the different status 'buckets' and can grab those instantly via a SELECT
- and that is great and works like a champ -- except that we are also
carrying an index for COMPLETE which is just enormous (and essentially
useless) - every record in the file except for the currently active is
stamped COMPLETE.

We would never have a reason to 'look' at all complete records via this
index, as to do so would be almost the entire file. So if we did not have
this index, I don't see that it would be a problem.


How often is the information in the COMPLETE records needed?
Will a COMPLETE record ever be changed to another status?
How often will you need to mix data from COMPLETE records and records 
with other statuses?


If a COMPLETE record is "essentially useless" (except for historical 
purposes), I'd consider moving records out of POTENTIALLY_HUGE_FILE 
and into POTENTIALLY_HUGE_FILE_ARCHIVE as soon as they're COMPLETE.


That solves the index problem and keeps the working file smaller 
and/or less full.


Ray

--
.=.
| =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= |
| -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- |
|      |
|Midwest Regional Office: 815-547-0662 (voice)  815-547-0353 (Fax)|
.=.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Index files

[Jerry Banker]

You're setting NO.NULLS on that field, could this be your problem.
By the way, what are you using for your email? You can hardly read the
message with all of the =0D=0A codes in it.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tim Franklin
Sent: Wednesday, August 02, 2006 3:49 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Index files

We are running UniVerse 10.1.7 and use indexing on a number of
files.=0D=0A
Randomly on one of the files we keep loosing the index on the same=0D=0A
field, PHYS.PALLET.ID.=0D=0A
=0D=0A
 =0D=0A
=0D=0A
Index name  Type  BuildNulls  In DICT  S/M  Just Unique
Field=0D=0A
num/I-type=0D=0A
=0D=0A
 =0D=0A
=0D=0A
PHYS.PALLET.ID   DNot Reqd  No Yes  SL N6=0D=0A
=0D=0A
TRUCK.ID DNot Reqd  No Yes  SL N8=0D=0A
=0D=0A
ORDER.NO DNot Reqd  No Yes  MR N1=0D=0A
=0D=0A
WAYBILL.UMC  DNot Reqd  No Yes  SR N9=0D=0A
=0D=0A
WAYBILL  DNot Reqd  No Yes  SL N14=0D=0A
=0D=0A
 =0D=0A
=0D=0A
So SELECTINDEX fails, has anyone experienced similar problems. The
data=0D=
=0A
in the fields is always of the form 4A4N and there is a one to one=0D=0A
relationship between the field and the primary key.=0D=0A
=0D=0A
 =0D=0A
=0D=0A
Regards,=0D=0A
=0D=0A
Tim=0D=0A
=0D=0A
=0D=0A
Legal Disclaimer:=0A
The information contained in this message may be privileged and
confident=
ial. It is intended to be read only by the individual or entity to whom
i=
t is addressed or by their designee. If the reader of this message is
not=
 the intended recipient, you are on notice that any distribution of this
=
message, in any form, is strictly prohibited. If you have received this
m=
essage in error, please immediately notify the sender and delete or
destr=
oy any copy of this message=0D=0A
---
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] terminfo issues after a UV restore

[George Gallen]

yes. Found it in the manual finally.
Online Manuals are harder to find things,

You would think that the infomation would be
referenced on how to do this under "terminfo"

Oh wellnow the next fish to fry...I mean fix to fry.

George

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Mark Ballinger
> Sent: Wednesday, August 02, 2006 10:11 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] terminfo issues after a UV restore
> 
> 
> On Wed, Aug 02, 2006 at 09:03:53AM -0400, George Gallen wrote:
> > We recently had a system crash.
> > 
> > I had to re-install UV, then overwrote the UV directory
> >   from a backup prior to the crash.
> > 
> > Universe seems to work fine, except the terminfo is a little screwy
> > I get a <$5> when using the @(x,y) positioning.
> > 
> > How do I recompile the terminfo database? Or if I remember correctly
> > I had to edit the terminfo for vt100 to remove the characters.
> > 
> > UV 10 / unix
> 
> uvtidc > vt100.temp
> 
> Then, edit that temp file, then as root
> 
> tic ./vt100.temp
> ---
> 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] terminfo issues after a UV restore

[Mark Ballinger]

On Wed, Aug 02, 2006 at 09:03:53AM -0400, George Gallen wrote:
> We recently had a system crash.
> 
> I had to re-install UV, then overwrote the UV directory
>   from a backup prior to the crash.
> 
> Universe seems to work fine, except the terminfo is a little screwy
> I get a <$5> when using the @(x,y) positioning.
> 
> How do I recompile the terminfo database? Or if I remember correctly
> I had to edit the terminfo for vt100 to remove the characters.
> 
> UV 10 / unix

uvtidc > vt100.temp

Then, edit that temp file, then as root

tic ./vt100.temp
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] terminfo issues after a UV restore

[Martin Phillips]

Hi George,

This has to be my favourite UV bug. It has been there for at least ten years
on and off.

>From an operating system prompt, go into the sample subdirectory of the UV
account and type
   ../bin/uvtic terminfo.src

The <$nn> construct is a terminfo feature that inserts a delay of nn
milliseconds. It is not supported by UV and hence just gets output as text.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
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] [UD] Indexing 'Best Practices'

[David Wolverton]

OK - sold!  Virtual field to move COMPLETE to NULL is the answer... As I was
driving back to the hotel after doing that post last night, I got to
thinking that the Virtual Field computation would strictly be CPU/Memory,
which means I can do A LOT of that for the cost of a single disk access.
And with the B+Tree design, we are doomed to at least TWO disk reads in
every case (unless you happen to hit the Root record!) - the first to the
'lead' block, and then a read either 'left' or 'right' - and fresh from
sleep, I can see that as the index grew, that could turn into 3, 4, or 50
traversals (aka Disk reads) left or right to position the key on write. The
leaf size is 4K - PERIOD. So every 100 or so records in a leaf, there would
be some sort of shift of level push that would involve even more write
traffic.

More than likely I'll create a new dictionary that is a Virtual Field, and
index that NO.NULLS and change the routines that need expedited selects that
we were using the index for anyway - any report that would allow "COMPLETE"
as an option will probably have to go through the whole file, so we may have
to create 'versions' of the report - a faster "Select Only From
non-COMPLETE" Version that can use Indexes, and a slow, but inclusive "Can
Include COMPLETE" version which will use the unindexed attribute.

Thanks for all who responded on and off list!  If anyone else knows magic
that goes on behind the scenes on indexes, or has recommendations, please
continue to chime in!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] terminfo issues after a UV restore

[George Gallen]

We recently had a system crash.

I had to re-install UV, then overwrote the UV directory
  from a backup prior to the crash.

Universe seems to work fine, except the terminfo is a little screwy
I get a <$5> when using the @(x,y) positioning.

How do I recompile the terminfo database? Or if I remember correctly
I had to edit the terminfo for vt100 to remove the characters.

UV 10 / unix

George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Index files

[Tim Franklin]

We are running UniVerse 10.1.7 and use indexing on a number of files.=0D=0A
Randomly on one of the files we keep loosing the index on the same=0D=0A
field, PHYS.PALLET.ID.=0D=0A
=0D=0A
 =0D=0A
=0D=0A
Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field=0D=0A
num/I-type=0D=0A
=0D=0A
 =0D=0A
=0D=0A
PHYS.PALLET.ID   DNot Reqd  No Yes  SL N6=0D=0A
=0D=0A
TRUCK.ID DNot Reqd  No Yes  SL N8=0D=0A
=0D=0A
ORDER.NO DNot Reqd  No Yes  MR N1=0D=0A
=0D=0A
WAYBILL.UMC  DNot Reqd  No Yes  SR N9=0D=0A
=0D=0A
WAYBILL  DNot Reqd  No Yes  SL N14=0D=0A
=0D=0A
 =0D=0A
=0D=0A
So SELECTINDEX fails, has anyone experienced similar problems. The data=0D=
=0A
in the fields is always of the form 4A4N and there is a one to one=0D=0A
relationship between the field and the primary key.=0D=0A
=0D=0A
 =0D=0A
=0D=0A
Regards,=0D=0A
=0D=0A
Tim=0D=0A
=0D=0A
=0D=0A
Legal Disclaimer:=0A
The information contained in this message may be privileged and confident=
ial. It is intended to be read only by the individual or entity to whom i=
t is addressed or by their designee. If the reader of this message is not=
 the intended recipient, you are on notice that any distribution of this =
message, in any form, is strictly prohibited. If you have received this m=
essage in error, please immediately notify the sender and delete or destr=
oy any copy of this message=0D=0A
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Fw: [U2] [UV] QSELECT in transaction

[Herve Balestrieri]

 "QSELECT" builds a SELECTed list of values, which operation is also

 possible with the "SELECT" statement, as noted.

 But the "QSELECT" statement have some options that implies a "Read"

 operation from the "&SAVEDLISTS&" file. It is assumed that, the

 "&SAVEDLISTS&" file being generally a Type 1 or 19 file, a Transaction

 cannot be ensured on this type of file. Subsequently, "QSELECT" is not

 permitted at all.

 If the equivalent of a "QSELECT" satement is to be performed in an

 Transactionnal application, the various steps to be executed would have to

 be explicitly programmed within the Transaction. In that sort of

 "workaround" programming, the programmer and applicative layer instead of

 the database engine are made responsible for application data consistency.


 An enhancement request could be raised toward IBM to allow in transactions
 those of the "QSELECT" syntaxes which are not involving the "&SAVEDLIST&"
file.
 Though, I doubt the UniVerse Basic Run Machine has the ability to
differentiate
 these syntaxes "on the fly", so the restriction was made to easily secure

 the transaction in all cases.


Hervi BALESTRIERI

Support Technique Avanci - IBM France
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] QSELECT in transaction

[Mark Cornelissen]

I guess that's a question for IBM

Regards,

Mark Cornelissen
http://www.innovate-it.com

On Jul 31, 2006, at 16:10, Brian Whitehorn wrote:

Whats slightly confusing / inconsistent is that an EXECUTE with SELECT 
/
SSELECT is catered for inside a transaction but not QSELECT? Why allow 
/

cater for one and not the other?

-Brian.


Important Notice: This email is subject to important restrictions,
qualifications and disclaimers ("the Disclaimer") that must be accessed
and read at the following address or by copying and pasting the 
following
address into your Internet browser's address bar: 
http://www.frstia.co.za/Disclaimer.asp


The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to 
mailto:[EMAIL PROTECTED]


FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services 
Provider

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