Use PCOMM Scripts to Dynamically Build a Spreadsheet, Part 2
by Michael Sansoterra

In Part 1 of this series, I demonstrated that users of IBM's Personnel Communications can use VBScript to run a remote PC command right from the 5250 emulator window. I want to build on that short tutorial by demonstrating how to build an Excel spreadsheet right from the context of the current 5250 screen. READ MORE >

Use SQL to Strip Out Tab Characters
Hey Ted:

We have a system set up to import orders from a Website. Sometimes a field comes through from our Website with the tab character. We didn't realize this is possible and have since started scrubbing the data before it is imported. The problem is that I already have some data in our System i tables that have the tab character in them. This is causing some odd things to happen later in our processes. I need some way to remove all of the tab characters from our database. Do you have a SQL statement or other magic way to find and replace these? READ MORE >