Picon

RE: [U2] [Unix] creation date/time

Karl L Pearson wrote:

> The question was: Creation date and time, not last
accessed date and
> time. 

> On Mon, 2004-08-30 at 18:56, Ian McGowan wrote:
>> If your system doesn't have the stat or fstat command,
this small
>> program may do: 
>> 
>> #include <sys/stat.h>
>> main(int argc,char**argv) {
>>     struct stat buf;
>>     char d[256];
>>     stat(argv[1],&buf);
>>     strftime(d, sizeof(d), "%D",
localtime(&buf.st_ctime));    
>> printf("%s\n", d); }
>> 
>> (error checking removed)
>> 
>> Or a perl one-liner:-)
>> 
>> perl -e 'print scalar localtime((stat $ARGV[0])[9]),"\n"'
$filename

st_ctime is the date/time the inode last changed.  This is
equivalent to ls -lc except as Ian says, if it happened more
than a year ago, ls reports just the date, not the time.  As
(Continue reading)

Ian McGowan | 1 Sep 03:07 2004

RE: [U2] [Unix] creation date/time

> st_atime is the date/time the file was last accessed. 
> Nobody has yet suggested using this information Karl.  ls
> will report st_atime if you use the -u option "ls -lu". 
> Presumably "u" is for "used" since "-a" was already
> allocated a meaning.

And since this is basically useless information and requires a write every
time someone so much as looks at a file, the "noatime" option is typically
used as a mount option on systems that support it.  If you run any kind of
production linux or solaris server, it can help you eke out a small
performance gain (<10%).  Though you have to watch out for backup products
that may use that value (legato?) and HSM software that tries to move
infrequently accessed files to near-line storage.

http://www.faqs.org/docs/securing/chap6sec73.html
-------
u2-users mailing list
u2-users <at> listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

LeRoi Keiller | 1 Sep 05:13 2004
Picon
Picon

RE: [U2] How import data from UniVerse into MS Access?

Hi again.

I managed to get the ODBC link established to MS Access.  Now tables appear and can be linked or imported.  This
was achieved by doing, for example, SELECT * FROM BLAH followed by HS.UPDATE.FILEINFO.  Problem is, the
attributes don't appear in MS Access - only the records.

So I figured I'd do as was suggested and setup some  <at> SELECTs on the dictionaries and re-run
HS.UPDATE.FILEINFO.  I did this on a couple of dictionaries.  Problem is, now when I try to import into MS
Access, I get the following error just for those files that have  <at> SELECTs:

   "The Microsoft Jet database engine could not find the object 'NEWONE'.
   Make sure the object exists and that you spell its name and the path name correctly.
				[OK] [Help]"

Thoughts?

Below is the setup:

>CT DICT BLAH  <at> SELECT

      <at> SELECT
0001 PH
0002 INTO ALTER  <- the records I want

>CT BLAH * (to show you the records available)
     NUMERIC
0001 K
0002 73

     PRINT.ADMIN
(Continue reading)

asvin.dattani | 1 Sep 11:17 2004

[U2] Memo: Universe file size limit

Hi Everyone,

HPUX 11i running Universe 9.6  - does anyone know if there is a 4GB file
limit?

We have 64 bit files on a 64 bit file system, but one of these files grew
to over 4gb and blew up with an Internal Data Error on a BASIC write. I
thought that 64 bit files were supposed to be vv large...

thanks in advance....

************************************************************
HSBC Bank plc
Registered Office: 8 Canada Square, London E14 5HQ
Registered in England - Number 14259
Authorised and regulated by the Financial Services Authority

Member of the HSBC Bank marketing group. We sell life assurance, pensions
and collective investment schemes and advise only on our own range of these
products.
************************************************************

_____________________________________________________

This transmission has been issued by a member of the HSBC Group 
"HSBC" for the information of the addressee only and should not be 
reproduced and / or distributed to any other person. Each page attached 
hereto must be read in conjunction with any disclaimer which forms part 
of it. Unless otherwise stated, this transmission is neither an offer nor the 
solicitation of an offer to sell or purchase any investment. Its contents are 
(Continue reading)

Adrian Matthews | 1 Sep 12:45 2004
Picon

RE: [U2] Memo: Universe file size limit

Unix limitation? Perhaps something needs tweaking there.

-----Original Message-----
From: owner-u2-users <at> listserver.u2ug.org
[mailto:owner-u2-users <at> listserver.u2ug.org] On Behalf Of
asvin.dattani <at> hsbcib.com
Sent: 01 September 2004 10:18
To: u2-users <at> listserver.u2ug.org
Subject: [U2] Memo: Universe file size limit

Hi Everyone,

HPUX 11i running Universe 9.6  - does anyone know if there is a 4GB file
limit?

We have 64 bit files on a 64 bit file system, but one of these files
grew
to over 4gb and blew up with an Internal Data Error on a BASIC write. I
thought that 64 bit files were supposed to be vv large...

thanks in advance....

************************************************************
HSBC Bank plc
Registered Office: 8 Canada Square, London E14 5HQ
Registered in England - Number 14259
Authorised and regulated by the Financial Services Authority

Member of the HSBC Bank marketing group. We sell life assurance,
pensions
(Continue reading)

Bob Witney | 1 Sep 12:59 2004

