Can anyone shed light on which is better:
SSELECT MYFILE WITH FIELD1 = RED AND FIELD2 = BLUE
or
SSELECT MYFILE WITH FIELD1 = RED AND WITH FIELD2 = BLUE
Does it make a difference if one or both are indexed.
Thanks...
Jeffrey Lee
Senior Analyst/Programmer
IT Vision Australia Pty Ltd (ABN: 34
Dan,
I tried it and got zero for the NSELECT result - as it should be. I suspect you
have one or more VOC keys that have attribute marks, value marks or newlines in
them. This will affect your select list.
If you LIST the results of the SELECT I would expect there to be a couple of
errors.
(800-797-6275)
(F) 310-377-3550
(C) 310-561-5200
www.sysmarkinfo.com
- Original Message -
From: Jef Lee jef@itvision.com.au
To: u2-users@listserver.u2ug.org
Cc: Steven Tilden steven.til...@itvision.com.au; John Steer
john.st...@itvision.com.au; Glenn Summerfield
glenn.summerfi
Does anyone have the magic bullet? We have a UniVerse account that was backed
up using uvbackup on an AIX platform. We restored the account on to a Windows
platform and the sky fell in.
Firstly there was the 13 (14?) character naming boundary. File names record
names that were longer than
]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Friday, 14 November 2008 6:39 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SELECT-READNEXT That's odd
One of our programmers wrote this snippet:
FOR YY=1 TO DCOUNT(WORK.ITEM.REC17,VM)
LISTNUMBER=''
SQLCOMMAND
Loop. Assign it once prior to the FOR statement and the loop will
be faster.
MAX=DCOUNT(WORK.ITEM.REC17,VM)
FOR I=1 TO MAX
My 2 cents
Mark Johnson
- Original Message -
From: Jef Lee [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Friday, November 14, 2008 2:39 AM
Subject: [U2
One of our programmers wrote this snippet:
FOR YY=1 TO DCOUNT(WORK.ITEM.REC17,VM)
LISTNUMBER=''
SQLCOMMAND=''
UNISTATEMENT='SELECT BPM.WORKITEMS WITH A1=':WORK.ITEM.REC1:' AND
WITH A2=':WORK.ITEM.REC2:' AND WITH A17=':WORK.ITEM.REC17,YY:' AND
WITH A24#C AND WITH
Please disregard this email. I received no U2 emails overnight (Australia) and
this is just a test to ensure it's not the new virus scanner software.
Thanks for your patience.
Thanks very much for the wealth of knowledge available in this group.
Jeffrey Lee
Senior Analyst/Programmer
IT
Our 10.1.11 does the same. In fact:
A = One:@VM:Two
PRINT A11,1
PRINT A11,2
PRINT A21,2
Produces
One
Two
With the last line a blank output.
It seems strange in a way, but logical.
Jeffrey Lee
Senior Analyst/Programmer
IT Vision Australia Pty Ltd (ABN: 34 309 336 904)
PO Box 881,
Scott,
Change your Unix command to:-
EXECUTE SH -c 'test -e :FILENAME: echo yes || echo no' CAPTURING XXX
XXX will contain yes or no depending on whether the file exists. That is
subject to your access to the file and it parent folder tree. So no could
mean that the file cannot be seen by
David,
This will take time to settle to a time where it will function correctly. But
here is my suggestion -
Day 1 - save a SELECT list of _PH_ using the date of day 1 as part of the key.
Day 2-30 - do the same, but remove from list the contents of the previous day's
list
Day 31 - delete
So, Ray, where do I find these rules? Are they written down somewhere
that I can get to and acquire a copy?
Jef.
- Partial Original Message-
No, it's true for all cases. UniVerse indexes are only used on
restrictions in the first WITH phrase in the query. That's one of the
rules.
Could someone please explain the EXPLAIN results? The Help does not
show about EXPLAIN.
In particular, what does the index processing point out? I have 43,000
records that have A8=DRJ but only a handful that will have A50=70 so
if I can get the SELECT to use A50 first that would be great. I can
I believe the IsActive property is not entirely accurate and tends more
to reflect the situation when the last command, or whatever, ran. But
hours-of-being-dormant later, testing this property does not prove the
connection is still viable.
What do you do?
The reason I ask is that in VB we try
From the Help,
quote
From a BASIC program there are two ways to find the UV account:
* Use the UV.ROOT replace token that is defined in the FILENAMES.H
header file
* Use the SYSTEM (32) BASIC function
Note: You cannot find the location of the UV account by opening and
reading the
2007 10:47 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Sacred Licence Seat - A Challenge
Put it in the UV account.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Friday, 24 August 2007 2:46 p.m.
To: u2-users@listserver.u2ug.org
Sara,
How do I set up the UVCS.LOGIN paragraph? I don't have one on my system
to use as a template. I have searched the UV PDF documentation and
Googled for UVCS.LOGIN but found nothing helpful.
I tried this:
CT VOC UVCS.LOGIN
UVCS.LOGIN
0001 PA
0002 JEFLOGIN
0003 END:
But it didn't run
Thank you all who responded. I have answers to questions you raised:
1) The majority of staff users access the database via UVCS - UniObjects
VB6. There occasional Telnet sessions, but not often. The Internet
connection is via a UniJava object which we assume also uses a UVCS
connection.
2)
Does anyone have a way to set one licence seat as sacred?
There are 15 users in the organization and 20 licences for UniVerse.
But users will open more than one session if they can. We need one
licence always available for when an internet connection is made.
How do we keep one unused?
Is
Dawn,
On the http://www.tincat-group.com/mv/trilogy.html page,
the SQL link:
www-3.ibm.com/software/data/u2/mits
doesn't work. Is there an update?
Jef.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Mats,
I think (foggy recollection) that it was the difference between
DUMMY=''
CHK=1
ARR=''
FOR I = 1 TO 1
ARRI=CHAR(MOD((I-1),26)+65)
NEXT I
* Check time here
FOR I = 1 TO 1
DUMMY=ARRI
NEXT I
* Check time here
Some time ago, someone posted code showing a very fast way to process
all the attributes in a record. I think it involved deleting the first
attribute after processing it, but I'm not sure.
I searched the digests I have kept and probably haven't got that one or
don't know what words to search
The .netrc file is a security file that has zero permissions because
it contains identities that can access your system remotely.
You should be able to create it and secure it using:
IDENTITY.DETAILS='hello world'
SH.TEXT='echo ':IDENTITY.DETAILS:' ~/.netrc'
EXECUTE SH -c
If memory serves me, and it's been a while, you still need to set the
UNIX permissions to 000.
Jef.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, 5 October 2006 10:12 AM
To: u2-users@listserver.u2ug.org
Subject: RE:
it be? I have looked for
recent files in the user's account folder and the UV account folder but
nothing appears the be useful.
Jef Lee
Software Developer
IT Vision Australia Pty Ltd
PO Box 881, Canning Bridge WA 6153
Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA Australia 6153
p: (08) 9315
Dan,
Mine is in
C:\IBM\UV\uvconfig
which is a text file.
Jef Lee
Software Developer
IT Vision Australia Pty Ltd
PO Box 881, Canning Bridge WA 6153
Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA Australia 6153
p: (08) 9315 7000
f: (08) 9315 7088
w: www.itvision.com.au
Charles,
The savevg command backs up a Volume Group (a collection of logical and
physical disk space). We do the same thing on our AIX machine to cover
against total hardware failure. A new machine would require the
operating system (rootvg) and then we could import out saved volume
group to the
Me too please?
Jef Lee
IT Vision
Level 3 Kirin Centre, 15 Ogilvie Road, APPLECROSS, WA 6153
Tel: (08) 9315 7000 Fax: (08) 9315 7088
P O Box 881, Canning Bridge, WA 6153
A.C.N. 068 914 867
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http
I don't think ours suffered from speed issues. It was so long ago and
we did what we had to to keep the project alive. The problem you had
arises from accessing a dynamic array value more than once in a
statement. If you are in your application's infancy, you can use local
variable. Instead
You may be experiencing a problem we had with VB6 in the executable.
Try setting your project compilation to P-code. It makes a difference
to the way the values are assigned to the dynamic arrays.
Jef...
IT Vision
Level 3 Kirin Centre, 15 Ogilvie Road, APPLECROSS, WA 6153
Tel: (08) 9315 7000
On a Linux system which programs should be owned by the root user and
which should have the s permission (effective user) set?
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
Hans,
The CONVERT statement does not change the way you think.
LINE=1234jello123green4
CONVERT 1234 TO ABCD IN LINE
will result in LINE containing ABCDjelloABCgreenD
You want the CHANGE function.
CHANGE (expression, substring, replacement [ ,occurrence [ ,begin] ]
)
where every
before.
- Original Message -
From: Jef Lee [EMAIL PROTECTED]
Date: Wed, 9 Jun 2004 17:10:24 +0800
To: [EMAIL PROTECTED]
Subject: [U2] Owner of UV program
On a Linux system which programs should be owned by the root user and
which should have the s permission (effective user) set
Just testing.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
Hello World...
Jef Lee
IT Vision
Level 3 Kirin Centre, 15 Ogilvie Road, APPLECROSS, WA 6153
Tel: (08) 9315 7000 Fax: (08) 9315 7088
P O Box 881, Canning Bridge, WA 6153
A.C.N. 068 914 867
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
35 matches
Mail list logo