8 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
Good afternoon:
I need your help please, Im new at Unix nd specially Unix applicationas like oracle and Ive got this problem:
I was asked to execute the next script using nohup in order to not hang up the session because it was supposed to connect to the database and then insert about 2... (3 Replies)
Discussion started by: alexcol
3 Replies
2. Shell Programming and Scripting
Hello all, I tried searching for something similiar before posting but couldn't come up with anything that fit what I need.
In Linux, I'm trying to parse through a number of files and take the info in them and put it into mysql. My file is a dump from an expect script:
---filename... (3 Replies)
Discussion started by: hamanjam
3 Replies
3. UNIX Desktop Questions & Answers
Hello Experts !!!
Im new to this so, please bear with me !
I have the following 2 sql statements
create table CMD_NEW_USER as
Select FD.EMPLOYEE, FD.PASTUSER, .....
FROM REPORTS FS, TASKLIST FD
WHERE FS.EMPLOYEEID = FD.EMPLOYEEID ;
create table CMD_OLD_USER as
Select FD.EMPLOYEE,... (4 Replies)
Discussion started by: OMLEELA
4 Replies
4. Shell Programming and Scripting
Hi ,
Daily I sneding report to client about the status of State 2 jobs in Control M .
I would like to schedule it via cron . I am using teh following command :
sudo su - <control M server Name>
then reach to the control M server
then run
#isql
<It ask for the password >
... (1 Reply)
Discussion started by: chandancsc
1 Replies
5. Shell Programming and Scripting
Hi,
I need to write a shell script file that does
1)Connects to DB using SQL plus
2)Do some SQL query like select * from....
3)Based on the output that I got from the sql query I will have to write a if else loop.
Plz let me know how to write the shell scripting for this.
Thanks for... (1 Reply)
Discussion started by: villain41
1 Replies
6. AIX
hi everybody,
i am Talip, a begginner at unix based systems and i have a problem (actually, we may think myself as the problem, in this situation).
i am not sure if this is the correct platform for my questions. if it is not please forgive me about this inappropriate mail.
what i have:
*... (2 Replies)
Discussion started by: talipk
2 Replies
7. Shell Programming and Scripting
hi,
plz let me know one example in using sql command in shell script
thanks inadvance
-bali. (1 Reply)
Discussion started by: balireddy_77
1 Replies
8. Shell Programming and Scripting
Hi gurus,
Being a newbie not sure whether iam asking the right question?
can we use oracle commands in unix for ex: to read a count on a table.
if so, what needs to be configured and etc..
any kind of help is appreciated.
Thanks
sish (6 Replies)
Discussion started by: sish78
6 Replies
rt-shredder(8) Request Tracker Reference rt-shredder(8)
NAME
rt-shredder - Script which wipes out tickets from RT DB
SYNOPSIS
rt-shredder --plugin list
rt-shredder --plugin help-Tickets
rt-shredder --plugin 'Tickets=query,Queue="general" and Status="deleted"'
rt-shredder --sqldump unshred.sql --plugin ...
rt-shredder --force --plugin ...
DESCRIPTION
rt-shredder - is script that allow you to wipe out objects from RT DB. This script uses API that RT::Shredder module adds to RT. Script
can be used as example of usage of the shredder API.
USAGE
You can use several options to control which objects script should wipeout.
OPTIONS
--sqldump <filename>
Outputs INSERT queries into file. This dump can be used to restore data after wiping out.
By default creates files <RT_home>/var/data/RT-Shredder/<ISO_date>-XXXX.sql
--object (DEPRECATED)
Option has been deprecated, use plugin "Objects" instead.
--plugin '<plugin name>[=<arg>,<val>[;<arg>,<val>]...]'
You can use plugins to select RT objects with various conditions. See also --plugin list and --plugin help options.
--plugin list
Output list of the available plugins.
--plugin help-<plugin name>
Outputs help for specified plugin.
--force
Script doesn't ask any questions.
SEE ALSO
RT::Shredder
perl v5.14.2 2013-05-22 rt-shredder(8)