Difference between revisions of "Qshell - Utilities"

From MidrangeWiki
Jump to: navigation, search
Line 15: Line 15:
  
 
This will not work correctly when displaying data for fields which has numeric or date values.
 
This will not work correctly when displaying data for fields which has numeric or date values.
 +
 +
 +
 +
==Select records from within QSHELL using db2==
 +
The db2 utility allows you select records from database files, from within QSHELL.  See this [http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahz/rzahzdb2utility.htm link] for the IBM explanation.
 +
 +
====db2 Example====
 +
This utility will allow you to select different type of fields, and display the data on the console:
 +
 +
db2 "select * from libname.filename where xxx = 'yyy'"

Revision as of 10:36, 11 August 2009

Background

A large number of utilities exist under Qshell which will make your live considerably easier. This write-up will help to highlight some of the hidden gems that exist under QShell.


Read or write record files - rfile

This Qshell utility reads record (database and device) files, and displays it to standard output, or reads information from standard input, and write the data to record files. See this link for the IBM explanation.


RFile Example - Alternative to CPYTOIMPF

If you have a plaintext file with a single field, that you want to copy to the IFS, the following will be easy to use:

rfile -rlQ LIBNAME/FILENAME > /tmp/filename.txt

This will not work correctly when displaying data for fields which has numeric or date values.


Select records from within QSHELL using db2

The db2 utility allows you select records from database files, from within QSHELL. See this link for the IBM explanation.

db2 Example

This utility will allow you to select different type of fields, and display the data on the console:

db2 "select * from libname.filename where xxx = 'yyy'"