• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Prompting CL in Run SQL Scripts

    December 9, 2009 Skip Marchesani

    System i Navigator’s Run SQL Scripts lets you create scripts, from simple to complex, that can be comprised of one to many SQL statements and/or batch CL commands (no interactive or display commands allowed). SQL statements are entered without any prefix, and batch CL commands must be prefaced with CL.

    The syntax for SQL statements and batch CL commands can get quite complex, and keying or creating each without some sort of help or assistance can be a challenge. RUN SQL Scripts does a good job of helping you create either.

    Figure 1.

    There is SQL Assist for SQL statements

    …

    Read more
  • Publish Result Sets Using Web Services and IWS

    December 9, 2009 Michael Sansoterra

    Note: The code accompanying this article is available for download here.

    IBM i/OS V6R1 (a.k.a. 6.1) introduced a new feature called Integrated Web Services (IWS). This feature is also available by PTF on V5R4 systems. One benefit of IWS is its ability to make data and logic in high-level language programs such as RPG, COBOL and C available as a Web service.

    Publishing business logic as a Web service allows clients on just about any platform (PDA, green screen, Web application, Windows client) in just about any language (Java, C#, VB.NET, VBA, etc.) to easily consume the data provided

    …

    Read more
  • Admin Alert: The Ins and Outs of IBM Business Partners

    December 9, 2009 Joe Hertvik

    Due to an unusual situation, we didn’t have a business partner for my System i 550 box and we needed to select a new partner before we could upgrade. That experience taught me a lot about how business partner relationships work. This week I’ll share that knowledge to help anyone who is interested in changing their business partner or to help you learn more about how the program works.

    The Basics

    It’s helpful to understand what IBM business partners do, how to select a business partner, what the relationship entails, and what to do if your business partner relationship isn’t

    …

    Read more
  • Getting the Message, Part 2

    October 21, 2009 Paul Tuohy

    In Part 1 of this series, we saw the definition of a number of message routines (clearMessages(), addMessage(), messageCount(), and getMessage()). In this article, we will see how the routines may be used in both an RPG and a PHP environment. We will also look at another couple of message routines that may be useful.

    Remember, a library containing the code used in these articles may be downloaded here.

    A Test Procedure

    Figure 1 shows a small subprocedure (fillMessages()) used to demonstrate that messages may be added/stored at any level in the job. The subprocedure simply adds a filler

    …

    Read more
  • Passing an Entire Result Set as a Parameter, Part 2

    October 21, 2009 Michael Sansoterra

    Note: The code accompanying this article is available for download here.

    In Part 1 of this series, I discussed a generic method of passing a delimited set of text records in CSV (comma separated variable) format into a single stored procedure variable. Once the stored procedure had this text data, a generic Java user-defined table function (UDTF) was used to parse the text data and convert it to a row set that could be by any number of standard DB2 for i statements, such as a SELECT or INSERT. So with a little sweat, it is indeed possible to

    …

    Read more
  • Setting Up SNTP Time Synchronization on an i5/OS Box

    October 21, 2009 Hey, Joe

    For PCI Data Security Standard (PCI DSS) auditing, I need to ensure that my System i 550 time is synchronized with other network system clocks. How do I set up time synchronization on an i5/OS V5R4 box?

    –Len

    PCI DSS is a security standard being pushed by the credit card providers to encourage companies to adopt consistent security measures for protecting customer account data. Requirement 10.4 of the standard specifies that all critical system clocks and times must be synchronized. For an iSeries, System i, or Power i box, this means that your partitions must automatically synchronize their system clocks

    …

    Read more

Content archive

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

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25

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