RE: [U2] SB Client 5.0 and XP SP2

2004-12-16 Thread kafsat taiyus
Add the user to the power user group that should work.

Regards
Kafsat


-Original Message-
From: P. Eghbal [mailto:[EMAIL PROTECTED] 
Sent: Friday, 17 December 2004 6:37 AM
To: [EMAIL PROTECTED]
Subject: [U2] SB Client 5.0 and XP SP2

After installation of SB Client, the administrator can
run it fine, but a domain user gets a message that
"Ardent Software\.\TU is not a valid acct."

Has anyone seen/been able to resolve this?

TIA,
Paul




__ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com 
---
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] Index problem

2004-11-09 Thread kafsat taiyus
Thank you Ken,

We have modified the subroutine according to your suggestions. It is working
as expected.

Thank you again for your help.

Regards
Kafsat



-Original Message-
From: Ken Wallis [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 November 2004 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Index problem

Kafsat,

I believe that if you pass the record data into the subroutine as a
parameter using @RECORD instead of re-reading it from the file, then you
will have a better chance of getting the behaviour you want:

V
SUBR("KAFSATS",@ID,@RECORD,OTHERSTUFF)
...

SUBROUTINE KAFSATS(RESULT, REC_ID, REC_DATA, OTHERSTUFF)
...
RETURN
END

Cheers,

Ken

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of kafsat taiyus
> Sent: Thursday, 4 November 2004 11:00 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: [U2] Index problem
>
>
> Thank you everybody for all your answers.
>
> I have used debug and stepped though the subroutine.  While
> adding a new
> record the program is reading the new non existing record
> from the same file
> and not returning anything for the virtual field.  This is
> one reason for
> not updating the index in the first place.
>
> I have tried to write same record twice with the same ID
> overwriting the
> existing record.  In this case the subroutine return the
> correct value but
> the index still does not get updated.
---
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] Index problem

2004-11-03 Thread kafsat taiyus
Thank you everybody for all your answers.  

I have used debug and stepped though the subroutine.  While adding a new
record the program is reading the new non existing record from the same file
and not returning anything for the virtual field.  This is one reason for
not updating the index in the first place.

I have tried to write same record twice with the same ID overwriting the
existing record.  In this case the subroutine return the correct value but
the index still does not get updated.

I have located following text from the documentations "A virtual attribute
that contains a TRANS statement to another file, or the same file, is not a
recommended use of an alternate key index, unless the file being translated
to does not change. If the file being translated to does change, the
alternate key index is not updated. Therefore, to obtain accurate results
from a UniQuery statement, the alternate key index would need to be rebuilt
each time the associated file is updated." 

Our problem is actually similar to Martin's birth year calculation example.
The subroutine is looking at the same file for data.  I understand the
problem now.  We should be able to implement a work around.

Thank you again.

Regards
Kafsat 


 

