AS/400 selective update with SQL

Hi All, I am trying to create an SQL statement that will update many records based on a file containing fewer records. I can easily update ALL records in the primary file but I really only want to update those that need to be updated. In the item master file the cost has been changed for some...

Ckelly0120 pointsBadges:

QPADEV0006 message spamming on history log

In "DSPLOG", I keep getting the following message spammed. Any help would be greatly appreciated: Description for device QPADEV0006 changed. Session to device QPADEV0006 ended normally. Description for device QPADEV0006 changed. Session to device QPADEV0006 ended normally. Description for device...

kf4wto15 pointsBadges:

Users connected to a particular printer device in AS/400

How can we find out who are the users connected to a particular printer device in AS/400 if we know the printer device name.

dineshiseries555 pointsBadges:

How do we reproduce the error CPF5032 – member already locked to job.

As part of my task, I need to recreate the issue that throws error CPF5032 - "member already locked to job. I need to fix a program but before doing that I need to recreate this error and I am unable to do so. What specific setup is required to recreate this issue?

sanras12340 pointsBadges:

Client Access adding decimal and blank space after numeric fields

How can I remove the decimal point and blank spaces during the file transfer process. These are defined as zoned numeric fields. The file is a typical iSeries physical file with both Character and zoned numeric fields. The blank spaces and decimal point do not show when you display the file on the...

Sharonhynes45 pointsBadges:

AS/400: Update the record that caused the trigger to be called

I need to update the record that caused the trigger to be called. When the status is updated to a certain value, I want to be able to perform some calculations on other files and then update the original status. This is not working due to record locking.

lisawml15 pointsBadges:

Convert AS/400 date format

Can the AS/400 date be re-formatted?

BillJohnson7624025 pointsBadges:

Query/400 not displaying column descriptions for DDL defined table

We recently updated a file and converted it from DDS to DDL during the process. During testing no one mentioned the column descriptions were no longer displayed when using Query/400. Is there a way to make Query/400 display column descriptions for DDL defined tables?

DancingInTheMoonlight145 pointsBadges:

How to convert a Date given in Char format to numeric format in RPG of AS/400.

How do I convert a Date given in Char format to numeric format in RPG of AS/400?

C.naveen09140 pointsBadges:

How to add one Module to the existing Service Program

Hi, I want to add or append one new module called 'C' to the already existing service program (SRVPGM) For Example: I have one service program called SRVPGM consists of 2 Modules are A, B. Now I want to add one new Module called 'C' to SRVPGM. How can I do this? when we do UPDSRVPGM does the...

hndajad195 pointsBadges:

DFU (UPDDTA) and changing Keys

DFU (UPDDTA) and changing keys - We support a number of users of the same software. then we try to change a key field in a file with DFU it doesn't always allow us to do so. Sometimes the user does not have access to the key field, sometimes they do. Each user is the owner of the file and has...

Bamba6125 pointsBadges:

AS/400: %Equal and %found

Which are those opcode can be used with this two built in function in different different scenario? Which one should be used with whom? Please explain me, I am quite confused here.

hndajad195 pointsBadges:

User Not On the Menu System

iNavigator v.7.2, OS400-iSeries.v5r3, When a regular user logs on from iNavigator, he sees no Menus, also encountering a confusing Message: “User Not On the Menu System”! What User Setting might have been Corrupted or Missing? THX! Kanneth

KenKimNy50 pointsBadges:

FTP from the IFS

I have an XML file successfully created and have used CPYTOIMPF to translate it to ASCII and put it on the IFS. What I need to do, though, is FTP the file to an internally defined FTP server that requires a userid and password.

GigiSarsfield10 pointsBadges:

Build a AS/400 calendar file

I need to build a calendar file with date '010110' and day of week 'SU' in rpg/400.  The client does not use the ILE envionment.  Can anyone provide the RPG code to create this file?  Thanks

Fedli0015 pointsBadges:

Remove color from data group in AS/400

How to remove the yellow color from Data Group in AS/400?

YEMEN50 pointsBadges:

File system organization in Microsoft Windows

What is the file system organization of windows in an operating system?

cse13mist5 pointsBadges:

Memory analyse dmpmeminf output

We have potential memory constraints. We are particularly interested in particular subsystems/jobs memory usage. We run dmpmeminf and get a grand report, but we cannot find any description of the fields/attributes reported. Below a list of interesting attributes with no description. We found on IBM...

SteenPalvig5 pointsBadges:

Deleted users audit trails in AS/400

Scenario 1: I have been doing some cleanup of user profiles that have not logged in more than 365 days to satisfy a SOX Compliance issue. I am doing this across all of our Health facilities (57). IT Personnel from one of the facilities is concerned that they would lose the Audit trail for these...

DCORDERO4725 pointsBadges:

MPS – JDE AS/400

I have an item which has negative on hand quantity, when I run single item MPS for this particular item the MPS message for work order creation is not getting generated, but MPS provides WO message for other items in the same scenario.

vinothpr25 pointsBadges: