(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

  • Aktuelles
  • TechTipp: In Transaktion ? - Wie erkenne ich, ob eine TA offen ist ?
  • TechTipp: RANK() - Die Reihenfolge der Ausgaben einer Abfrage
  • TechTipp: LEAD() - Folgenden Wert einbeziehen
  • TechTipp: LAG() - Vorausgehenden Wert einbeziehen
  • TechTipp: ROWNUMBER() - Zeilennummern ausgeben
  • TechTipp: INTERSECT
  • TechTipp: EXCEPT
  • TechTipp: CASE/DECODE in ORDER BY
  • Info: Nachlese zur INFORMIX Infobahn und zum 62. IUG Workshop
  • Anmeldung / Abmeldung / Anmerkung
  • Die Autoren dieser Ausgabe

Informix Newsletter Juni 2013

Read more...

 

This article provides step-by-step instructions for manually compiling Apache and PHP on Linux for OpenAdmin Tool for Informix. 

Note that there is an automated installation option for OpenAdmin Tool (OAT) that installs and configures Apache and PHP for you.  To use the automated installation, install OAT as part of the IBM Informix Client SDK installer or the IBM Informix bundle installer.  OAT is available as part of the Client SDK and bundle installers for Linux 32, Linux 64, Windows 32, and Mac OS 64 for Informix version 11.70 and higher.

By contrast, this article is intended for advanced users who would prefer to compile their own Apache and PHP on Linux.

In this article, I will be using Apache HTTP Server version 2.4.2, Apache Portable Runtime version 1.4.6, Apache Portable Runtime Utility version 1.4.1, PHP version 5.4.4, and PDO_INFORMIX version 1.2.7.  There are the versions that are currently shipped with the OAT that is part of the automated installer.  Feel free to try with more recent versions of these software components if you like.

1. Install the Informix Client SDK

The Informix Client SDK is required to run OAT.  It will also be required to compile the PDO_INFORMIX driver with PHP in step 3.

(a) Install the Informix Client SDK

(b) Set the INFORMIXDIR environment variable to point the directory where the Client SDK was installed.

2. Compile and Configure the Apache HTTP Server

(a) Download the UNIX source for the Apache HTTP Server from https://httpd.apache.org/

(b) Download the UNIX source for the Apache Portable Runtime (APR) and Apache Portable Runtime Utility (APR-util) from https://apr.apache.org/

(c) Extract the Apache HTTP Server source code. 

tar xvfz httpd-2.4.2.tar.gz

(d) Extract the APR and APR-util packages into the Apache srclib directory...

Read more...

 

There are new functions in Informix 12.10 designed to raise applicaiton compatibility with other vendors.  Some of these are packaged in the excompat (External Compatibility) library, and within that library are functions for enabling tracing or logging of user routines.  These are the DBMS_OUTPUT functions, which are:

 

System-defined routines available in the DBMS_OUTPUT package
Routine name Description
DISABLE procedure Disables the message buffer.
ENABLE procedure Enables the message buffer.
GET_LINE procedure Gets a line of text from the message buffer.
GET_LINES procedure Gets one or more lines of text from the message buffer and places the text into a collection.

(from http:/...

Read more...

 

The CASE statement within SPL is a long overdue request for many Informix users. Finally this wish fulfilled in Informix release 12.10. Now you can use the CASE statement within SPL routines as a faster alternative to IF...ELSE...END IF statements to define a set of conditional logical branches. The syntax for the CASE statement is:

CASE [ expression ]

...

Read more...

 

Title: Primary Storage Manager (PSM) a parallel backup alternative to ontape
Date: Tuesday, May the 30th
Time: 10:30 AM PST
Duration: 60 Minutes
Registration: Primary Storage Manager (PSM) a parallel backup alternative to ontape
Speaker: Gustavo Castro - Software Engineer (IBM)

This session will provide an overview of the PSM functionality. 
You will learn the features of PSM, the advantages as well as 
the usage of PSM. 

We will review how PSM/onbar is easy to use as ontape but provide 
for faster backup/restore, we will also see how to export and 
import objects. Come to learn more about this easy-to-use and 
understand storage manager which allows users to easily embed parallel backup/recovery solutions.

Register for the Event:
https://events.na.collabserv.com/register.php?id=39533c2ac3&l=en-US 

Read more...

 
More Articles...
Newsflash
IBM intends to offer NoSQL database capabilities inside of DB2 beginning early next year, according to a keynote speaker at IBM Information On Demand 2011.


Read more...
 

Title: Best Practices for Embedded Data Management
Date: Thursday, May 24, 2012
Time: 10:30 AM - 12:00 PM (Central Time), 16:30h Germany
Presented By: Pradeep Natarajan - Software Developer (IBM)
Registration: Best Practices for Embedded Data Management

Description:

 
A small footprint, a silent i...
Read more...
 

Title: Utilizing Informix in the Apple Eco System
Date: Thursday, September the 27th, 2012
Time: 10:30 AM - 12:00 PM (Central Time), 16:30h Germany
Presented By: Ian Ilsley -Software Engineer (IBM)
Registration: Utilizing Informix in the Apple Eco System

Description:

 
The presentation will cover iOS support for Informix. 

Applications can be seamlessly written to Support Informix as the backend. The 
development environment used on iOS via open source, web services etc. will be 
detailed for application development. Discover creating Mac OSX application using 
Informix ESQL/C and Xcode iOS using Informix as the backend. 

Come and join us for this Event. 

Register for this event at:
https://events.webdialogs.com/register.php?id=6e99e45969&l=en-US 

If clicking a link above does not work, please copy the entire link 
and paste it into your Web browser. 
For technical questions, contact support at support@lotuslive.com.
For questions about this event, contact the host at: mckeithe@us.ibm.com. 
Read more...
 
Ads