• Trigger

    Guys, we got a problem here...our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?

    Anu143525 pointsBadges:
  • QBatch subsystem Monitoring

    Hi Guys, I have requirements, I need the Job details like( Job Number, name , user) of any job as soon as they entered in Qbatch Subsystem. Do we have any API or some commands to fetch that... The only solution i m thinking is of take the *Print of WRKACTJOB command for QBATCH every minute and...

    ddaswani170 pointsBadges:
  • Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?

    Hello All, I ran into a roadblock writing a new purge process for my company. Here's the situation: I have 3 files that hold EDI Data that I need to purge: FILEA - Record Format FILEAR FILEB - Record Format FILEBR FILEC - Record Format FILECR All of the above files have the same record length,...

    Eric Witham690 pointsBadges:
  • Retreving source file names of a library

    Hi guys, I need to copy all the objects(both DB file and PGM) from a library to another library except the source file(PF-SRC). I tried DSPFD FILE([file library]/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE([outfile library]/[outfile]) then selecting those records where ATDTAT = ‘S’. But the...

    LakNar270 pointsBadges:
  • Problems using QTEMP in a CLLE

    I have a CLLE program. I'm creating a file in QTEMP. Then I do an OVRDBF to the QTEMP file. Then I call an RPGLE to output records to the QTEMP file. The records are actually going to a file in my library list, not QTEMP. How do I get a CLLE to use my QTEMP file?

    krtkrt5 pointsBadges:
  • AS400 menu options help creation

    It is DSPF with subfile that includes: Option# (up to 999, alpha-numeric) and option description(up to 30 chars.). Some options can start the other menu (nested). Thank you. yuriy44

    Yuriy4425 pointsBadges:
  • MSGW in WRKACTJOB

    How to end a job in MSGW how we can give in a program all the proces to give OPT-7 in front of a job which is in MSGW & giving 'G' to end that in RPGLE /CLLE progrm that too in a scheduled time

    Sitaratnam10 pointsBadges:
  • Want Query output into Spool file

    Hello Folks I am creating utility CLLE program based on 5 options. Inital 4 options will be RUNQRY (query name and library is fix). Queries I have already created by WRKQRY via joining various (4-5) files. 5th option is for to check spool file. Now I want to make a program that first displays the...

    pankaj2r100 pointsBadges:
  • Message status

    Hi, Can any one please tell me what are all the different job statuses in as400 like MSGW,CNDW,EVTW,DEQW,DLYW and what do they actually stand for?

    Knowledgeseekerone30 pointsBadges:
  • Suppress/trailing blanks in a string variable through CLLE

    Is there possibilities to suppress leading and trailing blanks in a string variable through CLLE??

    shyedajmal285 pointsBadges:
  • EMLSTMF – Email Address

    Hi, I have used SNDDST seamlessly to send .csv files, collecting the users email address via a DSPDIRE (output to a file in QTEMP). My question is : I want to use EMLSTMF instead but how can I access the email address from DSPDIRE ? Many thanks.

    NeilD570 pointsBadges:
  • Want to make a utility to search string.

    [h3 class="groups"> Hi,[/h3] [h3 class="groups">I want to make a utility in AS400 to search a string (Such as file name/PGM name) in my current Library and in all Source physical files if found show PGM and all related files. Like I do trough find string Command. [/h3] It would be also help ful you...

    Builtin100 pointsBadges:
  • Retrive System value in CCYYMMDDHHMMSS format?

    Hi anyone tell me how to retrive system valule in format CCYYMMDDHHMMSS   in which CC in centuary?

    SMisar130 pointsBadges:
  • how to set lower and higher records in CLLE

    i want to set lower and higher records value using CLLE program.... or read first record and last record in cl....

    pdsathishkumar3,805 pointsBadges:
  • CL Data Structure Compiler Crash in CLLE

    Hi, I had a 443 byte DS defined in CL, as input Parm and with subfields, in CLLE the compiler crashed (V7R1) and in CLP compiled fine. Anyone else come across this?  

    Neilmc15 pointsBadges:
  • Problem in AS/400 string

    hi i jaust want to put following string in a variable . arsdoc delete -h CSPAY -v -i "WHERE ZHSPCODE= 'abc'" -f PRYW2E -G PRYW2E here i am picking 'abc' part from file .Suppose field is zhsp that contains this part.So string will look something like this : arsdoc delete -h CSPAY -v -i "WHERE...

    munduuu435 pointsBadges:
  • Default Font Name in AS/400

    Hi All,  Can Anyone tell me that which Font we use in As400, i mean default font nmae for As400. Thanks

    Rpgle400tech145 pointsBadges:
  • Can CL Programming language can have level check error

     hi friends in CL Program is it possible that we can get Leve Check Parameter...

    chakramdhar65 pointsBadges:
  • Source name and location for RPGLE

    I want to find out the source name and location for all objects within a library - The source types are RPGLE and CLLE. Kindof like we use the DSPOBJD for RPG sources. Thanks.

    Mandavi40 pointsBadges:
  • Trimming og spaces in CLLE

    Hi, i am using v5r4, CLLe I have creted this pgm to transfer stream file into ifs folder        PGM        Dcl Var(&Data) Type(*Char) Len(50)                    DCL VAR(&Folder) TYPE(*CHAR) LEN(30)             DCL VAR(&Filename) TYPE(*CHAR) LEN(100) /* Accessing...

    Rpgle400tech145 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