473,405 Members | 2,415 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

sqlureot (reorg api) in a stored procedure (w2k, v6.1, fp11)

Hello.

I am trying to call sqlureot from stored procedure. I use VC++ 6.0. Here is
the c - code of my routine and DDL for creating my procedure.

--- bisp.c sample code ---
#include <sqlenv.h>
#include <sqlutil.h>

SQL_API_RC SQL_API_FN reorg(
char fullTableName[254],
char fullIndexName[254],
char sysTempSpaceName[254],
sqlint32 *sql_code,
sqlint16 nullinds[4])
{
struct sqlca sqlca;
sqlureot(fullTableName, nullinds[1]<0?NULL:fullIndexName,
nullinds[2]<0?NULL:sysTempSpaceName, &sqlca);
*sql_code = sqlca.sqlcode;
return(SQLZ_DISCONNECT_PROC);
}
}
--- bisp.c sample code end ---

-- DDL --
CREATE PROCEDURE mark.REORGTABLE (
IN TABNAME CHAR(254),
IN INDEXNAME CHAR(254),
IN TBSPACENAME CHAR(254),
OUT SQLCODE INTEGER)
EXTERNAL NAME 'bisp!reorg' LANGUAGE C PARAMETER STYLE GENERAL WITH NULLS
NOT DETERMINISTIC FENCED NO DBINFO CALLED ON NULL INPUT PROGRAM TYPE SUB;
-- DDL end --

Whenever I issue "call mark.reorgtable(...)" I get SQL2215N with
sqlcode=-751.
What did I do wrong? Who have managed to make it work on DB2 v6.1 on NT?
With db2 vv7, 8 reorg api works in a stored procedure...

Thanks in advance,
Barinstein Mark.
Nov 12 '05 #1
0 1302

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

27
by: Raquel | last post by:
This question if for UDB on LUW. Suppose I take regular database backups of my database Monday: database backup <ts1> Tuesday: Tablespace reorged and imagecopied <ts2> Friday: database...
6
by: gaetan | last post by:
Hi everybody, I have several stored procedure developped in Java that ran fine when I was in DB2 7.2 FP6 (on Windows) but since I have passed the FP11, I'm not able to call any of my stored...
7
by: andrew | last post by:
Does anyone know if there are any plans to address SQLprocedures() API performance in UDB 8.1 client/server? 8.1 SQLprocedures() API call is implemented through SYSIBM.SQLPROCEDURES(?,?,?,?)...
2
by: bughunter | last post by:
After install FP11 I found difference with previous versions. When I call sp with commit inside from as400 on UDB now I got exception -925 o When issued from a stored procedure, SQL COMMIT is...
1
by: pike | last post by:
DB2 v8.1 FP 11 on AIX 5.2. A REORG of a table created in a 4KB-PAGESIZE tablespaces with associated LONG data stored in a 16KB tablespace is failing with the following error: SQL2217N The...
2
by: Michael | last post by:
Hello, I am using the Membership control in my asp.net application. When a person registers, I set the account to not active. CreateUserWizard1.Enabled = false; Then I send them an email...
0
by: Loop123 | last post by:
Hello, i want to write a Stored Procedure in order to get the configuration parameters of a database like in the command line "db2 get db cfg for database"...i tried the following code: I used...
2
by: Okonita | last post by:
Hi all, How can I implement using REORGCHK to tell REORG what DB2 UDB v8 tables, etc to perform REORG on? Any example script will be highly appreciated. Okonita
9
by: Peter Duniho | last post by:
Is there a straightfoward API in .NET that allows for inspection of a database? That is, to look at the structure of the database, without knowing anything in advance about it? For example,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
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...
0
Oralloy
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,...
0
tracyyun
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.