Profound API provides an easier path for IBM i platforms to develop, document, deploy and manage APIS without writing a single line of code. It allows you to create, organize, expose APIS with ease, including saving API templates to build new APIs even easier than before. Easily document APIS to help with both consuming and maintaining the APIS. Quickly find, modify and test any API within the designer tool. Review analytical statistics about all APIS across a system, via a dashboard that includes charts and summaries. Seamlessly integrate with anything on or off ibmi ****************************** LETS CONNECT! Linkedin – https://www.linkedin.com/company/logicmate-ltd/ Youtube – https://www.youtube.com/channel/UC6sP… Website – https://www.logicmate.co.uk/From: Logicmate Read More
Webinar : Embrace the future of Testing with confidence Pascal Polverini
If you are looking for new solutions to improve Testing activities, enhance efficiency and ensure robust software quality with a faster time to market, join our free webinar with Pascal… Read More
Getting statistics for jobs that have ended Simon Hutchinson
One of the new additions to Db2 for i, or SQL, in the latest Technology Refreshes, IBM i 7.5 TR3 and 7.4 TR9, is a new Table function ENDED_JOB_INFO. This Table function exists in the SYSTOOLS library. ENDED_JOB_INFO allows me to retrieve some information about jobs that have, as the name suggests, ended.
ENDED_JOB_INFO has two parameters:
START_TIME: The start of the range of jobs to find. If a job starts on or after this time it will be included in the results. If no value is given the default is the current timestamp less one day.
END_TIME: End of the range. If no value is given the default is ‘9999-12-30-00.00.00.000000’.
Read more » Read More
SQL repeat scalar function Simon Hutchinson
The idea for this post came from Jonathan Heinz who brought to my attention the REPEAT SQL scalar function in a comment to a post. I have to admit I had not heard of it so this post is examples of how I played with it to become familiar with its use.
Being a scalar function it can be used within a Select, Set, or Values statement. Its syntax is:
REPEAT(‘characters-to-repeat’, number-of-times-to-repeat)
I started playing with it in ACS’s Run SQL Scripts, using a Values statement:
Read more » Read More
Sequel | Ask the Sequel Experts Fortra
Want to learn how Sequel can improve your business efficiency?
Have a pressing Sequel question? Read More