-Original Message-
From: Alfke, Colin [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 November 2004 6:06 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Index problem

I believe it's even in the documentation that UniData will only update an
index on the file that is being updated and not any other files that may
have an index that references that file.

Another work around is to have a trigger on the header file re-file the
detail items that reference it so that the index is properly updated. I'm
not sure if you'll have to "change" the detail item or not for it to cause
the index to be updated.

hth
Colin Alfke
Calgary - soon to head to LA

>-Original Message-
>From: Warren, Phil [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, November 03, 2004 7:25 AM
>To: '[EMAIL PROTECTED]'
>Subject: RE: [U2] Index problem
>
>
>We've run into a similar problem with virtual attributes that reference
>other files in all versions of UniData through to version 
>6.0.8.  I wonder
>if this might be a similar 'anomaly'
>
>For example, 
>In our case we have 2 order files, named HEADER and DETAIL.  A virtual
>attribute exists in the DETAIL file which references the HEADER file.
>When the DETAIL record(s) are written out before the HEADER 
>record, UniData
>does not update the DETAIL index when the HEADER file is 
>written, causing a
>null value when the DETAIL index is used.  As in your case, 
>when another
>attribute is used, to select the DETAIL file, which does not 
>use the index,
>the items are selected as expected.
>
>The only work around that we've used, is to rebuild the index 
>file daily.
>Perhaps there is a better work around or fix?
>
>-Phil-
---
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/


[U2] Index problem

2004-11-02 Thread kafsat taiyus
We have one Unidata 5.1 data file with a virtual attribute. The virtual
dictionary calls a Unibasic subroutine and returns a single value data from
a multi value attribute from within the same file.

We have an index on the virtual attribute.  When new records are added to
the file Unidata does not update the index on the virtual attribute. 

After adding new records that returns XXX for the virtual attribute the
command LIST FILE_NAME WITH VIRTUAL_ATT = "XXX" does not return any record.


But the command LIST FILE_NAME NO.INDEX WITH VIRTUAL_ATT = "XXX" finds the
record.

The command LIST FILE_NAME WITH VIRTUAL_ATT = "XXX" works only after
rebuilding the index using REBUILD.INDEX command.

Do you know why is it happening and how to fix it?

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

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


[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][UD] Create file/record if it does not exist

2004-09-20 Thread kafsat taiyus
With OPENSEQ THEN is true if the record exists.  Else is ELSE when the
record does not exists.  ELSE does not mean an open error. Open error can be
checked from ON ERROR section.

Try something like

OPENSEQ "_HOLD_", "XHR.PLINK.BENDED.EXTRACT" TO f.xhr.plink.bended.extract
THEN

Code section when "XHR.PLINK.BENDED.EXTRACT" exists in "_HOLD_" file
ELSE
section when "XHR.PLINK.BENDED.EXTRACT" does not exists in "_HOLD_" 
END

Regards
Kafsat




-Original Message-
From: Chauhan, Savita [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 21 September 2004 7:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2][UD] Create file/record if it does not exist

This is how I open my file. 
X.EXT.FILE = '_HOLD_/XHR.PLINK.BENDED.EXTRACT'
OPENSEQ X.EXT.FILE TO f.xhr.plink.bended.extract ELSE
ERR.MSG = "Error Opening XHR.PLINK.BENDED.EXTRACT. Error code
":STATUS()
CRT ERR.MSG
RETURN
END

This code aborts with a status() of 0 if the file/record doesn't exist
under the _HOLD_ dicrecotry.
The successful read is 0 too. 

So I don't know how to check the existence or non-existence of this
file/record.

Please help.
Thanks.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Monday, September 20, 2004 2:16 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2][UD] Create file/record if it does not exist

Have you tried using the ELSE clause with the OPENSEQ? That's how I
usually do it.


 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita
Sent: Monday, September 20, 2004 1:44 PM
To: [EMAIL PROTECTED]
Subject: [U2][UD] Create file/record if it does not exist

Hi,

Is there a UniBasic command which will let me do the following:

-- Open a seq file. If it does not exist then create one and open
it. ---

The seq file that I want to create/open is in the _HOLD_ directory, so
its kinda record in the _HOLD_ file.

I thot of working with the STATUS code returned by OPENSEQ. But, it
returns a 0 if the record does not exist and the same 0 if it's a
successful open!!

How do I check the existence of this record/file?

Thanks.
---
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/

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] UniDebugger won't let me in.

2004-09-15 Thread kafsat taiyus
Permission on the source code.



-Original Message-
From: Shawn Waldie [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 16 September 2004 7:50 AM
To: [EMAIL PROTECTED]
Subject: [U2] UniDebugger won't let me in.

I can log in using wintegrate, and I can even telnet in, but an error
message is returned stating "invalid username or password" when I try to
access my source code using unidebugger.

Any suggestions on where to look first?

TIA

* Shawn WaldieSan Juan College *
* Programmer/Analyst 4601 College Blvd *
* Phone: (505)566-3072   Farmington, NM  87402 *
*  email: [EMAIL PROTECTED]   *
*  *
* HP-UX 11.11   UniData 6.0.4Colleague R17 *

---
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][UD] ODBC to UniData

2004-09-10 Thread kafsat taiyus
Savita,

Log in to the server using the user name, you are using in your ODBC
connection.  Make sure you can change directory to
/datatel/development/coldev if it is not already the home directory.  Define
unidata environment variable it is already not in the login script. Use udt
command to go into unidata if the login script does not do it.  Use command
like "SQL SELECT * FROM filename" to make sure you have privilege etc. on
the file.

Then try ODBC from Access.

Regards
Kafsat



-Original Message-
From: Louis Guillaume [mailto:[EMAIL PROTECTED] 
Sent: Friday, 10 September 2004 4:19 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2][UD] ODBC to UniData

Chauhan, Savita wrote:

> Hi,
> 
> I have been trying to connect to our UniData server via ODBC. 
> It connects fine to the demo database. 
> But when I try to connect to my own test database from MS-Access or VSG,
> it gives an error message "You don't have permissions to chdir to
> /datatel/development/coldev" !!
> 
> I create files using Envision API from Datatel in the DEVelopment
> account/database (/datatel/development/coldev).
> 
> The entry in my ud_database file looks like this:
> 
> DATABASE=demo
> UDTHOME=/usr/ud52
> UDTACCT=/usr/ud52/demo
> TRACE_LEVEL=0
> 
> DATABASE=test_db
> UDTHOME=/usr/ud52
> UDTACCT=/datatel/development/coldev
> TRACE_LEVEL=0
> 
> I have been fiddling around with so many things, changing permissions on
> files, changing the ownership, etc, as suggested by a few people; but
> nothing seems to work!!!
> 
> Do I have to make some change/entry in some other file too for me to be
> able to access the DEV account/database via ODBC?
> 
> Can someone tell me what am I doing wrong?
> 
> Thanks.

This should be in an FAQ somewhere...

The user who runs unirpcd must be a member of the group that owns the 
database. I believe user permissions are ignored.

For example...

unirpcd is running as root.
the database you're trying to access is /datatel/development/coldev
the permissions on coldev are Owner:datatel Group:cdev Perms:770

root MUST be a member of the "cdev" group.

Note the lack of access control unless you set up good views and privileges!

Hope that helps,

Louis

--
Louis Guillaume
Berklee College of Music
---
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] How do we identify process running PORT-STATUS?

2004-09-09 Thread kafsat taiyus
In UNIX Try

ps -ef | grep PORT.STATUS
Or
ps -ef | grep POST_STATUS

Regards
Kafsat




-Original Message-
From: Eves, David [mailto:[EMAIL PROTECTED] 
Sent: Friday, 10 September 2004 11:10 AM
To: U2-Users List
Subject: [U2] How do we identify process running PORT-STATUS?

Universe Version 10.0.8, Tru64 Unix v.5.1a

We are currently experiencing network issues that are causing user
sessions to spontaneously disconnect.  When using PORT-STATUS in our uv
account we get the following message:

PORT.STATUS is currently being run by another user, try again later.

which is fine except that we can't identify which user is running the
process.  We can't use UniAdmin as User display requires PORT-STATUS and
so returns a blank list.

Does anybody have any clues on how to identify the unix process which is
executing the PORT-STATUS command so that we can kill it and get use of
the command back?

Cheers,
David Eves
---
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] Priorities for Unix udt processes

2004-08-03 Thread kafsat taiyus
I have used nice for Unidata on HPUX many times and never had any problem.
Renice is the command to change nice level. Use "man renice" to get help on
the command.  While using renice command just make sure to use correct pid
for the process.  

Another command you may want to have a look is "kill" with correct parameter
you can practically stop a low priority process to stop processing and give
high priority process more resources, and start the process again when high
priority process is done.  Use "man kill" for details.   


Regards
Kafsat


-Original Message-
From: Jonathan Leckie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 3 August 2004 9:13 PM
To: [EMAIL PROTECTED]
Subject: [U2] Priorities for Unix udt processes

Does anyone have any experience of what the "nice" and "priority" values
should be and how they can be changed?



-- 


* This message has been scanned for viruses and dangerous content by  
* Blairs of Scotland MailScanner, and is believed to be clean.
*   
* This email and any files transmitted with it are confidential and 
* intended solely for the use of the individual or entity to which they
* are addressed.
*
* If you have received this email in error please notify us at Blairs
* of Scotland via email at [EMAIL PROTECTED]

---
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] UniVerse barcode generation

2004-05-23 Thread kafsat taiyus
I have used software called Unibar to generate barcode from Unidata.  It
works with all PCL 5 printers.  Have a look at this product at
http://www.unibar.com/ it might help.

Regards
Kafsat


-Original Message-
From: Ross Ferris [mailto:[EMAIL PROTECTED] 
Sent: Monday, 24 May 2004 10:56 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] UniVerse barcode generation

A lot will depend on the type of printer you are looking to use  dot
matrix ? epson compatible ? HP Laserjet style ? Perhaps a dedicated thermal
transfer printer from someone like Zebra ? or Monarch ? or 



Ross Ferris
Stamina Software
Visage  an Evolution in Software Development

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On Behalf Of Don Cutting
>Sent: Saturday, 22 May 2004 2:22 AM
>To: [EMAIL PROTECTED]
>Subject: [U2] UniVerse barcode generation
>
>We have a need to generate barcodes from our UniVerse system. We are
>running
>on AIX 5.2 and UniVerse 10.0.19.
>
>If you know of away to do this with the standard UniVerse tools or know of
>a
>3rd party product, which might meet our needs, please e-mail me direct at
>[EMAIL PROTECTED]
>
>Thank You!
>
>Donald Cutting
>A. N. Deringer, Inc.
>D. B. A. / Systems Analyst
>Tel.  (802)524-8172
>Fax. (802)524-8297
>[EMAIL PROTECTED]
>http://www.anderinger.com
>---
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.u2ug.org/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

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

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


RE: [U2] SB Problem - Urgent

2004-05-02 Thread kafsat taiyus









Thank you Susan,

 

I have fixed the problem and still trying
to understand what actually caused the problem.

 

