RE: [U2] UniVerse File Types

2004-10-14 Thread Bjorn Behr
Type  1: Non Hashed - Directory - Does not support long names (Greater than
14 characters)
Type  2: Hashed - Keys numeric & most unique on right
Type  3: Hashed - Keys numeric with seperators & most unique on right
Type  4: Hashed - Keys alphanumeric & most unique on right
Type  5: Hashed - Keys consist of full range of ASCII characters & most
unique on right
Type  6: Hashed - Keys numeric & most unique on left
Type  7: Hashed - Keys numeric with seperators & most unique on left
Type  8: Hashed - Keys alphanumeric & most unique on right
Type  9: Hashed - Keys consist of full range of ASCII characters & most
unique on left
Type 10: Hashed - Keys numeric & most unique on center
Type 11: Hashed - Keys numeric with seperators & most unique on center
Type 12: Hashed - Keys alphanumeric & most unique on center
Type 13: Hashed - Keys consist of full range of ASCII characters & most
unique on center
Type 14: Hashed - Keys numeric & use entire key for hashing
Type 15: Hashed - Keys numeric with seperators & use entire key for
hashing
Type 16: Hashed - Keys alphanumeric & use entire key for hashing
Type 17: Hashed - Keys consist of full range of ASCII characters & use
entire key for hashing
Type 18: Hashed - Entire keys are in arbitrary form.
Type 19: Non Hashed - Directory - Does support long names
Type 25: B-Tree Files (Used for indexing in UniVerse)
Type 27: Distributed Files
Type 30: Dynamic Hashed Files

Regards
Bjorn

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: 15 October 2004 01:28
To: [EMAIL PROTECTED]
Subject: RE: [U2] UniVerse File Types

This is really good stuff

But **where** could I have found this documented, being the self-reliant
kind of guy I am...

I just need the Type 2 to 18 definitions now!
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] I am out of office on Friday, Oct 15, with no email access. Please use phone to contact me, 404-48-1581.

2004-10-14 Thread Deborah A Perry
I will be out of the office starting  10/15/2004 and will not return until
10/18/2004.

General questions, contact Sue Van Aalst at 913.599.8801
For sales support, contact Louis Tur at 813.356.3615

Additional Contacts:

* Technical U2 Product Support - visitm
www.ibm.com/software/data/u2/support/u2techconnect or call 800.729.3553

* Renew U2 maintenance - call 800.331.1763

* Order U2 product upgrades and place orders - email [EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Memresize failed

2004-10-14 Thread kafsat taiyus
Thank you everyone for all your answers.

Thank you ken, hope you are well too.

I have tried KEYDATA did not make much difference.

I have created a new file changed SPLIT_LOAD and MERGE_LOAD to 20 and 10
using CONFIGURE.FILE, copied all records to new file and. The result is a
smaller over001 but a bigger over002

1073741824 Oct 15 11:28 dat001
1073741824 Oct 15 11:30 dat002
 819068928 Oct 15 11:32 dat003
1073741824 Oct 15 11:30 over001
 598556672 Oct 15 11:32 over002

The record ids for this file are very similar to each other that may be the
main problem. I created a file will smaller modulo and the result is a
smaller file but with same problem.

1059520512 Oct 15 12:02 dat001
1672675328 Oct 15 12:02 over001

I wander if should stick to this smaller file at least it will save some
disk space? Is there anything else that I can try?

Thank you again.

Regards
Kafsat




-Original Message-
From: Ken Wallis [mailto:[EMAIL PROTECTED] 
Sent: Friday, 15 October 2004 10:50 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Memresize failed

> -Original Message-
> From: Timothy Snyder

> kafsat taiyus <[EMAIL PROTECTED]> wrote
>
> > Everything is getting in over001.  I tried TYPE 0, TYPE 1, mod,sep
> 181061,16
> > (suggestion from guide) and 362137, 8 still the result is same,
> everything
> > is going to over001.  What else can I try to get a better file?
>
> Sometimes changing the split/merge type to KEYDATA can help
> address this.

Hi Kafsat, hope you are well,

You may find that using a KEYDATA type file helps, or you may not.  I've
never had much luck with KEYDATA, and prefer to stick with KEYONLY, but to
vary the MERGE.LOAD and SPLIT.LOAD parameters for the file.  To be honest, I
generally prefer to change the default SPLIT and MERGE load parameters in
udtconfig since the defaults seem to almost always generate FAR too much L1
overflow and even allow some L2 overflow in a dynamic file.

To work out exactly what your block size and split/merge loads should be,
you need to take into account your average record size and the average key
size, the standard deviation of both, and all sorts of fiddly stuff that
gets very tedious.  So as a general rule of thumb, what I do is use mkfs -m
at the UNIX level to work out what the filesystem block size is, and unless
that is bigger than 16K, or unless a significant proportion of your records
are more than half the OS block size, I choose a block factor that generates
UniData blocks the same size as the OS filesystem.  I then vary guide's idea
of the ideal modulo according to how badly guide and I disagree on the block
factor.  I've said many times before that I can't think of a scenario in
which UniData's default SPLIT_LOAD and MERGE_LOAD parameters of 60% and 40%
will ever do a good job, so I tend to change them in udtconfig to 20 and 10
respectively - ie a group becomes a candidate for splitting if more than 20%
of the primary block is filled with keys and pointers, and two adjacent
groups become candidates for merging if the combined keys and pointers in
both groups are less than 10% of the block size.  If you don't want to
change your udtconfig then you'll have to use CONFIGURE.FILE to modify the
SPLIT.LOAD and MERGE.LOAD parameters for your specific file.  This means you
have to CREATE.FILE your new file, CONFIGURE.FILE it, and then COPY the data
from the old file to the new one.  This is much slower than using memresize,
but memresize doesn't provide an option to change the load thresholds.  One
other option is to change udtconfig, use stopsmm -r or kill -HUP ,
do your memresize and then change the parameters back again before anybody
else creates a new dynamic file.

All the best,

Ken
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

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]
To unsubscribe please visi

RE: [U2] Has anyone tried UniObjects for .NET?

2004-10-14 Thread Steve Johnson
Yes, we have been developing an entirely new product
with UO.NET and UV since June. Mostly it has worked
quite well, but we have hit a few snags.

With the beta version of uodotnet.dll we had a problem
with the GetArg or getArgDynArray methods on one
particular UniSubroutine object. It would sometimes
return garbage values for higher argument numbers
(above 5 or 6), or cause an abort with a message about
"possible client-side licensing problem." The
orkaround was to reduce the number of arguments. (We
combined several single-valued arguments into a
dynamic array.)

With build 1.1.7073.0 (first released build dated
7-Aug-04), we had these problems:

(1) LockRecord method of UniFile class raises
exception if record not found. But if executed twice,
it does NOT raise the exception the second time even
though the record is still not found. IMO, it should
not raise an exception, but I would be happy with any
consistent behavior.

(2) The UniVerse basic statement "DEL ATC<1>" causes
UO.NET to abort when ATC is an empty string passed in
to the subroutine as an argument. It is a UniDynArray
object in .NET. This happened every time in one
particular case, but it not occur with other
subroutines when they were passed an empty dynamic
array.

(3) The UniVerse basic statement"aMsg<-1>=Variable"
causes UO.NET to abort when aMsg is passed and it is
an empty string. Again, this happened every time in
one particular case, but not elsewhere.

My workaround for both (2) and (3) has been to insert
a statement like IF ATC="" THEN ATC="" for any
argument passed into a basic subroutine from .NET
where it might 
possibly be an empty string.

Yesterday, I installed build 1.1.1.0 dated 7-Oct-04
which patches a performance issue (not one that we
have experienced) with code like (example from Wally
Terhune 
at IBM U2 ATS):

uonetCMD.Command = "SSELECT CLIENTS" 
uonetCMD.Execute() 
uoSelectlist = uonetSession.CreateUniSelectList(0)
 
Do While Not uoSelectlist.LastRecordRead
itemid = uoSelectlist.Next
Loop

So far, no new problems with this build. I have not
checked the issues with prior builds to see if they
are resolved in this new build.

HTH...

Regards, 

Steve Johnson
Technology Director
FXA Group Ltd.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]  
On Behalf Of Dave Tabor
Sent: Thursday, October 14, 2004 9:44 PM
To: [EMAIL PROTECTED]
Subject: [U2] Has anyone tried UniObjects for .NET?