RE: [U2] Memo: Universe file size limit

Surely if the standard Universe 32bit max file size is 2gb (2147483648 Bytes)

Then the 64bit would be 4gb (2147483648*2 Bytes)

Bob

-----Original Message-----
From: owner-u2-users <at> listserver.u2ug.org
[mailto:owner-u2-users <at> listserver.u2ug.org]On Behalf Of Adrian Matthews
Sent: 01 September 2004 11:46
To: u2-users <at> listserver.u2ug.org
Subject: RE: [U2] Memo: Universe file size limit

Unix limitation? Perhaps something needs tweaking there.

-----Original Message-----
From: owner-u2-users <at> listserver.u2ug.org
[mailto:owner-u2-users <at> listserver.u2ug.org] On Behalf Of
asvin.dattani <at> hsbcib.com
Sent: 01 September 2004 10:18
To: u2-users <at> listserver.u2ug.org
Subject: [U2] Memo: Universe file size limit

Hi Everyone,

HPUX 11i running Universe 9.6  - does anyone know if there is a 4GB file
limit?

We have 64 bit files on a 64 bit file system, but one of these files
grew
(Continue reading)

Rick Ramsey | 1 Sep 13:18 2004
Picon

RE: [U2] [PICK] File handle opened?

I believe this will work for you in D3:  IF ASSIGNED(FILEVAR) . . .
where FILEVAR is the file handle variable used in the OPEN statement

Rick Ramsey
Healthpac Cumputer Systems
Savannah,  GA

-----Original Message-----
From: Allen E. Elwood (CA) [mailto:aelwood <at> curnaynassoc.com] 
Sent: Tuesday, August 31, 2004 5:39 PM
To: u2-users <at> listserver.u2ug.org
Subject: [U2] [PICK] File handle opened?

I've done this in U2 before, but in a Raining Data Pick Env, does anyone
know how to interrogate a file handle to see if it has been properly
opened?

I'm writing a LOCK.RECORD subroutine with all kinds of nifty options and
it
would be nice to be able to not blow out to debugger if a handle is not
opened.  Even the ON ERROR clause will not stop it from blowing out if
the
file is unopened and you try to read, or if the file is opened and you
do
any BUT a file operation.

Thanks!
Allen
-------
u2-users mailing list
(Continue reading)

Rick Ramsey | 1 Sep 13:21 2004
Picon

RE: [U2] [PICK] File handle opened?

I forgot to mention - the FILEVAR will be considered to be ASSIGNED=TRUE
even if you've simply done a FILEVAR="" somewhere in the program.  The
key to this is never use the file handle variable name except for the
ASSIGNED or the various file-handling verbs.

Rick Ramsey
Healthpac Cumputer Systems
Savannah,  GA

-----Original Message-----
From: Rick Ramsey 
Sent: Wednesday, September 01, 2004 7:18 AM
To: 'u2-users <at> listserver.u2ug.org'
Subject: RE: [U2] [PICK] File handle opened?

I believe this will work for you in D3:  IF ASSIGNED(FILEVAR) . . .
where FILEVAR is the file handle variable used in the OPEN statement

Rick Ramsey
Healthpac Cumputer Systems
Savannah,  GA

-----Original Message-----
From: Allen E. Elwood (CA) [mailto:aelwood <at> curnaynassoc.com] 
Sent: Tuesday, August 31, 2004 5:39 PM
To: u2-users <at> listserver.u2ug.org
Subject: [U2] [PICK] File handle opened?

I've done this in U2 before, but in a Raining Data Pick Env, does anyone
know how to interrogate a file handle to see if it has been properly
(Continue reading)

Picon

RE: [U2] Memo: Universe file size limit

Hi Bob,

A 64bit file has a very large capacity. The 64 bit number is binary so
every bit = 1 greater power of 2. Whereas 2,147,483,648 = 2^31 then
9,223,372,036,854,775,808 = 2^63. A very big number indeed. The reason
it is 31 and 63 is that the leftmost bit generally signifies the sign of
the number, eg: whether it is a positive or a negative number. If it is
1 then it is negative, 0 is positive so it generally doesn't get used
when calculating the filepointers.

I'm not that familiar with HPUX, however I'd be checking out any
filesystem limitations there maybe. Depending on the filesystem you are
using, eg: UFS, XFS or JFS there could be limitations on the maximum
filesystem size. Check with your support people but Universe shouldn't
be giving you any problems. Admittedly we are running a version 10.0
system on Tru64 but we have files that are now in excess of 25Gb so it
really shouldn't be that.

Regards

David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
(Continue reading)

Claus Derlien | 1 Sep 13:48 2004
Picon

RE: [U2] Memo: Universe file size limit

> Surely if the standard Universe 32bit max file size is 2gb 
> (2147483648 Bytes)
> 
> Then the 64bit would be 4gb (2147483648*2 Bytes)

I guess more in the neighbourhood of 2^63 = 9223372036854775808 bytes

but nevermind, the limit for a 32 bit system on 2gb is stupid as you could
have used the full range of bits instead of using a signed integer, I can't
understand why cardinal types can't be used in filesystems, it may be a
problem with the cpu's, the good old motorola 68k never had those stupid
limitations. 

best regards from rainy Denmark

Claus Derlien

Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk

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


Gmane