RE: [U2] [UD] How to determine the File Name within a dictionary called Subroutine

2006-01-06 Thread Bill Haskett
Thanks, but I've already tried this.  This is on UD PE v7.1.

Bill
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Burwell, Edward
> Sent: Friday, January 06, 2006 1:57 PM
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] [UD] How to determine the File Name within 
> a dictionary called Subroutine
> 
> try @FILE.NAME
> 
> -Original Message-
> From: Bill Haskett [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 06, 2006 4:04 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] [UD] How to determine the File Name within a 
> dictionary called Subroutine
> 
> 
> As I trudge along with a client conversion I've noticed a 
> difficulty using @FILENAME within a BASIC program...it works 
> fine in UniVerse but fails to compile in UniData ("P" 
> Ecltype).  I'm trying to determine, in a subroutine called 
> from a virtual definition, if the file being processed needs 
> to be opened.  Code looks like:
> 
> CurrFileName = @FILENAME
> IF CurrFileName = "EMPLOYEES" THEN
>ReturnValue = @RECORD<15>
> END ELSE
>ReturnValue = @RECORD<12>
> END
> RETURN
> 
> I can use @FILENAME in a virtual dictionary definition but 
> not in BASIC.
> How do I get the variable of the file being processed in a 
> query, in UniData?
> 
> Since the same code runs on U2 and D3 I'd like to keep this 
> business rule in the subroutine, that can be used by both.
> 
> Thanks, any help would be appreciated.
> 
> Bill Haskett
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
> __
> This e-mail has been scanned by MCI Managed Email Content 
> Service, using
> Skeptic(tm) technology powered by MessageLabs. For more 
> information on MCI's Managed Email Content Service, visit 
> http://www.mci.com.
> __
> 
> __
> This e-mail has been scanned by MCI Managed Email Content 
> Service, using Skeptic(tm) technology powered by MessageLabs. 
> For more information on MCI's Managed Email  Content Service, 
> visit http://www.mci.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/


[U2] re: [u2] DCOUNT

2006-01-06 Thread Stuart Boydell

Haven't seen anyone mention vector functions here. Do many people use them?

In situations where you are performing identical operations on every 
value in a dynamic array, I rekon vector functions are a more efficient 
way of handling multivalues then dcount/loop constructs.


A simple example of adding 1 to every attribute; instead of:

   max = dcount(var<15>,@vm)
   for i = 1 to max
  var<15,i> += 1
   next

you  use:

   var<15> = adds(var<15>,reuse(1))

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


RE: [U2] Calendar

2006-01-06 Thread Tony Gravagno
Have a look at NebulaManager, which isn't actively offered anymore, but
you'll get an idea of what's possible with Outlook and MV:
http://removethisNebula-RnD.com/products/manager.htm
(I munge the domain because this forum is open to spammers.)

There are some free and open source projects out there which allow people
to maintain calendars.  With some investigation into the datastore for
these applications I'm sure someone can work out a U2 interface into them.

I'll be happy to do such research and development on a contracting basis.

HTH
Tony Gravagno
Nebula R&D
TG@ removethisNebula-RnD.com

Bob Kinney wrote:
> Hi everyone,
> We would like to publish a company calendar.  We have an
> intranet running off Unidata thru the DBC cgi script.  
> We are planning to enter events into Unidata records that
> gets presented in either a standardized, formatted html
> page or Outlook's calendar.  We aren't using Exchange and
> don't know if feeding Outlook's calendar is even
> possible.  Any suggestions?  
> 
> We are currently using Cyberscheduler for our workgroup
> application. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] DCOUNT

2006-01-06 Thread Mark Johnson
Thanks for all that responded.

It was not a trick or underhanded question. It was just one of those days
when I had programmed DCOUNT about a zillion times and I was wondering if
there was any shortcut. It's better than the COUNT function that actually
counts something different.

I agree that having FOR I=1 to DCOUNT is not a problem with the small counts
but dare not consider it as my conscience (the U2 Forum) would frown on it.

I've learned a lot from this forum despite my decades of experience as I
have not transversed every possible style of coding. My personal collection
of styles is gleened from that vast experience of inheriting both good and
bad code examples and keeping the best.

Thanks
Mark Johnson
- Original Message -
From: "Bob Woodward" <[EMAIL PROTECTED]>
To: 
Sent: Friday, January 06, 2006 11:42 AM
Subject: RE: [U2] DCOUNT


> Correct me if I'm wrong but does this method not require the DCOUNT
> function to be executed each iteration of "I" to determine if you have
> reached your max value?  Granted, for a small number of values it would
> not be that much of a hit but I'd not like to encourage this on the off
> chance that you use it on a large number of values somewhere else.
>
> BobW
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Serguei
> Sent: Friday, January 06, 2006 6:02 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] DCOUNT
>
> I personally would even write it like this if I am sure the number of
> values
> is no more then ten:
> FOR I=1 TO DCOUNT(REC<15>,@VM)
>
> (and of course I would not use number as a field position)
> ---
> 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] Totaling oddity on UniVerse

2006-01-06 Thread Bruce Nichol

Goo'day,

Looks awfully like the old WIDEZERO problem to me

At 23:43 07/01/06 +1100, you wrote:


   A strange  oddity  I have encountered on UniVerse  (10,0,19).  I have
a file that I build and export
to a third party package we have. In this file, the dollar amount values
have to be store and sent
in OCONV format (that being  123.00  instead of  12300). All the data is
MR2 converted and all
the data is valid.
Before sending, I just like to check that to total dollar amount is
correct.  So   I  do a

 LIST   filename  TOTALF55   DET-SUPP

 Dict filename  F55
D
55

ATTR 55
12R

  The output I get is quite bizarre.  Instead of the expected value
of
134878167.90I get   134878167.890005

   Any thoughts ???

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





NOT 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
To unsubscribe please visit http://listserver.u2ug.org/



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.1.371 / Virus Database: 267.14.15/223 - Release Date: 06/01/06


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.371 / Virus Database: 267.14.15/223 - Release Date: 06/01/06
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Launching DOS executables from Universe 10.0.10 on Win 2000

2006-01-06 Thread Dave Taylor
I'm trying to launch a DOS executable (.bat or .exe file) from TCL or from a
BASIC program in UV PE Ver. 10.0.10 on Win 2000 Server.

The "DOS /c (pathname)" command Issued both at TCL and from a Basic program
runs the DOS command from *within* UV, but I want to run it from outside of
UV.

I understand from a friend that Unidata uses the command PCPERFORM to
accomplish this.

We currently use UEXECUTE in mvBase to accomplish this.

tia for your suggestions,

Dave

Dave Taylor
President
Sysmark Information Systems, Inc.
49 Aspen Way
Rolling Hills Estates, CA 90274
800-SYSMARK (800-797-6275)
(O) 310-544-1974
(P) 800-339-1497
(F) 310-377-3550
Your Source for Integrated EDI Translation and DataSync Integration
www.sysmarkinfo.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Re: U2 Users Digest V1 #991

2006-01-06 Thread Russ DeWitt
I will be out of the country from Sunday 1/8/2006 thru Sunday 1/15/2006. During 
this time I will not have very limited access to email. If you need to contact 
me, please try me on my cell phone. 631 680-0691

