Programming in ILE RPG – DDS Database Concepts MC Press Online

​While most recent database objects are created by using SQL, many files are still defined by using DDS. The procedure for creating database file definitions with DDS is similar to that of creating an RPG program. By Brian Meyers and Jim Buck Editor’s Note: This article is excerpted from chapter 3 of Programming in ILE RPG, Fifth Edition. The first step is to use an editor, such as the RDi LPEX editor, to create a source member of definition statements. Most installations use a file named QDDSSRC to store members representing externally described files. The source member type of a physical file member is PF, and the type of a logical file member is LF. The editor automatically provides prompts appropriate to the member type you specify. Read More 

Practical SQL: Change Management with SQL MC Press Online

​IBM continues to expand the scope of DB2 services, and two of them combine to provide excellent change management. By Joe Pluta In a recent article, I wrote about using an IBM DB2 for i service called DISPLAY_JOURNAL to retrieve object deletion information from the QAUDJRN journal. This service provides a way to identify when a program has been deleted. This article will expand on that by providing a way to compare the programs in two libraries to identify which programs are missing or otherwise different. Read More 

Verified by MonsterInsights