Home  ·  News  ·  Download  ·  Documentation  ·  Future  ·  Contact Affilate: Nixus AB
MCatS Logo   SourceForge Logo



[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