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
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
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
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
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
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
Could it possibleto write SQL in CL/400 Programing?
Answer Question | April 28, 2008 7:11 AM
AS/400 and SQL, CL, CL/400