System iNEWS Magazine

Browse the Archive by Author
Go to the iPro Developer archives

April 2012 System iNEWS

Cover Story: Is It Safe in the Cloud?
Plus: 3 CL Commands to Manage Digital Certificates • Cloud Security: Top 5 Vulnerabilities of the Public Cloud • Five Cloud Vulnerabilities Software Developers Should Know About • Have Migration Factory, Will Travel • How Safe Is NoSQL? • Create Realtime Web Reports with RPG • Meet Your Data Center Sidekick: IBM Systems Director 6.3 • How to Implement Open-Source Solutions: Building an Office • WebSmart PHP Modernizes Skechers Order Fulfillment System • Reader-to-Reader: Fieldproc in the Field • Isolate SQL App Problems Using IBM DB2 for i's New FTRSQLCODE • Long-Term Evolution, Short-Term Overcharging • Work-with Command Mark II: LISTSQL Revised • and more

March 2012 System iNEWS

3/1/2012

Cover Story:JavaScript and Frameworks for the IBM i Developer
Plus: Jazz Up i Projects with Rational Team Concert • Thinking Outside the SQL Box, Part 2 • A Sensible Approach to Multi-Step Queries • Reader to Reader: Solving the ‘One Penny Issue’ • How to Implement Open-Source Solutions: High Availability and Disaster Recovery • Using IBM i's National Language Support for Secondary Languages: Language-Based Interactive Subsystems • Integrating Cloud Day-to-Day • Using jQuery with RPG Applications • Explore the Ext JS JavaScript Framework • and more

February 2012 System iNEWS

2/1/2012

Cover Story:Thoroughly Mobile Manager: Bringing Tablets into Your Business
Plus: Music to the Ears of Software Developers—Rational Team Concert • The Power and Elegance of EVI-Maintained Aggregates • Reader to Reader: Alternative Method of Strings Comparison • 5 Common Misconceptions About IBM i Security • How to Implement Open-Source Solutions: Firewalls • The ABCs of IBM i Secondary Languages, Part 1 • Rough Guide to iPad Utilities for IBM i • Forces at Work in the Land of POWER • Dr. I Doctor: a Linux equivalent to IBM’s AIX Smitty tool; how to enlist NASA's resources in your network troubleshooting • and more

January 2012 System iNEWS

1/1/2012

Cover Story:Using the Cloud for Business Continuity
Plus: New PTF-Provided Features Extend RPG in IBM i 6.1 and 7.1 • CoC Frameworks for PHP and Java • Put the SBMJOBALT Command to Work, Part 2 • How to Implement Open-Source Solutions: Email Filtering • Inside Systems Management: Programming to IBM Systems Director • When Disaster Strikes: Lessons to Ensure Your Business Recovers • Linux LPAR Firewalls for IBM i Protection • New Simulation Tool Reveals POWER Advantages • Dr. I Doctor: how to trace packets through a Cisco router; fastest ways to move data to a replacement server • and more

December 2011 System iNEWS

12/1/2011

Cover Story: Solve It with PHP
Plus: Do-It-Yourself Web Reports! • Improve Your Data Center with Three-part Name Aliases • Automate Index Creation and Removal with SYSTOOLS Procedures • Keeping System Resource Security Under Control • How to Implement Open-Source Solutions: Thin Clients • How to Use IBM Systems Director Storage Control • Improve Service Delivery with ITIL • IBM’s VP of Power Systems Marketing • Dr. I Doctor: how to set up a guest network; vulnerability assessment tool for PCI DSS compliance • and more

November 2011 System iNEWS

11/1/11

Cover Story: FastCGI Boosts PHP Performance
Plus: Using the Create and Send MIME Email API • Working with SBMJOBALT, Part 1 • Thinking Outside the SQL Box, Part 1 • Use Multi-Factor Authentication to Counter Theft and Fraud • Keep an Eye On Your i with Performance Tools • Successful IBM i Disaster Recovery Best Practices • Know Thyself: Choosing the Best HA Option for Your IBM i Environment • The Ongoing Rise of PHP • Dr. I Doctor: SSL Certificate Workaround; Setting Up Fail-Over Router • and more

October 2011 System iNEWS

October 2011 System iNEWS

Cover Story: Best Practices for Developing Secure PHP Web Apps
Plus: Managing RPG Program Complexity • Deploying MediaWiki on IBM i • Magic and Myths of SQL ODPs • The Security Audit Journal—Decoded • How to Implement Open-Source Solutions: Network Infrastructure Services • Infor a Penny, Infor a Pound? • What If the Penguin Were Dead? • IntelliChief Helps Wenger Corp Speed Invoicing Process • Dr. I Doctor: TCP/IP default routes with multiple interfaces; Windows 7 secret communications channel • and more

September 2011 System iNEWS

September 2011 System iNEWS

Cover Story: Dig up Data with SQuirreL SQL
Plus: Hone the Keys for a Better User Experience • Three Easy SQL Utilities • Capture and Deploy AIX, Linux with VMControl, Storage Copy Services • Get Yourself /Free • Securing IBM Systems Director Navigator for i • Fulfilling Your BI Vision on a Budget • BI in the Cloud • War, War or Jaw, Jaw? • Dr. I Doctor: two-factor authentication to RPG apps; spanning tree problems with iSCSI networks • and more

August 2011 System iNEWS

August 2011 System iNEWS

Cover Story: Remote System Explorer: More Than Meets the Eye
Plus: 10 Tips for Developing a Retail Site • Try Modern CL Programming Techniques, Part 3 • Secure Your Web Apps with Web Application Firewalls • Work Management Refresher • IBM Systems Director 6.2.1 for IBM i Administrators • Résumés that Make the Cut • IBM's Ari Kugler on Growing IBM • Document Security Technology • Dr. I Doctor: Internet performance; “split” access and VPNs • and more

July 2011 System iNEWS

July 2011 System iNEWS

Cover Story: You Can Handle RPG OA
Plus: Restrategizing IBM i in the Age of the iPad • Tokenize My IBM i • Think Globally, Run Locally with DB2 for i 7.1 • Using Multitenant Architecture on System i • How to Implement Open-Source Solutions: File Serving • Manage Your Documents, Manage Your Business • Calculating Document Management ROI • Extending Document Capture: Routing, Management, and Process Automation • Dr. I Doctor: web server security verification; tracing TCP traffic • and more

June 2011 System iNEWS

June 2011 System iNEWS

Cover Story: No Fear: Use the Cloud for Dev & Testing
Plus: Ease Dev Tasks with RDP's Application Diagram Viewer • Optimize ILE Code for Speed, Part 2 • Make DB2 Catalog Work for You • Educate Users Against Social Engineering • Get the Best Performance Out of Your IBM i • Survey Shows Strong Commitment to IBM i • Secrets of Selecting Good Open-Source Apps • IBM Celebrates 100 Years of Innovation • Dr. I Doctor: iSCSI Behavior; Rogue Duplicate IP Address • and more

May 2011 System iNEWS

May 2011 System iNEWS

Cover Story: Convert Your Dates with APIs
Plus: Inside RD Power’s Screen Designer • Topics in ILE Optimization, Part 1 • Using an IBM i Command Interface to MySQL Features • PCI DSS 2.0: What It Means for IBM i • Open-Source Solutions: Laying the Linux Foundation • Using Pre-Installation Utility for IBM Systems Director • Momentum Builds on Wild 2010 for IBM i • A Return to Sane Security • Dr. I Doctor: IBM i IPv6 limitations • and more

April 2011 System iNEWS

April 2011 System iNEWS

Cover Story: New Open-Source Tools Blow the Lid Off Web Dev
Plus: Try Modern CL Programming Techniques, Part 2 • Build an Android App for i, Part 2 • Maintain a Database Table with a Web App • Make Your Mobile Data Secure • Customize Systems Director • Watson's 'Jeopardy!' Win a Boon for POWER7? • Guest Viewpoint: Debating the Cloud • Dr. I Doctor: VLANs; Gigabit Ethernet • and more

March 2011 System iNEWS

March 2011 System iNEWS

Cover Story: Break Free of Old RPG Habits
Plus: Build Browser-based Intranet Applications for IBM i • Modernize Your UI Using Only RPG • Try Modern CL Programming Techniques • Get Hip to Object-Oriented Programming • Debug All Your IBM i Host Apps with RDP • Get the Best IT Security Tools • Learn About Systems Director's Improved Functionality • Dr. I Doctor: Packet Storms; Migrating Domain Names • and more

February 2011 System iNEWS

February 2011 System iNEWS

Cover Story: Put Mobile Apps to Work
Plus: Build an Android App for i • Using Date Tools for SQL and Excel • Be an IT Security Pro, Not a Slacker • Tailor IBM i Access for Windows Installation Images • Achieve Outstanding Journal Performance with Write Cache • Industry Report: Exploring Today's IBM i Clouds, Part 2 • Dr. I Doctor: IPv4 & IPv6 Multi-homing; Wireless Bridges • Hot or Not? Android Tablets • and more

January 2011 System iNEWS

January 2011 System iNEWS

Cover Story: IBM's 7.1 ILE RPG Enhancements
Plus: Externalize Database Processing—Revisited • Discover Security Controls for DB2 for i Tool Usage • Tighten and Control Access to Your i • Save New Spooled Files • Dr. I Doctor: Networking Printing; VPNs and Network Resilience • Industry Report: Exploring Today's IBM i Clouds, Part 1 • Think Twice Before Bailing on Disaster Recovery • Hot or Not? 'Mainframe in a Box' • and more

December 2010 System iNEWS

December 2010 System iNEWS

Cover Story: Get Software Free! 90 Free Tools for Your IBM i
Plus: Document RPG Procedure and Program Calls • Run WDSC, RDi on Linux • Combine Hot Cloud Tech with Cool IBM i Tech • Enjoy Faster Backup and Recovery with BRMS • Understand and Leverage IBM i Security, Part 2 • Uncover Systems Director Navigator for i 7.1 • Industry Report: Breaking Through IBM i Web Dev Barriers • Hot or Not? Ad Hoc Knowledge • and more

November 2010 System iNEWS

November 2010 System iNEWS

Cover Story: HA: A Revenue Engine for Your Business
Plus: Introducing RPG File I/O to the Other Guys, Part 2 • Take Advantage of MI Instruction CALLPGMV • Create More Dynamic Arrays • Get Faster Updates with New .NET Features • Understand and Leverage IBM i Security, Part 1 • Improve Program Quality with Unit Testing • Industry Report: IBM Virtual Loaner Program • Hot or Not? Heterogeneous Support • and more

October 2010 System iNEWS

October 2010 System iNEWS

Cover Story: Fortify Your VLAN Connections
Plus: Explore Dates/Times, Web Services, and More in PHP • Use i Strategies to Grok J2EE Web Dev • Create Dynamic Arrays • Build a Dimensional Database for BI on IBM i • Put BRMS Best Practices to Work for Your Enterprise • Get Insight into Logging Activity with SEIM • Leverage Recent Enhancements to IBM Systems Director • Hot or Not? IT Automation • and more

September 2010 System iNEWS