Hi,

Just wondering if anyone has had a chance to try then
new UniObjects for .NET?  

If so:
What are your thoughts pro & con?  
Any bugs to keep in mind?  
Anything else?

Thanks in advance!
- Dave
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit
http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse File Types

2004-10-14 Thread Stuart Boydell
> But **where** could I have found this documented, being the self-reliant
> kind of guy I am...

Chapter 4 of the System Description (sysdesc.pdf) "Creating a Database", Sub
heading: Creating Files.
[nb. I used acrobat reader (v6) search and found the first occurence of the
phrase "file types" in INDEX.PDX supplied with the UV documentation. There
were about another hundred instances of the phrase that may have been
interesting.]

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


RE: [U2] [UV] Triggers

2004-10-14 Thread Stuart Boydell
> Has anyone experience with triggers at both version levels?

We have both file-triggers (sql & non-sql) and index-triggers on our system.
We have used index triggers from version 9.4 through to 10.0.7. and
file-triggers with v10.

Performance-wise, there doesn't seem to be too much difference.
Maintenance-wise, I think the index triggers are more fragile but that's
just the way they were architected here. There are also issues using
index-triggers within a transaction. We had a deadlatch issue using a file
with an index trigger. The index i-type read the file that was being updated
and regardless of the locking we used caused a deadlatch. We replaced the
index trigger with a file trigger and the problem went away.

Remember that triggers work transactionally. So, if for example, the update
that fires the trigger fails, or if you use the setDiagnostics() function in
the trigger program, then any file I/O actions the trigger makes will be
rolled back.

You cannot use a file trigger on a UVNet file updated remotely, though an
index trigger may work in that situation. I haven't had any other problems
using file triggers within version 10.

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


Re: [U2] [UD] BASIC COMPILE ERROR: Too many constants near line

2004-10-14 Thread Craig Bennett
  PCPERFORM "lp -d ":QUEUE:" ":FONTFILE CAPTURING MSG
Thanks for the suggestion Tom, but I'm generating PDF files and 
embedding the fonts before writing to disk, so this doesn't really apply.
I think I may just have to split the data into multiple subroutines.

Craig
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Cannot establish a Universe session

2004-10-14 Thread Timothy Snyder
"Nick Cipollina" <[EMAIL PROTECTED]> wrote on 10/14/2004 04:08:19 PM:

> Cannot open log file.  It repeats over and over again.

Is there a file called errlog in your uvhome directory?  (ls -l `cat
/.uvhome`/errlog)  If so, it should have its permissions set at -rw-rw-rw-.

Is this happening for all users or just some?  All accounts or just some?
Is it possible - as somebody else alluded to - that there's something being
executed in the LOGIN or UV.LOGIN paragraph that could be causing this
message?


Tim Snyder
IBM Information Management
Consulting I/T Specialist , U2 Professional Services
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Report Writer

2004-10-14 Thread Ross Ferris
I'm guessing that it was probably us they were referring to.

Visage gives you 2 choices in terms of reporting - the Visage.Reporter gives you a 
drag'n'drop report design facility to produce "traditional" banded reports & forms. 

These reports can be physically sent to a printer, generated as PDF, stored 
(indefinitely - storage permitting) and/or viewed from a Visage screen.

