RE: Unidata, Monitoring system parameters

2004-02-20 Thread Tony Gravagno
At the risk of making announcements too soon, I'm working on a tool right
now that will do this sort of monitoring for MV environments - in
collaboration with or instead of products like DPMonitor.  A VAR or IT staff
can automatically monitor remote client systems for OS, DBMS, or Application
issues, and get notifications when action is required.  This allows support
providers to be more pro-active, and adds new levels of service options for
everyone.  Another feature will allow system updates along the lines of
Symantec LiveUpdate or RedHat Network Management, and other forms of remote
maintenance to eliminate the need for people to manually update hundreds of
systems.  There's a LOT more being built into this but it's too early to go
into detail at this time.

E-mail inquiries are welcome, especially from people who feel the pain of
supporting a large number of sites.

Tony
Nebula R&D
[EMAIL PROTECTED]
(Moderatoring presentations at Spectrum in Las Vegas - See you there!)


>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson
>Sent: Friday, February 20, 2004 5:25 PM
>To: [EMAIL PROTECTED]
>Cc: Alan Billing
>Subject: RE: Unidata, Monitoring system parameters
>
>
>Date: Thu, 19 Feb 2004 18:50:24 +1100
>From: "Ken Wallis" <[EMAIL PROTECTED]>
>Subject: RE: Unidata, Monitoring system parameters
>
>> James Hogan wrote:
 From time to time we have customers who break a Unidata
>>> parameter and the
>>> program they are running will crash with errors such as "No more 
>>> entries in MI table in 'LCT -n'".
>
>>[snip]
>
>>> I have had a look at the commands "sms", "gstt" and "lstt". 
>With some 
>>> clever scripting these could be used to take snap shots of the
>>> system periodically
>>> to check for an over step of the parameters. The script could
>>> then warn the user if any parameter is over 80% utilised.
>
>:>I doubt it could warn them in time James.  When programs go 
>wild and eat smm
>>resources they tend to do it in a big hurry.
>
>>With decent tuning you should be able to find a reasonable compromise 
>>between making lots of memory available for big jobs without 
>lumbering 
>>little jobs with a huge footprint.  Even on AIX now there are some 
>>extended shared memory facilities which allow you to have 
>more segments 
>>instead of just making them all huge!  I can't remember the exact 
>>details but EXTSHM rings a bell.
>>
>>Cheers,
>>Ken
>
>Hello James Hogan,of Sungard and Ken Wallis,
>
>I have been getting the U2 Users Daily Digest for a for weeks 
>now, after getting individual emails for the longest time. I 
>just caught this thread, and had to get in on this. 
>
>What James Hogan wants to accomplish can be done. 
>There are products out there such as the DPMonitor that do 
>exactly that.
>
>There are several key factors though:
>1) Situations like that require constant monitoring, and 
>mapping out of platform operational dynamics, and knowing the 
>behaviors that occur when things "start to go wrong".
>
>2) The Monitor needs to be external to the application server 
>being monitored. You need a real low overhaed process (Agent) 
>on the Application Server doing low level kernel calls, 
>consistently, over time, and establish what the operational 
>baseline characteristics of the application are in "normal" 
>mode. A real key is having that Agent talking to an 
>"Operations Console" Performance Explorer and Alert Center, 
>and having Probes, or Alarms set up, to notify Operations in 
>things get out of whack, and therefore allow corrective action 
>to take place before the application server or process gets 
>"hung". Imagine that - a proactive response as compared to a 
>reactive response.
>
>3) You can't run such standard system 
>commands/programs/utilities, especially ones on the 
>application server being monitored, as they consume 
>significant volumes of resources, and contribute to the 
>problem, if they ever report back to you, (such as Ken mentions).
>
>So, what do you do? Reinvent the wheel with some configuration 
>of scripts?
>
>The smart choice is to download and evaluate the DPMonitor 
>Performance Monitoring Solution. The licensed version will 
>monitor individual, user-selected processes, in addition to 
>the system wide parameters and metrics. You can set up Probes 
>to test and watch for certian conditions or thresholds to be 
>crossed, and then take pro-active, pre-programmed by the user 
>responses to those situations, or simply generate an email, a 
>page, or what have you.
>
>DPMonitor has Performance Agents for AIX, Solaris, and 
>Windows. Even an Oracle Agent. U2 Products and applications 
>can be monitored via individual per process monitoring. One 
>Performance Explorer can display Agent data from all Agents, 
>for centralized Enterprise, or ASP providers. Very easily 
>installed and set up, and provides dynamic scaling, colorful, 
>detail graphs of the health and resource level consumption of 
>the application

RE: Unidata, Monitoring system parameters

2004-02-20 Thread Scott Richardson
Date: Thu, 19 Feb 2004 18:50:24 +1100
From: "Ken Wallis" <[EMAIL PROTECTED]>
Subject: RE: Unidata, Monitoring system parameters

> James Hogan wrote:
>>> From time to time we have customers who break a Unidata
>> parameter and the
>> program they are running will crash with errors such as "No
>> more entries in
>> MI table in 'LCT -n'".

>[snip]

>> I have had a look at the commands "sms", "gstt" and "lstt".
>> With some clever
>> scripting these could be used to take snap shots of the
>> system periodically
>> to check for an over step of the parameters. The script could
>> then warn the user if any parameter is over 80% utilised.

:>I doubt it could warn them in time James.  When programs go wild and eat smm
>resources they tend to do it in a big hurry.

>With decent tuning you should be able to find a reasonable compromise
>between making lots of memory available for big jobs without lumbering
>little jobs with a huge footprint.  Even on AIX now there are some extended
>shared memory facilities which allow you to have more segments instead of
>just making them all huge!  I can't remember the exact details but EXTSHM
>rings a bell.
>
>Cheers,
>Ken

Hello James Hogan,of Sungard and Ken Wallis,

I have been getting the U2 Users Daily Digest for a for weeks now, after getting 
individual emails for the longest time. I just caught this thread, and had to get in 
on this. 

What James Hogan wants to accomplish can be done. 
There are products out there such as the DPMonitor that do exactly that.

There are several key factors though:
1) Situations like that require constant monitoring, and mapping out of platform 
operational dynamics, and knowing the behaviors that occur when things "start to go 
wrong".

2) The Monitor needs to be external to the application server being monitored. You 
need a real low overhaed process (Agent) on the Application Server doing low level 
kernel calls, consistently, over time, and establish what the operational baseline 
characteristics of the application are in "normal" mode. A real key is having that 
Agent talking to an "Operations Console" Performance Explorer and Alert Center, and 
having Probes, or Alarms set up, to notify Operations in things get out of whack, and 
therefore allow corrective action to take place before the application server or 
process gets "hung". Imagine that - a proactive response as compared to a reactive 
response.

3) You can't run such standard system commands/programs/utilities, especially ones on 
the application server being monitored, as they consume significant volumes of 
resources, and contribute to the problem, if they ever report back to you, (such as 
Ken mentions).

So, what do you do? Reinvent the wheel with some configuration of scripts?

The smart choice is to download and evaluate the DPMonitor Performance Monitoring 
Solution. The licensed version will monitor individual, user-selected processes, in 
addition to the system wide parameters and metrics. You can set up Probes to test and 
watch for certian conditions or thresholds to be crossed, and then take pro-active, 
pre-programmed by the user responses to those situations, or simply generate an email, 
a page, or what have you.

DPMonitor has Performance Agents for AIX, Solaris, and Windows. Even an Oracle Agent. 
U2 Products and applications can be monitored via individual per process monitoring. 
One Performance Explorer can display Agent data from all Agents, for centralized 
Enterprise, or ASP providers. Very easily installed and set up, and provides dynamic 
scaling, colorful, detail graphs of the health and resource level consumption of the 
application server platform, history of resource consumption, aggregation, and 
user-selectable timeframe periods for display. Dial right into problems situations 
quickly and easily and understand exactly what is going on, when it happens, and what 
ripple affects it causes in paltform operational dymanics. Real easy to solve the 
problems if you have a clear roadmap. DPMonitor provides that roadmap, at reasonable 
pricing.

Check out the significantly updated www.deltek.us websoyte for product information and 
examples of how the DPMonitor could be easily & quickly setup to provide exactly the 
type of application server monitoring James at Sungard was asking about.

Regards,
Scott Richardson
Senior Systems Engineer / Consultant
Marlborough, MA 01752
Email: [EMAIL PROTECTED]
Web: http://home.comcast.net/~CheetahFTL/CC
eFax: 208-445-1259
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: wIntegrate Lookup Box

2004-02-20 Thread Ian Renfrew
If I remember correctly, wIntegrate 3.? is a 16 bit Windows application.
Your probably hitting a 16 bit limitation. Strongly suggest upgrading with
wIntegrate 4.? or higher which is 32 bit application. I encountered a
similiar issue with setting up a menuing system with over 2000 menu options.
Upgrading resolved my issue.

Regards,  Ian Renfrew

- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 20, 2004 10:26 AM
Subject: wIntegrate Lookup Box


> All,
>
> I am a little green with using wintegrate so please bear with me.  I am
trying to populate a lookup box with a list using WIN.LOOKUP on V3.0.7.  I
get a script error if the list is too big for the box it appears.
>
> Any thoughts would be appreciated.
>
> Thanks,
> Les
> -- 
> 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: UniData 6.0.b Clients - now on PE download site

2004-02-20 Thread James Canale, Jr.
Does anyone have a list of the new features or bug fixes for 6.0b?  It seems
that each individual product (UniDK, UniAdmin, etc.) each has its own
version number so it doesn't really specify what has changed from 6.0.
Thanks.

Regards,

Jim


>>I had the current clients posted on the PE site to replace the original
6.0
>>clients.



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


Damaged UniData files

2004-02-20 Thread Wally Terhune





John Cassidy wrote:
We crashed last Friday, 02/13/04 (it would be on Friday the 13th!), and a
subsequent series of `guide`s (wufa) indicated that I had 22 damaged
UniData files. I was able to `fixfile` about half of them; the other half
had group errors, such as:

"Group 65056, block 65057 has incorrect group number 0".

This indicates that the OS has layed a block of ascii 0s into the middle of
your UniData file. There isn't anything there for any UniData utility to
recover (in that group). The group structure has been destroyed as well as
the data.

Starting in UniData 6.0, you can use a single command to restore the group
structure to that group - (no data, of course) - and then access the rest
of the file normally - assuming all of the other groups are intact.

$UDTBIN/fileview -g65056 -zv STUDENT.ACAD.LEVELS (in this
example)
-g group number
-z zero/zap
-v verify (prompt - are you sure you want to zero the group)