September 2010 System iNEWS

Cover Story: BI Means Business
Plus: Put PHP and RPG Web Services to Work • Read, Prepare, Generate an XML document for Any DB2 File • Back Up the i to NAS • Develop Sensible Social Media Security Policies • Check Out Systems Director's New Flavors • BI Action Still Plenty Hot • Product Roundup: BI Tools for IBM i • Special Report: Integrating Microsoft .NET with the IBM i

August 2010 System iNEWS

August 2010 System iNEWS

Cover Story: PHP Opens Doors to Database Options
Plus: Build IBM Artifacts with IBM RTCi • Write More Robust ILE Apps Using Heap Memory • Connect Zend Framework to DB2 • Understand the Essentials of Encryption • Create Your Own Commands for the i • Industry Report: RPG OA—The Biggest Oxymoron in the Room? • Special Report: Realtime Data Integration

July 2010 System iNEWS

July 2010 System iNEWS

Cover Story: Navigate the World of Communications Options
Plus: Introducing RPG File I/O to the Other Guys • Working with Ajax, JSON, REST, and RPG • Pass Data Structures to RPG with PHP • Capitalize on 7.1's Remote-Journal Enhancements • Detect Database Changes • Customize Your IBM i with Exit Points • Enhance Your PHP Experience with Zend Server • Take a Guided Tour of IBM i TCP/IP Features • Hot or Not? Windows Server on non-x86 Platforms

June 2010 System iNEWS

June 2010 System iNEWS

Cover Story: Opening Document Management to the Cloud
Plus: Internationalize Your Reports • Use DB2 for i 7.1 to Ease XML Exchanges • Encrypt with Tokenization • Monitor All Your Power Systems Resources • Leverage Virtual IP Addresses for HA/DR and More • Take a Good Swing at Document Management Compliance • Industry Report: IBM's POWER7 Blades Grow Bigger Than Ever

May 2010 System iNEWS

May 2010 System iNEWS

Cover Story: IBM Unifies App Dev Tools!
Plus: Explore PHP's Approach to IBM i Database Access • Create Printed Reports Using DDS • Search for Data in XML Docs • Detect Security-Related Events • Extend IT Resources with Active Memory Sharing • Need-to-Know Security Updates in IBM i 6.1 • Industry Report: IBM Delivers IBM i 7.1

April 2010 System iNEWS

April 2010 System iNEWS

Cover Story: Handle Errors with a Tool You Already Have
Plus: Handle Errors with Monitor Groups • Explore PHP Functions from an RPG PoV • Step into the Cross-Platform GUI Desktop World • SQL Your XML • Detect Access to Sensitive Files • Discover Three Keys to ERP Survival • Metamorphoses: The Story of RPG • Industry Report: IBM Amps Everything with POWER7

March 2010 System iNEWS

March 2010 System iNEWS

Cover Story: Design a Mobile User Experience
Plus: Glean Even More PHP Fundamentals from an RPG Perspective • Put Grails on IBM i Apps to Work • Use SQL for Simple Ways to Transform Between Data Types • Test Your Journal IQ • Audit and Report on User Activity • Discover Little-Known Systems Director Capabilities • Set Up an IPv6 Test Lab • Industry Report: IBM Goes Global with Smarter Planet

February 2010 System iNEWS

February 2010 System iNEWS

Cover Story: Render IBM i Web Pages to a Smartphone
Plus: Analyze Your Audit Journal with RPG • Explore the Free EGL CE • Call RPG from Groovy • Eschew These Deadly Journal Sins • Learn and Avoid the Top 10 i Security Myths • Speed Up Your IBM i Upgrades • Viewpoint: Time for a Business App Generator? • Industry Report: Bit of Everything Selling in IBM i World

January 2010 System iNEWS

January 2010 System iNEWS

Cover Story: Get Off the Island: Upgrade Your OS
Plus: Create a Grails App in 5 Minutes • More PHP Fundamentals from an RPG Perspective • Use the WITH Clause for Better SQL Statements • Encrypt Your Tapes with the IBM EKM • Explore Open-Source Options for i • Solid State Drives for Super Speed • App Mapping: Writing Programs to Update Your Programs • Soltis: Hardware Changes' Impact on Application Programming

December 2009 System iNEWS

December 2009 System iNEWS

Cover Story: Bloopers, Blunders & Gaffes
Plus: Use the API Error Parameter • Learn PHP Fundamentals from an RPG Perspective • Create a Tool to Monitor Message Queues • Get an Overview of Open Source in the i Community • Put Central Site Distribution to Work • Connect to Open Storage: DS5000 • Application Mapping on IBM i • Web Dev Strategies for Business

November 2009 System iNEWS

November 2009 System iNEWS

Cover Story: Configure Apache for Security
Plus: Convert RPG Apps to Support Diverse Languages • Have Your Modern Interface and an RPG Core, Too • Audit and Track STRSQL Usage • Ensure Availability of Virtual, Consolidated Workloads • Equip External Storage for HA Scenarios • Use Navigator for i to Create Free Monitoring Tools • Developer's Guide for Now: 5 Plus 1 Must-Have Skills • Buyer's Guide: Enterprise Wireless • Hot or Not? Open-Source Software

October 2009 System iNEWS

October 2009 System iNEWS

Cover Story: Take Back Your WiFi: Lock Out Interlopers
Plus: NAC the Knife • Security Checklist for Your Compliance Audits • Make Maintenance Programming More Efficient • Learn About Open Source for Enterprises • Fine-Tune Your Backup and Recovery Plan • Understand Adopted Authority Concepts • Get a Website Up and Running with Open-Source CMS on IBM i

September 2009 System iNEWS

September 2009 System iNEWS

Cover Story: BI for SMBs: More Options, Better Tools, Faster Answers
Plus: Use Data Structures to Save Time • Tune, Tweak, and Extend RDi • Consider Using a RESTful Web Service • Provide New Functionality for Free with Open-Source Apps • Determine Feasible HA/DR Objectives for Your Business • Audit and Report on CL Command Use • Viewpoint: Are You Guilty of IT Malpractice?

August 2009 System iNEWS

August 2009 System iNEWS

Cover Story: Weather the Economic Storm
Plus: Industry Regs Can Help IT Skirt the Storm • Optimize Your Data Center with Active Energy Manager • Industry Report: IBM Smart Market + iManifest + ilook = A New Power Equation? • Convert Character Strings to One Case • Explore Native PHP Development Tools • Leverage SQL's Powerful CASE Statement • Put Disaster Recovery Within Reach with PowerHA Solutions • and more

July 2009 System iNEWS

July 2009 System iNEWS

Cover Story: Hook into IBM i Development Tools
Plus: Extend RDi • MySQL IBMDB2I Storage Engine • Journal Performance • SQL Table-Level Security • Stored Procedures on IBM i • Performance Tasks in Systems Director Navigator for i • Performance Data Investigator • Industry Report: Will COMMON's Next Big Challenge Be Its Last? • Solution Spotlight: NetIQ Security Solutions for iSeries

June 2009 System iNEWS

June 2009 System iNEWS

Cover Story: 11 Deadly Database Sins
Plus: Easily Retrieve Spooled File Lists • Amplify Your Value with Essential IT Competencies • Modernize Your Database • Streamline RPG Apps with Embedded SQL • Cut Bloated Journal Receivers Down to Size • Secure System i Access for Web • Industry Report: Programmers—Avoid Becoming a Commodity • Solution Spotlight: Clementine Data Mining Software

May 2009 System iNEWS

May 2009 System iNEWS

Cover Story: IPL Your Career
Plus: MI for the CL Programmer: More Examples • Self-Training on a Budget • Get Real with PHP • Open Community Web Deployment Update • Track Down Hidden Journal Bloat • Industry Report: IBM Layoffs Amidst Record Revenue • Hot or Not? Mainframes • Product Roundup: .NET Integration with the IBM i

April 2009 System iNEWS

April 2009 System iNEWS

Cover Story: Move to IPv6 Now
Plus: Install IBM i on a Power Blade • Code SQL Routines for Better Performance • Understand Your Remote Journal Setup • Keep Your Service Tools Secure • Industry Report: The Inevitable(?) Rise of PHP • Hot or Not? Enterprise Mobility Offerings • Case Study: State Board Taps CA Plex/Websydian

March 2009 System iNEWS

March 2009 System iNEWS

Cover Story: Recycle RPG
In Depth—Disaster Recovery: Avoid These Disaster Recovery Assumptions • Know the Pitfalls of Cutting IT Costs • Recover Your Security Information
PLUS: Manage Complex Data with DB2 Tools • Beware of Common App Mod Pitfalls • Industry Report: Economic Chill Freezes IT Budgets

February 2009 System iNEWS

February 2009 System iNEWS

Cover Story: Squash Bugs with Debugging Tools
In Depth—Troubleshooting: Track Down and Solve Data Access Connection Errors • Fix Network Errors with 3 Essential Ingredients • Use Messages to Diagnose System Problems
PLUS: Opinion: IPv6 Readiness • Hot or Not? Netbooks • Industry Report: What's Going on with IBM i Pricing?

January 2009 System iNEWS

January 2009 System iNEWS

Cover Story: Thinking in PHP
In Depth—PHP: Access DB2 for i Data from PHP • Create GUIs with 5250 Bridge and PHP • Lighten Your Load with PHP Frameworks
PLUS: Improve Your Technology Team • Chartering Your Path to Success • Enhance Your Career with PHP? • 10 IT Problems We Don’t Have with i • Hot or Not? Web and Cloud Storage

December 2008 System iNEWS

December 2008 System iNEWS

Cover Story: Youdunit: Embarrassing Computer Snafus—Bypass This Batch of Blunders
In Depth—Computer Goof-ups: Get a Chuckle from These Snafus • Avoid RCLSTG and SQL Mistakes
PLUS: Why Don't We Have a Native Web UI? • Opinion: Happy Birthday to the i | The Art of No • Hot or Not? Consumerization of IT • Industry Report: The i Doesn't Get More Available than This

November 2008 System iNEWS

November 2008 System iNEWS

Cover Story: Compliance: Formula for Success
In Depth—Security & Encryption: Learn Key Management Best Practices • Secure Your DB2 Data • Lock Down Mobile Computing • Get Secure with Tape Encryption
PLUS: i Pros Talk Challenges

October 2008 System iNEWS

October 2008 System iNEWS

Cover Story: The 5 D's of a Great IT Manager
In Depth—RPG: RPG IV Style for the 21st Century • Writing RPG Code Then and Now • Simplify ILE with Service Programs
PLUS: Demystify Virtualization

September 2008 System iNEWS

September 2008 System iNEWS

Cover Story: Real-World Business Intelligence
In Depth—Database: Create Queries with WDSc's SQL Builder • Renovate App Databases with DDL • V6R1 Navigator for i5/OS Enhancements
PLUS: Unicode and the System i

July 2008 System iNEWS

July 2008 System iNEWS

Cover Story: Avoid the Programming Dark Side
In Depth—Web Services: Get Started with Web Services • Call a Web Service with RPG • Invoke SOAP-based Web Services with PHP • Consume a Web Service with Java or Groovy
PLUS: Selling the New i on Power Systems

August 2008 System iNEWS

August 2008 System iNEWS

Cover Story: Ins and Outs of PTFs
In Depth—Networking: Use OpenSSH for Secure Networking • Improve Network Resilience and Security with DNS • Leverage SAN for Money and Energy Savings
PLUS: Defect Tracking and Reporting Essentials

June 2008 System iNEWS

June 2008 System iNEWS

Cover Story: Be a System i-vangelist
In Depth—Expand WDSc's Functionality: Use RSE in 4 Common Setups • Enrich WDSc with Plug-ins • Manage Object Lists with Filters
PLUS: Industry Report—The i Has It: IBM Powers On

May 2008 System iNEWS

May 2008 System iNEWS

Cover Story: Cover Focus: App Modernization: Focus on Business Benefits
In Depth—Add to Your RPG Repertoire: Model-driven Development • Java • Modern RPG • .NET
PLUS: Industry Report—Dev Experts Talk RDi, RDi SOA

April 2008 System iNEWS

April 2008 System iNEWS

Cover Story: IBM Revitalizes Dev Tools
In Depth—Web-Enable Your RPG: 4 Choices for You: The CGIDEV2 Way • The PHP Way • The Java or Groovy Way
PLUS: The Grudge Report — April Foolery

March 2008

March 2008

Cover Story: Brighten Your IT Career Prospects
In Depth—SQL: DB2 for V6R1 • Multiple Tables • Multidimensional Requests • Common Table Expressions
PLUS: Behind IBM's Reorganizations

February 01, 2008

February 01, 2008

Cover Story: 32-Bit JVM Revs Up Java Apps
In Depth—PHP: PHP for Net.Data Programmers • Install PHP • Implement Open-Source Web Deployment Stack
PLUS: Is i5's Future a Blade?

January 01, 2008

January 01, 2008

Cover Story: Asset Protection: What Have You Overlooked?
In Depth—Business Resilience: Prepared for DR? • Build for HA with IASPs • Also: related product coverage
PLUS: Exploring the App-Dev Solution Decision

December 01, 2007

December 01, 2007

Cover Story: Get Project Requirements Right
In Depth—Heaps of Tips: Programming: API, CL, Database, & more • Systems Management: Backup & Recovery, iSeries Access, Remote Admin, & more
PLUS: 6 Succinct Tips

November 01, 2007

November 01, 2007

Cover Story: Add MySQL to Multiply Your App Options
In Depth—Security: Be a NAC Ninja • Tighten Security with Exit Point Programs • Set Up PGP • and more
PLUS: Roundtable: Direction of System i Technology

October 01, 2007

October 01, 2007

Cover Story: ILE RPG: The Gold Standard
In Depth—Database Access: Expand Your SQL Horizons • Master SQL Triggers • Deliver Useful Dashboards • and more
PLUS: System i Shops at a Glance

September 01, 2007

September 01, 2007

Cover Story: Modernization: Balance Business and IT Needs
In Depth—Windows Integration: Integrate Vista and i • Add SQL Server Tactics to DB2 • Connect to MySQL • and more
PLUS: Hot or Not? i and p Union

August 01, 2007

August 01, 2007

Cover Story: Plug In to VoIP
In Depth — Code Comprehension: 5 WDSc Features for Code Comprehension • Grokking the Code • Search Code with Regular Expressions
PLUS: Roundup: RPG Code Comprehension Tools

July 15, 2007

July 15, 2007

25th Anniversary Supplement

July 01, 2007

July 01, 2007

Cover Story: Score with Agile Software Dev
In Depth — Web App Design: Analyze Your Dev Options • Craft an App with Java Frameworks • Add Flair with CSS • Master JS and DOM
PLUS: 25th anniversary supplement

June 01, 2007

June 01, 2007

Cover Story: 15 Browser UI Design Essentials
In Depth — Practical Compliance: Create and Validate Digital Signatures • What Sox Auditors Look For • Why Encrypt? • and more
PLUS: What's Hot for System i

May 01, 2007

May 01, 2007

Cover Story: WDSc - Give Toronto Your Input
In Depth - SQL Primer: Define Columns for SQL Tables • Deploy Secure SQL • Optimize Queries • Uncover SQL Plan Cache • and more
PLUS: Keep an IT Diary

April 01, 2007

April 01, 2007

Cover Story: i on QShell & PASE
In Depth — WDSc and You: What’s New in Version 7.0 • Build Your WDSc Environment the Easy Way • Helpful Debugging Gems • and more
PLUS: April Fools Drollery

March 01, 2007

March 01, 2007

Cover Story: Use Database Appliances to Cruise Megadata
In Depth — Ajax: Use Design Patterns to Leverage Ajax Dev • Simplify Web Apps with Ajax, RPG, and XSL • and more
PLUS: Industry Report: Linux on System i

February 01, 2007

February 01, 2007

Cover Story: The Web Dev Dating Game: Is PHP for You?
In Depth — RPG Patterns: Employ Software Design Patterns • Develop ILE RPG Design Patterns • Implement ILE Successfully
PLUS: Vista: When to Upgrade?

January 01, 2007

January 01, 2007

Cover Story: Ajax Field Guide
In Depth: Disaster Recovery — Virtual Tape: The "Real" Deal • Disaster Recovery on a Budget • IPL from External Storage: HA Nirvana?
PLUS: 25 Years of NEWS: Past Predictions

December 01, 2006

December 01, 2006

Cover Story: Secrets of Software Project Management
In Depth: Tips! — Programming: RPG, SQL, WDSc, and more • Systems Management: File Transfer, Printing, Security, and more
PLUS: App Modernization Roundtable, Pt. 2

November 01, 2006

November 01, 2006

Cover Story: V5R4 Encryption Enhancements
In Depth: Security — Safely Allow Temp Access to Apps • Boost Your Security with Reduced Sign-on • Secure Your VPN • and more
PLUS: Roundtable on App Modernization

October 01, 2006

October 01, 2006

Cover Story: Tame the Compliance Jungle
In Depth: Database Control — Guarantee Integrity: Guide to DB Transactions • Address Vulnerabilities: Open DB File Exit Point • and more
PLUS: Is Certification Worth It?

September 01, 2006

September 01, 2006

Cover Story: Why the System i Rules
In Depth: APIs — Get Started with Our Guide to APIs • Put Open List APIs to Work • Use APIs to Write SSL Apps in RPG
PLUS: Soltis on Multithreading and POWER6

August 01, 2006

August 01, 2006

Cover Story: Guarantee a Quality Application
In Depth: Performance — Optimize ODBC and OLE DB Performance • Analyze Data Access Methods • Improve Throughput
PLUS: Chasing the International System i

July 01, 2006

July 01, 2006

Cover Story: SOA Will Rock Your World
In Depth: Web Services — Intro to Web Services Standards • Make Sense of WS-Security • Access Web Services from RPG • and more!
PLUS: i5 and the Rising Cost of Energy

June 01, 2006

June 01, 2006

Cover Story: Coding in the 21st Century
In Depth: App Dev —19 Steps to Better CL Style • JavaScript for RPG Coders • Program Comprehension with WDSc • and more!
PLUS: Love to Hate It: iSeries Info Center

May 01, 2006

May 01, 2006

Cover Story: Next Gen Clients
In Depth: Communications — The Next High in Wi-Fi: 802.11n • App-to-App Communication with Asynch Messaging • TCP/IP Apps in ILE RPG • and more! PLUS: Untangling IT: Hi, 5!

April 01, 2006

April 01, 2006

Cover Story: Business Intelligence: Hindsight or Insight?
In Depth: Reporting/Printing — V5R4: Save and Restore Spooled Files • Print Within CGI • Print Without iSeries Access, and more.
PLUS: April Fools Fun!

March 01, 2006

March 01, 2006

Cover Story: "On the Glass" Portals
In Depth: SQL — Functions • Tables: Move and Copy • Diagnostics, and more!
Plus: V5R4 Coverage

February 01, 2006

February 01, 2006

RPG: Options for Storing, Editing, and Compiling Source Code • Runtime Arrays in RPG • ILE Activation Groups • Reusable RPG APIs • Write or Call RPG Procedures with Ease, and more!

January 01, 2006

January 01, 2006

DISASTER RECOVERY: From HA to Business Continuity • Versatile Remote Journal Support • Backup Horror Stories • Test Your Backup & Recovery Plan. PLUS: Peek Inside Query Optimizer • Get Started with RFID, and more!

December 01, 2005

December 01, 2005

APPLICATION PERFORMANCE: Speed SQL Batch Performance • Tune IFS Performance • Compare Subfile Sort Methods • Use PEX APIs to Trace Transaction Performance • and more. PLUS — SWEET TIPS: programming, sys admin, and more!

November 01, 2005

November 01, 2005

SECURITY: Eliminate Your Top Security Exposures • Simplify Remote-User Security with SSL VPNs • Secure XML Documents • Protect Data with Cryptographic Services APIs • Get Started with iSeries SSL • and more!

October 01, 2005

October 01, 2005

DATA ACCESS: 6 Indispensable FTP Tips • Share iSeries Data Across Systems with XML • Global Temp Tables: Avoid an SPL Constraint • Develop iSeries Data Queue Apps with .NET • Move iSeries Data to SQL Server • and more!

September 01, 2005

September 01, 2005

DIVE INTO THE IFS: Secure Your IFS • Tune IFS Performance • Work with Directories • Protect Your IFS from Viruses • Shadow an IFS Java Programmer • PLUS: Soltis on the New "Cell" Chip • 12 Great BIFs • and more!

August 01, 2005

August 01, 2005

DEV TOOLS: Inside Eclipse 3.1 • Free RPG Source Control • Hidden Gems of PDM and SEU • WDSc Plug-ins: 21 Tools. PLUS: The Many Flavors of LPAR • Consolidate Your Servers, Maximize Your Resources • and more!

July 01, 2005

July 01, 2005

iSeries App Modularization Choices • Maintainable Service Programs • Logging Capability for Your Apps • Regular Expression Processing in RPG • Database Enhancement with Trigger Programs • Power5 Partitioning • and more!

June 01, 2005

June 01, 2005

Secure Remote Admin with SSH • Critical DNS Changes • Utilities: Identify Authority-Adopting Programs; Reenable Disabled NetServer Users • RPG & IFS: Working with Links • Using Code Designer in WDSc • and more!

May 01, 2005

May 01, 2005

Faster DB Access, Tighter Security • Wi-Fi Time Bomb • Navigating the Blogosphere • Five Absolutes to ERP Implementation • RPG and IFS: Get Info About Your Files • Take Single Sign-On for a Spin • and more!

April 01, 2005

April 01, 2005

User Interface Options: CGI, Java, ColdFusion, WebFacing/HATS, 3rd Party • 10Gig Ethernet • iSeries-Friendly Domino Apps • Fall (and Rise?) of iSeries Education • and more!

March 01, 2005

March 01, 2005

Update Your RPG • Learn About Extreme Programming • Compile Programs in WDSc • Create a Java Web Service in WDSc • and more!

February 01, 2005

February 01, 2005

iSeries Access for Web Help • An Up-Close Look at OS/400 Host Servers • Fast Tracking the Supply Chain! • Free Utility: Display Source Code of Any Program Object • and more!

January 01, 2005

January 01, 2005

Why OS/400 & i5/OS can live virtually forever • faster SQL apps • DB2 triggers • rethinking iSeries security • common tasks made easy with text files • and more!

December 01, 2004

December 01, 2004

Cool Things About RPG, CL, DB2 UDB • Secure Service Tools • Web Services Security • Text File Basics • Check Printing Comes of Age • and more!

November 01, 2004

November 01, 2004

IFS Essentials • Service Tools Security • Is a SAN in Your Future? • ROI on RFID • V5 Support for Color Apps • Extend a WebFacing App • and more!

October 01, 2004

October 01, 2004

Discover WAS V5.1 • Config & Admin WebSphere • Utility: Access External DBs with RPG & Java • Utility: Take Back Control of Special Authorities • and more!

September 01, 2004

September 01, 2004

LPAR in depth • HA buyers guide • Wi-Fi lockdown • TCP/IP security • and more!

August 01, 2004

August 01, 2004

sharpen your RPG skills • explore IBM’s JDBC driver • simplify security auditing • and more!

July 01, 2004

July 01, 2004

new database tools in V5R3 • other V5R3 enhancements • free utility: Work with Source • and more!

June 01, 2004

June 01, 2004

Linux on the iSeries • V5R3 announcement coverage • inside iSeries Nav's new functions • and more!

April 01, 2004

April 01, 2004

Wireless Technology

September 01, 2002

September 01, 2002

Application Modernization

April 15, 2002

April 15, 2002

Spring 2002 Special Report

November 01, 2001

November 01, 2001

Backup and Recovery

October 15, 2001

October 15, 2001

Fall 2001 Special Report

July 01, 2001

July 01, 2001

Exploring the IFS

June 01, 2001

June 01, 2001

V5 Database Enhancements

May 01, 2001

May 01, 2001

WebSphere & V5R1

April 15, 2001

April 15, 2001

Spring 2001 Bonus Issue

December 15, 2000

December 15, 2000

Winter 2000 Special Issue: Building Integrated AS/400-Windows NT/2000 Solutions

December 01, 2000

December 01, 2000

Remote Administration

July 15, 2000

July 15, 2000

Summer 2000 Special Issue: The Jungle of e-Service & Support

July 01, 2000

July 01, 2000

Programmer's Workshop

June 01, 2000

June 01, 2000

Building a Better Web

May 01, 2000

May 01, 2000

Taking Domino to the Next Level

April 01, 2000

April 01, 2000

Get the Message Across with Middleware

March 01, 2000

March 01, 2000

The SQL Alternative

February 01, 2000

February 01, 2000

The Modern Age of RPG

January 01, 2000

January 01, 2000

Get Ready to Ride the Wild, Wild Web

December 01, 1999

December 01, 1999

The AS/400: Positioned To Win!

November 15, 1999

November 15, 1999

Winter 1999 Special Issue: The e-Business Beast

November 01, 1999

November 01, 1999

Security On The Inside

October 01, 1999

October 01, 1999

UDB: What's in it for you?

August 01, 1999

August 01, 1999

Exploring AS/400 Connections

July 01, 1999

July 01, 1999

Harness the Power of SQL

June 15, 1999

June 15, 1999

Summer 1999 Special Issue - Modernizing the AS/400 Portfolio

June 01, 1999

June 01, 1999

TCP/IP — What's New in 1999?

May 01, 1999

May 01, 1999

Data Warehousing Powerhouse

April 01, 1999

April 01, 1999

AS/400 as a Web Server

March 01, 1999

March 01, 1999

Programming Techniques

January 01, 1999

January 01, 1999

Network Infrastructure

December 15, 1998

December 15, 1998

Winter 1998 Report: Web Publishing

September 01, 1998

September 01, 1998

IBM Announces V4R3 and Powerful New Hardware

August 01, 1998

August 01, 1998

AS/400 and Windows NT: Cooperation and Integration

July 01, 1998

July 01, 1998

Leverage Your Intranet

June 15, 1998

June 15, 1998

June Special Report

June 01, 1998

June 01, 1998

Hacking the AS/400: How Safe Are You?

May 01, 1998

May 01, 1998

Domino: A New Game for AS/400 Users

April 01, 1998

April 01, 1998

DB2/400: Channeling the Flow of Data

February 01, 1998

February 01, 1998

IT Careers in the 21st Century

January 01, 1998

January 01, 1998

Take Control of Client Access

December 15, 1997

December 15, 1997

Winter 1997 Special Issue

November 01, 1997

November 01, 1997

AS/400, NT & Netware Solutions

August 01, 1997

August 01, 1997

Data for Your Business

July 01, 1997

July 01, 1997

Instant Intranet

June 15, 1997

June 15, 1997

Summer 1997 Special Issue: Approaching 2000

May 01, 1997

May 01, 1997

Remote Connectivity

April 01, 1997

April 01, 1997

Power Programming

March 01, 1997

March 01, 1997

DB2/400 Performance

February 01, 1997

February 01, 1997

The AS/400 & Windows NT: Partners or Rivals?

December 15, 1996

December 15, 1996

Winter 1996 Special Issue: Living with LANs

December 01, 1996

December 01, 1996

101 Tips & Techniques

September 01, 1996

September 01, 1996

SQL Challenges DDS & RPG

August 01, 1996

August 01, 1996

Make Your Programs Perform

July 01, 1996

July 01, 1996

AS/400 Meets the World Wide Web

June 15, 1996

June 15, 1996

Summer 1996 Special Issue

May 01, 1996

May 01, 1996

The AS/400 as Server

April 01, 1996

April 01, 1996

Deliver with DB2/400

March 15, 1996

March 15, 1996

Spring 1996 Special Issue

March 01, 1996

March 01, 1996

TCP/IP: Passport to Multiplatform Networks

February 01, 1996

February 01, 1996

What's In Store for 1996

December 15, 1995

December 15, 1995

Winter 1999 Special issue: System Software & Programmer Tools

December 01, 1995

December 01, 1995

Tips & Techniques Special Issue

November 01, 1995

November 01, 1995

Up and Running with the FSIOP

September 15, 1995

September 15, 1995

Fall 1995 Special Issue: Peripherals

September 01, 1995

September 01, 1995

AS/400-LAN Connections: Better Than Ever!

August 01, 1995

August 01, 1995

A New Client for the AS/400

July 01, 1995

July 01, 1995

Inside the PowerPC AS

June 15, 1995

June 15, 1995

Summer 1995 Special Issue: Focus on Application Software

June 01, 1995

June 01, 1995

Expand Your Universe

May 01, 1995

May 01, 1995

AS/400 Visual Programming Palette

April 01, 1995

April 01, 1995

AS/400 Middleware Emerges

March 15, 1995

March 15, 1995

Spring 1995 Special Issue

March 01, 1995

March 01, 1995

The Dawning of a VisualAge

February 01, 1995

February 01, 1995

Data Integrity Energizers

December 15, 1994

December 15, 1994

System Software & Programmer Tools

December 01, 1994

December 01, 1994

The New AS/400 Database

October 01, 1994

October 01, 1994

A Candid Talk with Dave Thomas

September 01, 1994

September 01, 1994

Now Playing ILE RPG/400 -- ILE COBOL

August 01, 1994

August 01, 1994

Is Your AS/400 Secure?

July 01, 1994

July 01, 1994

The Different Internet Faces of the AS/400

May 01, 1994

May 01, 1994

V2R3 and the Changing AS/400

January 01, 1994

January 01, 1994

Open Your System With APIs

December 15, 1993

December 15, 1993

Winter 1993 Special Issue: A Guide to Buying System Software

November 01, 1993

November 01, 1993

Client Server You Can Do It Now

October 01, 1993

October 01, 1993

Legacy Code: Time for an Overhaul?

September 15, 1993

September 15, 1993

Fall 1993 Special Issue: A Guide to Buying Peripheral-Based Solutions

September 01, 1993

September 01, 1993

Introducing AS/400 Client/Server Computing

August 01, 1993

August 01, 1993

In Search of Peak Performance

July 01, 1993

July 01, 1993

Nuts and Bolts Programming

June 15, 1993

June 15, 1993

Summer 1993 Special Issue: A Guide to Buying Application Software

June 01, 1993

June 01, 1993

Communications: Recipes for Success

May 01, 1993

May 01, 1993

What's in the Cards for the AS/400?

April 01, 1993

April 01, 1993

Information Retrieval

March 15, 1993

March 15, 1993

Spring 1993 Special Issue: A Guide to Buying Communications Solutions

March 01, 1993

March 01, 1993

3X/400 Database

February 01, 1993

February 01, 1993

Testing: Bringing Bugs Into Focus

January 01, 1993

January 01, 1993

Choices For Your Desktop

December 15, 1992

December 15, 1992

Winter 1992 Special Issue: A Guide to Buying System Software

December 01, 1992

December 01, 1992

Winning the Token-Ring Battle

November 01, 1992

November 01, 1992

Application Generators

October 01, 1992

October 01, 1992

Application Design

September 15, 1992

September 15, 1992

Summer 1992 Special Issue: A Guide to Buying Peripherals

September 01, 1992

September 01, 1992

Awk...Ool! A New Generation of Languages

August 01, 1992

August 01, 1992

S/36 Alternatives

July 01, 1992

July 01, 1992

10th Anniversary Special Edition

June 15, 1992

June 15, 1992

Summer 1992 Special Edition: A Guide to Buying Application Software

June 01, 1992

June 01, 1992

The Elements of Programming Style

May 01, 1992

May 01, 1992

Pull Your Data Together

March 15, 1992

March 15, 1992

Spring 1992 Special Issue: A Guide to Buying Communications Hardware

March 01, 1992

March 01, 1992

GUIs: The Dawn of a New Age

January 01, 1992

January 01, 1992

Connectivity: Bridging the Gap

December 01, 1991

December 01, 1991

Building Connections Between Systems

June 01, 1990

June 01, 1990

Advanced Peer to Peer Network


 

around the forums

better data access for AS400 applications
Forum Name: Systems Management
21 May 2012 06:22 AM | Replies: 0
Selection error involving field *N.
Forum Name: SQL, Query and Database
18 May 2012 02:19 PM | Replies: 6
WINDOWS 7 with CLIENT ACCESS 7 R1
Forum Name: Communications/Networking
18 May 2012 08:43 AM | Replies: 1

ProVIP Sponsors

BCD

Join Our Community!

Subscribe today to iPro Developer! iPro Developer is packed with technical know-how for developers of IBM i, iSeries, AS400 and System i. Sign up now to get your full subscriber benefits including:

  • Code available for download
  • Full access to the online article archive (including all System iNEWS ProVIP content)
  • Downloadable ebook with past 6 months of articles
  • Discounts on eLearning classes, self-paced training, in-person events, and more!
iPro Developer Newsletters
  • Get the Latest News
  • Product Updates
  • Helpful Tricks
  • Productivity Tips