Hi,
I need to get some files from a server via ftp. normaly I use following scrip, it is worrking fine.
cd dir_name
ftp -v -n "10.76.170.17" << cmd
user "rbi" "rbi"
cd recordreceive
prompt... (0 Replies)
Hi,
Can anyone plz share their experience with -
Building shell script to append the file with date in following format-
Filename_MMDDYYYY.txt
Thanks in advance (2 Replies)
Hi,
i have a sql file named sample.sql. The query is given below.
select count(*) from $TABLE_NAME
In the main script, i am sourcing this sql. I need to replace the $TABLE_NAME with actual value, before running the query. How can i achieve that?
The logic i tried is given below:... (3 Replies)
Hi,
I want to compare today's date(DDMMYYYY) with yesterday(DDMMYYYY) from system date,if (today month = yesterday month) then execute alter query else do nothing.
The above requirement i want in Shell script(KSH)...
Can any one please help me?
Double post, continued here. (0 Replies)
my file has thousands of line but let me show what i want to achieve... here is one line from that file
cat fileName.txt
(2,'','user3002,user3003','USER_DATA_SINGLE',1,0,0,'BACKUP',2,NULL,0,450,NULL,NULL,'','2011-05-10... (13 Replies)
hello,
can someone please suggest a script to rename a file that was generated today and filename that being generated daily starts with date, its a xml file.
here is example.
# find . -type f -mtime -1
./20130529_4995733057260357019.xml
#
this finename should be renamed to this format.... (6 Replies)
Hi there,
is it possible to get the actual date minux six months with just a simple command?
It's easy with Linux but on HP Unix (for me) impossible ;)
Best wishes (3 Replies)
Hi ,
I have to schedule one job in crontab, but with two parameters.
1. Sysdate in YYYYMMDD format
2. Sysdate - 7 in YYYYMMDD format
Please suggest how to do that.
Thanks in advance. (1 Reply)
I am trying to work on a script where it is a *(star) delimited file has a multiple lines starts with RTG and 3rd column=TD8 I want to substring the date part and
I want to replace with currentdate minus 15 days. Here is an example. iam using AIX server
$ cat temp.txt
RTG*888*TD8*20180201~... (1 Reply)
Hello All,
we what we call a parameter file (.txt) where my application read dynamic values when the job is triggered, one of such values are below:
abc.txt
------------------
line1
line2
line3
$$EDWS_DATE_INSERT=08-27-2019
line4
$$EDWS_PREV_DATE_INSERT=08-26-2019
I am trying to... (1 Reply)
Discussion started by: pradeepp
1 Replies
LEARN ABOUT DEBIAN
alzabo::runtime::inserthandle
Alzabo::Runtime::InsertHandle(3pm) User Contributed Perl Documentation Alzabo::Runtime::InsertHandle(3pm)NAME
Alzabo::Runtime::InsertHandle - A handle representing an insert
SYNOPSIS
my $handle =
$table->insert_handle
( columns => [ $table->columns( 'name', 'job' ) ] );
my $faye_row =
$handle->insert( values =>
{ name => 'Faye',
job => 'HK Pop Chanteuse' } );
my $guesch_row =
$handle->insert( values =>
{ name => 'Guesch',
job => 'French Chanteuse and Dancer' } );
DESCRIPTION
This object is analogous to a DBI statement handle, and can be used to insert multiple rows into a table more efficiently than repeatedly
calling "Alzabo::Runtime::Table->insert()".
METHODS
Objects of this class provide one public method:
insert
This method is used to insert a new row into a table.
It accepts the following parameters:
* values
This should be a hash reference containing the values to be inserted into the table.
If no value is given for a primary key column and the column is "sequenced" then the primary key will be auto-generated.
If values are not provided for other columns which were given when "Alzabo::Runtime::Table->insert_handle" was called, this method
first checks to see if a value was provided for the column when "Alzabo::Runtime::Table->insert_handle" was called. If none was pro-
vided, then the column's default value is used.
If column values were passed to "Alzabo::Runtime::Table->insert_handle", then these can be overridden by values passed to this method.
It is not possible to override column values that were given as SQL functions when "Alzabo::Runtime::Table->insert_handle" was called.
This method returns a new "Alzabo::Runtime::Row" object.
Throws: "Alzabo::Exception::Logic", "Alzabo::Exception::Params"
perl v5.8.8 2007-12-23 Alzabo::Runtime::InsertHandle(3pm)