dbTalk Databases Forums  

SELECTING a native file - liux D3

comp.databases.pick comp.databases.pick


Discuss SELECTING a native file - liux D3 in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
douglas@pickteam.com
 
Posts: n/a

Default SELECTING a native file - liux D3 - 09-13-2005 , 10:16 AM






I've just starting using linux files for easy import of large data
files. I can read and write to these files in BASIC and using the
editor if I know the exact name.

But for some reason I can't SELECT or LIST the items.

I've got an MD item like this... 001 Q,003 unix:\transfer

I'm pretty sure it's not permissions.

I think my problem has something to with there being no DICT portion of
the file, but I'm sure my fellow cdp friends can point me in the right
direction.

Thanks
Douglas Tatelman


Reply With Quote
  #2  
Old   
douglas@pickteam.com
 
Posts: n/a

Default Re: SELECTING a native file - liux D3 - 09-13-2005 , 10:17 AM






oops, looks like I spelled linux wrong in my subject.


Reply With Quote
  #3  
Old   
Tedd Scofield
 
Posts: n/a

Default Re: SELECTING a native file - liux D3 - 09-13-2005 , 10:24 AM



I've got an MD item like this... 001 Q,003 unix:\transfer

that slash looks backwards. try unix:/transfer


Reply With Quote
  #4  
Old   
Ross Ferris
 
Posts: n/a

Default Re: SELECTING a native file - liux D3 - 09-13-2005 , 10:30 AM



Said he can read/wrte in basic, so I'm assuming this was a transcriptin
typo :-)

However, if you have "lots" of items in file (directory) or even just a
few BIG items, and are applying ANY sort of criteria, or referencing
any attribute for printing, things can/will slow down DRASTICALLY as
the entire items have to be read in, and can slow to a crawl


Reply With Quote
  #5  
Old   
Frank Winans
 
Posts: n/a

Default Re: SELECTING a native file - linux D3 - 09-13-2005 , 11:40 AM



"Ross Ferris" wrote
Quote:
Said he can read/wrte in basic, so I'm assuming this was a transcriptin
typo :-)

However, if you have "lots" of items in file (directory) or even just a
few BIG items, and are applying ANY sort of criteria, or referencing
any attribute for printing, things can/will slow down DRASTICALLY as
the entire items have to be read in, and can slow to a crawl

Yes, OSFI tends to copy all the items into a bitbucket, which reeks. Just do
LIST ONLY unix:/tmp/mydir
or LIST ONLY C:/mydir {for the windoze crowd} and nothing fancier;
but you can offload some of that select/ fetch-n-format work to perl/awk
scripts. Or, there's a {rudimentary} freeware, java-based BASIC ...




Reply With Quote
  #6  
Old   
Scott Ballinger
 
Posts: n/a

Default Re: SELECTING a native file - liux D3 - 09-13-2005 , 11:57 AM



Doug,

Try this:

list only /transfer

or this:

list only unix:/transfer

You should see all files (including the dot files) but not directories.
If you are not seeing anything, then I suggest looking at permissions.
The D3 machine is usually running as user "pick". Does the following
work from tcl?

!ls /transfer

or:

sh
cd /transfer
ls

D3 is smart enough that if a file name starts with "/" the unix: is
assumed (and you don't need a q-pointer).

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006


Reply With Quote
  #7  
Old   
stefano
 
Posts: n/a

Default Re: SELECTING a native file - liux D3 - 09-14-2005 , 04:13 AM



douglas (AT) pickteam (DOT) com ha scritto:
Quote:
I've just starting using linux files for easy import of large data
files. I can read and write to these files in BASIC and using the
editor if I know the exact name.

But for some reason I can't SELECT or LIST the items.

I've got an MD item like this... 001 Q,003 unix:\transfer

I'm pretty sure it's not permissions.

I think my problem has something to with there being no DICT portion of
the file, but I'm sure my fellow cdp friends can point me in the right
direction.

Thanks
Douglas Tatelman

unix:\transfer -> unix:/transfer


Reply With Quote
  #8  
Old   
douglas@pickteam.com
 
Posts: n/a

Default Re: SELECTING a native file - liux D3 - 09-14-2005 , 09:37 AM



Thanks everyone.

Yes I did have the slash backwards in my post, but the MD item is
correct.
001 Q
002
003 unix:/transfer

Yes, Scott the ls works fine.

I guess I'm just used to the Universe enviroment where I can LIST and
SELECT at TCL (after building an @ID item).

It is funny that the SELECT returns no items present.


Reply With Quote
  #9  
Old   
Scott Ballinger
 
Posts: n/a

Default Re: SELECTING a native file - liux D3 - 09-14-2005 , 11:15 AM



Doug,

You should be able to LIST & SELECT linux directories from TCL in D3.

Here is an example:

:list /tmp

Page 1 /tmp

/tmp

..X0-lock
..fam_socket
..gdm_socket
jd_sockV4

[405] 4 items listed out of 4 items.

:select /tmp

[404] 4 items selected out of 4 items.

I can do this on all of my D3 7.4.0 (RH9) and 7.4.2 (RHEL) systems. If
list or select returns null then perhaps there is some permissions
issue (or the D3 system is not activated?).

/Scott


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.