Dan Cruikshank

Activities

2

talks

author

Frequent Collaborators

Hernando Bedoya 2

Filtering by: O'Reilly Data Engineering Books ×

Filter by Event / Source

O'Reilly Data Engineering Books 2

Talks & appearances

Showing 2 of 2 activities

Search activities →

SQL Procedures, Triggers, and Functions on IBM DB2 for i

2016-04-25 · O'Reilly Data Engineering Books O'Reilly Amazon

book

with Rob Bestgen , Doug Mack , Simona Pacchiarini , Jim Denton , Hernando Bedoya , Jim Bainbridge , Dan Cruikshank , Tom Mckinley , Mike Cain

data data-engineering relational-databases ibm-db2 Agile/Scrum IBM

Structured Query Language (SQL) procedures, triggers, and functions, which are also known as user-defined functions (UDFs), are the key database features for developing robust and distributed applications. IBM® DB2® for i supported these features for many years, and they are enhanced in IBM i versions 6.1, 7.1, and 7.2. DB2 for i refers to the IBM DB2 family member and relational database management system that is integrated within the IBM Power operating system that is known as IBM i. This IBM Redbooks® publication includes several of the announced features for SQL procedures, triggers, and functions in IBM i versions 6.1, 7.1, and 7.2. This book includes suggestions, guidelines, and practical examples to develop DB2 for i SQL procedures, triggers, and functions effectively. This book covers the following topics: Introduction to the SQL/Persistent Stored Modules (PSM) language, which is used in SQL procedures, triggers, and functions SQL procedures SQL triggers SQL functions This book is for IBM i database engineers and data-centric developers who strive to provide flexible, extensible, agile, and scalable database solutions that meet business requirements in a timely manner. Before you read this book, you need to know about relational database technology and the application development environment on the IBM Power Systems™ with the IBM i operating system.

Modernizing IBM i Applications from the Database up to the User Interface and Everything in Between

2014-06-27 · O'Reilly Data Engineering Books O'Reilly Amazon

book

with John Eberhard , Pascal Polverini , Isaac Ramírez Herrera , Tony Cairns , Paul Tuohy , Tim Rowe , Hernando Bedoya , Brian May , Carol Woodbury , Antonio Florez , Dan Cruikshank , Rich Diedrich , Michel Mouchon , Susan Gantner , Jesse Gorzinski , Mike Pavlak , Jon Paris , Trevor Perry , Jeroen Van Lommel , Jim Ritchhart , Nadir K. Amra , Jon Rush , Mark Evans

data data-engineering IBM

This IBM® Redbooks® publication is focused on melding industry preferred practices with the unique needs of the IBM i community and providing a holistic view of modernization. This book covers key trends for application structure, user interface, data access, and the database. Modernization is a broad term when applied to applications. It is more than a single event. It is a sequence of actions. But even more, it is a process of rethinking how to approach the creation and maintenance of applications. There are tangible deliveries when it comes to modernization, the most notable being a modern user interface (UI), such as a web browser or being able to access applications from a mobile device. The UI, however, is only the beginning. There are many more aspects to modernization. Using modern tools and methodologies can significantly improve productivity and reduce long-term cost while positioning applications for the next decade. It is time to put the past away. Tools and methodologies have undergone significant transformation, improving functionality, usability, and productivity. This is true of the plethora of IBM tools and the wealth of tools available from many Independent Solution Providers (ISVs). This publication is the result of work that was done by IBM, industry experts, and by representatives from many of the ISV Tool Providers. Some of their tools are referenced in the book. In addition to reviewing technologies based on context, there is an explanation of why modernization is important and a description of the business benefits of investing in modernization. This critical information is key for line-of-business executives who want to understand the benefits of a modernization project. This book is appropriate for CIOs, architects, developers, and business leaders. Related information Making the Case for Modernization, IBM Systems Magazine