03-11-2011
hhhhhhhhhh
Last edited by sams; 03-14-2011 at 03:07 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Data file path (.txt)
Control file(.ctl)
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me... (1 Reply)
Discussion started by: unihp1
1 Replies
2. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion 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... (1 Reply)
Discussion started by: pallavishetty
1 Replies
3. Shell Programming and Scripting
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies
4. Shell Programming and Scripting
Hi Guys,
I'm new to this forum as well as to UNIX shell scripting.
I'm looking for a shellscript to query an Oracle database table and populate the result set of the query in a text file.
Could you someone help me out with a sample code?
Thanks,
Bhagat (7 Replies)
Discussion started by: bhagat.singh-j
7 Replies
5. Shell Programming and Scripting
Hi All,
I need to BCP out a table into a text file along with the table headers. Normal BCP out command only bulk copies the data, and not the headers.
I am using the following command: bcp database1..table1 out file1.dat -c -t\| -b1000 -A8192 -Uuser -Ppassword -efile.dat.err
Regards,... (0 Replies)
Discussion started by: shilpa_acc
0 Replies
6. Shell Programming and Scripting
Hi,
I have a text file say file1 having data like
ABC c:/hm/new1 Dir
DEF d:/ner/d sd
......
So i want to make a table from this text file, is it possible to do it using perl.
Thanks in advance
Sarbjit (1 Reply)
Discussion started by: sarbjit
1 Replies
7. 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
8. Shell Programming and Scripting
hi ,
i need to create a bash shell script that insert a text data file into an html made table, this table output has to mailed.I am new to shell scripting and have a very minimum idea of shell scripting.
please help. (9 Replies)
Discussion started by: intern123
9 Replies
9. Shell Programming and Scripting
Hi,
I have a pipe separated text file.
Can some someone tell me how to convert it to a table?
Text File contents.
|Activities|Status1|Status2|Status3|
||NA|$io_running2|$io_running3|
|Replication Status|NA|$running2|$running3|
||NA|$master2|$master3|... (1 Reply)
Discussion started by: rocky88
1 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I have text file with comma seprater shown below
lu8yh,n,Fri,Feb,7,2014,16:5
deer4
deer4,n,Tue,Aug,21,,2012,on
r43ed
r43ed,n,Tue,Nov,12,2013,12:
e43sd
e43sd,n,Tue,Jan,1,,2013,on,
I am using below code to load the text file into table
#!/bin/ksh... (16 Replies)
Discussion started by: stew
16 Replies
LEARN ABOUT CENTOS
spectool
SPECTOOL(1) User Commands SPECTOOL(1)
NAME
spectool - manual page for spectool v1.0.10rpmdev1
SYNOPSIS
spectool [<options>] <specfile>
DESCRIPTION
Spectool is a tool to expand and download sources and patches from specfiles.
If you experience problems with specific specfiles, try to run
rpmbuild --nobuild --nodeps <specfile>
on the file which might give a clue why spectool fails on a file (ignore anything about missing sources or patches). The plan is to catch
errors like this in spectool itself and warn the user about it in the future.
OPTIONS
Operating mode:
-l, --lf, --list-files
lists the expanded sources/patches (default)
-g, --gf, --get-files
gets the sources/patches that are listed with a URL
-h, --help
display this help screen
Files on which to operate:
-A, --all
all files, sources and patches (default)
-S, --sources
all sources
-P, --patches
all patches
-s, --source x[,y[,...]]
specified sources
-p, --patch a[,b[,...]]
specified patches
Miscellaneous:
-d, --define 'macro value'
defines RPM macro 'macro' to be 'value'
-C, --directory dir
download into specified directory (default '.')
-R, --sourcedir
download into rpm's %{_sourcedir}
-n, --dryrun, --dry-run
don't download anything, just show what would be done
-f, --force
try to unlink and download if target files exist
-D, --debug
output debug info, don't clean up when done
FILES
/etc/rpmdevtools/curlrc
optional curl(1) configuration
spectool v1.0.10rpmdev1 June 2014 SPECTOOL(1)