Re: [U2] Double Indexes

2005-10-20 Thread Stuart . Boydell 
   UV  _should_  optimise  2-up  secondary  index selections (Glenn put a
   really  good  whitepaper on the list about indexes once - I can't find
   my copy now), use LIST/EXPLAIN to see if your indices are in use... My
   2mil  record  test file uses 2 indices without a struggle returning  a
   result in about a second or so.
   >LIST SUPPORD IF REC.TYPE = "O" AND IF ORD.DATE = "11/04/04" EXPLAIN
   Single-variable predicates processed in index:
   F6 = 'O' AND F3 = '13251'
   Optimizing query block 0
   Driver source: SUPPORD
   Access method: select list 0 with 249 ids
   UniVerse/SQL: Press any key to continue or 'Q' to quit
   >
   --
   Or try MERGE.LIST to see if that improves performance:
   SELECT FILE WITH DATE = "10.18" TO 1
   SELECT FILE WITH CUST = "12345" TO 2
   MERGE.LIST 1 INTERSECT 2
   [EMAIL PROTECTED] wrote: -
   >To:
   >From: "Mark Johnson"
   >Sent by: [EMAIL PROTECTED]
   >Date: 21/10/2005 13:50
   >Subject: [U2] Double Indexes
   >
   >I'm wondering if a UD or UV system behaves similarly to a D3 problem
   >I see.
   >
   >File contains 6,000,000 records. First field is DATE and 2nd field is
   >CUST.
   >Both are INDEXed.
   >
   >SELECT FILE WITH DATE = "10.18"
   >quickly returns 11,000 items
   >CLEARSELECT
   >SELECT FILE WITH CUST = "12345"
   >quickly returns 180,000 items
   >CLEARSELECT
   >SELECT FILE WITH DATE = "10.18" AND CUST = "12345"
   >takes forever as if the indexes aren't there.
   >
   >I don't know if the double test in the SELECT statement ignores the
   >INDEX on
   >either (or the first) or is encumbered by taking the 11,000 quick
   >DATE items
   >and then hashingly goes through them looking for CUST.
   >
   >If I try
   >SELECT FILE WITH DATE = "10.18"
   >then
   >SELECT FILE WITH CUST = "12345"
   >it still takes longer than I would expect.
   >
   >Is a double INDEX a strange animal. Does U2 support indexing virtual
   >fields,
   >ie DATE.CUST? I don't think D3 can.
   >
   >Thanks in advance.
   >Mark Johnson
   >---
   >u2-users mailing list
   >u2-users@listserver.u2ug.org
   >To unsubscribe please visit http://listserver.u2ug.org/
   >

   **
   This  email message and any files transmitted with it are confidential
   and intended solely for the use of addressed recipient(s). If you have
   received  this  email  in  error please notify the Spotless IS Support
   Centre  (+61 3 9269 7555) immediately, who will advise further action.
   This  footnote  also confirms that this email message has been scanned
   for  the presence of computer related viruses.
   **
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV][OT]Embed command in CSV file?

2005-10-20 Thread Stuart . Boydell 
   >From  universe, I am creating a sequential file which is formatted as
   a CSV
   [snip]
   >...does anyone know if it is possible to embed some kind of command
   Barry,  no,  it's  not possible in csv, closest is to embed a formula.
   However,  if  your  users  are  on  Office 2003, you might be best off
   creating  your  document as XML where you will have access to complete
   (Excel) control over your document.
   If  they  are on earlier versions of Excel then creating your document
   as HTML will give moderate control over the format of the doc.
   HTH, Stuart

   **
   This  email message and any files transmitted with it are confidential
   and intended solely for the use of addressed recipient(s). If you have
   received  this  email  in  error please notify the Spotless IS Support
   Centre  (+61 3 9269 7555) immediately, who will advise further action.
   This  footnote  also confirms that this email message has been scanned
   for  the presence of computer related viruses.
   **
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Double Indexes

2005-10-20 Thread Stevenson, Charles 
On UV I believe there were some optimizations at rel 10.0 and it will
use both indexes and take the intersection.

Use EXPLAIN keyword to see what's going on.

Before then, and maybe still on UD(??) it is as you described.
A good workaround is:

   SELECT FILE WITH DATE = "10.18" TO 1
   SELECT FILE WITH CUST = "12345" TO 2
   MERGE.LIST 1 INTERSECT 2
 
> Does U2 support indexing 
> virtual fields, ie DATE.CUST? I don't think D3 can.

Absolutely!  Virtual fields & correlatives, too.

