Re: [U2] ODBC to UPS WorldShip

[Tony G]

I concur with Glen's assessment that some of these services can
be unstable.  Not long after writing NebulaShip
(nospamNebula-RnD.com/products/ship.htm) I realized that even
though the product was stable that we might be getting emergency
calls when services were down.  I stopped advertising the
product, we're not currently selling it, and unless there is
significant demand for some of the less critical functions
(lookups, confirmations) I may withdraw it entirely.  Make sure
you have backup providers for critical services.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com!  Contribute!

> From: Glen Batchelor 

> 3) You're tied to a web service that can (and will) go 
> down at some point. Have a backup processing plan with 
> WorldShip. UPS has been good, for the most part. FedEx 
> has gotten better, but there are still times when the 
> FedEx Ground back-end disappears and we get goofy 
> 'unavailable' errors.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Anthony W. Youngman]

In message 
, 
bradley.sch...@usbank.com writes

Thanks, Rod. One more thing. I've written a test program to simplify index
creation and building. When I run it under type U or type P using
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to
continue..." prompt after each screen of *'s. Definitely not desirable for
an automated process. It doesn't do this at TCL.

How can I work around this? I'd rather not throw a bunch of DATA
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'

iirc, UniVerse has the NO.PAGE keyword. Does UniData have it? And if so, 
does it work for BUILD.INDEX?


Cheers,
Wol
--
Anthony W. Youngman 
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[Henry Unger]

Good point, Andy. I had considered that, but guessed that it would not be a
significant factor.

Just in case, I created a file with a million records, and reran the tests.
Here are the results:

COUNT TESTFILE WITH F1 = 'V'
Elapsed 7.4796

COUNT TESTFILE WITH F1 = EVAL "'V'"
Elapsed 23.2558

Seems pretty consistent with the earlier tests.

Best regards,

Henry

Henry P. Unger
Hitech Systems, Inc.
http://www.hitech.com

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum
Sent: Thursday, July 16, 2009 2:52 PM
To: U2 Users List
Subject: Re: [U2] Universe Retrieve


Henry,


EVAL compiles the expression and writes the result into the dictionary, runs
the query and then deletes the dictionary item. For your test to be valid
you would need to ignore the overheads of the compile, write to and delete
from dictionary which in your example are significant compared to the number
of records counted. You could probably get more accurate results by choosing
an example that runs against a file with millions of records.

Cheers,

Andy


- Original Message 
From: Henry Unger 
To: U2 Users List 
Sent: Thursday, 16 July, 2009 18:36:27
Subject: Re: [U2] Universe  Retrieve

Hi Martin,

I was under the impression that an EVAL calls the same compiler that an
I-type does, and that any expression optimization would be done therein.
Expanding beyond that, it would be interesting if the I-type compiler was
able to detect that a particular expression does result in a constant value
and flag the object code as not requiring repeated evaluation by the query
processor.

Here are some empirical results using UniVerse 10.2.7:

>TIMEIT 50 COUNT VOC WITH F1 = 'V'
COUNT VOC WITH F1 = 'V'
Elapsed 1.3006

>TIMEIT 50 COUNT VOC WITH F1 = EVAL "'V'"
COUNT VOC WITH F1 = EVAL "'V'"
Elapsed 5.135

This suggests that the query processor does not detect that the result of
the evaluation is a constant and optimize its execution.

Best regards,

Henry

TIMEIT:

sent = @SENTENCE
rest = trimf(field(sent, ' ', 2, len(sent)))
word = field(rest, ' ', 1)
if word matches "0N" then
   n = int(word)
   sent = trimf(field(rest, ' ', 2, len(rest)))
end else
   n = 1
   sent = rest
end
print sent
t0 = time()
for i = 1 to n
   execute sent capturing output
next
t1 = time()
print 'Elapsed ' : t1 - t0

end

Henry P. Unger
Hitech Systems, Inc.
http://www.hitech.com

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Thursday, July 16, 2009 9:30 AM
To: U2 Users List
Subject: Re: [U2] Universe Retrieve

Hi Henry,

> You can see the object code that is produced using VLIST and
> examine it for optimizations.

The particular optimsiation that Barry is looking for would not show in the 
object code. For a truly constant I-type expression, the query procesor 
could evaluate it just once and store the result instead of doing it on 
every use. Although not common,  such I-types do exist.


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Don Verhagen]

In Unidata (v6.x) you can issue the command BUILD.INDEX MYFILE ALL. With the
KEYWORD ALL it's builds/rebuilds all the indexes that have been created on
the file.  I would hate to have to remember that INDEX_1 is say, Customer
Name, verus a dictionary named CUST_NAME.

I would agree with others, I rarely had any need to rebuild any indexes with
Unidata, other than part of a file resizing/space considerations.

