Re: Proposal for New RPG BIF

[Mark Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>]

 There is no need for any SQL in this use case (just returning spaces).
    On Wednesday, July 31, 2024 at 11:00:46 AM EDT, Javier Sanchez <javiersanchezbarquero@xxxxxxxxx> wrote:  
 
 Yes, but, question: calling SQL to do that,is it not expensive?

El mar, 30 jul 2024 a las 23:56, Birgitta Hauser (<Hauser@xxxxxxxxxxxxxxx>)
escribió:

> You have a SPACE scalar function in SQL ... so just use embedded SQL and
> you
> have the function.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
> Modernization – Education – Consulting on IBM i
> Database and Software Architect
> IBM Champion since 2020
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> "Train people well enough so they can leave, treat them well enough so they
> don't want to. " (Richard Branson)
> "Learning is experience … everything else is only information!" (Albert
> Einstein)
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Javier
> Sanchez
> Sent: Wednesday, 31 July 2024 06:01
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Proposal for New RPG BIF
>
> Team,
>
> Honestly, I didn't want to go and look for the already posted proposals for
> new TRs in RPG.
>
> If this already exists and was rejected, just throw me a lot of rotten eggs
> (LOL).
>
> I am thinking of a new BIF: %SPACES(nSpaces)
>
> This would help a lot to stuff in a string a number of spaces when
> concatenating several pieces of other strings.
>
> Example:
>
> stmfString = var1 + %SPACES(50) + var2 + %SPACES(20);
>
> The literal number of spaces can also be a variable containing a valid
> positive value for the number of spaces to stuff in.
>
> Opinions?  (Or rotten eggs).
>
> Thanks,
>
> JS
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.