• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • The Better Way to Delete Physical Files

    February 11, 2004 Hey, Ted

    You missed a possible link between two articles in the January 14 issue! The first article is “Why SQL, Why Now,” and the second is “Deleting with a Generic File Name.”

    The missing link is that, if you use SQL (to define your database) and issue the command DROP TABLE, the indexes and logical files are deleted (dropped) also! So that’s one of the many reasons why you should use SQL.

    –Wim

    Thanks for the advice, Wim. Several other readers wrote with similar comments.

    SQL’s DROP TABLE command will indeed drop a physical file and the logical files that

    …

    Read more
  • OS/400 Alert: SSL Certificates

    February 11, 2004 Shannon O'Donnell

    If your shop is one of the thousands using digital certificates to enable secure transactions between your iSeries and users’ browsers, you may have recently experienced a problem with disabled certificate authorities. If not, chances are you will soon. Read on for more details. Also included in this issue is a list of a few of IBM’s recommended fixes for OS/400 licensed programs.

    VERISIGN EXPIRES CERTIFICATE AUTHORITIES

    On January 7, Verisign, a major worldwide provider of digital certificates, experienced a sudden surge in demand for verification of its clients’ certificate authorities. This check is performed by connecting to Verisign’s

    …

    Read more
  • Setting Up an OS/400 HTTP Firewall Using Reverse Proxy

    February 4, 2004 Shannon O'Donnell

    If you are a regular reader of our technical articles, you should already be familiar with how to configure an HTTP Server on your AS/400 and how to serve Web pages. Of course, by exposing your AS/400 to the Internet, you are also increasing the odds that someone will attempt to hack it. One method you can use to secure your OS/400 from hackers is to set up an HTTP reverse proxy server on another AS/400. This article will show you how.

    If you don’t remember how to set up an OS/400 HTTP Server, or how to store and serve

    …

    Read more
  • How Many Records Did SQL Delete?

    February 4, 2004 Hey, Ted

    I have an RPG IV program with an embedded SQL DELETE statement. Is it possible for my program to determine how many records are deleted when the statement executes?

    –Tom

    DB2/400 returns this information to you through a subfield of the SQL communications area (SQLCA), a data area that is automatically included in your RPG program when you compile. You can refer to this subfield by either of two names: SQLERRD(3) or SQLER3. When a DELETE, UPDATE, or INSERT operation completes normally, DB2 updates the subfield with the number of rows that qualified for the operation.

    C/exec sql                              
    C+             delete 
    …

    Read more
  • Recovering from WDSc Errors

    February 4, 2004 Hey, David

    I started using WebSphere Development Studio client (WDSc) a few months ago, and several times I caused it to crash. Twice now, a crash scrambled my Eclipse windows. The first time, I was able to get to the Eclipse update option off the help menu and the update fixed Eclipse. Yesterday, I accidentally double-clicked the WDSc icon in my startup tray and two copies of WDSc started running at once.

    I shut down both copies and everything looked okay, but the next time I ran WDSc several windows were missing elements and contained empty frames with no data. One of

    …

    Read more
  • Admin Alert: Alternate Ways to Ensure a Subsystem Ends

    February 4, 2004 Joe Hertvik

    In “Three Common Mistakes in CL Administration,” I presented a technique for ensuring that a subsystem ends before processing other commands. However, several readers quickly spotted some errors in that technique and wrote in with corrections and suggestions on how to make that routine better.

    To start with, I originally provided the following piece of CL code to end a subsystem, to copy and clear a file that is locked by that subsystem, and then to restart the subsystem:

    ENDSBS SBS(SUB1)
    MONMSG MSGID(CPF0000)
    
    DLYJOB DLY(300)
    
    CPYF   FROMFILE(LIB/CRITICAL) +
              TOFILE(LIB/CRITICALBK) MBROPT(*REPLACE) +
              CRTFILE(*YES)
    MONMSG MSGID(CPF0000)
    
    CLRPFM FILE(LIB/CRITICAL)
    
    STRSBS SBSD(SUB1)
    MONMSG MSGID(CPF0000)
    
    …

    Read more
  • OS/400 Alert: alphaWorks and Homeland Security

    February 4, 2004 Shannon O'Donnell

    In this issue of “OS/400 Alert,” we’ll tell you about some new electronic initiatives from the Department of Homeland Security. We’ll also alert you to some of the cool new tools, betas, trials, and emerging technologies from IBM’s bleeding-edge technology center, alphaWorks. IBM alphaWorks has consistently cranked out exciting new software technology, exceeding the output of any of the other major software skunkwerks anywhere in the world. In fact, many technologies being used today on the iSeries started as prototypes and became demos at alphaWorks.

    NEW HOMELAND SECURITY NEWSLETTERS

    The war on terrorism is about to hit your mailbox–at least

    …

    Read more
  • Application and Data Integration Between Linux and OS/400

    January 28, 2004 Erwin Earley and David Boutcher

    Previous articles have introduced the basics of Linux in logical partitioning, as well as networking alternatives for Linux, on iSeries systems. These articles covered the advantages of using iSeries for Linux in virtualizing resources (such as disk and network) and explained how to manage workloads better through subcapacity processor allocation. This article explains how Linux on iSeries can integrate with OS/400 to access data resident in DB2 databases, as well as flat files resident in the OS/400 Integrated File System.

    A number of solutions can be built upon the virtual LAN features of Linux on iSeries to integrate Linux with

    …

    Read more
  • To Commit or Not to Commit?

    January 28, 2004 Randy Adamski

    If data integrity is important to you, you owe it to yourself to learn more about IBM‘s advanced database feature known as commitment control for the iSeries. This feature promises an all-or-nothing approach to database file changes. If multiple files are being updated, you can guarantee that all the files will be updated, or none of the files will be updated. Why is this important? Well, that’s what this article explains.

    WHAT IS COMMITMENT CONTROL?

    Commitment control is handled by the operating system, but the programmer still has a final say about whether a record (even with bad data)

    …

    Read more
  • Simplify Complex Conditions

    January 28, 2004 Hey, Ted

    One of the features I like about Open Query File is the %VALUES function, which allows me to determine whether a value is found in a list of other values. For example, the expression CTYPE = %VALUES(45 56) is equivalent to CTYPE = 45 or CTYPE = 56. RPG does not have a similar function. Is there no way to simplify complex conditions?

    –David

    For record selection with SQL, you can use an IN predicate with a set. However, that’s not what you’re asking for in this case.

    One of the nice things about ILE is that you can

    …

    Read more

Previous Articles Next Articles

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • The Turning Point For Power Systems Is Here, And Now
  • How IBM i Users Can Compete In The Digital Era With Composable Commerce
  • IBM Streamlines Data Migration With New Partition Mirror Tech
  • Profound Logic Adds MCP To IBM i AI Tool
  • IBM i PTF Guide, Volume 27, Number 29
  • Power11 Entry Machines: The Power S1124 And Power L1124
  • BRMS Isn’t The Only Backup Product With A Security Problem
  • Guru: A Faster Way To Sign A JWT
  • Maxis Adds IBM i Support To Database Modernization Tool
  • IBM i PTF Guide, Volume 27, Number 28

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle