01 - Programming (EN)

Power coffee no. 19/2022 – Dates and times: default and null values

I would like to point out this Power Coffee by the legendary Marco Riva, IBM Champion and colleague.

In this video (by now only in Italian) we can see how to deal wtih dates/time, default values and null values.

Power coffee no. 19/2022 – Dates and times: default and null values

Related Posts
DB2 for i SQL – String Manipulation – POSSTR-LOCATE-LOCATE_IN_STRING (EN)

Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more

DB2 for i – FAQ & Howtos (EN)

DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more

IBM i 7.4 Announcement (En)

Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more

Generated Always Columns (EN)

Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more

--- Roberto De Pedrini Faq400.com

Recent Posts

IBM i: System Management is Simpler Than You Think

If you work with IBM i, I recommend reading this insightful article by Giancarlo Lui: IBM i System Management: Simpler…

3 months ago

RPG Free and option(*convert) for paramters

In his recent article "RPG Free and option *convert" , Aldo Succi explores the *CONVERT option in the RPG language,…

3 months ago

CA Certificate Update for the European Central Bank (ECB): A Practical Guide

Updating Java and DCM Certificates for ECB Exchange Rate Retrieval on IBM i In our blog, we have previously discussed…

3 months ago

Managing Locked Display Files on IBM i: An Effective Solution

We are pleased to receive and share this "tip & trick" from Patrick Rizzi, which introduces a technique that allows…

6 months ago

Monitoring QSYSOPR Messages: SQL to Retrieve Messages and Replies

I take inspiration from a response by Michael Mayer on the Midrange.com mailing lists to someone who asked how to…

6 months ago

Why ERP is the Key to Success for Modern Businesses

Businesses are increasingly seeking tools to enhance efficiency, collaboration, and resource management. Enterprise Resource Planning (ERP) systems provide a comprehensive…

8 months ago