473,545 Members | 2,688 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

sqluexpr - external routine problem

Hi All;
I'm having a problem running an external routine (C language) under DB2
8.2 (FP 9) on AIX 5.3. Since the code was mostly copied from the DB2
sample library, I'm pretty sure it's sound. When executed ("call
export_util (parm1, parm2, parm3, ?)) it just hangs - nothing happening
for several hours - when the table being exported is very small.

I compiled the routine (using IBM-supplied bldrtn module) on a
different AIX box running AIX 5.3 but DB2 8.1 (FP4). I then copied the
module to the routine library on the other (8.2 FP9) box and ran
"Create Procedure" successfully. Could this be my problem? Must I
compile the routine on the target box? The only reason I'm not is that
the C compiler on the target machine is not configured correctly and I
was being lazy. Any insight appreciated.

Pete H

Nov 12 '05 #1
1 1702
peteh wrote:
Hi All;
I'm having a problem running an external routine (C language) under DB2
8.2 (FP 9) on AIX 5.3. Since the code was mostly copied from the DB2
sample library, I'm pretty sure it's sound. When executed ("call
export_util (parm1, parm2, parm3, ?)) it just hangs - nothing happening
for several hours - when the table being exported is very small.

I compiled the routine (using IBM-supplied bldrtn module) on a
different AIX box running AIX 5.3 but DB2 8.1 (FP4). I then copied the
module to the routine library on the other (8.2 FP9) box and ran
"Create Procedure" successfully. Could this be my problem? Must I
compile the routine on the target box? The only reason I'm not is that
the C compiler on the target machine is not configured correctly and I
was being lazy. Any insight appreciated.
One problem might be the different shared libraries on the different
systems. If something changed in the shared libs between 8.1FP4 and 8.2FP9
then the routine would indeed fail at runtime.

Art S. Kagel
Pete H

Nov 12 '05 #2

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

Similar topics

6
2472
by: Stephen Cook | last post by:
Having worked through the problems around enabling the document function using an XmlUrlResolver I started work on building a useful class to hide the intricacies. Trying to generalise the process I've hit a snag. How do I resolve multiple external references? The transform method on a stylesheet only takes one resolver, not an array ...
4
4947
by: Sivakumar Shanmugam | last post by:
Group.. We are running on db2 UDF V8 on Sun solaris platform. I created an UDF which calles a C-routine(SQL_API_FN). This C-routine in turn calls an external C-function. The C-function is provided to us by a vendor(PCMILER application). The C-Function does the following operations- Open the server,get distance between two points and close...
18
6145
by: Ian Stanley | last post by:
Hi, Continuing my strcat segmentation fault posting- I have a problem which occurs when appending two sting literals using strcat. I have tried to fix it by writing my own function that does the strcat (mystract). Program below. However this appears not to have fixed the problem and I don't know why it shouldn't ? Any further help as to...
2
1635
by: Pavan Zope | last post by:
Hello I am facing a weired problem in calling a fortran routine from c. The fortran function in question is like this:- subroutine fortran_fun(idtab, nx, x, nf, nh, nhd, info, rinfo, fa, ga, ha, stats,iusr_size, iusr,rusr_size, rusr ) implicit none external usrfgh external foo integer :: idtab, nx, nf, nh, nhd, info(20),itno
7
1722
by: Kristof Thys via .NET 247 | last post by:
Post a new message to microsoft.public.dotnet.languages.vc http://www.dotnet247.com/247reference/default.aspx Hello, I've been struggling for weeks with this problem, I hope I find some help here...
14
2905
by: Christian Kaiser | last post by:
We have a component that has no window. Well, no window in managed code - it uses a DLL which itself uses a window, and this is our problem! When the garbage collector runs and removes our component (created dynamically by, say, a button click, and then not referenced any more), the GC runs in a different thread, which prohibits the DLL to...
9
2821
by: Alf P. Steinbach | last post by:
<what to design a C++ solution for> A Windows API /resource/ is data embedded in the executable, accessed via API functions. A resource is completely identified by the quadruple (id, type, language, file), where (1) id is what, for want of a better name, I'll call a /kludgeon/, (2) type is also a kludgeon, (3) language is a small integer...
0
1955
by: Nova | last post by:
Hi, I created a Java UDF (PARAMETER STYLE JAVA) for DB2 9 Express-C. I finally does what I want it to do. However, after a few hundred calls to the UDF, it fails and raises an SQL error, SQLCODE: -4302, SQLSTATE: 38501. The SQLSTATE translates to "Error occurred while calling a user-defined function, external procedure, or trigger (using...
2
1999
by: venu569 | last post by:
Hi, i am getting following error when i am trying to create stored procedures in db2. error is: PROCEDURE2 - Build started. Create stored procedure returns -7032. -- LOG FILE P6191000.log FOR PROCEDURE ARTIAGARWAL.PROCEDURE2 -- DB2_SQLROUTINE_PREPOPTS=
0
7502
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7434
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7946
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7791
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6026
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5360
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5078
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3491
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1045
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.