AS/400 and SQL Questions

1

SQL Precompiled Failed
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.

Answer Question   |  March 19, 2012  1:17 PM
AS/400, AS/400 and SQL, SQLRPG
asked by:
185 pts.

SQL error SQL0204 while using scalar function calling RPGLE program
I’ve created a sclar function in SQLRPGLE which will be calling a RPGLE program for processing. There are 2 functions in the SQLRPGLE program: one for handling character field and another for processing numeric fields. Character part is working fine, but if it processes numeric part (i.e. function name fnScrmbleN), program is showing error SQL0204 [...]

Answer Question   |  February 6, 2012  7:32 AM
AS/400 - DDS, AS/400 and SQL, PL/SQL error messages
asked by:
PG
30 pts.

SQP file members
Does SQL on AS400/iSeries allow selecting a specific member to be prcesssed without using a OVRDBF command?

Answer Question   |  August 26, 2008  4:04 PM
AS/400 and SQL, OVRDBF, SQL
asked by:
10 pts.

SQL/400 commands
Hi friends, How can I see or get the SQL/400 commands executed from another user ? Regards, Roberto

Answer Question   |  March 31, 2012  12:46 AM
AS/400 and SQL, SQL/400
asked by:
440 pts.

Multiple SQL For (AS/400)
For (AS/400) I need to create a source member with multiple sentences of sql: i.e. update aa…. update bb…. update cc…. , and then run these source member with runsqlstm. Is it possible? which is the character to separate between sentences? Thanks in advance

Answer Question   |  October 18, 2011  7:42 PM
AS/400 and SQL, SQL Server administration
asked by:
5 pts.

Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement?
Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement? Have tried the following, which do not work: column descr254_mixed format A30 set wrap off select descr254_mixed from PS REQ_LINE SELECT left(descr254_mixed, 20) from PS_REQ_LINE

Answer Question   |  June 13, 2008  4:50 PM
AS/400 and SQL, SQL, SQL statements
2,585 pts.

SQL In CL/400
Could it possibleto write SQL in CL/400 Programing?

Answer Question   |  April 28, 2008  7:11 AM
AS/400 and SQL, CL, CL/400
asked by:
75 pts.

1