Archive

Archive for June, 2011

Bob Cancilla on IBM i › Oracle and IBM i

June 30th, 2011 Comments off
I just read today's blog post by Jon Paris and Susan Ganter in the IBM Systems Magazine, Power Systems Edition at: http://ibmsystemsmag.blogs.com/idevelop/  entitled an open letter to Larry.

I couldn't agree with Jon and Susan more about Oracle finally being a company that see's the light in a vast darkness of out-of-control technology foisted off on the world by IBM, and many other vendors today.

Oracle is the only company that is focused on selling business application software to medium and large companies with a complete end to end solution including both hardware and software.  Jon and Susan lamented the fact that IBM has not recognized that they too have solution like this (the IBM i based Power System).

Well, not exactly true folks.  While the IBM i is an excellent operating system it is far from being a complete solution for a business.  IBM has not addressed application software since IBM unbundled in 1969 after losing a major anti-trust lawsuit.  IBM has tried to provide applications to run on its hardware by attempting to attract business partners (vendors of application software) who developed software that ran on their machines.

Microsoft takes the same partner strategy but backs up there partner program with thousands to millions of dollars worth of support to assist partner in development, sales, and marketing initiatives.  

IBM has failed to provide much of any support to the IBM i partners and while there are still many applications built for OS/400 aka IBM i they are old using old technologies and operating on support revenue.

Oracle systems run on lightweight Linux and Unix based machines that can scale from about $1500 to about $1.5 million for a high performance machine.  Oracle owns the software solutions and can deliver a complete turn key product that solves business problems.

IBM seems to support old time partners like SAP, CSC, and others who have supported IBM hardware for years.  IBM's total number of dedicated business partners is declining as vendors move to LINUX, various open source technologies, or Windows.

IBM's WebSphere Division of Software Group is probably in its last days of glory as vendors and customers realize that they don't need to spend a fortune on middleware software from IBM when they can obtain software that is every bit as good free in the open source community.  Quite often you can run on open source software in a cloud based environment and let the cloud based provider maintain all of your middleware for a fraction of the cost of implementing IBM recommended solutions in-house.

Oracle has chosen to continue to support Java and MySQL as if they were Open Source (they are not -- they are owned 100% by Oracle when Oracle acquired Sun Microsystems, Inc.).  Oracle leverages open source software stacks and eliminates dependancies on costly middleware while making their money on complete business solutions.

It is a sad, sad, day, but it appears as if IBM has lost all focus on the market and is fumbling around operating on the sheer power of its size and the fear of customers to abandon old IBM technologies like IBM i...

It is only a matter of time.  IBM has clearly demonstrated its cost reduction profit generation motivation with the next quarterly statement driving the company.  Hey Sam Palmisano should well be remembered as the man that drove IBM to total ruin.



Read the original at Bob Cancilla on IBM i.

Categories: Blogs Tags:

i-Series Blogs › SQL400 for Beginners Part 2

June 30th, 2011 Comments off

Hi Guys....

Welcome back… Today I would share more in SQL400….

Getting Started

Interactive SQL/400 can be run from the Command line. Invoke STRSQL {Start SQL/400} and get at what looks like another command line, where we can key in SQL statements for immediate execution, and/or use the F4 Prompt function to navigate IBM DB2/400 data base, which is a version of UDB




SQL CONCEPTS
       Using basic SQL statements and clauses
       The SELECT clause
       Specifying a search condition using the WHERE clause
       ORDER BY clause
       Date/Time arithmetic
       Creating and using ALIAS names
       Creating descriptive labels using the LABEL ON statement
       Describing an SQL object using COMMENT ON 

Read more »


Read the original at i-Series Blogs.

i-Series Blogs › SQL400 For Beginners Part – 1

June 29th, 2011 Comments off
Hi Guys....Today i just thought of sharing something on SQL400 for beginners...

SQL Relational Database In the relational model of data, all data is perceived as existing in tables. DB2 UDB for AS/400 objects are created and maintained as AS/400 system objects.

AS/400 System Terms and SQL Relational Database terms
System Terms
SQL Terms
Library. Groups related objects and allows you to find the objects by name.
Collection. Consists of a library, a journal, a journal receiver, an SQL catalog, and optionally a data dictionary. A collection groups related objects and allows you to find the objects by name.
Physical file. A set of records.
Table. A set of columns and rows.
Record. A set of fields.
Row. The horizontal part of a table containing a serial set of columns.
Field. One or more characters of related information of one data type.
Column. The vertical part of a table of one data type.
Logical file. A subset of fields and records of one or more physical files.
View. A subset of columns and rows of one or more tables.
SQL Package. An object type that is used to run SQL statements.
Package. An object type that is used to run SQL statements.
User Profile
Authorization name or Authorization ID.


Read more »


Read the original at i-Series Blogs.

Alan Seiden's PHP and IBM i Resources › How to learn Zend Server and PHP on IBM i

June 28th, 2011 Comments off

A customer who is also an IBM business partner asked me how to learn more about Zend Server and get a basic understanding of PHP. He has already installed Zend Server for IBM i.

I suggested these steps:


Read the original at Alan Seiden's PHP and IBM i Resources.

Categories: Blogs Tags: , , , ,

Mike's IBM i PHP blog and more... › Global Services means GLOBAL SERVICES…

June 16th, 2011 Comments off

When they say Global Services, they really mean Global Services…


Some of you may be aware that I used to report to the manager of the North American region. A few months ago I was moved to Global Services which is an awesome reaction to some of the work I have done at Zend. As a result I had a chance to visit the Zend folks in Europe including Paris, Cologne and Milan. The trip was well planned and orchestrated by the local team and I sure had my skates on! One thing that became crystal clear is that there is HUGE demand for application modernization using PHP in Europe!

First, in the West end of Paris I had a wonderful opportunity to meet one of the few remaining IBM i focused FTSS (Field Technical Sales Support) by the name of Philippe Beorgeois. Philippe hosted a two day event at the IBM offices near the West side of Paris on modernization and I had a chance to present an introductory breakout session on PHP for IBM i. With well over 170 attendees and about 35 people in my room the event was a HUGE success on every level.


Our team in Paris including Christophe, Christian, Clement and David were exceptional hosts. I did not have to worry about anything as they make sure I did not get lost. I would highly recommend the Metro system and anxiously await Scott Klement to review the rail someday. Speaking of rail, on Wednesday I took a bullet train (Thalys) from Paris to Cologne Germany where I met our local account manager Stefanie.





She introduced me to a wonderful customer called GroupMT where Dr. Rainer Schmitz is working magic with PHP on his IBM i.
Here is the link to his webinar in German where he discusses some of his awesome achievements.

Two big discoveries as Cologne is the home of Kolsh style beer so I had to try some…


The Dome of Cologne which is a magnificent cathedral that is the final resting place of the Magi (three wise men from Christian history). As I emerged from the train station I got a great look at the cathedral. I received a call from Stefanie who asked where I was and I responded “I’m between the train station and this really dirty church…” she giggled and new exactly where I was. After checking with a few of the locals I discovered the dirt is from hundreds of years of train soot. There is a walking tour available inside the cathedral for the low price of a 1 euro donation. I highly recommend the investment.



When it was time to leave Cologne, Stefanie dropped me off at the station and when I saw my train come up on the board I saw a message. It was in German so out came the Blackberry and thanks to Google Translate I discovered the message read “fall from train”. Needless to say the last train was canceled so I headed back to the Four Points hotel for one more night and enjoyed a little more Kolsch.

I got to spend my Saturday off in Paris and see some of the sights. This was very cool. As I love to walk I took a Metro from my hotel in the opera district to the Eiffel Tower. I was beginning to feel like an expert Parisian on the Metro. I walked from the Eiffel Tower to the American Church, then to the Grand Palace, up the Tuileries to the Louvre and then to Notre Dame. After experiencing the Cathedral in Cologne I was not as impressed with the size of Notre Dame as I was with the relics. The museum tour is a little over priced, but I would not have missed it for the world as they have a relic that contains a sliver from the cross of Jesus and many other priceless artifacts. Feeling a bit tired I walked back to my hotel and grabbed a quick nap. Then off to meet some awesome friends for dinner, Anne and Kent, who just happened to be on vacation in Paris.

Sunday was the trip to Milan and began my visit to COMMON Europe. Dinner that night was in a little café in the Piazza el Duomo, a very famous cathedral.


The next day I went to COMMON and met with Angela and Elena, our Zend team in Italy. Along with Enrico who has recently been recruited to the ZF Core team from professional services, they do a great job taking care of our customers. It was an unbelievable experience because as I presented my session in English there were attendants who translated it into Italian for people who got headsets. It was a little unsettling when I told a joke because as the English speaking folks would giggle about 3 seconds later the folks with the headsets would giggle. But a great turn out and wonderful response for PHP on IBM i! several session by Zend and other companies regarding PHP!




The first night of COMMON we had a great dinner with some IBM’ers. Met up with Steve Will and his lovely wife, Sherry, Alison Butterill, Trevor Perry and some new friends.






The second night was the Gala event. This was truly special as we were shuttled out to the country to a farm with live entertainment. There was an Italian version of the renaissance fair where they conducted sword fights and dancing. After a wonderful dinner we were shuttled back to the hotel and I saw a little more of Milan.

Sessions at COMMON in Italy were VERY well attended. The Zend team was fully engaged starting with Christian Durel our General Manager of European Operations. Working with a couple of other partners he led a very popular round table on New Business Models, innovation, skills development and professional attitude as key factors to exit the current crisis. Many attendees found it to be VERY helpful as they move forward in this treacherous economy!

There were a few other PHP sessions that explored several different aspects of the technology. it impresses me how creative people become once they realize the chains of the 5250 interface have been released. Mobile, javascript, Flash and other technologies are both powerful and liberating. Seeing members of the IBM i community en bracing these technologies reinforces the fact that we are all on the right track.

Also on deck was Elena and Enrico who hosted a seminar on PHP on the last day. I hear it went very well! I could not stick around as I had to high-tail it home for my son's graduation. Another AWESOME event!

Without question this was an AWESOME trip. WE covered a lot of ground, did a lot of business and saw a lot of the area. Looking forward to my next trip across the pond which looks like it will be around November for an event in London!

Woohoo!


Read the original at Mike's IBM i PHP blog and more....

Categories: Blogs Tags: