dbTalk Databases Forums  

OpenQM for Windows Q-Pointers into the windows file system.

comp.databases.pick comp.databases.pick


Discuss OpenQM for Windows Q-Pointers into the windows file system. in the comp.databases.pick forum.



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

Default OpenQM for Windows Q-Pointers into the windows file system. - 07-31-2006 , 01:49 PM






How does one setup a q-pointer to a file in the windows system. For example,
say, c:\contacts ?



Reply With Quote
  #2  
Old   
B Faux
 
Posts: n/a

Default Re: OpenQM for Windows Q-Pointers into the windows file system. - 07-31-2006 , 03:54 PM







"Concerned Netizen" <nospam (AT) nospam (DOT) com> wrote

Quote:
How does one setup a q-pointer to a file in the windows system. For
example, say, c:\contacts ?


netizen-

OpenQM has multiple ways to "point" to a data file outside of QM.

You can create a 'Directory' type file using an explicit path within the
available file system, which will then be available within QMBasic using
normal Open, Read, Write commands, (see "CREATE-FILE" command.) Directory
type files have no dictionaries (VOCs) and cannot be reported upon using
English/Access from TCL.

Also you can specify a 'Q' type file pointer where attr<2>=Account or Path,
attr<3>=File name in Account, attr<4>=Server name (QMNet connections only).
I believe these will have Directory type file limitations, if they reside
outside the file system.

See OpenQM documentation for more details. Note: as with most MV flavors,
if you read data from an outside source, it is highly recommended to run an
'MCP' conversion (or equivalent) on the data before actually doing anything
with it inside the DBMS.

Hope that helps... If not, try the OpenQM forum on Google Groups.

BFaux




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

Default Re: OpenQM for Windows Q-Pointers into the windows file system. - 08-01-2006 , 12:22 AM





Thanks, I went over the documentation, but I don't seem to see if or how OpenQm could sort an existing directory. Can it?

--

"B Faux" <nospam (AT) nospam (DOT) net> wrote

Quote:
"Concerned Netizen" <nospam (AT) nospam (DOT) com> wrote in message
news:xgszg.140605$H71.62387 (AT) newssvr13 (DOT) news.prodigy.com...
How does one setup a q-pointer to a file in the windows system. For
example, say, c:\contacts ?



netizen-

OpenQM has multiple ways to "point" to a data file outside of QM.

You can create a 'Directory' type file using an explicit path within the
available file system, which will then be available within QMBasic using
normal Open, Read, Write commands, (see "CREATE-FILE" command.) Directory
type files have no dictionaries (VOCs) and cannot be reported upon using
English/Access from TCL.

Also you can specify a 'Q' type file pointer where attr<2>=Account or Path,
attr<3>=File name in Account, attr<4>=Server name (QMNet connections only).
I believe these will have Directory type file limitations, if they reside
outside the file system.

See OpenQM documentation for more details. Note: as with most MV flavors,
if you read data from an outside source, it is highly recommended to run an
'MCP' conversion (or equivalent) on the data before actually doing anything
with it inside the DBMS.

Hope that helps... If not, try the OpenQM forum on Google Groups.

BFaux



Reply With Quote
  #4  
Old   
Bruce Nichol
 
Posts: n/a

Default Re: OpenQM for Windows Q-Pointers into the windows file system. - 08-01-2006 , 01:41 AM



Goo'day,

On Tue, 01 Aug 2006 05:22:38 GMT, "Concerned_Netizen"
<Concerned_netizen (AT) WhydontIgetspamanymore (DOT) net> wrote:

Quote:

Thanks, I went over the documentation, but I don't seem to see if or how OpenQm could sort an existing directory. Can it?
If I understand the question properly, what's wrong with !SORT ??

HTH
Regards,

Bruce Nichol
Talon Computer Services
ALBURY NSW Australia

http://www.taloncs.com.au

If it ain't broke, fix it until it is....


Reply With Quote
  #5  
Old   
Concerned_Netizen
 
Posts: n/a

Default Re: OpenQM for Windows Q-Pointers into the windows file system. - 08-01-2006 , 02:23 AM



I'd be happy to use sort on a directory i could point to which was a native windows directory. The question I was trying to proffer was, er, how do i make a directory that was native to windows visible to SORT in openqm.

In D3 it was easy...

One would set up what was called a super q-pointer to into the file system, and we wouldn't use the set-file verb and heaven forfend using create file since the target existed already......
an example using later implementations of d3 linux might be accomplished mearly by creating the following ..

root
001 q
002
003 /
004
005
006
007
008
009 L
010 10

and then saying at the command line...

sort root <enter>

Can anyone do something like this with the directory c:\contacts on an xp box using OpenQM?





--

"Bruce Nichol" <reverse_ecurb (AT) taloncs (DOT) com.au> wrote

Quote:
Goo'day,

On Tue, 01 Aug 2006 05:22:38 GMT, "Concerned_Netizen"
Concerned_netizen (AT) WhydontIgetspamanymore (DOT) net> wrote:



Thanks, I went over the documentation, but I don't seem to see if or how OpenQm could sort an existing directory. Can it?

If I understand the question properly, what's wrong with !SORT ??

HTH
Regards,

Bruce Nichol
Talon Computer Services
ALBURY NSW Australia

http://www.taloncs.com.au

If it ain't broke, fix it until it is....

Reply With Quote
  #6  
Old   
AT
 
Posts: n/a

Default Re: OpenQM for Windows Q-Pointers into the windows file system. - 08-01-2006 , 02:29 AM



The entry on my VOC for a Windows directory looks like

000 C.PROGRAMS
001 F
002 C:\PROGRAMS

So if all else fails you could construct an item like this by means of
the editor

Regards

Malcolm Bull


Reply With Quote
  #7  
Old   
Bruce Nichol
 
Posts: n/a

Default Re: OpenQM for Windows Q-Pointers into the windows file system. - 08-01-2006 , 06:20 PM



Goo'day,

Ah! Now I think I understand....

On Tue, 01 Aug 2006 07:23:56 GMT, "Concerned_Netizen"
<Concerned_netizen (AT) WhydontIgetspamanymore (DOT) net> wrote:

Quote:
I'd be happy to use sort on a directory i could point to which was a native windows directory. The question I was trying to proffer was, er, how do i make a directory that was native to windows visible to SORT in openqm.

In D3 it was easy...


In OpenQM it's even easier. There's a configuration parameter
FILERULE which "allows additive rules for file names":

1 = Allow Account:File
2 = Allow Server:Account:file (QMNet)
4 = Allow PATHathname

so if config FILERULE is set to 4 or higher, one can

SORT PATH:e:\downloads\qm<Enter> and get a result like:

SORT PATH:E:\DOWNLOADS\QM ... Page 1
PATH:E:\DOWNLOADS\QM
051231.CSV
QM-AT-COLOUR.ZIP
QMCLIENT_JAVA.ZIP
QMCLIENT_NET.ZIP
QMDOCS_2-1-13.ZIP
QMDOCS_2-1-14.ZIP
QMDOCS_2-1-5.EXE
QMWEB-WIN-2006-03-03.ZIP
QM_2-1-11.EXE
QM_2-1-12.EXE
QM_2-1-13.EXE
QM_2-1-14.EXE
QM_2-2-0.EXE
QM_2-2-10.EXE
QM_2-2-11.EXE
QM_2-2-12.EXE
QM_2-2-13.EXE
QM_2-2-14.EXE
QM_2-2-15.EXE....
:

HTH
Regards,

Bruce Nichol
Talon Computer Services
ALBURY NSW Australia

http://www.taloncs.com.au

If it ain't broke, fix it until it is....


Reply With Quote
  #8  
Old   
Concerned_Netizen
 
Posts: n/a

Default Re: OpenQM for Windows Q-Pointers into the windows file system. - 08-05-2006 , 04:16 AM



where in the documentation would I find information on how to set up configuration parameters and FILERULE. I sure can't seem to find them by typing HELP FILERULE

--

"Bruce Nichol" <reverse_ecurb (AT) taloncs (DOT) com.au> wrote

Quote:
Goo'day,

Ah! Now I think I understand....

On Tue, 01 Aug 2006 07:23:56 GMT, "Concerned_Netizen"
Concerned_netizen (AT) WhydontIgetspamanymore (DOT) net> wrote:

I'd be happy to use sort on a directory i could point to which was a native windows directory. The question I was trying to proffer was, er, how do i make a directory that was native to windows visible to SORT in openqm.

In D3 it was easy...



In OpenQM it's even easier. There's a configuration parameter
FILERULE which "allows additive rules for file names":

1 = Allow Account:File
2 = Allow Server:Account:file (QMNet)
4 = Allow PATHathname

so if config FILERULE is set to 4 or higher, one can

SORT PATH:e:\downloads\qm<Enter> and get a result like:

SORT PATH:E:\DOWNLOADS\QM ... Page 1
PATH:E:\DOWNLOADS\QM
051231.CSV
QM-AT-COLOUR.ZIP
QMCLIENT_JAVA.ZIP
QMCLIENT_NET.ZIP
QMDOCS_2-1-13.ZIP
QMDOCS_2-1-14.ZIP
QMDOCS_2-1-5.EXE
QMWEB-WIN-2006-03-03.ZIP
QM_2-1-11.EXE
QM_2-1-12.EXE
QM_2-1-13.EXE
QM_2-1-14.EXE
QM_2-2-0.EXE
QM_2-2-10.EXE
QM_2-2-11.EXE
QM_2-2-12.EXE
QM_2-2-13.EXE
QM_2-2-14.EXE
QM_2-2-15.EXE....
:

HTH
Regards,

Bruce Nichol
Talon Computer Services
ALBURY NSW Australia

http://www.taloncs.com.au

If it ain't broke, fix it until it is....

Reply With Quote
  #9  
Old   
Tom deL
 
Posts: n/a

Default Re: OpenQM for Windows Q-Pointers into the windows file system. - 08-05-2006 , 06:47 AM




Concerned_Netizen wrote:
Quote:
where in the documentation would I find information on how to set up configuration parameters and FILERULE. I sure can't seem to find them by typing HELP FILERULE
Try section 17 of intro.pdf "Configuration Parameters" or
http://qmweb.cdmiweb.com/qmv/qmdocs/docssearch.htm or
http://www.nuwiki.com/cgi-bin/nuwiki...20PARAME TERS



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.