AS/400: Move / Convert Data from Excel Spreadsheet to DB2/400

On AS400, first create a DB file in the relevant format using either DDS or SQL

eg


CREATE TABLE QGPL/TEMPXML
(
FILE CHAR(10),
FIELD char(10),
DBFIELD char(10),
DESCRIPTION CHAR(100),
DATATYPE CHAR(20),
FORMAT CHAR(20),
SYSTEM CHAR(20));

Then save the xls as a CSV to the iSeries IFS

Once the file has been saved to the iSeries, use the following command to convert the spreadsheet to a native as400 DB2/400 file:

Use the CPYFRMIMPF command (copy from Import File). This is by far the easiest method and you're not restricted by the file name lengths, etc. Here's what the command looks like:

CPYFRMIMPF FROMSTMF('\iSeries directory\test.csv')
TOFILE(testlib/TESTF)
RCDDLM(*ALL)

Check this has imported to your as400 correctly

Oracle Indefinitely Extends the Life of JDE World, EnterpriseOne

The users of the World and EnterpriseOne ERP software suites from the former J.D. Edwards will probably breathe a sigh of relief this week, and so will the top brass at IBM's System i division. The reason why is that Charles Phillips, Oracle's president, and Mark Shearer, general manager of the System i business, will announce that Oracle will now support and enhance the JDE World and EnterpriseOne suites indefinitely--no strings, no gimmicks, no tricks.

ISVs React (Or Not) to PHP on the System i

The news that PHP will be available on the System i--and for free!--seems to have captured the imagination and interest of many. After all, it's a Java alternative, and we all know how unenthusiastic many iSeries users have been about going down the Java road. The potential is there, many say, for PHP to have a big--even huge--impact on the System i5 line. But there are some issues that need to be dealt with first.
For one thing, there are lots and lots of young and enthusiastic PHP programmers who are devoted to this easy-to-learn and easy-to-use Web scripting language. If you've been hesitating to Web-enable your legacy applications because you can't find or afford the necessary Java or WebSphere resources (both of which tend to send the minds and hearts of many an OS/400 professional sinking), it's not hard to find (and hire) those with PHP experience. And, if you're inclined to grow your own, PHP is far more likely to be accepted by your staff than, say, Java.
The partnership announcement between IBM and Zend Technologies for the System i platform a few weeks ago is leading to a lot of speculation (and some high hopes) about what it all really means to the System i community. Andi Gutman, one of the founders of Zend, posted a note on his weblog on April 14: 'I believe this initiative will have a huge impact on the i5/OS community, which has primarily been offered Java as a way to Web and Web Service enable their platform, but as most of us PHPers know, Java is just too damn hard and takes too much time . . . :' He notes also that Zend will be providing ways to i5/OS users to 'access their existing code-base by creating language bridges, native drivers for accessing DB2/400, and various other bridges to operating system services

Scott McNealy steps down as Sun CEO

Sun Microsystems announced Monday that its longtime chief executive Scott McNealy is stepping down from the helm and will be succeeded by the struggling computer and software company's No. 2 executive, Jonathan Scwhartz.
McNealy, 51, a Silicon Valley luminary for years, will continue as chairman of the company he co-founded in 1982. Schwartz, 40, will keep the title of president.
The changes are effective immediately and are the ``result of Sun's ongoing succession planning process'' the company said in a statement.
The shakeup followed rising speculation in recent days that the Santa Clara company, after years of struggling financially, would announce large-scale layoffs or that McNealy would step down as CEO

IBM System i revenue slumps hard

IBM yesterday announced revenues for the servers plunged 22% in the first quarter of 2006, the second consecutive quarterly drop for a platform that saw its numbers surge last year alongside substantial company backing in the form of upgrades and vigorous marketing. Sales in the fourth quarter fell 12% at the end of 2005.

Though disappointing, analysts said the results weren't necessarily an indicator of doom, as the iSeries is a product line in transition that could cause potential customers to hold out for a few months before an assumedly attractive new release. But this latest decline, even sharper than before, may be an indicator that last quarter's dip was more than a hiccup

prefuse | interactive information visualization

The Prefuse visualization toolkit

A Java-based toolkit for building interactive information visualization applications.

