10-31-2008
I'm not a db2 expert, but the best way to test a database is to create a small test table within the database with only one filed most likely the actual date.
testing steps:
* update the date field with the current date
* select the date filed
compare the result.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to create an automated script which is called by another maually executed script.
The condition is that the no one should be able to manually execute the automated script.
The automated script can be on the same machine or it can be on a remote machine.
Can any one suggest a check in the... (1 Reply)
Discussion started by: adi_bang76
1 Replies
2. UNIX for Dummies Questions & Answers
UNIX Shell Script
I'm in /home/suneel dirctory
in that directory need to check for a path for example com/src/resources
If Path exists need to copy the files from one directory
If path not exist need to create the folders and copy the files
UNIX shell script help required (3 Replies)
Discussion started by: suneelc
3 Replies
3. Shell Programming and Scripting
Hi,
I need Unix Shell Script Review Check list in the format of word or excel.
Can any one provide the review checklist for unix shell script. Pls. (1 Reply)
Discussion started by: praka
1 Replies
4. Shell Programming and Scripting
Hi all,
I have written the script to check the connectivity of the Database ,the scripts show me the correct error when i try to give the wrong credential's but it also show Connected and trigger's the child jobs which that should not happen , whenever the connection is not established properly... (2 Replies)
Discussion started by: bshivali
2 Replies
5. Shell Programming and Scripting
Hi,
It will be great help if any of them can provide or tell which scripting is possible to write for checking folder exists or not in Windows server from Unix/Windows machine.
If folder doesn't exist then need to create the folder through script and copy the files.
It is on very... (1 Reply)
Discussion started by: prakashchakra7
1 Replies
6. Shell Programming and Scripting
Hi,
I am completely new to shell scripting. Basically I am wanting to create a simple while loop script to check if a network connection is available from 'netstat -a' and if its present then output a character to the serial port. I think i am nearly there.. but need some assistance.. this is... (9 Replies)
Discussion started by: zippyzip
9 Replies
7. Shell Programming and Scripting
check the connectivity of the DBs through script, script should exit if no connection and display the output as below.
connectivity for DB1 is OK
connectivity for DB2 is OK
connectivity for DB3 is FAILED
for DB in 1 2 3
do
(sqlplus -s... (5 Replies)
Discussion started by: only4satish
5 Replies
8. Shell Programming and Scripting
I use below command to log in to oracle database
sqlplus username/passwordWhen i enter into sql prompt i press quitIf there are any errors it will show just below the output of sqlplus username/password. The errors generally start with keyword ORA can we do this by using a unix shell script.?... (4 Replies)
Discussion started by: Nakul_sh
4 Replies
9. Shell Programming and Scripting
Hi,
I need a script which check the FTP connections, if its working fine then no issue. Incase not working fine then Trigger the mail.
Please help on this.
Thanks (4 Replies)
Discussion started by: Keshav Kalra
4 Replies
10. Shell Programming and Scripting
Hello Guys,
Here is the requirement!!
I want to check the mail with attachment received or not through unix scripting.
And send an notification email when mail with attachment already received.
Any thoughts on this is much appreciated!!
Regards,
Harry (0 Replies)
Discussion started by: dharry2017
0 Replies
LEARN ABOUT DEBIAN
dbix::class::timestamp
DBIx::Class::TimeStamp(3pm) User Contributed Perl Documentation DBIx::Class::TimeStamp(3pm)
NAME
DBIx::Class::TimeStamp - DBIx::Class extension to update and create date and time based fields
DESCRIPTION
Works in conjunction with InflateColumn::DateTime to automatically set update and create date and time based fields in a table.
SYNOPSIS
package My::Schema;
__PACKAGE__->load_components(qw( TimeStamp ... Core ));
__PACKAGE__->add_columns(
id => { data_type => 'integer' },
t_created => { data_type => 'datetime', set_on_create => 1 },
t_updated => { data_type => 'datetime',
set_on_create => 1, set_on_update => 1 },
);
Now, any update or create actions will update the specified columns with the current time, using the DateTime inflator.
This is effectively trigger emulation to get consistent behavior across databases that either implement them poorly or not at all.
METHODS
get_timestamp
Returns a DateTime object pointing to now. Override this method if you have different time accounting functions, or want to do anything
special.
The date and time objects in the database are expected to be inflated. As such you can be pretty flexible with what you want to return
here.
AUTHOR
J. Shirley <jshirley@gmail.com>
CONTRIBUTORS
Florian Ragwitz (Porting to DBIx::Class::DynamicDefault)
LTJake/bricas
COPYRIGHT & LICENSE
Copyright 2009 J. Shirley, all rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2010-09-05 DBIx::Class::TimeStamp(3pm)