Skip to content

Code400

YOUR EXTENDED TEAM

Menu

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

Code400 - Forum

One of the only IBM i specific online forums that remains free and open to the public. Stop by, join us, ask questions and share your expertise with hundreds of experienced IBM i developers.

Visit the Forum
Code Samples

Code Samples

Visit the Blog for discussions on RPGLE, SQL, API's, CLLE, PHP and web development using IBM i.

Code Samples and Discussion
IBM i Job Postings

IBM i Job Postings

View IBM i job postings in your area.

Job Postings
SQL on DB2

SQL on DB2

A scratch page put together with multiple examples of stand alone SQL and SQLRPGLE programs.

SQL on DB2

Enterprise Backup Solution

Enterprise Backup Solution

I was in doing a full system save on the IBM i today and thought I’d share a few thoughts. We have 1 physical IBM i device that is partitioned so that we have a production and “development” system available

Jamie January 6, 2019 Enterprise Backups, icluster No Comments Read more

XA (MAPICS) Table Identification

XA (MAPICS) Table Identification

XA – Version 9.2.0 XA (MAPICS) table defiitions

Jamie December 20, 2018 Table (DDS), Uncategorized, XA (MAPICS) No Comments Read more

Updating Planning Date XA (MAPICS)

Updating Planning Date XA (MAPICS)

Short example on how to use system-link to update XA (MAPICS) table. This example includes some procedures. System_Link Users Guide the below snippet runs out of the job scheduler. ** Binding directory – “UTLITIES” 2 procedures GETDATE & UPDDAT System-Link

Jamie December 19, 2018 Procedure, RPGLE, System-Link, XA (MAPICS) No Comments Read more

Get date in multiple formats

Get date in multiple formats

Procedures — Initial guide to creating them in RPGLE Download the source: getdate getdate_cp getdatetst   In this example we will provide an example of how to get  date values in a multitude of formats. You may pass it a

Jamie December 17, 2018 Dates, Procedure, RPGLE, SQL 2 Comments Read more

create XML from RPG read as EXCEL

create XML from RPG read as EXCEL

This program produces the below spreadsheet. It writes XML to IFS which is then read automagically by excel as a spreadsheet. This example can be used to produce multi tabbed spreadsheets. These spreadsheets can contain any/all of the features in

Jamie December 5, 2018 IFS, RPGLE, SQL, XML 1 Comment Read more

Encrypting Data

Encrypting Data

Encrypting data using system API Required Parameter list for Qc3EncryptData Required Parameter Group: 1 Clear data Input Char(*) 2 Length of clear data Input Binary(4) 3 Clear data format name Input Char(8) 4 Algorithm description Input Char(*) 5 Algorithm description

Jamie December 2, 2018March 19, 2020 API, RPGLE No Comments Read more

Using QWCRSVAL to change password (QSYCHGPW)

Using QWCRSVAL to change password (QSYCHGPW)

The Retrieve System Values ​​(QWCRSVAL) API lets you retrieve system values. This is for example use only — We do not recommend use of this program to bypass enterprise security policies. In this example system values that are associated with

Jamie December 2, 2018 API, RPGLE No Comments Read more

Working examples of API’s

Working examples of API’s

The term Application Programming Interface (API) can be applied in many instances. By definition, an API is an application-supplied program or procedure that allows an application program, which is written in a high-level language, to access specific data or functions

Jamie December 2, 2018 API, RPGLE, SQL 1 Comment Read more

List and enable disabled NetServer users -Carsten Flensburg

List and enable disabled NetServer users -Carsten Flensburg

IBM Says… When an IBM System i user profile is disabled for NetServer access, message CPIB682 is posted to the QSYSOPR message queue. This disabled user profile is added to the NetServer Disabled User ID list the next time the

Jamie December 1, 2018 Uncategorized No Comments Read more

DATAQ

DATAQ

Data queues are a type of system object (type *DTAQ) that you can create and maintain using OS/400 commands and APIs. They provide a means of fast asynchronous communication between two jobs, or within the same job, because they use

Jamie December 1, 2018 API, data queue, RPGLE No Comments Read more
  • « Previous
  • Next »

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