| |
by: Peanut044 |
last post by:
Hi all!
I am in need of writing a few stored procedures.
The first one is to create a stored procedure to recover a database
from backup and the second one is to create a stored procedure to...
|
by: Roger |
last post by:
have a stored procedure running on DB2 V7 Z/os calling a COBOL
program to do some inserts. The stored procedure have 3 input columns
and one column is of varchar(32648)
The stored procedure is...
|
by: satish mullapudi |
last post by:
Hi,
I am using DB2 v8.2 & jdk 1.4.
1. I have a java program which returns an array which contains 1 to 5
numbers.
The code:
public class ArrayTest
{
public static final int ARRAY_SIZE = 5;...
|
by: sri |
last post by:
My environment is DB2v9.1, Windows/AIX and I am trying to compile the
stored proc below and I am getting an error, "ERROR SQL0104N An unexpected token "WITH" was found following "User_ID
=...
|
by: cuddles |
last post by:
Hi,
Im very new to this and i need some urgent help. I'm converting a COBOL stored procedure into an SQL stored procedure with logic. Im using IBM DB2 and im not sure about the syntax of the...
|
| |
by: Subrat Das |
last post by:
Java application invokes my stored procedure. But i am getting a strange exception when the application calls the procedure. The exception is:
"The statement or function must be executed in the...
|
by: roshnair |
last post by:
Hi i have a small problem . I need to change one query to stored procedure and call it in my vb.net application.Query is :
Select * from emp where empid in (‘001’,’002’)
For this query I...
|
by: ponvijaya |
last post by:
Hi all,
I have used a substring function inside my stored procedre as
set @dummy1=substring(@dummyid,2);
but when i print and check the value of @dummy1 as
select @dummy1;
|
by: db2readlog |
last post by:
Hi,
Im trying to execute a C Stored Procedure(getTransactionId.sqc) from one of Developer Works articles "Transaction IDs in DB2 -- retrieve a unique identifier for a unit of work from the DB2 log...
|
by: mohit1286 |
last post by:
my stored procedure in db2 is--->
create procedure temp_bill(in UPC_cd character(6))
language sql
begin
declare prod_cd character(8);declare prod_desc varchar(30);declare discount...
|
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,...
|
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
24