Prior to 6.0, you could use a series of fileview commands to poke a number
of bits into the block to make the  group OK. This is documented in the
white paper that Colin refers to (subsequent email on this thread). This
paper has been around for a couple of years - included on prior versions of
the survival kit cd. I've lectured on this at the last two (or three)
IBM/Informix technical conferences also.

Wally Terhune
Manager - U2 Advanced Technical Support
IBM Data Management Solutions
Tel: 303.294.4866 Fax: 303.294.4832
[EMAIL PROTECTED]
www.ibm.com/software/data/u2/support - Open, Query, Update, Search -
Online!--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: [UV] BSCAN error accessing Distributed Files with Indexes

2004-02-20 Thread Glenn Herbert
BSCAN (last I knew) does not work with Distrbuted File indexes.  You can 
only use BSCAN on the parts, not the whole.   It was something that never 
got implemented when I wrote BSCAN due to the merge complexities of the 
index files and it was never marked as important enough to implement by the 
higher-ups at the time.

At 03:40 PM 02/20/2004, you wrote:

We have converted a file from a Static Hashed file to a Distributed File
with 3 Parts:
  POLICY -->  POLICY.PART1
  POLICY.PART2
  POLICY.PART3
Each Part File points back to the D_POLICY file for its Dictionary in order
to reduce the overhead of maintaining 4 seperate DICT's
We built indexes on the POLICY file using CREATE.INDEX and BUILD.INDEX.
The Indexes were created as:
  I_POLICY.PART1
  I_POLICY.PART2
  I_POLICY.PART3
These Indexes work fine through Retrieve and Basic, however, when testing
code that uses the BSCAN function with the USING clause, it fails with an
error code 3, stating there are no secondary indices on the file.
Has anyone experienced this, or set up this scenario before?  I'm thinking
there is a compatibility issue with BSCAN and Indexes on a Distributed
File.
Thanks for you help!

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


[UV] BSCAN error accessing Distributed Files with Indexes

2004-02-20 Thread gcanedy

We have converted a file from a Static Hashed file to a Distributed File
with 3 Parts:

  POLICY -->  POLICY.PART1
  POLICY.PART2
  POLICY.PART3

Each Part File points back to the D_POLICY file for its Dictionary in order
to reduce the overhead of maintaining 4 seperate DICT's

We built indexes on the POLICY file using CREATE.INDEX and BUILD.INDEX.
The Indexes were created as:

  I_POLICY.PART1
  I_POLICY.PART2
  I_POLICY.PART3

These Indexes work fine through Retrieve and Basic, however, when testing
code that uses the BSCAN function with the USING clause, it fails with an
error code 3, stating there are no secondary indices on the file.

Has anyone experienced this, or set up this scenario before?  I'm thinking
there is a compatibility issue with BSCAN and Indexes on a Distributed
File.

Thanks for you help!

- 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


RE: Damaged files

2004-02-20 Thread alfkec
John;

There are a couple of tools for file repair that I miss from D3. The good
thing is I don't have to worry about it much :-).

1. Yes, I at least hope you wrote a program to do that all for you.
Generally, I copy the file at the OS level (after making sure no one will
access it etc). I then try to resize the file. It will often times clean up
this kind of stuff. It pretty much just copies the items out and back in.
There is also a File Fixing document on the U2 TechSupport Survival CD. It
provides a lot of techniques for fixing file corruption.

2. If the file is damaged in certain ways I've had these fail. Yes, it's
very annoying.

3. RECORD filename ID will list everything in the group that the ID hashes
to. I've only found dumpgroup to give the items in a group - so if you don't
have a key that hashes to that group you're in for the hunt-and-peck method.
Perhaps the fileview utility would help here - I haven't had the time to go
work with it much.

4. The file fixing documentation on the Tech Survival CD has some good
advice. I don't know if any of the UD courses go into the file structure.

hth
-- 
Colin Alfke
Calgary, Alberta Canada

"Just because something isn't broken doesn't mean that you can't fix it"

Stu Pickles


>-Original Message-
>From: John Cassidy [mailto:[EMAIL PROTECTED]
[snip]

>1. I'm sorry, but this was the best I could come up with after 
>many hours. Please tell me there's a better way.
>2. Why did dumpgroup/fixgroup fail? Isn't this what they're 
>designed to do?
>3. Is there another way to extract the keys from a damaged 
>UniData file?
>4. Is there a white paper or available technical document 
>which describes, in some detail, the structure and layout of 
>UniData files, which would aid me in writing my own utilities?
> 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: recursive values

2004-02-20 Thread Jefferson, Jim

report

name... street ... city
Raven   1234   IRVINE
A STREET


Would like this
name... street ... city
Raven   1234   IRVINE
Raven   A STREET   IRVINE


BY.EXP STREET would separate your MV'd street field unacceptably.  A quick & dirty 
would be to create I-Types for your "name" and "city" fields, each of which would 
DCOUNT the values in "street" and construct a MV'd repeating list of the name/city 
with a matching number of values.  Make sure the new I-Types are defined as 
"M"ultivalued, and this should give you the output you are looking for.

Jim

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


RE: recursive values

2004-02-20 Thread José Luis Gutiérrez de la Peza
Did you tried with the REUSE en the dictionary ?


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En
nombre de Dave Raven
Enviado el: viernes, 20 de febrero de 2004 13:03
Para: [EMAIL PROTECTED]
Asunto: recursive values 



I am using Universe and am looking for a way to have recursive values in my
retrive report. I would like to export this report to a spreadsheet.

The pick command for a dictonary would be LPV (last previous value) and I
have tried TRANSPORT.

report

name... street ... city
Raven   1234   IRVINE
A STREET


Would like this
name... street ... city
Raven   1234   IRVINE
Raven   A STREET   IRVINE





Dave R

P.O. Box 17811, Irvine CA 92623-7811


-- 
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: recursive values

2004-02-20 Thread Dave Davis
You mean repeating values.  You have BY-EXP don't you?



From: [EMAIL PROTECTED] on behalf of Dave Raven
Sent: Fri 2/20/2004 2:03 PM
To: [EMAIL PROTECTED]
Subject: recursive values 





I am using Universe and am looking for a way to have recursive values in my retrive 
report. I would like to export this report to a spreadsheet.

The pick command for a dictonary would be LPV (last previous value) and I have tried 
TRANSPORT.

report

name... street ... city
Raven   1234   IRVINE
A STREET


Would like this
name... street ... city
Raven   1234   IRVINE
Raven   A STREET   IRVINE





Dave R

P.O. Box 17811, Irvine CA 92623-7811


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



Our company accepts no liability for the content of this email, or for the
consequences of any actions taken on the basis of the information
provided, unless that information is subsequently confirmed in writing.
Any views or opinions presented in this email are solely those of the 
author and do not necessarily represent those of the company.
WARNING: Computer viruses can be transmitted via email.
The recipient should check this email and any attachments for the 
presence of viruses. The company accepts no liability for any damage 
caused by any virus transmitted by this email.
11/29/2003 ACE Software, LLC

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


RE: recursive values

2004-02-20 Thread Peter Olson
is this one record or two records ?



Notice of Confidentiality:  The information included and/or attached in this
electronic mail transmission may contain confidential or privileged
information and is intended for the addressee.  Any unauthorized disclosure,
reproduction, distribution or the taking of action in reliance on the
contents of the information is prohibited.  If you believe that you have
received the message in error, please notify the sender by reply
transmission and delete the message without copying or disclosing it. 

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


recursive values

2004-02-20 Thread Dave Raven


I am using Universe and am looking for a way to have recursive values in my retrive 
report. I would like to export this report to a spreadsheet.

The pick command for a dictonary would be LPV (last previous value) and I have tried 
TRANSPORT.

report

name... street ... city
Raven   1234   IRVINE
A STREET


Would like this
name... street ... city
Raven   1234   IRVINE
Raven   A STREET   IRVINE





Dave R

P.O. Box 17811, Irvine CA 92623-7811


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


RE: UniVerse and Backup Exec

2004-02-20 Thread Gwen Buck
 

Excellent write up Tom.  This is a keeper email.

Thanks,

-Doug 


Yes, Tom.  The Windows SharedSection registry tweak write-up was great.
I apologize for neglecting to acknowledge it sooner!

Thank you,
Gwen Buck
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Damaged files

2004-02-20 Thread John Cassidy
We crashed last Friday, 02/13/04 (it would be on Friday the 13th!), and a subsequent 
series of `guide`s (wufa) indicated that I had 22 damaged UniData files. I was able to 
`fixfile` about half of them; the other half had group errors, such as:
 
"Group 65056, block 65057 has incorrect group number 0". 
 
When I try to run dumpgroup, I got:
1:blk check error in U_read_group for file 'STUDENT.ACAD.LEVELS', key '', number=65056
1:U_read_group error in dumpgroup for file 'STUDENT.ACAD.LEVELS', key '', number=1
 
When I made an attempt to clear the group, I got:
fixgroup STUDENT.ACAD.LEVELS 65056
Fixgroup STUDENT.ACAD.LEVELS 65056 will make group 65056 empty,
do you wish to do it ?  [y/n] y
No input file is specified.
Group 65056 will be cleared. Do you really want to proceed? (Y/N) y
1:blk check error in U_read_group for file 'STUDENT.ACAD.LEVELS', key '', number=65056
read error,errno=0.
 
Needless to say, the file remained unchanged.
The effect was that various LIST, SELECT, COUNT and FILE.STAT commands were 
terminated, as well as thier UniBasic equivilents, with similar errors.
All the damaged files were dynamic files.
We're running UniData 6.0.3 under Solaris 8.
 
I was able to recover, at least partially, by the incredibly kludgy and ugly (and time 
consuming) method of using dumpgroup to dump all the other groups, and then using the 
resulting file names as keys to build a savelist, which I then used to copy everything 
but the bad group. I then was able to construct a list of the missing @ID's by 
comparing the savedlist with one constucted from my backups. All the missing records 
hashed to the damaged group. Any new ones which may have caused the damage in the 
first place were lost.
 
1. I'm sorry, but this was the best I could come up with after many hours. Please tell 
me there's a better way.
2. Why did dumpgroup/fixgroup fail? Isn't this what they're designed to do?
3. Is there another way to extract the keys from a damaged UniData file?
4. Is there a white paper or available technical document which describes, in some 
detail, the structure and layout of UniData files, which would aid me in writing my 
own utilities?
 
Thanks for any help.
 
John Cassidy
Unix Sys Admin
DCCCD
 


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


Re: wIntegrate Lookup Box

2004-02-20 Thread Bryan Thorell
I think there is a 32k limit on the size of a variable in v3 of wIntegrate.

[EMAIL PROTECTED] wrote:

All,

I am a little green with using wintegrate so please bear with me.  I am trying to populate a lookup box with a list using WIN.LOOKUP on V3.0.7.  I get a script error if the list is too big for the box it appears.

Any thoughts would be appreciated.

Thanks,
Les
 

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


RE: Unicode for System Builder

2004-02-20 Thread Kevin King
Didn't we just see this same message from Bruce @ YCI (same company)?  You
might check w/ Bruce to see if he received any offline info.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of [EMAIL PROTECTED]
> Sent: Friday, February 20, 2004 9:32 AM
> To: [EMAIL PROTECTED]
> Subject: Unicode for System Builder
>
>
> Does anyone have knowledge or experience of using UniData double byte and
> SB+ to implement an application in Chinese?
> Does SB+ support Unicode?
> Thanks
>
>  <<...OLE_Obj...>>
>
> Tom Jobe
> Database Administration Group
> Yamanouchi Consumer, Inc.
> 4747 Willow Rd
> Pleasanton, CA 94588

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


Re: Unicode for System Builder

2004-02-20 Thread Peter Gonzalez
i'm looking for the same thing, but for straight Unidata code.

At 08:31 AM 2/20/04 -0800, you wrote:
Does anyone have knowledge or experience of using UniData double byte and
SB+ to implement an application in Chinese?
Does SB+ support Unicode?
Thanks
 <<...OLE_Obj...>>

Tom Jobe
Database Administration Group
Yamanouchi Consumer, Inc.
4747 Willow Rd
Pleasanton, CA 94588
Phone: (925) 924-2156
Fax:(925) 924-3660
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Thank you,

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


RE: UniVerse and Backup Exec

2004-02-20 Thread Doug Miller
At 11:34 AM 2/19/2004, Tom Firl wrote:
I didn't catch the nature of the errors, but the registry tweak may have 
to do with the Windows SharedSection parameter that relates to telnet 
service.
Excellent write up Tom.  This is a keeper email.

Thanks,

-Doug 

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


Unicode for System Builder

2004-02-20 Thread TJobe
Does anyone have knowledge or experience of using UniData double byte and
SB+ to implement an application in Chinese?
Does SB+ support Unicode?
Thanks

 <<...OLE_Obj...>> 

Tom Jobe
Database Administration Group
Yamanouchi Consumer, Inc.
4747 Willow Rd
Pleasanton, CA 94588
 
Phone: (925) 924-2156
Fax:(925) 924-3660

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


wIntegrate Lookup Box

2004-02-20 Thread lslingford
All,

I am a little green with using wintegrate so please bear with me.  I am trying to 
populate a lookup box with a list using WIN.LOOKUP on V3.0.7.  I get a script error if 
the list is too big for the box it appears.

Any thoughts would be appreciated.

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


RE: [OT] Looking for U2 owners in northern suburbs PA, USA

2004-02-20 Thread Daly, Mark
pickjobs.net

-Original Message-
From: Mark Johnson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 19, 2004 11:20 PM
To: U2 Users Discussion List
Subject: Re: [OT] Looking for U2 owners in northern suburbs PA, USA


go to pickjobs.com. there's one in wilkesbarre.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: uvbackup

2004-02-20 Thread Claus Derlien


Original Message-
From: Anthony Youngman [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 12:04 PM
To: U2 Users Discussion List
Subject: RE: uvbackup


>Replace the "file concatenate" symbol ">" with the pipe symbol "|", and
>then follow that directly with the gzip command.

>/usr/uv/bin/uvbackup -f -v -l "TEST" /data1/MEMBERSHIP/GM.MEDLE | gzip
>-9 > /backup/GM.MEDLE.gz


Thanks alot.
Made my day a lot more easier, im writing a wrapper to move selected data
from production to test
i guess its fairly safe to use uvrestore to restore to a live environment
(TEST machine)
anyway im back on track :-)

best regards from sunny but icecold denmark

Claus Derlien


Frie Funktionærer - faglig organisation og tværfaglig a-kasse - www.f-f.dk

***
Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der 
kun er beregnet for adressaten,
og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse 
modtaget denne email, bedes
De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak.
***
This email and any files transmitted with it may contain confidential information 
intended for the addressee(s) only.
The information is not to be surrendered or copied to unauthorised persons. If you 
have received this
communication in error, please notify us immediately by telephone: +45 6313 8550. 
Thank you.
***

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


RE: version control software (AD for PRC)

2004-02-20 Thread Claus Derlien
Susan Joslyn wrote:

>AD WARNING: Following is a blatant PRC brag and sales pitch thinly
disguised
>as a technical discussion of its approach. (But I will stick with the main
>technical differences ... unless you want more, then e.mail me!)

He he...  nvm the bad disguised shameless ad, your product looks cool, last
year we had the pleasure of being educated a bit in SB+ by Susan's sister,
and she also told us some good things about PRC :-)


If I have an 8 user developer machine running linux + uv 10.1
and a 75 user production machine running linux + uv 10.1 will PRC then be
able to deploy from
the test machine to the production machine ??

If its project oriented, can you use it to keep track on status for a
project like time used etc etc. ??
and when a project is finished can you write out all source code nicely on
paper and also make a report on all the changes ??
We could seriously use a product like that!

best regards from deepfreezing denmark

Claus Derlien


Frie Funktionærer - faglig organisation og tværfaglig a-kasse - www.f-f.dk

***
Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der 
kun er beregnet for adressaten,
og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse 
modtaget denne email, bedes
De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak.
***
This email and any files transmitted with it may contain confidential information 
intended for the addressee(s) only.
The information is not to be surrendered or copied to unauthorised persons. If you 
have received this
communication in error, please notify us immediately by telephone: +45 6313 8550. 
Thank you.
***

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


RE: uvbackup

2004-02-20 Thread Anthony Youngman
Replace the "file concatenate" symbol ">" with the pipe symbol "|", and
then follow that directly with the gzip command.

/usr/uv/bin/uvbackup -f -v -l "TEST" /data1/MEMBERSHIP/GM.MEDLE | gzip
-9 > /backup/GM.MEDLE.gz

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Claus Derlien
Sent: 20 February 2004 10:54
To: '[EMAIL PROTECTED]'
Subject: uvbackup

Hi,

Can anyone help me with the proper syntax for this problem :

I want to backup a single uv file (DYNAMIC) and compress it with gzip in
one
go, i have no problems doing it in two steps like this :
   
   /usr/uv/bin/uvbackup -f -v -l "TEST" /data1/MEMBERSHIP/GM.MEDLE >
/backup/GM.MEDLE
   gzip -9 /backup/GM.MEDLE

   this leaves me with GM.MEDLE.gz in /backup, very nicely

since uvbackup uses stdout
and gzip uses stdin it must somehow be possible to redirect gzip output
to
/backup/GM.MEDLE.gz

best regards from denmark

Claus Derlien
edb-afdelingen
direkte : 63 13 86 69
email   : [EMAIL PROTECTED]



***

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


uvbackup

2004-02-20 Thread Claus Derlien
Hi,

Can anyone help me with the proper syntax for this problem :

I want to backup a single uv file (DYNAMIC) and compress it with gzip in one
go, i have no problems doing it in two steps like this :
   
   /usr/uv/bin/uvbackup -f -v -l "TEST" /data1/MEMBERSHIP/GM.MEDLE >
/backup/GM.MEDLE
   gzip -9 /backup/GM.MEDLE

   this leaves me with GM.MEDLE.gz in /backup, very nicely

since uvbackup uses stdout
and gzip uses stdin it must somehow be possible to redirect gzip output to
/backup/GM.MEDLE.gz

best regards from denmark

Claus Derlien
edb-afdelingen
direkte : 63 13 86 69
email   : [EMAIL PROTECTED]


Frie Funktionærer - faglig organisation og tværfaglig a-kasse - www.f-f.dk

***
Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der 
kun er beregnet for adressaten,
og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse 
modtaget denne email, bedes
De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak.
***
This email and any files transmitted with it may contain confidential information 
intended for the addressee(s) only.
The information is not to be surrendered or copied to unauthorised persons. If you 
have received this
communication in error, please notify us immediately by telephone: +45 6313 8550. 
Thank you.
***

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


RE: version control software (AD for PRC)

2004-02-20 Thread Susan Joslyn
There've been a few people post about the way their company has wrapped a
unix or other outside 'change control tool'.  I think these are interesting
and I admire the "technicality" that goes into that approach.  And I
appreciate their sharing it, here.  But it stimulates in me a rather wild
and uncontrollable desire to express my differences in opinion and approach.
It's different when I do it, because this is what I do -- and I have a
product to sell.  Thus:

AD WARNING: Following is a blatant PRC brag and sales pitch thinly disguised
as a technical discussion of its approach. (But I will stick with the main
technical differences ... unless you want more, then e.mail me!)

PRC is a complete software configuration management tool -- including change
control / version control -- developed in and for the U2 environment.
Besides the obvious -- that it is a finished / supported product -- PRC
differs in some basic ways from other "mainstream" approaches.


* PRC is written in and for the U2 environment. 

* PRC is project-centric, as opposed to file-centric (or item-centric)
meaning the versioning is not so much against a specific file (program)
(although that detail is kept) but rather the collection of bits and pieces
of whatever (program, subroutine, process, paragraph, dictionary, Voc entry,
whatever) that comprise "the change".

* Backward regress-able versions of all changed items are stored -- in their
entirety. (And self-managed.)  No delta records, to apply in order to
'rebuild' ... you can pull up an old copy and look at it.  Or view it
against the current version with changes highlighted.

* There are tools and utilities so that the programmer -- not from a
management perspective but from a head-down/ coders / convenience
perspective -- WANTS and LIKES what PRC is doing.  This is key, along with
...
 
* Our #1 mission in the development of PRC was that there not be any 'extra'
task or step that must be remembered or could be (accidentally or otherwise)
forgotten.  With PRC you just work as usual -- the software is checked out,
reviewed against permissions, backed up and so forth AS YOU GO.  No extra
steps or checking required.

* There are clearances and procedures that can be put into place to handle
any "emergency" or "exception" without violating audit requirements.
* PRC supports he whole SCM /SDLC process from the problem report, through
management of the projects (in terms of assigning, scheduling, estimating,
tracking progress), the change control piece, test management, deployment
and provides a single repository for auditing and reporting.

I'll stop now.  Reluctantly.  :)

Susan Joslyn
SJ+ Systems Associates, Inc.
[EMAIL PROTECTED]
PRC(r) Real software configuration management for U2.


Message: 2
Date: Thu, 19 Feb 2004 09:53:22 -
From: "Brian Leach" <[EMAIL PROTECTED]>
Subject: RE: version control software
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain;   charset="us-ascii"

Jeff,

We use a two pronged attack - I don't think I can share it (sorry) but here
is what it does - none of it should be too difficult to emulate:

First we have some BASIC routines that stamp our programs with a string in
the format:

ADGVERDATA='Version=x;'
ADGVERDATA:= 'VerDate=xx;'
ADGVERDATA:='VerHist=xx' 
etc.