However, we are finding that more people are opting for the Visage.BIT option, which 
provides a MOLAP cube for you to "play" with (as opposed to the ROLAP technology used 
by the other products I'm aware of in the mv world - we have a whitepaper that 
explains the technology difference at 
http://www.stamina.com.au/Products/Visage/Visage_BIT.htm)

At the Spectrum show in Sydney earlier this week I showed a cube with 22 dimensions 
(things that you would typically SORT on, or include in a report for information or 
sub-totals) and 5 facts (the 'real' data you are interested in - typically numbers).

This single cube has replaced >400 'standard' reports in our R5 application, because 
the user can drag dimensions any way they want, to get at the data they need as an 
"interactive" report. As one user said (after converting from another OLAP product), 
"This is great, because I DON'T KNOW what I don't know, and now I can find things 
without having to pre-plan drill paths"

To further enforce this, for a ROLAP product to enable a drill/view of every possible 
dimensional combination for 22 dimensions, each source "transaction" would need to be 
transformed into a massive 3,055,350,753,492,612,960,484 summary records !!! (and 
multiply this by at least 500 for the number of bytes per summary record, including 
key size !)

What some people find even more staggering when making comparisons to other products 
is that using our API functionality, we can transform > 3,000,000 source records into 
this cube in under an hour ! AND our Visage.BITSolo product enables these cubes to be 
used in a stand alone mode, which is a great way to empower a mobile sales force that 
may already have notebooks !

You can get a free test drive of a BIT cube from the link I gave above. For more 
information, and/or to play with our test drive facility if you want to check out the 
"traditional" reporting options, contact the team at American Computer Technics.

It is important to realize that these products can be used as independent pillars of 
the Visage product range - it's OK to only install Visage.BIT as an OLAP tool, or the 
Visage.ReportServer engine, even though you haven't (and maybe won't) convert any of 
your screens to use Visage.

Indeed some people have found this as an 'interesting' way to get Visage in the back 
door - they get management approval for a cost effective OLAP solution (better, faster 
AND cheaper!) and then use the platform to gradually 'evolve' new features into their 
applications

Hmm, I think I should have added an [AD] to the subject, as this is starting to get 
[OT], but the key is that Visage is the ONLY product that addresses ALL of the key 
issues you will face when delivering 21st century applications - it is a COMPLETE 
Application Development Framework !




Ross Ferris
Stamina Software
Visage - an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On Behalf Of D Averch
>Sent: Wednesday, 13 October 2004 4:07 AM
>To: [EMAIL PROTECTED]
>Subject: [U2] Report Writer
>
>Somebody mentioned in passing to me that there is a report writer written
>for Universe that was developed in Australia.  Does any one know the name
>of
>the company and their web site?
>---
>u2-users mailing list
>[EMAIL PROTECTED]
>To unsubscribe please visit http://listserver.u2ug.org/
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.775 / Virus Database: 522 - Release Date: 8/10/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 8/10/2004
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Memresize failed

2004-10-14 Thread Ken Wallis
> -Original Message-
> From: Timothy Snyder

> kafsat taiyus <[EMAIL PROTECTED]> wrote
>
> > Everything is getting in over001.  I tried TYPE 0, TYPE 1, mod,sep
> 181061,16
> > (suggestion from guide) and 362137, 8 still the result is same,
> everything
> > is going to over001.  What else can I try to get a better file?
>
> Sometimes changing the split/merge type to KEYDATA can help
> address this.

Hi Kafsat, hope you are well,

You may find that using a KEYDATA type file helps, or you may not.  I've
never had much luck with KEYDATA, and prefer to stick with KEYONLY, but to
vary the MERGE.LOAD and SPLIT.LOAD parameters for the file.  To be honest, I
generally prefer to change the default SPLIT and MERGE load parameters in
udtconfig since the defaults seem to almost always generate FAR too much L1
overflow and even allow some L2 overflow in a dynamic file.

To work out exactly what your block size and split/merge loads should be,
you need to take into account your average record size and the average key
size, the standard deviation of both, and all sorts of fiddly stuff that
gets very tedious.  So as a general rule of thumb, what I do is use mkfs -m
at the UNIX level to work out what the filesystem block size is, and unless
that is bigger than 16K, or unless a significant proportion of your records
are more than half the OS block size, I choose a block factor that generates
UniData blocks the same size as the OS filesystem.  I then vary guide's idea
of the ideal modulo according to how badly guide and I disagree on the block
factor.  I've said many times before that I can't think of a scenario in
which UniData's default SPLIT_LOAD and MERGE_LOAD parameters of 60% and 40%
will ever do a good job, so I tend to change them in udtconfig to 20 and 10
respectively - ie a group becomes a candidate for splitting if more than 20%
of the primary block is filled with keys and pointers, and two adjacent
groups become candidates for merging if the combined keys and pointers in
both groups are less than 10% of the block size.  If you don't want to
change your udtconfig then you'll have to use CONFIGURE.FILE to modify the
SPLIT.LOAD and MERGE.LOAD parameters for your specific file.  This means you
have to CREATE.FILE your new file, CONFIGURE.FILE it, and then COPY the data
from the old file to the new one.  This is much slower than using memresize,
but memresize doesn't provide an option to change the load thresholds.  One
other option is to change udtconfig, use stopsmm -r or kill -HUP ,
do your memresize and then change the parameters back again before anybody
else creates a new dynamic file.

All the best,

Ken
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse File Types

2004-10-14 Thread Timothy Snyder
"David Wolverton" <[EMAIL PROTECTED]> wrote on 10/14/2004 07:28:13 PM:

> But **where** could I have found this documented, being the self-reliant
> kind of guy I am...

Check out the UniVerse System Description manual, in the chapter on
UniVerse File Structures.  There's an all-inclusive table starting on page
6-39 of the copy I'm looking at.

Tim Snyder
IBM Information Management
Consulting I/T Specialist , U2 Professional Services
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse File Types

2004-10-14 Thread Andrew Gissing
One could make the case that you don't really need to know what 2-18 are
'cause the only differences are as you've said, the hashing algorithym.

You could do a HASH-HELP on each file in the system and have universe tell
you what type it recommends - along with modulo and separator.

Up till a recent cleanout we had a set of uv 9.4 manuals and on a few pages
it outlined each of the types. You'll find it in the documentation
somewhere - sorry I can't be more specific. In umm.. system description or
something like that.

Andrew
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse File Types

2004-10-14 Thread David Wolverton
This is really good stuff

But **where** could I have found this documented, being the self-reliant
kind of guy I am...

I just need the Type 2 to 18 definitions now!
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Triggers

2004-10-14 Thread Scott Ballinger
I recently used the index-trigger method to track and record all changes
to a file. It seems to work well; it's not a really active file, so the
performance hit has been negligible. If anyone is interested I will post
the code. The only gotcha was figuring out how many times the TRIGGER
subroutine was called, and what my RECord variable contained each time.
Here is the note at the top of the subroutine regarding this:

SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID)
* This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE.
* A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS
option.
* That forces this subroutine to be called twice when a MYFILE record is
updated:
*  the first time with REC = the original record, then again with REC =
the new
*  record (however, if the MYFILE record is new, this subroutine is
called only once).

 RELLEVEL
0001 X
0002 9.6.1.14
0003 PICK
0004 PICK.FORMAT
0005 9.6.1.14


Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Maresh, Mel
Sent: Thursday, October 14, 2004 9:55 AM
To: [EMAIL PROTECTED]
Subject: [U2] [UV] Triggers


We have recently upgraded to v10.1 and are reconsidering the use of
triggers after encountering significant issues with triggers with v9.4.
After successfully testing them in our development  environment, we
encountered random write failures in production.

Has anyone experience with triggers at both version levels?  If so, is
the use of triggers on non-SQL files, which is now possible, more robust
and more efficient than on SQL files in 9.4?

It has been suggested that we use indexes instead of triggers in the
following way

1.  Create an I-descriptor on a file that calls a subroutine
2.  Create the subroutine to always return a null value
3.  Index the I -descriptor with the no-null option

Any time a write is made to the file from any program including the
editor, Universe will attempt to update the Index.  However  the index
will not be updated as the returned value is always null.  In the
meantime the subroutine called to evaluate the value is free to do what
we wanted the trigger to do.

This apparently was common before triggers became available.  Has anyone
had experience with this?

Any help would be greatly appreciated

Mel Maresh
NextiraOne LLC
IT Senior Developer
713.307.4256
[EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse File Types

2004-10-14 Thread Rod Hills
Both create a folder with each OS file being a universe record.

Type 1 assume a 14 character max on path names and universe will create
sub folders to extend the name. Example- record ELEPHANTSANDMICE becomes
under the OS as ELEPHANTSANDMI/CE.

Type 19 assumes no such restriction and the file name is the full record
name.

Type 1 folders will have a .Type1 empty file under the folder to tell
universe that that is the type. Type 19 are represented by not having a
.Type1 file.

HTH

-- Rod Hills

-Original Message-
From: David Wolverton [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 14, 2004 1:59 PM
To: [EMAIL PROTECTED]
Subject: [U2] UniVerse File Types

This question has been posed before, but when I do a search on 'FILE
TYPE'
in my U2 email folder, and get 1700 hits. Yikes!  So here it is,
probably
again...

What is the difference in TYPE 1 and TYPE 19 files?

And where can I find this documented?  I just downloaded the current
UniVerse docs, and only the CREATE.FILE command seems to talk about it,
but
not what the implications are of the types.

I find 'File Types' defined, but again, it doesn't tell me what the
choices
of "2 - 18" involve, or why one is better/worse/different. As well, I
know 1
and 19 are diretory, but why are there two of them?  I know it must be
based
on the key structure, but WHERE do I find those defintions?
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniVerse File Types

2004-10-14 Thread Ray Wurlod
The difference in physical implementation is that, for a Type 1 file there is a hidden 
file called .Type1 in the directory whereas for a Type 19 file there is not.

In a Type 1 file there are two things that occur with record IDs that do not occur in 
Type 19.

The first is that, if the record ID contains more than 14 characters, it is actually 
stored as a nested structure of directories.  Thus, for example, if you save a record 
whose key is PRODUCE.DAY.END.REPORTS in a BP file that is Type 1, the actual UNIX file 
is ./BP/PRODUCE.DAY.EN/D.REPORTS (the reason for this is that some old UNIX 
implementations impose a limit of 14 characters per file/directory name, and UniVerse 
preserves compatibility with this rule).

The second is that the maximum length of a record ID is 41 characters.  This prevents 
the above mechanism from creating more than three levels of nesting (3 x 14 = 42).

You can change a Type 1 file to Type 19 using RESIZE, for example RESIZE BP 19.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Cannot establish a Universe session

2004-10-14 Thread Ray Wurlod
Is this message generated by something in your autostart paragraph/PROC, or definitely 
by UniVerse.  Does the errlog file exist in the UV account?  Do you have transaction 
logging enabled?  If so, is there sufficient disk space in the log files directory to 
create a new transaction log file?

- Original Message -
From: "Nick Cipollina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [U2] [UV] Cannot establish a Universe session
Date: Thu, 14 Oct 2004 16:08:19 -0400

> 
> I'm wondering if anyone else has run into this before.  When attempting
> to establish a universe session, we get the following error message
> 
> 
> 
> Cannot open log file.  It repeats over and over again.  This is UV 10
> running on SunOS 5.8.  Any help would be greatly appreciated.
> 
> 
> 
> Nick Cipollina
> 
> 
> 
> Pick Programmer
> 
> ACS - Heritage Information Systems, Inc.
> 
> 2810 North Parham Road, Suite 210
> 
> Richmond, VA 23294
> 
> (804)644-8707 x 314
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse File Types

2004-10-14 Thread Pingilley, Ron
David,

A type-1 directory file splits item-id's at 14 characters, which I believe was 
based on the old Unix file name limit.  If a record's ID is longer than 13 characters, 
a new subdirectory is created to contain the "rest" of the name.  If the "rest" of the 
name is also longer than 13 characters, yet another subdirectory is created.

The TCL command UNIX.PATH simulates this:

>UNIX.PATH 123456789012345678901234567890
12345678901234/56789012345678/90

So if you said ED TYPE1FILE 123456789012345678901234567890 and filed that 
item, the body of the record would reside at:

/.../TYPE1FILE/12345678901234/56789012345678/90

If you had typed ED TYPE1FILE 12345678901234 you would get:

/.../TYPE1FILE/12345678901234/?

Which is a real PAIN to deal with at the Unix level, since "?" is a special 
character.

I MUCH prefer type-19 files, which don't do any subdirectory stuff.  As long 
as your underlying OS can handle the item-id, you're good to go...

--Ron P.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Wolverton
Sent: Thursday, October 14, 2004 3:59 PM
To: [EMAIL PROTECTED]
Subject: [U2] UniVerse File Types


This question has been posed before, but when I do a search on 'FILE TYPE'
in my U2 email folder, and get 1700 hits. Yikes!  So here it is, probably
again...

What is the difference in TYPE 1 and TYPE 19 files?

And where can I find this documented?  I just downloaded the current
UniVerse docs, and only the CREATE.FILE command seems to talk about it, but
not what the implications are of the types.

I find 'File Types' defined, but again, it doesn't tell me what the choices
of "2 - 18" involve, or why one is better/worse/different. As well, I know 1
and 19 are diretory, but why are there two of them?  I know it must be based
on the key structure, but WHERE do I find those defintions?
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UniVerse File Types

2004-10-14 Thread David Wolverton
This question has been posed before, but when I do a search on 'FILE TYPE'
in my U2 email folder, and get 1700 hits. Yikes!  So here it is, probably
again...

What is the difference in TYPE 1 and TYPE 19 files?

And where can I find this documented?  I just downloaded the current
UniVerse docs, and only the CREATE.FILE command seems to talk about it, but
not what the implications are of the types.

I find 'File Types' defined, but again, it doesn't tell me what the choices
of "2 - 18" involve, or why one is better/worse/different. As well, I know 1
and 19 are diretory, but why are there two of them?  I know it must be based
on the key structure, but WHERE do I find those defintions?
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] Cannot establish a Universe session

2004-10-14 Thread Nick Cipollina
I'm wondering if anyone else has run into this before.  When attempting
to establish a universe session, we get the following error message



Cannot open log file.  It repeats over and over again.  This is UV 10
running on SunOS 5.8.  Any help would be greatly appreciated.



Nick Cipollina



Pick Programmer

ACS - Heritage Information Systems, Inc.

2810 North Parham Road, Suite 210

Richmond, VA 23294

(804)644-8707 x 314
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] -- Out of BUF_TYPE space [AD] - JScript for U2

2004-10-14 Thread Allen E. Elwood
Perhaps if your COL-1 evaluated to 0 or a negative number, it may have done
a simple math test (expecting a positive column) and come out with a number
it knew was larger than the buffer space.  (?)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Noah Hart
Sent: Thursday, October 14, 2004 10:26
To: [EMAIL PROTECTED]
Subject: [U2] -- Out of BUF_TYPE space [AD] - JScript for U2


We run a number of scheduled jobs each night.  They have run
successfully for several years.

Last night we received this error in the log file.

In /home/LIPMAN/CTLG/S.INPUT at line 64 out of BUF_TYPE space.

The source for this line is a simple print statement
  CRT @(COL-1,ROW):VR:STR("_",LON):VO:

Any idea what this error might mean?

Noah
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] writeseq

2004-10-14 Thread Alfke, Colin
It's been around for quite a while. I did some basic performance testing
vs. writeseq and *if* the optimal settings were used it was a little
faster. I didn't think it was enough of a gain to worry about -
especially since you need to do testing to get the optimal settings to
get it to run faster. The syntax is a little bit more work - unless you
are working with fixed length blocks of data as you need to specify the
number of bytes per read/write.

Colin
Currently in sunny LA

-Original Message-
From: Kevin King [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 14, 2004 9:12 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] writeseq 


WriteBlk?  What version of Unidata is that supported in? 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] -- Out of BUF_TYPE space [AD] - JScript for U2

2004-10-14 Thread Noah Hart
We run a number of scheduled jobs each night.  They have run
successfully for several years.

Last night we received this error in the log file.

In /home/LIPMAN/CTLG/S.INPUT at line 64 out of BUF_TYPE space.

The source for this line is a simple print statement
  CRT @(COL-1,ROW):VR:STR("_",LON):VO:

Any idea what this error might mean?

Noah 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] Triggers

2004-10-14 Thread Maresh, Mel
We have recently upgraded to v10.1 and are reconsidering the use of triggers
after encountering significant issues with triggers with v9.4.  After
successfully testing them in our development  environment, we encountered
random write failures in production.

Has anyone experience with triggers at both version levels?  If so, is the use
of triggers on non-SQL files, which is now possible, more robust and more
efficient than on SQL files in 9.4?

It has been suggested that we use indexes instead of triggers in the following
way

1.  Create an I-descriptor on a file that calls a subroutine
2.  Create the subroutine to always return a null value
3.  Index the I -descriptor with the no-null option

Any time a write is made to the file from any program including the editor,
Universe will attempt to update the Index.  However  the index will not be
updated as the returned value is always null.  In the meantime the subroutine
called to evaluate the value is free to do what we wanted the trigger to do.

This apparently was common before triggers became available.  Has anyone had
experience with this?

Any help would be greatly appreciated

Mel Maresh
NextiraOne LLC
IT Senior Developer
713.307.4256
[EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] writeseq

2004-10-14 Thread Kevin King
WriteBlk?  What version of Unidata is that supported in? 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Thursday, October 14, 2004 3:21 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] writeseq 

Dave,

Use WriteBlk rather than WriteSeq.

Brian. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Raven
Sent: 13 October 2004 23:17
To: [EMAIL PROTECTED]
Subject: [U2] writeseq 

I am using a writeseq to build a record for flat file, I have 5 to
15000 records I am build into one item, after each record I append it
to the flat file item however there is a blank line appended each time
it writes ? Is there a way to omit the blank line when it writes?

Thanks

D Raven
e Fax (815)4259364
P.O. Box 17811, Irvine CA 92623-7811
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

__
__
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]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Has anyone tried UniObjects for .NET?

2004-10-14 Thread Dave Tabor
Thanks, Don.  Any thoughts from anyone moving from the standard UniObjects to 
UniObjects for .NET?
- Dave

-Original Message-
From: [EMAIL PROTECTED]

I have a project that I'm using it for right now.  So far, it's working O.K.  It does 
take a bit of getting used to after using the UniObjects for Java stuff via .Net, but 
I hope to have this current project running by next Monday.  It's a simple thing that 
will just build a set of records and move them over to a sql server for further 
processing by another program.  

Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett & Dunner LLP
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Has anyone tried UniObjects for .NET?

