Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are DDS and RPG? Am I really using DB2 or a flat file system?

April 26, 2017db2 DDS file flat rpg system

0

Posted

What are DDS and RPG? Am I really using DB2 or a flat file system?

1 Answer

0

Posted

DB2 for i has many programming and operational interfaces available for application developers, DBAs, and operations/support personnel. However, the database engine is still the same regardless of the interface being used. With this architecture, you actually have MORE flexibility in how you use the database and what skills are available in the marketplace to help develop or support. DDS (Data Description Specifications) provide one option to define database tables and indexes. RPG is a common programming language in the IBM i world. These interfaces, commonly referred to as “native” interfaces, were in place before SQL became an industry standard and continue to be used heavily in an IBM i environment. DB2 for i also supports SQL interfaces, and you can create tables and indexes through SQL, generally considered the “open” standard for database development. DB2 for i also supports many different high level languages (e.g., Cobol, JAVA), 4GL and CASE tools, and web or client/server bas