Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Foreach loop with two variables
Top Forums Shell Programming and Scripting Foreach loop with two variables Post 302950658 by vgersh99 on Monday 27th of July 2015 05:45:56 PM
Old 07-27-2015
does it have to be csh/tcsh?
Code:
#!/bin/ksh
awk '
   FNR==NR {f1[$0];next} 
  {f2[$0]}
END {
   for (f1I in f1)
     for (f2I in f2)
       print "sql " f1I " -u" f2I " <script.sql>> script.log"
}' /local/hd3/dba/tools/build_db_scripts/dbs /local/hd3/dba/tools/build_db_scripts/dbas > /local/hd3/dba/tools/build_db_scripts/run_this

chmod 777 /local/hd3/dba/tools/build_db_scripts/run_this

This User Gave Thanks to vgersh99 For This Post:
deneuve01
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

foreach loop question

Hello, I am new at this forum so please bare with me on this. Within a given directory, I have a list of files in which in each file, I would like to do a substitution. I would like to substitute the string mlcl to mll in each file using the foreach command. I dont quite get how to do that. If... (7 Replies)
Discussion started by: clipski
7 Replies

2. Shell Programming and Scripting

Foreach loop

What am I doing wrong with this foreach loop? foreach var ($argv) @sum = $sum + $var (4 Replies)
Discussion started by: haze21
4 Replies

3. Shell Programming and Scripting

foreach loop

Hi Guys, I have a loop which uses a wildcard i.e. foreach f (*) but when I execute the tcsh file in unix then it gives me an error ->>>>>>>foreach: words not parenthesized<<<<<<<<<<- Any help. (1 Reply)
Discussion started by: abch624
1 Replies

4. Shell Programming and Scripting

foreach loop + 2 variables

In a foreach loop, is it possible for the loop to go through 2 arguments instead of one i.e. instead of foreach i (do stuff for i), we have foreach i j(do stuff for i; do stuff for j) I am working under BASH and TCSH shell environments cheers (3 Replies)
Discussion started by: JamesGoh
3 Replies

5. Shell Programming and Scripting

foreach loop

Hi everyone Does anyone know what is wrong with this script. i keep getting errors foreach filename (`cat testing1`) set string=$filename set depth=`echo "$string" echo $depth end the error is the following testing: line 1: syntax error near unexpected token `(' testing: line 1:... (3 Replies)
Discussion started by: ROOZ
3 Replies

6. UNIX for Advanced & Expert Users

Problem with foreach loop

Hi All, Is there any problem with the below 'foreach' loop? foreach risk_factor ($(cat "$rf_list")) where "rf_list=$SCRIPT/Utility/rflist.txt " I'm wondering, it is throwing below error message: syntax error at line 34: `(' unexpected Any idea/suggestions ? Thanks in advance /... (7 Replies)
Discussion started by: ganapati
7 Replies

7. Shell Programming and Scripting

Using sed with a foreach loop

So I am back again beating my head against the wall with a shell script and getting a headache! I want to change each year in a file (1980, 1981, 1982, 1983, etc.) to the same year followed by a tab. The input is "blah blah (1980) blah blah". I want to get "blah blah (1980 ) blah blah".... (2 Replies)
Discussion started by: Peggy White
2 Replies

8. UNIX for Dummies Questions & Answers

Using the Foreach loop, Needing help

I am trying to make a script for my Counter-Strike: Source servers. What i am wanting it to do is for it to restart each server, the only way i can think of doing this in through for each. Years what i have at the moment. server_start() { START=`ps x | grep SCREEN | grep $SRV | cut -d '?' -f... (5 Replies)
Discussion started by: grahamn95
5 Replies

9. Shell Programming and Scripting

foreach loop problem

Dear all, I wrote a script to download files and move files in directories according to their name. Now here is the problem: Both p101 and p360 data download successfully, but when I move them according to the year and month, only p101 data can be placed at the right location, p360,... (1 Reply)
Discussion started by: handsonzhao
1 Replies

10. UNIX for Dummies Questions & Answers

foreach loop in csh

Hi everyone I'm new to unix and encountered a small problem i couldnt find out a reason why it doesn't work..please help.. in my csh script when i tried to use the foreach loop like this: foreach x ( ls ) echo $x end when i tried to run it, it printed out 'ls' to the std out instead of... (3 Replies)
Discussion started by: ymc1g11
3 Replies

LEARN ABOUT PHP

dba_open

DBA_OPEN(3)								 1							       DBA_OPEN(3)

dba_open - Open database

SYNOPSIS

       resource dba_open (string  $path, string  $mode, [string  $handler], [mixed  $...])

DESCRIPTION

       dba_open(3) establishes a database instance for $path with $mode using $handler.

PARAMETERS

	      o $path
		- Commonly a regular path in your filesystem.

	      o $mode
		-  It is r for read access, w for read/write access to an already existing database, c for read/write access and database creation
		if it doesn't currently exist, and n for create, truncate and read/write access. The database is  created  in  BTree  mode,  other
		modes (like Hash or Queue) are not supported.  Additionally you can set the database lock method with the next char. Use l to lock
		the database with a .lck file or d to lock the databasefile itself. It is important that all of your applications do this  consis-
		tently.   If you want to test the access and do not want to wait for the lock you can add t as third character. When you are abso-
		lutely sure that you do not require database locking you can do so by using - instead of l or d. When none of d, l or -  is  used,
		dba will lock on the database file as it would with d.

	      Note

		      There  can  only	be  one  writer for one database file. When you use dba on a web server and more than one request requires
		     write operations they can only be done one after another. Also read during write is not allowed. The dba extension uses locks
		     to prevent this. See the following table:

		     DBA locking

		     +-------------+---------------+---+---+---+---+---+---+---+
		     |already open |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rl"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rlt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wl"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wlt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rd"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rdt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wd"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wdt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     +-------------+---------------+---+---+---+---+---+---+---+
		     |	not open   |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "rl" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "wl" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "rd" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "wd" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     +-------------+---------------+---+---+---+---+---+---+---+
			    ook: the second call will be successfull.

			    owait: the second call waits until dba_close(3) is called for the first.

			    ofalse: the second call returns false.

			    oillegal: you must not mix
			      "l" and "d" modifiers for $mode parameter.

	      o $handler
		-  The	name of the handler which shall be used for accessing $path. It is passed all optional parameters given to dba_open(3) and
		can act on behalf of them.

RETURN VALUES

	Returns a positive handle on success or FALSE on failure.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 4.3.0	|						    |
       |	|						    |
       |	|  It's possible to open database files  over  net- |
       |	| work	connection.  However in cases a socket con- |
       |	| nection will be used (as with http  or  ftp)	the |
       |	| connection will be locked instead of the resource |
       |	| itself. This is important to know since  in  such |
       |	| cases  locking  is simply ignored on the resource |
       |	| and other solutions have to be found. 	    |
       |	|						    |
       +--------+---------------------------------------------------+
SEE ALSO

       dba_popen(3), dba_close(3).

PHP Documentation Group 													       DBA_OPEN(3)
All times are GMT -4. The time now is 02:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy