The post 2022 December Newsletter appeared first on Original Software.

On December 2, PTFs were released that added some new features to RPG.  One of those features is the OPTIONS(*CONVERT) keyword.  You add this keyword to parameters on your prototypes, and RPG will automatically convert the parameter to a character data type.

For example, consider the following subprocedure:

In this case, I accept a parameter that is a Unicode string and I’ve defined OPTIONS(*CONVERT), To keep things simple, this procedure simply prints the parameter using the DSPLY opcode.

Here’s what makes it interesting:  It doesn’t matter what data type the caller provides!  No matter if it is numeric, character, date or time – RPG will automatically convert it to VARUCS2(25), since that is what I specified for this parameter.

For example, the following will work fine:

The %TIME and %DATE built-in functions retrieve the current system time and date.  Even though printVal() specifies a character parameter, the system will automatically convert them to character strings before passing them.

Likewise, the variables ts and dt represent timestamp and date fields, respectively.  The final example uses a date literal.  It doesn’t matter, they will all be converted to character, and the output looks like this:

Notice that the date that specified DATFMT(*DMY) printed in day-month-year format, the others did not have a format specified, so printed in the format of their respective data type.  As a rule-of-thumb, it converts the data the same way that the %CHAR built-in function would.

I can also pass character and numeric fields, constants and literals to my printVal() subprocedure.

And it will convert them to the appropriate character value and display them.

There are some restrictions with this feature.

The parameter data type must either be a form of character (char, varchar, ucs2 or varucs2) or a pointer.
The parameter must be defined as CONST or VALUE.
If a pointer is used, it will be treated the same as options(*string), except that the caller can pass non-character data types.
While the parameter needs to be character, the caller can be just about anything. The only types it will not convert are pointers, procedure pointers and Java objects.

I suspect this feature will be useful for making subprocedures more versatile and easier to call.  Since the caller can provide any data type, it won’t matter as much what format the caller’s data is in.

In a more extreme case, you could use it to add functionality to your subprocedure that adapts to the data that was given.  For example, if I wanted to retrieve a customer’s phone number from the customer master (CUSTMAS) file, I could pass a search string with options(*convert) as follows:

Notice that I have an indicator called isNumber that will be on if the parameter can be interpreted as a valid number.

If a number was passed, I search the CUSTMAS file by the customer, but if it wasn’t a valid number, I used SQL to search for customer names that contain the character string provided.

For example, I could do this:

In this example, the first two calls will retrieve the customer number for account 1001 or 9999, respectively. The next ones will search for a customer with ‘Scott’ in their name, or ‘Tracy’ in their name.  If a matching row Is found, their phone numbers will be printed (using the SND-MSG opcode that was added back in spring.)

I look forward to seeing all of the creative and useful things that people find to do with this new feature!

The post OPTIONS(*CONVERT) Keyword appeared first on Midrange Dynamics.

Have you heard? HelpSystems is now Fortra! This webinar is your chance to go in depth on why we made this change and how it benefits you and your organization. During this discussion, Fortra leaders will share the story behind our new name and what it means when we say we’re tenacious in our pursuit of a stronger, simpler future for cybersecurity.

Watch the recorded session to learn: 

Why we changed our identity
Key updates to our portfolio, including the Fortra platform and our Bundles
How our advanced threat research and intelligence informs everything we do

This session is a must for those eager to understand how the Fortra team of expert problem solvers is ready to find answers to your organization’s toughest problems, and how we remain committed to being a people-first company ready to collaborate with our customers. 

Learn more at https://www.fortra.com/resources/videos/meet-fortra

Woow!! We spent alot of time watching this one during @CommonEurope Congress in 2019 twitter.com/i/web/status/1… pic.twitter.com/pp6m49gmPy

– Torbjörn Appehl (@tappehl)03:58 – Dec 16, 2022