Re: data structure input parameter for SPROC

Do you have any samples of an SQL create procedure statement?

Thanks,
Todd





CRPence
<crp@xxxxxxxxxxxx
.ibm.com> To
Sent by: midrange-l@xxxxxxxxxxxx
midrange-l-bounce cc
s@xxxxxxxxxxxx
Subject
Re: data structure input parameter
01/08/2008 11:47 for SPROC
AM


Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






The SQL VARBINARY works well for anything _other than_ all-character,
and the SQL VARCHAR [with CCSID] for all-character DS elements. In
either case, the first two bytes of the DS must represent the two-byte
integer varying length, regardless of implementation. Or similarly,
using the SQL data types BINARY and CHAR [with CCSID]; without the
two-byte integer varying length as first two bytes of the structure.

Regards, Chuck
--
All comments provided "as is" with no warranties of any kind
whatsoever and may not represent positions, strategies, nor views of my
employer

TAllen@xxxxxxxxxxxx wrote:

I asked this question on the Java-L list but realized it is really an SQL
question.

I have an RPG program that needs to be wrapped with an external SQL

stored

procedure. The RPG program takes a data structure as an input parameter.
The SPROC will be called from a Java application.
Are there any considerations for a data structure as an input parameter

for

an SQL stored procedure? If the data structure is treated as one long
string then I have concerns on string termination characters and numeric
fields in the data structure. I assume that I would need to pad all the
strings and numeric fields.

I'd be interested to find out if anyone has done this before.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.