• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • V5R3 CL Programming Enhancements, Part 2

    March 24, 2004 Ted Holt

    Last week I wrote about the integer data types, the select structure, and the looping commands that will be available in V5R3. This week I’ll finish my tour of new V5R3 CL programming features by telling you what’s new with input/output operations, parameter passing, and the generation of CL command documentation.

    DECLARE MORE FILES!

    One limitation that System/38, AS/400, and iSeries programmers have complained about is that only one Declare File (DCLF) command was allowed in a CL procedure (i.e., a compiled program or module). Using a database file automatically eliminated the possibility of using a display file, and vice

    …

    Read more
  • Better Data Transfers

    March 24, 2004 Bruce Guetzkow

    [The code for this article is available for download.]

    I’ve been searching for ways to automate user tasks and, preferably, to have them initiated from the iSeries. One such task is transferring data between a network folder or the Integrated File System (IFS) and an externally described iSeries database file. But there are problems associated with using IBM’s Copy from Stream File (CPYFRMSTMF) and Copy to Stream File (CPYTOSTMF) commands. So I developed my own commands.

    When using the CPYFRMSTMF and CPYTOSTMF commands, the parameters and associated values are difficult to keep straight, and externally-described iSeries database

    …

    Read more
  • Delimited List Processing in SQL

    March 24, 2004 Michael Sansoterra

    [The code for this article is available for download.]

    I recently worked on the database side of a Web project for which the Web developers needed to pass several item numbers to an iSeries for processing. Traditional methods would have dictated these items be inserted into a temporary or transaction file, then converted and processed as an XML file or passed individually to a stored procedure for processing.

    An alternative that is fast and painless (provided the related item information is minimal) is to make a single call to a stored procedure and to pass the item

    …

    Read more
  • OS/400 Alert: Microsoft Closes the Doors on JVM

    March 24, 2004 Shannon O'Donnell

    This issue of “OS/400 Alert” lets you in on what was an inevitable move by Microsoft in announcing it will no longer support or provide its own Java Virtual Machine. We’ll also let you know what to do if you find a bug in one of IBM‘s Licensed Program Products. And if you ever felt sorry for hackers, thinking these poor folks must have no friends or social life, you might be surprised to learn the number of Web sites devoted to the hacker lifestyle.

    SUPPORT FOR MICROSOFT JVM TO END SOON

    In what is likely one of the

    …

    Read more

Content archive

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

Recent Posts

  • IBM Unveils Manzan, A New Open Source Event Monitor For IBM i
  • Say Goodbye To Downtime: Update Your Database Without Taking Your Business Offline
  • i-Rays Brings Observability To IBM i Performance Problems
  • Another Non-TR “Technology Refresh” Happens With IBM i TR6
  • IBM i PTF Guide, Volume 27, Number 18
  • Will The Turbulent Economy Downdraft IBM Systems Or Lift It?
  • How IBM Improved The Database With IBM i 7.6
  • Rocket Celebrates 35th Anniversary As Private Equity Owner Ponders Sale
  • 50 Acres And A Humanoid Robot With An AI Avatar
  • IBM i PTF Guide, Volume 27, Number 17

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