Re: SQL size limitation

2007-10-22 Thread Mike Bell
> Your choices are limited to > 1. set and release base registers around the FETCH > 2. use a SQLDA which looks like > EXEC SQL FETCH SELECT-1 > USING DESCRIPTOR :SQLDA1 > or something but this requires that you build the SQLDA with the addresses > and datatypes of the variables. See the DB2 manual

Re: SQL size limitation

2007-10-22 Thread Hardee, Charles H
D] On Behalf Of Ron MacRae Sent: Monday, October 22, 2007 9:43 AM To: IBM-MAIN@BAMA.UA.EDU Subject: SQL size limitation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the messag

Re: SQL size limitation

2007-10-22 Thread McKown, John
Is there any way to convert to "baseless" code? I know of a way in general, but I don't know what sort of code the EXEC SQL is generating. We don't have DB2, so I cannot look at the generated code. Can you show the HLASM expansion of the EXEC SQL? If there are a bunch of LA instructions, you might

SQL size limitation

2007-10-22 Thread Ron MacRae
I've tried to send this twice but it hasn't appeared in the archive so I'm trying another method. Apologies to anyone who has received this two or three times. This is my last attempt. If it doesn't get through I'll give up. I have an assembler program that accesses a DB2 table with 340 fields