473,324 Members | 2,178 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,324 software developers and data experts.

Prepare Statement in DB2

2
Hi All,

can i use user defined function in prepare statement?

I am trying following,

sprintf(c_stmt,"INSERT/*+ APPEND */ INTO %s VALUES(?,CHAR_TO_DATE(?,'DD-MON-YYYY')) WITH UR",V_TABLE_NAME);

EXEC SQL PREPARE ins_stmt FROM :c_stmt;

Error Code: 440 is encountred.

Thanks,
Abhi
Sep 26 '08 #1
1 3687
sakumar9
127 Expert 100+
are you sure that you are getting 440 code from this PREPARE only??

As far as my knowledge is concerned, it should not happen at precompile time atleast. Are you getting this error at run time or compile time??
Oct 1 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: serge calderara | last post by:
Dear all, I have read on article that the same SQL querry is call many time, for perfomramce reaon it is needed to call the SQLCommand.Prepare method before executing. What does that prepare...
2
by: claus.hirth | last post by:
I wrote a stored procedure that uses a prepared INSERT INTO statement in order to play with the PREPARE and EXECUTE keywords. In transcript 1 below the call to that stored procedure does not...
3
by: fmarchioni | last post by:
Hi all, I'm trying to do an insert using MySQL OleDb Provider. I'd like to use the prepare() method of OleDbCommand class to precompile the statement. The problem is that when I issue prepare() I...
0
by: RG | last post by:
OleDbCommand.Prepare error: Size of parameter (VB.NET 2003) I need to do a SQL INSERT statement into an Access table, and I’d like to use the exact technique described in the Help file example...
2
by: Rajat Katyal | last post by:
Hi: I prepare the statement for execution as follows: PREPARE query(text) as SELECT count(*) FROM transform_customer_billing where inv_no = $1; The problem is Iam not able to execute this...
1
by: rAinDeEr | last post by:
Hi, I have started using DB2 UDB ESE v8.2 in Linux recently. I have seen a lot of articles on packages, prepare statement, bind and execute statement. I havent got a clear idea. I have...
1
by: Purple-D | last post by:
Hi All, I came across a weird situation today. We have a simple sql statement with some java code thrown around it which executes in about 1-2 seconds. However when put in input parameter...
2
by: william.david.anderson | last post by:
Hi there, I'm thinking of using a PREPARE statement inside a stored procedure, but am wondering about the performance penalty associated with calling PREPARE multiple times. Below is an...
0
by: Gordon | last post by:
With the move over to PHP 5.x I' mnow writing a lot of code that makes use of prepared statements as the PHP manual has nothing but good things to say about them. They have less overhead for the...
1
by: Massimiliano Campagnoli | last post by:
Hy, I am trying to understand how the prepare statement works. I am using Qt C++ library to access db2: { .... QSqlQuery cust_query; cust_query.prepare("SELECT CUST_NAME FROM CUSTOMERS...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.