• Duplicate Records in physical file using RPGLE

    How can I find duplicate records in a single physical file using RPGLE?

    Nanisuresh10 pointsBadges:
  • AS/400 Month/Year End Closing

    I closed Dec. and I have not closed for the year; we have already done some sales for 2018. What can I do to go back and close the year (2017)?

    MelodyAS40010 pointsBadges:
  • How can I check status of a file during debug?

    How would I be able to check the status of a file during debugging in AS/400? It's status: open/close.

    rajat01170 pointsBadges:
  • What is the use of ‘EDU’ (education) command in CL?

    How can I use the CL command 'EDU' (education)?

    rajat01170 pointsBadges:
  • Can my V5R4M5 run on Power 7 machines?

    Hello, we are planning to do hardware upgrade as we are dependent on the old hardware which is having issues. we are currently on Power 5 machines running OS version V5R4M5. Now I want to move to power 7 machines without upgrading the operating system. Is it possible to run V5R4 on power 7...

    Skalluri15 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER220 pointsBadges:
  • Design a new user sign up sign in screen in RPGLE

    How to design a simple login screen with id and password using RPGLE? Can you help with RPGLE code?

    sampathrsk15 pointsBadges:
  • Difference between READE and CHAIN

    Hi, What is difference between CHAIN and READE both reads equal key record? Looping possible do while in both so that both will filter equivalent key records but what is main difference then? Thanks!

    6r1,960 pointsBadges:
  • COBOL/400 FD entry

    Inquiry (related to COBOL/400): Q1. How to declare more than one 'record key' in 'file-control' for a single LF with  multiple record formats with multiple key(s) Q2. How to create multiple storage areas, one each for each record for the same LF....

    anandx715 pointsBadges:
  • AS/400 query on editable subfile with SFLNXTCHG

    I have an editable subfile that lists 10 records. Option = 4 to delete record from PF. I input 7 (invalid option) on 2nd record and 4 (valid option) on 5th record. Now, I get error on 2nd record as the option is invalid (fine till this point). Now, I remove option 7 from 2nd record and hit enter....

    sri8707165 pointsBadges:
  • AS/400 output file break level and overlow field

    I've created a query using WRKQRY to output the file and added break level in the query in order to output the data in unique. I found additional field break level and overlow fields existed in output file. How can I output a file without this 2 additional fields? Thanks in advance.

    Charlena25 pointsBadges:
  • Retrieve AS/400 user profile list

    How do I code SQL to retrieve user profiles that have not signed on in 60 days?

    KatieEnglish5 pointsBadges:
  • AS/400 User Friendly Manual

    Does anyone know where I can find a AS/400 user friendly manual?

    kjjohnson041215 pointsBadges:
  • While trying to FTP AS/400, 530 Log on attempt by user XXXXXXX rejected

    530 Log on attempt by user while trying to FTP AS/400, 530 Log on attempt by user XXXXXXX rejected. message received.

    Anshan150 pointsBadges:
  • %Found in READE

    Is it incorrect to use %Found with ReadE? I performed READE on a file with 4 keyfields and as there was no exact match found, resulted in EOF. However, I noticed that %Found() returned True. Is there a relation between %found and %eof function when used with ReadE opcode?

    sri8707165 pointsBadges:
  • IP Address of AS/400

    How to find the IP address of a given AS/400 machine?

    RamT35 pointsBadges:
  • What does LANSA stands for?

    What does LANSA stands for in LANSA for iSeries?

    rajat01170 pointsBadges:
  • JDE Worldsoft or AS/400 dev?

    Hi everyone, I am sorry that I am not asking a technical question and seeking advice from all the experts here. I have a total 5 years of experience. I am currently working in an AS/400 project and also worked in JDE World soft for around 1.5 years in starting of my career. I am getting...

    newasuser1235 pointsBadges:
  • Holding and restarting the job scheduler

    We have A LOT of jobs scheduled through the Advanced Job Scheduler (wrkjobjs).  We have to do some system maintenance and need to prevent the scheduled jobs from starting while we perform the maintenance. In the past, the operator has gone through the entire list of jobs on the scheduler and...

    ElTerrifico620 pointsBadges:
  • BPCS Inventory activation date

    Is there a BPCS native file that shows the date in which a lot changes from status "H" to status "A"?

    ricardoguadarrama5 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.

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

Following