It saved you hours of writing intermediate queries and complicated joins (by the way, here are a couple of refreshers about table joins, if you need them), but the result is most unfortunate: a very long number with loads and loads of decimal places.
To answer this question, we’ll need to list the teacher rank, which is a column of the teachers table, and two functions (a count of the teachers per rank and their average salary). Read More
CEEDATM API CEE2527 Timestamp truncated
The Convert Seconds to Character Timestamp (CEEDATM) API formats a number representing the number of seconds since 00:00:00 14 October 1582. The output is a character string such as 1988/07/26 20:37:00.One of the parameters in using this API which is an output_timestamp is a character string that is the result of converting input_seconds to the format specified by picture_string.https://www.ibm.com/docs/en/i/7.4?topic=ssw_ibm_i_74/apis/CEEDATM.htmlILE/C program is created that uses STGMDL (*TERASPACE).The program is compiled to TGTRLS(V7R2M0) on V7R3, or TGTRLS(V7R3M0) or TGTRLS(V7R2M0) on V7R4. Running the program results in message CEE2527 (timestamp truncated). Read More
Philippe Vanden Bussche, President @CommonBelgium introducing joint event with Common Denmark about Customer Stories from both countries #IBMi @IBMChampions Ranga Deshpande (@RangaDesh)
Philippe Vanden Bussche, President @CommonBelgium introducing joint event with Common Denmark about Customer Stories from both countries #IBMi @IBMChampions pic.twitter.com/8puWkbM7OC- Ranga Deshpande (@RangaDesh)01:54 – Mar 13, 2023 Read More
@jesperomer Chairman Common Denmark welcoming attendees of the joint event with @CommonBelgium about Customer Stories from both countries #IBMi @IBMChampions Ranga Deshpande (@RangaDesh)
@jesperomer Chairman Common Denmark welcoming attendees of the joint event with @CommonBelgium about Customer Stories from both countries #IBMi @IBMChampions pic.twitter.com/3f4e4wti9V- Ranga Deshpande (@RangaDesh)01:59 – Mar 13, 2023 Read More
@koen_decorte @CommonBelgium and CD-Invest telling the JORI customer story. What an impressive use of #IBMi for production, website already in 1996, administration, CRM, customer configuring furniture on-line, everything they need @IBMChampions Ranga Deshpande (@RangaDesh)
@koen_decorte @CommonBelgium and CD-Invest telling the JORI customer story. What an impressive use of #IBMi for production, website already in 1996, administration, CRM, customer configuring furniture on-line, everything they need @IBMChampions pic.twitter.com/3nc2zjBsIG- Ranga Deshpande (@RangaDesh)02:10 – Mar 13, 2023 Read More
