Skip to content

Jimmy.Octane

Just Another IBM i Website

Menu

  • Home
  • Code400 Forums
  • Blog
  • Shop
    • Cart
    • My Account
  • Contact Us

System Value

You are here: Jimmy.Octane > Blog > System Value

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!!! 123456SELECT 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

Jamie November 28, 2018 RPGLE, SQL 2 Comments Read more

Recent Posts

  • SYSTEM – API CMD Processor

    SYSTEM – API CMD Processor

    January 24, 2020
    system() is a runtime C library function that performs the same purpose as the QCMDEXC API. With system() you …Read more
  • Caller – The Detail(s)

    Caller – The Detail(s)

    January 24, 2020
    Caller_CP – This procedure returns the name of the previous program.  If called from command …Read more
  • XA (MAPICS) JAVA 8 upgrade process

    XA (MAPICS) JAVA 8 upgrade process

    September 17, 2019
    Install JAVA 7 & 8 on V7R2 in preparation of V7R3 and 9.2.2 version 7 …Read more

Recent Comments

  • Bert de Vries on Get date in multiple formats
  • The new Code400 for RPG Developers on Working examples of API’s
  • The new Code400 for RPG Developers on Refresh IBM i test partition
  • The new Code400 for RPG Developers on Using SQL to retrieve system information
  • Updating Planning Date XA (MAPICS) - Code400 on Get date in multiple formats

Archives

  • January 2020
  • September 2019
  • March 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2017
  • March 2014
  • February 2014

Categories

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

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Contact Info

  • Midwest USA
  • Phone: ‪(302) 570-2633‬
  • Email: jamie@jimmyoctane.com
  • Website: www.jimmyoctane.com

Recent Posts

  • SYSTEM – API CMD Processor

    SYSTEM – API CMD Processor

    January 24, 2020
  • Caller – The Detail(s)

    Caller – The Detail(s)

    January 24, 2020
  • XA (MAPICS) JAVA 8 upgrade process

    XA (MAPICS) JAVA 8 upgrade process

    September 17, 2019
  • XA (MAPICS) Facility Time Entry

    XA (MAPICS) Facility Time Entry

    March 13, 2019
  • Refresh IBM i test partition

    Refresh IBM i test partition

    January 7, 2019

Premium Themes

  • ColorMag Pro
  • ColorMag Pro
  • Flash Pro
  • Foodhunt Pro
  • Accelerate Pro
  • Accelerate Pro
  • Suffice Pro
  • Esteem Pro
  • eStore Pro
  • Esteem Pro
  • eStore Pro
  • Himalayas Pro
  • Himalayas Pro
  • Radiate Pro
  • Radiate Pro
  • FitClub Pro
  • ColorNews Pro
  • ColorNews Pro

More Free Themes

  • Cenote
  • ColorMag
  • ColorMag
  • FoodHunt
  • Flash
  • eStore
  • Accelerate
  • Envince
  • Suffice
  • FitClub
  • eStore
  • Accelerate
  • FitClub
  • Ample
  • Ample
  • Esteem
  • Esteem
Copyright © 2021 Jimmy.Octane. Powered by WordPress. Theme: Spacious by ThemeGrill.
  • Contact Us
  • My Account
  • Code400.com