November 19, 2008 12:23am pst

1. Tintin 109,032
2. ozo 106,990
3. omarfarid 103,014
4. sirbounty 20,975
5. sunnycoder 20,640
6. hernst42 19,800
7. Adam314 18,230
8. RobSamp... 16,975
9. ahoffmann 16,895
10. blu 15,530
11. ghostdog74 14,871
12. sentner 14,300
13. MikeOM_... 13,300
14. mikelfritz 13,100
15. Shift-3 13,000
15. BSonPosh 13,000
17. AmazingT... 12,600
18. amit_g 10,000
19. merowinger 8,200
20. sungenw... 7,600
21. JustUNIX 7,435
22. knightEkni... 7,000
22. hielo 7,000
24. agriesser 6,032
25. duncan_roe 5,116

1. ozo 164,528
2. Tintin 162,818
3. omarfarid 125,257
4. ahoffmann 43,666
5. amit_g 42,400
6. RobSamp... 36,150
7. hernst42 34,500
8. sirbounty 32,575
9. Adam314 23,965
10. sunnycoder 21,040
11. Shift-3 20,600
12. BSonPosh 19,350
13. ghostdog74 18,481
14. blu 15,530
15. sentner 14,300
16. ravenpl 14,200
17. MikeOM_... 13,300
18. mikelfritz 13,100
19. AmazingT... 12,600
20. SteveGTR 11,550
21. duncan_roe 9,816
22. merowinger 8,200
23. oBdA 7,800
23. nixfreak 7,800
25. sungenw... 7,600

03.25.2008 at 06:40PM PDT, ID: 23269231

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.1

Solaris: Shell script to write output to a file.

Asked by stopm in Shell Scripting, Sun Solaris

Hi
I need to run a sql query each day which retrieves data based on a numerical incremental (MAXID) value.
I want then to store the max value from last query ran in a file (tempid) and then use this new number each day to retreive only the new data.
Attached is a sample of the script being used.

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:

           
           
             #!/bin/sh
 
echo "Retrieve id"
 
FILE="/tmp/tempid"
MAXID=0
 
if [ ! -f $FILE ]; then
	echo "$FILE : deos not exist"
	exit 1
elif [ ! -r $FILE ]; then
	echo "$FILE : can not read"
	exit 2
fi
 
# read $FILE using the file descriptors
exec 3<&0       #save standard input
exec 0<$FILE
while read line
do
 
        MAXID=$line
 
done
 
#
#	Query
#
 
sh -c "sqlplus etc ................ <<EOF
       
 
spool /tmp/temp.csv
 
        select blah blah blah.........;
 
spool off
quit;
 
 
NEW_MAXID=`expr $MAXID + 10`
 
echo $NEW_MAXID
 
# write New MAXID to a new file
 
#echo $NEW_MAXID > $FILE
 
exit 0

           
         

Keywords: Solaris: Shell script to write output to …

	Title
1	Append incremental numeric data base…
2	Retrieve records with Max(Date)
3	Retreiving PK on a newly Inserted reco…
4	Reverse increment of Alpha Numeric c…
5	how can i add days to a date in shell s…
6	to retrieve the newly inserted auto-inc…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Solaris: Shell script to write output to a file.

Asked by stopm in Shell Scripting, Sun Solaris

About this solution