IBM i 7.4 Recommended Fixes- SMTP

​These recommendations are based upon your system already having installed the most current Cumulative PTF Package and HIPER PTF Group.
For further information or to order these PTFs, follow this link: http://www.ibm.com/support/fixcentral/ 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 

SQL 101: DML Recap-Some Handy Column Functions, Part 2

​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 

Verified by MonsterInsights