Shell Programming and Scripting

What do you plan to do with your one records files? Do you have a naming convention to follow based on the data or just a sequential number?



If you can tell us more, there may be a better way to achieve your overall objective.




Robin

Please post a representative example of your data.

Hi,

Consider a table column, which stores each page of a book in a seperate row.

Now, we have to save each of these rows(each page of a book) in a seperate unix file. We can use any naming convention.

Row 1 :- Page 1 of a book
Row 2 :- Page 2 of a book
.
.
.
Row n :- Page n of a book, where n is the number of rows.

Example:-

Query:-
select page_text from books;

Suppose, this query yields 1000 rows. Each row contains data in the below form:-

--------------------------------------
Row1:-

Rohan Bopanna and Aisam-ul-Haq Qureshi progressed to the semifinals of the Sydney International but Leander Paes failed to rescue his 2014 season from a poor start as he crashed out in the first round with Czech partner Radek Stepanek.
Bopanna and his Pakistani partner, seeded third, faced stiff resistance from Trat Huey of Philippines and Briton Dominic Inglot before prevailing 6-7(3) 7-6(5) 10-3 in the quarterfinals.



***********************

Row2:-
--------------------------------

They now face giant-killers Lukas Rosol and Joao Sousa, who dumped the top seeded American pair of Mike and Bob Bryan 3-6 6-3 14-12 in their quarterfinal.
For Paes, it has been a nightmarish start to the new season. At the Chennai Open, he did not get to play a single ball as his partner Fabio Fognini pulled out due to an injury.
***********************

Thanks

It all seems a bit homework to me..........can you elaborate?

Might you be better off writing this as a loop?

Robin

Yes ...I figured out this much. But not able to implement this logic. Could you please provide a sample code for this ..Thanks

What have you tried so far?

It would be better for me to suggest adjustments rather than just deliver a (potential) solution.

Below Shell Script is for splitting the file.

Code:

#!/usr/bin/ksh
exec 1>/Temp/`basename ${0}`.log
exec 2>/Temp`basename ${0}`.err

SQLPLUS=""
PATH=""
no_of_rows="1"
file_name=new_file
if [ -f Query.txt ]
then
rm -rf Query.txt
fi
${SQLPLUS}  scott/tiger@Server @Query.sql

split $no_of_rows Query.txt $file_name

SQL File:-

Code:

set feedback off
set linesize 5000
set pagesize 1000
set trimspool on
set colsep "    "
spool Query;
SELECT  text FROM table WHERE trunc(date_time)=trunc(sysdate);
spool off;
exit;

The above Script generates a file Query.lst, which prints only the first 8 lines of each row.