Donald Verhagen
People 2.0

 



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
> Bill Haskett
> Sent: Thursday, July 16, 2009 4:52 PM
> To: U2 Users List
> Subject: Re: [U2] More questions on indexing
> 
> Brad:
> 
> I've defined indexes in my files with dictionary items like 
> "INDEX_1", 
> etc.  Thus only these dictionaries are ever used for 
> indexing.  A file 
> may have 4 or 5 indexes (INDEX_1 - INDEX_4).
> 
> I wrote another program to do the indexing for a single file or an 
> entire account by executing the command...
> 
> :ACCT-INDEX  CUSTFILE  -IINDEX_
> 
> ...which will create all the indexes on the CUSTFILE.  Also, my 
> dictionary listing will show these indexes separately so it 
> looks like:
> 
> Dictionary of File: APPO  
> 13:48:38 Jul 16 2009
> Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt 
> Assoc...
> 
> @UQ Phr   VENDNO CLIEN
>   TNO DISSUE A
>   UTH DESCT DC
>   LOSED
> INDEX_1 Indx  IF DCLOSED N
>   18L   S
>   E "" THEN CL
>   IENTNO "R(%4
>   )" : UNITNO
>   "R(%7)" : SE
>   QNO "R(%7)"
> @ID D 0   APPO
>   6RS
> PONOD 0   PO# 
>   7RS
> VENDNO  D 1   VEND#   
>   5RS
> CLIENTNOD 2   CLNT
>   4RS
> 
> 
> We don't normally rebuild indexes on UD v7.1 or v7.2.
> 
> HTH,
> 
> Bill
> 
> --
> --
> bradley.sch...@usbank.com said the following on 7/16/2009 1:18 PM:
> > Thanks, Rod. One more thing. I've written a test program to 
> simplify index 
> > creation and building. When I run it under type U or type P using 
> > BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
> > continue..." prompt after each screen of *'s. Definitely 
> not desirable for 
> > an automated process. It doesn't do this at TCL. 
> >
> > How can I work around this? I'd rather not throw a bunch of DATA 
> > statements in there.
> >
> >
> > EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
> > DATA 20
> > EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
> > EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'
> >
> >
> > TIA,
> > Brad.
> >
> >   
> >> Please respond to U2 Users List
> >>
> >>  I think Oracle's indexing scheme is much more complicated that
> >> Unidata's, so I don't think you can compare the two. I do 
> rebuild some
> >> of the dynamic files on occasion to get some space back. Other than
> >> that, I leave them alone and haven't had problems. - Rod
> >>
> >> 
> >
> >
> >   
> >> Research continues and I have more question for the group: 
> my Oracle 
> >> buddies rebuild their indexes at least weekly. Seems to be a best 
> >> practice. Seems odd to not be able to trust that your 
> index is correct.
> >> Is 
> >> this a concern for ud 7.1? 
> >>
> >> TIA,
> >> Brad.
> >>
> >> ud 7.1
> >> AIX 5.3
> >> U.S. BANCORP made the following annotations
> >> 
> >
> > U.S. BANCORP made the following annotations
> > 
> -
> > Electronic Privacy Notice. This e-mail, and any 
> attachments, contains information that is, or may be, covered 
> by electronic communications privacy laws, and is also 
> confidential and proprietary in nature. If you are not the 
> intended recipient, please be advised that you are legally 
> prohibited from retaining, using, copying, distributing, or 
> otherwise disclosing this information in any manner. Instead, 
> please reply to the sender that you have received this 
> communication in error, and then immediately delete it. Thank 
> you in advance for your cooperation.
> >
> >
> >
> > 
> -
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >   
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2

Re: [U2] ODBC to UPS WorldShip

[Glen Batchelor]

  Consider becoming a customer integrator and use the web XML API. It's not
that complicated to implement if you're doing domestics only. If you're
doing international, then it's a bit more complex but nothing like FedEx.
We've been fully automated with both FedEx and UPS in terms of
domestic/international shipment processing, credit card charging, billing,
and invoice delivery for well over 2 years now. The drawbacks to using the
UPS XML service are:

1) It's not a SOAP service so you have to do your own element checking for
proper return document format.

2) The shipping process requires multiple submissions to the UPS server.
First, a request to verify you can ship the package is sent. Then you send
an "ok" to tell UPS that you're fine with the previous "inquiry" to ship a
package. Then you get your label and charges. I don't understand this at all
because the package will not get billed if it's not scanned at the hub. :-)

3) You're tied to a web service that can (and will) go down at some point.
Have a backup processing plan with WorldShip. UPS has been good, for the
most part. FedEx has gotten better, but there are still times when the FedEx
Ground back-end disappears and we get goofy 'unavailable' errors.

4) If you process a lot of collect shipments, then be weary of the "fraud
validation" step that validates the bill-to account's "set up" zip code to
the account number being charged. If you can't get the zip code the account
was set up under, then you'll end up having to run it through WorldShip.
Most shippers are totally unaware of this and the fact that WorldShip does
_not_ validate account status at all. It only performs an alphanumeric check
on the 6-chars. You will get a chargeback after delivery, if the account has
been closed or suspended. We have been fighting with UPS for over 2 years on
this stupid "fraud check" that is practically worthless and makes us look
like we don't want to do business with huge customers. The live account
status check is great, though.

5) The validation/certification step is a breeze to do, but you will have to
generate a handful of example labels to prove your stuff works properly for
the services and features you want to integrate.

 The benefits of automation and full integration into the packing
application on our system outweighed these drawbacks. If you ship over 1000
packages a day then you should consider an EDI or FTP based PLD
build/transmit solution and generate your own labels. WorldShip changes too
much too often for it to be a stable integration platform for my taste. We
have to have it for HazMat shipments and as a fall-back shipping terminal.

Regards,


Glen Batchelor
IT Director
All-Spec Industries
 phone: (910) 332-0424
   fax: (910) 763-5664
E-mail: webmas...@all-spec.com
   Web: http://www.all-spec.com
  Blog: http://blog.all-spec.com


> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill
> Sent: Thursday, July 16, 2009 11:20 AM
> To: U2 Users List
> Subject: Re: [U2] ODBC to UPS WorldShip
> 
> 
> UniVerse ODBC Client
> Version 4.0.3
> Build 7251
> February, 2008
>  on both PC's
> 
> We are not SHIMS.  We are not Prelude.
> 
> This may be a lost cause.  Perhaps a better way to approach this problem
> is via an external program talking to the UPS database.
> 
> --Bill
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
> Sent: Wednesday, July 15, 2009 8:29 PM
> To: U2 Users List
> Subject: Re: [U2] ODBC to UPS WorldShip
> 
> I am in the process of doing this right now.  What version of the ibm
> odbc driver do you have installed?  My var warned me against one
> version, but they didn't elaborate why.  Are you a SHIMS or Prelude
> shop?
> 
> -Original Message-
> From: Brutzman, Bill 
> Sent: Wednesday, July 15, 2009 7:47 PM
> To: U2 Users List 
> Subject: [U2]  ODBC to UPS WorldShip
> 
> 
> Using a Windows PC, I am able to obtain a bona fide ODBC connection to
> UniVerse... and then import UV data to Excel.
> 
> However... When I try to connect from United Parcel Service's WorldShip
> v11, WorldShip hangs up with Windows Task Manager indicating "Not
> Responding".  I had the same bad result on two different PC's... One
> Vista-Ultimate, one XP-Pro.
> 
> I am wondering if anyone out there was able to get WorldShip ODBC to
> work with U2.  Suggestions would be appreciated.
> 
> --Bill
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[andy baum]

Henry,


EVAL compiles the expression and writes the result into the dictionary, runs 
the query and then deletes the dictionary item. For your test to be valid you 
would need to ignore the overheads of the compile, write to and delete from 
dictionary which in your example are significant compared to the number of 
records counted. You could probably get more accurate results by choosing an 
example that runs against a file with millions of records.

Cheers,

Andy


- Original Message 
From: Henry Unger 
To: U2 Users List 
Sent: Thursday, 16 July, 2009 18:36:27
Subject: Re: [U2] Universe  Retrieve

Hi Martin,

I was under the impression that an EVAL calls the same compiler that an
I-type does, and that any expression optimization would be done therein.
Expanding beyond that, it would be interesting if the I-type compiler was
able to detect that a particular expression does result in a constant value
and flag the object code as not requiring repeated evaluation by the query
processor.

Here are some empirical results using UniVerse 10.2.7:

>TIMEIT 50 COUNT VOC WITH F1 = 'V'
COUNT VOC WITH F1 = 'V'
Elapsed 1.3006

>TIMEIT 50 COUNT VOC WITH F1 = EVAL "'V'"
COUNT VOC WITH F1 = EVAL "'V'"
Elapsed 5.135

This suggests that the query processor does not detect that the result of
the evaluation is a constant and optimize its execution.

Best regards,

Henry

TIMEIT:

sent = @SENTENCE
rest = trimf(field(sent, ' ', 2, len(sent)))
word = field(rest, ' ', 1)
if word matches "0N" then
   n = int(word)
   sent = trimf(field(rest, ' ', 2, len(rest)))
end else
   n = 1
   sent = rest
end
print sent
t0 = time()
for i = 1 to n
   execute sent capturing output
next
t1 = time()
print 'Elapsed ' : t1 - t0

end

Henry P. Unger
Hitech Systems, Inc.
http://www.hitech.com

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Thursday, July 16, 2009 9:30 AM
To: U2 Users List
Subject: Re: [U2] Universe Retrieve

Hi Henry,

> You can see the object code that is produced using VLIST and
> examine it for optimizations.

The particular optimsiation that Barry is looking for would not show in the 
object code. For a truly constant I-type expression, the query procesor 
could evaluate it just once and store the result instead of doing it on 
every use. Although not common,  such I-types do exist.


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] ODBC to UPS WorldShip

[John Hester]

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
> Brutzman, Bill
> Sent: Thursday, July 16, 2009 8:20 AM
> To: U2 Users List
> Subject: Re: [U2] ODBC to UPS WorldShip
> 
>   
> UniVerse ODBC Client   
> Version 4.0.3
> Build 7251
> February, 2008 
>  on both PC's
> 
> We are not SHIMS.  We are not Prelude.
> 
> This may be a lost cause.  Perhaps a better way to approach 
> this problem
> is via an external program talking to the UPS database.
> 
> --Bill

We just use samba and delimited flat files to capture tracking #'s from
our UPS and Fedex workstations.  We've been doing this for years without
any serious issues.  We did have to get both companies to write us a
custom script to export the data to a flat file, though, and we do
sometimes experience problems when they force an upgrade on us.  But if
you're a volume shipper, they'll work with you.

-John
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Baakkonen, Rodney A (Rod) 46K]

 One more thing that we do. We build a database of our indexes every
night using a 'cron'. It does a 
find / \( -name 'idx001' -o -name 'X_*' \) at a UNIX level.

The results of this 'find' are then passed into a Unidata program. Using
a combination of LIST.INDEX and INDICES we get all the info we need to
build the index and write a record to a database using the FILE.NAME as
the key. We then have a process to rebuild indexes using this database.
So if I want to re-build an index. I just type REBUILD.INDEX file name
and everything gets redone. This is really nice for when you have a file
with 10 indexes and you want to rebuild it. -Rod


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent: Thursday, July 16, 2009 3:25 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

 I usually do a TERM 132,999

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify
index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable
for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is
correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Bill Haskett]

Brad:

I've defined indexes in my files with dictionary items like "INDEX_1", 
etc.  Thus only these dictionaries are ever used for indexing.  A file 
may have 4 or 5 indexes (INDEX_1 - INDEX_4).


I wrote another program to do the indexing for a single file or an 
entire account by executing the command...


:ACCT-INDEX  CUSTFILE  -IINDEX_

...which will create all the indexes on the CUSTFILE.  Also, my 
dictionary listing will show these indexes separately so it looks like:


Dictionary of File: APPO  13:48:38 Jul 16 2009
Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt 
Assoc...


@UQ Phr   VENDNO CLIEN
 TNO DISSUE A
 UTH DESCT DC
 LOSED
INDEX_1 Indx  IF DCLOSED N  18L   S
 E "" THEN CL
 IENTNO "R(%4
 )" : UNITNO
 "R(%7)" : SE
 QNO "R(%7)"
@ID D 0   APPO  6RS
PONOD 0   PO#   7RS
VENDNO  D 1   VEND# 5RS
CLIENTNOD 2   CLNT  4RS


We don't normally rebuild indexes on UD v7.1 or v7.2.

HTH,

Bill


bradley.sch...@usbank.com said the following on 7/16/2009 1:18 PM:
Thanks, Rod. One more thing. I've written a test program to simplify index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.



EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

  

Please respond to U2 Users List

 I think Oracle's indexing scheme is much more complicated that
Unidata's, so I don't think you can compare the two. I do rebuild some
of the dynamic files on occasion to get some space back. Other than
that, I leave them alone and haven't had problems. - Rod





  
Research continues and I have more question for the group: my Oracle 
buddies rebuild their indexes at least weekly. Seems to be a best 
practice. Seems odd to not be able to trust that your index is correct.
Is 
this a concern for ud 7.1? 


TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations



U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[David A. Green]

TERM 132,0 should work too.

Thanks,
David A. Green
www.dagconsulting.com
(480) 813-1725


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney
A (Rod) 46K
Sent: Thursday, July 16, 2009 1:25 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

 I usually do a TERM 132,999

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify
index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable
for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is
correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[David A. Green]

Any PRINT @ will turn off automatic pagination.  You can also use BPIOCPN.

Thanks,
David A. Green
www.dagconsulting.com
(480) 813-1725


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 1:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank
you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Baakkonen, Rodney A (Rod) 46K]

 I usually do a TERM 132,999

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify
index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable
for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is
correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[Martin Phillips]

Hi Henry,


I did say "not", so we are saying the same thing.


Whoops! I missed one word. Guess which one!


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Mark Eastwood]

Try adding "CAPTURING TRASH" to the end of your EXECUTE statements.

Mark

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 1:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify
index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable
for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Israel, John R.]

In your program, do a CRT @(-1) at the top of the program to disable the paging.

John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 4:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

Thanks, Rod. One more thing. I've written a test program to simplify index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Doug]

Brad,

We have a client with over 3 million records with 14 indices running on
Unidata 7.2.  We have never rebuilt the indexes in over two years.  The last
time we rebuilt them we added some 2 more indexes.  We just purged about a
1/2 million records with no problems on the indexes that are used everyday
from our Web data entry and reports forms.

Regards,
Doug
www.u2logic.com  

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney
A (Rod) 46K
Sent: Thursday, July 16, 2009 2:07 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing

 I think Oracle's indexing scheme is much more complicated that Unidata's,
so I don't think you can compare the two. I do rebuild some of the dynamic
files on occasion to get some space back. Other than that, I leave them
alone and haven't had problems. - Rod

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:00 PM
To: U2 Users List
Subject: [U2] More questions on indexing

Research continues and I have more question for the group: my Oracle buddies
rebuild their indexes at least weekly. Seems to be a best practice. Seems
odd to not be able to trust that your index is correct.
Is
this a concern for ud 7.1? 

TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank
you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users






--
CONFIDENTIALITY NOTICE: If you have received this email in error, please
immediately notify the sender by e-mail at the address shown.  This email
transmission may contain confidential information.  This information is
intended only for the use of the individual(s) or entity to whom it is
intended even if addressed incorrectly.  Please delete it from your files if
you are not the intended recipient.  Thank you for your compliance.
Copyright 2009 CIGNA

==

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Mark Eastwood]

It's probably for performance - when a table has lots of
inserts/deletions the index gets "fragmented".


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 1:00 PM
To: U2 Users List
Subject: [U2] More questions on indexing

Research continues and I have more question for the group: my Oracle 
buddies rebuild their indexes at least weekly. Seems to be a best 
practice. Seems odd to not be able to trust that your index is correct.
Is 
this a concern for ud 7.1? 

TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[bradley . schrag]

Thanks, Rod. One more thing. I've written a test program to simplify index 
creation and building. When I run it under type U or type P using 
BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
continue..." prompt after each screen of *'s. Definitely not desirable for 
an automated process. It doesn't do this at TCL. 

How can I work around this? I'd rather not throw a bunch of DATA 
statements in there.


EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
DATA 20
EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'


TIA,
Brad.

> 
> Please respond to U2 Users List
> 
>  I think Oracle's indexing scheme is much more complicated that
> Unidata's, so I don't think you can compare the two. I do rebuild some
> of the dynamic files on occasion to get some space back. Other than
> that, I leave them alone and haven't had problems. - Rod
> 


> Research continues and I have more question for the group: my Oracle 
> buddies rebuild their indexes at least weekly. Seems to be a best 
> practice. Seems odd to not be able to trust that your index is correct.
> Is 
> this a concern for ud 7.1? 
> 
> TIA,
> Brad.
> 
> ud 7.1
> AIX 5.3
> U.S. BANCORP made the following annotations

U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Baakkonen, Rodney A (Rod) 46K]

 I think Oracle's indexing scheme is much more complicated that
Unidata's, so I don't think you can compare the two. I do rebuild some
of the dynamic files on occasion to get some space back. Other than
that, I leave them alone and haven't had problems. - Rod

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:00 PM
To: U2 Users List
Subject: [U2] More questions on indexing

Research continues and I have more question for the group: my Oracle 
buddies rebuild their indexes at least weekly. Seems to be a best 
practice. Seems odd to not be able to trust that your index is correct.
Is 
this a concern for ud 7.1? 

TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users





--
CONFIDENTIALITY NOTICE: If you have received this email in error, please 
immediately notify the sender by e-mail at the address shown.  This email 
transmission may contain confidential information.  This information is 
intended only for the use of the individual(s) or entity to whom it is intended 
even if addressed incorrectly.  Please delete it from your files if you are not 
the intended recipient.  Thank you for your compliance.  Copyright 2009 CIGNA
==

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] More questions on indexing

[bradley . schrag]

Research continues and I have more question for the group: my Oracle 
buddies rebuild their indexes at least weekly. Seems to be a best 
practice. Seems odd to not be able to trust that your index is correct. Is 
this a concern for ud 7.1? 

TIA,
Brad.

ud 7.1
AIX 5.3
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[Henry Unger]

Hi Martin,

I did say "not", so we are saying the same thing.

I like that QM is smart about it.

Best regards,

Henry

Henry P. Unger
Hitech Systems, Inc.
http://www.hitech.com

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Thursday, July 16, 2009 12:36 PM
To: U2 Users List
Subject: Re: [U2] Universe Retrieve

Hi Henry,

> I was under the impression that an EVAL calls the same compiler
> that an I-type does, and that any expression optimization would be
> done therein.

As far as I know, EVAL does indeed  call the same compiler. As I think you 
realise, the point is that an I-type expression such as
   1: I
   2: SPACE(3)
(which I have seen used to get differing column spacings) will compile to a 
pcode sequence that produces a string of three spaces. This does not tell us

how the query processor will then go on to use it. A "normal" I-type 
expression, whether from the dictionary or from use of EVAL, would be 
executed for each occurrence of it in the report, typically once per record.

In the case of my spacing expression above, the query processor would 
actually only need to evaluate the expression once and then drop it into the

report as a constant item.

I think that this is what the original poster was asking about. I have no 
idea whether UV does this (QM does). Your experiment seems to tell us.

> Here are some empirical results using UniVerse 10.2.7:
>
>>TIMEIT 50 COUNT VOC WITH F1 = 'V'
> COUNT VOC WITH F1 = 'V'
> Elapsed 1.3006
>
>>TIMEIT 50 COUNT VOC WITH F1 = EVAL "'V'"
> COUNT VOC WITH F1 = EVAL "'V'"
> Elapsed 5.135
>
> This suggests that the query processor does not detect that the result of
> the evaluation is a constant and optimize its execution.

No, I think that this is actually showing the opposite. The query was 
considerably faster where your test was a simple literal
   WITH F1 = 'V'
whereas the EVAL expression added a further four seconds to your query. If 
the query processor detected that
   EVAL "'V'"
was a constant and optimised it I would expect both queries to take the same

time. It does look as though it is evaluating the expression for every 
record.


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[Martin Phillips]

Hi Henry,


I was under the impression that an EVAL calls the same compiler
that an I-type does, and that any expression optimization would be
done therein.


As far as I know, EVAL does indeed  call the same compiler. As I think you 
realise, the point is that an I-type expression such as

  1: I
  2: SPACE(3)
(which I have seen used to get differing column spacings) will compile to a 
pcode sequence that produces a string of three spaces. This does not tell us 
how the query processor will then go on to use it. A "normal" I-type 
expression, whether from the dictionary or from use of EVAL, would be 
executed for each occurrence of it in the report, typically once per record. 
In the case of my spacing expression above, the query processor would 
actually only need to evaluate the expression once and then drop it into the 
report as a constant item.


I think that this is what the original poster was asking about. I have no 
idea whether UV does this (QM does). Your experiment seems to tell us.



Here are some empirical results using UniVerse 10.2.7:


TIMEIT 50 COUNT VOC WITH F1 = 'V'

COUNT VOC WITH F1 = 'V'
Elapsed 1.3006


TIMEIT 50 COUNT VOC WITH F1 = EVAL "'V'"

COUNT VOC WITH F1 = EVAL "'V'"
Elapsed 5.135

This suggests that the query processor does not detect that the result of
the evaluation is a constant and optimize its execution.


No, I think that this is actually showing the opposite. The query was 
considerably faster where your test was a simple literal

  WITH F1 = 'V'
whereas the EVAL expression added a further four seconds to your query. If 
the query processor detected that

  EVAL "'V'"
was a constant and optimised it I would expect both queries to take the same 
time. It does look as though it is evaluating the expression for every 
record.



Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[Henry Unger]

Hi Martin,

I was under the impression that an EVAL calls the same compiler that an
I-type does, and that any expression optimization would be done therein.
Expanding beyond that, it would be interesting if the I-type compiler was
able to detect that a particular expression does result in a constant value
and flag the object code as not requiring repeated evaluation by the query
processor.

Here are some empirical results using UniVerse 10.2.7:

>TIMEIT 50 COUNT VOC WITH F1 = 'V'
COUNT VOC WITH F1 = 'V'
Elapsed 1.3006

>TIMEIT 50 COUNT VOC WITH F1 = EVAL "'V'"
COUNT VOC WITH F1 = EVAL "'V'"
Elapsed 5.135

