Re: Example of right justifying a character field.

[Jonathan Ball <jonball52@xxxxxxxxx>]

I tend to do all of this kind of activity in SQL whenever possible.

   dcl-s   char_15   char(15);
   dcl-s   char_30   char(30);
   dcl-s   char_7    char(7) inz('STUFF');   // char_7 = 'STUFF '

   exec sql
   set :char_15 = lpad(rtrim(:char_7), length(:char_15));  // char_15 = 
'          STUFF'

   exec sql
   set :char_30 = hex(:char_15);   // char_30 = '40404040404040404040E2E3E4C6C6'

In find SQL built-in functions intuitively easier to understand and simpler to 
use than equivalent RPGLE BIFs, and there aren't always equivalents.

On 2/14/2023 1:04 PM, dfreinkel@xxxxxxxxxxxxxxxxx wrote:
> What is a good and simple way to right justify a character field?
>
>   
>
> I would not like to use a do loop to do this.
>
>   
>
> Thanks
>
>   
>
> Darryl Freinkel
>
> A4G
>
> Telephone: 770.321.8562 Mobile: 678.355.8562
>
>