Hi all,
I have a requirement where I need to read records one by one from a file. I have tried this below code:
while read mLine
do
echo 'Line = '${mLine}
done < input_file
--- But the problem here is im getting the records with removed spaces.
--Supposer if the record is like... (3 Replies)
All, I need to write an unix shell script which inserts some records into a file located in remote servers.
* Get the input from the user and insert according the first row. It should be in ascending order.
123451,XA,ABA
123452,XB,ABB
123453,XC,ABC
123455,XE,ABE
123456,XF,ABF
123458,XG,ABG... (2 Replies)
Hi,
I have a file with 6 columns. First 3 columns together make unique record. I have a variable ($v) which hold a value that is obtained by a caliculaion. I have to replace value in 5th columnn with the value of the variable ($v). The value $v is caliculated from col4 and col6 values.
... (2 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)
Hi,
I have 10000 records in my test.dat file
All records are under the following format
a,12,45,bn,c
a,16,46,bn1,c
a,18,47,bn2,c
a,12,47,bn3,c
a,11,49,bn4,c
I have to read each 2 records and assign it into a temp file
.Can anybody help me in this?
Thanks (3 Replies)
I have a file which has number of pipe delimited records.
I am able to read the records....but I want to sort it after reading.
i=0
while IFS="|" read -r usrId dataOwn expire email group secProf startDt endDt smhRole RoleCat DataProf SysRole MesgRole SearchProf
do
print $usrId $dataOwn... (4 Replies)
Hi All
Can anybody let me know the code to read a particular record from a file
For e.g.
File Name: File.txt
File content:
Script_path=/abc/def/script/
File_path=/xyz/data/
Business Date=19990905
SERVER_NAME=Server
DATABASE_NAME=Database
Login=NewUser
Password=NewPassword
... (3 Replies)
hi all,
i have to read a file using shell script for example my csv file is
like this
Tid Inputfille Inputfilepath
1 ABC_20141218.idr /export/home/him60t1/input
2 ABC_20141219.idr /export/home/him60t1/input1
what i have to do is if on my command line i... (1 Reply)
Not sure if this is the correct forum for this question. I have two files. file1.zip, file2
Input:
file1.zip
col1, col2 , col3
a , b , 0:0:0:0:0:c436:9346:d40b
x, y, 0:0:0:0:0:880:39f9:c9a7
m, n , 0:0:0:0:0:80c7:9161:fe00
file2.txt
col1
c4:36:93:46:d4:0b... (1 Reply)
Discussion started by: anil.v
1 Replies
LEARN ABOUT DEBIAN
dbix::class::storage::dbi::informix
DBIx::Class::Storage::DBI::Informix(3pm) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Informix(3pm)NAME
DBIx::Class::Storage::DBI::Informix - Base Storage Class for Informix Support
DESCRIPTION
This class implements storage-specific support for the Informix RDBMS
METHODS
connect_call_datetime_setup
Used as:
on_connect_call => 'datetime_setup'
In connect_info to set the "DATE" and "DATETIME" formats.
Sets the following environment variables:
GL_DATE="%m/%d/%Y"
GL_DATETIME="%Y-%m-%d %H:%M:%S%F5"
The "DBDATE" and "DBCENTURY" environment variables are cleared.
NOTE: setting the "GL_DATE" environment variable seems to have no effect after the process has started, so the default format is used. The
"GL_DATETIME" setting does take effect however.
The "DATETIME" data type supports up to 5 digits after the decimal point for second precision, depending on how you have declared your
column. The full possible precision is used.
The column declaration for a "DATETIME" with maximum precision is:
column_name DATETIME YEAR TO FRACTION(5)
The "DATE" data type stores the date portion only, and it MUST be declared with:
data_type => 'date'
in your Result class.
You will need the DateTime::Format::Strptime module for inflation to work.
AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.14.2 2011-05-10 DBIx::Class::Storage::DBI::Informix(3pm)