XBase::SDBM(3) User Contributed Perl Documentation XBase::SDBM(3)NAME
XBase::SDBM - SDBM index support for dbf
DESCRIPTION
When developing the XBase.pm/DBD::XBase module, I was trying to support as many existing variants of file formats as possible. The module
thus accepts wide range of dbf files and their versions from various producers. But with index files, the task is much, much harder. First,
there is little or no documentation of index files formats, so the development is based on reverse engineering.
None if the index formats support is finalized. That made it hard to integrate them into one consistent API. That is why I decided to write
my own index support, and as I wanted to avoid inventing yet another way of storing records in pages and similar things, I used SDBM. It
comes with Perl, so you already have it, and it's proven and it works.
Now, SDBM is a module that aims at other task than to do supporting indexes for a dbf. But equality tests are fast with it and I have
creted a structure in each index file to enable "walk" though the index file.
VERSION
0.200
AUTHOR
(c) 2001 Jan Pazdziora, adelton@fi.muni.cz, http://www.fi.muni.cz/~adelton/ at Faculty of Informatics, Masaryk University in Brno, Czech
Republic
All rights reserved. This package is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.12.1 2001-08-19 XBase::SDBM(3)
Check Out this Related Man Page
DBFDUMP(1) User Contributed Perl Documentation DBFDUMP(1)NAME
dbfdump - Dump the record of the dbf file
FORMAT
dbfdump [options] files
where options are
--rs output record separator (default newline)
--fs output field separator (default colon)
--fields comma separated list of fields to print (default all)
--undef string to print for NULL values (default empty)
--memofile specifies unstandard name of attached memo file
--memosep separator for dBase III dbt's (default x1ax1a)
--nomemo do not try to read the memo (dbt/fpt) file
--info print info about the file and fields
with additional --SQL parameter, outputs the SQL create table
--version print version of the XBase library
--table output in nice table format (only available when
Data::ShowTable is installed, overrides rs and fs)
SYNOPSIS
dbfdump -fields id,msg table.dbf
dbfdump -fs=' : ' table
dbfdump --nomemo file.dbf
ssh user@host 'cat file.dbf.gz' | gunzip - | dbfdump -
DESCRIPTION
Dbfdump prints to standard output the content of dbf files listed. By default, it prints all fields, separated by colons, one record on a
line. The output record and column separators can be changed by switches on the command line. You can also ask only for some fields to be
printed.
The content of associated memo files (dbf, fpt) is printed for memo fields, unless you use the "--nomemo" option.
You can specify reading the standard input by putting dash (-) instead of file name.
AUTHOR
(c) 1998--1999 Jan Pazdziora, adelton@fi.muni.cz, http://www.fi.muni.cz/~adelton/ at Faculty of Informatics, Masaryk University in Brno,
Czech Republic
SEE ALSO perl(1); XBase(3)perl v5.12.1 2010-07-05 DBFDUMP(1)
Hi all
If I have lines in a file as follows :-
/ora04/oradata/data1/data1.dbf
/ora01/app/product/8.1.6/dbs/F1.Dbf
/ora04/oradata/data2.dbf
How can I select the last part of the line as my file name. Can I start from the right and define "/" as my delimeter ?
Thx
J (3 Replies)
Hi Unixers, :)
In a shell script i found the following statements
mline='grep\^ 1111 emaster.dbf
set -- $mline
The first statement searches the emaster.dbf file for the code 1111 and ifit finds any such line it gets that line and stores it in mline.
But iam getting little bit confusion with... (4 Replies)
Hi,
I am writing a script to use awk to generate a set of cp commands from an input file abc.
file abc:
/data/a.dbf
/data/june/b.dbf
desired output:
cp -pr a.dbf /data/a.dbf
cp -pr b.dbf /data/june/b.dbf
script:
$ cat abc | awk '{ print "cp -pr '`basename $1`' " $1 }'
I tried to... (4 Replies)
Hi,
I have a file like this:
mgr1.dbf
tool.dbf
usr.dbf
wow19.dbf
wow2wow.dbf
Can anyone help change the format after each line of reading to:
mgr2.dbf # add 1 of *1.dbf
tool2.dbf # if not a number exist, make it default to 2
usr2.dbf
wow20.dbf # add 1 of *19.dbf
wow3wow.dbf ... (5 Replies)
Hi all,
I would want to copy everything in a particular directory. However would want to exclude 2 files:
DIMStemp01.dbf
DIMSts01.dbf
Don't really know how to do so, any suggestions?
Thanks in advance. (5 Replies)
Hi all,
I would want to copy everything in a particular directory. However would want to exclude 2 files:
DIMStemp01.dbf
DIMSts01.dbf
I tried to:
(1) ls files except these 2 files into abc.txt
(2) Read from abc.txt and start copying.
It works, however is there any easier way? Eg.... (6 Replies)
Hi all,
I am new to shell scripting.
I have dbf file and I need to convert it into csv file.
OR, can i read the fields from a .dbf file and OR seprate the records in dbf file and put into .csv or txt.
Actually in the .dbf files I am getting , the numbers of fields may vary in very record and... (6 Replies)
My salary is 800$ per month and I have invited in Czech Republic as an AIX administrator giving me 1000 euro... if I go to Czech republic I will have additional problems such as flat for living and transport.. so would you recommend me to go there dear friends? :-) I am hesitating and don't know... (3 Replies)
Hi,
I am a novice and require help once again.
I have a over 200 file all called index.jsp placed in different directories
The following Sed command gives me the data of all included jsp files in index.jsp
sed -n -e 's/^.*page="\(*\).*$/\1/p' index.jsp
How can I run the above... (6 Replies)
From below mentioned line,i have to display output as last word only ie:arch_1_105366_720809746.dbf
-rw-r----- 1 oracle dba 98887680 02 Mar 12:01 arch_1_105366_720809746.dbf
Please .. (5 Replies)
Hi,
I have a string like the following:
/db1/data/GLIDER/SYSTEM.dbf
need to find the postion where "SYSTEM.dbf" starts, so I tried:
LOCATION=/db1/data/GLIDER/SYSTEM.dbf
$ expr index $LOCATION SYSTEM
expr: syntax error
$ expr index "$LOCATION" SYSTEM
expr: syntax error
... (5 Replies)
I have a bunch of database files in a directory. Their name are like:
1234_ABCD_01.dbf, 28hrs_ABCD_02.dbf
I want to change them in bulk to:
1234_XXXU_01.dbf, 28hrs_XXXU_02.dbf.
I mean I just want to replace ABCD by XXXU. don't change other part of the file name and the contents of the... (4 Replies)
Hi,
I have a file which has the following
/u12/data/oracle/abc.dbf
/u12/data/oracle/def.dbf
/u12/data/oracle/daf.dbf
/u12/data/oracledb/fgh.dbf
/u12/data/oracledb/fkh.dbf
/u12/data/oracledb/kdq.dbf
I want to do something like this
/u12/data/oracle
/u12/data/oracle... (7 Replies)
Hi,
There were a few files deleted from a server by user xyz.
The file names are:-
/oraextME4/oradata/ME11G22/TEST_IMPORT_01.dbf
/oraextME4/oradata/ME11G22/RKVITR1_03.dbf
/oraextME4/oradata/ME11G22/TEST_IMPORT_02.dbf
need to know the ip address of the terminal from which that... (10 Replies)