RE: [sqr-users] SQR 1302:-

["Patel, Samir" <SPatel@fdic.gov>]

Sachin,

Did you make any changes to the PER099.SQR??
If so, make sure you have a matching "end-procedure" for every
"begin-procedure".

Hope that helps,
Samir

-----Original Message-----
From: Sachin Goswami [mailto:saching@hexaware.com] 
Sent: Thursday, December 11, 2003 5:56 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR 1302:-

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

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