Home > IT Answers > AS/400 > SQL Precompiled Failed
VJayashree
185 pts.
 SQL Precompiled Failed
AS/400, AS/400 and SQL, SQLRPG
In SQLRPG program, when a compile a program it is showing the error SQL Precompiled Failed. I have given the sql syntax correctly. but I cant able to find the error. What may be reason for it?

Please clarify.

 

Jayashree V.



Software/Hardware used:
as/400
ASKED: January 23, 2012  1:17 PM
UPDATED: March 19, 2012  1:48 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by VJayashree (Question Asker)

You should be getting a spool file from the compile .. at the end are the errors including record numbers and descriptions. The record numbers can be found in that listing. Both the errors and the statements in error will lead you/us to a solution.
Phil

ANSWERED:  Jan 23, 2012  3:02 PM (GMT)  by VJayashree
 
Other Answers:
Last Wiki Answer Submitted:  October 16, 2012  5:34 pm  by  Michael Tidmarsh   11,400 pts.
Latest Answer Wiki Contributors:  Michael Tidmarsh   11,400 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

you’ll have to show us the error messages, and the sql syntax (at the minimum) for us to be able to help you

BigKat
 7,185 pts.
 

Hi Phil,

I saw the errors in spool file and cleared. Thanks.

Jayashree V.

VJayashree
 185 pts.