Thanks,

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


Re: [U2] Calendar

2006-01-06 Thread Results

Bob,
You could join the mvCMS project, which is developing a U2-to-web 
interface, starting with a calendar application. We will start looking 
at coding for the core API next week. Watch U2-Community for 
discussions, details, and progress.


- Charles Barouch   
[EMAIL PROTECTED]
(718) 762-3884 x 1
	P. O. Box 540957, 
	Linden Hill, NY 11354-0957

www.KeyAlly.com


Bob Kinney wrote:


Hi everyone,
We would like to publish a company calendar.  We have an intranet running off
Unidata thru the DBC cgi script.   We are planning to enter events into
Unidata records that gets presented in either a standardized, formatted html
page or Outlook's calendar.  We aren't using Exchange and don't know if
feeding Outlook's calendar is even possible.  Any suggestions?
We are currently using Cyberscheduler for our workgroup application.

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


Re: [U2] UV - OPENSEQ and unix pipes

2006-01-06 Thread Ray Wurlod
There is (or was) a white paper on using named pipes with UniVerse.  Download 
from IBM web site (start at http://www.ibm.com/software/data/u2 and search for 
it in the library).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Converting number to word

2006-01-06 Thread Ray Wurlod
The Advanced UniVerse Programming class used to use this as an example of 
writing a recursive function.  Each thousand-group can make a recursive call.

There is no inbuild numbers-to-words function in UniVerse.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Converting number to word

2006-01-06 Thread Ray Wurlod
Algortithm refinement: You need to add "ST" or "ND" if the final digit is 1 
unless the penultimate digit is also 1 in which case add "TH".

Oconv(TheNumber, "NR") will do Roman numerals.  I suppose it's a user exit, but 
one for which there's no code supplied.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [uv] Something Strange happened today

2006-01-06 Thread Ray Wurlod
Mike has replied about the "negative versus unsigned" integer.

Looks like one process locked the T30FILE semaphore, which governs access to 
the T30FILE table in the disk shared memory segment, for longer than the 
instant expected.  Maybe that process was killed at EXACTLY the wrong moment 
(while it held that semaphore).

You could have used analyze.shm -d to see what Type 30 files were open, and 
analyze.shm -s to see the semaphores (T30FILE is in the final eight).  The 
administrator has an UNLOCK SEMAPHORE command available to free these eight 
system semaphores in the very unlikely event that it's required.  Such as your 
erxperience!  (I was going to fix that spelling, but I actually like the new 
word!)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread Piers Angliss
Barry,

Search the archives for anything on wide-zero for detailed explanation, but
I'll have a go anyway.

It is all to do with binary representation of floating point numbers. If you
convert an integer from decimal to binary the resultant value is always
precise and unambiguous, the binary can always be converted back to decimal
with the correct result. If you try this with a floating point number that
isn't always true, a small percentage of decimal values between 0 and 1 do
not have a precise binary representation, you can get close but you can't
get there exactly.

So, if you perform arithmetic operations on these binary representations you
stand the chance of getting very small inaccuracies, or rounding errors.
Many programming environments (including Unidata) will resolve these for
you - I'm not sure how (help me Ken ?) but possibly by converting fp values
to integers first, then calculating, then converting back

Universe performs the calculation on the fp numbers themselves and uses a
tunable parameter (WIDE-ZERO) to allow you to specify the point at which
very small values can be considered equivalent to zero. The default value is
an industry-standard (IEEE) value of 2.91E-11 which is roughly 1 / 2 pwr 35.

By totalling values in external (OCONV) format in Universe you will
occasionally fall foul of this and find that the total is "out" by a small
amount - although 0.05 is larger than I would expect, may depend on the
number of values you are totalling.

You can "tune" your system by tweaking the value of the wide-zero parameter
(default 0x3dc0) or, as recommended by many gurus on this list, you
should always perform arithmetic on the internal (ICONV) values so if you
modify your F55 definition to ICONV the value with an MD2 conversion then I
think you'll find the total to be as expected ( but 100 times too large)

Hth

Piers

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen

  The output I get is quite bizarre.  Instead of the expected value
of
134878167.90I get   134878167.890005

   Any thoughts ???

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


RE: [U2] Calendar

2006-01-06 Thread Mike Rajkowski
If you must use Outlook

Try working with CSV file.  While I have not imported the calendar, I
have imported into the address book from a CSV created from a U2 file.

 
Michael Rajkowski
Senior Programmer/Analyst
GWiz Systems Inc.
(720) 212 - 0691
 
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Kinney
Sent: Friday, January 06, 2006 3:16 PM
To: U2 Users
Subject: [U2] Calendar

Hi everyone,
We would like to publish a company calendar.  We have an intranet
running off
Unidata thru the DBC cgi script.   We are planning to enter events into
Unidata records that gets presented in either a standardized, formatted
html
page or Outlook's calendar.  We aren't using Exchange and don't know if
feeding Outlook's calendar is even possible.  Any suggestions?

We are currently using Cyberscheduler for our workgroup application.

Thanks,

Bob Kinney
Buffalo Wild Wings
---
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] Calendar

2006-01-06 Thread Bob Kinney
Hi everyone,
We would like to publish a company calendar.  We have an intranet running off
Unidata thru the DBC cgi script.   We are planning to enter events into
Unidata records that gets presented in either a standardized, formatted html
page or Outlook's calendar.  We aren't using Exchange and don't know if
feeding Outlook's calendar is even possible.  Any suggestions?

We are currently using Cyberscheduler for our workgroup application.

Thanks,

Bob Kinney
Buffalo Wild Wings
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] How to determine the File Name within a dictionary called Subroutine

2006-01-06 Thread Burwell, Edward
try @FILE.NAME

-Original Message-
From: Bill Haskett [mailto:[EMAIL PROTECTED]
Sent: Friday, January 06, 2006 4:04 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] How to determine the File Name within a dictionary
called Subroutine


As I trudge along with a client conversion I've noticed a difficulty using
@FILENAME within a BASIC program...it works fine in UniVerse but fails to
compile in UniData ("P" Ecltype).  I'm trying to determine, in a subroutine
called from a virtual definition, if the file being processed needs to be
opened.  Code looks like:

CurrFileName = @FILENAME
IF CurrFileName = "EMPLOYEES" THEN
   ReturnValue = @RECORD<15>
END ELSE
   ReturnValue = @RECORD<12>
END
RETURN

I can use @FILENAME in a virtual dictionary definition but not in BASIC.
How do I get the variable of the file being processed in a query, in
UniData?

Since the same code runs on U2 and D3 I'd like to keep this business rule in
the subroutine, that can be used by both.

Thanks, any help would be appreciated.

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

__
This e-mail has been scanned by MCI Managed Email Content Service, using
Skeptic(tm) technology powered by MessageLabs. For more information on MCI's
Managed Email Content Service, visit http://www.mci.com.
__

__
This e-mail has been scanned by MCI Managed Email Content Service, using 
Skeptic(tm) technology powered by MessageLabs. For more information on MCI's 
Managed Email  Content Service, visit http://www.mci.com.
__
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Create hashed file in subdirectory?

2006-01-06 Thread Jacques G.
I tried a few things to arrive at this syntax for Pick
flavor:

