Sponsored Content
Full Discussion: Help with looping
Top Forums UNIX for Dummies Questions & Answers Help with looping Post 11643 by marist89 on Monday 10th of December 2001 09:12:02 AM
Old 12-10-2001
spool overwrites the file every time you SPOOL fn.

After your SQL Query is done, you have to append your results to some "master" type file.

For example, something like:
Code:
touch master.out
for i in `cat NAMES` 
{ 
sqlplus -s $CONNECTID << EOF 
spool rooh 
set heading off 
select name,address1,address2,street,occupation,age 
from emp_detail 
where name='$i'; 
spool off 
EOF
cat rooh >> master.out
}

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

looping

Hi I have around 100 users in sun server and have default home directory in /usr/home/<username> I want to clean their home directory time to time to make free space on root, as users generate many output files during usage of application. My idea is, generate a file with following command... (4 Replies)
Discussion started by: ishir
4 Replies

2. Shell Programming and Scripting

Looping through the directory

Hi, I have to write a KSH script to loop through the directory and transfer all the files through FTP. The source machine is the Network shared drive and the files in the directory needs to be FTPied to the UNIX server. For eg. Directory (Datasource) + Directory1 ... (6 Replies)
Discussion started by: mahalakshmi
6 Replies

3. Shell Programming and Scripting

for looping

I run into a issue when I try to do sorting of the following with ascending order, one round of for looping seems not working, anyone knows how to use shell or perl? $array = (5,0,3,2,7,9,8) (2 Replies)
Discussion started by: ccp
2 Replies

4. Shell Programming and Scripting

help on looping using if/for or while

Hello, where can I get usefull information on the use of looping with for , if and while with extensive examples. Also use of variables in scripts (1 Reply)
Discussion started by: sam4now
1 Replies

5. Shell Programming and Scripting

help with looping

vesselNames values: xxx yyy zzz vesselPlanned values: xxx zzz zzz zzz OIFS="" OIFS=$IFS IFS="\n" (2 Replies)
Discussion started by: finalight
2 Replies

6. Shell Programming and Scripting

Looping through entries

Hi everyone, I am having trouble looping through entries in a file. The file several entries that are separated by topics e.g. <Topic r:id="Top/World/Français"> </Topic> <Topic r:id="Top/World/Français/Actualité"> </Topic> <Topic r:id="Top/World/Français/Actualité/A_la_Une"> <link... (1 Reply)
Discussion started by: BlueberryPickle
1 Replies

7. Shell Programming and Scripting

Looping

Hi, Now I have written a script which sorts the records in the file and splits them according to some condition. Now, I need to modify the script so that it reads all the files one after the other and does the sorting & splitting. Pls help me in reading all the files in a directory and... (8 Replies)
Discussion started by: Sunitha_edi82
8 Replies

8. Shell Programming and Scripting

Looping

Hi evryone i need a help . i have a file xcv.the content is : accelerate i want a script which will run 1000 times in loop and changing the value to accelerate to acceler in 1st loop and in 2nd loop it will be again accelerate and so on . (6 Replies)
Discussion started by: Aditya.Gurgaon
6 Replies

9. Shell Programming and Scripting

looping while using getopts

so when i use rm file -i vv bb i can delete the first file vv but i cant seem to delete the second file bb as i tried to use shift on it, but it seems that it delete the first one and stops it without looping it to the next file. what is wrong with my coding ? #!/bin/bash function... (3 Replies)
Discussion started by: cman123
3 Replies

10. Shell Programming and Scripting

Looping

Hey guys, so I am trying to do a loop script that will go through each folder (no gui so just each domain has a folder) and grab out the databases being used on that domain. I know I would use mysql -e "show databases where not 'information_schema';" once in each directory to pull the actual... (3 Replies)
Discussion started by: dough
3 Replies
Tk_MaintainGeometry(3)					       Tk Library Procedures					    Tk_MaintainGeometry(3)

__________________________________________________________________________________________________________________________________________________

NAME
Tk_MaintainGeometry, Tk_UnmaintainGeometry - maintain geometry of one window relative to another SYNOPSIS
#include <tk.h> Tk_MaintainGeometry(slave, master, x, y, width, height) Tk_UnmaintainGeometry(slave, master) ARGUMENTS
Tk_Window slave (in) Window whose geometry is to be controlled. Tk_Window master (in) Window relative to which slave's geometry will be controlled. int x (in) Desired x-coordinate of slave in master, measured in pixels from the inside of master's left border to the outside of slave's left border. int y (in) Desired y-coordinate of slave in master, measured in pixels from the inside of master's top border to the outside of slave's top border. int width (in) Desired width for slave, in pixels. int height (in) Desired height for slave, in pixels. _________________________________________________________________ DESCRIPTION
Tk_MaintainGeometry and Tk_UnmaintainGeometry make it easier for geometry managers to deal with slaves whose masters are not their parents. Three problems arise if the master for a slave is not its parent: [1] The x- and y-position of the slave must be translated from the coordinate system of the master to that of the parent before posi- tioning the slave. [2] If the master window, or any of its ancestors up to the slave's parent, is moved, then the slave must be repositioned within its parent in order to maintain the correct position relative to the master. [3] If the master or one of its ancestors is mapped or unmapped, then the slave must be mapped or unmapped to correspond. None of these problems is an issue if the parent and master are the same. For example, if the master or one of its ancestors is unmapped, the slave is automatically removed by the screen by X. Tk_MaintainGeometry deals with these problems for slaves whose masters are not their parents, as well as handling the simpler case of slaves whose masters are their parents. Tk_MaintainGeometry is typically called by a window manager once it has decided where a slave should be positioned relative to its master. Tk_MaintainGeometry translates the coordinates to the coordinate system of slave's parent and then moves and resizes the slave appropriately. Furthermore, it remembers the desired position and creates event handlers to monitor the master and all of its ancestors up to (but not including) the slave's parent. If any of these windows is moved, mapped, or unmapped, the slave will be adjusted so that it is mapped only when the master is mapped and its geometry relative to the master remains as specified by x, y, width, and height. When a window manager relinquishes control over a window, or if it decides that it does not want the window to appear on the screen under any conditions, it calls Tk_UnmaintainGeometry. Tk_UnmaintainGeometry unmaps the window and cancels any previous calls to Tk_MaintainGeom- etry for the master-slave pair, so that the slave's geometry and mapped state are no longer maintained automatically. Tk_UnmaintainGeome- try need not be called by a geometry manager if the slave, the master, or any of the master's ancestors is destroyed: Tk will call it automatically. If Tk_MaintainGeometry is called repeatedly for the same master-slave pair, the information from the most recent call supersedes any older information. If Tk_UnmaintainGeometry is called for a master-slave pair that is is not currently managed, the call has no effect. KEYWORDS
geometry manager, map, master, parent, position, slave, unmap Tk 4.0 Tk_MaintainGeometry(3)
All times are GMT -4. The time now is 03:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy