October's presentations

On Thursday 23 October, 16:00 – 17:45 (CET), I am doing an online presentation to COMMON Austria, for their 16th "Know Your IBM i Websession".

You can learn about it, and register, here.

I g'freu mi drauf, di dort zu seh’n.

October is also the start of the extremely popular System i Developer Lunch and Learn series. For three weeks, Tuesday October 21 – Thursday November 6, System i Develop is offering a series of free technical discussions from IBM i experts: Jon Paris, Susan Gantner, Patrick Behr, Mike Pavlak, and myself.

You can see what the Lunch and Learn sessions are, and register for them, here.

I hope to see you, virtually, at my presentations.

Basic constraints with DDS files

In my previous post I described how I could add several constraints to DDL Tables. Here I am going to describe how I can do the same with DDS physical files.

I will have two sets of parent and child files. The first I will add the constraints using SQL statements. The second I will use the Add Physical File Constraint command, ADDPFCST.

I will be adding the following constraints to the physical files:

1. Add primary key constraint using SQL
2. Add primary key constraint using CL command
3. Foreign key constraint using SQL
4. Foreign key constraint using CL command