CREATE.FILE DATA TEMP.JAG,TRAVAIL.KK 503,1,16

(Modulo,Separation,Type)

The problem I had was when I do: HELP CREATE.FILE at
the TCL level I only get examples for a different
flavor.  Those examples had spaces instead of commas.
I have the PDF files, but tend to use the HELP command
instead. 

Still, it shouldn't have created files with a modulo
of 18.  

--- Brian Leach <[EMAIL PROTECTED]> wrote:

> Jacques,
> 
> Does it work correctly if you specify commas between
> e.g.
> 
> CREATE.FILE TEMP.JAG,WORK.JJ 16,17,1 18,101,1 ?
> 
> It could be flavor dependent.
> 
> Brian 




__ 
Yahoo! DSL  Something to write home about. 
Just $16.99/mo. or less. 
dsl.yahoo.com 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread Dave Taylor
Barry,

Try listing it without the DET-SUPP and see what's actually making up that
total.

Dave Taylor
President
Sysmark Information Systems, Inc.
49 Aspen Way
Rolling Hills Estates, CA 90274
800-SYSMARK (800-797-6275)
(O) 310-544-1974
(P) 800-339-1497
(F) 310-377-3550
Your Source for Integrated EDI Translation and DataSync Integration
www.sysmarkinfo.com

- Original Message - 
From: "Barry Rogen" <[EMAIL PROTECTED]>
To: 
Sent: Friday, January 06, 2006 12:03 PM
Subject: [U2] [UV] Totaling oddity on UniVerse


>A strange  oddity  I have encountered on UniVerse  (10,0,19).  I have
> a file that I build and export
> to a third party package we have. In this file, the dollar amount values
> have to be store and sent
> in OCONV format (that being  123.00  instead of  12300). All the data is
> MR2 converted and all
> the data is valid.
> Before sending, I just like to check that to total dollar amount is
> correct.  So   I  do a
>
>  LIST   filename  TOTALF55   DET-SUPP
>
>  Dict filename  F55
> D
> 55
>
> ATTR 55
> 12R
>
>   The output I get is quite bizarre.  Instead of the expected value
> of
> 134878167.90I get   134878167.890005
>
>Any thoughts ???
>
> 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
> 
>
>
>
>
> NOT 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
> 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] Totaling oddity on UniVerse

2006-01-06 Thread Barry Rogen
sorry,   should have specified -   HPUX  box  but thanks
for the feedback

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
[EMAIL PROTECTED]
Sent: Friday, January 06, 2006 3:33 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Totaling oddity on UniVerse


>A strange  oddity  I have encountered on UniVerse  (10,0,19).  I
have
> a file that I build and export
> to a third party package we have. In this file, the dollar amount
values
> have to be store and sent
> in OCONV format (that being  123.00  instead of  12300). All the data
is
> MR2 converted and all
> the data is valid.
> Before sending, I just like to check that to total dollar amount
is
> correct.  So   I  do a
>
>  LIST   filename  TOTALF55   DET-SUPP
>
>  Dict filename  F55
> D
> 55
>
> ATTR 55
> 12R
>
>   The output I get is quite bizarre.  Instead of the expected
value
> of
> 134878167.90I get   134878167.890005

Sounds like an IBM RS/6000 anomaly I found when writing a uniVerse
calculator. I had it working on a PICK 7800 system (this was years ago)
and when I ported it to an IBM RS/6000, I had to re-write it and build
in
some pretty annoying compensatory tools so the math co-processor (if
that's what it's called) couldn't mess my answers so badly that trust
was
lost. I don't remember what I did, but it was pretty lame to have to do
it.

So, if you are on an IBM system, you may have found the bug I found
years
ago.

Karl

>
>Any thoughts ???
>
> 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
> 
>
>
>
>
> NOT 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
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
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] Totaling oddity on UniVerse

2006-01-06 Thread Eric Armstrong
It looks like its rounding to six decimal places instead of two.

Eric Armstrong
Programmer/Analyst
Lobel Financial
714.816.1207


-Original Message-
From: Barry Rogen [mailto:[EMAIL PROTECTED]
Sent: Friday, January 06, 2006 12:04 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Totaling oddity on UniVerse


   A strange  oddity  I have encountered on UniVerse  (10,0,19).  I have
a file that I build and export
to a third party package we have. In this file, the dollar amount values
have to be store and sent
in OCONV format (that being  123.00  instead of  12300). All the data is
MR2 converted and all
the data is valid.
Before sending, I just like to check that to total dollar amount is
correct.  So   I  do a

 LIST   filename  TOTALF55   DET-SUPP

 Dict filename  F55
D
55

ATTR 55
12R

  The output I get is quite bizarre.  Instead of the expected value
of
134878167.90I get   134878167.890005

   Any thoughts ???

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





NOT 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
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] [UD] How to determine the File Name within a dictionary called Subroutine

2006-01-06 Thread Bill Haskett
As I trudge along with a client conversion I've noticed a difficulty using
@FILENAME within a BASIC program...it works fine in UniVerse but fails to
compile in UniData ("P" Ecltype).  I'm trying to determine, in a subroutine
called from a virtual definition, if the file being processed needs to be
opened.  Code looks like:

CurrFileName = @FILENAME
IF CurrFileName = "EMPLOYEES" THEN
   ReturnValue = @RECORD<15>
END ELSE
   ReturnValue = @RECORD<12>
END
RETURN

I can use @FILENAME in a virtual dictionary definition but not in BASIC.
How do I get the variable of the file being processed in a query, in
UniData?

Since the same code runs on U2 and D3 I'd like to keep this business rule in
the subroutine, that can be used by both.

Thanks, any help would be appreciated.

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


Re: [U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread karlp

>A strange  oddity  I have encountered on UniVerse  (10,0,19).  I have
> a file that I build and export
> to a third party package we have. In this file, the dollar amount values
> have to be store and sent
> in OCONV format (that being  123.00  instead of  12300). All the data is
> MR2 converted and all
> the data is valid.
> Before sending, I just like to check that to total dollar amount is
> correct.  So   I  do a
>
>  LIST   filename  TOTALF55   DET-SUPP
>
>  Dict filename  F55
> D
> 55
>
> ATTR 55
> 12R
>
>   The output I get is quite bizarre.  Instead of the expected value
> of
> 134878167.90I get   134878167.890005

Sounds like an IBM RS/6000 anomaly I found when writing a uniVerse
calculator. I had it working on a PICK 7800 system (this was years ago)
and when I ported it to an IBM RS/6000, I had to re-write it and build in
some pretty annoying compensatory tools so the math co-processor (if
that's what it's called) couldn't mess my answers so badly that trust was
lost. I don't remember what I did, but it was pretty lame to have to do
it.

So, if you are on an IBM system, you may have found the bug I found years
ago.

Karl

>
>Any thoughts ???
>
> 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
> 
>
>
>
>
> NOT 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
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Create hashed file in subdirectory?

2006-01-06 Thread Brian Leach
Jacques,

Does it work correctly if you specify commas between e.g.

CREATE.FILE TEMP.JAG,WORK.JJ 16,17,1 18,101,1 ?

It could be flavor dependent.

Brian 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G.
> Sent: 06 January 2006 19:53
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UV] Create hashed file in subdirectory?
> 
> I've used Multi-files like this on Unidata, I tried the 
> following in Universe 10.1.8:
> 
> Notice that in the second part that I add, I specify
> 18 503 and 1 as parameters. For some reason, CREATE-FILE uses 
> the 18 as both the file type and modulo.  The LISTFILES 
> command confirms that the second part was created with a modulo of 18.
>  
> >CREATE.FILE TEMP.JAG,WORK.JJ 16 17 1 18 101 1
> Creating a multilevel data file.  
>  
> Creating file "TEMP.JAG/WORK.JJ" as Type 18, Modulo 17, Separation 1.
> Creating file "D_TEMP.JAG" as Type 18, Modulo 16,
> Separation 1. 
> 
> 
> >CREATE.FILE DATA TEMP.JAG,WORK.KK 18 503 1   
>
> Creating file "TEMP.JAG/WORK.KK" as Type 18, Modulo 18, Separation 1. 
> FILES in your vocabulary 
> 08:45:12pm  06 Jan 2006 Page  1  
>   
> 
> Filename...
> Pathname.. Type Modulo 
>   
> 
>  F 503 1  
> 
> DICT TEMP.JAG   D_TEMP.JAG
>   18 16 
> DATA TEMP.JAG,WORK.JJTEMP.JAG/WORK.JJ 
> 18 17 
> DATA TEMP.JAG,WORK.KKTEMP.JAG/WORK.KK 
> 18 18 
> 
> >ED MD RELLEVEL   
> 5 lines long. 
>   
> : P   
> 0001: X   
> 0002: 10.1.8  
> 0003: PICK
> 0004: PICK.FORMAT 
> 0005: 10.1.8  
> 
> 
>   
> __
> Yahoo! DSL  Something to write home about. 
> Just $16.99/mo. or less. 
> dsl.yahoo.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/


[U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread Barry Rogen
   A strange  oddity  I have encountered on UniVerse  (10,0,19).  I have
a file that I build and export
to a third party package we have. In this file, the dollar amount values
have to be store and sent
in OCONV format (that being  123.00  instead of  12300). All the data is
MR2 converted and all
the data is valid.
Before sending, I just like to check that to total dollar amount is
correct.  So   I  do a

 LIST   filename  TOTALF55   DET-SUPP

 Dict filename  F55
D
55

ATTR 55
12R

  The output I get is quite bizarre.  Instead of the expected value
of
134878167.90I get   134878167.890005

   Any thoughts ???

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





NOT 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
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Create hashed file in subdirectory?

2006-01-06 Thread Jacques G.
I've used Multi-files like this on Unidata, I tried
the following in Universe 10.1.8:

Notice that in the second part that I add, I specify
18 503 and 1 as parameters. For some reason,
CREATE-FILE uses the 18 as both the file type and
modulo.  The LISTFILES command confirms that the
second part was created with a modulo of 18.
 
>CREATE.FILE TEMP.JAG,WORK.JJ 16 17 1 18 101 1
Creating a multilevel data file.  
 
Creating file "TEMP.JAG/WORK.JJ" as Type 18, Modulo
17, Separation 1.
Creating file "D_TEMP.JAG" as Type 18, Modulo 16,
Separation 1. 


>CREATE.FILE DATA TEMP.JAG,WORK.KK 18 503 1   
   
Creating file "TEMP.JAG/WORK.KK" as Type 18, Modulo
18, Separation 1. 
FILES in your vocabulary 
08:45:12pm  06 Jan 2006 Page  1  
  

Filename...
Pathname.. Type Modulo 
  

 F 503 1  

DICT TEMP.JAG   D_TEMP.JAG
  18 16 
DATA TEMP.JAG,WORK.JJTEMP.JAG/WORK.JJ 
18 17 
DATA TEMP.JAG,WORK.KKTEMP.JAG/WORK.KK 
18 18 

>ED MD RELLEVEL   
5 lines long. 
  
: P   
0001: X   
0002: 10.1.8  
0003: PICK
0004: PICK.FORMAT 
0005: 10.1.8  



__ 
Yahoo! DSL  Something to write home about. 
Just $16.99/mo. or less. 
dsl.yahoo.com 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] DCOUNT

2006-01-06 Thread BNeylon
IMHO it is a bad habit to get into. 

Bruce M Neylon
Health Care Management Group 





"Marilyn Hilb" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/06/2006 12:07 PM
Please respond to u2-users

 
To: 
cc: 
Subject:RE: [U2] DCOUNT

Which is why he said "no more than ten". 

 -Original Message-
From:[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]  On Behalf Of Bob Woodward
Sent:Friday, January 06, 2006 10:43 AM
To:  u2-users@listserver.u2ug.org
Subject: RE: [U2] DCOUNT

Correct me if I'm wrong but does this method not require the DCOUNT
function to be executed each iteration of "I" to determine if you have
reached your max value?  Granted, for a small number of values it would
not be that much of a hit but I'd not like to encourage this on the off
chance that you use it on a large number of values somewhere else.

BobW
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Serguei
Sent: Friday, January 06, 2006 6:02 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DCOUNT

I personally would even write it like this if I am sure the number of
values
is no more then ten:
FOR I=1 TO DCOUNT(REC<15>,@VM)

(and of course I would not use number as a field position)
---
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] Backup, dbpause & 24/7 operation

2006-01-06 Thread John Solie
Hi Jeff,

We use the FlashCopy feature of our FAStT disk array.  My script does a
dbpause, then runs a script to activate flashcopy on our FAStT (which takes
a kind of snapshot of the disk, and the array is able to maintain this
snapshot even as the underlying data changes) then dbresume.  The script
then does some stuff behind the scenes to re-mount the filesystems in the
snapshot area and the backup proceeds from the snapshot.  At the end of the
backup, those filesystems are unmounted, and flashcopy "turned off."

Total time for Unidata to be in a dbpause: anywhere between 20 seconds and a
minute (last night's was about 27 seconds)
Total time to tape off the snapshot: close to 5 hours
Value to a 7x24x365 bidness to get a good night's backup: priceless...  :-)


  -- John Solie -- Professional Hospital Supply -- 951-296-2600  

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell
> Sent: Friday, January 06, 2006 2:15 AM
> To: u2 users group
> Subject: [U2] Backup, dbpause & 24/7 operation
> 
> As our company grows we are getting more pressure to extend 
> our operation through the night. We have maintained a nightly 
> backup that does a dbpause to suspend unidata. This irritates 
> our night shift people since they can no longer use the system.
> 
> How do those companies who operate 24/7 get around this and 
> perform backups?
> 
> Thanks,
> 
> SB 5.3.8
> Unidata 6
> AIX 5.3
> ---
> 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] DCOUNT

2006-01-06 Thread Kevin King
I'd like to second BobW in NOT using DCOUNT in a FOR line.  Certainly
when the count is small the overhead is also small, but how many times
are we DCOUNTing with certainty that we know the count is less than a
particular threshold?  Whether the count is zero or higher, I believe
it's always better to assign the count to a variable and then loop to
the variable; then there's no chance for surprises when the program
does encounter an unexpectedly big list.

Furthermore, at the risk of offending delicate sensibilities, I take
this a step farther and recommend specific variable names for FOR
statements.  If the list is in a variable called INVOICES, the loop
would be:

