FHG Volume: 8 Archives - Page 11 of 13

More About SQL Correlation Names

March 12, 2008 Hey, Ted

I hope my question is an easy one to answer. I have a file that stores the location of inventory in a warehouse. Location consists of a row (an aisle), column, and level. Why will an SQL UPDATE let me change the column and level, but not the row?

–Scott

You can update the column like this:

update qtemp/inventory 
   set column=4        
 where item = 'SL-701'

But updating the row gives you error SQL0104. (Token 4 was not valid. Valid tokens: ( : DAY CAST CHAR DATE DAYS HOUOUR LEFT TIME TRIM YEAR COUNT MONTH.)

update qtemp/inventory 
   set row=4           
 where item

…

Admin Alert: A Much Quicker Way to Move System i Objects Between Partitions

March 12, 2008 Joe Hertvik

In a recent article, I detailed how to use common i5/OS commands to easily transfer System i objects between partitions. After publication, several readers wrote to say that if you have a working SNADS network between your target and source partitions, transferring objects is incredibly easy if you just use the commands that come with IBM‘s free ObjectConnect licensed program. And you know something, they’re right! ObjectConnect is easier.

This week, I’ll review what ObjectConnect does for i5/OS object movement between systems, how to make sure that you have it installed on your machine, and how to use

…

Performance Advice from a Mysterious Friend

March 5, 2008 Dear Professional

One of your fellow subscribers sent me some performance tips that he says have made enormous performance improvements for his customers. He asked me to share them with you. Here’s the first one:

Change system value QDBFSTCCOL (Database file statistics collection) to *NONE during the day. Change the value to *ALL during non-peak times.

System value QDBFSTCCOL is shipped with a value of *ALL. The database statistics job is always running. Setting the system value to *NONE suspends the collector job. When you change the system value to *ALL, the collector job wakes up and any outstanding statistic requests are

…

Don’t Let SQL Name Your Baby, Take 2

March 5, 2008 Hey, Ted

Don’t Let SQL Name Your Baby gave some good advice on tackling the problems created by column names longer than 10 characters. Table names of more than 10 characters can also cause problems, especially if you need to add the same table on multiple systems. Plus, if you want to do updates in an RPG program, it’s nice to have a record format name different from the table name.

–Tim

Tim points out another discrepancy between the System i’s QSYS.LIB file system and relational databases that run on other systems. Using SQL, you can create a table with a very

…

Admin Alert: When System i Ethernet Cards Stop Broadcasting

March 5, 2008 Joe Hertvik

Twice recently my shop ran into an interesting problem with System i Ethernet cards. We were migrating Ethernet line descriptions from one system to another and even though the source system was in restricted mode, the target Ethernet card refused to work correctly until the source system card was unplugged from the network. Here’s what happened and what it teaches us about how System i Ethernet cards work.

Why Migrate Line Descriptions?

Because this situation deals with conflicts caused by migrating configurations, let’s first look at why people migrate Ethernet line descriptions between systems. I can think of three separate

…

XAMPP: The PHP Developer’s Dream

February 27, 2008 Brian Kelly

This is the final installment in a series of four articles by Brian Kelly on PHP.

Regardless of whether your production server is a System i or a System p, or if you run x-Series servers, z-series mainframes, Solaris, or HP, your dream development machine for building dynamic PHP applications needs to have XAMPP from Apache Friends. XAMPP is a phenomenal integration package for the development components that just about every modern day Web developer requires, regardless of platform they work on.

The “X” in XAMPP stands for “operating system.” The rest of the acronym is: Apache, MySQL, PHP, and

…

Programmatically Retrieve Defined System i Names

February 27, 2008 Michael Sansoterra

In recent tips, I have discussed some of the useful client side tools that IBM has given to developers in the iSeries Access programmer’s toolkit for Windows. In this tip, I’d like to discuss how a Windows script or program can access all of the system names defined within iSeries Navigator (soon to be renamed System i Navigator).

In these days of multiple System i systems and LPARs, it is increasingly common to see multiple systems defined within iSeries Navigator. There are several scenarios where it would be useful to harvest this information for use within a program.

For example,

…

Admin Alert: Five Minutes to Moving System i Objects Between Partitions

February 27, 2008 Joe Hertvik

Administrators in multiple System i environments are frequently called upon to save and restore files from one i5/OS machine to another. Because you may not always remember the exact steps involved in performing a transfer, this week I’m presenting a five-minute cheat sheet that details every step you need to perform in order to easily save an object and move it to a companion machine via FTP.

The Basic Game Plan

When moving objects between System i partitions, there are five critical steps that you need to follow.

Creating or clearing an i5/OS save file on the source system
Saving

…

Getting MySQL Working With PHP

February 20, 2008 Brian Kelly

This is the third in a series of four articles by Brian Kelley on PHP.

MySQL is a common open source SQL database management system. It is developed and distributed by MySQL AB, a company that builds its business by providing services around MySQL.

This relational database was first developed for Unix and Linux applications. It became popular when Internet Service Providers found out that MySQL was a relational database that could be offered free of charge to their Internet customers. The MySQL “product” could provide all the storage and retrieval functionality that a dynamic Web application needs.

MySQL

…

LPEX Edit in Hex Mode

February 20, 2008 Hey, Ted

Thanks for your article, Let WDSc Help You Format Your Source Code. Prior to using WDSc, I used a tool to colorize my RPG source code. It applied different colors to various types of lines (comments, loop structures, etc.). LPEX doesn’t seem to be able to understand the hex code and displays box symbols for the hex value. Is there something in the parser controls that will make LPEX recognize the hex value or simply ignore it?

–Eddie

I don’t know if there’s anything in those parser controls that will make LPEX interpret those p-field codes or not, Eddie.

…

Previous Articles Next Articles

Search for: