ORACLE on the AS/400?

I found an interesting discussion in the Oracle Forum on this subject.

In summary it is not possible to install Oracle directly on the IBM iSeries, but the iSeries support also guest Operating systems like Linux and AIX/PPC.

You can install Oracle on the above guest Operating systems.

AS/400 DSTDTA now handles SQL STRINGS for selecting data

Ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet?

Now you can… all from one IBMi command without having to write any CL code to do it.

I added this new function to the PROJEX400 - Distribute Data command last night – so it can now take a bite of selected data using SQL and send it as a TXT, CSV, XML or PDF as EMAIL.

Huge timesaver for me and has been on my wish-list for ages.

Example:

DSTDTA FILE(CSP20) DATA(*SQL) DATASQL('select * from CSP20 where CONO20 = ''??'' and PSTD20 between 1061001 and 1101022') METHOD(*EMAIL) TYPE(*XML) EMAIL(*prompt) INSERT(*LINK) SUBJECT('Here is the spreadsheet for data range 10/01/2010 thru 10/22/2010') IFSDIR(*USER) IFSDOC('CSP20 Spreadsheet') STAMP(*YES)

Creates a spreadsheet in the IFS called /home/nlitten/csp20spreadsheet[10-26-2010_08.34.06].csv and emailed a link to me.

It's a thing of beauty. Hope it helps somebody.

This interesting article was originally published at: http://www.projex.com

An interesting and funny video on the IBM AS/400





You will find information and training on the IBM iSeries (ex AS(400) at:

==> http://www.Datamission.co.uk

==> http://as400softwaredownloads.com/

From DDS to SQL: How to fully exploit DB2 on i and hone your SQL skills

Improve DDS with SQL?!?! If your database is still DDS-generated, you could be missing out on important functionality and performance gains. In this webcast, IBM's Mike Cain explains why modernizing most legacy databases with SQL can bring significant benefits to your company--and to you. He describes why SQL has become the IBM i standard for defining and accessing database objects, and how you can transform your DB2 for i objects incrementally without impacting your existing applications.

Mike is joined by Resolution's Karen Sedlar, who will show how new IBM i-based tooling can significantly reduce the time and effort involved in database modernization, plus shield users from the complexities of SQL and help hone their SQL skills. She'll demonstrate how you can:

• Quickly scope your modernization project
• Automate the IBM-recommended modernization process to reduce risk and errors
• Transform your database in manageable bits
• Preserve your existing applications -- without even recompiling
• Maintain your new SQL database using a true modeling environment

Register today to learn how you can use SQL to fully leverage DB2 on i.

l Get More Out of Your Green Screen Programs with Presto www.bcdsoftware.com/presto

You have a lot invested in your IBM i and in your green screen programs. Use Presto to extract even more value from them.

Satisfy users with an instant Web GUI

Presto instantly transforms all your RPG and COBOL programs and IBM i screens into modern looking web pages that are more accepted by users. You save time by not having to make any changes to your RPG, COBOL or DDS code. Your web enabled screens are accessed via a browser which makes them easier for your users, clients and management to access and use. It's also easier for you to deploy as there is NO PC software to install to make Presto work.

Extend the functionality of your 5250 programs

You can then further increase user productivity and add new modern functionality to your applications by customizing your web-enabled screens. With the Presto Visual Editor and by having full access to the HTML code you can have more intuitive navigation and better data entry with features such as clickable links and drop down lists.

The possibilities are endless

You can also add JavaScript including jQuery or ExtJS to make your screens even more sophisticated. Using AJAX and SOA technology you can call other web programs including WebSmart PHP and ILE programs to incorporate new data or features into your application. For example, a dropdown box of available shipping rates to a zip code by loading the information from a SOA interface to an external web server such as UPS, or adding file upload, email and xls capabilities.

Start getting more out of your IBM i investment today!

Learn more or Download a Full 30-day Trial


I found this news at

Three Easy Methods to Get Data From AS400 to Excel

One of the more commonly asked questions I see in forums and by end users is how do you get your data from the AS400 down to the PC in a text file format or as an Excel based spreadsheet. And fortunately with modern tools and software this is a very simple problem to solve. Now a days there are many different ways to tackle it depending on what exactly your needs are and what skill-set you or your users have.

First up you can roll your own tools. RPG and CL are a couple of the native programming languages for the platform and if you can write RPG and CL programs then you can really automate the whole data download process from the AS400 environment without any additional tools. You simply create a CL program that reads a spool file or an RPG program to query a database table and write that out to another temporary physical file that can be queried.

Manipulating a spool file this way has the advantage of breaking it apart into the appropriate fields from the source data. Once you have this information put together you can simply have the program email it. One very simply method of emailing from the AS400 is the SNDDST command. But SNDDST can be a bit of a pain to get working since it takes some configuring.

From a Windows based PC you have many many options to get at the data. To download a spool file you simply launch Operations Navigator, search through the output queues for the report you want to download and click and drag it to your desktop. The software automatically converts the spool file into plain text format and downloads it to your computer. Operations Navigator will also convert spool files into Adobe pdf format.

From here it’s a very simple and straight forward process to import the plain text file directly into an Excel spreadsheet. You launch Excel and open the new file, excel will recognize the format and prompt you to add the column breaks. This method is so easy and straight forward it can even be done by end users with a little bit of training and over the shoulder help.

Now you can also query your AS400 directly from a Windows client using an ODBC or OLE driver to access the underlying database. This can be done using your favorite programming or scripting language of choice that can access ODBC, which should be just about all of them. Using this method you need to know how to construct an SQL statement that will be used to query the data set you need.

In fact using this method before I have created Perl scripts to query a specific set of information, in this case it was daily invoices using a date parameter. All the data was downloaded and dumped into a newly created spreadsheet and them subsequently emailed to a list of people. The whole thing was then automated every day by adding it into the task scheduler on the client system. And if I recall correctly this whole script was less than fifty lines of Perl code. How is that for quick and easy?

John Andersen is an IT manager and creator of the Power System Jump Start course. Check out his Midrange Jump Start web site for more info on how to quickly and easily manage your AS400, iSeries or System i.

This article was originally published at http://1367.de/2010/10/17/three-easy-methods-to-get-data-from-as400-to-excel/

An alternative solution to this problem can be found at my blog http://as400softwaredownloads.com/

Optimizing Java in the Cloud - Virtual Conference

Developers and IT managers have been the first to take advantage of public clouds to explore new application architectures, test programming concepts, quickly and inexpensively introduce new applications, and create test beds for analyzing performance and scalability.

Simply writing a Java application, however, using the same techniques as those used to deploy to a local server will introduce new hurdles, from how to leverage the cloud in building new application architectures to securing applications in the cloud.

To help you succeed with your Java and cloud projects, TheServerSide.com has created the "Optimizing Java in the Cloud" virtual conference featuring independent industry experts who examine common issues Java developers encounter when developing for the cloud and the key technologies the Enterprise Java developer needs to know when moving to the cloud.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ABOUT THIS VIRTUAL CONFERENCE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TITLE: Optimizing Java in the Cloud: What Every
Java Professional Needs to Know About
Cloud Computing
DATE: Thursday, 18 November 2010
TIME: 14:30 - 21:30 (GMT)
COST: FREE
REGISTER: Click here to fast track your registration!
http://go.techtarget.com/r/12683168/682667

Throughout the day you have the exclusive opportunity to network with speakers and your peers, ask questions, participate in our expert panel on managing, optimizing and maintaining your cloud projects, evaluate vendor solutions, and so much more. Don't miss LIVE on November 18 as experts share valuable insights around:

* Innovative application architectures for development using cloud approaches;
* How to analyze and test applications and application components in the cloud;
* How to overcome challenges unique to the cloud;
* And more

This unique, live, online experience is designed to duplicate the information and interaction you'd experience at a live conference, with the convenience of desktop access and virtual experience functionality.

Don't miss out! Register now with one click! http://go.techtarget.com/r/12683169/682667



This is an interesting news received from:

TechTarget, 275 Grove Street, Newton, MA 02466 Contact: Webmaster@techtarget.com

Get More Out of Your Green Screen Programs with Presto

You have a lot invested in your IBM i and in your green screen programs. Use Presto to extract even more value from them.

Satisfy users with an instant Web GUI

Presto instantly transforms all your RPG and COBOL programs and IBM i screens into modern looking web pages that are more accepted by users. You save time by not having to make any changes to your RPG, COBOL or DDS code. Your web enabled screens are accessed via a browser which makes them easier for your users, clients and management to access and use. It's also easier for you to deploy as there is NO PC software to install to make Presto work.

Extend the functionality of your 5250 programs

You can then further increase user productivity and add new modern functionality to your applications by customizing your web-enabled screens. With the Presto Visual Editor and by having full access to the HTML code you can have more intuitive navigation and better data entry with features such as clickable links and drop down lists.

The possibilities are endless

You can also add JavaScript including jQuery or ExtJS to make your screens even more sophisticated. Using AJAX and SOA technology you can call other web programs including WebSmart PHP and ILE programs to incorporate new data or features into your application. For example, a dropdown box of available shipping rates to a zip code by loading the information from a SOA interface to an external web server such as UPS, or adding file upload, email and xls capabilities.

Start getting more out of your IBM i investment today!

Learn more or Download a Full 30-day Trial

Java and the AS/400: Practical Examples for the iSeries & AS/400 Overview

Do you want to create and deploy AS/400 and iSeries Java applications that really work? In Java and the AS/400, Daniel Darnell ignores all the hype and gets down to practical examples to help you understand how Java works in the AS/400-iSeries environment. Not just another Java tutorial, this detailed book takes you through everything you need to know about the implementation of Java on these systems and guides you through several small application examples to teach the techniques and technologies available today for AS/400 development in Java.

The fully revised Second Edition provides updated coverage of the products and tools that play into AS/400 Java development efforts (Chapter 2), expanded and revised coverage of the Java environment on the AS/400 (Chapters 4, 5, 6, and 7) expanded and revised coverage of the AS/400 Toolbox for Java (Chapters 8 and 9), and two completely new chapters. Chapter 11 helps you sort out the enhancements to ILE RPG that let you directly manipulate Java objects in your RPG code, and Chapter 12 takes a look at the tools and techniques used to develop Web applications, including a sample application deployed to the AS/400’s Apache Software Foundation Jakarta Tomcat application server.

The reality of the software development world today is that programmers must be schooled in client/server, server-only, and Web application development. With the view of this edition broadened to include Java integration features in RPG and the fundamental aspects of Web applications, you hold in your hands a book that includes all three types of application development.

This review was originally published at: http://classpath.ancientblog.net

DB2 9.7 a Technical Overview

Some Interesting News from:

Toolbox for IT

Author: Triton Consulting

Posted Date: 9/28/2010

Summary:
DB2 has been making huge strides over the past few years. The latest edition, DB2 9.7, aka COBRA, has incorporated an abundance of new functionality. This paper provides a technical overview of the new features and business benefits of moving to DB2 9.7.

Pop-up blockers may interfere with the automatic display of the document. If a new window did not open, Click here to launch the document.

People Who Liked This White Paper Also Downloaded

• Privileged User Management - It's Time to Take Control
• The World’s Best Business Intelligence Applications
• Top 10 Things Network Managers Need to Know About Virtualized Wireless LANs

Related White Papers

• Edison Group, Comparative Management Costs Study: Oracle Database 11g vs. IBM DB2 Enterprise 9.5
• Oracle Database 11g Product Family
• Lower IT Costs with Oracle Database 11g Release 2
• Advanced Compression with Oracle Database 11g Release 2
• Managing Oracle Database with Oracle Enterprise Manager Grid Control 11g

More White Papers

Receive the latest Database white papers in your inbox

Your email:

About This White Paper

About This Sponsor
Triton Consulting are Data Management specialists & IBM Premier Business Partners. Specialising in DB2 for both the mainframe and distributed systems, Triton provide a full range of services from consultancy through to education and remote support.

What Is QuickPro?

QuickPro is combining the best of both worlds from QuickImage and QuickSpool, with enhancements in printing features.



The software package is made up of three elements. The first two are our high quality software products, QuickImage and QuickSpool. The third element, the Print Server for Imaged Reports, creates the link between the two software products, giving you a complete printout solution for your report, its related image(s) and scanned form.


Setting up QuickPro is easy. To print your images, report, and scanned form together, simply specify the location and size within your report for the image and scanned form to be printed. Your final product will be a report with its related images and/or scanned form printout that meets your own specifications. After this easy setup is complete, and your images, scanned form and reports are integrated, printing can be carried out through any PC printer. Unlike most AS/400 printing, you do not require an IPDS or AFP printer to print out your reports, images and/or scanned form.


This added asset makes printing of your merged data with images more practical. You can print the report with the images automatically, or use the control options of your printer server before sending the job to print.

You can find more information on this product at:

==> http://www.studyatpku.com/

Desktop Virtualization Workshop - UK

9th and 10th Nov 10 | 9:00 AM - 5:00 PM GMT

Citrix and Intel Desktop Innovation Seminars

You are invited to join other IT pros to learn the latest information on Desktop Virtualization. This seminar for both partners and customers will equip you with all you need to revolutionize the way you manage and deliver desktops.

This free workshop in Gerrards Cross Bucks, offers a morning end user focus and an afternoon partners Session. Attend half-day or all day, depending on your interests.

Sign up now and reserve your seat before it's too late!

Morning sessions include:

• Enterprise Client Evolution DT Virtualization Inflexion trends and market overview
• Desktop Virtualization Vision and Solutions
• Intel vPro Technology - a foundation for virtualization, manageability, security
• Next generation desktop virtualization technologies/solutions

Afternoon sessions include:

• Architecture
• Installing Xen Client
• vPro Technology Manageability and Security features in detail
• XenClient/Desktop scenarios/demo

Don't wait! Get ideas and solutions from experts and learn how how you can dramatically streamline desktop management.. This event is complimentary!

---

Don’t miss this opportunity to experience networking with your peers, valuable chats with the sponsor, and Q&As to complement each workshop session. Lunch and breaktime refreshments will be served.

---

For more great online events, check out Windows IT Pro Events Central

RPG OPEN ACCESS AND PROFOUND UI: A NATIVE GUI FOR IBM i

LEARN HOW OPEN ACCESS CAN BENEFIT YOUR BUSINESS
WITH OUR EDUCATIONAL ON-DEMAND WEBCAST

Profound Logic demonstrates the value of RPG Open Access with the first handler for web development and modernisation, Profound UI, which creates native user interfaces for the IBM i utilising RPG.

Download the on-demand webcast hosted by Profound Logic and Logicmate with special speaker George Farr, IBM's World Wide Power Market Manager of Tools and Compilers.

During the event, you will learn about:

• What RPG OA is and how it benefits your business
• How to create web GUIs natively with Profound UI
• What to consider when moving to a GUI framework
• How Profound UI and RPG OA utilise existing resources and investments

When you download you will also receive a PDF copy of the Q&A from the live event.

Check it out today.
View this educational webcast now by clicking here.

Brought to you by: