• Substringing long character length field

    After doing a DSPUSRPRF command and putting the data into a file, there is a field called Special Authorities which is a 150 character length field. I need to take this field and break it up to create a separate field for each value that this field has. So if there are entries like, *ALLOBJ ...

    Rrbond07750 pointsBadges:
  • AS/400 Printer Output Issue

    I have a USB connected printer that is set up on a printer emulator session on AS/400 and it does print screen fine, but when I print a document from the system, the characters on the page are all mashed together and overlapping each other. How do I fix this?The printer is HL-L625ODW brother. the...

    redwallju25 pointsBadges:
  • AS/400: Changed record on screen

    We have subfile and in that there are 5 records in the screen and when we update the 5th record in the screen. The changed record should come first in the screen. How to do this? What is the command used? Is this possible?

    vivekntt21450 pointsBadges:
  • AS/400: Change field length in physical file

    We have a normal physical file and one reference physical file, In referenced physical file we change a field's length after this change should we go back to the original physical file and change the field length as well?

    vivekntt21450 pointsBadges:
  • Substring in CL on iSeries

    I have a 150 character field. I need to check each character for a quote. If it should find one I want to replace it with a blank space or just delete the quote. Is there a way to "walk the field" searching for a quote using substringing?

    Rrbond07750 pointsBadges:
  • Inquiry into a Journal

    I have had multiple attempts to sign on to the system with QSECOFR, but the requests fail. I am trying to find out what process is trying to use the QSECOFR profile to sign onto the system. How do I view the information from the journal?

    Rrbond07750 pointsBadges:
  • AS/400 Authorization Lists

    I want to generate a file that will contain all authorization lists that have profiles associated them. So if I have an authorization list by the name of APS, I want in the file to contain an entry for each profile that is secured by the authorization list along with the profiles access rights in...

    Rrbond07750 pointsBadges:
  • Create CL program Update in AS/400

    Dear All, I am learning to write CL program in AS/400 for DB2, maybe call new programmer. I have a file1 include ( field 1 ->10) to have value as: Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Field 8 Field 9 112118 P I 1 A B C D E I want to create CL program update file 1 in AS/400 to...

    Hvphong0311150 pointsBadges:
  • AS/400: How to reuse field indicator

    How to reuse field indicator in a display file in AS/400?

    Amitkshukl15 pointsBadges:
  • DDS in AS/400

    What is DDS in AS/400?

    vivekntt21450 pointsBadges:
  • AS/400 RPGLE: What is EDTCDE & EDTWRD

    What is EDTCDE & EDTWRD and let me know the difference as well please explain with example.

    vivekntt21450 pointsBadges:
  • AS/400 DB2

    I want to know the DB2/400 questions that are usually asked in interviews so somebody can provide me the source to read about DB2/400?

    vivekntt21450 pointsBadges:
  • AS/400 CLLE: What is open query

    What is open query and when we use open query? How we use it in CL program?

    vivekntt21450 pointsBadges:
  • AS/400: Difference between member and record in physical file

    Difference between member and a record in a physical file? I am getting confused some one please explain? Source physical file vs physical file?

    vivekntt21450 pointsBadges:
  • AS/400 CLLE: Get second member from physical file

    How to get second member from a physical file through SQL query or work query?

    vivekntt21450 pointsBadges:
  • Programming languages similar to AS/400 RPGLE

    Which programming language is close to RPG OR RPGLE? I mean which language will be easy to learn when we know RPG or RPGLE?

    vivekntt21450 pointsBadges:
  • CPYFRMIMPF try copy data from a TXT file to DB file

    I am using the CPYFRMIMPF to copy data from a TXT file into a DB file, but the result is "corrupt data" or any other format unreadable, I don't know what happened, because I have done this in previous works. The first command was: CPYFRMIMPF FROMSTMF('/FILEST.TXT') TOFILE(*LIBL/TESTF)...

    eroek18220 pointsBadges:
  • AS/400: Difference between data area and data queue

    What is the difference between data area vs data queue in AS/400?

    vivekntt21450 pointsBadges:
  • Multiple AS/400 User Profiles

    Is there a way to find how many user profiles one user may have on the system? Say I have multiple profiles on the system, but don't know how many. Is there a way to find out those profiles especially if no text has been entered with the user's name.

    Rrbond07750 pointsBadges:
  • AS/400 CLLE: How to debug batch jobs

    There is a program A which calls another program B and submits the job, here how to debug the program? In simple terms how to debug batch jobs?

    vivekntt21450 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