01-19-2007
Using loop reading a file,retrieving data from data base.
Hi All,
I am having trouble through, I am reading the input from tab delimited file containing several records,
e.g.
line1 field1 field2 field3 so on..
line2 field1 field2 field3 so on..
..
..
on the basis of certain fields for each record in input file, I have to retrieve data from oracale database.
and using copy command move the record to different location..
Thanks in advance.
Sonu.
10 More Discussions You Might Find Interesting
1. Programming
Dear sirs,
I am new to DataBase in C++,Also here iam using mysql,
How can do it nad get the result back from the database and do operation onit.
Thanks in advance,
arunkumar (2 Replies)
Discussion started by: arunkumar_mca
2 Replies
2. UNIX for Dummies Questions & Answers
Friends,
I have a data with 3 columns:
30 41 1
39 19 4
14 25 3
....
....
.....
I want to retrieve any data in the first column that is greater 15. What is the best way to do this?
Thanks! (2 Replies)
Discussion started by: bobo
2 Replies
3. HP-UX
Need help on making a loop script base on what is inside a file...
File to read: List.txt
List.txt contains below w/c are file name as well:
SAMPLEa
SAMPLEb
SAMPLEc
SAMPLEd
SAMPLEe
SAMPLEf
.
.
.
Want to make a loop that will manipulate those that are inside the file.txt w/c are... (3 Replies)
Discussion started by: JohnBalayo
3 Replies
4. UNIX for Dummies Questions & Answers
To make it clearer:
I have a file, List.txt
List.txt contains: (these are actually splitted files w/c I got from ls command and dump them to the List.txt file)
SAMPLEa
SAMPLEb
SAMPLEc
SAMPLEd
SAMPLEe
SAMPLEf
.
.
.
.
.
And I want to rename these files to have a .dat extension.... (3 Replies)
Discussion started by: JohnBalayo
3 Replies
5. UNIX and Linux Applications
Hi
I'm using and Oracle 10g Database.
I want to write a script to retrieve data from the database and store it toa file.
I'm using simple sql statements such as
Select * from celltable
I don't know how to specify the database name etc.
I have this but it doesn't work
... (1 Reply)
Discussion started by: ladyAnne
1 Replies
6. Linux
Hello,
I had Gentoo installed on a Microsoft Windows Hyper-V virtual machine. The system shutdown properly but the RAID array on the drive it was on failed. We had a backup that was poorly configured and as such we didn't back up all of the data we needed.
Therefore, after getting the RAID... (0 Replies)
Discussion started by: ckoeber
0 Replies
7. UNIX for Dummies Questions & Answers
I have input file like
AAA
AAA
CCC
CCC
CCC
EEE
EEE
EEE
EEE
FFF
FFF
GGG
GGG
i was trying to retrieve data between two strings using sed.
sed -n /CCC/,/FFF/p input_file
Am getting output like
CCC
CCC
CCC (22 Replies)
Discussion started by: NareshN
22 Replies
8. Shell Programming and Scripting
HI
I have input file A.txt
X
Y
Z
File B.txt
1 X 10 AAA 11123
2 Y 22 PlD 4563
3 Z 55 PlD 54645
4 Z 66 PlD 15698
5 F 44 PlD 154798
6 C 55 PlD 12554
7 Z 88 PlD 23265
8 C 99 PlD 151654
9 C 11 PlD 21546546
I need New File C.txt (1 Reply)
Discussion started by: pareshkp
1 Replies
9. Shell Programming and Scripting
Hello experts :cool:,
I am new to programming and will need your help.. I have 2 very large files with the following format:
FILE1:
>MLP1019 PL4
>MLP7456 PL3
>MLP9268 PL9
>MLP6245 PL1
FILE2:
>MLP1019
STNAPLQTSNTWVSYQPSMMMSLQ
>MLP7456
PPYWYWNSAVMIFYVQPLSLLAVLLA
>MLP9268... (2 Replies)
Discussion started by: narachaid
2 Replies
10. Shell Programming and Scripting
File 1
ID Name Po1 Po2
DD134 DD134_4A_1 NN-1 L_0_1
DD134 DD134_4B_1 NN-2 L_1_1
DD134 DD134_4C_1 NN-3 L_2_1
DD142 DD142_4A_1 NN-1 L_0_1
DD142 DD142_4B_1 NN-2 L_1_1
DD142 DD142_4C_1 NN-3 L_2_1
DD142 DD142_3A_1 NN-41 L_3_1
DD142 DD142_3A_1 NN-42 L_3_2
File 2 ( Combination of... (1 Reply)
Discussion started by: pareshkp
1 Replies