• AS/400 QMQRY: Table Lateral Identifier Error

    Hi, I have a file.That comprises of all the file names(Only one column).Now  I am reading this file through a RPG program & passing this file name to a QMQRY object on a CL program. On the QMQRY, I'm facing the below error, as it is not accepting the '&' symbol. These are the two programs....

    HABBIE805 pointsBadges:
  • Save Objects and PF records in another AS/400 System

    Hi! We have two machines in our company one is V4R5 and latest one is V6R1 on Power 720 Machine. I just want to put auto backup all the backups in the V6R1 to V4R5 older machine. On next day it should deleted the previous backup and replace with the new one. Suggest me to perform this please. And...

    Sureyz2,375 pointsBadges:
  • What network is best for 340 systems?

    Which network topology is best where more than 340 systems and should be control by one server?

    spools5 pointsBadges:
  • AS/400 job running an error

    There is a job running which is in error, I cannot dump it and also do not have any authority to debug it. What should be my approach?

    smi201420 pointsBadges:
  • Record locked by the same job

    Here's the case where my program does several Read operations on a single file at different places. At one of the READ statements it throws error that the record is already locked to this Job. Apparently it would have got locked in one of the other READ operations, but is there a way I can find...

    NetBro20 pointsBadges:
  • Power Down Problem of Two Partitions

    Good day, We have 9406-825 machine and there's two(2) 5094 expansion unit (One for DEV and the other for PROD). When I changed the cache battery for DEV partition, I power down the partition, but the PROD partition also power down. What would be the possible problem of our machine? Does anyone...

    excellentrandy625 pointsBadges:
  • QMQRY ERROR : FILE in *LIBL type *FILE not found

    Hi,I am trying to call the QMQRY interactively. I am facing some kind of issue,which I am unable to get through.Kindly look let me know, what does this for.This is the error from DSPJOBLOG:STRQMQRY QMQRY(MENTIS1/QMQRY102) FILE in *LIBL type *FILE not found. RUN QUERY command failed with SQLCODE...

    HABBIE805 pointsBadges:
  • AS/400 V7.1 Operating System

    Are there any major changes in V7.1? Such as with commands WRKWTR, WRKOUTQ, etc.

    JohnD215 pointsBadges:
  • Calling RPG ILE code from RPG3 code

    How I can call an RPG ILE program from RPG3 program with parameters. I have searched on the net but all the examples I got are related to calling RPG3 from RPG ILE code.Thanks

    hunshabbir7860 pointsBadges:
  • Reading a file twice in a CL program

    In a certain CL program, in the first part, I've read the total file and reached EOF, in the second part of the same program I want to traverse the file again for some reason. How can I do that?

    NetBro20 pointsBadges:
  • What will happen in AS/400 if I use H dump?

    H  DUMP     what will happen to the program

    chakramdhar60 pointsBadges:
  • CHAIN operation in CL

    Is there a way I can access a random record in CLP similar to doing a chain operation with known key field in RPG instead of reading the total file and validating each one until I reach the required record?

    NetBro20 pointsBadges:
  • Error in Prepare statment in SQLRPGLE

    Hi Group, I'm having a problem with the prepare statement in SQLRPGLE. Here my code: Eval q_str = 'SELECT ' + 'EMPCDE, EMPDEP, CLSS, STRYER, ' + 'SUBSTR(CHAR(UPDTTM),1,10) AS ENTRY ' + 'FROM EMPMAS ' If vnum <> *BLANKS Eval q_str = %TRIM(q_str)+ ' WHERE ' + 'SRLNO = '+ vnum+' ' EndIf c/Exec...

    Sureyz2,375 pointsBadges:
  • passing parameters via a datastructure to and from a procedure

    Can anyone provide a simple example of passing data via a data structure from one procedure to another? I would like to call a procedure to post data to a transaction file using a data structure to pass the data.

    docorp15 pointsBadges:
  • LEAVESR opcode for RPG

    Is there anyway to perform LEAVESR operation in OLD RPG code. Unfortunately I have to amend some old written code. I am searching for related operation as LEAVESR. I have used GOTO (with tag). Is it ok?

    hunshabbir7860 pointsBadges:
  • SSN ID format in AS/400

    Hi, I am new to this technology. I need to create some fields on Physical file which should accept the data in the format of SSN ID (123-456-789). Kindly let me know. How can I go with this? If this is an older question, please forgive me & post that older link. Thanks

    HABBIE805 pointsBadges:
  • How to access a single program at different PEPs?

    How can this be done? I want to access PGMB at 2 different entry points when called from 2 different programs PGMA & PGMB.

    NetBro20 pointsBadges:
  • LIKE pattern matching in AS/400

    Hi, I have table with one column(ID), values are in the format of '123-456-7890'. Now I need to fetch all the rows from the table whose ID values are of the  same format. I tried to query as Select * from file where ID like ('%___-___-____%'). But no records found. Kindly let me know, how to...

    HABBIE805 pointsBadges:
  • Creating a field in AS/400 physical file

    Hi, How to create a field in Physical file with (123 456 789). Tried with EDTWRD, unable to specify spaces in between. Thanks

    HABBIE805 pointsBadges:
  • Another CPYTOIMPF problem

    I created a small cmd that will take any spool file and transfer it as a PDF to our “public” drive. When I call it under my usrprf, it works beautifully. But, when my operators do it,, they receive the error “CPFA0A9 “ according to IBM, the error is caused due to a password conflict and...

    smintz90 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following