The format of the string means that we can search both source and object
code for version stamps (being a variable assignment not a comment they get
compiled into the object code string table). We have some simple subroutines
that return this version information which we can use e.g. from
I-Descriptors to list the versions and from setup routines to check
versions; and we have wrappers around our installation routines and checks
in the routine we use for any global cataloging to ensure that we don't
accidentally catalog an older routine over a newer version.

Secondly, we use RCS for delta-ing (we could use CVS but RCS was a simpler
option for interfacing). To allow it to handle non-source items (eg
dictionaries and parameter records) we wrapper the RCS routines (ci and co)
through some routines that essentially maintain an index of the UniVerse
location (ACCOUNT DICT FILE LEVEL ITEM) to a numbered UNIX file. These allow
allow us to things like accept select lists, so the whole thing is command
line driven and very flexible.

The routines maintain an index between our version stamps (which are 3 level
major.minor.build) and the RCS version (which is 2 level major.minor) so we
can search on either. We also apply tags in the index rather than using RCS
tags, which are a bit flaky.
 
The routines use the index to copy the item to a type 19 file using
sequentially assigned IDs, then commit the copy to RCS. The same index is
used to retrieve the item again, and optionally copy the item back to its
original location OR to a new location (another reason for using the index).

As most of our applications are client/server or 

RE: @SPAM+++++++++

2004-02-20 Thread Anthony Youngman
Doesn't time fly!

I can (just about) remember when 1c == 1d. That really DOES go back!

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neil Charrington
Sent: 20 February 2004 10:25
To: U2 Users Discussion List
Subject: RE: @SPAM+ 

Wol, that would be awfully long time ago - an exchange rate of 1.20 to the
pound (maybe around 1983ish).  For a long time it was at around 1.50 to the
pound ;-)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Anthony Youngman
Sent: 20 February 2004 09:32
To: U2 Users Discussion List
Subject: @SPAM+


$72 per user? That's CHEAP!

We pay IBM direct £60 per user. At current exchange rates, that's about
$110. In mitigation, though, sterling has been rising markedly of late - not
that long ago £60 would have been about $72.

Cheers,
Wol



***

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


RE: @SPAM+++++++++

2004-02-20 Thread Neil Charrington
Wol, that would be awfully long time ago - an exchange rate of 1.20 to the
pound (maybe around 1983ish).  For a long time it was at around 1.50 to the
pound ;-)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Anthony Youngman
Sent: 20 February 2004 09:32
To: U2 Users Discussion List
Subject: @SPAM+


$72 per user? That's CHEAP!

We pay IBM direct £60 per user. At current exchange rates, that's about
$110. In mitigation, though, sterling has been rising markedly of late - not
that long ago £60 would have been about $72.

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of jimmay h
Sent: 20 February 2004 00:05
To: [EMAIL PROTECTED]
Subject: [UV] How much do you pay for support each year?

Our VAR just sent our UniVerse support bill for next year.  We are running
UniVerse 10.0.0.1 on Windows 2000 Sever.
It is $72/user license.  With 60 licenses, that is $4320,  plus the windows
support at 865.00.

We used them for some support over the year, but mostly it was related to
their installation of UV on the server prior to shipping it to us.  We're
located on the west coast and their support was in the east coast of the US.
  So, sometimes their support was slow in responding.

They are not our software vendor, they just sold us the server and UniVerse.

What are my options?
Can we purchase support directly from IBM?

Any ideas?

_
Click, drag and drop. My MSN is the simple way to design your homepage.
http://click.atdmt.com/AVE/go/onm00200364ave/direct/01/

--
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
---
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: 06/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: 06/02/2004


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


RE: [UV] Very slow SQL query

2004-02-20 Thread Brian Leach
César,

So the problem is not joins or indices. So it must be somewhere else :-)

1. If you use a SORT command, is that as slow?

SORT CCMLIAL BY EMP BY ALBA BY NUMLIN WITH EMPABLA = "1*05236" PEDIDO REFART
DESART CANDIDAD CANTMODALB NOPAGE

2. If it is, what are these fields doing? Are they Data fields or I
Descriptors? Do any call BASIC subroutines, or do translates (TRANS or XLATE
functions?)

3. The obvious one - what is the file sizing like?

4. What does the BASIC program do that is different?

There should be no reason for this SQL command to be slow.

Brian Leach


> Hello,
> 
> 
> I have two files one has 300.000 records and another has 
> 200.000 records, I wante to make SQL Query whit the two files 
> and this takes bettewn 30 seconds and 1 minute to return the result.
> 
> However, I have a program with BASIC to obtime the same 
> result and it takes less than one second, I have heard that 
> other DB Systems like SQL Server, Oracle, etc... are very 
> fast with the SQL Query.
> 
> Is this posible or do have I made a mistake?
> 
> 
> Thanks
> 
> 
> César
> 



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: [UV] How much do you pay for support each year?

2004-02-20 Thread Anthony Youngman
$72 per user? That's CHEAP!

We pay IBM direct £60 per user. At current exchange rates, that's about $110. In 
mitigation, though, sterling has been rising markedly of late - not that long ago £60 
would have been about $72.

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jimmay h
Sent: 20 February 2004 00:05
To: [EMAIL PROTECTED]
Subject: [UV] How much do you pay for support each year?

