Reader Feedback and Insights: Thanks for the Information

October 30, 2002 Timothy Prickett Morgan

Hey, Ted:

I receive tons of emails and delete most without even opening them, but I always find time to read your questions and answers in Midrange Guru, OS/400 Edition.

Thanks for the information, and keep it coming.

— Bob

Sponsored By ADVANCED SYSTEMS CONCEPTS

Business Analytics – Practical – – Cost Effective – – Easy to Deploy – SEQUEL FYI User Quote: “I love SEQUEL FYI because it lets me look at the data any way I need to see it, instantly. This is the easiest tool to manage complex product relationships that I have ever seen.” SEQUEL FYI

Get a Hex Dump of

October 30, 2002 Timothy Prickett Morgan

Dear Readers:

Today’s tip proves the old saying, “There’s more than one way to skin a cat.” Here’s another way to view any database file member or IFS file in hexadecimal.

— Ted

CL’s Display File (DSPF) command displays any IFS file or database file member.

To display an IFS file, use the STMF parameter:

DSPF STMF('/home/mydir/mydata.dat')

Press F10 to see the file in hexadecimal.

You can specify a path name and/or wildcard characters in the STMF parameter.

In that case, DSPF provides a list of files from which you can choose.

This command lists all files and directories in

SQL’s One-Row, One-Column Table

October 30, 2002 Timothy Prickett Morgan

Hey, Ted:

In the October 25 Midrange Guru article, “SQL to the Rescue!“, a reader named Jeff provides an example that requires a file with one record. IBM provides such a file for just that purpose:

It’s called QSQPTABL.

— Yannick

Thanks for the information, Yannick. QSQPTABL is in library QSYS2. It has one column (field), which is a four-byte integer field called INTCOL (INTEGER_COLUMN). The only row in the table has the value 1.

It occurred to me that this technique is probably worth further exploration. SQL has a rich set of scalar functions, and IBM adds