Re: data structure input parameter for SPROC

[TAllen@xxxxxxxxxxxx]

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.