Have you compiled the i-descriptor fields? Try listing the field you're
trying to declare as an index, just before you declare it.
It's a pain - some commands (LIST) will do an auto-compile, but most
just refuse. If you've done almost anything to the DICT entry since you
last did a LIST of that fi
kevin zollinger wrote:
...
IHNSHO, ...
Wich means?
-- mats
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
As I understand it (and I'm probably wrong), the UV command editor will
convert from one form to the other (but not the other way round). So if
you use (I think it's this way round) EDIT_LIST and it can't find it, it
will try EDIT.LIST.
I was only ever used to the dot versions on PI, so they're th
Tom,
I guess I am echoing various other responses, but here's my 2c anyway:
1. There are a whole host of tools that will populate a SQL database from
UniVerse. (I recommend mvQuery: it's my product so I would anyway). You will
need to consider how far each solution can be automated and what it al
On Tue, 10 Feb 2004 10:01:21 +0100, you wrote:
>
>
>kevin zollinger wrote:
>
>>...
>>IHNSHO, ...
>>
>Wich means?
In
His
Not
So
Humble
Opinion
--
Allen Egerton
[EMAIL PROTECTED]
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
For some strange reason, the DICT of each Part File needed to contain
copies of the I-Types from the Distributed File's DICT in order for
CREATE.INDEX to work correctly.
Next question... To avoid having to copy DICT items to all the Part Files
each time a change is made, I updated the VOC pointe
Sorry, forgot to mention: UniVerse 9.5 on AIX 4.3.2
[EMAIL PROTECTED]
Except it's not a strange reason. The whole point of a distributed file
is that any part of the file can be treated as a file in its own right,
so it needs its own dictionary.
And given that MV makes no distinction between data and dict portions at
the structural level (and all that jazz), there's
I forgot - another side effect of this is that, if you declare an index
on one partfile, it makes sense to declare it on all.
I'm sure one of the VMark/Ardent/IBM guys who worked on this will muck
in and confirm the details, but if you try doing a select or sorted list
or whatever on a distributed
I'd second the Worthington option - the only caution would be in a rugged
environment, but given the relative costs, it could even be worth starting
out with Worthington and just swapping in something a little more robust
where experience requires.
Steve
-Original Message-
From: Ross Ferr
What's the exact command that places parenthesis around a negative number?
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
parens ???
theres the qoute() function
or an conversion code oconv( negnum , 'MD<' ) but you loose the - sign
ex. < negnum >
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Baruch Salamander
Sent: Tuesday, February 10, 2004 10:01 AM
To: [EMAIL PROTECTED
But if you're doing it for accounting reasons, that's the convention.
You use parentheses INSTEAD OF as negative sign. It makes it stick out
because on the rhs the parens stands out in a column of its own.
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
O
Thanks
[EMAIL PROTECTED] writes:
>parens ???
>
>theres the qoute() function
>
>or an conversion code oconv( negnum , 'MD<' ) but you loose the - sign
>
>ex. < negnum >
>
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Behalf Of Baruch Salamander
>Sent: Tuesday,
OCONV(value, "MDn<") where n is your descale factor, e.g.
Crt OConv(123.45,"MD2<") gives 1.23
Crt OConv(-123.45,"MD2<") gives <1.23>
For more detail, HELP CONV MD (UniVerse).
Brian Leach
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Baruch Salamander
Thanks Stu and Ken the line worked flawlessly.
kevin
At 05:43 PM 2/5/2004 -0500, you wrote:
On line 9, you left out the EVAL. See line 8 to see your mistake.
-Original Message-
From: Kevin Michaelsen [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 3:57 PM
To: U2 Users Discuss
CRT "(":-X "2":")"
:-)
-Original Message-
From: Baruch Salamander [mailto:[EMAIL PROTECTED]
What's the exact command that places parenthesis around a negative number?
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Or you can use the "pick" style conversion code:
CRT OCONV(NEG.NUM,'MD2,E');* The E puts <> around negative numbers
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: Daly, Mark [mai
Gentlemen,
I was having a walk-around this Unidata system. I noticed that some of the files are
approaching 2 gb and a couple of files are over 2 gb. Is there a future problem
looming.
What is the 2 gig limits mentioned in some of the email's?
Dave Raven
Mobile(949) 228 2224 e Fax (815)42593
Dave,
If those 2GB files are static files then there is a serious problem in
your future. If they are dynamic then they can grow beyond 2GB.
FILE.STAT 'filename' at the colon prompt will tell you what the file is.
HTH
JohnC
*
I HAVE UNIDATA 5,2 IN WINDOWS 2000, And The FOLLOWING ERROR :
Tipo de suceso: Error
Origen del suceso: UDTnet
Categoría del suceso: Ninguno
Id. del suceso: 1002
Fecha: 09/02/2004
Hora: 07:14:52 p.m.
Usuario: No disponible
Descripción:
TNET Client/Site licensing inquiry failed
REINSTALL The DATA
If you have 32-bit addressing, then the largest file you can address is 2Gb
(2147483648 bytes), or 2^31. At 2147483649 bytes, you have a corrupt file,
which will fail on writes.
The solutions to the problem include:
1) Archive old data
2) change to Dynamic files (this may be a short-term fix,
Switch to a dynamic file. Another poster mentions "distributed files" but unidata
does not have that option.
From: [EMAIL PROTECTED] on behalf of Dave Raven
Sent: Tue 2/10/2004 12:13 PM
To: [EMAIL PROTECTED]
Subject: 2 gig limits
Gentlemen,
I was having a w
Dave;
There can be a problem with 2GB files. If they are static they will fail
when a write tries to add an item that is 'hashed' over the 2GB limit.
Note: my testing has shown that there are no warnings if you create, resize,
or memresize a file larger than 2GB. Additionally, unix has a ulimit
In English (According to iTools.com):
Type of event: Error
Origin of the event: UDTnet
Category of the event: Unknown
Id. of the event: 1002
Date: 09/02/2004
Hour: 07:14:52 p.m.
User: not available
Description: TNET Client/Site licensing inquiry failed
It sounds like a pr
Convert("<>", "()", Oconv(TheNumber, "MD2<")
The Convert() function changes the angle brackets to parentheses.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
I did not originally notice the OP stated they were a Unidata platform. My distributed
file comments were related to UniVerse. However, when designing a UniVerse distributed
file, it is wise to pick the number of part files that will keep each part file size
*well below* the 2GB limit. Based on
We are looking to move to Universe. Does a 2 gig limit apply to Universe as
well? Does it only apply to the backup or live data?
JT
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
If the file is corrupt, you need the file repaired, then distributed.
Fixing the file can be a real bear at the 2GB limit because of group
truncation and other issues. After you get that part solved (I could do
it for you if you don't have local help and don't mind telecommuting
administration), Yo
The 2GB file size limit is a traditional Unix-based operating system limit. The 2GB
file limit appies to *all* files, UniVerse or not.
ken
===
In a message dated 2/10/2004 2:40:15 PM Eastern Standard Time, [EMAIL PROTECTED]
writes:
>
>
> We are looking to move to Universe. Does a 2 gig limit
The system was an IBM RS6000 with about 100-130 active users. The 80GB file actually
had about 40GB of data in it (to allow for growth, as previously mentioned). These
were usually large historical sales analysis files, where the worst file contained
every invoice line item for the last 5-7 year
All,
We use UniVerse/NT and SB+. It seems redundant to have to login to UniVerse
with a valid user and password, then choose an account, and then login to
SB+ with a user and password. What options do we have to avoid this
redundant entry. Is there a way to pass the user's authentication
inform
Hi Jason,
Yes, it sure does (please note these examples are Universe). Also please
be aware there are limits with dynamic files as well. The dynamic file
has 2 sub files in which the actual data is kept and the 2Gb limit
applies to them :
u-orion1.faulding.com.au> ls -l AR.ARCHIVE6
total 5187936
>The 2GB file size limit is a traditional Unix-based operating system limit.
The 2GB file limit appies to *all* files, UniVerse or not.
Then maybe I missed something in an earlier post. What is a general
suggestion if we expect any sort of file to be larger than 2 gigs?
Thanks,
JT
--
u2-users
I have installed again the BD *(unidata) and also it activate DEVICE
LICENSING. east error continues leaving.
a user enters several (2 or 3) sessions the time .
somebody can help me
> I HAVE UNIDATA 5,2 IN WINDOWS 2000, And The FOLLOWING ERROR :
> Tipo de suceso: Error
> Origen del suceso: UDTne
It would have to be a 64bit file, there are no exceptions as this is a
limitation brought on by the size of a number. (I think a couple of
earlier posters had the numbers involved) therefore you literally cannot
create a file larger than 2Gb with 32 bit addressing.
We have a substantial number of
You can make larger files, but U2 cannot address them, unless you enable
64-bit addressing. The limit is in the unix file /etc/limits (at least on
AIX), as fsize. Fsize is usually expressed in 512b chunks, so a) check, and
b) figure out your upper size requirement in local block size.
"Our gr
Jason Theis wrote:
All,
We use UniVerse/NT and SB+. It seems redundant to have to login to UniVerse
with a valid user and password, then choose an account, and then login to
SB+ with a user and password. What options do we have to avoid this
redundant entry. Is there a way to pass the user's a
The limit is an old one from Unix having 32-bit addressing. On a system with
32-bit addressing, the limit applied to all files, including backup images
(at least to disk - I'm not certain about on tape drives, although I'd
assume so). Now, we have 64-bit addressing, so the upper limit is in the
Is there a way to do this so that MYPASSWORD is encrypted?
R. Bruce Lunt
From: Dianne Ackerman <[EMAIL PROTECTED]>
Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
To: U2 Users Discussion List <[EMAIL PROTECTED]>
Subject: Re: Login question for Universe/SB+
Date: Tue, 10 Feb 2004 15:58:
> I would question how real time the OLAP & BI tools are never mind the
> database.
Yes, the "real-time" requirement is ambiguous. It will be addressed as we flesh out
the tactical analysis requirements for the BI tools.
> I would suspect they are looking for a dashboard solution
> rather th
Yes.
Execute the script 'example/script/wc.wis'.
The STYLE for this script reads:
Style WS_CAPTION|WS_POPUP|WS_VISIBLE|WS_SYSMENU|WS_MINIMIZEBOX|WS_GROUP
Regards, Ian Renfrew
- Original Message -
From: "Barry Brevik" <[EMAIL PROTECTED]>
To: "U2 list (E-mail)" <[EMAIL PROTECTED]>
Sent
Under HP/UX there are some known bugs with 64-bit files in older
UniVerse versions which can lead to file truncation. Be sure to
research the applicable release for your O/S and make sure there are no
known problems before you decide to implement this solution.
On Tue, 2004-02-10 at 14:51, Logan,
>
> 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 ?
>
Yes.
> Also, what USE is the information going to be put to ?!
To be d
We only use AIX and possibly (at a later date) Linux.
JT
-Original Message-
From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 2:41 PM
To: U2 Users Discussion List
Subject: RE: 2 gig limits
Under HP/UX there are some known bugs with 64-bit files in older
U
In UD we don't have the VOC/user option so our LOGIN VOC item calls a
program. This program takes the user (@logname) and determines the SB user,
it then data's the user and password to SB.LOGIN. You could easily apply
encryption to the passwords (they are encrypted in DMSECURITY as well).
Note,
> Another possible name for a real-time data warehouse is
> Operational Data Store (ODS).
I'm somewhat familiar with the concept ODS, I don't think it will play a role in this
project, but it is on my radar.
> Any approach to actually porting data to SQL Server, for
> example, sounds so
> sm
Unless you are really using the Device Licensing setup I would turn it off.
>From UniAdmin, Licensing, uncheck Device License. Then update and
re-authorize UniData. We had some grief with device licensing at about this
release level. I don't think it was that bad but we didn't "use" it so
turned it
> Is there a way to do this so that MYPASSWORD is encrypted?
So let me see if I get this; you want the password encrypted but
automagically provided to SB+? Seems like this is a bit uncertain as to how
much security you'd really want out of this kind of a solution.
--
u2-users mailing list
[EM
> ... On Behalf Of Dan Fitzgerald
> You can make larger files, but U2 cannot address them, unless
> you enable 64-bit addressing
UV *mostly* handled >2GB files, but I had trouble enabling them for UV's
transaction logging.
If I remember, UV used a unix utility - maybe fsync? - that was only
One suggestion I don't think was mentioned is to break your record into
parts with each part in a different file. One file having most of the
stuff you use and another file(s) have other stuff. You have to change
your read for multiple reads (also for write and locks and releases).
--
u2-users
Tom Firl asked for some clever ideas on Extract-Transform-Load.
At www.mvconsultants.com/mv-start.html there is some by Steve Van Arsdale.
He details how REFORMAT can be used in a really cunning way. It's worth the
read.
Regards, Keith
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oli
>Yes.
>
>Execute the script 'example/script/wc.wis'.
Thank you! I find scripting to very different than universe basic, heh heh.
Barry
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Any Melbournian Perl jockies who might be interested in this?
Apologies for the off-topic post.
-
Subject: Fwd: Damian Conway on Perl 6 -- February 17
Tuesday 17 February, 11am
WEHI Lecture Theater (http://www.wehi.edu.au/about/locations.html)
Parkville
Prof Damian Conway
School of Computer
Hi Dan,
We can use filepeek quite happily on our 64bit files. Do you mean
uvfixfile? I know that has restrictions and cannot be used on 64bit
files. The parameter in the uvconfig file is 64BIT. If this is set to 1,
all files are created by default as 64bit files.
Regards
David Logan
Database Adm
There's a few postings on this very topic in the archives, such as this from
Glenn Herbert...
http://www.indexinfocus.com/dl/u2list/200106/15105.html
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 7:37 AM
Yes; I remembered one of those didn't work, and I chose the wrong one.
Shoulda fired up my UV server & checked first...
"Our greatest duty in this life is to help others. And please, if you can't
help them, could you at least not hurt them?" - H.H. the Dalai Lama
"When buying & selling are cont
From: Dan Fitzgerald [mailto:[EMAIL PROTECTED]>
> You can make larger files, but U2 cannot address them, unless
> you enable
> 64-bit addressing. The limit is in the unix file /etc/limits
> (at least on
> AIX), as fsize. Fsize is usually expressed in 512b chunks, so
> a) check, and
> b) fi
> From: Dan Fitzgerald [mailto:[EMAIL PROTECTED]
> will then make the limit a historical curiosity. Or you can
> use dynamic
> files (although at the most - with a lot of luck - this gives
> you 4Gb),
What makes you say this? We have some dynamic files that are well
over 10-15 gig. They have
What caught my attention was MYPASSWORD. I assumed (maybe wrongly?) that
that was an ASCII string in the VOC. If that can be found by others then my
password is not very secure. Or did I misunderstand?
R. Bruce Lunt
408.832.1900 cell
From: "Bruce Lunt" <[EMAIL PROTECTED]>
Reply-To: U2 Users
>From: Horn, John
>> From: Dan Fitzgerald
>> Or you can use dynamic
>> files (although at the most - with a lot of luck - this gives
>> you 4Gb),
>What makes you say this? We have some dynamic files that are well
>over 10-15 gig. They have multiple dat files that are all well
>under the 2 gig
Dynamic files are simply two files - DATA.30 and OVER.30 - at the Unix
Level, each subject to the 2Gb limit if you don't have 64-bit addressing
enabled. It sounds to me like what you have are distributed files. You can
have a distributed file made up of dynamic file partitiions.
> From: Dan Fi
Ah. Yes, well, I was.
I suspect Dan was busy thinking about UniVerse when he posted, even though
the OP is actually running UniData.
Cheers,
Ken
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
_
> We use UniVerse/NT and SB+. It seems redundant to have to login
> to UniVerse with a valid user and password, then choose an account, and
then login to
> SB+ with a user and password.
Sure does. SB won't change this I'm guessing because their licencing relies
on it.
> What options do we have t
IIRC, UV.LOGIN always gets run first - if it exists, regardless of account
flavour. It resides in the UV account.
Regards
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Stuart Boydell
Subject: RE: Login question for Universe/SB+
SB+ runs in "Pick"
One of the prior concerns that R. Bruce Lunt raised was about security - if
you set all the SB+ passwords to be the same, you lose that.
However, i'd like to add that if you've got users who do not have access to
TCL; do not have access to a unix shell; and in effect, once they login can
only do t
> IIRC, UV.LOGIN always gets run first - if it exists, regardless of account
> flavour. It resides in the UV account.
I left this out on purpose because I didn't think anyone would use it to
control sb+ access. but are you saying you think this is an appropriate
place to control access to sb+? Wha
Hmmm, nope...nothing to do with it at all...just thought I'd throw in !!
Regards
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Stuart Boydell
Sent: Wednesday, February 11, 2004 2:39 PM
To: U2 Users Discussion List
Subject: RE: Login question for Un
I will be out of the office starting February 11, 2004 and will not return
until February 16, 2004.
I will be out of the office February 11 - 13. You may also leave me a
voice mail message at (614) 659-7457 if your message is urgent.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliv
69 matches
Mail list logo