Display message ID MH00090

How do I display message ID MH00090?

eudybarb5 pointsBadges:

How to export data from AS/400 in Excel

Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

Itriconewbie5 pointsBadges:

RPGLE DATE CALCULATIONS

I need to subtract 1 day from the system date and output it into a file in the format mmddyyyy. No separators. I cannot figure out how to use date functions like subdur w/o the field containing separaters on output. And I can't figure out how to use a DS to redefine it so I can exclude the...

KatanaBeach115 pointsBadges:

ILE RPG RegEx API

Hi All, Has anyone had any luck implementing the Regex C APIs within ILE RPG? I'm aware of the matter of converting the pattern input to match CCSID 37, and I thought I had catered for the gotchas. But I cannot get the API to work for anything but the most basic of match conditions. For example if...

andyhumphreys465 pointsBadges:

QSOSRV1 service program hangs on recv() procedure

My program hangs on IBM's service program QSOSRV1 when it runs the 'recv' procedure. It's hung at statement 9. This only happens occasionally. Most of the time the 'recv' procedure works fine. I'm new to sockets programming and would appreciate any help or suggestions. The 'recv' statement...

fhartman15 pointsBadges:

RPQSQL / SQLRPG

Any body please help Wanted to know the advantage and disadvantage using RPGSQL / SQLRPG I've heard that this is the new one its not only RPG but become one with SQL. Thanks in advance

TG50 pointsBadges:

AS/400 distribution list

How many names in one list, and how do I see the entire list?

c021340j5 pointsBadges:

How to remove comma for individual fields before inserting into comma seperated csv file in RPGLE

I'm trying to convert flat file to CSV file using RPGLE. As it is a comma separated file for certain fields like description as and when comma is encountered data is written to next column. I need to place each field value in respective columns even if comma is present in a field value. Can some...

ganeshpavi75 pointsBadges:

CPYTOIMPF error when copying PF to stream file on iSeries

I'm encountering an error while copying a PF to a stream file on iSeries if the stream file reside on a IFS link with 'NFS' as root directory. Below is the scenario where I'm getting this error. Used the below command: CpytoImpf Fromfile(Qtemp/CsvHeading) Tostmf(&CsvFile) Mbropt(*Replace)...

HemanthD5 pointsBadges:

Cannot view spool file in System i Navigator

In system i navigator, user cannot view their spool file. What should I do?

ravisub15 pointsBadges:

How to decrypt a SHA1 hash value?

SHA= 2fd4e1c6 7a2d28fc ed849ee1 bb76e739 1b93eb12. How can I decrypt (to ASCII) the string using RPG/400? What is its coding scheme?

rajat01170 pointsBadges:

How to create a AS400 Qshell script (.sh) file

Hi, I want to run a command STRQSH CMD ('/REPORTGENERATOR/move2current.sh') Where move2current would be a .sh file with commands as below: rm /HPA_CURRENT/_YOUR_AS400_NAME*.CSV cp /REPORTGENERATOR/*$(date '+%Y%m%d')* /HPA_CURRENT #set new owner chown hpa_transf /HPA_CURRENT/*.CSV My question is how...

DeepikaR115 pointsBadges:

Program not logged in queue in remote AS/400

Hi, I have a program that put an XML msg to a remote AS/400. The issue is when calling the program directly nothing logged in the queue but when calling it from submit job it works fine. This is for the same user

majdhrb5 pointsBadges:

Program Described File in RPGIV

Can any one send me an Example, How a Program Described File is used in RPGIV?

Cganeshh0 pointsBadges:

How to use OVRDBF on STDIN to read multiple files in REXX/400

I can issue "OVRDBF" for STDIN to a file and then read the file with PARSE PULL commands. At EOF, I issue "DLTOVR STDIN" and then a new "OVRDBF" to read the another file. However, the first PARSE PULL for second file returns EOF. How can I get past this?

mgphl5215 pointsBadges:

Send message to specific user when AS/400 job runs

I need to send a message to a specific user informing them when a specific job runs. The user is not getting the message. I have checked the user profile to make sure of the correct message queue. I have sent the message to my own user id and it works fine. I am thinking there is something with...

JMatthews5040 pointsBadges:

AS/400 Power 8 (Subsystems)

I have a client who says their IBM rep said they should only have one batch subsystem, and they are adamant that this is gospel. How do I prove this wrong?

Harry10815 pointsBadges:

Code C9002910 takes a long time on IPL display without starting up

The code C9002910 takes a long time on IPL display without starting up. How can I resolve this problem?

Husseinmoh5 pointsBadges:

AS400 command to view all users last login

Hi There, I need to find a command that will list all users last login. Also all disabled accounts. For Audit purposes   Thanks :)

Kerry5 pointsBadges:

AUDIT: *ALLOBJ.. but really how?

- If I have users with *ALLOBJ, but no access to command line: How does the user access those *any* objects on the server or app? How is the risk materializing? If I look at a client's screen and they say:  "yeah I have allobj but see? I don't have a CL and my menu shows only 2-3 options.. So how...

aldc123100 pointsBadges: