RE: Real Time Data Warehouse

[djordan]

Hi Tom

We customise many strategic systems to achieve this sort of facility.

I would question how real time the OLAP & BI tools are never mind the
database.  I would look at breaking the data in two components as some
details such as financial require to be snapshoted to ensure the
integrity of the data.  Others may be related to current sales where
accuracy is not so critical as is having a pretty good feel.  These
would require different update times.  You don't need to keep updating
End of Day balances every 10 minutes.  Look at whether you update the
remote files via triggers rather than trying to copy the whole file
across.

The big issue is to convert transactional data into timeshots that are
meaningful. 

I would suspect they are looking for a dashboard solution rather than an
OLAP tool. If you are in a position, can I suggest actually putting a
prototype system up in Universe to show some of the expected outcomes.
I often find that those requesting the information are not sure what
they are looking for, so if I show them useful information that they
require for decision making processes, then I can dictate the project.
Also a prototype in 2 days achieves 80% of the solution, where
management are then faced with a solution that is already partially
working to having to put up a lot of money for an unknown solution on
one of these BI Tools.  This has won us a lot of business.

There are many other ways of achieving this than just an ETL solution,
but you would probably end up with a mixture of solutions.

Jbase and Universe have similar code to updating SQL databses from BASIC
code and based on similar code to Visual Basic processes.

I have been putting a white paper together to try an identify that PICK
is the platform of choice for this time of environment.

Regards

David Jordan
Managing Consultant
[EMAIL PROTECTED]

Dacono Holdings Pty Ltd
Business & Technology Consulting
PO Box 909
Lane Cove 
NSW 2066
Australia
Ph 61 2 9418 8329
Fax 61 2 9427 2371
www.dacono.com.au 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Tom Firl
Sent: Tuesday, 10 February 2004 8:55 AM
To: U2-Users Distribution List (E-mail)
Subject: Real Time Data Warehouse


So, I'm moving on from my "encrypted database" problem (that was put on
hold) and now I have a new, interesting problem.  I'm looking at a
proposal that seems to demand a solution that is a cross between a "data
replication system" and a "data warehouse".  

The system needs to be able to "Extract" data from a feed up updates to
specified Universe or jBASE files in "real-time" (once a minute, or so
will suffice), do some "Transformation" on the data, then "Load" the
data into a DB2 or SQL Server (not my implementation requirement...
don't yell at me).  During peak times, I'm supposing could be over a
thousand updates per minute written to the data replication feed.  I
don't know if it's reasonable to expect this system to be able to handle
that kind of throughput... that is to be determined.

The rationale for the system is to allow people to use standard
reporting, OLAP, and BI tools.  In industry parlance, I think such a
system is called a "Real Time Data Warehouse (RTDW)".  

So, here's where you can help... 

I'm brainstorming for design/implementation ideas.  First, I'm trying to
get the lay-of-the-land of tools and companies that can help with the
"ETL" (Extract-Transform-Load) part of this project (is this what
DataStage does?).  Where do I look?

Second, I'm searching for clever ideas about how to create and extract
the data feed containing file updates -- such as leveraging UV-DR.  I'd
prefer to create the data replication feed in isolation from the ETL
tool.  Seeing as I'm a little lazy (and hoping we won't have to roll our
own) I'd like to evaluate off-the-shelf solutions.

TIA,

Tom Firl
Columbia Ultimate


-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Robert Ruschak is out of the office.

[rruschak]

I will be out of the office starting  02/09/2004 and will not return until
02/12/2004.

I will respond to your message when I return .Thank you

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Fred Finken is out of the office.

[ffinken]

I will be out of the office starting  02/09/2004 and will not return until
02/23/2004.


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Batch Mode Scanners

[Ross Ferris]

Hmmm - batch mode  why not go real-time online ? For a low cost alternative, I'd 
check out Worth Data (aka Worthington Data Systems)

Ross Ferris
Stamina Software
Visage – an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Karl L Pearson
>Sent: Tuesday, 10 February 2004 5:02 AM
>To: u2-users
>Subject: Batch Mode Scanners
>
>Background info:
>
>We are considering the purchase of some type of handheld scanner that
>will save our outside sales force the paper-pencil solutions they are
>currently using.
>
>Our idea is to have them enter a customer account number, then scan
>barcodes affixed to bins where our product is kept, then enter a number
>which represents an inventory adjustment.
>
>When they get back to their desk, they would plug the scanner in and hit
>a key and the data would be read off the scanner and processed by our
>business application.
>
>question for the list:
>
>What types of products are available which are easily setup and don't
>cost a first born child. The ones I've been familiar with in the past
>are Telxon and Intermec, but for real-time telnet connectivity we use
>Symbol (PDT3146us) technology.
>
>Any quick responses that point me in the right direction will be greatly
>appreciated.
>
>--
>Karl L. Pearson
>Director of IT,
>ATS Industrial Supply
>Direct: 801-978-4429
>Toll-free: 888-972-3182 x29
>Fax: 801-972-3888
>http://www.atsindustrial.com
>[EMAIL PROTECTED]
>
>
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.580 / Virus Database: 367 - Release Date: 6/02/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.580 / Virus Database: 367 - Release Date: 6/02/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Real Time Data Warehouse

[Ross Ferris]

Tom,

Just for some more background here  is the real reason you are having to go 
through the ETL is so that the users can "play" with your data using 'standard' BI 
tools like Cognos against the SQL database ?

Also, what USE is the information going to be put to ?! I remember one of the "classic 
tales" of a sales manager, CFO & CEO turning up @ a meeting at midday with their 
figures extracted from their real-time BI tool.

The sales manager got his extract @ 10am, the CFO @ 11am, and the CEO was handed his 
take as he walked in at midday --> and of course none of the figures reconciled. 

Cutting to the chase (in the version of the story I heard), the company stepped back 
from real-time for "big picture" stuff - and only used near real time for daily 
performance review.

Just curious .. your answer will impact your solution - but of course things will 
mature over time to if this is currently simply a 'me too' exercise, though hopefully 
there are some well considered objectives in mind.

Ross Ferris
Stamina Software
Visage – an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Dawn M. Wolthuis
>Sent: Tuesday, 10 February 2004 3:30 PM
>To: 'U2 Users Discussion List'
>Subject: RE: Real Time Data Warehouse
>
>Another possible name for a real-time data warehouse is Operational Data
>Store (ODS).  You will want a really good handle on the requirements for
>this.  I have worked in this arena with U2 for almost a decade.  There are
>many possibilities, but the biggest bang for the buck from my perspective
>is
>still to have users grab data from U2, where the data "thinks" like they
>do.
>
>
>Setting up to be able to populate spreadsheets from whatever is extracted,
>for example, is much easier than taking data from a non-1NF database that
>is
>quite easily understood by end-users and normalizing it only to find that
>users are then trying to second guess how the data looks in the new
>database
>and figuring out how to regroup it for a report.
>
>Using Cedarville's DOWNLOAD utility (you would want to wrap it for the
>end-user) or the www.entrinsik.com Informer tool from a web browser would
>let the user think intuitively to extract current data (without need for an
>ODS) and THEN populate a spreadsheet with the result.
>
>Any approach to actually porting data to SQL Server, for example, sounds so
>small and innocent until two years down the line you add up the costs of
>hardware, software, training for users and IT, on-going support, etc and
>find that it was a much bigger expense than anyone estimated up front.
>
>Just my two cents.  Best wishes!  --dawn
>
>Dawn M. Wolthuis
>Tincat Group, Inc.
>www.tincat-group.com
>
>Take and give some delight today.
>
>
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.580 / Virus Database: 367 - Release Date: 6/02/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.580 / Virus Database: 367 - Release Date: 6/02/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: U2 System Guru

[Results]

Phil,
   What part of the country (which country) and what sort of a guru do 
you want? We have a lot of sharp people here if you need a housecall.
 
   - Charles 'A Chicken in Every Pot and a Guru on Every Mountain Top' 
Barouch

Phil Grant wrote:

Hello all,
A client of mine is looking for a Universe on NT system expert. He got into a 
situation where a file grow to 2GB. Neither he or I knew of the file limit on 32 bit 
files. He would like someone to do a health check on his system. We contacted IBM but 
their prices are a bit steep.
Thank in advance,

Phil Grant
707-761-3707
He is no fool that gives up what he can not have,
to gain what he can not lose.
 



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Real Time Data Warehouse

[Dawn M. Wolthuis]

Another possible name for a real-time data warehouse is Operational Data
Store (ODS).  You will want a really good handle on the requirements for
this.  I have worked in this arena with U2 for almost a decade.  There are
many possibilities, but the biggest bang for the buck from my perspective is
still to have users grab data from U2, where the data "thinks" like they do.


Setting up to be able to populate spreadsheets from whatever is extracted,
for example, is much easier than taking data from a non-1NF database that is
quite easily understood by end-users and normalizing it only to find that
users are then trying to second guess how the data looks in the new database
and figuring out how to regroup it for a report.

Using Cedarville's DOWNLOAD utility (you would want to wrap it for the
end-user) or the www.entrinsik.com Informer tool from a web browser would
let the user think intuitively to extract current data (without need for an
ODS) and THEN populate a spreadsheet with the result.

Any approach to actually porting data to SQL Server, for example, sounds so
small and innocent until two years down the line you add up the costs of
hardware, software, training for users and IT, on-going support, etc and
find that it was a much bigger expense than anyone estimated up front.

Just my two cents.  Best wishes!  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: U2 System Guru

[Eugene Perry]

I am curious.  What size system are you running?  How many users, hardware
etc.  How many records do you have in 80GB?

Thanks

Eugene

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 09, 2004 9:19 PM
Subject: Re: U2 System Guru


> Convert the file to a Distributed File type where each part file can be up
to 2GB. We had some distributed files with 40+ parts, yielding a 'logical'
file of about 80GB.
> ken
> ===
> In a message dated 2/9/2004 10:38:23 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
> >
> >   Subj:  U2 System Guru
> >   Date:  2/9/2004 10:38:23 PM Eastern Standard Time
> >   From:  Phil Grant <[EMAIL PROTECTED]>
> >   To:  [EMAIL PROTECTED]
> >   Reply-To:  U2 Users Discussion List <[EMAIL PROTECTED]>
> >   Sent from the Internet (Details)
> >
> > Hello all,
> > A client of mine is looking for a Universe on NT system expert. He got
into a situation where a file grow to 2GB.
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: U2 System Guru

[KAbraha454]

Convert the file to a Distributed File type where each part file can be up to 2GB. We 
had some distributed files with 40+ parts, yielding a 'logical' file of about 80GB.
ken
===
In a message dated 2/9/2004 10:38:23 PM Eastern Standard Time, [EMAIL PROTECTED] 
writes:
> 
>   Subj:  U2 System Guru
>   Date:  2/9/2004 10:38:23 PM Eastern Standard Time
>   From:  Phil Grant <[EMAIL PROTECTED]>
>   To:  [EMAIL PROTECTED]
>   Reply-To:  U2 Users Discussion List <[EMAIL PROTECTED]>
>   Sent from the Internet (Details)
> 
> Hello all,
> A client of mine is looking for a Universe on NT system expert. He got into a 
> situation where a file grow to 2GB.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

U2 System Guru

[Phil Grant]

Hello all,
A client of mine is looking for a Universe on NT system expert. He got into a 
situation where a file grow to 2GB. Neither he or I knew of the file limit on 32 bit 
files. He would like someone to do a health check on his system. We contacted IBM but 
their prices are a bit steep.
 
Thank in advance,
 
Phil Grant
707-761-3707


He is no fool that gives up what he can not have,
to gain what he can not lose.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] Scope of ASSIGN 1 TO SYSTEM(1017) : Prevents translation of "@FM" into "\n" (newline) when "WRITE" to Type 1/19 files

[Craig Bennett]

Hi Herve,

sorry I took so long to reply, I needed time to write the test programs.

It seems that your reading of the UV code is only partially correct
(assuming I got my tests right).

I have attached my test code for you to look at. Tests 3 and 5 did not work
as I expected.
(if anyone on the list would like a copy of the code and it doesn't arrive
on the list, email me and I will ask Clif to put the code on his website).

Specifically:

   TEST3: calling a subroutine does seem to reset SYSTEM(1017).

and

TEST5: setting SYSTEM(1017) in a called subroutine does not affect the
calling program.

Run
TEST1017 1
TEST1017 2
TEST1017 3
TEST1017 4
TEST1017 5
TEST1017 6
TEST1017 7
TEST1017 8

to see my test results.

I tested in an account with the following RELLEVEL

0001: X
0002: 10.0.11
0003: REALITY
0004: REALITY.FORMAT
0005: 10.0.11

running on AIX 4.3.3.

Test results were:

***
TEST TEST1
Tests if ASSIGN 1 TO SYSTEM(1017) is reset with each read/write operation.
TEST1 OK
***
TEST TEST2
Tests if ASSIGN 1 TO SYSTEM(1017) is reset by open/close.
TEST2 OK
***
TEST TEST3
Tests if ASSIGN 1 TO SYSTEM(1017) can be altered by a subroutine call which
does
 not ASSIGN SYSTEM(1017)
TEST 3 Failed step 2 data converted when SYSTEM(1017) set.
***
TEST TEST4
Tests if ASSIGN 1 TO SYSTEM(1017) can be altered by a subroutine call which
rese
ts SYSTEM(1017)
TEST4 OK
***
TEST TEST5
Tests if ASSIGN 1 TO SYSTEM(1017) can be altered by a subroutine call which
sets
 SYSTEM(1017)
TEST 5 Failed step 2 data converted when SYSTEM(1017) set.
***
TEST TEST6
Tests if ASSIGN 1 TO SYSTEM(1017) can be altered by a subroutine which uses
the
EXECUTE instruction
TEST6 OK
***
TEST TEST7
Tests if SYSTEM(1017) is reset at start of EXECUTE instruction.
TEST7 OK
***
TEST TEST8
Tests if ASSIGN 1 TO SYSTEM(1017) alters behaviour in called subroutines.
TEST8 OK

regards,


Craig
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: using locate in compound true/false statement

[Stuart Boydell]

> Actually, "LOOP WHILE LOCATE" is incorrect syntax, and will fail on
> compilation.  You have to use the PICK flavor of LOCATE to do this.  

actually the ideal syntax works just fine.

partA = 'a' ; subAssemblyB = 'a':@am:'y':@am:'z'
loop while locate partA in subAssemblyB by 'al' setting glue do
subAssemblyB = 'x'
repeat




**
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 viruses.
**

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Re VPN and Samba problem

[Jason Theis]

David,

  Any chance you could repost your problem?  I am a new user but I have
samba running through a vpn.

JT

-Original Message-
From: Norman, David (SAAS) [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 4:21 PM
To: 'U2 User List'
Subject: Re VPN and Samba problem

Thanks to all who suggested solutions to my problem of not being able to
access samba shares through VPN. Unfortunately nothing really helped, so
we'll just have to wait for our facilities management support to come up
with a solution.


David Norman
Senior Systems Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
fax +61 8 8271 4844
* [EMAIL PROTECTED] 


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re VPN and Samba problem

[Norman, David (SAAS)]

Thanks to all who suggested solutions to my problem of not being able to
access samba shares through VPN. Unfortunately nothing really helped, so
we'll just have to wait for our facilities management support to come up
with a solution.


David Norman
Senior Systems Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
fax +61 8 8271 4844
* [EMAIL PROTECTED]  


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

[OT] Re: [ADMIN] The aforementioned and promised NAG about OVERQUOTING

[kevin zollinger]

Results <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]: 

> Susan,
> Curious, I find the reverse to be true. Since I usually read in 
> threads, I find that having to scroll through the last part to get to 
> the current part mildly annoying. With the post after, I find myself 
> skipping replies because the top looks familiar when I scan through my
> mail. 
> 

Which brings us to the dropping of the other shoe: Top or bottom posting 
should include e generous amount of trimming; enough that the entire 
message can fit in one screen. There are always exceptions, but I try very, 
very, very hard to remove most of the previous posters message, other than 
what I need to make my response make sense. 

Of course, I blame the whole top-posting problem on Microsoft. Until they 
suddenly "got" the Internet and dumped OE on us only rank newbies would top 
post, and it normally only took one "correction" to correct the error. M$ 
makes it so hard to post properly that many never try any more

IHNSHO, post however you want (I'll figure it out) but for digest-sake make 
sure to trim. (Ever try to read a digest from a group of non-trimming 
top-posters?) ;)

-- 
~ kevin zollinger
[EMAIL PROTECTED]

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [ADMIN] The aforementioned and promised NAG about OVERQUOTING

[Results]

Susan,
   Curious, I find the reverse to be true. Since I usually read in 
threads, I find that having to scroll through the last part to get to 
the current part mildly annoying. With the post after, I find myself 
skipping replies because the top looks familiar when I scan through my mail.

   - Charles 'Getting too Curmudgeonly to be Flexible' Barouch

Susan Lynch wrote:

Ray DeGennaro at Eaglerock IS [EMAIL PROTECTED] wrote:


 



with some explanations of why Netiquette is the way is it.
   



Ray, thank you for the informative links.  Interesting to discover that what
had appeared to be a stylistic preference is actually a rule of etiquette,
when I had always found it mildly annoying to have to search (or scroll down
past) a previously read (or composed) message to ferret out the answers to
the questions asked.  Oh, well, one must have a flexible attitude...
 

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [ADMIN] The aforementioned and promised NAG about OVERQUOTING

[Susan Lynch]

Ray DeGennaro at Eaglerock IS [EMAIL PROTECTED] wrote:


> 
> 
> with some explanations of why Netiquette is the way is it.


Ray, thank you for the informative links.  Interesting to discover that what
had appeared to be a stylistic preference is actually a rule of etiquette,
when I had always found it mildly annoying to have to search (or scroll down
past) a previously read (or composed) message to ferret out the answers to
the questions asked.  Oh, well, one must have a flexible attitude...


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Real Time Data Warehouse

[Results]

Tom,
Sixty to ninety days from now, I'll have a solution for you ::sigh:: I 
have the UniVerse side in my Tier I product (Zeus) but the SQL won't be 
until Tier II (in development) and I may or may not have the jBASE bits 
by then.
   You may want to look at writing a straight SQL read/write solution 
with UniVerse handling everything through phantoms. As to DataStage - we 
have a Stager or two on the list with us - I'm sure they'll be happy to 
respond.

   - Charles 'SQL is Dead, Dawn Said So, but I'm still adding it to my 
product' Barouch

Tom Firl wrote:

So, I'm moving on from my "encrypted database" problem (that was put on hold) and now I have a new, interesting problem.  I'm looking at a proposal that seems to demand a solution that is a cross between a "data replication system" and a "data warehouse".  

The system needs to be able to "Extract" data from a feed up updates to specified Universe or jBASE files in "real-time" (once a minute, or so will suffice), do some "Transformation" on the data, then "Load" the data into a DB2 or SQL Server (not my implementation requirement... don't yell at me).  During peak times, I'm supposing could be over a thousand updates per minute written to the data replication feed.  I don't know if it's reasonable to expect this system to be able to handle that kind of throughput... that is to be determined.

The rationale for the system is to allow people to use standard reporting, OLAP, and BI tools.  In industry parlance, I think such a system is called a "Real Time Data Warehouse (RTDW)".  

So, here's where you can help... 

I'm brainstorming for design/implementation ideas.  First, I'm trying to get the lay-of-the-land of tools and companies that can help with the "ETL" (Extract-Transform-Load) part of this project (is this what DataStage does?).  Where do I look?

Second, I'm searching for clever ideas about how to create and extract the data feed containing file updates -- such as leveraging UV-DR.  I'd prefer to create the data replication feed in isolation from the ETL tool.  Seeing as I'm a little lazy (and hoping we won't have to roll our own) I'd like to evaluate off-the-shelf solutions.

TIA,

Tom Firl
Columbia Ultimate
 



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Tuning Tru64

[kafsat taiyus]

Hello everybody,

We are running Unidata 5.2 on AlphaServer ES45 Model 2 Operating System:
Compaq Tru64 UNIX V5.1A

If we run sys_check it returns following suggestions.

Virtual Memory and Swap 
Operational: Check the values of ubc-maxpercent, ubc-minpercent,
ubc-borrowpercent, vm-ubcdirtypercent, vm-ubcseqpercent, and
vm-ubcseqstartpercent settings. 
One or more of these attributes is not set correctly. 

Virtual Memory and Swap 
Operational: Check the values of vm-page-free-target, vm-page-free-optimal,
vm-page-free-min, and vm-page-free-reserved settings. 
One or more of these attributes is not set correctly. 

Current values for thiese parameters are 
ubc-maxpercent = 100, ubc-minpercent = 10, ubc-borrowpercent = 20,
vm-ubcdirtypercent = 40, vm-ubcseqpercent = 10, and vm-ubcseqstartpercent =
50

vm-page-free-target = 768, vm-page-free-optimal = 394, vm-page-free-min = 20
, and vm-page-free-reserved = 10


Please give me some suggestion on these parameters.

Have a wonderful time.

Regards


Kafsat Taiyus
Network Administrator
Retail Decisions Pty Ltd

This email and any attachments are confidential and intended solely for the
use of the person or entity to whom they are addressed. If you are not the
intended recipient, please do not disclose, store, copy or take any action
in reliance on it or them. If you have received this message in error,
please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete
all copies on your system. Any opinion, advice or information in this email
is not necessarily that of the owners or officers of this company. Please
advise us immediately if you or your employer do not consent to email for
messages of this type. 

Retail Decisions has taken reasonable precautions to ensure that any
attachment to this email has been swept for viruses. However, we cannot
accept any liability for any damage sustained as a result of software
viruses, and would advise that you carry out your own virus checks before
opening any attachment. Please note that communications sent by or to any
person through our computer system may be viewed by other Retail Decisions
employees or officers strictly in accordance with law.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Real Time Data Warehouse

[Tom Firl]

So, I'm moving on from my "encrypted database" problem (that was put on hold) and now 
I have a new, interesting problem.  I'm looking at a proposal that seems to demand a 
solution that is a cross between a "data replication system" and a "data warehouse".  

The system needs to be able to "Extract" data from a feed up updates to specified 
Universe or jBASE files in "real-time" (once a minute, or so will suffice), do some 
"Transformation" on the data, then "Load" the data into a DB2 or SQL Server (not my 
implementation requirement... don't yell at me).  During peak times, I'm supposing 
could be over a thousand updates per minute written to the data replication feed.  I 
don't know if it's reasonable to expect this system to be able to handle that kind of 
throughput... that is to be determined.

The rationale for the system is to allow people to use standard reporting, OLAP, and 
BI tools.  In industry parlance, I think such a system is called a "Real Time Data 
Warehouse (RTDW)".  

So, here's where you can help... 

I'm brainstorming for design/implementation ideas.  First, I'm trying to get the 
lay-of-the-land of tools and companies that can help with the "ETL" 
(Extract-Transform-Load) part of this project (is this what DataStage does?).  Where 
do I look?

Second, I'm searching for clever ideas about how to create and extract the data feed 
containing file updates -- such as leveraging UV-DR.  I'd prefer to create the data 
replication feed in isolation from the ETL tool.  Seeing as I'm a little lazy (and 
hoping we won't have to roll our own) I'd like to evaluate off-the-shelf solutions.

TIA,

Tom Firl
Columbia Ultimate


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

wIntegrate script- dialog box?

[Barry Brevik]

wIntegrate v4.2.3.

Is it possible to create a dialog box in a client-side script that is
Non-Modal? When I use the dialog box editor, I don't get a choice, and it
always creates a script that has a line like this:

Style WS_CAPTION|WS_POPUP|WS_VISIBLE|WS_SYSMENU|DS_MODALFRAME

The docs I got from the IBM site don't talk about the DS_MODALFRAME
property, or if there is an alternative.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Standard Deviation

[Ray Wurlod]

I've done this in an I-descriptor.  The downside is that it's SD for a particular 
field only.  Also, to invoke it you must use CALC on the command line, to trigger the 
TOTAL() functions.  In the following example the data field is called F4.

  id: SD.F4
0001: I Standard deviation of F4; use CALC to evaluate
0002: IF T(1) > 1 THEN SQRT(T(F4*F4)-(T(1)*T(F4))/(T(1)-1)*T(1)) ELSE 0
0003:
0004: SD.F4
0005: 8R2
0006: S
0007:


- Original Message -
From: Ray Buchner <[EMAIL PROTECTED]>
Date: Mon, 9 Feb 2004 08:35:53 -0500 
To: 'U2 Users Discussion List' <[EMAIL PROTECTED]>
Subject: Standard Deviation

> Is there a Universe Basic command to calculate standard deviation?  If not,
> does anyone have a sub?
> -- 
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
> 

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Wintegrate message box

[Charlie Rubeor]

Many thanks!  I am still having a little trouble with an extra carriage
return, but I am able to use most of the code you sent from either unibasic
or a posix script.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Saturday, February 07, 2004 1:40 AM
To: U2 Users Discussion List
Subject: Re: Wintegrate message box


Sure,you could create a subroutine that writes a wintegrate script to their
device...


  EQU ESC TO CHAR(27), SOH TO CHAR(1)
  EQU STX TO CHAR(2), CR TO CHAR(13)

  WSCRIPT=ESC:SOH:'Global SKS446=':QUOTE(MESSAGE):CR
  WSCRIPT:=ESC:SOH:'Global HScript='
  WSCRIPT:='BStoAscii(`Loop\r'
  WSCRIPT:='Response = MessageBox(SKS446,'
  WSCRIPT:='"Message from ':MYNAME
  WSCRIPT:='",MB_ICONASTERISK|MB_OKCANCEL|MB_DEFBUTTON2)\r'
  WSCRIPT:='Until Response = "OK"\r'
  WSCRIPT:='Repeat'
  WSCRIPT:='`)':CR
  WSCRIPT:=ESC:SOH:'Convert HScript,char(254),cr':CR
  WSCRIPT:=ESC:SOH:'Execute HScript':

  OPENSEQ TTYNAME TO TTY$FD THEN
  MAXN=LEN(WSCRIPT)
  FOR N=1 TO MAXN STEP 80
 TEMP=WSCRIPT[N,80]
 WRITEBLK TEMP ON TTY$FD THEN WRITTEN=1
  NEXT N
  CLOSESEQ TTY$FD

One of the guru's on the list can probably come up with a better solution
but this works pretty well for me.  This is not the complete subroutine.

Hope this helps ya.

Scott
> Does anybody know if it is possible to send a wintegrate pop-up box to 
> a different user, from either a unibasic program or a shell script? 
> Specifically, if Fred is trying to access a record, which is locked by 
> Barney, is it possible to have a pop-up box appear on Barney's screen? 
> Currently, we send an email to Barney, which does not work well if 
> Barney does not have his email client open.
> 
> This is just one example.  Our users are currently thinking up several 
> more applications where they would like to do this, if it is possible.
> 
> tia
> 
> Charlie Rubeor
> Unix/Database Admin
> The Wiremold Company
> 800.338.1315 x3498
> 860.523.3690 fax
> > À votre service
> > 
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

UNCLASSIFIED RE: UV secondary index

[HENDERSON MICHAEL MR]

Margus,

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
> Sent: Monday, 9 February 2004 10:23 p.m.
> To: [EMAIL PROTECTED]
> Subject: UV secondary index
> 
> 
> Hello,
> 
> I have distributed UV file with total size about 2.5Gb.
> I made secondary index
> CREATE. INDEX file field1 ... field6
> BUILD.INDEX file field1 ... field6
This syntax creates & builds six separate secondary index files, so that
inserting a row in the main file will create probably between six and
eighteen additional I/O operations to the multiple indices.
Is this what you intended?
If you actually wanted to create a single secondary index based on a
concatenation of the first six fields, you need to create an I-type which
does the concatenation, then index on the I-type.
If you do need six separate secondary indices, maybe you need to look at
where the index files are placed (different disk channel from main
file,etc.)

Another possibility is that the data is very 'clumpy' on one or more index
fields, so that a large proportion of the records share the same value for
that index.  When UV comes to add a value to the index, it has to scan
through a huge set of identical values and then put the new occurrence at
the end: this gets exponentially slower.  If the shared value is ,
then re-creating your index/indices with NO.NULLS will help.  If it's not
null (maybe it's a month number, so all records fall into only twelve
distinct values?), then you need to find some way of creating a more-unique
(e.g. month and day) indexable value.


HTH

Mike


> 
> After that, rows inserting takes very long time.
> (4000 rows. Server so busy, that other users can't do anything.
> If I removed index then inserting process is OK, but I need this
> index for reporting)
> Is it normal in UniVerse? 
> How to avoid this problem?
> I use UniVerse 9.5.2 on AIX 5.2
> 
> Thanks,
> Margus Kandelin
> 

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Batch Mode Scanners

[Kent Walker]

I've had success with Hand Held Product's "Dolphin 7200" batch 
scanner.  The Dolphin is a very small, lightweight unit.  The C language 
compiler in their development kit is easy to use and the kit has several 
templates which can be used to create applications like you apparently 
need.  The unit runs a micro-DOS system.  The Post Office uses these, which 
is testimony to their ruggedness.

http://www.hhp.com/hhp/products/product.tpl?prodsku=8211202246993

Have used Intermec products in the past and they also performed 
well.  Programmed their old 9440 handhelds using the proprietary IRL code 
to develop applications - not sure what they're using now.

At 10:01 AM 2/9/2004, Karl L Pearson wrote:
Background info:

We are considering the purchase of some type of handheld scanner that
will save our outside sales force the paper-pencil solutions they are
currently using.
Our idea is to have them enter a customer account number, then scan
barcodes affixed to bins where our product is kept, then enter a number
which represents an inventory adjustment.
When they get back to their desk, they would plug the scanner in and hit
a key and the data would be read off the scanner and processed by our
business application.
question for the list:

What types of products are available which are easily setup and don't
cost a first born child. The ones I've been familiar with in the past
are Telxon and Intermec, but for real-time telnet connectivity we use
Symbol (PDT3146us) technology.
Any quick responses that point me in the right direction will be greatly
appreciated.
--
Karl L. Pearson
Director of IT,
ATS Industrial Supply
Direct: 801-978-4429
Toll-free: 888-972-3182 x29
Fax: 801-972-3888
http://www.atsindustrial.com
[EMAIL PROTECTED]
---
Kent Walker - Datatel Analyst
Information Technology - U.C. Hastings College of the Law
415-565-4635
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: InValid Characters

[Susan Lynch]

Tim,

UD 6.0.6 (but, if I remember correctly, this was true on the release 5 that
we came from as well, and our standard policy is to uninstall and re-install
Unidata for a new release, which should have replaced CTLGTB).  This being
my first experience with the Unidata flavor, I thought it was standard
behavior - annoying but standard.  So, rather than set up what I thought was
a non-standard synonym (and have to set  up on all the customer machines as
well, if one of my colleagues started using it), I was just avoiding editing
lists.

The synonym entry in the VOC does work as expected.

Susan M. Lynch
F.W. Davison & Company, Inc.



- Original Message -
From: "Timothy Snyder" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Monday, February 09, 2004 1:41 PM
Subject: Re: InValid Characters


>
>
>
>
> I tried to respond a while ago, but my message came back with "The
> message's content type was not explicitly allowed".  I'll try a different
> cut-and-paste approach.  Hopefully this isn't a duplicate for anybody
>
> 
> > "Susan Lynch" <[EMAIL PROTECTED]>
> >
> >Thanks - I just looked at CTLGTB and there is an entry there for both.
> >
> >EDIT-LIST looks like this:
> >
> >M
> >0
> >@UDTHOME/SYS_BP EDIT-LIST
> >root
> >
> >EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST.
> >
> >In UDTHOME, we have a sys directory, which contains a SYS_BP file, which
> contains EDIT.LIST and EDIT_LIST, not EDIT-LIST.
> 
>
> Susan,
>
> That all looks like what I'm seeing on a system here, and both EDIT-LIST
> and EDIT.LIST work fine. What platform, UDT release, etc. are you working
> with?
>
> Just for giggles, it may be interesting to create a synonym VOC entry for
> EDIT-LIST that looks like this:
> 1: S
> 2: EDIT.LIST
>
> If that works, it may help track this down.
>
> Tim Snyder
> IBM Data Management Solutions
> Consulting I/T Specialist , U2 Professional Services
>
> [EMAIL PROTECTED]
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
>


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Help wanted creating an efficient SELECT statement

[Ray DeGennaro at Eaglerock IS]

At 05:26 + 2004/02/06, Marco Manyevere wrote:
Short and easy to follow but N is not always numeric.
You can add a regular old variable to hold all of the prefixes, use a 
LOCATE() to find the field number of the prefix and then use that to 
access the array N.  Going through all this, might just make the 
I-Type the way to go.  How often do you expect to have to do this 
sort?  Is it something that will run in a batch or is it a request 
that a user will be sitting there waiting for a response?

Ray
--
.=.
| =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= |
| -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- |
|      |
|Midwest Regional Office: 815-547-0662 (voice) 503-905-8153 (eFax)|
.=.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [ADMIN] The aforementioned and promised NAG about OVERQUOTING

[Ray DeGennaro at Eaglerock IS]

If you are replying to several points, do not top-post.
This one really should be:

Don't Top-Post, especially if the reply is already "Right Posted".

Here's two links:
	
	
with some explanations of why Netiquette is the way is it.  They're 
targeted for Usenet, but a mailing list suffers from all the standard 
Usenet problems, and has the additional disadvantage of not having 
Reference: headers to thread by.

Hopefully folks will see the reasons behind interleaved replies and 
trimming posts.  Otherwise Cliff might have to wield his moderator 
power more forcefully.

Ray
--
.=.
| =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= |
| -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- |
|      |
|Midwest Regional Office: 815-547-0662 (voice) 503-905-8153 (eFax)|
.=.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: InValid Characters

[Timothy Snyder]

I tried to respond a while ago, but my message came back with "The
message's content type was not explicitly allowed".  I'll try a different
cut-and-paste approach.  Hopefully this isn't a duplicate for anybody


> "Susan Lynch" <[EMAIL PROTECTED]>
>
>Thanks - I just looked at CTLGTB and there is an entry there for both.
>
>EDIT-LIST looks like this:
>
>M
>0
>@UDTHOME/SYS_BP EDIT-LIST
>root
>
>EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST.
>
>In UDTHOME, we have a sys directory, which contains a SYS_BP file, which
contains EDIT.LIST and EDIT_LIST, not EDIT-LIST.


Susan,

That all looks like what I'm seeing on a system here, and both EDIT-LIST
and EDIT.LIST work fine. What platform, UDT release, etc. are you working
with?

Just for giggles, it may be interesting to create a synonym VOC entry for
EDIT-LIST that looks like this:
1: S
2: EDIT.LIST

If that works, it may help track this down.

Tim Snyder
IBM Data Management Solutions
Consulting I/T Specialist , U2 Professional Services

[EMAIL PROTECTED]
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Batch Mode Scanners

[Dave Taylor]

Karl,

I don't know about the cost of a first born child these days (we're several
years past that), and I don't think you can get both "good" and "cheap" at
the same time.

But, we did a project for a customer using the Symbol 8100 series with a
cellular phone connection and then (to offer a lower cost alternative)
retrofitted it to a T-Mobile Pocket PC Phone.

We gave up the "scanner" and the "print" functions that we had on the
Symbol, but retained the portability and were able to manually enter the
necessary information at a significant cost savings.

The Pocket PC Phone can accept a Storage Card that can store your
information, and it does have an IR port, plus a docking cradle to connect
it to a PC via cable, for data upload.

Your users would have to enter the product numbers manually, instead of
scanning.

The main advantage is that the data would not have to be reentered into your
database, but the inital data entry (eg writing down the information on a
pad) would still have to be done in the field.

I'll be glad to discuss this in more detail if you wish.

Rgds,

Dave

Dave Taylor
Sysmark Information Systems, Inc.
800-SYSMARK (800-797-6275)
www.sysmarkinfo.com


- Original Message -
From: "Karl L Pearson" <[EMAIL PROTECTED]>
To: "u2-users" <[EMAIL PROTECTED]>
Sent: Monday, February 09, 2004 10:01 AM
Subject: Batch Mode Scanners


> Background info:
>
> We are considering the purchase of some type of handheld scanner that
> will save our outside sales force the paper-pencil solutions they are
> currently using.
>
> Our idea is to have them enter a customer account number, then scan
> barcodes affixed to bins where our product is kept, then enter a number
> which represents an inventory adjustment.
>
> When they get back to their desk, they would plug the scanner in and hit
> a key and the data would be read off the scanner and processed by our
> business application.
>
> question for the list:
>
> What types of products are available which are easily setup and don't
> cost a first born child. The ones I've been familiar with in the past
> are Telxon and Intermec, but for real-time telnet connectivity we use
> Symbol (PDT3146us) technology.
>
> Any quick responses that point me in the right direction will be greatly
> appreciated.
>
> --
> Karl L. Pearson
> Director of IT,
> ATS Industrial Supply
> Direct: 801-978-4429
> Toll-free: 888-972-3182 x29
> Fax: 801-972-3888
> http://www.atsindustrial.com
> [EMAIL PROTECTED]
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Joseph Baker/Columbus/IBM is out of the office.

[Joseph Baker]

I will be out of the office starting February 9, 2004 and will not return
until February 10, 2004.

I will be out of the office February 9.  Please leave me a voice mail
message at (614) 659-7457 if your message is urgent.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Batch Mode Scanners

[Jeff Schasny]

or these which are not quite as ruggedized but cheaper

http://www.symbol.com/products/mobile_computers/mobile_palm_spt1550.html

-Original Message-
From: Jeff Schasny [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 11:15 AM
To: U2 Users Discussion List
Subject: RE: Batch Mode Scanners


 you might want to check into the Symbol spt1800

http://www.symbol.com/products/mobile_computers/mobile_palm_spt1800.html

-Original Message-
From: Karl L Pearson [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 11:02 AM
To: u2-users
Subject: Batch Mode Scanners


Background info:

We are considering the purchase of some type of handheld scanner that
will save our outside sales force the paper-pencil solutions they are
currently using.

Our idea is to have them enter a customer account number, then scan
barcodes affixed to bins where our product is kept, then enter a number
which represents an inventory adjustment.

When they get back to their desk, they would plug the scanner in and hit
a key and the data would be read off the scanner and processed by our
business application.

question for the list:

What types of products are available which are easily setup and don't
cost a first born child. The ones I've been familiar with in the past
are Telxon and Intermec, but for real-time telnet connectivity we use
Symbol (PDT3146us) technology.

Any quick responses that point me in the right direction will be greatly
appreciated.

-- 
Karl L. Pearson
Director of IT,
ATS Industrial Supply
Direct: 801-978-4429
Toll-free: 888-972-3182 x29
Fax: 801-972-3888
http://www.atsindustrial.com
[EMAIL PROTECTED]


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Batch Mode Scanners

[Jeff Schasny]

 you might want to check into the Symbol spt1800

http://www.symbol.com/products/mobile_computers/mobile_palm_spt1800.html

-Original Message-
From: Karl L Pearson [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 11:02 AM
To: u2-users
Subject: Batch Mode Scanners


Background info:

We are considering the purchase of some type of handheld scanner that
will save our outside sales force the paper-pencil solutions they are
currently using.

Our idea is to have them enter a customer account number, then scan
barcodes affixed to bins where our product is kept, then enter a number
which represents an inventory adjustment.

When they get back to their desk, they would plug the scanner in and hit
a key and the data would be read off the scanner and processed by our
business application.

question for the list:

What types of products are available which are easily setup and don't
cost a first born child. The ones I've been familiar with in the past
are Telxon and Intermec, but for real-time telnet connectivity we use
Symbol (PDT3146us) technology.

Any quick responses that point me in the right direction will be greatly
appreciated.

-- 
Karl L. Pearson
Director of IT,
ATS Industrial Supply
Direct: 801-978-4429
Toll-free: 888-972-3182 x29
Fax: 801-972-3888
http://www.atsindustrial.com
[EMAIL PROTECTED]


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: using locate in compound true/false statement

[Mats Carlid]

Dangerous syntax  this pick style locate.
It ooks like a function but it isn't.
Actually it is a  statement with  THEN ELSE clauses.
Once  you realise that it's crystal clear .
You can't write  IF READ ...  and you can't write IF LOCATE() ...
but you can write   WHILE READ  and WHILE LOCATE()
as  you can with any statement with an ELSE clause.
/Mats

Glenn W. Paschal wrote:

Actually, "LOOP WHILE LOCATE" is incorrect syntax, and will fail on
compilation.  You have to use the PICK flavor of LOCATE to do this.  

Still, you are correct in that "LOOP WHILE LOCATE()" works fine, but "IF
LOCATE() THEN" will not compile.
A side note, TRUE.FALSE.FLAG = LOCATE() also will not compile.
However, if instead of using "IF LOCATE() THEN", you simply use "LOCATE()
THEN" it will work.
I realize you were venting, and I must agree in part that it would appear to
present somewhat of an inconsistency, but I can more see why "IF LOCATE()"
would not work, than I can tell you why "WHILE LOCATE()" does work.  I would
have expected neither to work.
H

  -



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Batch Mode Scanners

[Karl L Pearson]

Background info:

We are considering the purchase of some type of handheld scanner that
will save our outside sales force the paper-pencil solutions they are
currently using.

Our idea is to have them enter a customer account number, then scan
barcodes affixed to bins where our product is kept, then enter a number
which represents an inventory adjustment.

When they get back to their desk, they would plug the scanner in and hit
a key and the data would be read off the scanner and processed by our
business application.

question for the list:

What types of products are available which are easily setup and don't
cost a first born child. The ones I've been familiar with in the past
are Telxon and Intermec, but for real-time telnet connectivity we use
Symbol (PDT3146us) technology.

Any quick responses that point me in the right direction will be greatly
appreciated.

-- 
Karl L. Pearson
Director of IT,
ATS Industrial Supply
Direct: 801-978-4429
Toll-free: 888-972-3182 x29
Fax: 801-972-3888
http://www.atsindustrial.com
[EMAIL PROTECTED]


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV secondary index

[Brian Leach]

Margus,

Wol's answer hit the nail on the head and will probably sort out the
problem, but if it does not you might need to sit down and consider the
variation in what you are indexing, as that is the main reason why an index
will slow (if you have a million records and you are trying to index a field
that can have only 20 different permutations, that is not a good idea).

You might need to condider looking at extending your application design, for
example to see whether you can combine fields together into a single indexed
idesciptor to provide better variance (this does not make sense for all data
but a status code and a sub-status that are always selected together
provides an example). 


Brian Leach

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Anthony Youngman
Sent: 09 February 2004 09:46
To: U2 Users Discussion List
Subject: RE: UV secondary index

Two tricks to speed things up ...

Firstly, would the NO.NULLS keyword speed things up? I'm guessing your
fields can often be blank, and in this case you will have a single huge
record knocking your index for six!

Secondly, would the pause and resume indexing commands work? During the day,
while the users are working, you pause index updates. At the end of the day
(or whenever you need to run the reports) you resume indexing.
Okay, it'll knacker the system while it sorts out the indices, but it'll be
one short, concentrated hit. The you run your reports, disable indexing
again, and let the users at it ...

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]
Sent: 09 February 2004 09:23
To: [EMAIL PROTECTED]
Subject: UV secondary index

Hello,

I have distributed UV file with total size about 2.5Gb.
I made secondary index
CREATE. INDEX file field1 ... field6
BUILD.INDEX file field1 ... field6

After that, rows inserting takes very long time.
(4000 rows. Server so busy, that other users can't do anything.
If I removed index then inserting process is OK, but I need this index for
reporting) Is it normal in UniVerse? 
How to avoid this problem?
I use UniVerse 9.5.2 on AIX 5.2

Thanks,
Margus Kandelin
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users





***

This transmission is intended for the named recipient only. It may contain
private and confidential information. If this has come to you in error you
must not act on anything disclosed in it, nor must you copy it, modify it,
disseminate it in any way, or show it to anyone. Please e-mail the sender to
inform us of the transmission error or telephone ECA International
immediately and delete the e-mail from your information system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911
7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1
212 582 2333.


***

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


This email was checked by MessageLabs SkyScan before entering Microgen.



This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.

DISCLAIMER

This email and any attachments are confidential and may also be
privileged.

If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.

In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]

Microgen Information Management Solutions
http://www.microgen.co.uk
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: InValid Characters

[Susan Lynch]

Tim,

Thanks - I just looked at CTLGTB and there is an entry there for both.

EDIT-LIST looks like this:

M
0
@UDTHOME/SYS_BP EDIT-LIST
root

EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST.

In UDTHOME, we have a sys directory, which contains a SYS_BP file, which
contains EDIT.LIST and EDIT_LIST, not EDIT-LIST.

Does this indicate that one of my predecessors on these systems was getting
adventuresome, or is this standard issue?

Susan M. Lynch
F.W. Davison & Company, Inc.



- Original Message -
From: "Timothy Snyder" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Monday, February 09, 2004 11:51 AM
Subject: Re: InValid Characters


>
>
>
>
>
> > the systems I work on don't have EDIT-LIST, and I never think
> > to change the punctuation and try the revised form of the
> > commands - I grew up on EDIT-LIST and SAVE-LIST, etc.
>
> The ECL parser should accept the "dashed" versions of these commands.  Any
> chance you have a VOC entry (or something in the global catalog) for
> EDIT-LIST or EDIT.LIST that's getting in the way?
>
> Tim Snyder
> IBM Data Management Solutions
> Consulting I/T Specialist , U2 Professional Services
>
> [EMAIL PROTECTED]
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
>


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Secondary Indices on Distributed Files

[gcanedy]

I've got a Distributed File that I'm trying to create indices on.  Four of
the fields are D-Types, and CREATE.INDEX runs fine for them.  Three fields
though, are I-Types (that are compiled and working), where CREATE.INDEX
gives the following error:

  I-descriptor must be compiled before execution.

  I-descriptor must be compiled before execution.

  I-descriptor must be compiled before execution.

  Program "*UVPRINTMSG":  pc = 34,  Variable previously undefined.
Zero length string used.
  [00]

All seven fields are working just fine as indices on the original file that
was a Static Hashed file.  I'm setting up the Distributed File to get
around the 2GB limit issues.

Does anyone know of any limitations putting secondary indices onto
distributed files?

Thanks!
Gary Canedy





---
This email and any files transmitted with it are intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material.   If you received this email in error, please
contact the sender immediately and delete this email from your system.  If
you are not the named addressee, you should not disseminate, distribute,
print, or copy the email, or take any action in reliance on its contents.


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

MBSII or Profi'C

[Glenn W. Paschal]

(sorry, last message had no subject...  Resending.)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Glenn W. Paschal
Sent: Sunday, February 08, 2004 4:27 PM
To: [EMAIL PROTECTED]
Subject: (no subject)


Hello, group!
 
Can anyone tell me if they have used or are using a product called Profi'C
from MBSII.net?  (It's an accounting package for UV)
 
If so, can you give me a general overview... pros/cons... likes/dislikes...
etc?
 
Thanks,
 
Glenn W. Paschal
PasTech LLC
Computer Consulting
ph. (931) 526-9631
fx. (931) 526-9678
email.   [EMAIL PROTECTED]
web.   www.pastech.net
-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users




-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: InValid Characters

[Timothy Snyder]

> the systems I work on don't have EDIT-LIST, and I never think
> to change the punctuation and try the revised form of the
> commands - I grew up on EDIT-LIST and SAVE-LIST, etc.

The ECL parser should accept the "dashed" versions of these commands.  Any
chance you have a VOC entry (or something in the global catalog) for
EDIT-LIST or EDIT.LIST that's getting in the way?

Tim Snyder
IBM Data Management Solutions
Consulting I/T Specialist , U2 Professional Services

[EMAIL PROTECTED]
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: using locate in compound true/false statement

[Glenn W. Paschal]

Actually, "LOOP WHILE LOCATE" is incorrect syntax, and will fail on
compilation.  You have to use the PICK flavor of LOCATE to do this.  

Still, you are correct in that "LOOP WHILE LOCATE()" works fine, but "IF
LOCATE() THEN" will not compile.
A side note, TRUE.FALSE.FLAG = LOCATE() also will not compile.

However, if instead of using "IF LOCATE() THEN", you simply use "LOCATE()
THEN" it will work.

I realize you were venting, and I must agree in part that it would appear to
present somewhat of an inconsistency, but I can more see why "IF LOCATE()"
would not work, than I can tell you why "WHILE LOCATE()" does work.  I would
have expected neither to work.

Hmmm

See the following three examples.

>ED BP TEST.PGM.1
0001:   ABC = "A":@FM:"B":@FM:"C"
0002:   ABCD = "ABCD"
0003:   CNTR = 0
0004:   LOOP
0005:  CNTR += 1
0006:  X = ABCD[CNTR,1]
0007:   WHILE LOCATE(X,ABC;POS)
0008:  PRINT X:" FOUND."
0009:   REPEAT
0010:   STOP
>RUN BP TEST.PGM.1
A FOUND.
B FOUND.
C FOUND.

>ED BP TEST.PGM.2
0001:   ABC = "A":@FM:"B":@FM:"C"
0002:   ABCD = "ABCD"
0003:   CNTR = 0
0004:   FOR CNTR = 1 TO 4
0005:  X = ABCD[CNTR,1]
0006:  IF LOCATE(X,ABC;POS) THEN
0007: PRINT X:" FOUND."
0008:  END ELSE
0009: PRINT X:" was not found."
0010:  END
0011:   NEXT CNTR
0012:   STOP
>BASIC BP TEST.PGM.2

0006 IF LOCATE(X,ABC;POS) THEN
   ^
';' unexpected, Was expecting: '!', ')', '=', "AND", "OR", "LT", "LE","GT",
"GE", "NE", "EQ", "MATCH"
0008 END ELSE
 ^
"ELSEEOL" unexpected, Was expecting: END, "NEXT", "UNTIL", "WHILE"
Array 'LOCATE' never dimensioned.

3 Errors detected, No Object Code Produced.

>ED BP TEST.PGM.3
0001:   ABC = "A":@FM:"B":@FM:"C"
0002:   ABCD = "ABCD"
0003:   CNTR = 0
0004:   FOR CNTR = 1 TO 4
0005:  X = ABCD[CNTR,1]
0006:  LOCATE(X,ABC;POS) THEN
0007: PRINT X:" FOUND."
0008:  END ELSE
0009: PRINT X:" was not found."
0010:  END
0011:   NEXT CNTR
0012:   STOP
>RUN BP TEST.PGM.3
A FOUND.
B FOUND.
C FOUND.
D was not found.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Stuart Boydell
Sent: Sunday, February 08, 2004 11:19 PM
To: U2-Users
Subject: using locate in compound true/false statement


A mild annoyance at some inconsistence using boolesque statements such as
locate. One can use the syntax: loop while locate moon in sky setting sun do
;* a thing of beauty ...repeat

yet cannot use:
if locate spoon in pudding setting jelly then ... ;* food fight!

Just thinking it would be nice if the boolean nature of the first syntax was
applicable with something firmer than the wobbly inconsistency of the
second. 

Regards,
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 viruses.
**

-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users




--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: InValid Characters

[Susan Lynch]

Mark,

You are correct about EDIT.LIST, but the systems I work on don't have
EDIT-LIST, and I never think to change the punctuation and try the revised
form of the commands - I grew up on EDIT-LIST and SAVE-LIST, etc.  I keep
forgetting that someone one of the predecessor products decided to move away
from the standard Pick spelling of the commands.

When I tried EDIT-LIST and it said 'not a verb', I just went to plan B!

Susan M. Lynch
F.W. Davison & Company, Inc.



- Original Message -
From: "Mark Johnson" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 8:07 PM
Subject: Re: InValid Characters


> UD has EDIT-LIST or EDIT.LIST.
> - Original Message -
> From: "Susan Lynch" <[EMAIL PROTECTED]>
> To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> Sent: Friday, February 06, 2004 6:51 PM
> Subject: Re: InValid Characters
>
>
> > Bill,
> >
> > Not sure whether you are on UV or UD, so I will avoid using the
EDIT-LIST
> > command (which UD does not have).  Given that restriction, probably the
> > easiest method would be to
> >
> > SELECT PS = "[101393" BY-DSND @ID
> > (assuming that @id is left-justified)
> >
> > If only 1 item selected, DELETE PS
> >
> > If more than 1 item selected, SELECT PS SAMPLE 1, then LIST PS to be
sure
> > that the one selected is the one with the unusual characters in the key.
> >
> > If yes, then repeat the two SELECTs and DELETE PS.  If no, then your
> system
> > is sorting unprintable characters differently than mine is, and you will
> > have to play with the selection process in order to get the right record
> > selected prior to deleting it.

>


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV command failing mystery

[Vance Dailey]

We upgraded our system from a 16 processor AV2 to an 8 processor
AV25000. Because each block of 4 cpus can only support 4gb of memory our
upgrade was going to cut our memory in half. So, the main purpose of the
changes was to cut the memory requirements of the universe lock tables. And
in fact we successfully cut the per user memory usage in half. The other
changes were made as part of the overall review of both uv.config and the
kernel parameters prior to the upgrade.

Because several people suggested that the semaphore and/or shared memory
changes could be the cause of the problem I had them changed back to their
original values yesterday. So far we have not had a failure, but its a
little too soon to celebrate.

Thanks for the advice on using the trace. I was not able to pick out the
system calls and before I make another attempt I think I will wait and see
if the weekends changes fixed the problem. If the problem is solved I will
post in case someone else runs in the same problem in the future.
Thanks,
Vance Dailey

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ken Wallis
Sent: Sunday, February 08, 2004 7:52 PM
To: 'U2 Users Discussion List'
Subject: RE: UV command failing mystery


>From: Vance Dailey

>It was suggested that I try to run dg_strace. I ran it on one
>of the failing
>uv processes. It generated a 1mb file. I can see where it
>executes "uvsh"
>and It fails just after the 7th occurance of "RUN APP.PROGS
>PACKAGE.INS".
>(The 7th run is just after the string
>"SPECIAL.EDITOR.SELECT.DATA\OLONG".) I
>have no idea how to read this file but I thought it might help identify
>where the error occurred. I have included the very end of the output of
>dg_strace below:
>
...
>close(3)= 0
>sigaction_svr3(SIGQUIT, {...}, {...})   = 1253
>sigaction_svr3(SIGNULL, {...}, {0xc0a0d, [XCPU XFSZ],
>SA_RESTART|SA_SIGINFO}) = 2130681856
...

This tool seems to be showing you the system calls that uvsh is making and
the values returned from them (the bit after the "=").  The section you have
shown is simply the program trying to tidy up and exit after detecting
something it didn't like.  You'll need to look higher up in the output for a
system call which seems to return an error code.  Unfortunately, you need to
know what sort of system calls should return 0 all the time and which ones
regularly return other values.  I think I'd be looking at calls to sem...()
or shm...() functions that return non-zero and then using errmsg (if DG/UX
has that, or vi-ing /usr/include/sys/errno.h if it doesn't) to see what the
error numbers returned mean and man to interpret from that where the problem
lies.

I can't remember the exact numbers you quoted earlier, but certainly with
your user counts I'd be very suspicious of the reductions you made to the
semaphore kernel parameters.  Just as a matter of interest, why were these
reductions made?

HTH,

Ken


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: InValid Characters - shameless plug...

[Bryan Thorell]

If you're on universe you could use the Universe File manager, just 
click on the item with the weird characters and press delete..

Bryan Thorell

Brutzman, Bill wrote:

Following the comments from Susan and Dave, the following worked...

 

SELECT PS WITH @ID < 1
   

2 records selected... 

 

DELETE PS
   

Thanks...

--Bill

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Susan Lynch
Sent: Friday, February 06, 2004 6:51 PM
To: U2 Users Discussion List
Subject: Re: InValid Characters
Bill,

Not sure whether you are on UV or UD, so I will avoid using the EDIT-LIST
command (which UD does not have).  Given that restriction, probably the
easiest method would be to
SELECT PS = "[101393" BY-DSND @ID
(assuming that @id is left-justified)
If only 1 item selected, DELETE PS

If more than 1 item selected, SELECT PS SAMPLE 1, then LIST PS to be sure
that the one selected is the one with the unusual characters in the key.
If yes, then repeat the two SELECTs and DELETE PS.  If no, then your system
is sorting unprintable characters differently than mine is, and you will
have to play with the selection process in order to get the right record
selected prior to deleting it.
Susan M. Lynch
F.W. Davison & Company, Inc.


- Original Message -
From: "Brutzman, Bill" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 5:49 PM
Subject: InValid Characters


When I issue the following LIST command, there is are apparent bad
characters, ascii box drawing characters.
How can I clear them ?  The two characters show up a single "box" below.

Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit
Up-Arrow mode, or UV.VI.
I tried the ascii equivalents of the box characters per...

  >DELETE PS ^210^201
  Record ID "^210^201" not found.
  0 records DELETEd.
  >DELETE PS ^210
  Record ID "^210" not found.
  The records for @ID 103662 and 101393 appear to be clean.
  >DELETE PS ^D2
  Record ID "^D2" not found.
  0 records DELETEd.
  >DELETE PS ^D2^C9
  Record ID "^D2^C9" not found.
  0 records DELETEd.
Suggestions would be appreciated.

--Bill

---

LIST PS

D.PS..

103662
   101393
101312


D.PS. 103662
NEXT.COMP.PN.
PREV.COMP.PN. 103661
QTY.PER.ASSY.
TYPE.
SCRAP.FACTOR.
LEAD.TIME.OFFSET.
OPERATION
EFFECTIVE.DATE...
EFFECTIVE.CODE...
ENG.CHG.ID...
DATE.ADDED...
NWU.PN...
PWU.PN...
BALýNBR..
REFERENCEýDESIGNATORS.
NOTEýREFERENCE...
ECO DATE.
D.PS.  NEXT.COMP.PN.
PREV.COMP.PN.
QTY.PER.ASSY.
TYPE.
SCRAP.FACTOR.
LEAD.TIME.OFFSET.
OPERATION
EFFECTIVE.DATE...
EFFECTIVE.CODE...
ENG.CHG.ID...
DATE.ADDED...
NWU.PN...
PWU.PN...
BALýNBR..
REFERENCEýDESIGNATORS.
NOTEýREFERENCE...
ECO DATE.
D.PS. 101393
NEXT.COMP.PN.
PREV.COMP.PN. 103626
QTY.PER.ASSY.
TYPE.
SCRAP.FACTOR.
LEAD.TIME.OFFSET.
OPERATION
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


 

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Wintegrate message box

[Bryan Thorell]

You could do it if your application has a single piece of code that 
handles the input of data, in this area you could have it loop and check 
for a message that needed to pop up when not getting characters.  You 
may also be able to tap into the windows messenger service to send 
messages to users (on windows platforms).

-- Bryan

Charlie Rubeor wrote:

Does anybody know if it is possible to send a wintegrate pop-up box to a
different user, from either a unibasic program or a shell script?
Specifically, if Fred is trying to access a record, which is locked by
Barney, is it possible to have a pop-up box appear on Barney's screen?
Currently, we send an email to Barney, which does not work well if Barney
does not have his email client open.
This is just one example.  Our users are currently thinking up several more
applications where they would like to do this, if it is possible.
tia

Charlie Rubeor
Unix/Database Admin
The Wiremold Company
800.338.1315 x3498
860.523.3690 fax
 

À votre service

   

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Standard Deviation

[David T. Meeks]

This should work...

Key  note that this takes into account 'bias'.  Bias is basically defined 
to be used to determine
whether the input set is complete or a sampling, and has to do with the 
accuracy of the information.
If the input set is a complete list of values (a popluation), set Bias = 
0.  If it is a sample from a
larger set, set it to Bias = 1.

;* 
;*  FUNCTION STDDEV ( Values, Bias )
;*  Values - DynArray of values to use
;*  Bias - value determining if this is a
;*  sampling, or full set
;*
;*  - Calculates standard deviation from a set
;*  of values.  Returns the standard deviation
;*
;*  Written by Dave Meeks, February 2004
;* 
FUNCTION STDDEV( Values, Bias )
;* Error checking, just assure we have either 0 or 1
IF Bias NE 0 THEN
Bias = 1
END
;* Get sum and mean
NumValues = DCOUNT( Values, @FM )
SumValues = SUM( Values )
Mean  = SumValues/NumValues
Variance  = 0
;* get variance
FOR I = 1 TO NumValues
Variance = Variance + PWR(Values-Mean,2)
NEXT I
;* get standard deviation
StdDev = SQRT( Variance / ( NumValues - Bias ) )
RETURN( StdDev )
END


At 08:35 AM 2/9/2004 -0500, you wrote:
Is there a Universe Basic command to calculate standard deviation?  If not,
does anyone have a sub?

David T. Meeks || "All my life I'm taken by surprise
Architect, Technology Office   ||  I'm someone's waste of time
Ascential Software ||  Now I walk a balanced line
[EMAIL PROTECTED]   ||  and step into tomorrow" - IQ

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Joseph Baker/Columbus/IBM is out of the office.

[Joseph Baker]

I will be out of the office starting February 9, 2004 and will not return
until February 10, 2004.

I will be out of the office February 9.  Please leave me a voice mail
message at (614) 659-7457 if your message is urgent.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Standard Deviation

[Ray Buchner]

Is there a Universe Basic command to calculate standard deviation?  If not,
does anyone have a sub?
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: uvsql

[Barry Rogen]

a. yes  b. no  c. yes and no   d. yes

Barry Rogen
Senior Programmer
PNY  Technologies
(973) 515 - 9700  ext 5327
[EMAIL PROTECTED]
_
The quality of a person's life is in direct
proportion to their commitment to excellence
regardless of their chosen field of endeavor
   vince lombardi
_

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Brian Leach
Sent: Sunday, February 08, 2004 8:53 AM
To: 'U2 Users Discussion List'
Subject: RE: uvsql

Barry,

Just to eliminate the obvious:
A) is your file pointer correct in the uvsql account?
B) are there any indexes on the file that may be looking at the wrong
location?
C) are the DATA.30 and OVER.30 files set up with the same permissions?
Is
there any chance you might not be seeing the OVER.30? 
D) your UNIX cp included the .Type30 file.

Brian Leach 


- Original Message -
From: "Barry Rogen" <[EMAIL PROTECTED]>
Date: Fri, 6 Feb 2004 07:59:32 -0500
To: <[EMAIL PROTECTED]>
Subject: uvsql

> 
>Question...
> 
>I have a file, my live ORDER (type 30) file. Via unix, I copy 
> this file to my test account - copy is fine, all records there - no 
> problem
> 
>If I take that same file, and move it to my uvsql account, all 
> I get is a fraction of the file. I have tried this twice and got same 
> results.
> 
>   Any ideas why this occurs and how I can get this file into the 
> uvsql directory/account  intact ?
> 
>All comments appreciated,
> 
> Barry Rogen
> Senior Programmer
> PNY  Technologies
> (973) 515 - 9700  ext 5327
> [EMAIL PROTECTED]
> _
> The quality of a person's life is in direct proportion to their 
> commitment to excellence regardless of their chosen field of endeavor
>vince lombardi 
> _
> 
> 



This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.

DISCLAIMER

This email and any attachments are confidential and may also be
privileged.

If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.

In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]

Microgen Information Management Solutions
http://www.microgen.co.uk
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

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
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: uvsql

[Barry Rogen]

 I was trying to avoid the UniVerse level of copy - since
 the file in question has over a million records. I was
 trying in Unix (cp) to take advantage of the speed I would
 realize. The ULIMIT is set to 128000

Barry Rogen
Senior Programmer
PNY  Technologies
(973) 515 - 9700  ext 5327
[EMAIL PROTECTED]
_
The quality of a person's life is in direct
proportion to their commitment to excellence
regardless of their chosen field of endeavor
   vince lombardi
_

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ray Wurlod
Sent: Saturday, February 07, 2004 5:26 PM
To: U2 Users Discussion List
Subject: Re: uvsql

What kind of UNIX, and what cp options are you using?
Clearly if you're getting some of the file there permissions aren't an
issue, but is the file system where your uvsql is filling or is there a
quota or are you reaching your ulimit setting (maximum size of a UNIX
file that you can create)?  The uv command - among other things - raises
ulimit; if you're not working within the UniVerse environment maybe your
ulimit setting is too low.  Use the ulimit command to find out.

What happens if you create the UniVerse file in your uvsql account, and
use a UniVerse COPY command?

- Original Message -
From: "Barry Rogen" <[EMAIL PROTECTED]>
Date: Fri, 6 Feb 2004 07:59:32 -0500
To: <[EMAIL PROTECTED]>
Subject: uvsql

> 
>Question...
> 
>I have a file, my live ORDER (type 30) file. Via unix, I copy 
> this file to my test account - copy is fine, all records there - no
> problem
> 
>If I take that same file, and move it to my uvsql account,
> all I get is a fraction of the file. I have tried this twice and
> got same results.
> 
>   Any ideas why this occurs and how I can get this file into the
> uvsql directory/account  intact ?
> 
>All comments appreciated,
> 
> Barry Rogen
> Senior Programmer
> PNY  Technologies
> (973) 515 - 9700  ext 5327
> [EMAIL PROTECTED]
> _
> The quality of a person's life is in direct
> proportion to their commitment to excellence
> regardless of their chosen field of endeavor
>vince lombardi
> _
> 
> 
> 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
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV secondary index

[Anthony Youngman]

Two tricks to speed things up ...

Firstly, would the NO.NULLS keyword speed things up? I'm guessing your
fields can often be blank, and in this case you will have a single huge
record knocking your index for six!

Secondly, would the pause and resume indexing commands work? During the
day, while the users are working, you pause index updates. At the end of
the day (or whenever you need to run the reports) you resume indexing.
Okay, it'll knacker the system while it sorts out the indices, but it'll
be one short, concentrated hit. The you run your reports, disable
indexing again, and let the users at it ...

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]
Sent: 09 February 2004 09:23
To: [EMAIL PROTECTED]
Subject: UV secondary index

Hello,

I have distributed UV file with total size about 2.5Gb.
I made secondary index
CREATE. INDEX file field1 ... field6
BUILD.INDEX file field1 ... field6

After that, rows inserting takes very long time.
(4000 rows. Server so busy, that other users can't do anything.
If I removed index then inserting process is OK, but I need this
index for reporting)
Is it normal in UniVerse? 
How to avoid this problem?
I use UniVerse 9.5.2 on AIX 5.2

Thanks,
Margus Kandelin
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users




***

This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.

***

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

UV secondary index

[Margus.Kandelin]

Hello,

I have distributed UV file with total size about 2.5Gb.
I made secondary index
CREATE. INDEX file field1 ... field6
BUILD.INDEX file field1 ... field6

After that, rows inserting takes very long time.
(4000 rows. Server so busy, that other users can't do anything.
If I removed index then inserting process is OK, but I need this
index for reporting)
Is it normal in UniVerse? 
How to avoid this problem?
I use UniVerse 9.5.2 on AIX 5.2

Thanks,
Margus Kandelin
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: InValid Characters

[Bob Witney]

select the file
save the list
create a work file
edit the list
delete the invalid keys from the list
save the list
get the list 
copy file 1 to work file
clear file 1
copy workl to file1 all

if i understood the problem

bob

-Original Message-
From: Brutzman, Bill [mailto:[EMAIL PROTECTED]
Sent: 06 February 2004 22:50
To: 'U2 Users Discussion List'
Subject: InValid Characters



When I issue the following LIST command, there is are apparent bad
characters, ascii box drawing characters.

How can I clear them ?  The two characters show up a single "box" below.

Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit
Up-Arrow mode, or UV.VI.  

I tried the ascii equivalents of the box characters per...

   >DELETE PS ^210^201
   Record ID "^210^201" not found.
   0 records DELETEd.

   >DELETE PS ^210
   Record ID "^210" not found.
   The records for @ID 103662 and 101393 appear to be clean.

   >DELETE PS ^D2
   Record ID "^D2" not found.
   0 records DELETEd.

   >DELETE PS ^D2^C9
   Record ID "^D2^C9" not found.
   0 records DELETEd.

Suggestions would be appreciated.

--Bill

---

LIST PS 

D.PS.. 

103662
   101393
101312




D.PS. 103662
NEXT.COMP.PN.
PREV.COMP.PN. 103661
QTY.PER.ASSY.
TYPE.
SCRAP.FACTOR.
LEAD.TIME.OFFSET.
OPERATION
EFFECTIVE.DATE...
EFFECTIVE.CODE...
ENG.CHG.ID...
DATE.ADDED...
NWU.PN...
PWU.PN...
BALýNBR..
REFERENCEýDESIGNATORS.
NOTEýREFERENCE...
ECO DATE.

D.PS.  NEXT.COMP.PN.
PREV.COMP.PN.
QTY.PER.ASSY.
TYPE.
SCRAP.FACTOR.
LEAD.TIME.OFFSET.
OPERATION
EFFECTIVE.DATE...
EFFECTIVE.CODE...
ENG.CHG.ID...
DATE.ADDED...
NWU.PN...
PWU.PN...
BALýNBR..
REFERENCEýDESIGNATORS.
NOTEýREFERENCE...
ECO DATE.

D.PS. 101393
NEXT.COMP.PN.
PREV.COMP.PN. 103626
QTY.PER.ASSY.
TYPE.
SCRAP.FACTOR.
LEAD.TIME.OFFSET.
OPERATION
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com


Confidentiality Notice: This e-mail and any attachments are 
intended solely for the addressee and may contain confidential or 
privileged information. If you are not the named addressee, or the 
person responsible for delivering the message to the named 
addressee, please notify the sender as soon as possible and delete 
the material from your computer. This message will be protected by 
copyright. If it has come to you in error, you must not take any 
action based on its contents nor must you copy or show the message 
to any person other than the intended recipient.



This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users