Our VAR just sent our UniVerse support bill for next year.  We are running UniVerse 
10.0.0.1 on Windows 2000 Sever.
It is $72/user license.  With 60 licenses, that is $4320,  plus the windows support at 
865.00.

We used them for some support over the year, but mostly it was related to their 
installation of UV on the server prior to shipping it to us.  We're located on the 
west coast and their support was in the east coast of the US. 
  So, sometimes their support was slow in responding.

They are not our software vendor, they just sold us the server and UniVerse.

What are my options?
Can we purchase support directly from IBM?

Any ideas?

_
Click, drag and drop. My MSN is the simple way to design your homepage. 
http://click.atdmt.com/AVE/go/onm00200364ave/direct/01/

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


Re: [UV] paragraph labels

2004-02-20 Thread Martin Phillips
This is just plain, simple bad programming.  In a paragraph, jumping to an
undefined label terminates the paragraph.  It is totally unsafe to use this
as a nifty way to end because someone might later add the label for some
other meaning in the same paragraph.

In a Basic program, as one responder showed, you get a compilation error.

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

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


RE: [UV] Very slow SQL query

2004-02-20 Thread Cesar Riba
Hello Björn

I build the index  and the result is equal.

Tanks.



-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
nombre de Björn Eklund
Enviado el: jueves, 19 de febrero de 2004 17:41
Para: 'U2 Users Discussion List'
Asunto: SV: [UV] Very slow SQL query


Cesar,
You need to build the index also, try BUILD.INDEX  ALL
In Unidata that is.

Björn Eklund



-Ursprungligt meddelande-
Från: Cesar Riba [mailto:[EMAIL PROTECTED]
Skickat: den 19 februari 2004 17:24
Till: 'U2 Users Discussion List'
Ämne: RE: [UV] Very slow SQL query




-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
nombre de Brian Leach
Enviado el: jueves, 19 de febrero de 2004 16:22
Para: 'U2 Users Discussion List'
Asunto: RE: [UV] Very slow SQL query


César,

I think we will need more information to help you.

1. are you running the SQL query at TCL or through ODBC or OleDB?

  César: I running the SQL query at TCL



2. Can you give the command you are running please.

   Cesar: SELECT PEDIDO,REFART,DESART,CANTIDAD,CANTMODALB FROM GCMLIAL WHERE
EMPALBA = '1*05236' ORDER BY EMP, ALBA, NUMLIN;
   Cesar: SELECT PEDIDO, SUREF FROM GCMLIAL WHERE EMPALBA = '1*05236' GROUP
BY PEDIDO, SUREF;



3. Are there any indexes on the files? (LIST.INDEX filename ALL)

   Cesar: There aren't indexes on the files, I create index but the result
is the same.




Regards,

Brian Leach


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Cesar Riba
Sent: 19 February 2004 15:04
To: [EMAIL PROTECTED]
Subject: [UV] Very slow SQL query

Hello,


I have two files one has 300.000 records and another has 200.000
records, I wante to make SQL Query whit the two files and this takes bettewn
30 seconds and 1 minute to return the result.

However, I have a program with BASIC to obtime the same result and it
takes less than one second, I have heard that other DB Systems like SQL
Server, Oracle, etc... are very fast with the SQL Query.

Is this posible or do have I made a mistake?


Thanks


César

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

--
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] paragraph labels

2004-02-20 Thread Bob Witney


0001: IF @LOGNAME NE 'FRED' THEN GO OUT
: .X BAS
"BOB" filed in file "BP".
Executing the command "BASIC BP BOB".
Compiling: Source = 'BP/BOB', Object = 'BP.O/BOB'
*
Label 'OUT' not defined

1 Errors detected, No Object Code Produced

Are you sure there not an include somewhere and this is set up in a common
block ?

bob

-Original Message-
From: Barry Brevik [mailto:[EMAIL PROTECTED]
Sent: 19 February 2004 22:08
To: U2 list (E-mail)
Subject: [UV] paragraph labels


On UV versions 9.4.1.1d through 9.6.1.3 as far as I know...

We have a great many paragraphs (third party app) that contains a line like
this:

IF  THEN GO OUT

...however, there is no OUT: label in the paragraph. Somehow, this works. Is
"OUT" some kinda built-in label?

I'd like to know because I don't want to learn any bad habits .
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


This email has been scanned by the MessageLabs Email Security System.
For more information please 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 by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com

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


RE: The aforementioned and promised NAG about OVERQUOTING

2004-02-20 Thread Anthony Youngman
That assumes you have the ability to do it ...

At home (as you will have seen from newsgroup posts) I have a mail/news
client that does it properly. At work I'm stuck with OE and "corporate
standards".

NB. I was wondering why I hadn't seen the original post starting all
this. Now I know - there's a nagbot on the loose :-)

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ken Wallis
Sent: 19 February 2004 23:59
To: 'U2 Users Discussion List'
Subject: RE: The aforementioned and promised NAG about OVERQUOTING


There are options in Outlook under E-Mail Options where you can specify
not
to include the original text in any reply.  PLEASE, if you aren't going
to
trim the context, use that option, and simply post your reply
standalone.

Alternatively, there are two good freeware tools you can use which let
you
fix up the way OE and Outlook do quoting and attributions automatically
-
sadly though, they'll only do it on the way out, they won't fix stuff
other
people send you!

Here are the URLs:

Outlook Express: http://home.in.tum.de/~jain/software/oe-quotefix/
Outlook 2000+: http://home.in.tum.de/~jain/software/outlook-quotefix/

Cheers,

Ken



***

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