Playing with IBM i Database Timestamp Date Field and other Gubbins

Описание: if you're tinkering with IBM i physical files, this quick video breaks down the DFT keyword in a straightforward way. It's all about setting default values for fields right in your PF definitions, so when you add new records, those fields get populated automatically without extra coding hassle. The syntax is simple: use DFT('some string') for character fields, a plain number for numerics, or even hex like X'whatever' for special cases. Perfect for keeping your database clean and efficient, especially in RPG or SQL setups where defaults save you time on inserts. Check it out if you're brushing up on DDS basics!

If you want to see some coding examples on how to create an IBM i *PF using IBM i RDi and various DEFAULT keywords -

https://www.nicklitten.com/when-is-th...

---

Hey there, IBM i programmers! Welcome to my channel where I try to cover AS400, iSERIES and IBM-i topics like programming, code refactoring, modernization, and technical things like OS updates, RPG subfiles or SQL stored procedures. All on the IBM i system, focusing on practical steps to improve your development work.

You will find tips on modernization, GIT integration for source control, and tools like Project Bob for refactoring legacy code.

This content is designed for beginners learning iSeries basics or experienced developers optimizing Power Systems performance.

For more IBM i resources, visit https://nicklitten.com, where you can access tutorials, code snippets, and free materials to enhance your programming skills. Download the source code from my public github repository https://github.com/NickLitten/nick.li...

Enjoyed the video? Buy me a beer and fuel more nerdy goodness!
https://www.nicklitten.com/shop/buy-m...

#IBMi #AS400 #IBM-i #PowerSystems #RPGLE #CLProgramming #SQLonIBMi