I am use unix shell script to called an sql Script to query data in my shell program.
but my script on function "sysdate" not work !!
Could you tel me,How can i use function "sysdate" on unix or can replace the other function in my script to get data in system date.
Ex. my pl update.sql
Last edited by Franklin52; 10-21-2011 at 07:51 AM..
Reason: Please use code tags, thank you
Hi,
We have a DEC Alpha 4100 Server with OSF1 Digital Unix 4.0.
Can any one tell me, if there are any commands on this Unix which are equivalent to "top" and "sar" on HP-UX or Sun Solaris ?
I am particularly interested in knowing the CPU Load, what process is running on which CPU, etc.
... (1 Reply)
Hi Friends,
Can any of you explain me about the below line of code?
mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`
Im not able to understand, what exactly it is doing :confused:
Any help would be useful for me.
Lokesha (4 Replies)
im a new student in programming and im stuck on this question so please please HELP ME. thanks.
the question is this:
enter a command to delete all files that have filenames starting with labtest, except labtest itself (delete all files startign with 'labtest' followed by one or more... (2 Replies)
Hi,
I need to pass 4 parameters from Oracle Procedure to Unix Shell script..
procedure signature :-
UNIX Shell script:
Problem: 1. Suppose pdffile and pdfresult has Null values in Oracle procedures but unix shell will read parameters by spaces so
I am getting wrong parameters... (7 Replies)
Hi,
I have line in input file as below:
3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL
My expected output for line in the file must be :
"1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL"
Can someone... (7 Replies)
I am trying to find lines in a text file larger than 3 Gb that start with a given string. My command looks like this:
$ look "string" "/home/patrick/filename.txt"
However, this gives me the following message:
"look: /home/patrick/filename.txt: File too large"
So, I have two... (14 Replies)
How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address
and column 3 contains “cc” e-mail address to include with same email.
Sample input file, email.txt
Below is an sample code where... (2 Replies)
Hello.
System : opensuse leap 42.3
I have a bash script that build a text file.
I would like the last command doing :
print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt
where :
print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies
LEARN ABOUT DEBIAN
rt-shredder-4
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)