Prefuse supports a rich set of features for data modeling, visualization, and interaction. It provides optimized data structures for tables, graphs, and trees, a host of layout and visual encoding techniques, and support for animation, dynamic queries, integrated search, and database connectivity. Prefuse is written in Java, using the Java 2D graphics library, and is easily integrated into Java Swing applications or web applets. Prefuse is licensed under the terms of a BSD license, and can be freely used for both commercial and non-commercial purposes.
The visualization gallery and demonstration video provide numerous examples of the types of applications that can be built with the prefuse toolkit

IBM - Diagnosing connection leak problems in WebSphere V5.0 and V5.1

Cause
Applications that connect to a back-end server and that have become slow or unresponsive might be encountering connection problems that are related to the application code or configuration problems, rather than to bugs in the WebSphere� connection manager. These issues include leaked connections that are not explicitly closed by application, and connectionWaitTimeoutExceptions in the application that might fill up the connection pool without returning connections to the free pool.

Solution
The Connection Manager code for WebSphere versions 5.1.1.3 and 5.0.2.10 provides a new diagnostic feature, connection leak trace logic, that gathers information on which application methods might be generating leaked connections, or might be holding on to connections for longer than expected. This information is useful, especially considering that connections should not take much longer then the maximum processing time of the longest running query in the application.

The best free utilities

The best things in life may be free, but most software isn't. Limited functionality, annoying adware, and pesky nag screens mean even most 'free' software isn't actually without cost.
Anyone who has explored the world of free utilities knows the woes of saving a few bucks. But have heart, ye short of dollars; when it comes to boosting performance, snagging spyware, or protecting your privacy, Download.com has software that debunks that old saying about the mythical free lunch. If you need a beefy, dynamic FTP client, SmartFTP is tough to beat. Does your PC sound as if it's about to go into orbit? Look under the hood with SpeedFan. Ridding yourself of gnarly spyware and the associated headaches won't cost you a penny with HijackThis, Microsoft AntiSpyware, or Spybot - Search & Destroy. When it comes to utilities, here are 10 frugal favorites

Python for as400 programmers

Strictly speaking, the popular open source software stack that is abbreviated as LAMP should really be shortened to LAMPPP, since the stack is comprised of the Linux operating system, the Apache Web server, the MySQL database, and the three programming languages made popular for Web programming: Perl, Python, and PHP. While the OS/400 platform has informally supported Perl for years, and is just now getting official support for PHP, what you might not know is that two Python variants also run natively on the i5 box

Look Mom, No Application Servers, Look...MOM!

'What do you think of application servers?' The most popular answer was, 'I don't need no stinkin' application server.'

By: Yakov Fain"

Nuts-and-Bolts, and Download Details

The Zend/IBM agreement calls for the creation of a Zend Core, Zend Studio, Zend Guard and Zend Platform for i5/OS for use by the end of 2006.

-- Zend Core for i5/OS will be a fully-tested and enhanced version the Open Source PHP language, bundling all necessary drivers and third-party libraries to work with i5/OS and DB2 UDB. An Early Access version of Zend Core for i5/OS is now available for download.

-- Zend Studio for i5/OS is an IDE for encompassing all components needed for the full PHP application lifecycle. An evaluation version is now available.

-- Zend Guard provides independent software vendors and IT managers with the ability to safely distribute and manage the distribution of PHP apps, while protecting their source code. Zend Guard is comprised of an encoder/obfuscator and a license manager. Information is available.

-- Zend Platform for i5/OS is a PHP production environment, which includes performance, availability, clustering and monitoring capabilities for business-critical PHP applications

Basic WebSphere Application Server V5.0 and V5.1 wsadmin Programmers Guide

Websphere Application Server v5 and v5.1

Examples for the WebSphere Application Server V5.0 wsadmin tool are included in the information center, Redbooks and technotes. Many clients want to advance their skills, doing more than making minor modifications to these examples. A common goal for clients is to use wsadmin to create commands that duplicate the functionality of the administrative console.

The building blocks in this document help you build the skills necessary to correctly formulate commands that administer a WebSphere Application Server V5.x environment. This document explains how simple techniques that use wsadmin commands, and other available documentation, can help you reach your administrative design goals.


Content
Basic WebSphere Application Server V5.0 wsadmin
Programmers Guide

Index
1. Purpose
2. Official Product Documentation
3. Wsadmin Command Overview
3.1. Help
3.2. AdminApp
3.3. AdminConfig
3.4. AdminControl
4. Wsadmin Application Commands, AdminApp
4.1. Options
4.2. Interactive
5. Wsadmin Configuration Commands, AdminConfig
5.1. Basic AdminConfig Subjects
5.1.1. Types
5.1.2. Attributes
5.1.3. Required Attributes
5.1.4. Config IDs
5.2. Techniques for Formulating Administrative Configuration Commands
5.2.1. Scenario 1
5.2.2. Scenario 2
5.2.2.1. Discovering the Type
5.2.2.2. Understanding the Final Command
5.2.2.3. Forming the Final Command
6. Wsadmin Control Commands, AdminControl
7. Conclusion


--------------------------------------------------------------------------------


1. Purpose
Many examples for the WebSphere Application Server V5.0 wsadmin tool are provided in the information center, Redbooks or technotes. Many clients want to advance their skills beyond the making minor enhancements to examples, without calling IBM® Support.

The final goal for the client is the ability to create commands to mimic the administrative console and beyond. The Basic WebSphere Application Server V5.0 Wsadmin Programmers Guide advances the client skills by pointing out important documentation that IBM provides, and the simple techniques needed to correctly formulate any command to administer a WebSphere Application Server V5.x. This document shows how some public documentation and some simple techniques that use wsadmin commands, can reach the final administrative design goals.

2. Official Product Documentation
WebSphere Application Server V5.0 Information Center:
V5.0: http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp
V5.1: http://publib.boulder.ibm.com/infocenter/ws51help/index.jsp

The WebSphere Application Server Information Center contains many examples for wsadmin commands, the migration commands from WSCP to wsadmin, and information about WebSphere Application Server MBeans, JavaDoc.

The recommend starting point for new wsadmin users is the information center’s Contents view, where you can expand your WebSphere Application Server editions to find All topics by feature. Inside this view is the System administration section. Underneath System administration is Scripting, where new users can learn how to use wsadmin with the information center.

More advance users can employ good search strings to locate information directly.

One example of a generic search string is Example wsadmin; a more specific wsadmin search uses the specific command, for example, installInteractive. The search results show all the examples and descriptions that IBM has created. This is a powerful source, which IBM keeps up-to-date with current information.

WebSphere Application Server Support Web site:
http://www.ibm.com/software/webservers/appserv/was/support/
The IBM Redbooks, white papers, technotes and fixes for WebSphere Application Server are located on this Web site. The WebSphere Application Server Support Web site provides a variety of information to help you use and fix WebSphere Application Server.

The IBM Redbooks contain cook book examples for wsadmin; for example, the IBM WebSphere Application Server 5.0 System Management and Configuration Redbook contains “Command Line Administration and Scripting” in Chapter 22.

Technotes document specific examples that many customers run into that are not documented or that correct documented commands and examples from the Redbooks or other sources.

WebSphere developerWorks :
http://www.ibm.com/developerworks/websphere/
developerWorks is a Web site where advanced technical papers written by the architects and developers of WebSphere products explain the design and usage of the products.

3. Wsadmin Command Overview
Three major categories, or objects, comprise the WebSphere Application Server administration commands: AdminApp, AdminConfig and AdminControl. The most helpful command to use when lost in wsadmin is the help command.

The building blocks in this document help you build the skills necessary to correctly formulate commands that administer a WebSphere Application Server V5.x environment. This document explains how simple techniques that use wsadmin commands, and other available documentation, can help you reach your administrative design goals.


Content
Basic WebSphere Application Server V5.0 wsadmin
Programmers Guide

Index
1. Purpose
2. Official Product Documentation
3. Wsadmin Command Overview
3.1. Help
3.2. AdminApp
3.3. AdminConfig
3.4. AdminControl
4. Wsadmin Application Commands, AdminApp
4.1. Options
4.2. Interactive
5. Wsadmin Configuration Commands, AdminConfig
5.1. Basic AdminConfig Subjects
5.1.1. Types
5.1.2. Attributes
5.1.3. Required Attributes
5.1.4. Config IDs
5.2. Techniques for Formulating Administrative Configuration Commands
5.2.1. Scenario 1
5.2.2. Scenario 2
5.2.2.1. Discovering the Type
5.2.2.2. Understanding the Final Command
5.2.2.3. Forming the Final Command
6. Wsadmin Control Commands, AdminControl
7. Conclusion





1. Purpose
Many examples for the WebSphere Application Server V5.0 wsadmin tool are provided in the information center, Redbooks or technotes. Many clients want to advance their skills beyo"

SQL Goodies in DB2 for i5/OS V5R4, Part 1

Instead of Triggers

Embedded SQL in Free Form RPG

ISO Timestamp Format

Row Value Expressions in Predicates

Fullselect in a Subquery and Scalar Fullselect

ORDER OF in ORDER BY Clause

RCDFMT Keyword

USE AND KEEP EXCLUSIVE LOCKS

Alter Procedure

Label On Index

Set Current Debug Mode

Set Current Degree

Set Session Authorization

How to Create a Windows Installer for an SWT Application

Native Windows installers offer unparalleled integration with the operating system, as well as a familiar installation process for your users they just double-click on the installer, click Next a few times, and then click Finish. In this 10-Minute Solution, you will learn how to build a native Windows installer for an SWT application using open source tools.

How To Make a Dalek

Advanced Projects and Kits for Electronics

A small collection of electronic circuits for the hobbyist or student

A small collection of electronic circuits for the hobbyist or student. Site includes over 100 circuit diagrams, links to related sites, commercial kits and projects, newsgroups and educational areas. Most of the circuits can be built with common components available from Radio Shack or salvaged from scrap electronic equipment. Most all of the circuits have been built and tested and believed to perform as described, however possible mistakes may be found

Find the jar for a class in Eclipse based IDEs

There is a trick in Eclipse IDEs that you can use to find the jar for a class:

Right click a source folder and select New...Class

On the superclass field, click the browse button

Blank out the java.lang.Object, and type in the unqualified (no package) name of the class that you need the jar for

In the qualifier box below will be shown the package name for the class, and next to that is the name and the location of the jar for that class

How to move up rank in Google

Optimise the site

Correct use of Headers h1 - h6

Add keyords and important words to the H? tags

Add Keywords and key phrases

Key words and phrases in the first two paragraphs

Good logical structure

Good idea to index your sitemap

If you do not have a sitemap, then make one.

CSS based site can help, less code for the spider to fight through

New Phishing Flaw in Internet Explorer

Hai Nam Luke has discovered a vulnerability in Internet Explorer, which can be exploited by malicious people to conduct phishing attacks.

The vulnerability is caused due to a race condition in the loading of web content and Macromedia Flash Format files (".swf") in browser windows.

This can be exploited to spoof the address bar in a browser window showing web content from a malicious web site.

Secunia has constructed a test, which can be used to check if your browser is affected by this issue

Top Ten Coolest Laptop Bags

Laptop cases are no longer simply about getting your laptop from one place to another; you can do that with a plastic grocery bag. With more people than ever daily toting their computers between the office and the home, the laptop case is now expected to mix durability, security, style, the ratio of those elements is up to you. Heres a list of some of our favorite laptop cases that weve come across over the last year, each mixing function and fashion in their own way. Which works for you?

Visits to Sites for Blogging, Local Information and Social Networks Drive Web Growth

While growth is slowing at most top Internet sites, it is skyrocketing at sites focused on social networking, blogging and local information.

The dramatic success of those Internet categories is apparent from a recent online-traffic analysis provided by market research firm ComScore Media Metrix, which examined visitor growth rates among the 50 top Web sites over the past year.

Top-ranked sites growing the most, ComScore's data showed, were Blogger.com, a personal publishing site; MySpace.com, where young people do virtual preening and share musical tastes; Wikipedia, an open reference site jointly edited by millions of people; and Citysearch, a network of local guides focused on cities"

US Attorney General sues Direct Revenue over spyware

New York Attorney General Eliot Spitzer said on Tuesday he has sued Direct Revenue, charging the Internet marketer with secretly installing millions of spyware programs that sent unsolicited advertisements to users' computers.

Spitzer, in a statement, said Direct Revenue secretly bundled spyware, that tracked users' Internet habits and caused pop-up ads to appear, into offers for free games or other applications.
The lawsuit filed in Supreme Court of the State of New York seeks an order barring Direct Revenue from secretly installing spyware or sending ads through existing spyware programs.
Spitzer also asked the court to compel the company to account for its revenue and pay unspecified monetary penalties.
Spitzer has been pursuing companies involved in alleged Internet fraud and other misconduct.
Last year, he reached a $7.5 million settlement with Intermix Media after suing the company for bundling hidden spyware along with millions of programs it gave away for free. Intermix owns the popular MySpace social networking site and was later purchased by News Corp

Ten Things Every Java Developer Should Know About Unix

One of the great things about Java is how multi-platform it really is. While cross platform glitches do occur, they are not really all that common. But since the law of unintended consequences is all pervasive, we now have the common sight of teams of developers building Java programs meant to run on Unix boxes on Windows.
Developing code meant for Unix on Windows does work reasonably well. The trouble is, many those coders slaving away in front of XP have a very limited understanding of their target platform. If that describes you, this following list is meant for you. Without further ado, here are the ten things you really need to know about Unix, in reverse David Letterman order

Has the Java platform has simply stopped being cool?

Arguably, Java did the same thing to C++ and C++ did the same thing to Smalltalk. In the Java over C++ case at least, it was a good thing as Java was a better concept.

The creation and use of materialized query tables within IBM DB2 UDB for iSeries

This white paper explains, at length, the process for creating and implementing materialized query tables (MQT) within the IBM DB2 UDB for iSeries environment. MQT is a new technology that is delivered with the latest release of this state-of-the-art database. It offers new methods for enjoying high performance query processing

DB2 for IBM i - Articles and White Papers

AS400 Articles and White Papers

A new approach to enforcing business rules with DB2 for IBM i

Accessing DB2 for i5/OS data from a Linux Partition and Optimize Linux access to your DB2 for i5/OS database

Accessing DB2 for i5/OS data from AIX Applications - Optimize AIX access to your DB2 for i5/OS database

Building Web services with db2 and .Net

Creating and using materialized query tables (MQT) in IBM DB2 for i5/OS

IBM DB2 Development Add-in for Microsoft Visual Studio .NET

DB2 for i5/OS and Web Services

Debugging SQL procedures with the System i graphical debugger and DB2 developers workbench

Heterogeneous Data Access for iSeries Applications

IBM DB2 for i5/OS and Development Center

Improving SQL procedure performance: New features and tips to help improve stored-procedure performance
Indexing and statistics strategies for DB2 for i5/OS
Modernizing a DB2 for i5/OS application
Protecting i5/OS data with encryption [New]
QIBM_QDB_OPEN: The Open Database File-exit program - Using the Open Database File-exit program to secure your database [New]
Routing database client connections to IBM DB2 for i5/OS through an alternate subsystem
Star Schema Join Support within DB2 for i5/OS - Version 3
Table Partitioning Strategies for DB2 for i5/OS
Understanding the DB2 Universal Database on iSeries systems
Using DB2 Connect in an iSeries Linux Partition - Optimize the DB2 Connect access to a DB2 UDB for iSeries from a Linux partition white paper
Using IBM Rational Application Developer Version 6.0 wizards
Using iSeries database monitor to identify and tune SQL queries
Using iSeries ODBC Driver in a Linux Partition - Optimize the access to your DB2 UDB for iSeries database from a Linux partition
IBM DB2 for as400 i5/OS and DB2 Developer Workbench

Native PHP Ready to Burst onto the i5 Scene

The availability of native PHP on the System i might be the news with the most far-reaching effects this year. Previewed several months ago and announced last week at COMMON, native PHP brings not only a fast and free way to deliver i5 Web applications, but it also makes the i5 more relevant to new Web developers and carries the potential to reduce the use of Java and WebSphere on the i5.
'Since PHP is built to be a simple Web-scripting language, programmers will find it easier to develop applications without the need for all the overhead of WebSphere and the complexities of CGI,' says Mike Pavlak, director of IS for Trippe Manufacturing Company. 'PHP represents an alternative to Java that does not require a degree in Object-Oriented Development but still supports it. It is the biggest language to hit the iSeries since Java!'
PHP is the world's most popular Web-scripting language, and it comes with more than 10,000 existing PHP-based components and applications, many of which are open source and readily customizable. i5 developers can embed PHP inside Web pages and use it to access database content. While most PHP scripts are currently designed for MySQL, i5 pros should be able to adapt them for use with DB2 fairly easily

Socializer - free automatic social bookmark submission

The Socializer allows you to easily submit a link to several social bookmarking systems. Instead of having a link to each social bookmarking website, you have a single link to all of them

Socializer - free automatic social bookmark submission

The Socializer allows you to easily submit a link to several social bookmarking systems. Instead of having a link to each social bookmarking website, you have a single link to all of them

PHP Form Handling

If your PHP program is a dynamic web page (and it probably is) and your PHP program is dealing with user input (and it probably is), then you need to work with HTML forms. Here are some tips for simplifying, securing, and organizing your form-handling PHP code

Using Websphere on Iseries? Then you must read this paper!

This paper provides examples of the possible environments used to deploy IBM® WebFacing Tool solutions. The reader will also be walked through techniques to tune the environment to maximize performance Link

UK Government to Shut Down GSM Networks - Mobile Gazette - Mobile Phone News

Mobile Gazette has learned of a shock move by the British Government - it has decided to take back the part of the radio spectrum currently used for GSM networks in the UK, and will force mobile operators to run a 3G-only service in the future.
According to an interview in a secret location with someone claiming to be close to the heart of government (known to us only as 'Barry'), the 900MHz and 1800MHz bands are to be taken away from mobile operators from 1st April 2007 and redeployed to other functions. This means that all mobile phone users in the UK will need to switch to a 3G handset before that date. And on the subject of dates, check the date on this one!

32bit JVM for Websphere for Iseries

Text release of WAS (due out
this summer) will allow you to enable the installed product or a specific
profile in the product to use the 32-bit JVM. Out of the box, the product
will use the 'classic' iSeries JDK 5.
Currently available WAS releases cannot use the new 32-bit JVM because they
require JDK levels prior to JDK 5

Using System Request to execute a command

If your workstation is running some batch job and you don't have any other display session to execute command, you can use the 'send a message option' from the system request menu to execute the command.
That program allows you to send a message to a message queue by using the System Request key with option 5 (Send a message). That can be done even while your workstation is input-inhibited. By using that program, the 'Send a message' option can be used to send a command that gets executed by the operating system. The following command must be executed before MYCMD can be used, ADDLIBLE LIB(qtemp) Crtmsgq msgq(qtemp/q) Chgmsgq msgq(qtemp/q) dlver(*break) pgm(mycmd)

Printing from Qshell

While Qshell is a valuable tool in the iSeries professional's toolbox, some features it has are hard to discover. For example, instructions on how to print Qshell output to an iSeries printer are hidden in an obscure page in the InfoCenter. To send the output of a Qshell command to an output queue, use the Rfile command. Entered by itself, the following command 'echo Hello iSeries' will echo to the screen the words 'Hello iSeries'. We will redirect that to a printer file via Rfile echo Hello iSeries | Rfile -wbQ -c 'ovrprtf file(qprint) outq(outqname) splfname(qshprt) hold(*yes)' qprint
The InfoCenter has an example on how to send ASCII files and Qshell output to remote printers

Printing from Qshell

While Qshell is a valuable tool in the iSeries professional's toolbox, some features it has are hard to discover. For example, instructions on how to print Qshell output to an iSeries printer are hidden in an obscure page in the InfoCenter. To send the output of a Qshell command to an output queue, use the Rfile command. Entered by itself, the following command 'echo Hello iSeries' will echo to the screen the words 'Hello iSeries'. We will redirect that to a printer file via Rfile echo Hello iSeries | Rfile -wbQ -c 'ovrprtf file(qprint) outq(outqname) splfname(qshprt) hold(*yes)' qprint
The InfoCenter has an example on how to send ASCII files and Qshell output to remote printers

Advanced trigger applications

The application of triggers to implement solutions for many data processing problems is limited by the imagination only. A trigger program can be attached to (or, associated with) any number of physical files using the ADDPFTRG command. You write the trigger program in the language of your choice. Once attached to a file, the program is called every time a record is deleted, inserted and/or updated

Stupid google tricks

There have been many examples of people "tweeking" the results of a google search.

Everyone knows about the GWB one, but I found a real funny one.

type "french military victories" and press "feeling lucky".