Re: Constants used in field definition (SQLRPGLE)

On Tuesday, November 30, 2021, 10:43:14 AM EST, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

On Tue, Nov 30, 2021 at 12:47 AM Åke Olsson <konsult@xxxxxxxxxxxxxxx> wrote:

I noticed something weird when testing an SQL program I am writing. The
program parses message queues in search of escape messages.

The message data is then received in a character variable for later
processing.

But if I define the receiving variable like this:

dcl-c Used_Ccsid 278;

dcl-s Messtxt char(100) ccsid(Used_Ccsid);

The SQL fetch fails with SQLSTATUS  57017 “Character conversion between
CCSID 1200 and CCSID 65535 not valid)

Whereas if I define the “Messtxt” variable like this

dcl-s Messtxt char(100) Ccsid(278);

It all works fine

Normally defining various features of variables using constants for say
number of digits, sizes or similar works perfectly fine.