INVOICES.CNT = DCOUNT(INVOICES,@VM)
FOR INVOICES.LOOP = 1 TO INVOICES.CNT
..
NEXT INVOICES.LOOP

(That is, loop variables always end in .LOOP, loop max counts always
end in .CNT, and the prefix is the original variable name.  It has
been my experience that tying the loop max and loop counter to the
original variable name (by convention) improves the clarity and
purpose of the loop.  Your individual results may vary.)

This is assuming, of course, that the FOR/NEXT loop is the proper
construct for the particular task at hand.  If the list is anticipated
to be large or there are other extenuating circumstances due to the
format of the data being looped through, FOR/NEXT may not be the best
choice.

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


RE: [U2] DCOUNT

2006-01-06 Thread gerry-u2ug
Absolutely correct 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: January 6, 2006 11:43
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] DCOUNT

Correct me if I'm wrong but does this method not require the DCOUNT
function to be executed each iteration of "I" to determine if you have
reached your max value?  Granted, for a small number of values it would
not be that much of a hit but I'd not like to encourage this on the off
chance that you use it on a large number of values somewhere else.

BobW
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Serguei
Sent: Friday, January 06, 2006 6:02 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DCOUNT

I personally would even write it like this if I am sure the number of
values is no more then ten:
FOR I=1 TO DCOUNT(REC<15>,@VM)

(and of course I would not use number as a field position)
---
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] DCOUNT

2006-01-06 Thread Marilyn Hilb
Which is why he said "no more than ten". 

 -Original Message-
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]  On Behalf Of Bob Woodward
Sent:   Friday, January 06, 2006 10:43 AM
To: u2-users@listserver.u2ug.org
Subject:RE: [U2] DCOUNT

Correct me if I'm wrong but does this method not require the DCOUNT
function to be executed each iteration of "I" to determine if you have
reached your max value?  Granted, for a small number of values it would
not be that much of a hit but I'd not like to encourage this on the off
chance that you use it on a large number of values somewhere else.

BobW
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Serguei
Sent: Friday, January 06, 2006 6:02 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DCOUNT

I personally would even write it like this if I am sure the number of
values
is no more then ten:
FOR I=1 TO DCOUNT(REC<15>,@VM)

(and of course I would not use number as a field position)
---
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] DCOUNT

2006-01-06 Thread Bob Woodward
Correct me if I'm wrong but does this method not require the DCOUNT
function to be executed each iteration of "I" to determine if you have
reached your max value?  Granted, for a small number of values it would
not be that much of a hit but I'd not like to encourage this on the off
chance that you use it on a large number of values somewhere else.

BobW
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Serguei
Sent: Friday, January 06, 2006 6:02 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DCOUNT

I personally would even write it like this if I am sure the number of
values
is no more then ten:
FOR I=1 TO DCOUNT(REC<15>,@VM)

(and of course I would not use number as a field position)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Elections and Membership

2006-01-06 Thread Larry Friedlander
   I had the same problem trying to sign-up.

   Larry E. Friedlander
   Assistant MIS Manager
  for Programming
   Utilities, Inc
   2335 Sanders Road
   Northbrook, IL 60062
   Telephone: 847-498-6440 x3318
   Fax # : 847-498-2066
   __

 From: Results <[EMAIL PROTECTED]>
 Reply-To: u2-users@listserver.u2ug.org
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Elections and Membership
 Date: Fri, 06 Jan 2006 10:59:43 -0500
 >Perry,
 > I've forwarded your complaint to our webmaster. If anyone else
 >is being blocked from joining, please speak up. We'll get you all
 >straightened out.
 >
 >
 >Perry Taylor wrote:
 >
 >>There appears to be a small problem on the New User Registration
 >>page
 >>http://u2ug.org/user.php?op=register&module=NS-NewUser . Here's
 >>what I'm
 >>getting...
 >>---
 >>New user registration
 >>User name: -- _UAUPASS * _UAUPASSCONFIRM * -- E-mail
 >>address: ( _FIELD_REQUIRED ) Option: Allow other users to view
 >>your e-mail address Fatal error: Call to undefined function
 >>getuserfieldlist() in
 >>/home/httpd/vhosts/u2ug.org/htdocs/modules/NS-NewUser/user.php on
 >>line
 >>115
 >>---
 >>
 >
 >--
 >
 > - Charles Barouch
 >
 > [EMAIL PROTECTED]
 > (718) 762-3884 x 1
 > P. O. Box 540957, Linden Hill, NY 11354-0957
 > www.KeyAlly.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] Backup, dbpause & 24/7 operation

2006-01-06 Thread Josh Volosov (3)
Hi,

I will be out of the office on the afternoon of 1/6/06.  I will return
to the office on Monday 1/9/06.

I will have limited access to e-mail or voice mail during this time.  If
a you need an immediate response to your e-mail please e-mail
[EMAIL PROTECTED]

Thanks and have a great day!

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


RE: [U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread Robert Paterson
And if you are using a Windows box, dbpause doe NOT close open
files at the O/S level (at least in UniData it does not)

Just a thought, have you tried the sync command available from
http://www.sysinternals.com to see if that helps?

I appreciate that the open files issue may still be a headache, but at
least any pending writes should be flushed from the OS level in that
instance...

(One less thing to consider!)


This e-mail is for the use of the intended recipient(s) only. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not use, disclose or 
distribute this e-mail without the author's prior permission. We have taken 
precautions to minimize the risk of transmitting software viruses, but we 
advise you to carry out your own virus checks on any attachment to this 
message. We cannot accept liability for any loss or damage caused by software 
viruses.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Elections and Membership

2006-01-06 Thread Results

Perry,
   I've forwarded your complaint to our webmaster. If anyone else is 
being blocked from joining, please speak up. We'll get you all 
straightened out.



Perry Taylor wrote:


There appears to be a small problem on the New User Registration page
http://u2ug.org/user.php?op=register&module=NS-NewUser . Here's what I'm
getting...
---
New user registration
User name:   
--  
_UAUPASS *  
_UAUPASSCONFIRM *  
--  
E-mail address: ( _FIELD_REQUIRED )  
Option:   Allow other users to view your e-mail address 
Fatal error: Call to undefined function getuserfieldlist() in

/home/httpd/vhosts/u2ug.org/htdocs/modules/NS-NewUser/user.php on line
115
--- 



--

- Charles Barouch

[EMAIL PROTECTED]
(718) 762-3884 x 1
	P. O. Box 540957, 
	Linden Hill, NY 11354-0957

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


[U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread David Wolverton
And if you are using a Windows box, dbpause doe NOT close open files at the
O/S level (at least in UniData it does not) -- so you cannot pull a backup
against a system that was 'paused' and count on it unless you are SURE your
Backup Software *really* handles open files correctly. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread Baakkonen, Rodney A (Rod) 46K
We only DB Pause the system long enough to sync up a parallel copy of the
database on our SAN. The parallel copy then gets unmounted off the
production server. It is mounted on the backup up server and a tape backup
is done. You need enough disk for another copy of your production files. We
mount the backup file system on another machine because tape processes
slowed our production box down, so we setup a special server just for
backups.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeff Powell
Sent: Friday, January 06, 2006 4:15 AM
To: u2 users group
Subject: [U2] Backup, dbpause & 24/7 operation


As our company grows we are getting more pressure to extend our
operation through the night. We have maintained a nightly backup that
does a dbpause to suspend unidata. This irritates our night shift people
since they can no longer use the system.

How do those companies who operate 24/7 get around this and perform
backups?

Thanks,

SB 5.3.8
Unidata 6
AIX 5.3
---
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] Backup, dbpause & 24/7 operation

2006-01-06 Thread mgolden
We do a disk-to-disk-to-tape backup to minimize the amount of quiet time 
required from the live data files, and we schedule the backup to coincide 
with the workers' scheduled break.


Michael Golden
Unique Fabricating Inc
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread Tom Dodds
When you reconnect/remirror the split drive do you have to re-sync the
complete volume or only the data that was updated since the split was
executed.

Tom Dodds
[EMAIL PROTECTED]
708-234-9608 Office
630-235-2975 Cell

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Paterson
Sent: Friday, January 06, 2006 9:04 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Backup, dbpause & 24/7 operation

If you are truly 24x7 then the best way in my opinion would be to mirror
- or better yet - triple mirror the disks.

Then, using dbpause to pause, split one of the mirrors off, dbresume and
then mount the split disk for backup separately.

The triple mirror will then mean you still have two sets of disks
operating and providing performance/redundancy whilst being able to
backup using the third set with your favourite tool.

:-)


This e-mail is for the use of the intended recipient(s) only. If you have
received this e-mail in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not use, disclose
or distribute this e-mail without the author's prior permission. We have
taken precautions to minimize the risk of transmitting software viruses, but
we advise you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by
software viruses.
---
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] Something Strange happened today {Unclassified}

2006-01-06 Thread George Gallen
This did happen to us once before, I think the circumstances were
around unix and not being able to spawn off a new process.

Our problem was with phantoms, I had a phantom process that fired 
off other phantom processes, the only problem was the processes that
were fired off were never released because the parent phantom had
never finished.

Our workaround for that was to have the parent phantom chain to itself
after it fired off a new phantom, thus allowing the child phantom to
fully release.

Once we killled the parent phantom job, all of our locked processed
started up like magic.

George

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of 
> HENDERSON MIKE,
> MR
> Sent: Thursday, January 05, 2006 10:05 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [uv] Something Strange happened today {Unclassified}
> 
> 
> Mark,
> 
> Since nobody else has replied, I'll put in my two cents worth ...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread Martin Phillips
> Then, using dbpause to pause, split one of the mirrors off, dbresume and
> then mount the split disk for backup separately.

Beware! Unless your application makes full use of transaction processing,
dbpause may well split in the middle of a business transaction. If you were,
for example, moving funds between two client accounts, restore of the backup
may have the money in both accounts (bad news) or neither account (a healthy
profit until someone spots it!).

As far as I am aware (and I have put much effort into this one) there is no
safe way to backup the system without at least briefly getting all the users
to a quiescent state. The easiest way to do this is to get them to log out
across the dbpause and mirror breaking operation.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread Thomas Derwin
Hi,

For starters, you might check the features of your AIX filesystem. Does it have 
any kind of snapshot feature? If it does, you might only need to "dbpause" 
while the snapshot command executes.

On DEC Tru64, we use the "Advanced filesystem" ("AdvFS"). It has a awesome 
feature called "clone filesets". When a clone is created, it keeps copies of 
the original data before any changes are written. We mount and backup the 
clone, which gives us a time-sliced snapshot while business rolls on. When the 
backup is done, we delete the clone and recover the disk space it needed.

Another traditional way is to use mirrored disks. The backup script would break 
the mirror, backup the static data on the unmirrored (and offline) set of 
disks, and remirror them when it finishes.

If your data is stored on a SAN device, the SAN hardware probably has features 
that can help you, too.

Hope this helps,
Tom Derwin

>>> [EMAIL PROTECTED] 01/06/06 5:14 AM >>>
As our company grows we are getting more pressure to extend our
operation through the night. We have maintained a nightly backup that
does a dbpause to suspend unidata. This irritates our night shift people
since they can no longer use the system.

How do those companies who operate 24/7 get around this and perform
backups?

Thanks,

SB 5.3.8
Unidata 6
AIX 5.3
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


-
This e-mail and any attachments may contain CONFIDENTIAL
information, including PROTECTED HEALTH INFORMATION. If you are not
the intended recipient, any use or disclosure of this information
is STRICTLY PROHIBITED; you are requested to delete this e-mail and
any attachments, notify the sender immediately, and notify the
LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877)
23-HIPAA / (877) 234-4722.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread Anthony Dzikiewicz
We are using Veritas NetBackup.  What we do is kick off the users, do a
disk to disk with Veritas, process nightly (approx 15 minutes of
exclusive system use), then allow users to login. After that we
duplicated the diskbackup to tape.

Our files that are backed up are only about 4.5gb.  So, it does go
pretty quick.  As far as people complaining, what can you say.  There
are absolutely more sophisticated ways of doing this using replication
and so forth.  The question is how much do you want to spend on this and
how much do you want complicate things ?  Sometimes you really have no
choice and you have to bit the bullet.

I say keep it simple.

Anthony

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell
> Sent: Friday, January 06, 2006 5:15 AM
> To: u2 users group
> Subject: [U2] Backup, dbpause & 24/7 operation
> 
> 
> As our company grows we are getting more pressure to extend 
> our operation through the night. We have maintained a nightly 
> backup that does a dbpause to suspend unidata. This irritates 
> our night shift people since they can no longer use the system.
> 
> How do those companies who operate 24/7 get around this and 
> perform backups?
> 
> Thanks,
> 
> SB 5.3.8
> Unidata 6
> AIX 5.3
> ---
> 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] Backup, dbpause & 24/7 operation

2006-01-06 Thread Robert DunnMiller
Jeff -

The answer to that question is rooted in the backup methodology you are
employing. If, for example, you are running on EMC, you can pause the
database long enough to split off a BCV, then resume the database, and
perform your backup from the "copy" you split off. The SHARK offers "Flash
Copy", HP Sure Store XP series offers "Business Copy".

Ultimately, the database is paused to obtain a quiescent image. However,
since these "splitting" operations tend to take only a few minutes, the
actual time that the database is unavailable is minimized, often no more
than 5-10 minutes.

Most shops that have moved to a 24/7 operational strategy have had to
revisit how they manage their backups to accommodate their availability
requirements.

Hope this offers a little insight for you.

Regards,

Robert DunnMiller
CIO, dmcs, Inc.
[EMAIL PROTECTED]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell
Sent: Friday, January 06, 2006 04:15
To: u2 users group
Subject: [U2] Backup, dbpause & 24/7 operation

As our company grows we are getting more pressure to extend our
operation through the night. We have maintained a nightly backup that
does a dbpause to suspend unidata. This irritates our night shift people
since they can no longer use the system.

How do those companies who operate 24/7 get around this and perform
backups?

Thanks,

SB 5.3.8
Unidata 6
AIX 5.3
---
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] Backup, dbpause & 24/7 operation

2006-01-06 Thread Gordon J Glorfield
Your query got me curious so I went to our DBA to ask.  We have a live 
system, a fallback system and a development system.  3:00 AM was 
determined to be the time with the lowest volume of activity.  So at that 
time we do a Unix system copy of the file systems from the live system to 
the fallback system.  The DBA said it takes just under 3 hours to do this. 
 As soon as that system copy is complete a tape backup of the fallback 
system is made and stored offsite.

Then each weekend the Thursday night tape is restored to the development 
machine.

It's not perfect but it works for us.


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

[EMAIL PROTECTED] wrote on 01/06/2006 05:14:50 AM:

[snip]
> How do those companies who operate 24/7 get around this and perform
> backups?

> Thanks,

[snip]


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/


Re: [U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread TVankirk
Jeff,
We also are a 24/7 shop and we use Tivoli Storage Manager and just 
back up Unidata hot. What happens is that some very active files will have 
errors when restored and we simply run fixfile, fixgroup, etc to throw out 
the incomplete records.  This is not perfect, but gets us 99% of the way.
Or you could mirror your data, break off the mirror, backup the 
mirror and then resync the mirrors. This would require a large hardware 
investment, but would be fairly easy to implement on AIX.
Thanks.

Unidata 6.1
AIX 5.2
TSM 5.2.6.1





Jeff Powell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/06/2006 05:14 AM
Please respond to u2-users
 
To: u2 users group 
cc: 
Subject:[U2] Backup, dbpause & 24/7 operation


As our company grows we are getting more pressure to extend our
operation through the night. We have maintained a nightly backup that
does a dbpause to suspend unidata. This irritates our night shift people
since they can no longer use the system.

How do those companies who operate 24/7 get around this and perform
backups?

Thanks,

SB 5.3.8
Unidata 6
AIX 5.3
---
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] Elections and Membership

2006-01-06 Thread Perry Taylor
There appears to be a small problem on the New User Registration page
http://u2ug.org/user.php?op=register&module=NS-NewUser . Here's what I'm
getting...

---
New user registration

User name:   
 
--  
_UAUPASS *  
 
_UAUPASSCONFIRM *  
 
--  
E-mail address: ( _FIELD_REQUIRED )  
 
Option:   Allow other users to view your e-mail address 
 

Fatal error: Call to undefined function getuserfieldlist() in
/home/httpd/vhosts/u2ug.org/htdocs/modules/NS-NewUser/user.php on line
115
--- 

Thanks.

Perry Taylor
Zirmed, Inc.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of u2ug
Sent: Friday, January 06, 2006 2:05 AM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [U2] Elections and Membership

All,
 While you are all welcome to be members of the lists and not be
members of the U2UG organization, we recommend that you consider joining
the U2UG. Membership is free and, with elections coming up soon, this is
an ideal time to join and let you voice be heard. To join the U2UG,
follow this link:

http://u2ug.org/user.php?op=check_age&module=NS-NewUser
 

- Charles Barouch, Moderator

U2-Users
U2-Community
RBSolutions
SBSolutions

Visit http://listserver.u2ug.org, 
enter your e-mail address, 
and 'browse all' lists to maintain your access.

For non-U2UG e-mail: [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, 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. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. 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
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread Robert Paterson
If you are truly 24x7 then the best way in my opinion would be to mirror
- or better yet - triple mirror the disks.

Then, using dbpause to pause, split one of the mirrors off, dbresume and
then mount the split disk for backup separately.

The triple mirror will then mean you still have two sets of disks
operating and providing performance/redundancy whilst being able to
backup using the third set with your favourite tool.

:-)


This e-mail is for the use of the intended recipient(s) only. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not use, disclose or 
distribute this e-mail without the author's prior permission. We have taken 
precautions to minimize the risk of transmitting software viruses, but we 
advise you to carry out your own virus checks on any attachment to this 
message. We cannot accept liability for any loss or damage caused by software 
viruses.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] DCOUNT

2006-01-06 Thread Serguei
I personally would even write it like this if I am sure the number of values
is no more then ten:
FOR I=1 TO DCOUNT(REC<15>,@VM)

(and of course I would not use number as a field position)


- Original Message - 
From: "Mark Johnson" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, January 05, 2006 5:21 AM
Subject: [U2] DCOUNT


> I'm finding that I'm doing a lot of programming for the processing through
> multi-valued attributes.
>
> I'm wondering if the method I'm using is the best way to determine the
last
> element.
>
> LAST=DCOUNT(REC<15>,@VM)
> FOR I=1 TO LAST
> (process something)
> NEXT I
>
> There was a REMOVE thread a few months ago and I use that when I expect
that
> the number of elements could test the patience of the EXTRACTs. REMOVE
doesn't
> give you the MV counter for the associated fields by itself. You have to
> manage separately and hope to keep in sync. That's more code.
>
> I know that in VB certain object array variables (a list box for example)
has
> a property for the number of elements. Is there anything in MV that I'm
not
> aware of for determining the last multi-value that's easier to type than
the
> DCOUNT expression. I'm looking at reducing my keystrokes.
>
> 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/


Re: [U2] DCOUNT

2006-01-06 Thread TPellitieri
Mark Johnson <[EMAIL PROTECTED]> wrote on Thu, 5 Jan 2006 00:21:37
-0500

> I'm finding that I'm doing a lot of programming for the processing
> through multi-valued attributes.
>
> I'm wondering if the method I'm using is the best way to determine
> the last element.
>
> LAST=DCOUNT(REC<15>,@VM)
> FOR I=1 TO LAST
>  (process something)
> NEXT I

If you're working with ASSOCIATED multi-values and you need to process
every one, this may be your best bet, although there are some other
options.

If you just need to process each item in a single multi-valued attribute
(without updating the original), you could consider:

REC15 = RAISE(REC<15>)
SELECT REC15 TO R15.LIST
LOOP WHILE READNEXT MV FROM R15.LIST DO
  (process MV)
REPEAT

For example, I use the above syntax to process each line in a sales order,
where the multi-value in the order header contains the keys to the
individual line items.

If your controlling multi-value is sorted and you only need to process a
known value, you can use the LOCATE function to find the appropriate spot.
With associated multi-values, you'll need to use the INSERT (or DELETE)
function on the associated items to add (or remove) value groups from the
list.  Note that these functions are flavor dependent.

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


RE: [U2] DCOUNT

