SQL Mismatch in From Statement
What need to be done if an error message mentions “Mismatch in From Statesmen”? It seems like I have not done any different then what I have done over the last numerous of queries that I have done. I started with an excel spreadsheet. I had to do some concatenation of the some columns. I [...]
Answer Question
| September 18, 2009 4:23 PM
AS/400 - DDS, SQL
What need to be done if an error message mentions “Mismatch in From Statesmen”? It seems like I have not done any different then what I have done over the last numerous of queries that I have done. I started with an excel spreadsheet. I had to do some concatenation of the some columns. I [...]
Answer Question
| September 18, 2009 4:23 PM
AS/400 - DDS, SQL
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
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
AS400 – DDS
Hello All, I am having one doubt related to display file handling. Let’s say I have one Display file which handles different functionalities like add/update/delete/display of records. For Adding record (Function 10 from main screen) I have a separate window screen. I am doing data validation for this window screen. The problem I am facing [...]
Answer Question
| August 11, 2009 6:51 AM
AS/400 - DDS, DDS
Hello All, I am having one doubt related to display file handling. Let’s say I have one Display file which handles different functionalities like add/update/delete/display of records. For Adding record (Function 10 from main screen) I have a separate window screen. I am doing data validation for this window screen. The problem I am facing [...]
Answer Question
| August 11, 2009 6:51 AM
AS/400 - DDS, DDS