2004-10-14 Thread gerry
has uo.net been released with uv pe yet ?


- Original Message - 
From: "Donald Kibbey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 14, 2004 10:52 am
Subject: Re: [U2] Has anyone tried UniObjects for .NET?


> I have a project that I'm using it for right now.  So far, it's working
O.K.  It does take a bit of getting used to after using the UniObjects for
Java stuff via .Net, but I hope to have this current project running by next
Monday.  It's a simple thing that will just build a set of records and move
them over to a sql server for further processing by another program.
>
>
>
>
> Don Kibbey
> Financial Systems Manager
> Finnegan, Henderson, Farabow, Garrett & Dunner LLP
>
>
> >>> [EMAIL PROTECTED] 10/14/04 10:44AM >>>
> Hi,
>
> Just wondering if anyone has had a chance to try then new UniObjects for
..NET?
>
> If so:
> What are your thoughts pro & con?
> Any bugs to keep in mind?
> Anything else?
>
> Thanks in advance!
> - Dave
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Strange Select Results?

2004-10-14 Thread Rod Hills
Could it be because "STATUS" is a keyword?

-Original Message-
From: Mats Carlid [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 14, 2004 7:09 AM
To: [EMAIL PROTECTED]
Subject: Re: [U2] [UV] Strange Select Results?

I've never seen select reuturn status -1 except when there is a syntax 
error in
the select command  -  so  try  rerunning without hush  or  run the
select from the tcl   to capture the error messages  - if any.

HTH
-- mats

Bjorn Behr wrote:

>Why when I execute this:
>
>EXECUTE Tcl CAPTURING SelectX Returning SelectY
>
>do I get this?
>
>:: Tcl/
>
>STRING: T r L=64 `SELECT PU.SHIP.TIMES WITH ITEM = "336DB-1.1/2" AND
STATUS
><= "4"'
>
>:: SelectX/
>
>STRING: T r L=73 `~1 record(s) selected to SELECT list #0.'
>
>:: SelectY/
>
>NUMBER: -1
>
>
>Should SelectY not equal 1?
>PS: It should select 1!
>
>System Information:
>O/S: Windows 2003
>UV : UniVerse 10.1
>___
_
>Regards
>Bjvrn Behr
>Programmer
>
>HYFLO Southern Africa (Pty) Ltd
>Tel : +27 11 386 5800
>Fax : +27 11 444 5391
>Mail: [EMAIL PROTECTED]
>WWW : http://www.hyflo.co.za
>___
_ 
>---
>u2-users mailing list
>[EMAIL PROTECTED]
>To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Has anyone tried UniObjects for .NET?

2004-10-14 Thread Donald Kibbey
I have a project that I'm using it for right now.  So far, it's working O.K.  It does 
take a bit of getting used to after using the UniObjects for Java stuff via .Net, but 
I hope to have this current project running by next Monday.  It's a simple thing that 
will just build a set of records and move them over to a sql server for further 
processing by another program.  




Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett & Dunner LLP


>>> [EMAIL PROTECTED] 10/14/04 10:44AM >>>
Hi,

Just wondering if anyone has had a chance to try then new UniObjects for ..NET?  

If so:
What are your thoughts pro & con?  
Any bugs to keep in mind?  
Anything else?

Thanks in advance!
- Dave
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Strange Select Results?

2004-10-14 Thread Peter Olson
check the dict's at tcl... i'v seen -1 come back when there was a bad
dict... 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Mats Carlid
Sent: Thursday, October 14, 2004 10:09 AM
To: [EMAIL PROTECTED]
Subject: Re: [U2] [UV] Strange Select Results?


I've never seen select reuturn status -1 except when there is a syntax 
error in
the select command  -  so  try  rerunning without hush  or  run the
select from the tcl   to capture the error messages  - if any.

HTH
-- mats

Bjorn Behr wrote:

>Why when I execute this:
>
>EXECUTE Tcl CAPTURING SelectX Returning SelectY
>
>do I get this?
>
>:: Tcl/
>
>STRING: T r L=64 `SELECT PU.SHIP.TIMES WITH ITEM = "336DB-1.1/2" AND STATUS
><= "4"'
>
>:: SelectX/
>
>STRING: T r L=73 `~1 record(s) selected to SELECT list #0.'
>
>:: SelectY/
>
>NUMBER: -1
>
>
>Should SelectY not equal 1?
>PS: It should select 1!
>
>System Information:
>O/S: Windows 2003
>UV : UniVerse 10.1
>
>Regards
>Bjvrn Behr
>Programmer
>
>HYFLO Southern Africa (Pty) Ltd
>Tel : +27 11 386 5800
>Fax : +27 11 444 5391
>Mail: [EMAIL PROTECTED]
>WWW : http://www.hyflo.co.za
> 
>---
>u2-users mailing list
>[EMAIL PROTECTED]
>To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately. 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Has anyone tried UniObjects for .NET?

2004-10-14 Thread Dave Tabor
Hi,

Just wondering if anyone has had a chance to try then new UniObjects for .NET?  

If so:
What are your thoughts pro & con?  
Any bugs to keep in mind?  
Anything else?

Thanks in advance!
- Dave
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Strange Select Results?

2004-10-14 Thread Mats Carlid
I've never seen select reuturn status -1 except when there is a syntax 
error in
the select command  -  so  try  rerunning without hush  or  run the
select from the tcl   to capture the error messages  - if any.

HTH
-- mats
Bjorn Behr wrote:
Why when I execute this:
EXECUTE Tcl CAPTURING SelectX Returning SelectY
do I get this?
:: Tcl/
STRING: T r L=64 `SELECT PU.SHIP.TIMES WITH ITEM = "336DB-1.1/2" AND STATUS
<= "4"'
:: SelectX/
STRING: T r L=73 `~1 record(s) selected to SELECT list #0.'
:: SelectY/
NUMBER: -1
Should SelectY not equal 1?
PS: It should select 1!
System Information:
O/S: Windows 2003
UV : UniVerse 10.1

Regards
Bjvrn Behr
Programmer
HYFLO Southern Africa (Pty) Ltd
Tel : +27 11 386 5800
Fax : +27 11 444 5391
Mail: [EMAIL PROTECTED]
WWW : http://www.hyflo.co.za
 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Memresize failed

2004-10-14 Thread Timothy Snyder
kafsat taiyus <[EMAIL PROTECTED]> wrote on 10/14/2004
07:05:37 AM:

> Everything is getting in over001.  I tried TYPE 0, TYPE 1, mod,sep
181061,16
> (suggestion from guide) and 362137, 8 still the result is same,
everything
> is going to over001.  What else can I try to get a better file?

Sometimes changing the split/merge type to KEYDATA can help address this.

Tim Snyder
IBM Information Management
Consulting I/T Specialist , U2 Professional Services
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UD] BASIC COMPILE ERROR: Too many constants near line

