dbTalk Databases Forums  

Howto determine Universe file-type?

comp.databases.pick comp.databases.pick


Discuss Howto determine Universe file-type? in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MikeYates
 
Posts: n/a

Default Howto determine Universe file-type? - 08-05-2010 , 05:27 AM






Hi
I did years on Ultimate, then D3, now I'm back into it with Universe
10.2
I have a little tool which looks at and into files that I'm porting
from D3.
One of the many issues is display of modulo, sep and overflow % if
hashed
but that data is not in the Universe VOC, just STAT.FILE and in the
main production accounts
it seems that ACCOUNT.FILE.STATS is broken (not my job to fix).
Is there an easy way to determine at least the file type?

Reply With Quote
  #2  
Old   
Ed Sheehan
 
Posts: n/a

Default Re: Howto determine Universe file-type? - 08-05-2010 , 07:48 AM






Try FILE.STAT

Ed

"MikeYates" <myates23 (AT) gmail (DOT) com> wrote

Quote:
Hi
I did years on Ultimate, then D3, now I'm back into it with Universe
10.2
I have a little tool which looks at and into files that I'm porting
from D3.
One of the many issues is display of modulo, sep and overflow % if
hashed
but that data is not in the Universe VOC, just STAT.FILE and in the
main production accounts
it seems that ACCOUNT.FILE.STATS is broken (not my job to fix).
Is there an easy way to determine at least the file type?

Reply With Quote
  #3  
Old   
MikeYates
 
Posts: n/a

Default Re: Howto determine Universe file-type? - 08-05-2010 , 09:30 AM



On 5 Aug, 13:48, "Ed Sheehan" <NOedsS... (AT) xmission (DOT) com> wrote:
Quote:
Try FILE.STAT
No, that doesn't tell you which non-hashed type a file may be:-

Quote:
file.stat BP
Cannot process type 1, 19, 25 or 30 file "/data/MYACC/BP"

and gives too much information on hashed types,
taking far too long on large files.

However,

EXECUTE 'FILE.STAT ':FNME CAPTURING STS
IF STS[1,7] = 'Cannot ' THEN
CRT 'This is a non-hashed,':STS[15,LEN(STS)-15]
END ELSE
FOR L = 1 TO DCOUNT(STS,CHAR(254))
CRT STS<L>
NEXT L
END

is a good start, thanks!.


Quote:
Ed

"MikeYates" <myate... (AT) gmail (DOT) com> wrote in message

news:02c3463f-c26c-4dd1-867f-90e692580370 (AT) l14g2000yql (DOT) googlegroups.com...

Hi
I did years on Ultimate, then D3, now I'm back into it with Universe
10.2
I have a little tool which looks at and into files that I'm porting
from D3.
One of the many issues is display of modulo, sep and overflow % if
hashed
but that data is not in the Universe VOC, just STAT.FILE and in the
main production accounts
it seems that ACCOUNT.FILE.STATS is broken (not my job to fix).
Is there an easy way to determine at least the file type?

Reply With Quote
  #4  
Old   
Pickie
 
Posts: n/a

Default Re: Howto determine Universe file-type? - 08-05-2010 , 08:26 PM



There is a BASIC function FILEINFO()
You can also use the STATUS statement. They give a mix of the same
and different information.

There are programs to make these available as TCL commands in Pickwiki

http://www.pickwiki.com/cgi-bin/wiki.pl?FileStatus

http://www.pickwiki.com/cgi-bin/wiki.pl?FileInfo


Regards, Keith

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.