Skip to content

Code400

YOUR EXTENDED TEAM

Menu

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

TimeStamp

You are here: Code400 > Blog > TimeStamp

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

using QWCCVTDT to get UTC time

using QWCCVTDT to get UTC time

UTC time can be used when queuing data. In a project where you have data sent external from the IBM i to AWS (Amazon Cloud Services). This data is sent via webservice on the IBM i using HTTPS post and

PIO October 29, 2017January 16, 2024 Uncategorized Read more

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