2004-10-14 Thread TPellitieri
> Date: Thu, 14 Oct 2004 09:49:24 +1000
> From: Craig Bennett <[EMAIL PROTECTED]>
>
> > Cant it be read ONCE and put into one (or more) named common
> > variables?
>
> I could do that, but I am trying to have the data cached by
> a process (object loaded) without having to read the data.

I don't remember if you've said what O/S you're using, but I have a font
load coded with a "PCPERFORM" to have our AIX system send the font
definitions to the printer before starting printing from BASIC.

The file contains the exact data stream needed to set up the font.  I use
the following BASIC statement in UniData to send it:

* QUEUE = AIX Print Queue
* FONTFILE = Full Path Name of Font File, e.g. "/usr/local/myfont"
*
  PCPERFORM "lp -d ":QUEUE:" ":FONTFILE CAPTURING MSG

Hope this might help...

--Tom Pellitieri
  Century Equipment
  Toledo, Ohio
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2][UD] INPUT @ functionality

2004-10-14 Thread Nick Cipollina
I ran into this before also.  What I ended up doing was CRT @(column,row): ;
INPUT ANS

For some reason, the INPUT @ would not work, and I think it was when column
exceeded row.



Thanks,



Nick Cipollina



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bjxrn Jxrnvig
Sent: Thursday, October 14, 2004 7:58 AM
To: [EMAIL PROTECTED]
Subject: [U2][UD] INPUT @ functionality



Hi



A customer of ours have gone from PI/Open to Unidata and have a problem with

the INPUT @ basic statement that has an other functionality in PI/OPEN and

UniVerse.



Has anyone a routine we can replace the INPUT @ with





Regards



Bjorn Jornvig

---

u2-users mailing list

[EMAIL PROTECTED]

To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2][UD] INPUT @ functionality

2004-10-14 Thread Bjørn Jørnvig
Hi

A customer of ours have gone from PI/Open to Unidata and have a problem with
the INPUT @ basic statement that has an other functionality in PI/OPEN and
UniVerse.

Has anyone a routine we can replace the INPUT @ with


Regards

Bjorn Jornvig
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] RE: Memresize failed

2004-10-14 Thread Lance Jahnke
Do you have the disk space for the swap/temp file that the resize command
creates?


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Sent: Thu Oct 14 05:06:33 2004
Subject: [U2] RE: Memresize failed

I found it does not like the mod 181061, sep 16.  It works for a smaller
file. But don't know why.


Regards
Kafsat



-Original Message-
From: kafsat taiyus
Sent: Thursday, 14 October 2004 7:36 PM
To: '[EMAIL PROTECTED]'
Subject: Memresize failed

Hi,

We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a 1.7GB
static file to dynamic and getting following error.

memresize TRANSACTION.DETAILS 181061,1>
Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory =
26214 (k)  restore
errno=27: File too large
CREATE.FILE failed.
Cannot create temp file, RESIZE failed.
memresize failed.

I have tried with different memory parameter it got the same error.  I tried
this command on a different machine it works on that machine.  Does anyone
know what the problem is and how to fix it?

Thanking you in anticipation.

Regards
Kafsat


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]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Memresize failed

2004-10-14 Thread kafsat taiyus
Thank you Radoslaw, 

I actually missed the key word dynamic.  Now the command is working but I
don't like the resulting dynamic file.  The static file was 1.7 GB the
dynamic file is now 

1073741824 Oct 14 18:58 dat001
1073741824 Oct 14 19:01 dat002
819167232 Oct 14 19:03 dat003
1676189696 Oct 14 19:03 over001
8192 Oct 14 18:56 over002
8192 Oct 14 18:56 over003

Everything is getting in over001.  I tried TYPE 0, TYPE 1, mod,sep 181061,16
(suggestion from guide) and 362137, 8 still the result is same, everything
is going to over001.  What else can I try to get a better file?

Regards
Kafsat


-Original Message-
From: Radoslaw Ryckowski [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 14 October 2004 8:25 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] Memresize failed

W liEcie z czw, 14-10-2004, godz. 11:36, kafsat taiyus pisze: 
Hello
You must have big enough free space in temp directory

regards,
Radoslaw 

> Hi,
> 
> We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a 1.7GB
> static file to dynamic and getting following error.
> 
> memresize TRANSACTION.DETAILS 181061,1>
> Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory =
> 26214 (k)  restore
> errno=27: File too large
> CREATE.FILE failed.
> Cannot create temp file, RESIZE failed.
> memresize failed.
> 
> I have tried with different memory parameter it got the same error.  I
tried
> this command on a different machine it works on that machine.  Does anyone
> know what the problem is and how to fix it?
> 
> Thanking you in anticipation.
> 
> Regards
> Kafsat
> 
> 
> 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]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

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


Re: [U2] Memresize failed

2004-10-14 Thread TVankirk
Hello. 
Your are missing "DYNAMIC" on the end of your memresize command, 
it is trying to create a "static" 2,966,503,424 size file. It fails at 
alittle over 2 gig and your at nearly 3 gig. Rerun with: memresize 
TRANSACTION.DETAILS 181061,1 DYNAMIC.






kafsat taiyus <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/14/2004 05:36 AM
Please respond to u2-users
 
To: "'[EMAIL PROTECTED]'" 
<[EMAIL PROTECTED]>
cc: 
Subject:[U2] Memresize failed


Hi,

We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a 1.7GB
static file to dynamic and getting following error.

memresize TRANSACTION.DETAILS 181061,1>
Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory =
26214 (k)  restore
errno=27: File too large
CREATE.FILE failed.
Cannot create temp file, RESIZE failed.
memresize failed.

I have tried with different memory parameter it got the same error.  I 
tried
this command on a different machine it works on that machine.  Does anyone
know what the problem is and how to fix it?

Thanking you in anticipation.

Regards
Kafsat


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]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] RE: [UD] Memresize failed

2004-10-14 Thread James.E.Hogan
"memresize TRANSACTION.DETAILS 181061,1>
Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory
=
26214 (k)  restore
errno=27: File too large
CREATE.FILE failed.
Cannot create temp file, RESIZE failed.
memresize failed."

You have specified a file size larger than 2 gigabytes 181061 * 16 *
1024. You should use a smaller modulo, or convert your file to a dynamic
file type that allows files larger than 2 gig.

James Hogan
Sungard
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] RE: Memresize failed

2004-10-14 Thread Adrian Matthews
Too large a file for your Unix settings perhaps.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of kafsat taiyus
Sent: 14 October 2004 11:07
To: '[EMAIL PROTECTED]'
Subject: [U2] RE: Memresize failed

I found it does not like the mod 181061, sep 16.  It works for a smaller
file. But don't know why.


Regards
Kafsat



-Original Message-
From: kafsat taiyus 
Sent: Thursday, 14 October 2004 7:36 PM
To: '[EMAIL PROTECTED]'
Subject: Memresize failed

Hi,

We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a
1.7GB
static file to dynamic and getting following error.

memresize TRANSACTION.DETAILS 181061,1>
Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory
=
26214 (k)  restore
errno=27: File too large
CREATE.FILE failed.
Cannot create temp file, RESIZE failed.
memresize failed.

I have tried with different memory parameter it got the same error.  I
tried
this command on a different machine it works on that machine.  Does
anyone
know what the problem is and how to fix it?

Thanking you in anticipation.

Regards
Kafsat


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


The information contained in this email is strictly confidential and for the use of 
the addressee only, unless otherwise indicated. If you are not the intended recipient, 
please do not read, copy, use or disclose to others this message or any attachment. 
Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 
0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that 
do not relate to the official business of this company shall be understood as neither 
given nor endorsed by it.  IG Markets Limited and IG Index Plc are authorised and 
regulated by the Financial Services Authority and, in Australia, by the Australian 
Securities and Investments Commission.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Memresize failed

2004-10-14 Thread kafsat taiyus
Please ignore my mails.  I missed keyword DYNAMIC in my command.

Regards
Kafsat

-Original Message-
From: kafsat taiyus [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 14 October 2004 7:36 PM
To: '[EMAIL PROTECTED]'
Subject: [U2] Memresize failed

Hi,

We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a 1.7GB
static file to dynamic and getting following error.

memresize TRANSACTION.DETAILS 181061,1>
Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory =
26214 (k)  restore
errno=27: File too large
CREATE.FILE failed.
Cannot create temp file, RESIZE failed.
memresize failed.

I have tried with different memory parameter it got the same error.  I tried
this command on a different machine it works on that machine.  Does anyone
know what the problem is and how to fix it?

Thanking you in anticipation.

Regards
Kafsat


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

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


Re: [U2] Memresize failed

2004-10-14 Thread Radosław Ryckowski
W liEcie z czw, 14-10-2004, godz. 11:36, kafsat taiyus pisze: 
Hello
You must have big enough free space in temp directory

regards,
Radoslaw 

> Hi,
> 
> We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a 1.7GB
> static file to dynamic and getting following error.
> 
> memresize TRANSACTION.DETAILS 181061,1>
> Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory =
> 26214 (k)  restore
> errno=27: File too large
> CREATE.FILE failed.
> Cannot create temp file, RESIZE failed.
> memresize failed.
> 
> I have tried with different memory parameter it got the same error.  I tried
> this command on a different machine it works on that machine.  Does anyone
> know what the problem is and how to fix it?
> 
> Thanking you in anticipation.
> 
> Regards
> Kafsat
> 
> 
> 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]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] RE: Memresize failed

2004-10-14 Thread kafsat taiyus
I found it does not like the mod 181061, sep 16.  It works for a smaller
file. But don't know why.


Regards
Kafsat



-Original Message-
From: kafsat taiyus 
Sent: Thursday, 14 October 2004 7:36 PM
To: '[EMAIL PROTECTED]'
Subject: Memresize failed

Hi,

We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a 1.7GB
static file to dynamic and getting following error.

memresize TRANSACTION.DETAILS 181061,1>
Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory =
26214 (k)  restore
errno=27: File too large
CREATE.FILE failed.
Cannot create temp file, RESIZE failed.
memresize failed.

I have tried with different memory parameter it got the same error.  I tried
this command on a different machine it works on that machine.  Does anyone
know what the problem is and how to fix it?

Thanking you in anticipation.

Regards
Kafsat


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


[U2] Memresize failed

2004-10-14 Thread kafsat taiyus
Hi,

We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a 1.7GB
static file to dynamic and getting following error.

memresize TRANSACTION.DETAILS 181061,1>
Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory =
26214 (k)  restore
errno=27: File too large
CREATE.FILE failed.
Cannot create temp file, RESIZE failed.
memresize failed.

I have tried with different memory parameter it got the same error.  I tried
this command on a different machine it works on that machine.  Does anyone
know what the problem is and how to fix it?

Thanking you in anticipation.

Regards
Kafsat


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


RE: [U2] writeseq

2004-10-14 Thread Brian Leach
Dave,

Use WriteBlk rather than WriteSeq.

Brian. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Raven
Sent: 13 October 2004 23:17
To: [EMAIL PROTECTED]
Subject: [U2] writeseq 

I am using a writeseq to build a record for flat file, I have 5 to 15000
records I am build into one item, after each record I append it to the flat
file item however there is a blank line appended each time it writes ? Is
there a way to omit the blank line when it writes?

Thanks

D Raven
e Fax (815)4259364
P.O. Box 17811, Irvine CA 92623-7811
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


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