473,666 Members | 2,392 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

urgent : stored procedure not accepting data string more than 1024 bytes

have a stored procedure running on DB2 V7 Z/os calling a COBOL
program to do some inserts. The stored procedure have 3 input columns
and one column is of varchar(32648)
The stored procedure is being called from a V7 DB2 connect client.

The stored procedure is giving SQL0104N An unexpected token was found
if my varchar data goes beyond 1024 bytes. Anything under 1025 bytes
on that column is working perfectly.
Does anybody know of any limitation of Stored procedure.

here is the stored procedure

CREATE PROCECURE CUSTOMSP
(
,IN CUSTOMER_NO CHAR(10)
,IN ORD_NO CHAR(8)
,IN ENCODED_DATA VARCHAR(32648)
,OUT WSRETURN INT
)
FENCED
LANGUAGE COBOL
EXTERNAL NAME 'CUSTOMSP'
NOT DETERMINISTIC
MODIFIES SQL DATA
NO DBINFO
COLLID CUSTOMR
NO WLM ENVIRONMENT
ASUTIME NO LIMIT
RESULT SETS 1
STAY RESIDENT NO
PROGRAM TYPE MAIN
SECURITY DB2
COMMIT ON RETURN NO

here is my call statement

CALL
CUSTOMSP('A1234 56789','1234567 8','000001ABCDE FGHIJ1234567890 1234567890
123456789012345 678901234567890 123456789012345 678901234567890 123456789
0000002ABCDEFGH IJ1234567890123 456789012345678 901234567890123 4567890
123456789012345 678901234567890 123456789Z00000 3ABCDEFGHIJ1234 5678901
234567890123456 789012345678901 234567890123456 789012345678901 234567890
123456789z00000 4ABCDEFGHIJ1234 567890123456789 012345678901234 567890
123456789012345 678901234567890 123456789012345 67890000005ABCD EFGHIJ
123456789012345 678901234567890 123456789012345 678901234567890 12345678
901234567890123 4567890000006AB CDEFGHIJ1234567 890123456789012 3456789
012345678901234 567890123456789 012345678901234 567890123456789 Z000007
ABCDEFGHIJ12345 678901234567890 123456789012345 678901234567890 123456
789012345678901 234567890123456 789z000008ABCDE FGHIJ1234567890 123456
789012345678901 234567890123456 789012345678901 234567890123456 7890
123456789000000 9ABCDEFGHIJ1234 567890123456789 012345678901234 5678901
234567890123456 789012345678901 234567890123456 7890000010ABCDE FGHIJ
123456789012345 678901234567890 123456789012345 6789012345',?);

Below is the message I am getting :
SQL0104N An unexpected token
"'000001ABCDEFG HIJ123456789012 345678901234567 890" was found following
","
Expected tokens may include: "<server-input-data>". SQLSTATE=42601

Any help is apprecaited

Thanks

Roger

Sep 11 '06 #1
0 1410

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

Similar topics

4
3855
by: Thomas Paul Diffenbach | last post by:
Can anyone point me to an open source library of /statically allocated/ data structures? I'm writing some code that would benefit from trees, preferably self balancing, but on an embedded system that doesn't offer dynamic memory allocation (to be clear: no malloc, no realloc), and with rather tight memory constraints. Writing my own malloc to do dynamic allocation from some static pool isn't really an option, for various reasons, not...
2
5450
by: Dino L. | last post by:
How can I run stored procedure (MSSQL) ?
3
1469
by: Jack Black | last post by:
Help!! I'm trying to call a custom stored procedure from a VB.Net code-behind page in an ASP.Net application, and I keep getting an error with no real helpful info... Basically, I'm accepting a username and password from a front-end, and performing a simple INSERT into a SQL Server table via a custom stored procedure in the database. All privileges are fine, and the stored procedure works fine (inserts records perfectly; tested with...
1
1395
by: situ | last post by:
hi all, this is the procedure i have created CREATE PROCEDURE XIREL2.proc_size_2 (p_dummy CHAR(1)) SPECIFIC XIREL2.proc_size_2 DYNAMIC RESULT SETS 3 ------------------------------------------------------------------------ -- SQL Stored Procedure
2
2934
by: Roger | last post by:
I have a stored procedure running on DB2 V7 Z/os calling a COBOL program to do some inserts. The stored procedure have 3 input columns and one column is of varchar(32648) The stored procedure is being called from a V7 DB2 connect client. The stored procedure is giving SQL0104N An unexpected token was found if my varchar data goes beyond 1024 bytes. Anything under 1025 bytes on that column is working perfectly. Does anybody know of...
4
3985
by: nishi57 | last post by:
I hope I can get some help regarding this issue, which has been going on for a while. I have a desktop user who is having problem running "Stored Procedures". The DB2 Connect application works fine but when he runs the stored procedure, he gets the following error message. "SYSPROC".CSGCSB54 - Run started. Data returned in result sets is limited to the first 100 rows. Data returned in result set columns is limited to the first 20...
0
2548
by: ravindrag | last post by:
Hi, I am getting error SQL1131N during sqlj.install_jar(...). There is no useful message in the diag.log (even with diag level 4). I am giving the diag.log entries at the end of this posting (would have been ideal if there was an option to attach the file). command: db2 call sqlj.install_jar('file:/home/xyz/abc.jar','def.abc') response: SQL1131N DARI (Stored Procedure) process has been terminated abnormally. SQLSTATE=38503
0
2607
by: db2user24 | last post by:
I'm trying to invoke a DB2 stored procedure. The stored proc is coded in C and compiled to a shared library, which has been placed in the <DB2 dir>/functions directory. The platform is Linux (using 64 bit DB2 UDB). From the debug log it seems that the stored procedure can't be found, although I don't know why. I can see that the procedure name is defined in the database, however it can not be invoked. Can anyone shed any light on what could...
4
6527
by: Veeraraghavan | last post by:
Hi All, I am developing a client server communication using system.net.socket and I am finding it very difficult to get a solution for this. I started with single port communication with single client and as I was asked to develop to listen on multiple ports handling multiple clients, I am stuck with out a solution. The below is what could end up doing any help to solve the problem will be very much appreciated. Below is the code I...
0
8352
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8863
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8780
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8636
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6189
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5661
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4358
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2765
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1763
bsmnconsultancy
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.