 |
Midrange Guru, OS/400 Edition, is the
first in a series of new technical tips newsletters that Midrange
Server, Inc., is putting together to serve the needs of the diverse
midrange environment.
|
|
February 7, 2003 |
| Odds and Ends |
| V5 and Trigger Programs |
| Reader Feedback and Insights: Character to Numeric |
| |
|
February 5, 2003 |
| Real Date to JD Edwards Date as a UDF |
| Alpha to Numeric with Query/400 |
| Reader Feedback and Insights: SBMJOB's RQSDTA Parameter |
| |
|
January 29, 2003 |
| Converting Alpha to Numeric |
| Retrieve Qshell Exit Status in CL Programs |
| Reader Feedback and Insights: Effective Communication |
| |
|
January 24, 2003 |
| Effective Communication, Part II |
| Type2 IFS Directories and Domino |
| Reader Feedback and Insights: Native Awk |
| |
|
January 22, 2003 |
| Effective Communication, Part I |
| More About Qshell's db2 Command |
| Reader Feedback and Insights: Calling RPG Subprocedures from CL |
| |
|
January 17, 2003 |
| A More Perfect Union |
| Which Commands Can Build Outfiles? |
| Reader Feedback and Insights: Faster Grep |
| |
|
January 15, 2003 |
| Dropping Procedures |
| Running Awk |
| Reader Feedback and Insights: More about Dumping IFS Files |
| |
|
January 10, 2003 |
| Call RPG Subprocedures from CL |
| Predicting Bad Query Performance |
| Reader Feedback and Insights: Another Vote for ISDB |
| |
|
December 18, 2002 |
| Debugging Java Script |
| Make Qshell Clean Up After Itself |
| Reader Feedback and Insights: Your System/36 Information is Very Helpful |
| |
|
December 13, 2002 |
| Ensuring Valid XML Content |
| Spacing between Concatenated Strings |
| Reader Feedback and Insights: RPG Compiler Directives and V4 |
| |
|
December 11, 2002 |
| Subfile Positioning |
| Readers Prefer ISDB |
| Reader Feedback and Insights: SBMJOB's RQSDTA Parameter |
| |
|
December 6, 2002 |
| Get Rid of Old IFS Files, Take Two |
| Performance of the SQL LIKE Predicate |
| Reader Feedback and Insights: One-Row Table Still Needed |
| |
|
December 4, 2002 |
| Protecting HTML Page Elements with JavaScript and CSS |
| LIKE is Like, Confusing, Man! |
| Reader Feedback and Insights: RPG II |
| |
|
November 20, 2002 |
| V5R1 Storage Model Mismatch |
| Get Rid of Old IFS Files |
| Reader Feedback and Insights: Thanks for Qshell Tips |
| |
|
November 15, 2002 |
| Access the Database from Qshell |
| Data Structure Parameters in RPG Prototypes |
| Reader Feedback and Insights: Indicators in RPG II Programs |
| |
|
November 13, 2002 |
| Using Grep to Search Source Physical Files |
| Compiler Directives for RPG Programs and Modules |
| Reader Feedback and Insights: Modernizing RPG II Programs |
| |
|
November 8, 2002 |
| Odds and Ends |
| Omitting Parameters in RPG Programs and Modules |
| Reader Feedback and Insights: Overlooking the Obvious |
| |
|
November 6, 2002 |
| Going From a True Date to a JDE Date |
| Use the Full-Screen Debugger with OPM Programs |
| Reader Feedback and Insights: We Want More RPG |
| |
|
November 1, 2002 |
| Help with RPG II Programs |
| You Can't Get There From Here |
| Reader Feedback and Insights: Not All Hex Dumps Are Created Equal |
| |
|
October 30, 2002 |
| Get a Hex Dump of Any File |
| SQL's One-Row, One-Column Table |
| Reader Feedback and Insights: Thanks for the Information |
| |
|
October 25, 2002 |
| Another Way to Dump an IFS File |
| Johnny Can't Read and RPG Can't Do Math |
| Reader Feedback and Insights: SQL to the Rescue! |
| |
|
October 23, 2002 |
| A Simple Guide to jar |
| Type2 IFS Directories |
| Reader Feedback and Insights: Extending the Network |
| |
|
October 18, 2002 |
| Reading Spool Files in RPG |
| Hex Dump of an IFS File |
| Reader Feedback and Insights: Another Compression Utility |
| |
|
October 16, 2002 |
| Sorting Lists in Java |
| Extending the Network |
| Reader Feedback and Insights: Dynamic Result Field in Query/400 |
| |
|
October 11, 2002 |
| Odds and Ends |
| Client Access Hotspots |
| Reader Feedback and Insights: Dynamic Result Field in Query/400 |
| |
|
October 9, 2002 |
| FTP and Save Files, Yet Again! |
| Using API's to Send Impromptu Messages |
| Reader Feedback and Insights: QTEMP and the Library List |
| |
|
October 4, 2002 |
| Find the Cursor Position in a CL Program |
| David's Choice for Java Error Logging |
| Reader Feedback and Insights: A Timely OPNQRYF Tip |
| |
|
October 2, 2002 |
| FTP and Save Files |
| When Good Batch FTP Users Go Bad |
| Reader Feedback and Insights: Displaying Menu Options |
| |
|
September 27, 2002 |
| Loading a Tilde-Delimited File into the Database |
| Find the Cursor Position in a CL Program |
| Reader Feedback and Insights: Midrange Guru Articles Helpful |
| |
|
September 25, 2002 |
| FTP'ing a Library |
| OPNQRYF Date Arithmetic |
| Reader Feedback and Insights: Displaying Menu Options |
| |
|
September 20, 2002 |
| Comparing Lists of Numbers to a Value |
| JD Edwards Dates, Revisited |
| Reader Feedback and Insights: Thanks for the Tips |
| |
|
September 18, 2002 |
| Odds and Ends |
| Is It a Different 'Hello World' in OS/400 V5R1? |
| Reader Feedback and Insights: More Binder Language |
| |
|
September 13, 2002 |
| Put Users On the Fast Track |
| Properly Sorting Numeric Arrays |
| Reader Feedback and Insights: Binder Language |
| |
|
September 11, 2002 |
| Excuse Me...Can You Hold this Secondary Partition While I Upgrade the Primary? |
| Adding Subprocedures to a Service Program, Revisited |
| Reader Feedback and Insights: Security Flaws |
| |
|
September 6, 2002 |
| Convert J.D. Edwards Dates to Other Formats |
| Edit with Parentheses in Query/400, Take Two |
| Reader Feedback and Insights: Copying Records in RPG |
| |
|
September 4, 2002 |
| Starting the Host Database Server Daemon After an OS/400 V5R1 Upgrade |
| Parameterized RUNSQLSTM with Two or More Substitutions |
| Reader Feedback and Insights: Odds and Ends Always Popular |
| |
|
August 30, 2002 |
| Adding Subprocedures to a Service Program |
| A Fuzzy Search Algorithm |
| Reader Feedback and Insights: Splitting a Qshell Variable |
| |
|
August 28, 2002 |
| A CPYF Idiosyncrasy Revisited |
| Edit with Parentheses in Query/400 |
| Reader Feedback and Insights: Timestamps and V5R1 RPG |
| |
|
August 23, 2002 |
| Use Monitor to Trap QCMDEXC Errors |
| Odds and Ends |
| Reader Feedback and Insights: More on TCP/IP Printing |
| |
|
August 21, 2002 |
| Debugging Java in Eclipse |
| Validating a User Password |
| Reader Feedback and Insights: OPNQRYF Bug |
| |
|
August 16, 2002 |
| Calling a Program From a UDF |
| Creating HTML Subfiles |
| Reader Feedback and Insights: Confirm File Deletions in Qshell |
| |
|
August 14, 2002 |
| Make an SQL UDF Return Null |
| SQL Functions for Mashing Characters |
| Reader Feedback and Insights: Using Timestamps as Unique Keys |
| |
|
August 9, 2002 |
| Default Connection for CAE Users |
| Date and Time Functions in V5R1 RPG |
| Reader Feedback and Insights: TCP/IP Printing Problem |
| |
|
August 7, 2002 |
| Splitting a Qshell Variable |
| Tell PC5250 to Stop Bugging Me about My Password |
| Reader Feedback and Insights: Valuable Newsletters |
| |
|
August 2, 2002 |
| Looking for Number Two |
| Confirm File Deletions in Qshell |
| Reader Feedback and Insights: Free Software From Kisco |
| |
|
July 31, 2002 |
| SQL Understands Microseconds |
| Changing Languages on a 5250 Screen |
| Reader Feedback and Insights: Retrieving Query Definitions |
| |
|
July 26, 2002 |
| Restore a Single IFS Directory |
| Sending Escape Messages From RPG |
| Reader Feedback and Insights: Generating a Unique Identifier |
| |
|
July 24, 2002 |
| Three Ways to Direct OS/400 Output Queues to TCP/IP Printers |
| Did OPNQRYF Retrieve Records? |
| Reader Feedback and Insights: Scheduling a Job to Run More than Once a Day |
| |
|
July 19, 2002 |
| Odds and Ends |
| Populating JavaBeans From Database Values |
| Reader Feedback and Insights: Deleting a Badly Named IFS File |
| |
|
July 17, 2002 |
| SQL and System/36 File Names |
| Using Timestamps as Unique Keys |
| Reader Feedback and Insights: Dealing with Record Locks |
| |
|
July 12, 2002 |
| Setting TCP/IP Server Autostart Parameters as a Group |
| Scheduling a Job to Run More than Once a Day |
| Reader Feedback and Insights: Service Program Catch-22 Simplified |
| |
|
July 10, 2002 |
| Use Query/400 to Find IFS Files in BRMS |
| Delete Badly Named OS/400 IFS Files, Take Two |
| Reader Feedback and Insights: Avoiding Object Locks |
| |
|
June 28, 2002 |
| Easy Subfile Windowing |
| Distinct File and Record Names with SQL |
| Reader Feedback and Insights: Determining Whether a User Is Already Signed On, Take Three |
| |
|
June 26, 2002 |
| Connection Pooling with Tomcat |
| Service Program Catch-22 |
| Reader Feedback and Insights: Searching Message Text |
| |
|
June 21, 2002 |
| Determining Whether a User Is Already Signed On, Take Two |
| Parameterized RUNSQLSTM |
| Reader Feedback and Insights: RPG II |
| |
|
June 19, 2002 |
| Tracing a Qshell Variable |
| LAYOUT: An Improved DSPFFD |
| Reader Feedback and Insights: String Parameters of Various Lengths |
| |
|
June 14, 2002 |
| String Parameters of Various Lengths, Take Three |
| Determining Whether a User Is Already Signed On, Take Three |
| Reader Feedback and Insights: Group Job Limitation |
| |
|
June 12, 2002 |
| String Parameters of Various Lengths, Take Two |
| Build SQL to Define Your Existing Files, Revisited |
| Reader Feedback and Insights: Printing Leading Zeros in Query/400, Another Look |
| |
|
June 7, 2002 |
| How Does OS/400 FTP Determine Working Directories? |
| Searching the Information Center |
| Reader Feedback and Insights: Printing Leading Zeros with Query/400 |
| |
|
June 5, 2002 |
| Build SQL to Define Your Existing Files |
| Making PC5250 Look like a Dumb Terminal |
| Reader Feedback and Insights: Proper Use of QTEMP |
| |
|
May 31, 2002 |
| Odds and Ends |
| Using Library Lists for JDBC File Access |
| Reader Feedback and Insights: A Better Way to Get Query/400 Definitions? |
| |
|
May 29, 2002 |
| String Parameters of Various Lengths |
| Prevent Someone Else From Peeking at Your Windows 2000/XP System |
| Reader Feedback and Insights: Suggestions for a Temporary Library |
| |
|
May 24, 2002 |
| Creating a User-Defined Function to Convert Legacy Dates |
| CRTDUPOBJ and the Library List |
| Reader Feedback and Insights: Repetitive Compiler Options |
| |
|
May 22, 2002 |
| Print Query Definitions From a Batch Job |
| You Can Re-IPL an AS/400 into Restricted State |
| Reader Feedback and Insights: I Didn't Know You Could Do That |
| |
|
May 17, 2002 |
| Avoiding Split of a File Name Containing Blanks |
| Odds and Ends |
| Reader Feedback and Insights: OV/400 Data Text Merge |
| |
|
May 15, 2002 |
| Client Access and Windows Compatibility |
| Delete Badly Named OS/400 IFS Files |
| Reader Feedback and Insights: Converting OV/400 Documents to Microsoft Word |
| |
|
May 10, 2002 |
| Table-Driven Programming |
| Automatically Hold Large Reports |
| Reader Feedback and Insights: CSV and SQL Utilities From a Reader |
| |
|
May 8, 2002 |
| EDTF Sizes Up OS/400 IFS Directories |
| Convert OV/400 Documents to MS Word for Free |
| Reader Feedback and Insights: Another Way to Check the Call Stack |
| |
|
May 3, 2002 |
| Enter the Vector, Victor! |
| Stupid Parameter Tricks |
| Reader Feedback and Insights: Spend Money to Save Money |
| |
|
May 1, 2002 |
| Changing Link Styles with CSS |
| Legacy Dates to SQL Dates |
| Reader Feedback and Insights: Old Is Not Bad |
| |
|
April 26, 2002 |
| Common Table Expressions Make Summarizing Data Easy |
| Windows Power Settings Might Disconnect Ops Console |
| Reader Feedback and Insights: Book Recommendation |
| |
|
April 24, 2002 |
| Looking at another Job's Temporary Objects |
| Handling Break Messages Revisited |
| Reader Feedback and Insights: Get with the Times |
| |
|
April 19, 2002 |
| Reducing Sign-On Screen Clutter |
| Qshell vs. DOS |
| Reader Feedback and Insights: Good Content |
| |
|
April 17, 2002 |
| Installing the 1.3 Java Development Kit |
| Show Current Directory in Qshell Prompt |
| Reader Feedback and Insights: We Still Use the 'Old' Stuff |
| |
|
April 12, 2002 |
| Checking the Call Stack |
| Odds and Ends |
| Reader Feedback and Insights: Refreshing STRCPYSCN |
| |
|
April 10, 2002 |
| Avoiding a Sign-On with Java |
| CLRPFM for the IFS |
| Reader Feedback and Insights: Ad-Hoc SQL and Linux |
| |
|
April 5, 2002 |
| One Way to Ease Conversion of RPG II Programs |
| Odds and Ends |
| Reader Feedback and Insights: Query Management and MBROPT(*UPDADD) |
| |
|
April 3, 2002 |
| Dynamic Result Field in Query/400 |
| It Looks Bad, but V5R1 Express Error is Harmless |
| Reader Feedback and Insights: Quotation Marks Work in Pairs |
| |
|
March 29, 2002 |
| More Qshell Output in ASCII |
| Odds and Ends |
| Reader Feedback and Insights: Remote Software |
| |
|
March 27, 2002 |
| Query Management and File Updates |
| Does This Date Fit IBM's Window? |
| Reader Feedback and Insights: Passive FTP and Data Area QTMFTPPASV |
| |
|
March 22, 2002 |
| Client Access Transfers Linefeed-Terminated Data |
| Wanted: Qshell Output in ASCII |
| Reader Feedback and Insights: You Don't Have to Roll Your Own |
| |
|
March 20, 2002 |
| OPNQRYF and Quotation Marks |
| Getting to the Information Center URLs |
| Reader Feedback and Insights: Checking for a Mounted Tape |
| |
|
March 15, 2002 |
| The V5R1 Client Access Licensing Configuration People Miss |
| Remote Control of a Terminal Session |
| Reader Feedback and Insights: We Like Odds and Ends! |
| |
|
March 13, 2002 |
| Native Graphics, VNC, and Perl |
| Keep Trailing Blanks on FTP Transfer From PC Client |
| Reader Feedback and Insights: Passive Mode and OS/400 FTP? |
| |
|
March 8, 2002 |
| Edit Code X Converts Numeric to Alpha |
| Odds and Ends |
| Reader Feedback and Insights: Page 1 of X |
| |
|
March 6, 2002 |
| Global Substitution in OS/400 IFS Files |
| Display Break Messages on the Bottom Line |
| Reader Feedback and Insights: We Don't Like Ops Console |
| |
|
March 1, 2002 |
| Extracting Packed Decimal Data From a List |
| Send Large E-mails in One Piece |
| Reader Feedback and Insights: CPF9897 and CPF9898 |
| |
|
February 27, 2002 |
| More than One Way to Skin a Cat |
| Page 1 of X |
| Reader Feedback and Insights: Status Messages May Degrade Performance |
| |
|
February 22, 2002 |
| find and grep Performance Issues |
| FTP and Numeric Data |
| Reader Feedback and Insights: Returning a Value From a Prototyped Call |
| |
|
February 20, 2002 |
| Setting Up Views Optimized for Crystal Reports |
| Why Doesn't iSeries Ops Console Work? |
| Reader Feedback and Insights: Remote Sign-On Problem—A Look at Another Solution |
| |
|
February 15, 2002 |
| Compiling Multiple Java Programs |
| Finding Your Libraries and Tables with Crystal Reports |
| Reader Feedback and Insights: Another Solution to the Remote Sign-On Problem |
| |
|
February 13, 2002 |
| A JavaScript Version of /COPY |
| SQL and Multi-Member Files |
| Reader Feedback and Insights: Keeping Users Informed |
| |
|
February 8, 2002 |
| Boosting Java Performance |
| Visual Basic and S/36 Files |
| Reader Feedback and Insights: Journaling Data Areas and Data Queues |
| |
|
February 6, 2002 |
| Start QINTER Remotely |
| Keeping Users Informed |
| Reader Feedback and Insights: More Information about CWBLM0020 |
| |
|
February 1, 2002 |
| Getting Past *ALLOBJ Authority |
| It's Hard to Find Hard Links |
| Reader Feedback and Insights: Journaling Changed Bytes Only |
| |
|
January 30, 2002 |
Journaling Changed Bytes Only
|
|
Retrieve a Spool File Number
|
| Reader Feedback and Insights: RPG Prototypes and /COPY Members |
| |
|
January 25, 2002 |
Debugging an SQL User-defined Function
|
|
Where's My PC5250 Sign-On?
|
| Reader Feedback and Insights: Appreciation for Crystal Reports Solution |
| |
|
January 23, 2002 |
SQL Replace Function, Take Two
|
|
A CPYF Idiosyncrasy
|
| Reader Feedback and Insights: Choosing a Linux Distribution |
| |
|
January 18, 2002 |
Determine WebSphere Service Pack Level |
|
Avoiding Record Locks in RPG
|
| Reader Feedback and Insights: Appreciation for Perl Information |
| |
|
January 16, 2002 |
Retrieve Subtotals and Detail Data at the Same Time |
|
Somebody's Got My Report!
|
|
| |
|
January
11, 2002 |
Grepping It Up |
|
SQL Package Problems Cause ODBC Troubles
|
| Reader Feedback and Insights: Appreciation for SQL Tip |
| |
January
9, 2002 |
| Looking for Strings in the IFS |
| RPG Compiler Directives and SQL |
| Reader Feedback and Insights: Appreciation for HTML Tip |
| |
| December
14, 2001 |
| How Do You Say Midnight in RPG? |
| Fun with SQL Date Math |
| Reader Feedback and Insights: Clarification of "Looking Forward to Monday" Tip |
| |
| December
12, 2001 |
| Removing and Replacing Characters Using SQL |
| Here's the Code |
| Reader Feedback and Insights: RPG Prototypes and SQL |
| |
| December
7, 2001 |
| Looking Forward to Monday |
| CL Date Arithmetic |
| Reader Feedback and Insights: Query/400 and User-defined SQL Functions |
| |
| December
5, 2001 |
| Using Case to Segregate Data |
| Force Queries to Run in Batch |
| Reader Feedback and Insights: Debugging and /COPY |
| |
| November
30, 2001 |
| More on Prototyping *Entry Parameters |
| DSPATR(PC) for CGI Programs |
| Reader Feedback and Insights: Defining Entry Parameters in D Specs |
| |
| November
28, 2001 |
| Remote Sign-On Problem |
| Client Access Toolbar Customization |
| Reader Feedback and Insights: Entry Parameters and D Specs |
| |
| November
21, 2001 |
| Prototyping *ENTRY Parameters, Part II |
| Properly Ordering Grouped SQL Queries |
| Reader Feedback and Insights: Discarding the Output of RUNSQLSTM |
| |
| November
16, 2001 |
| Prototyping *ENTRY Parameters, Part I |
| Where's the Key? |
| Reader Feedback and Insights: Don't Ignore C |
| |
| November
14, 2001 |
| Active and Passive FTP Mode |
| Still More Personal Communications Keyboard Mapping |
| Reader Feedback and Insights: Automatic Reply to Inquiry Messages |
| |
| November
9, 2001 |
| Directing SQL Output to a Database File |
| More Personal Communications Keyboard Mapping |
|
| |
| November
7, 2001 |
| Rules Of Thumb On Program Optimization |
| Dynamic Spool File Names |
|
| |
| November
2, 2001 |
| Frustrated By Field Minus Keys |
| Run CL Commands From Interactive SQL (Revisited) |
|
| |
| October
31, 2001 |
| Creating Flexible Join Files |
| Customizing Keyboards In Personal Communications |
|
| |
| October
26, 2001 |
| How Many Modules Should Be in a Service Program? |
| Changing IPL Default For Applying PTFs |
|
| |
| October
19, 2001 |
| Extracting Packed Data From A Character Field |
| Running Perl On The AS/400 and iSeries |
|
| |
| October
12, 2001 |
| With SQL, Sometimes Less Is More |
| Run CL Commands From Interactive SQL |
|
| |
| October
5, 2001 |
| Avoiding Output From RUNSQLSTM |
| Linux Desktop Environment for iSeries |
|
| |
| September
28, 2001 |
| Removing A Character From A Character Field |
| Which CL Messages Should I Monitor? |
|
| |
| September
21, 2001 |
| Trapping A Canceled RUNQRY Command |
| DSN-Less Connections Using ActiveX Data Object |
|
| |
| August
30, 2001 |
| Removing A Damaged PTF |
| Solving A Crystal Report SQL5001 Error |
|
| |
|
| These documents may be freely and
enthusiastically redistributed by email only in their unedited form.
The Four Hundred and Midrange Guru are registered
trademarks of Guild Companies, Inc. ISSN 1049-7757 IBM, AS/400,
iSeries, OS/400 and eServer are registered trademarks of International
Business Machines Corp. All other product names are trademarked
or copyrighted by their respective holders. |
|
|
