I'm attempting to run an SQL script from an RPGLE program by executing the RUNSQLSTM command and specifying a SRCSTMF.
What I'm struggling with is understanding why the CCSID of the STMF is not being respected.
The SQL CREATE VIEW command contained within my STMF includes a hard-coded € (Euro symbol), the STMF has a CCSID of 1208.
When I process my RPGLE program the view is created but the € (Euro symbol) is shown as a ¤ character.
If I manually process the RUNSQLSTM command (from a command line) I get the same result.
The job I'm processing the RPGLE program (and RUNSQLSTM command) from has a CCSID of 1146 and if I view the STMF from this job I can see the Euro symbol.
If I run the same SQL statement through the ACS Run SQL Scripts interface then I get the Euro symbol.
Does the RUNSQLSTM command deal with CCSID conversions?
Has anyone had a similar issue?