Skip to content

Code400

YOUR EXTENDED TEAM

Menu

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

XA (MAPICS)

You are here: Code400 > Blog > XA (MAPICS)

XA (MAPICS) SQL to pull 10 levels BOM

XA (MAPICS) SQL to pull 10 levels BOM

I needed a quick way to pull Bill of Materials (BOM) for a group of finished goods to help calculate turns of raw material. I borrowed this from WIKI A bill of materials or product structure (sometimes bill of material,

PIO August 6, 2019January 16, 2024 Procedure, RPGLE, SQL, XA (MAPICS) Read more

XA (MAPICS) Facility Time Entry

XA (MAPICS) Facility Time Entry

Standard labor entry screens provided by XA may be a bit of a challenge to deploy onto the shop floor. They also lack the ability to transact data to MOTRAN in near real time. What we saw happening is that

PIO March 13, 2019January 16, 2024 Procedure, RPGLE, SQL, Table (DDS), Uncategorized, XA (MAPICS) Read more

Refresh IBM i test partition

Refresh IBM i test partition

To start we are running bot a production (MM) & test (TT) environment of XA (MAPICS). We have separated the environments by logical partition on the IBM i. Looking for a way to keep “we” developers out of production, we

PIO January 7, 2019January 16, 2024 Enterprise Backups, icluster, RPGLE, XA (MAPICS) Read more

XA (MAPICS) Table Identification

XA (MAPICS) Table Identification

XA – Version 9.2.0 XA (MAPICS) table defiitions

PIO December 20, 2018January 16, 2024 Table (DDS), Uncategorized, XA (MAPICS) 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

PIO December 19, 2018January 16, 2024 Procedure, RPGLE, System-Link, XA (MAPICS) 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