Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to use LOOP in Unix Script?
Top Forums Shell Programming and Scripting How to use LOOP in Unix Script? Post 302454998 by 116@434 on Monday 20th of September 2010 01:49:37 PM
Old 09-20-2010
Not sure how to connect with db2. I will give you a sample with sqlplus (connects to oracle). Please edit the corresponding code as per db2:

Code:
for i in `cat $input_file`
do
count=$(sqlplus id/password@connect_string <<EOSQL
$i
exit
EOSQL
)
[ $count -gt 200000 ] && exit
done

But this is will slow down the processing. because you have to connect and disconnect with the database in every iteration. Just check if this works in your case.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Please help with UNIX while loop...

Hi all. I am trying to execute a while loop that reads a log file containing a file listing, and it compares file sizes, etc. But I am getting an error that makes it seem like it is not reading the log file line by line. When I do a 'more' on the log file, it doesn't appear to be wrapped... ... (1 Reply)
Discussion started by: gerard1
1 Replies

2. Shell Programming and Scripting

for loop in unix

hi, can any one suggest why the program 2 is not working. only difference is for ab in *.txt for ab in a_DATA.txt b_DATA.txt c_DATA.txt ------------------------------------ Program :1 (working fine) #!/bin/ksh for ab in a_DATA.txt b_DATA.txt c_DATA.txt suf="_" echo "old->... (1 Reply)
Discussion started by: deep_kol
1 Replies

3. Shell Programming and Scripting

Unix Shell Script to loop over Directory and send Filesname as parameters

Hi there I'm new to UNIX scripting; I’m stuck with the following I have an Oracle SQL script that takes three parameters 1- File Name 2- File Path 3- File creation date Under UNIX I have a folder where files will be placed frequently and I need to upload those files to Oracle, what I need... (3 Replies)
Discussion started by: windjashi
3 Replies

4. Shell Programming and Scripting

for loop in Unix

This is the content of a file work.log 1 TGBUS I-US 0;15;83 i did this for i in `cat work.log` do echo $i done I wanted the out put to be 1 TGBUS I-US 0;15;83 But the output appears as 1 TGBUS I-US 0;15;83 For Loop treats space as a delimiter. Can i overrride this space as... (10 Replies)
Discussion started by: kinny
10 Replies

5. Shell Programming and Scripting

How to loop use while loop in csh script?

Hi all, i got 2 text file. file.txt value.txt i want use C shell script to write out while both of the file got different limit....how i going to write it in 1 while loop? (4 Replies)
Discussion started by: proghack
4 Replies

6. UNIX for Dummies Questions & Answers

Help with unix for loop

Hi, I have a command that I want to translate to Unix. I mostly work with Windows and because of that I am stuck on a part. What I cannot find on the internet is skipping the first lines in a for loop and using a certain word/token. (I know how to do a normal loop with output) I need to skip... (1 Reply)
Discussion started by: flappy
1 Replies

7. Shell Programming and Scripting

foreach loop in unix script

Hi all, I have a script which searches for all sql files in the current directory and replaces all sql files with an underscore with a dash. The next part I need to do is record the number of changes made (underscore to dash) and display this value (e.g.2). This is what I have so far; find /... (17 Replies)
Discussion started by: shawi
17 Replies

8. Shell Programming and Scripting

UNIX shell script - cut specified line and perform loop

Guys, I have a requirement as below. consider,if i use df command, its getting the below output. file system kbytes used avail %used Mounted on /dev/sample/ 45765 40000 5765 50% / /dev/filesys/ 30000 20000 1000 80% /u .... .... Now i wanted to cut the /u... (11 Replies)
Discussion started by: AraR87
11 Replies

9. Shell Programming and Scripting

UNIX for loop

Guys, Please help me on the below.. sample.prm /u/test/: mail=123@gmail.com purgedays=30 zipdays=7 purgefile=log.gz zipfile=log /u/test/: mail=123@gmail.com purgedays=30 purgefile=txt.gz zipfile=txt zipdays=7 (2 Replies)
Discussion started by: AraR87
2 Replies

10. Shell Programming and Scripting

UNIX shell script for loop issue

Guys, Please help on the below. sample.prm /u/test/: mail=123@gmail.com purgedays=30 zipdays=7 purgefile=log.gz zipfile=log /u/test/: mail=123@gmail.com purgedays=30 purgefile=txt.gz zipfile=txt zipdays=7 (1 Reply)
Discussion started by: AraR87
1 Replies

LEARN ABOUT DEBIAN

cgen

fileutil::magic::cgen(3tcl)					  file utilities				       fileutil::magic::cgen(3tcl)

__________________________________________________________________________________________________________________________________________________

NAME

       fileutil::magic::cgen - Generator core for compiler of magic(5) files

SYNOPSIS

       package require Tcl  8.4

       package require fileutil::magic::cgen  ?1.0?

       package require fileutil::magic::rt  ?1.0?

       package require struct::tree

       package require struct::list

       ::fileutil::magic::cgen::2tree script

       ::fileutil::magic::cgen::treedump tree

       ::fileutil::magic::cgen::treegen tree node

_________________________________________________________________

DESCRIPTION

       This  package  provides the generator backend for a compiler of magic(5) files into recognizers based on the fileutil::magic::rt recognizer
       runtime package. For the compiler frontend using this generator see the package fileutil::magic::cfront.

COMMANDS

       ::fileutil::magic::cgen::2tree script
	      This command converts the recognizer specified by the script into a tree and returns the object command of that tree as its  result.
	      It uses the package struct::tree for the tree.

	      The script is in the format specified by magic(5).

       ::fileutil::magic::cgen::treedump tree
	      This  command  takes a tree as generated by ::fileutil::magic::cgen::2tree and returns a string encoding the tree for human consump-
	      tion, to aid in debugging.

       ::fileutil::magic::cgen::treegen tree node
	      This command takes a tree as generated by ::fileutil::magic::cgen::2tree and returns a Tcl script, the recognizer for the file types
	      represented by the sub-tree rooted at the node.  The generated script makes extensive use of the commands provided by the recognizer
	      runtime package fileutil::magic::rt to perform its duties.

BUGS, IDEAS, FEEDBACK
       This document, and the package it describes, will undoubtedly contain bugs and other problems.  Please report such in the category fileutil
       :: magic of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you may
       have for either package and/or documentation.

SEE ALSO

       file(1), fileutil, magic(5)

KEYWORDS

       file recognition, file type, file utilities, mime, type

CATEGORY

       Programming tools

fumagic 								1.0					       fileutil::magic::cgen(3tcl)
All times are GMT -4. The time now is 12:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy