Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Delete database table based on months using script.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Delete database table based on months using script.
# 1  
Old 08-30-2007
Delete database table based on months using script.
HI All,

Newbie here.
I have a script which generates the tables in teradata database with time stamp like below.I want to add some more code to delete the archive tables which are 2months old.

. $HOME/.profile
t_name=$1
procdate=`date +%y%m%d`
log_dir=$Folder/log
tab=`echo $t_name"_"$procdate`
tab_create=$log_dir/$t_name.txt
param_dir=$Folder/parameter
echo ".run file=$param_dir/logon.txt;" > $tab_create
echo "DATABASE XYZ;" >> $tab_create
echo ".echoreq off;" >>$tab_create
echo ".SET FOLDLINE off; " >>$tab_create
echo "rename table $t_name to $tab;" >> $tab_create
echo ".if errorcode =3803 then .goto prob38;" >> $tab_create
echo "create table $t_name as $tab with no data;" >> $tab_create
echo ".quit;" >> $tab_create
echo ".LABEL prob38" >> $tab_create
echo "drop table $tab;" >> $tab_create
echo "rename table $t_name to $tab;" >> $tab_create
echo "create table $t_name as $tab with no data;" >> $tab_create
echo ".quit;" >> $tab_create
echo "EOF" >> $tab_create
bteq < $tab_create> $log_dir/$tab_create_$tab.log

Can someone help me on this..

Thanks.

Regards,
Mav.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to log file processing details to database table usnig UNIX shell script?

we are getting files on daily basis.we need to process these files. i need a unix shell script where we can count 1-The no of files processed 2-No of data/record processed for each files. The script should log these details into a database table. If there is any error while file... (3 Replies)
Discussion started by: Atul kumar
3 Replies

2. Shell Programming and Scripting

Script needed to delete to the list of files in a directory based on last created & delete them

Hi My directory structure is as below. dir1, dir2, dir3 I have the list of files to be deleted in the below path as below. /staging/retain_for_2years/Cleanup/log $ ls -lrt total 0 drwxr-xr-x 2 nobody nobody 256 Mar 01 16:15 01-MAR-2015_SPDBS2 drwxr-xr-x 2 root ... (2 Replies)
Discussion started by: prasadn
2 Replies

3. Shell Programming and Scripting

Intelligent Script to Insert Records in Database Table

Hello All Members, I am new to this forum and to the shell scripting. I want to write a shell script to do the following: Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the... (18 Replies)
Discussion started by: chetanojha
18 Replies

4. Red Hat

Need Script to ZIP/SAVE & then DELETE Log file & DELETE ZIPS older than 12 months

ENVIROMENT Linux: Fedora Core release 1 (Yarrow) iPlanet: iPlanet-WebServer-Enterprise/6.0SP1 Log Path: /usr/iplanet/servers/https-company/logs I have iPlanet log rotation enabled rotating files on a daily basis. The rotated logs are NOT compressed & are taking up too much space. I... (7 Replies)
Discussion started by: zachs
7 Replies

5. Shell Programming and Scripting

Delete folder in a directory which are two months old

I need help. I have to create a script which will delete multiple directory (folders) that are two months old. Example, I have folders dated April, May, June and July. I have to delete folders April and May and retain June and July and as such that when the July month lapse, the folder June will be... (2 Replies)
Discussion started by: jasperux
2 Replies

6. Shell Programming and Scripting

Script to count the dataflow in a table in oracle database

I need to write a unix shell script to connect to oracle database and retrieve data from a table, the script should count the total number of rows till date in that table number of rows which are getting filled per hour on current day and the peak hour of the current day number of rows which are... (5 Replies)
Discussion started by: PhAnT0M
5 Replies

7. Shell Programming and Scripting

Delete table from postgresql using shell script

Hi, I need help to Delete table from postgresql using shell script. Anyone know about it? Thanks Regards, Sajjad (1 Reply)
Discussion started by: sajjad
1 Replies

8. Shell Programming and Scripting

Delete oracle table from UNIX script

Hi, Is it possible to delete oracle table datas using a UNIX script/Shell script? how can we do this?? I have oracle Database and i have to delete millions of record everyday.. adn it is taking hours togather to execute this. Will the delete query triggered from UNIX be faster can we expect any... (1 Reply)
Discussion started by: Codesearcher
1 Replies

9. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal. (1 Reply)
Discussion started by: royal9482
1 Replies

10. Shell Programming and Scripting

Delete 6 months old files

Hi, Iam trying to delete 6 months old files. Iam using the following script -ctime +190 -type f -exec echo rm {} \; Iam getting an error saying -ctime not found. (6 Replies)
Discussion started by: Sompalle Jalaja
6 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

mysql::diff::database

MySQL::Diff::Database(3pm)				User Contributed Perl Documentation				MySQL::Diff::Database(3pm)

NAME

       MySQL::Diff::Database - Database Definition Class

SYNOPSIS

	 use MySQL::Diff::Database;

	 my $db = MySQL::Diff::Database->new(%options);
	 my $source    = $db->source_type();
	 my $summary   = $db->summary();
	 my $name      = $db->name();
	 my @tables    = $db->tables();
	 my $table_def = $db->table_by_name($table);

	 my @dbs = MySQL::Diff::Database::available_dbs();

DESCRIPTION

       Parses a database definition into component parts.

METHODS

   Constructor
       new( %options )
	   Instantiate the objects, providing the command line options for database access and process requirements.

   Public Methods
       o   source_type()

	   Returns 'file' if the data source is a text file, and 'db' if connected directly to a database.

       o   summary()

	   Provides a summary of the database.

       o   name()

	   Returns the name of the database.

       o   tables()

	   Returns a list of tables for the current database.

       o   table_by_name( $name )

	   Returns the table definition (see MySQL::Diff::Table) for the given table.

FUNCTIONS

   Public Functions
       o   available_dbs()

	   Returns a list of the available databases.

	   Note that is used as a function call, not a method call.

COPYRIGHT AND LICENSE

       Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       mysqldiff, MySQL::Diff, MySQL::Diff::Table, MySQL::Diff::Utils

AUTHOR

       Adam Spiers <mysqldiff@adamspiers.org>

perl v5.14.2							    2012-04-06						MySQL::Diff::Database(3pm)