2006-01-06 Thread Ross Ferris
But this doesn't save much on the typing front, which apparently is the
real objective of the question :-(

However, with a 'smart' pre-compiler you can achieve your OO objectives,
AND(or) reduce typing. (Of course we have such a beast within our Visage
environment)

There are some other advantages to this pre-compiler approach, like
being able to freely (and easily) change the physical implementation of
something if you DO find that there is a more efficient way to work.

For example your pre-compiler directive may look like this :

&vl REC 15 mysub

(I've assumed REALLY short names like vl (for a value loop) to reduce
typing, and that mysub is a reference to an internal subroutine to "do
something with the variables")

The initial implementation of "vl" may initially generate code something
like :

LAST = DCOUNT(REC<15>,@VM)
FOR I = 1 TO LAST
 GOSUB mysub
NEXT I

which is a saving on the typing front (my "favourite" is the
select/readnext/read/write loop). Or perhaps (better) with a small
change to mysub

LAST = DCOUNT(REC<15>,@VM)
FOR I = 1 TO LAST
 THIS.REC = REC<15,I>
 GOSUB mysub
NEXT I

Our next iteration on the journey may generate this code

TEMP.REC15 = REC<15>
LAST = DCOUNT(TEMP.REC15,@VM)
FOR I = 1 TO LAST
 THIS.REC15 = REC15<1,I>
 GOSUB mysub
NEXT I

to avoid jumping over the leading 14 attributes every time, and if LAST
was getting big, then we could change the implementation to generate

LOOP
 REMOVE THIS.REC15 FROM REC<15> SETTING DELIM
 GOSUB mysub
WHILE DELIM REPEAT

to gain the advantages of REMOVE (internal pointers for where we were up
to in the string)

The "nice" thing about this approach is that if you DO find a better way
to do "something" that you do often, it becomes very easy to change it
"everywhere" in your application.

(You can also have 'implementations' of things that may generate
something other than Basic code, but that is a whole other story -
suffice to say that this "snippet technology" also powers our
multi-lingual capabilities)

Within the context of our Visage development, by adopting his technique
we have a single source tree that can generate code that is
targeted/optimised for a particular OS & database version & type. Whilst
we can debug with the generated code, we develop at a higher (macro)
level

Maybe a long way off topic, but if you are serious about reducing
keystrokes, as part of our Active Code Reduction initiative we have
found that using this type of technique, a single high level
pre-compiler directive may generate 5-50 (or more) lines of "efficient",
error-free, local-standards compliant code, resulting in faster
development, and easier maintenance & enhancements

>>

Ross Ferris
Stamina Software
Visage > Better by Design!
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On Behalf Of Symeon Breen
>Sent: Friday, 6 January 2006 10:25 PM
>To: u2-users@listserver.u2ug.org
>Subject: Re: [U2] DCOUNT
>
>If we where obj orientated we could have REC<15>.dcount but alas no

>
>
>
>On 1/6/06, Larry Hiscock <[EMAIL PROTECTED]> wrote:
>> Mark Johnson wrote:
>>
>> > REMOVE doesn't give you the MV counter for the associated fields
>> > by itself. You have to manage separately and hope to keep in sync.
>> > That's more code.
>>
>> You can do multiple removes on different MV strings instead of
keeping a
>> counter and referencing the associated fields as REC.
>>
>> For example:
>>
>> LOOP
>>
>>REMOVE VAR1 FROM REC<15> SETTING DELIM
>>REMOVE VAR2 FROM REC<16> SETTING NOTHING
>>...
>>
>>{ do something with the variables }
>>
>> WHILE DELIM REPEAT
>>
>>
>> Larry Hiscock
>> Western Computer Services
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Backup, dbpause & 24/7 operation

2006-01-06 Thread Jeff Powell
As our company grows we are getting more pressure to extend our
operation through the night. We have maintained a nightly backup that
does a dbpause to suspend unidata. This irritates our night shift people
since they can no longer use the system.

How do those companies who operate 24/7 get around this and perform
backups?

Thanks,

SB 5.3.8
Unidata 6
AIX 5.3
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] OSBWRITE problem

2006-01-06 Thread Brian Leach
Colin,

That worked a treat. Thanks!

Brian 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Sent: 05 January 2006 20:44
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UD] OSBWRITE problem
> 
> You can try "NOCONVERT ON" to see if that fixes your problem.
> 
> Hth
> Colin Alfke
> Calgary, Canada
> 
> >-Original Message-
> >From: Brian Leach
> >
> >All,
> > 
> >I'm having a problem writing a binary file from UniData. 
> > 
> >I need to store some lengths as 4 byte integers, and I'm 
> deliberately 
> >encoding all numbers to base 250 + 1 shifted to avoid 
> writing char(0) 
> >or char(255)s but I'm still getting a problem with byte translation.
> ---
> 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] DCOUNT

2006-01-06 Thread Anthony Dzikiewicz
This is the way we always do it. 
For associations, you might be better off creating a separate set of
subroutines that add and delete to rows of associated values.  Its just
more controlled and you dont end of with uneven columns of data.  The
system Im working was not designed this way and I was finding tables of
data within records that were uneven.  We still have a little of that
left and I plan to knock that out when we can.
Anthony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Thursday, January 05, 2006 12:22 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] DCOUNT


I'm finding that I'm doing a lot of programming for the processing
through multi-valued attributes.

I'm wondering if the method I'm using is the best way to determine the
last element.

LAST=DCOUNT(REC<15>,@VM)
FOR I=1 TO LAST
(process something)
NEXT I

There was a REMOVE thread a few months ago and I use that when I expect
that the number of elements could test the patience of the EXTRACTs.
REMOVE doesn't give you the MV counter for the associated fields by
itself. You have to manage separately and hope to keep in sync. That's
more code.

I know that in VB certain object array variables (a list box for
example) has a property for the number of elements. Is there anything in
MV that I'm not aware of for determining the last multi-value that's
easier to type than the DCOUNT expression. I'm looking at reducing my
keystrokes.

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 Free Edition.
Version: 7.1.371 / Virus Database: 267.14.14/222 - Release Date:
1/5/2006
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.14/222 - Release Date:
1/5/2006
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] DCOUNT

2006-01-06 Thread Symeon Breen
If we where obj orientated we could have REC<15>.dcount but alas no 



On 1/6/06, Larry Hiscock <[EMAIL PROTECTED]> wrote:
> Mark Johnson wrote:
>
> > REMOVE doesn't give you the MV counter for the associated fields
> > by itself. You have to manage separately and hope to keep in sync.
> > That's more code.
>
> You can do multiple removes on different MV strings instead of keeping a
> counter and referencing the associated fields as REC.
>
> For example:
>
> LOOP
>
>REMOVE VAR1 FROM REC<15> SETTING DELIM
>REMOVE VAR2 FROM REC<16> SETTING NOTHING
>...
>
>{ do something with the variables }
>
> WHILE DELIM REPEAT
>
>
> Larry Hiscock
> Western Computer Services
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 1/3/2006
> ---
> 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] DCOUNT

2006-01-06 Thread Larry Hiscock
Mark Johnson wrote: 

> REMOVE doesn't give you the MV counter for the associated fields
> by itself. You have to manage separately and hope to keep in sync.
> That's more code.

You can do multiple removes on different MV strings instead of keeping a
counter and referencing the associated fields as REC.

For example:

LOOP

   REMOVE VAR1 FROM REC<15> SETTING DELIM
   REMOVE VAR2 FROM REC<16> SETTING NOTHING
   ...

   { do something with the variables }

WHILE DELIM REPEAT


Larry Hiscock
Western Computer Services

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 1/3/2006
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Elections and Membership

2006-01-06 Thread u2ug

All,
While you are all welcome to be members of the lists and not be 
members of the U2UG organization, we recommend that you consider joining 
the U2UG. Membership is free and, with elections coming up soon, this is 
an ideal time to join and let you voice be heard. To join the U2UG, 
follow this link:


   http://u2ug.org/user.php?op=check_age&module=NS-NewUser


- Charles Barouch, Moderator

U2-Users
U2-Community
RBSolutions
SBSolutions

	Visit http://listserver.u2ug.org, 
	enter your e-mail address, 
	and 'browse all' lists to maintain your access.


For non-U2UG e-mail: [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/