|
[back]
Content-type: text/html
Manpage of MCATS_IODBC
MCATS_IODBC
Section: User Commands (1) Updated: FEBRUARY 2002 Index
Return to Main Contents
NAME
iodbc - a module for MCatS to output to a odbc data source.
USAGE
mcats -o wii --dsn name [--connectstring cstring] [--volumetable table --volumeformat format] [--directorytable table --directoryformat format --filetable table --fileformat format] [--help] [--version]
SYNOPSIS
wii --dsn name [--connectstring cstring] [--volumetable table --volumeformat format] [--directorytable table --directoryformat format --filetable table --fileformat format] [--help] [--version]
DESCRIPTION
This module is for output to a ODBC source.
OPTIONS
- --help
-
Display module usage, and exit.
- --version
-
This will display the current version of iodbc module, and exit.
- --dsn name
-
The name is the data source name specified in odbc.ini.
- --connectstring cstring
-
The cstring is the semicolon seperated string and can the following parts.
HOST=<server host name>
SVT=<database server type>
DATABASE=<database path>
OPTIONS=<db specific opts>
UID=<user name>
PWD=<password>
READONLY=<N|Y>
FBS=<fetch buffer size>
Example:
HOST=db1;UID=test;PWD=test;DATABASE=backups
- --volumetable table
-
The table to store the volumeinformation in.
- --volumeformat format
-
The format the volumeinformation should be saved in. Interpreted squences are:
%a The name.
%b The publisher.
%c The preparer.
%d The application.
%e Type of filesystem.
%f Copy of mount flags (depricated).
%g Fundamental filesystem block size.
%h Optimal transfer block size.
%i Total data blocks in filesystem.
%j Free blocks in filesystem
%k Free blocks avaible to non-superuser.
%l Total file nodes in filesystem.
%m Free file nodes in filesystem.
%n Filesystem id.
%o User that mounted the filesystem
%p Copy of mount flags.
%q Count of sync writes since mount.
%r Count of async writes since mount.
%t Filesystem type name.
%u Directory on which mounted.
%v Mounted filesystem.
\t Horizontal tab.
\n New line.
* The id column.
| The column seperator.
Example:
For the table: ( id int auto_increment, volumename varchar(33) ) the correct volumeformat would be: "*|%a"
- --directorytable table
-
The table to store the directoryinformation in.
- --directoryformat format
-
The format the directoryinformation should be saved in. Interpreted squences are:
%a The time of last accessed.
%b The time of last modification.
%c The time of last file status change.
%d The description (normaly supplied by a filter).
%f The filename. No leading slash.
%g The group.
%i The mime type (normaly supplied by a filter).
%m The mode.
%o The owner.
%p The path. Leading and trailing slash.
%s The size in bytes.
%t The type.
\t Horizontal tab.
\n New line.
\V The volumeid
* The id column.
| The column seperator.
Example:
For the table: ( id int auto_increment, path char(255), directory char(255), volumeid int ) the correct directoryformat would be: "*|%p|%f|\V"
- --filetable table
-
The table to store the fileinformation in.
- --fileformat format
-
The format the fileinformation should be saved in. Interpreted squences are:
%a The time of last accessed.
%b The time of last modification.
%c The time of last file status change.
%d The description (normaly supplied by a filter).
%f The filename. No leading slash.
%g The group.
%i The mime type (normaly supplied by a filter).
%m The mode.
%o The owner.
%p The path. Leading and trailing slash.
%s The size in bytes.
%t The type.
\t Horizontal tab.
\n New line.
\V The volumeid
* The id column.
| The column seperator.
Example:
For the table: ( id int auto_increment, path char(255), file char(255), volumeid int ) the correct directoryformat would be: "*|%p|%f|\V"
BUGS
Since this is the initial release of iodbc module there will probably be alot of bugs. Please report any bugs to <bug@mcats.net>.
AUTHOR
Pehr Johansson <pehr@mcats.net>
http://mcats.net/
Index
- NAME
-
- USAGE
-
- SYNOPSIS
-
- DESCRIPTION
-
- OPTIONS
-
- BUGS
-
- AUTHOR
-
This document was created by
man2html,
using the manual pages.
Time: 18:41:08 GMT, November 18, 2002
|