The only caveat is do NOT index on any calculation where the answer
depends on anything other than the exact record being updated.  The
archtypical bad example would be TRANS() & T-correlatives.  The system
allows it,  but you are asking for corruption.

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

Re: [U2] Double Indexes

2005-10-20 Thread Bruce Nichol 

Goo'day Mark,

At 23:50 20/10/05 -0400, you wrote:


I'm wondering if a UD or UV system behaves similarly to a D3 problem I see.

File contains 6,000,000 records. First field is DATE and 2nd field is CUST.
Both are INDEXed.

SELECT FILE WITH DATE = "10.18"
quickly returns 11,000 items
CLEARSELECT
SELECT FILE WITH CUST = "12345"
quickly returns 180,000 items
CLEARSELECT
SELECT FILE WITH DATE = "10.18" AND CUST = "12345"
takes forever as if the indexes aren't there.


AFAIK, all MV variants only use the first iindex.
If you try to use 2 indices, none are used. Must be documented. 
somewhere


The old story applies:   Use successive SELECTs to get the benefit of 
multiple indices



I don't know if the double test in the SELECT statement ignores the INDEX on
either (or the first) or is encumbered by taking the 11,000 quick DATE items
and then hashingly goes through them looking for CUST.

If I try
SELECT FILE WITH DATE = "10.18"
then
SELECT FILE WITH CUST = "12345"
it still takes longer than I would expect.

Is a double INDEX a strange animal. Does U2 support indexing virtual fields,
ie DATE.CUST? I don't think D3 can.


Why not?   The index is built on a DICT item. Wasn't there a discussion 
somewhere in the past week over indexing null items and the suggestion was 
to non-null them by adding something else to the key?




Thanks in advance.
Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.1.360 / Virus Database: 267.12.4/145 - Release Date: 20/10/05


Regards,

Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia

http://www.taloncs.com.au

Tel: +61 (0)411149636
Fax: +61 (0)260232119

If it ain't broke, fix it till it is! 



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.360 / Virus Database: 267.12.4/145 - Release Date: 20/10/05
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Translate question

2005-10-20 Thread Mark Johnson 
Oddly enough I learned this back in the day on microdatas (I used to work
for MCD in the late 1970's) and have been using it ever since.

I find it much easier to program than the OPEN/READ for the simple purposes.
I'm obviously effeciency oriented and wouldn't OCONV more than 1 field. My
brain detects the need for the second field and I program OPENs and READs.

I spent 2 days with my MCD clients last week and it's getting painfully
obvious how slow it is. The absense of indexing is perhaps the greatest
loss. I have to be far more concerned for effeciency.

On D3 and U2 systems, one doesn't have to be perfectly effecient. Before
everyone gets on their soapbox and flames me for not being perfect,
understand that people like me have lived on both sides, native and
contemporary.

The native systems never had the speed and were about 30% less on other
advanced features. I can honestly say that upgrading to a faster box brings
with it more application opportunites that may have been declined on the
prior system. There are things you can do on a current system that would be
a burden on an older system. But effecient methods brough forth from a
system with less resources to a current system wins both times.

I've not felt the delay during these past 25 years of using OCONV for single
readv's, old or new systems. That's just my experience.

Thanks


- Original Message -
From: "Susan Lynch" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, October 18, 2005 12:53 PM
Subject: Re: [U2] Translate question


> Glenn,
>
> Sorry, I missed that thread, but thank you for the information!
>
> Mark does not work solely on UV systems - he has a lot of older Microdata
> sites, so the warning may still help him!
>
> Susan Lynch
> F.W. Davison
> - Original Message -
> From: "Glenn Herbert" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; 
> Sent: Tuesday, October 18, 2005 11:47 AM
> Subject: RE: [U2] Translate question
>
>
> >I believe this issue was addressed in a previous thread just last
week
> >-  trans  operations,  whether with TRANS, XLATE, or Tfile
conversion,
> >utilize  both  a  file  and  record  cache  to  help  alleviate
these
> >concerns.If  you  issue  multiple statements against the same
file
> >and/or  record,  the  open/read  hit  is  only taken against the
first
> >statement.   This  does  NOT  alleviate  the  speed  of  field
lookup
> >traversal, only file/record open/reads
> >
> >In summary, the universe implementation is fairly efficient.
> >
> >Hope this helps.
> >
> >
__
> >
> >From: [EMAIL PROTECTED]
> >[mailto:[EMAIL PROTECTED] On Behalf Of "Susan
Lynch"
> ><[EMAIL PROTECTED]>
> >Sent: Tuesday, October 18, 2005 11:28 AM
> >To: 
> >Subject: Re: [U2] Translate question
> >
> >Has the internal implementation of this changed, or is this still as
> >horrifically  inefficient as it was back in the Microdata days?
Except
> >in a
> >condition  where  you  were  doing  a  READV  from a file that was
not
> >otherwise
> >read  in  a Basic program, this was always strongly discouraged - as
I
> >found
> >out  when  I asked Jon Sisk about it at a convention, and he
literally
> >fell on
> >the  floor  laughing  that  someone was actually using this syntax.
At
> >that
> >time, Chandru Murthi got up and helped him answer (both were
laughing)
> >-
> >this  syntax actually did a file open and then a READV, so that if
you
> >use it
> >for  more  than one field in a record, or for multiple reads on a
file
> >in a
> >Basic  program,  the  OPEN  being  repeated  was  a killer in terms
of
> >performance
> >(our software vendor did both, constantly!)
> >I am surprised that no other responders raised the efficiency issue!
> >Susan Lynch
> >F.W. Davison
> >- Original Message -
> >From: "Mark Johnson"
> >To:
> >Sent: Monday, October 17, 2005 11:16 PM
> >Subject: [U2] Translate question
> >>  I've always used the OCONV(ID,"TFILE;X;15;15") form for
translates.
> >What
> >is
> >> the difference between the first and second '15's. I've seen
"X;;15"
> >work
> >and
> >> "X;15" not work.
> >>
> >> Thanks in advance.
> >> Mark Johnson
> >> ---
> >> u2-users mailing list
> >> u2-users@listserver.u2ug.org
> >> To unsubscribe please visit http://listserver.u2ug.org/
> >---
> >u2-users mailing list
> >u2-users@listserver.u2ug.org
> >To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe

[U2] Double Indexes

2005-10-20 Thread Mark Johnson 
I'm wondering if a UD or UV system behaves similarly to a D3 problem I see.

File contains 6,000,000 records. First field is DATE and 2nd field is CUST.
Both are INDEXed.

SELECT FILE WITH DATE = "10.18"
quickly returns 11,000 items
CLEARSELECT
SELECT FILE WITH CUST = "12345"
quickly returns 180,000 items
CLEARSELECT
SELECT FILE WITH DATE = "10.18" AND CUST = "12345"
takes forever as if the indexes aren't there.

I don't know if the double test in the SELECT statement ignores the INDEX on
either (or the first) or is encumbered by taking the 11,000 quick DATE items
and then hashingly goes through them looking for CUST.

If I try
SELECT FILE WITH DATE = "10.18"
then
SELECT FILE WITH CUST = "12345"
it still takes longer than I would expect.

Is a double INDEX a strange animal. Does U2 support indexing virtual fields,
ie DATE.CUST? I don't think D3 can.

Thanks in advance.
Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Translate question

2005-10-20 Thread Mark Johnson 
Is there an "OPEN ONCE" when translates are used in dict items for a MVquery
report as opposed to the implied "OPEN EVERYTIME" when used as a OCONV in
databasic.

I use OCONV(ID,TFILE) pretty often to get single fields and can settle for
the X variant if just displaying a CUST name or simple things like that.

Thanks
- Original Message -
From: "Susan Lynch" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, October 18, 2005 11:27 AM
Subject: Re: [U2] Translate question


> Has the internal implementation of this changed, or is this still as
> horrifically inefficient as it was back in the Microdata days?  Except in
a
> condition where you were doing a READV from a file that was not otherwise
> read in a Basic program, this was always strongly discouraged - as I found
> out when I asked Jon Sisk about it at a convention, and he literally fell
on
> the floor laughing that someone was actually using this syntax.  At that
> time, Chandru Murthi got up and helped him answer (both were laughing) -
> this syntax actually did a file open and then a READV, so that if you use
it
> for more than one field in  a record, or for multiple reads on a file in a
> Basic program, the OPEN being repeated was a killer in terms of
performance
> (our software vendor did both, constantly!)
>
> I am surprised that no other responders raised the efficiency issue!
>
> Susan Lynch
> F.W. Davison
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, October 17, 2005 11:16 PM
> Subject: [U2] Translate question
>
>
> > I've always used the OCONV(ID,"TFILE;X;15;15") form for translates. What
> is
> > the difference between the first and second '15's. I've seen "X;;15"
work
> and
> > "X;15" not work.
> >
> > Thanks in advance.
> > Mark Johnson
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Translate question

2005-10-20 Thread Mark Johnson 
Not for nothin' but could you give me some examples. I don't get the ICONV
part of this.
Thanks.
- Original Message -
From: "Barry Rogen" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, October 18, 2005 9:46 AM
Subject: RE: [U2] Translate question


> OCONV(ID,"TFILE;X;15;15")
>
> or
>
> OCONV(ID,"TFILE;Xvloc;iloc;oloc)
>
>
> vloc   Number  of  the  value  to  be  returned  from   a
>multivalued  field. If you do not specify vloc and
>the field  is  multivalued,  the  whole  field  is
>returned  with  all  system delimiters turned into
>blanks. If the vloc specification follows the oloc
>or  bloc  specification,  enclose  vloc  in square
>brackets or separate vloc from oloc or bloc with a
>comma.
>
> iloc   Field number (decimal) for input  conversion.  The
>input  value  is used as a record ID in the lookup
>file, and the translated value is  retrieved  from
>the  field  specified  by the iloc. If the iloc is
>omitted, no input translation takes place.
>
> oloc   Field number  (decimal)  for  output  translation.
>When  RetrieVe  creates  a  listing, data from the
>field specified by oloc in  the  lookup  file  are
>listed instead of the original value.
>
>Cheers,
>
> Barry  Rogen
> PNY Technologies, Inc.
> Senior  Programmer/Analyst
> (973)  515 - 9700  ext 5327
> [EMAIL PROTECTED]
>
> -
> Far better it is to dare mighty things, to win
> glorious triumphs even though checkered by
> failure, than to rank with those poor spirits who
> neither enjoy nor suffer much because they live
> in the gray twilight that knows neither victory
> nor defeat
> 
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Tuesday, October 18, 2005 8:51 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Translate question
>
> I don't get it. If I'm retrieving the 15th attribute from FILE, ID, what
> is
> being ICONV'd? Is there a WRITE possibility?
> Thanks.
>
> - Original Message -
> From: "Bruce Nichol" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, October 18, 2005 12:15 AM
> Subject: Re: [U2] Translate question
>
>
> > Goo'day, Mark,At 23:16 17/10/05 -0400, you wrote:
> >
> > >I've always used the OCONV(ID,"TFILE;X;15;15") form for translates.
> What
> is
> > >the difference between the first and second '15's. I've seen "X;;15"
> work
> and
> > >"X;15" not work.
> >
> > The difference is in "ICONV" vs "OCONV" 
> >
> > The first "15" is for ICONV's and the second "15" is for OCONV's
> >
> > AFAIK, "standard" over all implementations...
> >
> > HTH
> >
> > >Thanks in advance.
> > >Mark Johnson
> > >---
> > >u2-users mailing list
> > >u2-users@listserver.u2ug.org
> > >To unsubscribe please visit http://listserver.u2ug.org/
> > >
> > >
> > >--
> > >No virus found in this incoming message.
> > >Checked by AVG Anti-Virus.
> > >Version: 7.0.344 / Virus Database: 267.12.2/138 - Release Date:
> 17/10/05
> > >
> > >
> > >
> > >
> > >--
> > >No virus found in this incoming message.
> > >Checked by AVG Anti-Virus.
> > >Version: 7.0.344 / Virus Database: 267.12.2/138 - Release Date:
> 17/10/05
> >
> > Regards,
> >
> > Bruce Nichol
> > Talon Computer Services
> > ALBURYNSW 2640
> > Australia
> >
> > http://www.taloncs.com.au
> >
> > Tel: +61 (0)411149636
> > Fax: +61 (0)260232119
> >
> > If it ain't broke, fix it till it is!
> >
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.344 / Virus Database: 267.12.2/138 - Release Date:
> 17/10/05
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Problems with uniobjects and windows 2003 server

2005-10-20 Thread John Jenkins 
Riba

The earliest version of UniVerse for Windows 2003 is 10.0.17 and you need to
be on at least 10.0.21 or 10.1.11

https://www.ibm.com/software/data/u2/support/u2techconnect/buildmatrix.asp

Anything below a Windows 2003 certified and supported version and you are
taking "pot-luck". Your UniVerse provider should be able to arrange an
upgrade for you. 

Regards

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

RE: [U2] Is there a method to suppress printing the Banner page after the fact?

2005-10-20 Thread John Jenkins 
Denny

You would need to write a "driver script", send the report to /dev/null
(device)and use the script to edit the data. You could use "sed" which I
seem to recall is pretty OK with this or alternatively "awk"

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Denny Watkins
Sent: 20 October 2005 15:14
To: u2-users@listserver.u2ug.org
Subject: [U2] Is there a method to suppress printing the Banner page after
the fact?

We are running UniVerse release 9.6.2.5 under IBM AIX 4.3.3 on an IBM F50.

Question:

Is there a way to suppress the printing of the 'banner' page after
a print job has already been submitted and is in the queue but did
not have the parameter NHEAD or NOHEAD set to suppress printing the banner?

Thanks,


Denny Watkins
Director Computer Services
Morningside College
1501 Morningside Ave
Sioux City, Ia 51106-1717

Phone:  1-712-274-5250

Email:   [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/

[U2] Herve Balestrieri/France/IBM est absent du Vendredi 22/10/2005 et sera de retour le Jeudi 03/11/2005. In english : is out of office today Tuesday October 4th. I will be back on Wednesday Octobe

2005-10-20 Thread Herve Balestrieri 
I will be out of the office starting  21/10/2005 and will not return until
03/11/2005.

Pour les clients accidant au Support Technique des produits IBM "U2",
veuillez renvoyer votre message sur : [EMAIL PROTECTED]
Merci

For non-french speaking customers : If your  IBM "U2" products Technical
Support centre is France, please re-send messages to : [EMAIL PROTECTED]
Otherwise, IBM "U2" products Technical Support in UK/EMEA email is :
[EMAIL PROTECTED]

Support Technique IBM - Produits "U2"
IBM Data Management Solutions
Tel.: N0 VERT International   00 800 2535 2535 (France et Belgique)
+44 208 844 3076 (autres pays/other countries)
Fax:  +33 (0) 49 31 45 58
Web: http://www.ibm.com/software/u2/

IBM
Centre de Support Technique IBM Produits "U2"
7630 - 04S03
Immeuble "Marne La Vallie 1"
1, Place Jean-Baptiste Climent
93881 Noisy-le-Grand Cedex
France

e-mail Support Technique IBM "U2" : [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Herve Balestrieri/France/IBM est absent du Vendredi 22/10/2005 et sera de retour le Jeudi 03/11/2005. In english : is out of office fromFriday October 22th. and will be back on Thursday Novembe

2005-10-20 Thread Herve Balestrieri 
I will be out of the office starting  21/10/2005 and will not return until
03/11/2005.

Pour les clients accidant au Support Technique des produits IBM "U2",
veuillez renvoyer votre message sur : [EMAIL PROTECTED]
Merci

For non-french speaking customers : If your  IBM "U2" products Technical
Support centre is France, please re-send messages to : [EMAIL PROTECTED]
Otherwise, IBM "U2" products Technical Support in UK/EMEA email is :
[EMAIL PROTECTED]

Support Technique IBM - Produits "U2"
IBM Data Management Solutions
Tel.: N0 VERT International   00 800 2535 2535 (France et Belgique)
+44 208 844 3076 (autres pays/other countries)
Fax:  +33 (0) 49 31 45 58
Web: http://www.ibm.com/software/u2/

IBM
Centre de Support Technique IBM Produits "U2"
7630 - 04S03
Immeuble "Marne La Vallie 1"
1, Place Jean-Baptiste Climent
93881 Noisy-le-Grand Cedex
France

e-mail Support Technique IBM "U2" : [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Is there a method to suppress printing the Banner page after the fact?

2005-10-20 Thread Ray Wurlod 
If you look at the print-ready file in usr/spool/uv (or wherever it is that 
your UVSPOOL points to), it already has the banner page; this is added by the 
generating process.  So, the only way you could "suppress" the header would be 
to direct the job to another "printer" that uses a special driver to remove the 
banner page.  Such a script should not be difficult to create; you seek to 
remove all lines up to and including the second form-feed character. 

- Original Message -
From: "Denny Watkins" <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org
Subject: [U2] Is there a method to suppress printing the Banner page after  the 
fact?
Date: Thu, 20 Oct 2005 09:14:12 -0500

> 
> We are running UniVerse release 9.6.2.5 under IBM AIX 4.3.3 on an IBM F50.
> 
> Question:
> 
> Is there a way to suppress the printing of the 'banner' page after
> a print job has already been submitted and is in the queue but did
> not have the parameter NHEAD or NOHEAD set to suppress printing the banner?
> 
> Thanks,
> 
> 
> Denny Watkins
> Director Computer Services
> Morningside College
> 1501 Morningside Ave
> Sioux City, Ia 51106-1717
> 
> Phone:  1-712-274-5250
> 
> Email:   [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] pdf2html

2005-10-20 Thread Ron White 

Thanks Tony.  I think I found one from your list
that will fill my need.

Ron

Tony Gravagno wrote:


Ron White wrote:
 


Does anyone know of a good utility for converting
pdf documents to html?  I have tried some that I
found in the CDP archive but the conversion was
not true to the original pdf.
I need a converter that I can run from a basic program.
   



No experience with these but...:
http://www.adobe.com/products/acrobat/access_onlinetools.html
http://pdftohtml.sourceforge.net/
http://www.pdfpdf.com/pdfconverter.html
http://guiguy.wminds.com/downloads/pdf2htmlgui/
http://convert-in.com/pdf2html.htm
http://www.intrapdf.com/
Definitive PDF resources:
http://www.pdfzone.com/
http://www.planetpdf.com/

Some of these tools have a command-line interface then you can use them
from BASIC.  For those that don't you might be able to run them in the
background, move a PDF to a path that will auto-convert, wait for the HTML
to be generated, then just read that with BASIC.  Lots of ways to skin
these cats.

Assistance available if required.
Tony
TG@ removethisNebula-RnD.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

RE: [U2] [UV] Problems with uniobjects and windows 2003 server

2005-10-20 Thread David Jordan 
Hi Cesar

Is it possible for you to upgrade to a new version of UniVerse.  If I
remember right, there is a newer version of UniObjects implemented about
that time and I have not used the older version on Windows 2003.

Regards

David Jordan
Managing Consultant
 
[EMAIL PROTECTED]
Mobile: 0428 669 730
 
DACONO Holdings Pty Ltd
www.dacono.com.au
 
PO Box 909
Lane Cove
NSW 2066
Australia
 
Phn: 61 2 9418 8320
Fax: 61 2 9427 2371
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Cisar Riba Cervera
Sent: Wednesday, 19 October 2005 11:37 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Problems with uniobjects and windows 2003 server

Thanks you for you help, we have, tried this and unfortunately it doesn't
work, do you have my other suggestions.



> -Mensaje original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] nombre de David Jordan
> Enviado el: martes, 18 de octubre de 2005 22:53
> Para: u2-users@listserver.u2ug.org
> Asunto: RE: [U2] [UV] Problems with uniobjects and windows 2003 server
>
>
> This may be related to a problem with the U2 Services.  This issue with
> services has be identified before.  One possible action is to
> click ON allow
> interaction with the Desktop under the logon tab in the properties in the
> services management console particularly for the unirpc service.
>
> Regards
>
> David Jordan
> Managing Consultant
>
> [EMAIL PROTECTED]
> Mobile: 0428 669 730
>
> DACONO Holdings Pty Ltd
> www.dacono.com.au
>
> PO Box 909
> Lane Cove
> NSW 2066
> Australia
>
> Phn: 61 2 9418 8320
> Fax: 61 2 9427 2371
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Cisar
> Riba Cervera
> Sent: Wednesday, 19 October 2005 2:17 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] [UV] Problems with uniobjects and windows 2003 server
>
> Hello
>
>   We worked with windows NT and it runned well all, and now we have
> changed
> the server to windows 2003 and we have a problem that appear everyday, we
> receive an error of Uniobjects (30114) and in windows 2003
> generate the next
> error:
>
>  (UniVerse error: Unhandled Exception raised at address 0x00404CC3; Access
> violation. Attempted to read from address 0x00B4A000. Binary data is
> processor CONTEXT structure..)
>
>
>   Can help me somebody, this problem force to reinitiate the server
> every
> day.
>
> Best regards
>
> Cesar Riba
> Spain
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.12.2/140 - Release Date: 18/10/2005
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.12.2/140 - Release Date: 18/10/2005
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.12.4/142 - Release Date: 18/10/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] pdf2html

2005-10-20 Thread Tony Gravagno 
Ron White wrote:
> Does anyone know of a good utility for converting
> pdf documents to html?  I have tried some that I
> found in the CDP archive but the conversion was
> not true to the original pdf.
> I need a converter that I can run from a basic program.

No experience with these but...:
http://www.adobe.com/products/acrobat/access_onlinetools.html
http://pdftohtml.sourceforge.net/
http://www.pdfpdf.com/pdfconverter.html
http://guiguy.wminds.com/downloads/pdf2htmlgui/
http://convert-in.com/pdf2html.htm
http://www.intrapdf.com/
Definitive PDF resources:
http://www.pdfzone.com/
http://www.planetpdf.com/

Some of these tools have a command-line interface then you can use them
from BASIC.  For those that don't you might be able to run them in the
background, move a PDF to a path that will auto-convert, wait for the HTML
to be generated, then just read that with BASIC.  Lots of ways to skin
these cats.

Assistance available if required.
Tony
TG@ removethisNebula-RnD.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] pdf2html

2005-10-20 Thread Gordon J Glorfield 
My question would be, why?  You can do pretty much anything you need to do 
in a PDF that you can in an HTML document.  You can do links and you can 
display them in a browser, provided you've loaded Adobe Acrobat Reader.

But if you need to convert from PDF to HTML you will never get a "true" 
copy as HTML is too dynamic as far as document dimensions.  HTML will make 
the document fit the size of the window.  PDF retains the proportions of 
the document.  At best a document converted from PDF to HTML will only be 
an approximation of the original.


Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839

[EMAIL PROTECTED] wrote on 10/20/2005 03:18:44 PM:

> Does anyone know of a good utility for converting
> pdf documents to html?  I have tried some that I
> found in the CDP archive but the conversion was
> not true to the original pdf.

> I need a converter that I can run from a basic program.

> Thanks
> Ron White
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/


This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] pdf2html

2005-10-20 Thread Ron 

Does anyone know of a good utility for converting
pdf documents to html?  I have tried some that I
found in the CDP archive but the conversion was
not true to the original pdf.

I need a converter that I can run from a basic program.

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

RE: [U2] [UV][OT]Embed command in CSV file?

2005-10-20 Thread Louie Gouws 
Hi Barry,

Why don't you do a macro in excel that will do the Format/row/autofit and
let your users have it?

Louie

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik
Sent: 20 October 2005 20:05
To: U2-users (E-mail)
Subject: [U2] [UV][OT]Embed command in CSV file?

A little off-topic...

>From universe, I am creating a sequential file which is formatted as a CSV
file, in other words each field is quoted and separated from each other by
commas, for example:
 
  "John","Jacob","Dingleheimer Schmidt"
 
The intent is that the resulting file is opened with Excel.

You can force any cell into multiple lines by embedding a CHAR(10), for
example:
 
  WRITESEQ \"John","Jacob","Dingleheimer\:CHAR(10):\Schmidt"\ TO MY.CSV.FILE
THEN NULL
 
...when viewed in Excel will give you...
 
JohnJacobDingleheimer
 Schmidt
 
...which is a great way of expressing multi-values.

Finally I arrive at the crux. When you open such a document in Excel, it
only displays one line per row even if a cell in that row contains multiple
lines. To see all lines you have to select all and hit FORMAT | ROW |
AUTOFIT. My users seem to be incapable of dealing with that, so...
 
...does anyone know if it is possible to embed some kind of command in a CSV
file that will get Excel to autofit those rows automatically?

Barry Brevik
---
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] [UV][OT]Embed command in CSV file?

