Skip to content

Code400

YOUR EXTENDED TEAM

Menu

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

System Value

You are here: Code400 > 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!!! 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

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

Recent Posts

  • 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
  • Get IP Address

    Get IP Address

    March 20, 2020
    This procedure was written to retrieve the IP address of a device.  This can be …Read more
  • Check IFS/Server for a document

    Check IFS/Server for a document

    March 19, 2020
    This procedure was written to check for the existence of a table on either the …Read more

Archives

  • 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

  • Regular Expressions

    Regular Expressions

    March 20, 2020
  • Get IP Address

    Get IP Address

    March 20, 2020
  • Check IFS/Server for a document

    Check IFS/Server for a document

    March 19, 2020
  • SQL Vs. QUSRJOBI (Retrieving Library List)

    SQL Vs. QUSRJOBI (Retrieving Library List)

    March 17, 2020

IBM i 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 © 2023 Code400. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.
  • Contact Us
  • Code400.com