Tips

Tips

• SQL For Dummies, Fifth Edition -- Chapter 1

  Chapter 1 discusses data storage, how the relational model comparew with other major models, and the important features of relational databases.  Continue Reading

• Are your backups complete?

  No security plan is complete without addressing the issue of safe and complete backups.  Continue Reading

• Proper IFS security setting

  How do you set the IFS security so a manager can access the IFS files from her PC applications but none of the clerks can? Security expert Carol Woodbury has a suggestion.  Continue Reading

• Technical documentation: Pictures worth a thousand words

  Andrew Borts takes a look at how you can use screen shots to improve your technical documentation after you modify a program.  Continue Reading

• The ins and outs of journaling -- Part III

  A benefit of using journaling to protect against data loss is that it uses a lot less disk space than mirroring, as it protects only files. However, that's also its disadvantage. In this tip Ron Turull shows you how to use a journal for disaster ...  Continue Reading

• Learn which JobQ an active job is running from

  Here's a simple command that helps you determine which JobQ an active job is running from?  Continue Reading

• Using BestFit scaling with PC5250 printer sessions

  Using Client Access printers and having trouble printing 198 columns on one page? This tip may help.  Continue Reading

• Delaying a job by less than a second

  Learn an easy way to poll a file.  Continue Reading

• Encrypt communication between iSeries and desktops

  What do you do when you need to encrypt information flowing between iSeries servers and desktops? Here are a couple ideas.  Continue Reading

• Physical security challenges growing

  Some basics steps to take to make sure your system is physically secure.  Continue Reading

• Check objects in directories other than QDLS

  Here's an alternative method to check for objects.  Continue Reading

• WebSphere for beginners

  It's not uncommon for the learning curve for WebSphere to be large. There is, however, a tool that eliminates the complexity of WebSphere development.  Continue Reading

• The ins and outs of journaling -- Part II

  Once the system starts journaling a file, it starts writing journal entries to the associated journal receiver. Eventually, journal receivers fill up. What do you do then?  Continue Reading

• Tapping WRKSYSACT to collect performance data

  What you may not know about WRKSYSACT is that you can run the command in batch to collect data about how well your system is performing.  Continue Reading

• The wonders of Display Query (DSPQRY)

  The DSPQRY command displays the queries sorted by descending date/time.  Continue Reading

• Sample code: Accessing MS SQL Server database from the iSeries

  Nowadays with the help of Java the iSeries can be integrated with other databases quite easy. This tip shows you how.  Continue Reading

• Better than QRWOPTIONS

  This program allows you to decide if you want to log, dump, or use a QAQQINI file for a job.  Continue Reading

• Checking IFS security

  How to check the security configurations of non-native file systems in OS/400.  Continue Reading

• Find the programs that use a particular file using DSPPGMREF

  No matter how well you plan the design of a database file, it will eventually need to be changed.  Continue Reading

• FTP an Out File without using a *SAVF

  An ITKE member recently had a question on FTPing a Out File without using a *SAVF, and ITKE members jumped in to helped out. Here is a portion of the conversation.  Continue Reading

• Options for accepting or declining rescheduled meetings

  An ITKE member was seeking an option for accepting rescheduled meetings. Thankfully, fellow iSeries gurus jumped in on the tread to help out. Here's a portion of the conversation.  Continue Reading

• The ins and outs of journaling -- Part I

  Ron Turull discusses what journaling is, how it works and the four basic journal categories.  Continue Reading

• Set your iSeries to synchronize time with the U.S Naval Observatory

  Set your iSeries to synchronize time with the U.S Naval Observatory by using the iSeries command CHGNTPA.  Continue Reading

• Know where your spooled files are going

  Learn how printer reports end up in different areas, and how to designate exactly where they end up.  Continue Reading

• Why DB2 is better than VSAM

  Why DB2 and why not VSAM? This article aims at answering this query and provides sufficient information that would let the designer take the right decision.  Continue Reading

• Accessing MS SQL Server database from the iSeries

  An ITKE member recently was looking for some information on the best way to execute a SQL statement on the iSeries. Fellow iSeries users offered advice.  Continue Reading

• Securing query definitions

  A better way of granting users access to query definitions.  Continue Reading

• Things to watch out for when auditing IFS objects

  What do you do if you need to audit an object in the IFS? iSeries security expert Carol Woodbury shows you.  Continue Reading

• Simple object control

  Here's a code to run a display file description of all the files on your system and put the results into a file. file.  Continue Reading

• Find and Replace in a string

  Learn an easier way to insert the parameters in the submit string.  Continue Reading

• Deleting PC files on the iSeries

  An ITKnowledge Exchange(ITKE) recently member had a question about deleting PC files on the iSeries, and fellow techies jumped in on the conversation and helped out.  Continue Reading

• SQL for eServer i5 and iSeries -- Chapter 2

  Learn how to use the SQL scripting tool included in iSeries Navigator.  Continue Reading