This suggests that the query processor does not detect that the result of
the evaluation is a constant and optimize its execution.

Best regards,

Henry

TIMEIT:

sent = @SENTENCE
rest = trimf(field(sent, ' ', 2, len(sent)))
word = field(rest, ' ', 1)
if word matches "0N" then
   n = int(word)
   sent = trimf(field(rest, ' ', 2, len(rest)))
end else
   n = 1
   sent = rest
end
print sent
t0 = time()
for i = 1 to n
   execute sent capturing output
next
t1 = time()
print 'Elapsed ' : t1 - t0

end

Henry P. Unger
Hitech Systems, Inc.
http://www.hitech.com

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Thursday, July 16, 2009 9:30 AM
To: U2 Users List
Subject: Re: [U2] Universe Retrieve

Hi Henry,

> You can see the object code that is produced using VLIST and
> examine it for optimizations.

The particular optimsiation that Barry is looking for would not show in the 
object code. For a truly constant I-type expression, the query procesor 
could evaluate it just once and store the result instead of doing it on 
every use. Although not common,  such I-types do exist.


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[Martin Phillips]

Hi Henry,


You can see the object code that is produced using VLIST and
examine it for optimizations.


The particular optimsiation that Barry is looking for would not show in the 
object code. For a truly constant I-type expression, the query procesor 
could evaluate it just once and store the result instead of doing it on 
every use. Although not common,  such I-types do exist.



Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[Brian Leach]

Barry

'Date() - 14' isn't constant - the Date() function is designed specifically
to be evaluated each time. '@DATE - 14', on the other hand, should be
constant.

You should see a difference between the two if you run a query across
midnight...

Same with TIME() and @TIME: try both on a long LIST or SORT and you'll see
what I mean

:)

Brian 

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen
> Sent: 16 July 2009 16:39
> To: U2 Users List
> Subject: [U2] Universe Retrieve
> 
> 
>   Question:  If  you are doing a select statement and within 
> the statement you have a eval phrase and this eval phrase 
> contains all constants (ie,  DATE() - 14),  does Universe 
> recalculate that constant value with each record iteration or 
> is it smart enough to know that this is a constant value and 
> therefore only calculates it once ?
> 
> Barry  Rogen
> PNY Technologies, Inc.
> Senior  Programmer/Analyst
> (973)  515 - 9700  ext 5327
> bro...@pny.com
> 
> -
> We are continually faced with great opportunities 
> brilliantly disguised as insoluble problems.
>  
> John W Gardner
> 
> P Before printing please think about your environmental responsibility
> 
> 
> 
> 16/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING 
> 
> NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY 
> BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A 
> BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR 
> ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, 
> NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC 
> TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE 
> OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT.  THIS EMAIL 
> MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO 
> REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A 
> CONTRACT.  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF 
> WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL 
> ALTER THIS DISCLAIMER.  
> 
> This e-mail message from PNY Technologies, Inc. is for the 
> sole use of the intended recipient(s) and may contain 
> confidential and privileged information. Any unauthorized 
> review, use, disclosure or distribution is prohibited. If you 
> are not the intended recipient, please contact the sender by 
> reply e-mail and destroy all copies of the original message. 
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe Retrieve

[Henry Unger]

DATE() is not a constant, but rather a function that will return a different
value each day.

You can see the object code that is produced using VLIST and examine it for
optimizations.

Best regards,

Henry

Henry P. Unger
Hitech Systems, Inc.
http://www.hitech.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen
Sent: Thursday, July 16, 2009 8:39 AM
To: U2 Users List
Subject: [U2] Universe Retrieve


  Question:  If  you are doing a select statement and within the
statement you have a eval phrase and this eval phrase contains all
constants (ie,  DATE() - 14),  does Universe recalculate that constant
value with each record iteration or is it smart enough to know that this
is a constant value and therefore only calculates it once ?

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
bro...@pny.com

-
We are continually faced with great opportunities
brilliantly disguised as insoluble problems.
 John W
Gardner

P Before printing please think about your environmental responsibility



16/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING 

NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR
IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY
CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING
OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC
TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW
OF SIMILAR SUBSTANCE OR EFFECT.  THIS EMAIL MESSAGE, ITS CONTENTS AND
ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER
TO ENTER INTO A CONTRACT.  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF
WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS
DISCLAIMER.  

This e-mail message from PNY Technologies, Inc. is for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message. 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Universe Retrieve

[Barry Rogen]

  Question:  If  you are doing a select statement and within the
statement you have a eval phrase and this eval phrase contains all
constants (ie,  DATE() - 14),  does Universe recalculate that constant
value with each record iteration or is it smart enough to know that this
is a constant value and therefore only calculates it once ?

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
bro...@pny.com

-
We are continually faced with great opportunities
brilliantly disguised as insoluble problems.
 John W
Gardner

P Before printing please think about your environmental responsibility



16/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING 

NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN 
ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY 
CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING 
OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC 
TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF 
SIMILAR SUBSTANCE OR EFFECT.  THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS 
ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO 
A CONTRACT.  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A 
PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.  

This e-mail message from PNY Technologies, Inc. is for the sole use of the 
intended recipient(s) and may contain confidential and privileged information. 
Any unauthorized review, use, disclosure or distribution is prohibited. If you 
are not the intended recipient, please contact the sender by reply e-mail and 
destroy all copies of the original message. 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] ODBC to UPS WorldShip

[Garry Smith]

We are doing this with separate ODBC account that has a subset of
dictionaries with I-descriptors that call subroutines to extract the
required data back to UPS. The VOC entries on the ODBC account point
back to the production data.
We used a different logon since we did not want our Universe application
to execute all the "startup/login" for a typical menu based user. The
first transaction of the day takes the longest time to execute.
You need to have all the data elements defined in the @SELECT and
dictionary items should not have "." period but instead an
underscore(AR.ID  -> AR_ID). Another reason we use a separate
dictionary. Also, make sure to follow all the steps in the HS.ADMIN for
your ODBC account, and anytime you and a new dictionary item or compile
an I-descriptor.

We have been doing this for about 4 years. Since, ODBC only supports
INSERT and UPDATE, we have a UPS script the executes after each shipment
and 'appends' the ship-out data to a SAMBA directory on our UNIX box and
then a phantom routine runs every 15 minutes to read the entries in the
file and post to our production data, and then delete the file.

How are you using the UPS connection, "Keyed Import" ?


Garry L. Smith
Dir Info Systems
Charles McMurray Company
V# 559-292-5782   F# 559-346-6169

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman,
Bill
Sent: Thursday, July 16, 2009 8:20 AM
To: U2 Users List
Subject: Re: [U2] ODBC to UPS WorldShip

  
UniVerse ODBC Client   
Version 4.0.3
Build 7251
February, 2008
 on both PC's

We are not SHIMS.  We are not Prelude.

This may be a lost cause.  Perhaps a better way to approach this problem
is via an external program talking to the UPS database.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Wednesday, July 15, 2009 8:29 PM
To: U2 Users List
Subject: Re: [U2] ODBC to UPS WorldShip

I am in the process of doing this right now.  What version of the ibm
odbc driver do you have installed?  My var warned me against one
version, but they didn't elaborate why.  Are you a SHIMS or Prelude
shop?

-Original Message-
From: Brutzman, Bill 
Sent: Wednesday, July 15, 2009 7:47 PM
To: U2 Users List 
Subject: [U2]  ODBC to UPS WorldShip


Using a Windows PC, I am able to obtain a bona fide ODBC connection to
UniVerse... and then import UV data to Excel.

However... When I try to connect from United Parcel Service's WorldShip
v11, WorldShip hangs up with Windows Task Manager indicating "Not
Responding".  I had the same bad result on two different PC's... One
Vista-Ultimate, one XP-Pro.

I am wondering if anyone out there was able to get WorldShip ODBC to
work with U2.  Suggestions would be appreciated.

--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] ODBC to UPS WorldShip

[Steve Romanow]

Brutzman, Bill wrote:
  
UniVerse ODBC Client   
Version 4.0.3

Build 7251
February, 2008 
 on both PC's


We are not SHIMS.  We are not Prelude.

This may be a lost cause.  Perhaps a better way to approach this problem
is via an external program talking to the UPS database.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Wednesday, July 15, 2009 8:29 PM
To: U2 Users List
Subject: Re: [U2] ODBC to UPS WorldShip

I am in the process of doing this right now.  What version of the ibm
odbc driver do you have installed?  My var warned me against one
version, but they didn't elaborate why.  Are you a SHIMS or Prelude
shop?

-Original Message-
From: Brutzman, Bill 
Sent: Wednesday, July 15, 2009 7:47 PM
To: U2 Users List 
Subject: [U2]  ODBC to UPS WorldShip


Using a Windows PC, I am able to obtain a bona fide ODBC connection to
UniVerse... and then import UV data to Excel.

However... When I try to connect from United Parcel Service's WorldShip
v11, WorldShip hangs up with Windows Task Manager indicating "Not
Responding".  I had the same bad result on two different PC's... One
Vista-Ultimate, one XP-Pro.

I am wondering if anyone out there was able to get WorldShip ODBC to
work with U2.  Suggestions would be appreciated.

--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
  
Let me check with my contact and see if 4.03 is the one they told me to 
avoid.  brb

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] ODBC to UPS WorldShip

[Brutzman, Bill]

  
UniVerse ODBC Client   
Version 4.0.3
Build 7251
February, 2008 
 on both PC's

We are not SHIMS.  We are not Prelude.

This may be a lost cause.  Perhaps a better way to approach this problem
is via an external program talking to the UPS database.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Wednesday, July 15, 2009 8:29 PM
To: U2 Users List
Subject: Re: [U2] ODBC to UPS WorldShip

I am in the process of doing this right now.  What version of the ibm
odbc driver do you have installed?  My var warned me against one
version, but they didn't elaborate why.  Are you a SHIMS or Prelude
shop?

-Original Message-
From: Brutzman, Bill 
Sent: Wednesday, July 15, 2009 7:47 PM
To: U2 Users List 
Subject: [U2]  ODBC to UPS WorldShip


Using a Windows PC, I am able to obtain a bona fide ODBC connection to
UniVerse... and then import UV data to Excel.

However... When I try to connect from United Parcel Service's WorldShip
v11, WorldShip hangs up with Windows Task Manager indicating "Not
Responding".  I had the same bad result on two different PC's... One
Vista-Ultimate, one XP-Pro.

I am wondering if anyone out there was able to get WorldShip ODBC to
work with U2.  Suggestions would be appreciated.

--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Fw: COMMON misMatch

[Don_Bausili]

Since all common variables are cleared when you exit UniVerse, and 
eliminates the error, is it possible your user used a LOGTO command to 
switch environments that have different versions of the subroutine 
HOP.R87?

