Possibly add a script like this into your crontab. How often you want to run it in your crontab is entirely up to you and what you need this script to do...
without more specifics as to what you're trying to do and so on I couldn't really think of anything else to post but hopefully this will be of some use to you.
Do not use a variable name which is the same as the command.
Hi,
I logged in to a Sun unix box. I would like to know where my unix id is stored. So I did a "more /etc/passwd | grep <my unix id> but it did not show up. Where can I find my unix id and what is the command to see it?
Thanks in advanced,
XZOR (4 Replies)
All,
We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running... (3 Replies)
Hi All,
I want to run/execute a stored procedure (sybase) from unix command prompt not by login in isql utility which is provided my Sybase guys.
Is there way ..?
Thanks in advance for your help !!!
Regards,
Arvind S. (0 Replies)
Hi Guys,
I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script.
When i use the following in my script,
db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE
I am getting an error..
Please... (1 Reply)
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
Hi,
My stored procedure returns a value.
How to retrieve the value and display in unix.
Stored procedure
CREATE OR REPLACE
PROCEDURE gohan(num INT) IS
BEGIN
DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num);
END;
Unix Scripting i used
sqlplus -s... (7 Replies)
Hi Dudes :)
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
declare
res varchar2(10);
begin
odm_load_check('PRE_SANITY',res);
dbms_output.put_line(res);
end;
select * from error_log;
truncate table error_log;
select * from test; (1 Reply)
The db2 table stores the unix path as below
PARM VALUE
RootPath $SRootDir
Target $SRootDir/target
$SRootDir is set in the env variable as /home/test/root
In the shell script i read the table value and store it in a variable
pth=db2 -x "select VALUE from... (2 Replies)
Hi,
I am using sql server 2008 version and invoking the stored procedure using unix script. I want to know the procedure of killing the stored procedure in sql server.
If I kill -9 the unix script will it also terminate the process at the SQL server. When I executed the kill -9 PID in unix... (2 Replies)
Discussion started by: Rahul Raj
2 Replies
10. Post Here to Contact Site Administrators and Moderators
Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File, somehow i tried to find a solution but when i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
LEARN ABOUT DEBIAN
wiki-toolkit-revert-to-date
WIKI-TOOLKIT-REVERT-TO-DATE(1p) User Contributed Perl Documentation WIKI-TOOLKIT-REVERT-TO-DATE(1p)NAME
wiki-toolkit-revert-to-date - Revert the state of a Wiki::Toolkit instance to an earlier point in time.
SYNOPSIS
# Removes any changes made to a Wiki::Toolkit instance since a given date
# (and optionally time), restoring it to the state at that point.
wiki-toolkit-revert-to-date --type postgres
--name mywiki
--user wiki
--pass wiki
--host 'db.example.com'
--port 1234
--date 2007-01-05
--time 11:23:21
DESCRIPTION
Takes three mandatory arguments:
type
The database type. Should be one of 'postgres', 'mysql' and 'sqlite'.
name
The database name.
date
The date to revert the state back to, in the format YYYY-MM-DD
five optional arguments:
time
The time (on the specified date) to revert the state back to, in the format hh:mm:ss. If not specified, will use midnight.
user
The user that connects to the database. It must have permission to create and drop tables in the database.
pass
The user's database password.
host
The hostname of the machine the database server is running on (omit for local databases).
port
The port number that the database server is expecting connections to.
AUTHOR
Nick Burch
COPYRIGHT
Copyright (C) 2006 Nick Burch. All Rights Reserved.
This code is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Wiki::Toolkit
perl v5.14.2 2011-09-25 WIKI-TOOLKIT-REVERT-TO-DATE(1p)