• Write results of SQL Select statement to an outfile

  Outfiles are status quo on the iSeries, but did you know that SQL can produce them intrinsically? Ron Turull shows you how.  Continue Reading

• Quickly copy any source member from one iSeries to another

  A second option for copying an RPG or CL source member from one iSeries to another.  Continue Reading

• Evaluating change management software

  An ITKnowledge Exchange member recently inquired about solutions for iSeries, WDSC & WebSphere running on Linux on PCs. Other techies jumped in to offer some advice.  Continue Reading

• Connect the dots: Get your iSeries servers talking to one another

  Need to transfer information from one iSeries to another? OS/400 has a tool -- Opti-Connect -- built right in that makes transfers easy and fast.  Continue Reading

• V5R3 view disk IOA cache battery expiration

  Prevent dead batteries with V5R3's view disk IOA cache battery expiration.  Continue Reading

• How to encapsulate SNA over TCP

  Learn how to encapsulate SNA over TCP so you can use the old SNA commands such as SAVRST*.  Continue Reading

• Are you using Authority Holders?

  With an Authority Holder in place, you can pre-set how *PUBLIC authority will be granted when a physical file is created on your system.  Continue Reading

• Utility helps you determine the status of PTFs on your system quickly

  Ron Turull has created a utility that eases the task of determining if a particular PTF has been applied.  Continue Reading

• Accessing iSeries files from within an Oracle application

  Keep your eyes open when accessing iSeries files from within an Oracle application.  Continue Reading

• Use SQL views to transfer packed data using FTP

  Here's an easy way to transfer packed data from an iSeries to an ASCII system.  Continue Reading

• Using NFS to create image catalog entries

  Install cumulative PTFs by using image catalogs.  Continue Reading

• How does RPG talk to a browser?

  Using your existing RPG skills and a little knowledge of HTML, you can be programming for the Web in no time.  Continue Reading

• Illustration of multithreading in the iSeries

  Learn how multithreading is a general purpose programming technique that reduces the complexity and overhead of concurrent programming.  Continue Reading

• Client Access Express password cache

  Stop that darn pop-up window from appearing when you're trying to connect to Client Access.  Continue Reading

• Security Tools can help manage your system security

  You don't need to look far for tools to manage your system's security. Included in your iSeries is a generous set of utilities that can help you.  Continue Reading

• Identify files used in all queries

  Identify files used in all queries in a library, library list or ALLUSR.  Continue Reading

• How to generate reports using stored procedures

  Third-party reporting tools aren't always the best option when generating reports from data on several types of databases. External stored procedures can do a better job.  Continue Reading

• Restoring Client Access Excel Data Transfer Add-In

  Learn how to restore Client Access Excel Data Transfer Add-In.  Continue Reading

• Check constraint allows database admins to sleep a bit better at night

  You can easily prevent errant programs from writing invalid data to a field with a simple constraint.  Continue Reading

• Tips for i5 eServer Hardware Management Console (HMC)

  Allyn Walsh answers user's questions regarding Hardware Management Console (HMC).  Continue Reading

• Watch your profiles

  How to monitor changes to user profiles.  Continue Reading

• The ins and outs of using constraints

  Paul Tuohy take a closer look at constraints, what they are and how you define them.  Continue Reading

• Send message to users at a remote site

  Learn how you can send messages to a user who is at a remote site.  Continue Reading

• iSeries calling an .exe

  From a CL, you can call the Windows standard calculator program.  Continue Reading

• How to take advantage of DSM -- even in a non-ILE shop

  Ron Turull provides a "helper" program to let you save and restore the screen using two DSM APIs from a non-ILE program.  Continue Reading

• Use the i5/OS Networking Quality of Service monitor to look at your system's bandwidth usage

  Learn how to set up a simple policy to monitor your network.  Continue Reading

• Formatted work job scheduler

  Learn more about the formatted job scheduler report using API QWCLSCDE.  Continue Reading

• QUPSDLYTIM system value

  Carefully calculate the QUPSDLYTIM system value setting.  Continue Reading

• How to save, restore the screen -- the quick and easy way

  This time we turn our attention to a couple of DSM APIs that can be used to take a "snapshot" of the screen, save it and restore it later using the saved data.  Continue Reading

• Mixing free format code with embedded SQL

  Here's a neat trick to try when mixing free format code with embedded so you don't have to use the /end-free before each SQL code.  Continue Reading

• Create an iSeries Access image and update it with the latest Service Pack

  There's an easy way to create an iSeries Access image that can be used for PC-Client installations and to load the latest Service Pack on to.  Continue Reading

• SQL update a field in one file from a field in another file

  You can easily update a field in one file with SQL by using a field in another file where unique field matching is possible.  Continue Reading

• Automate programming tasks

  Learn how to create programming tools that you can use to create sections of code.  Continue Reading

• Easy code copying via the drag and drop method

  Learn haow code copying can be a lot easier using the drag and drop method.  Continue Reading

• The best place to put your e-business workload

  There are two options for running your e-business workloads in an average iSeries shop: upgrade your existing iSeries server or buy a new front-end server. Find out which is best.  Continue Reading

• Easy way to compile my RPG programs

  These CL programs help you to compile an RPG III or ILE RPG program by putting the necessary commands into your RPG code.  Continue Reading

• Setting FTP time-outs

  We know about the inactivity time-out on the FTP server. But there are three other time-outs that can be set, one for the iSeries FTP server, and two for the iSeries FTP client.  Continue Reading

• Tracking use of critical files/objects

  How to set up access tracking of critical files with security auditing.  Continue Reading

• Dynamic Screen Manager lets you build screens and windows on the fly

  Want to do something with a display file but can't seem to get DDS to do it? Try Dynamic Screen Manager.  Continue Reading

• Backing up a database with split mirroring

  This article discusses a popular alternative to creating and maintaining backup images of DB2 databases known as a split mirror.  Continue Reading

• Web Menu security integrates with RPG apps

  Jim Mason shows you how to build a Web menu system that delivers user authentication and integration with back-end applications.  Continue Reading

• RPG documentation made easy

  Using a simple Client Access data transfer you can select which lines from a RPG source send to a *.txt file in order to document it.  Continue Reading

• SQL vs. DDS -- The good, the bad and the downright ugly

  What does DDL offer over DDS and vice versa? Let's take a look.  Continue Reading

• Easy code copying the EDTF way

  It is possible to copy directly from the integrated file system.  Continue Reading

• Message monitor for security events

  How to monitor security logs in real time.  Continue Reading

• How to save time using the CPYTOPCD and CPYFRMPCD commands

  Learn how to get the most out of the Copy To PC Document (CPYTOPCD) and the Copy From PC Document (CPYFRMPCD) commands.  Continue Reading

• Logging strategies

  Two very different logging strategies--circular logging and archival logging--are available in DB2. But a hybrid method called infinite active logging might work best.  Continue Reading

• Copy text to SRCMBR

  If you have a CL program in a text file on your PC, you can send this text to SCRMBR of QCLSRC and have the program ready.  Continue Reading

• Top Q&A's on the OS/400

  View top expert advice on OS/400.  Continue Reading

• Build Web apps using free utility -- WOW!

  Learn how to use Web Object Wizard (WOW) to build a Web application that accesses iSeries data in fewer than 15 minutes.  Continue Reading

• Quickly copy an RPG or CL source member from one iSeries to another

  Copying an RPG or CL program source from a remote iSeries into the iSeries you are currently on can be achieved using several ways. This tip review one of them.  Continue Reading

• Debug value of pointer

  See what the pointer is pointing to when debugging ILE RPG.  Continue Reading

• The Lazy Coder talks about highlighting your code

  Can't tell the difference between your comments and your program? It's time to highlight some of it.  Continue Reading

• Your built-in security consultant - Free of charge

  A built in wizard can act as your iSeries security consultant.  Continue Reading

• How to set up an autostart job

  What do you do when you want a program to run automatically only when a specific subsystem is started? Attach an autostart job entry to the subsystem.  Continue Reading

• Use caution when providing access to file shares

  Although file shares are a convenient way to share data throughout a company, defining shares can create serious security exposures if OS/400 object authority hasn't been utilized.  Continue Reading

• Easy code copying -- without CODE400

  Try this method of copying code to make your life a little easier.  Continue Reading

• Take control of Query

  Create your own version of the WRKQRY command that allows you to determine how much time should be allotted for interactive queries.  Continue Reading

• Add HEX key to PC5250

  iSeries Access PC5250 keyboard does not have the Hex key that the old 5250 keyboard did. Assign this script to a key to get this function back.  Continue Reading

• The CHGSYSJOB command lets you configure system jobs

  Using the Change System Job command (CHGSYSJOB) you can change the run priority of some system jobs.  Continue Reading

• Automated disaster recovery revisited

  Security expert Rich Loeber updates a past tip on automating disaster recovery for new versions of OS/400.  Continue Reading

• Generic trigger program to capture create/change date and time

  Instead of adding code to several programs to track data record changes, this program can be added to any physical file to track changes from any source.  Continue Reading

• Easy code copying ... without CODE400

  Copy any Web source code in an iSeries source file in five steps.  Continue Reading

• Top Expert Advice on Managing your iSeries

  Systems management Glen Bunnell offers expert advice to Search400.com members.  Continue Reading

• How to use the ILE debugger to display the value of a variable in hexadecimal format

  Ron Turull looks at why hexadecimal formatting is often necessary.  Continue Reading

• Using files with multiple members in SQL or ODBC

  Working in SQL and ODBC with specific members in files with multiple members? Here's a helpful tip to make it a little easier when problems occur.  Continue Reading

• Quick view contents of a data file

  Use this command to view the contents of a data file.  Continue Reading

• Find duplicate records in a file

  Find duplicates files in SQL statements.  Continue Reading