Informix Stored Procedure Programming

Informix Stored Procedure Programming
Author: Michael L. Gonzales
Publisher: Prentice Hall
Total Pages: 0
Release: 1996
Genre: SPL (Computer program language)
ISBN: 9780132067232

For developers familiar with Informix software and SQL. This Book helps the reader understand Informix stored procedures, which can be used to dramatically improve the performance of SQL code, tighten security, reduce maintenance of permissions, and maximize data integrity.

Programming Informix SQL/4GL

Programming Informix SQL/4GL
Author: Cathy Kipp
Publisher: Prentice Hall
Total Pages: 504
Release: 1995
Genre: Computers
ISBN:

This beginner's guide to developing applications using Informix SQL and 4GL is designed for those with some programming experience, but little to moderate experience with databases and/or Informix. It serves as a comprehensive, single-source tutorial on database design, Informix SQL, and Informix 4GL--showing developers how to design, create, maintain and write applications for a database system.

Programming the Perl DBI

Programming the Perl DBI
Author: Alligator Descartes
Publisher: "O'Reilly Media, Inc."
Total Pages: 372
Release: 2000
Genre: Computers
ISBN: 9781565926998

Co-authord by the primary developer of DBI, this text is the first and only book on Perl and DBI and destined to be the bible for and DBI programmer. Learn how to program with DBI through extensive examples.

Informix Performance Tuning

Informix Performance Tuning
Author: Elizabeth Suto
Publisher: Prentice Hall
Total Pages: 190
Release: 1996
Genre: Business & Economics
ISBN: 9780132392372

Practical coverage of the two most recent releases of the Informix database server, versions 8 and 7

Migrating from Microsoft SQL Server to IBM Informix

Migrating from Microsoft SQL Server to IBM Informix
Author: Whei-Jen Chen
Publisher: IBM Redbooks
Total Pages: 496
Release: 2010-07-22
Genre: Computers
ISBN: 0738434442

In this IBM® Redbooks® publication, we discuss considerations, and describe a methodology, for transitioning from Microsoft® SQL Server 2008 to the Informix® Dynamic Server. We focus on the topic areas of data, applications, and administration, providing information about the differences in features and functionality, including the data types, data manipulation language, data definition language, and stored procedures. Understanding the features and functionality of the two products assists you in developing a migration plan. We provide a conversion methodology and discuss the processes for migrating the database objects and data from SQL Server to Informix using various methods. We show the SQL differences between SQL Server and Informix and illustrate, with examples, how to convert tables, views, stored procedures, functions, and triggers. We provide script conversion samples for data loading. We describe application programming and conversion considerations. In addition, we discuss the Informix configuration, as well as the administration features and functions Informix provides to help DBAs manage the Informix database server after it is migrated. With this information, you can develop your required transition methodology, and you can plan and execute the conversion activities in an orderly and cost-effective manner.

Informix Basics

Informix Basics
Author: Glenn Miller
Publisher: Prentice Hall
Total Pages: 700
Release: 1999
Genre: Computers
ISBN:

In this book, a world-class Informix expert guides both novices and power users through the complex suite of Informix products, helping them master the development and administration skills they need most. Informix Basics is chock-full of exercises, practical examples and real-world tips - all honed through Glenn Miller's 14 years "in the trenches" teaching, building, and administering Informix databases. It shows not just what to do, but how and why to do it, and which tools to use. It covers virtually every key issue Informix developers and DBAs are likely to face, including: designing databases for maximum efficiency and power; working with SQL; using advanced SQL techniques such as stored procedures and triggers; 4GL programming and user interface development, and more. Coverage also includes data migration, interfacing with 3GLs, and the basics of Informix database administration. Informix Basics is ideal for new Informix users; power users seeking to learn application development; and database professionals migrating from other environments.

Informix Guide to SQL

Informix Guide to SQL
Author: Informix Software, Inc
Publisher: Prentice Hall PTR
Total Pages: 852
Release: 1995
Genre: Computers
ISBN:

Designed as a companion volume to the INFORMIX Guide to SQL: Tutorial, this comprehensive reference covers the Structured Query Language (SQL) as it is implemented in Informix products. KEY TOPICS: Outlines the structure and contents of the demonstration database (stores5) and explains the 21 Informix system catalog tables that describe that structure; defines the column data types supported by Informix products and explains data type conversion techniques; describes the various environment variables that can or should be set to properly use Informix products; explains error handling, the system descriptor area and the SQL Descriptor Area (sqlda); details the workings of all the SQL statements supported by Informix products with step-by-step diagrams explaining every clause of each SQL statement; and shows how to create and use stored procedures. MARKET: A reference to SQL for those who already know how to use computers and who rely on them in their daily work.

The Informix Guide to SQL Tutorial

The Informix Guide to SQL Tutorial
Author: Informix Software, Inc
Publisher: Prentice Hall PTR
Total Pages: 500
Release: 1995
Genre: Computers
ISBN:

Describes the Structured Query Language (SQL) as it is implemented by Informix products. This tutorial shows how to create, manage, and use relational databases with Informix software tools. It also shows how to make simple and advanced queries to fetch and display database data, and how to refine and optimize queries and use the query Optimizer.

IBM Informix Developer's Handbook

IBM Informix Developer's Handbook
Author: Whei-Jen Chen
Publisher: IBM Redbooks
Total Pages: 510
Release: 2011-01-17
Genre: Computers
ISBN: 0738434701

IBM® Informix® is a low-administration, easy-to-use, and embeddable database that is ideal for application development. It supports a wide range of development platforms, such as JavaTM, .NET, PHP, and web services, enabling developers to build database applications in the language of their choice. Informix is designed to handle RDBMS data and XML without modification and can be extended easily to handle new data sets. This IBM Redbooks® publication provides fundamentals of Informix application development. It covers the Informix Client installation and configuration for application development environments. It discusses the skills and techniques for building Informix applications with Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate. The book uses code examples to demonstrate how to develop an Informix application with various drivers, APIs, and interfaces. It also provides application development troubleshooting and considerations for performance. This book is intended for developers who use IBM Informix for application development. Although some of the topics that we discuss are highly technical, the information in the book might also be helpful for managers or database administrators who are looking to better understand their Informix development environment.