We had both a Test and a Prod environment on the same box, and experienced 
problems when enhanced code in Test was being staged for promotion into 
Prod.  Executing a program in Test that had changes to its COMMON, and 
then logging into Prod resulted in the size mismatch error when running 
the unchanged program.

Our solution was to insert "CLEARCOMMON" in the LOGIN paragraphs.

Don
- Forwarded by Don Bausili/OK/HCSC on 07/16/2009 09:09 AM -

"Brutzman, Bill"  
Sent by: u2-users-boun...@listserver.u2ug.org
07/15/2009 06:55 PM
Please respond to
"U2 Users List" 


To
"U2 Users List" 
cc

Subject
Re: [U2] COMMON misMatch







A user here obtained an error message...

 "COMMON size mismatch in subroutine "HOP.R87".

Upon logging out and then logging back in again... The HOP program was
able to launch without this error.

Help with a diagnosis and more reliable cure would be appreciated.

This user is WinXP / Dynamic Connect / UniVerse 10.1 / HP-Ux 11i v2.

--Bill

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee.  Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful.  If you have received this
communication in error, please notify the sender immediately at (312)
653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
Oklahoma; or (972)766-6900 in Texas.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] COMMON misMatch

[Brutzman, Bill]

1. The program was not created by an auto-generator. 

2. The user only has one way to go in.

3. Others here may have been in the program when he went in.  Also,
others here have access to an older version of 
the program that may have been active when this user went in... likely
having the same COMMON definition.

4. I am glad to be reminded of MaVerick.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W.
Youngman
Sent: Thursday, July 16, 2009 7:24 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] COMMON misMatch

In message
<2b1985075953c947a7a53a53987adab22b5...@arnold.hkmetalcraft.lan>,
"Brutzman, Bill"  writes
>
>A user here obtained an error message...
>
>   "COMMON size mismatch in subroutine "HOP.R87".
>
>Upon logging out and then logging back in again... The HOP program was 
>able to launch without this error.
>
>Help with a diagnosis and more reliable cure would be appreciated.
>
>This user is WinXP / Dynamic Connect / UniVerse 10.1 / HP-Ux 11i v2.
>
Has this program been created by an auto-generator program? Did the user
go into the program by the *same* *route* both times after logging in?

If you've got a program generator auto-generating named common names you
have to be very careful - I fell foul of that a couple of times with
&PACE.

Cheers,
Wol
--
Anthony W. Youngman  'Yings, yow graley
yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What
*is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the
thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the
MaVerick web-site -  Open Source Pick
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SAVE-LIST [FILENAME] LISTNAME

[George Gallen]

I Just tested this.

If the file is a type 30 file, and you do an open path, it sill only
reads the items in the DATA/OVER.30 portion, and ignores any other
files that are in the directory, like ones that SAVE.LIST would put
there.



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Thursday, July 16, 2009 9:47 AM
> To: U2 Users List
> Subject: Re: [U2] SAVE-LIST [FILENAME] LISTNAME
>

> although, that could be an undocumented feature of save-list, you can
>write items to a type 30 file, that can't be read back or listed.
>so if you wanted to hide some information. I haven't checked but
>I wonder if you did an OPENPATH "filename" would it show up then?
>It would be invisible to the system because it's a type 30 and the
>system is only looking at the DATA/OVER.30 files.
>
> h
>
> George
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SAVE-LIST [FILENAME] LISTNAME

[George Gallen]

that's from basic, I meant from the ">" prompt.

Save-list works, but only to type 1/19 files, not with type 30 files,
   well, it still works, but not in a usable way.

although, that could be an undocumented feature of save-list, you can
   write items to a type 30 file, that can't be read back or listed.
   so if you wanted to hide some information. I haven't checked but
   I wonder if you did an OPENPATH "filename" would it show up then?
   It would be invisible to the system because it's a type 30 and the
   system is only looking at the DATA/OVER.30 files.

h

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
> Sent: Wednesday, July 15, 2009 10:53 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] SAVE-LIST [FILENAME] LISTNAME
>
>
> Oops, my bad.  I should have said use READLIST, or READSELECT (I use
> basictype P) and then write the array out.
>
> > Date: Wed, 15 Jul 2009 16:36:04 -0700
> > From: grsassocia...@gmail.com
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] SAVE-LIST [FILENAME] LISTNAME
> >
> > Outside the U2 world (mvBase, Reality) you can just
> > COPY-LIST xyz
> > (fname item
> >
> > I'd be surprised if that didn't work in U2 as well.
> >
> >
> > On Wed, Jul 15, 2009 at 4:22 PM, Colin Jennings <
> > colin.jenni...@btconnect.com> wrote:
> >
> > > SoIs there a reverse of FORM.LIST? that is take a LIST and
> write it as
> > >> an item to a file?
> > >>
> > >> This is UV 10.0.3
> > >>
> > >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] COMMON misMatch

[Anthony W. Youngman]

In message 
<2b1985075953c947a7a53a53987adab22b5...@arnold.hkmetalcraft.lan>, 
"Brutzman, Bill"  writes


A user here obtained an error message...

  "COMMON size mismatch in subroutine "HOP.R87".

Upon logging out and then logging back in again... The HOP program was
able to launch without this error.

Help with a diagnosis and more reliable cure would be appreciated.

This user is WinXP / Dynamic Connect / UniVerse 10.1 / HP-Ux 11i v2.

Has this program been created by an auto-generator program? Did the user 
go into the program by the *same* *route* both times after logging in?


If you've got a program generator auto-generating named common names you 
have to be very careful - I fell foul of that a couple of times with 
&PACE.


Cheers,
Wol
--
Anthony W. Youngman 
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users