[sqr-users] SQR 1302:-

["Sachin Goswami" <saching@hexaware.com>]

Hi all,
I am facing some problem in PER099.sqr.We are porting Informix SQr on DB2 
database.There in one select statement which select almost 85 fields from three 
tables.and all those fields are get inserted into one record PS_EMPLOYEE.We are 
running it on Unix server...While running it always give error SQR 1302:-SQL 
buffer too small.Use -Mfile to increse the SQL size.
I tried making one file and increse the SQLSIZE to 50000.And put -M flag in the 
PSSQRFLAGS in pssqr.unx.but then it starts giving me error SQR5534:-SQR too 
long for prepare/declare.maximum 12000 characters.

Pls let me know the resolution.I am stuck with it.

Thansk in advance

"Gravitation shouldn't be held responsible for people falling in Love" 
Always Keep Smiling 
Sachin Goswami



-----Original Message-----
From: sqr-users-request@sqrug.org [mailto:sqr-users-request@sqrug.org]
Sent: Friday, December 12, 2003 4:22 AM
To: Sachin Goswami
Subject: Welcome to the "sqr-users" mailing list


Welcome to the sqr-users@sqrug.org mailing list!

To post to this list, send your email to:

  sqr-users@sqrug.org

General information about the mailing list is at:

  http://www.sqrug.org/mailman/listinfo/sqr-users

If you ever want to unsubscribe or change your options (eg, switch to
or from digest mode, change your password, etc.), visit your
subscription page at:

  http://www.sqrug.org/mailman/options/sqr-users/saching%40hexaware.com


You can also make such adjustments via email by sending a message to:

  sqr-users-request@sqrug.org

with the word `help' in the subject or body (don't include the
quotes), and you will get back a message with instructions.

You must know your password to change your options (including changing
the password, itself) or to unsubscribe.  It is:

  sansac85

If you forget your password, don't worry, you will receive a monthly
reminder telling you what all your sqrug.org mailing list passwords
are, and how to unsubscribe or change your options.  There is also a
button on your options page that will email your current password to
you.

You may also have your password mailed to you automatically from the
Web page noted above.

DISCLAIMER:

Information contained and transmitted by this E-MAIL is proprietary to Hexaware 
Technologies Limited and is intended for use only by the individual or entity 
to which it is addressed and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with the 
authority of the Company. If you are not the intended recipient, an agent of 
the intended recipient or a person responsible for delivering the information 
to the named recipient, you are notified that any use, distribution, 
transmission, printing, copying or dissemination of this information in any way 
or in any manner is strictly prohibited. If you have received this 
communication in error, please delete this mail & notify us immediately at 
mailadmin@hexaware.com 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users