12-12-2005
yes...i thought of that too.... however my text file is not formated in a way to be append in and its a very huge set of data..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database.
Requirement:-
1. Need to connect to Oracle database from Unix Shell script.
2. Need to pick Text file from some location on Unix Box.
3. Need to upload the data from text file to... (6 Replies)
Discussion started by: chandrashekharj
6 Replies
2. Shell Programming and Scripting
Hi ,
a:) i have configuration file with pattren
<Range start no>,<Range end no>,<type of records to be extracted from the data file>,<name of the file to store output>
eg:
myfile.confg
9899000000,9899999999,DATA,b.dat
9899000000,9899999999,SMS,a.dat
b:) Stucture of my data file is... (3 Replies)
Discussion started by: suparnbector
3 Replies
3. Shell Programming and Scripting
Hi,
Need to get help from you guys about this issue.
I need to insert data into MySql database from a text file which is located in other server.
The text file is something look like below:
Date | SubscriberNo | Call Duration
20/7/07 | 123456788 | 20
20/7/07 | 123412344 | 30
The... (4 Replies)
Discussion started by: shirleyeow
4 Replies
4. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (4 Replies)
Discussion started by: pallavishetty
4 Replies
5. Shell Programming and Scripting
Hi,
I have gps receiver, by using gpsd data i can read gps log data to my database(my sql).
Steps:
1. telenet localhost 2947 > gps.txt (press enter)
2. r (press enter) //then i will get the data like below in gps.txt file
Trying 127.0.0.1...
Connected to localhost.... (1 Reply)
Discussion started by: gudivada213
1 Replies
6. Web Development
If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries
LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n' (0 Replies)
Discussion started by: sitex
0 Replies
7. Shell Programming and Scripting
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Discussion started by: shellguy
15 Replies
8. Shell Programming and Scripting
Sorry to disturb you, I would like to seek help on inserting data whenever the switch is on or off to my phpMyAdmin mySQL database from my Shell Script. I'm using Raspberry PI as my hardware and I have follow this LINK: instructables.com/id/Web-Control-of-Raspberry-Pi-GPIO/?ALLSTEPS to create my... (4 Replies)
Discussion started by: aoiregion
4 Replies
9. Programming
Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
Discussion started by: aoiregion
1 Replies
10. Shell Programming and Scripting
I have a test file that I want to read and insert only certain lines into the
the table based on a filter.
1. Rread the log file 12 Hours back Getdate() -12 Hours
2. Extract the following information on for lines that say "DUMP is
complete"
A. Date
B. Database Name
C.... (2 Replies)
Discussion started by: JolietJake
2 Replies
dvdfs(4) Kernel Interfaces Manual dvdfs(4)
NAME
dvdfs - The Digital Versatile Disk File System [This feature is not supported in Tru64 UNIX Version 5.0]
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
ISO/ITEC 13346:1995
Optical Storage Technology Association (OSTA) Universal Disk Format (UDF) Specification, "OSTA UDF Compliant Domain", Version 2.00.
ISO 9660:1988
Information Processing-Volume and file structure of CD-ROM for information interchange.
Refer to the standards(5) reference page for more information about industry standards and associated tags.
DESCRIPTION
The Digital Versatile Disk File System enables the reading of disks formatted in the Universal Disk Format (UDF).
User data sectors in a DVD-ROM can contain any type of data in any format. However, for Tru64 UNIX support through the dvdfs file system,
the OSTA UDF file format standard is mandatory. The file system limit for DVDFS is int cfs_cdfs_mount_limit = 512.
Additionally, DVD-ROM standards require that the logical sector size and the logical block (the user data block) size be 2048 bytes.
DVD support in the UDF specification includes these levels: DVD-ROM (Read-only):
Supports reading of UDF-formated files from DVD-ROM disks. DVD-R (Write-once):
Supports the reading of UDF-formated files from a DVD-ROM disk and supports writing, one time, UDF-formated files onto a DVD-ROM
disk. DVD-RAM (Rewritable):
Supports reading and writing of UDF-formated files from and to a DVD-ROM disk.
At this time, the Tru64 UNIX dvdfs file system supports only the DVD-ROM (Read-only) format.
See mount(8) for information about mounting and unmounting a dvdfs file system, fstab(4) for information about including dvdfs file system
in a system's /etc/fstab file, and disklabel(8) for information about labeling DVD-ROM disks.
RELATED INFORMATION
Commands: disklabel(8), mount(8)
Files: cdfs(4) fstab(4) delim off
dvdfs(4)