Daily news about IBM AIX

Displaying foreign key constraints using SQL

foreign key information using sql

I was asked:

What about referenced tables when you specify a foreign key when creating a table? I can check this when I run DSPFD, it is in Parent File Description but I still can’t find an SQL to elaborate all tables in our Application.

I have to admit this one took me some time to find the information I need to provide the example in this post.

A foreign key is one of the many constraints that can be used with Db2 for i tables and DDS files. Doing a quick search of the IBM KnowledgeCenter I found the following:

  • SYSCST:  Every constraint, can be considered the “header” file for constraints
  • SYSCSTCOL:  Columns upon which the constraints have been defined
  • SYSCSTDEP:  Tables upon which the constrains have been defined
  • SYSKEYCST:  Every unique, primary, and foreign key that has been defined
  • SYSREFCST:  Foreign keys that have been defined

Read more »

When Cloud Meets DevOps on IBM i

When Cloud Meets DevOps on IBM i

We’re witnessing multiple macro trends play out in the IT industry, with the rise of cloud computing and managed services being one of the most compelling storylines in 2021. How software is developed is changing too, with DevOps tools and agile methodologies rapidly becoming the norm. When these two trends converge in our little neck of the woods, it can leave IBM i customers wondering where to go. With their recently formed partnership, ARCAD Software and Connectria have mapped out one path.

A decade ago, companies were still unsure of the cloud. They would dabble with adding development, test, and maybe DR in the cloud, but they kept production systems on premise. That resistance is quickly melting away, as many companies now look to the public cloud platforms as their first choice for production runtimes, especially for new Web and mobile applications, and analytics and AI.

The post When Cloud Meets DevOps on IBM i appeared first on ARCAD Software.

Verified by MonsterInsights