Thank you for your help.

 

Regards

Kafsat

 

 

 

 

-Original Message-
From: Susan Lynch
[mailto:[EMAIL PROTECTED] 
Sent: Monday, 3 May 2004 1:04 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] SB Problem -
Urgent

 



In response to a message from: kafsat taiyus 





 





First, the problem looks
like data corruption, given the error messages shown.





 





Second, how to fix it:





 





- Make sure
all the users are logged off.





 





- Go to the SB directory
and run 





 





   
guide_51 DMCONT





 





    This
will produce a guide_errors file that will show you the    
        errors and will allow the fixfile command
to repair them:





 





- Run the fixfile command





 





   
fixfile -dDummyfile -f





 





    where
Dummyfile is a file name that is not used in your    
               
application - it will hold some output from the fixfile command
    when finished.





 





- Run another guide_51
DMCONT, and check the guide_errors file 





    to be
sure that there are no errors this time.





 





-  Repeat
fixfile and guide_51 if errors occur again.  Users can get on after 
you stop seeing errors in the guide_errors file.





 





Third, what causes data
structure errors?  There are a number of possible causes, including, but
not limited to, system crashes, hardware and power problems, someone using a
DOS or Windows or Unix text editor to change something in a UniData file
without understanding the underlying file and record structure issues, a static
file hitting the 2 gig limit, a file being restored from a damaged backup
medium, etc.  Given that it is DMCONT, and not likely to be maintained by
your application programs, I suspect that some of the other possible causes can
be ruled out, like users updating the file without proper locking, one user
doing a clear-file while someone else was updating the file. 





 





 Good luck getting
the system back up for your users!





Hi,

 

No body
can log in to SB+ error

 

   


Current
UniData home is /usr/ud52/. 

Current
working directory is /data1/rtime/SBPlus/SB.    

2:blk
check error in U_post_read for file 'DMCONT', key 'SB.ACCOUNTS', number=33

    

1:block
check error in modify_record for file 'DMCONT', key 'SB.ACCOUNTS', numbe

r=34816


1:block
check error in U_append_strtuple for file 'DMCONT', key 'SB.ACCOUNTS', n

umber=33   


Fatal
error: WRITE error  

 

 

Any idea
why this is happening and how to fix it?

 

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.


RE: [U2] SB Problem - Urgent

2004-05-02 Thread kafsat taiyus









Thank you Ken,

 

I realized it was corruption but got
confused when I checked the voc entry of DMCONT it looks something like

 

001: F   


002: ../D_DMCONT

003: ../D_DMCONT



And thought something else was wrong.

 

All fixed now.

 

Thank you for your help.

 

Regards

Kafsat

 

 

 

 

-Original Message-
From: Ken Wallis
[mailto:[EMAIL PROTECTED] 
Sent: Monday, 3 May 2004 12:45 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] SB Problem -
Urgent

 



Hi
Kafsat,





 





That
looks a lot like your DMCONT file has become corrupted.  Run guide -na -ns
against it and then look at the GUIDE_ERRORS.LIS before running fixfile -f if
there are errors.  How did it get like that?  Some sort of hard
shutdown?  kill -9 on a process that was updating the file?  even a
hardware memory error?





 





Try very
hard to stop anyone getting onto the system (at the UNIX level) while you sort
this out Kafsat.





 





Cheers,





 





Ken





No body
can log in to SB+ error

 

   


Current
UniData home is /usr/ud52/.     

Current
working directory is /data1/rtime/SBPlus/SB.   


2:blk
check error in U_post_read for file 'DMCONT', key 'SB.ACCOUNTS', number=33

  
 

1:block
check error in modify_record for file 'DMCONT', key 'SB.ACCOUNTS', numbe

r=34816


1:block
check error in U_append_strtuple for file 'DMCONT', key 'SB.ACCOUNTS', n

umber=33   


Fatal
error: WRITE error 


 

 

Any idea
why this is happening and how to fix it?










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] SB Problem - Urgent

2004-05-02 Thread kafsat taiyus









Hi,

 

No body
can log in to SB+ error

 

   


Current UniData
home is /usr/ud52/. 

Current working directory is
/data1/rtime/SBPlus/SB.    

2:blk check error
in U_post_read for file 'DMCONT', key 'SB.ACCOUNTS',
number=33

   


1:block check
error in modify_record for file 'DMCONT', key
'SB.ACCOUNTS', numbe

r=34816


1:block check
error in U_append_strtuple for file 'DMCONT', key
'SB.ACCOUNTS', n

umber=33  
 

Fatal error: WRITE error  

 

 

Any idea why this is happening and how to
fix it?

 

Regards

Kafsat

 


 

 

 






---This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses.

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.