i'm using db2 9.5 for windows. have created the following task ..
call SYSPROC.ADMIN_TASK_ADD ( 'TASK1','2008-10-22
12:05:36.343000',NULL,NULL,'0 0 1 *
*','CCDB','SAMPLE',NULL,NULL,NULL )
here i'm calling a procedure CCDB.SAMPLE with out any input parameter
in ADMIN_TASK_ADD procedure.
i want to known is it a correct way to execute the procedure without
input parameter..
do i need to add values() clause even though I'm not passing any input
parameter.
your help in this regard is highly appreciated.
Regards,
Situ 1 3430
On Oct 22, 7:44*am, situ <SRIDHAR...@rediffmail.comwrote:
i'm using db2 9.5 for windows. have created the following task ..
call *SYSPROC.ADMIN_TASK_ADD ( 'TASK1','2008-10-22
12:05:36.343000',NULL,NULL,'0 0 1 *
*','CCDB','SAMPLE',NULL,NULL,NULL )
here i'm calling a procedure CCDB.SAMPLE with out any input parameter
in ADMIN_TASK_ADD procedure.
i want to known is it a correct way to execute the procedure without
input parameter..
do i need to add values() clause even though I'm not passing any input
parameter.
your help in this regard is highly appreciated.
Regards,
Situ
Correct. If you have no input parameter, using NULL is correct.
The following developerWorks article might be of some interest to you: http://www.ibm.com/developerworks/db...le/dm-0809see/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: J.Beaulieu |
last post by:
Hi
I'll have probably to use sql server soon but prior to that I have a
question concerning priviledges and security.
Is it possible for someone to do like in access, ie creating a
db/table...
|
by: Simon Harvey |
last post by:
Hi everyone,
I was wondering if it is possible, to use SQL to return more than one table
at a time into a dataset. I only know the basics of SQL and so I'm not sure
if I'm just asking a stupid...
|
by: turnstyle |
last post by:
Hey all, sorry for asking such a grunt question, and thanks in advance
for any help...
My hosting ISP offers access to their MS-SQL database, and my
understanding is that it's generally simplest...
|
by: Tcs |
last post by:
My backend is DB2 on our AS/400. While I do HAVE DB2 PE for my PC, I haven't
loaded it yet. I'm still using MS Access. And no, I don't believe this is an
Access question. (But who knows? I...
|
by: Mark Yudkin |
last post by:
The documentation is unclear (at least to me) on the permissibility of
accessing DB2 (8.1.5) concurrently on and from Windows 2000 / XP / 2003,
with separate transactions scope, from separate...
|
by: Elaine |
last post by:
This has to do with self-joins and includes a running balance problem.
Is it possible to do this using SQL alone?
Amortization schedule
--------------------------
Givens: beginning balance,...
|
by: Tiraman |
last post by:
Hi ,
Problem description :
I have 2 assemblies (A.dll And B.dll) .
They are both under the GAC and they are both using the functions of each
other .
Each time that I m doing a change in...
|
by: Roy |
last post by:
Hi all,
I'm creating a project that should always use this date format when displays
the dates or create dates. The back end database is a SQL Server and I like
to know what is the logical way...
|
by: ajocius |
last post by:
It seems every month when I'm diluged by lots of data I fall back on ole
reliable, Excel. But, I get over 50,000 rows of data to scrub. A colleague
of mine suggested I use a database. Seems...
|
by: Sudhakar |
last post by:
A) validating username in php
as part of a registration form a user fills there desired username and
this is stored in a mysql. there are certain conditions for the
username.
a) the username...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |