SQLRPGLE Prepare
When using the prepare statement I'm creating a string that contains my select statement... I want to compare a numeric field within my string. For example I have batch# which is numeric, how can I say where batch# = 21
Software/Hardware used:
Software/Hardware used:
ASKED:
April 2, 2010 7:11 PM
UPDATED:
April 5, 2010 7:27 PM
RELATED QUESTIONS
- Getting SQLCODE -518, while running EXECUTE Statement after PREPARE Statement in COBOL
- for AS/400 V5R2
- MS Access 2003 write in SQL query to convert string to numeric
- How to convert a "Numeric-String" with '-' sign and decimal places into pure "Numeric"?
- mixture of characters, numerics and special characters
Answer Wiki:
Ok your statement might look like this:
Stmt = 'Select x,y,z from myfile where batch# = ' + %editc(reqBatch# : 'Z')
where batch# is a numeric field in myfile reqBatch# has the reqired numeric value by the time that this string is built.
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
Note that technically the name “batch#” is invalid in SQL. The “#” (hash or pound symbol) is not in past SQL language character sets.
You might need to enclose the column name in full-quotes (double quote marks, i.e., [ " ]) or maybe even create a view that renames the column.
Tom