Avoiding SQLCODE -746 when calling procedures from triggers

Similar topics

by: Jean-Marc Blaise | last post by:

Dear all, Could you explain why some SQL messages do not possess a SQLSTATE ? Why not transmitting the SQLSTATE of the original <sqlcode>, for example if you get a -911 on a RUNSTATS ? ...

DB2 Database

9619

dynamic SQL from Hibernate and SQLCODE -301

by: JDPope | last post by:

I have a situation which I cannot get a good lead on how to resolve. One of the applications I support uses the Hibernate software to generate SQL. The app is JAVA with JDBC. In testing the users...

DB2 Database

7206

How to decipher a SQLCODE

by: Twan Kennis | last post by:

Hi, I have a DB2 database on the IBM iSeries platform, on which I created several Stored Procedures with the SQLCODE as a return-parameter. These Stored Procedures are called from a Windows...

DB2 Database

1768

problems with sqlcode -1225 in AIX 5.2 + UDB DPF (parallel) environment

by: peteh | last post by:

Hi All; We have 2 open PMRs - one for AIX, one for DB2 relating to this problem, but I thought I'd see if I could make any progress in the group. We just upgraded a 4 node/36 processor...

DB2 Database

46670

Error SQLCODE "-811", SQLSTATE "21000"

by: Richard | last post by:

Our web programmer was looking in his application log an found the following error: 2006-08-31 16:33:35,129 ERROR org.hibernate.util.JDBCExceptionReporter - < SQL0723N An error occurred in a...

DB2 Database

14445

Error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031

by: misterutterbag | last post by:

Stack trace below. Only happens in WebSphere 6.0. DB2 v 8.2. FP12. Only against 1 database. I have other databases in this database instance, but they don't seem to have this problem. ...

DB2 Database

11177

Getting exception in Java application with error code "DB2 SQL error: SQLCODE: -901"

by: jyoti202 | last post by:

Hi, Need help for this as i have been looking for it but could not get any results. We are using java as front end and DB2 as backend, i m getting the exception while executing a particular...

DB2 Database

6604

Getting SQLCODE -302 after migrating DB2 V7 to V8 IN ibm z/os

by: Sri | last post by:

All Recenetly our shop migrated to DB2 V8 from V7. We are in IBM System Level: z/OS 1.6.1 @ RSU 0702. Processor : IBM 2064-1C7 (z/900) # 1B89 Mode: 64-bit One of my application is facing...

DB2 Database

5046

SQLCODE groups

by: Gregor =?UTF-8?B?S292YcSN?= | last post by:

Hi! I was searching through DB2 InfoCenter, but didn't find an answer to my question: When I get an SQLCODE from an SQL command (ADMIN_CMD for example) when I want to know what this code means;...

DB2 Database

8152

How do you display the Current SQLSTATE or SQLCODE

by: APP1MVF | last post by:

Question: I come from a COBOL/DB2 environment so I am use to being able to display the current SQLSTATE or SQLCODE following the issuing of a DB2 command, now I have move over to a LINUX/DB2 shell...

DB2 Database

7223

What is ONU?

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,...

General

7110

Changing the language in Windows 10

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...

Windows Server

7372

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7030

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

7482

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

5623

AI Job Threat for Devs

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,...

Career Advice

3179

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

758

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

411

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General