2005-10-20 Thread Barry Brevik 
A little off-topic...

>From universe, I am creating a sequential file which is formatted as a CSV
file, in other words each field is quoted and separated from each other by
commas, for example:
 
  "John","Jacob","Dingleheimer Schmidt"
 
The intent is that the resulting file is opened with Excel.

You can force any cell into multiple lines by embedding a CHAR(10), for
example:
 
  WRITESEQ \"John","Jacob","Dingleheimer\:CHAR(10):\Schmidt"\ TO MY.CSV.FILE
THEN NULL
 
...when viewed in Excel will give you...
 
JohnJacobDingleheimer
 Schmidt
 
...which is a great way of expressing multi-values.

Finally I arrive at the crux. When you open such a document in Excel, it
only displays one line per row even if a cell in that row contains multiple
lines. To see all lines you have to select all and hit FORMAT | ROW |
AUTOFIT. My users seem to be incapable of dealing with that, so...
 
...does anyone know if it is possible to embed some kind of command in a CSV
file that will get Excel to autofit those rows automatically?

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

Re: [U2] NETWORKING

2005-10-20 Thread Will 
   The /sbin/rc2.d seems to be in binary?
   Haas, John wrote:

This is from the startup script in /sbin/rc2.d.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
.org] On Behalf Of Will
Sent: Thursday, October 20, 2005 12:08 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] NETWORKING

   John,
   Thanks.
   How did you get the printout you sent?
   Will
   Haas, John wrote:

We are using lantronix on HP-UX. The setup is below.  The port numbers (300x) c
 orrespond to the number of ports on the lanronix. We are using 8 port boxes.
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz5 -x dcterm -p 3001 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz4 -x dcterm -p 3002 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz3 -x dcterm -p 3003 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz2 -x dcterm -p 3004 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz1 -x dcterm -p 3005 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz0 -x dcterm -p 3006 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyf -x dcterm -p 3007 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyye -x dcterm -p 3008 -k
##
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyd -x orlterm -p 3001 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyc -x orlterm -p 3002 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyb -x orlterm -p 3003 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyya -x orlterm -p 3004 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy9 -x orlterm -p 3005 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy8 -x orlterm -p 3006 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy7 -x orlterm -p 3007 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy6 -x orlterm -p 3008 -k

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
.org] On Behalf Of Will
Sent: Tuesday, October 18, 2005 8:39 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] NETWORKING

   Our  Lantronics  server  lost configuration for the off site terminals
   and  printers.  Lantronics  help  desk  says  we  must  tell  them the
   listening  port  numbers  on the HP9000 running HP-UX Universe. Anyone
   know how to determine those ports? Kind Regards, Will

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


This email is intended only for the use of the party to which it is addressed a
nd may contain information that is privileged, confidential, or protected by la
w.  If you are not the intended recipient you are hereby notified that any diss
emination, copying or distribution of this email or its contents is strictly pr
ohibited. If you have received this message in error, please notify us immediat
ely by replying to the message and deleting it from your computer.

Internet communications are not assured to be secure or clear of inaccuracies a
s information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. Therefore, we do not accept responsibility for
any errors or omissions that are present in this email, or any attachment, that
 have arisen as a result of e-mail transmission. --
-
-
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


This email is intended only for the use of the party to which it is
addressed and may contain information that is privileged,
confidential, or protected by law.  If you are not the intended
recipient you are hereby notified that any dissemination, copying
or distribution of this email or its contents is strictly prohibited.
If you have received this message in error, please notify us immediately
by replying to the message and deleting it from your computer.

Internet communications are not assured to be secure or clear of
inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. Therefore,
we do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result
of e-mail transmission. ---
-
---
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] NETWORKING

2005-10-20 Thread Haas, John 
This is from the startup script in /sbin/rc2.d.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Will
Sent: Thursday, October 20, 2005 12:08 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] NETWORKING


   John,
   Thanks.
   How did you get the printout you sent?
   Will
   Haas, John wrote:

We are using lantronix on HP-UX. The setup is below.  The port numbers (300x) c 
orrespond to the number of ports on the lanronix. We are using 8 port boxes.
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz5 -x dcterm -p 3001 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz4 -x dcterm -p 3002 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz3 -x dcterm -p 3003 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz2 -x dcterm -p 3004 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz1 -x dcterm -p 3005 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz0 -x dcterm -p 3006 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyf -x dcterm -p 3007 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyye -x dcterm -p 3008 -k
##
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyd -x orlterm -p 3001 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyc -x orlterm -p 3002 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyb -x orlterm -p 3003 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyya -x orlterm -p 3004 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy9 -x orlterm -p 3005 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy8 -x orlterm -p 3006 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy7 -x orlterm -p 3007 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy6 -x orlterm -p 3008 -k

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
.org] On Behalf Of Will
Sent: Tuesday, October 18, 2005 8:39 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] NETWORKING

   Our  Lantronics  server  lost configuration for the off site terminals
   and  printers.  Lantronics  help  desk  says  we  must  tell  them the
   listening  port  numbers  on the HP9000 running HP-UX Universe. Anyone
   know how to determine those ports? Kind Regards, Will

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


This email is intended only for the use of the party to which it is addressed 
and may contain information that is privileged, confidential, or protected by 
law.  If you are not the intended recipient you are hereby notified that any 
dissemination, copying or distribution of this email or its contents is 
strictly prohibited. If you have received this message in error, please notify 
us immediately by replying to the message and deleting it from your computer.

Internet communications are not assured to be secure or clear of inaccuracies 
as information could be intercepted, corrupted, lost, destroyed, arrive late or 
incomplete, or contain viruses. Therefore, we do not accept responsibility for 
any errors or omissions that are present in this email, or any attachment, that 
have arisen as a result of e-mail transmission. 
---
-
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


This email is intended only for the use of the party to which it is 
addressed and may contain information that is privileged, 
confidential, or protected by law.  If you are not the intended 
recipient you are hereby notified that any dissemination, copying 
or distribution of this email or its contents is strictly prohibited. 
If you have received this message in error, please notify us immediately 
by replying to the message and deleting it from your computer.

Internet communications are not assured to be secure or clear of 
inaccuracies as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses. Therefore, 
we do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result 
of e-mail transmission. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Is there a method to suppress printing the Banner page after the fact?

2005-10-20 Thread Denny Watkins 
We are running UniVerse release 9.6.2.5 under IBM AIX 4.3.3 on an IBM F50.

Question:

Is there a way to suppress the printing of the 'banner' page after
a print job has already been submitted and is in the queue but did
not have the parameter NHEAD or NOHEAD set to suppress printing the banner?

Thanks,


Denny Watkins
Director Computer Services
Morningside College
1501 Morningside Ave
Sioux City, Ia 51106-1717

Phone:  1-712-274-5250

Email:   [EMAIL PROTECTED]  
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/