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

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 migh

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 FIL

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

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 det

[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,00

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

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(

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 UniVers

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 PR

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

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

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 driv

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

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 7

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:

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

[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@listser

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 c

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

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

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 printo

[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? T