10-31-2008
shell script to read data from text file and to load it into a table in TOAD
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 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005678 000001 000000 000000 000000 000000 000000 000001
I would like the first 3 columns of data to be read by the script to insert them into a table in Toad.
The table is IMSERNOS
and its contains 3 fields..namely:
ImiCode varchar2(6),
CustNo varchar2(9),
SerNo varchar2(9)
How to create a script(ksh) that reads the data and insert this data into the Toad?
Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies
2. 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
3. Shell Programming and Scripting
Hi all,
I need to know how to copy data from a table say ABC to a flat file say XYZ.dat in unix,
Please leave ur comments and the fastest way to do so,
I need to load the table records into flat file.
Regards
Ann (4 Replies)
Discussion started by: Haque123
4 Replies
4. Shell Programming and Scripting
hi all,
I have this file with some user data.
example:
$cat myfile.txt
FName|LName|Gender|Company|Branch|Bday|Salary|Age
aaaa|bbbb|male|cccc|dddd|19900814|15000|20|
eeee|asdg|male|gggg|ksgu|19911216|||
aara|bdbm|male|kkkk|acke|19931018||23|
asad|kfjg|male|kkkc|gkgg|19921213|14000|24|... (4 Replies)
Discussion started by: srimal
4 Replies
5. Shell Programming and Scripting
I am having one text file and i need to read that data from my shell script.
I will expain you the scenario:
Script look like:
For name type 1:
For age type 2:
For Salary type3:
echo "Enter the input:"
read the data
if input is 1 then go to the Text file and print the... (2 Replies)
Discussion started by: dineshmurs
2 Replies
6. Shell Programming and Scripting
I need help as to how to write a script in Unix for the following:
We have 3 servers;
The mainframe will FTP them to a folder. In that folder we will need the script to look and see if the specific file name is there and load it to the correct table.
Can anyone pls help me out with... (2 Replies)
Discussion started by: msrahman
2 Replies
7. 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
8. Shell Programming and Scripting
I need to read a text file that contain columns of data, i need to read 1st column as a function to call, and others are the data i need to get into a ksh script.
I am quite new to ksh scripting, i am not very sure how to read each row line by line and the data in each columns of that line, set... (3 Replies)
Discussion started by: gavin_L
3 Replies
9. Homework & Coursework Questions
Hi,
I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script.
The table has two columns - Acct_number (not nullable) and date (timestamp).
I'm not able to write a shell script for that. Can any one help me?
... (3 Replies)
Discussion started by: saisudeep
3 Replies
10. UNIX for Dummies Questions & Answers
sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies
INPUT(5) File Formats Manual INPUT(5)
NAME
input - input data file format
DESCRIPTION
This manual page describes the output format of the file created by the Yagi-Uda project input or first programs. The file is an ASCII
file, so can be edited manually if required. It is read by yagi or optimise. The program optimise also creates the same file format.
NOTES
FREQUENCY
MIN_FREQUENCY
MAX_FREQUENCY
STEP_FREQUENCY
ELEMENTS
DRIVEN
PARASITIC
ANGULAR_STEP
DATA_DRIVEN
DATA_PARASITIC
The
#
is used as a comment.
A typical file, for an antenna designed for the 2m amateur band (144-146
MHz) might be as shown below. Note:
1) Reflector is at position 0.0
2) All elements lengths/positions are in m.
NOTES This line can be up to 400 characters.
FREQUENCY 145.000000
MIN_FREQUENCY 144.000000
MAX_FREQUENCY 146.000000
STEP_FREQUENCY 0.100000
ELEMENTS 10
DRIVEN 1
PARASITIC 9
ANGULAR_STEP 180.000000
#DATA_DRIVEN x y length diameter voltage phase
DATA_DRIVEN 0.30993 0.000000 1.002492 0.0063000000000000 1.000000 0.000000
# DATA_PARASITIC x y length diameter
DATA_PARASITIC
0.00000 0.00000 1.01902 0.00630
0.49859 0.00000 0.95551 0.00630
1.07338 0.00000 0.93595 0.00630
1.81020 0.00000 0.92050 0.00630
2.58152 0.00000 0.91322 0.00630
3.30390 0.00000 0.91243 0.00630
4.03692 0.00000 0.90423 0.00630
4.64108 0.00000 0.89081 0.00630
5.37418 0.00000 0.83912 0.00630
FILES
filename ASCII description of antenna. filename.out binary file
SEE ALSO
yagi(1), output(1), input(1), optimise(1), first(1) and yagi(5).
AUTHORS
Dr. David Kirkby G8WRB (david.kirkby@onetel.net), with help with converting to DOS from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov).
Yagi version 1.16 24th October 2000 INPUT(5)