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 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
...
|
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...
|
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...
|
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
|
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...
| |
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...
|
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...
|
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...
|
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=
|
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...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
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...
|
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...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |