• Extract the list of file names (just the names) from Zip file which is available on remote server

    I want to retrieve file names from zip file which is available on remote server. Please share your experiences if anyone has ever come across this problem.

    PreetMaan85 pointsBadges:
  • AS/400: *YMD0 TEST (DE) character date not working in 7.1?

    I'm getting an error while compiling this program with date format. I'm using V7r1 version. Please help me on this.

    vinaykumar1112135 pointsBadges:
  • I want to sort the data with SQL Query.

    I want to sort the data on customer table on Address field. Address field contains data like this: Address Preet Street ,India. John Street, India. 34 cyber tower,Hyderabad. 2 keivn road, Bangalore. I used the below query to sort the data. Select address from customer order by address Below are the...

    PreetMaan85 pointsBadges:
  • I have never seen this before in AS/400

    Something very interesting and mysterious in AS/400. The below set of statements are getting execute in sequence. As soon as the statement no.4 which is calling program named as CMS002(RPGLE PGM) gets executed cursor returns back to statement no. 2 which is CPYF and program fails with error...

    PreetMaan85 pointsBadges:
  • What will be the type of Copybook for RPGLE Prototype Defination Member??

    I want to put RPGLE Prototype Defination in one Member(say Mbr1) and then want to use it in other modules using /copy compiler directive. But I am not getting what should be the type of MBR1??? Like RPGLE,CLP,SQLRPGLE. Please Suggest me.

    PreetMaan85 pointsBadges:
  • Undefined record type is found in file QSQLSRC

    I have one CL program CMS002CL running in production system,this program Copy the QSQLSRC source physical fileĀ from production library to QTEMP/QSQLSRC with one member say MBR1 CPYF FROMFILE(&OBJLIB/&SRCFIL) + TOFILE(QTEMP/&SRCFIL) FROMMBR(&SRCMBR) + TOMBR(*FROMMBR) CRTFILE(*YES)...

    PreetMaan85 pointsBadges:
  • AS/400 macros

    Good day. I need to run a macro question on AS/400. I'm currently using an external macro program called Macro Control (CA400 Macro v1.7.3), which enables you to copy an Excel loaded into editable fields AS400 data. My problem arises when the task that must be performed by the macro requires that I...

    WillRolon30 pointsBadges:
  • I want to retrieve the Job status. If the job is *ACTIVE,*OUTQ but RTVJOBSTS command is not available on my system.

    Any alternate way is there to retrieve the job status? I have job name,user, job number. I am working on V7R1M0.

    PreetMaan85 pointsBadges:
  • Automatically identify all group profiles that are not being utilized.

    Automatically identify all group profiles that are not being utilized. By system count how many times each group is being used

    PreetMaan85 pointsBadges:
  • How to delete duplicate records from physical file via RPGLE Program?

    Hi All, I have a requirement. I have to delete all the duplicate records from physical file Customer via RPGLE Program. Please help me. How I can achieve this? Regards Manpreet

    PreetMaan85 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