Skip to content

Code400

YOUR EXTENDED TEAM

Menu

  • Home
  • Code400 Forums
  • Webinars
  • Blog
  • Jobs
  • Contact Us

Year: 2018

You are here: Code400 > Blog > 2018

Working with Data Areas

Working with Data Areas

A data area can be used whenever you need to store information of limited size, independent of the existence of procedures or files. Typical uses of data areas are: To provide an area (perhaps within each job’s QTEMP library) to

PIO December 1, 2018January 16, 2024 API, DataArea, RPGLE Read more

Using SQL to retrieve system information

Using SQL to retrieve system information

List system values that contain “SEC” in the name. Take some time and play with the SQL — Become famous Post new samples!!! SELECT SYSTEM_VALUE_NAME as sysvalue, ifnull(CURRENT_NUMERIC_VALUE,0) as DecValue, CURRENT_CHARACTER_VALUE as CharValue FROM SYSTEM_VALUE_INFO where SYSTEM_VALUE_NAME LIKE ‘%SEC%’ this

PIO November 28, 2018January 16, 2024 RPGLE, SQL Read more
  • Next »

Recent Posts

  • 6 Reasons to Keep Your Printing Operations On-Premises: A Focus on RPG, IBMi, and AS400 Technology for B2B Services

    6 Reasons to Keep Your Printing Operations On-Premises: A Focus on RPG, IBMi, and AS400 Technology for B2B Services

    June 20, 2024
    In the age of cloud computing and Software as a Service (SaaS), many businesses are …Read more
  • The Best Tools For Prospecting And Successfully Landing B2B Sales

    The Best Tools For Prospecting And Successfully Landing B2B Sales

    January 20, 2023
    When it comes to landing a lucrative B2B sales opportunity, you need all the help …Read more
  • Regular Expressions

    Regular Expressions

    March 20, 2020
    A regular expression is similar to a rule which defines the characters that can appear in an …Read more

Archives

  • June 2024 (1)
  • January 2023 (1)
  • March 2020 (4)
  • January 2020 (2)
  • September 2019 (1)
  • August 2019 (1)
  • March 2019 (1)
  • January 2019 (2)
  • December 2018 (11)
  • November 2018 (1)
  • October 2017 (1)
  • March 2014 (3)
  • February 2014 (1)

Categories

  • API
  • data queue
  • DataArea
  • Dates
  • Enterprise Backups
  • FTP
  • General
  • icluster
  • IFS
  • Procedure
  • RPGLE
  • SQL
  • System-Link
  • Table (DDS)
  • Uncategorized
  • XA (MAPICS)
  • XML

Contact Info

  • Programmers.io
  • Address: 8951 Cypress Waters Blvd STE 160
  • Dallas, TX 75019-4784 USA
  • Email: info@programmers.io
  • Phone: 1-800-600-5822

Recent Posts

  • 6 Reasons to Keep Your Printing Operations On-Premises: A Focus on RPG, IBMi, and AS400 Technology for B2B Services

    6 Reasons to Keep Your Printing Operations On-Premises: A Focus on RPG, IBMi, and AS400 Technology for B2B Services

    June 20, 2024
  • The Best Tools For Prospecting And Successfully Landing B2B Sales

    The Best Tools For Prospecting And Successfully Landing B2B Sales

    January 20, 2023
  • Regular Expressions

    Regular Expressions

    March 20, 2020
  • Get IP Address

    Get IP Address

    March 20, 2020

IBMi Sites

  • IBM i on Power Systems
  • Scott Klement’s Site
  • Jon Paris & Susan Gantner’s Site
  • IT Jungle
  • IBM Systems Magazine
  • Simon Hutchinson’s Site
  • Easy400.net
  • Craig Rutledge’s Site
  • Leif Guldbrand’s Site
  • Nick Litten’s Site
Copyright © 2025 Code400. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.
  • Contact Us
  • Code400.com