i use aqua data studio 4.7.2 to see explain plan, but i get below error:
Describe Error: Failed to execute EXPLAIN plan: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: USER.DUAL
Please convert this stored procedure from DB2 for LUW to DB2 for ZOS.
CREATE
PROCEDURE CREATE_COMPONENT_EVENT(IN useTablespace_fl CHAR(1))
result sets 1
language sql
BEGIN
...
I am trying to access data from IBM Universe database (running on HP UNIX) using Java code.
I am using UniJDBC driver to access this data.
Following is my program to access the data:
...
I'm well versed with DB2 z/OS. I'm new to UDB. I'm working with DB2 UDB in a J2EE environment.
a) The table i'm referring to needs to be online 24X7. Every nite a load is to be done to the ta...
i am using DB2 as Database and c#.net 2.0 as front end.
i want to accesss database tables in DB2, so i use odbc cconnection.
my select query is some waht like:
"select * from SWIPEDATA"...
Hi,
I am using ISeries navigator for programming my DB2 stored procedures. I created a stored procedure which basically creates a savepoint and then deletes a record from a table and then...
when i try to backup a database it come out "database is currently in use",
so i can db2 "force applications all", then backup again.
but the problem is when i "force applications all", it...
I'm stumped ... I've removed logic down to a simplest form ...
--------------------------------------------------------------------------------
When my Function has "WITH REPLACE" ... ERROR:...
We are running DB2 V8 on z/OS 1.7. For the first time, we are trying to get SQL Stored Procedures to run. When we run the code pasted below from Stored Procedure Builder, it returns zeroes for...
All,
I've spent quite a while at this point working on and off with Microsoft's SQL Server product. One thing I learned (painfully) early on, is that database indexes have to be defragmented...
Hi Experts,
I have a ORACLE procedure, what i want is its equivalent IBM DB2 (UDB) procedure. I know sql but i have a little knowledge of pl/sql. The following is the code..
CREATE TABLE...
Is there an equivalent to Postgres's "VACUUM" command in DB2 to shrink the database when it grows too much, in other words to release unused space from files? I need to call it on "per databas...
I am running a DB2 database running Peoplesoft and I need to increment a number in a field, and have the update return the value that it was updated to.
Any quick answers on how to do it. I...
Hi,
In one of my queries i have a requirement to extract a certain number from a field which is defined as a VARCHAR field.
An example of the string is:
FN|KEVIN|LN|XOOOOOOO|MN|P|CFN||...
Hi!
I have been doing some research regarding to performance on DB2 on both LUW and Mainframe and I want to throw out a question to other DB2 Experts to clarify few things.
The ...
How to do paging in DB2 using scrollable cursor?
Hi all,
I have a question regarding database migration. For illustration purposes, I have a DB table and a dependent table such as:
Table 1: Employee:
column EMPLID INTEGE...
I am trying to update records across two libraries on an AS400 DB2 using STRSQL
UPDATE Library1/Table1 j
SET j.COUNCS = (Select i.COUNCS from Lib...
I need query examples that use loops in DB2- like while or for or if loop within a query.
I have a column call Name1, Name 2, I want to select the result of these names into a file but I want to append 8 spaces into each name such as in that file
Name1 Name2
Name1 ...
I have a stored procedure which spits out values like data counts etc as out parameters.
Can some one suggest how I can capture just the values and send them to a Uinix shell variable to be u...
I'm very new to using IBM Syntax, specifically a need for OPENQUERY.
I would appreciate it if someone could show me a small example of how to grab, convert, pass data to SQL.
I listed exact...
I have a linked server going from MSSQL 2000 sp3a to DB2 on an AS400 server using the client access 32bit odbc driver and am getting back odd results from the database.
Depending on what co...
The iSeries AS400 DB2 has a thing called "LOGICAL FILES"
In an effort to increase speed, one of our programmers advocates use of "JOIN LOGICAL FILES" as a replacement for VIEWS.
Neither he n...
How to use CURRENT DATE in a where clause.
See Below ...
-- Generate SQL
-- Version: V5R3M0 040528
-- Generated on: 09/26/08 12:05:17
-- ...
