09-20-2010
i'm using db connect to <databse-name> user <user_name> using <password> command to connect to database....
i need not to connect to databse inside the loop as I am already establishing a connection in my script
all I need is the command to execute the SQL
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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
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)