• Printing AS/400 ouptputs in diffrent printers,results in different outcome.

    Our server is model 810 running on V5R2. We have a cheque printing program which outputs a spool which is used to print cheques.When the spool file is sent to a LEXMARK 2380/81 2390/91 series printers for print, the data is positioned perfectly in to the cheques. But we have some users who wants to...

    ISU0 pointsBadges:
  • OPNQRY File

    OPNQRYF Query Hi, I am having difficulty in figuring out the syntax for using the special keyword %values with the variables in the OPNQRYF command. Below is the &QRYSLT I used.  CHGVAR VAR(&QRYSLT) VALUE('(DQB8ST *EQ "A" *AND + DQJRCE *EQ %VALUES( ' *TCAT &MARKET + *CAT ' )) *OR (DQB8ST = "D"...

    Ankita135 pointsBadges:
  • populate the values of pagerange on chgsplfa

    i want to be able to programmatically change the values of the pagerange parameter in the chgsplfa command. there are two elements and i want to be able to access them.

    matis75 pointsBadges:
  • RPGLE Getting around recursive calls

    With proceedures I read that recursive calls are allowed.  No time to get into proceedures. clp calls, pgm1. pgm1 add function displays scrn2, then calls pgm2, pgm2 calls pgm3, pgm3 calls pgm4. pgm1 update function calls pgm4. Issue is that pgm4 can call pgm1, pgm2, pgm3, pgm5, pgm6.  On the call...

    NickHutcheson11,380 pointsBadges:
  • AS/400 tab text delimited format of physical file

    Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X'05' or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.

    Atti123135 pointsBadges:
  • SNDTCPSPLF Problem

    Hello all, I ran into an issue with SNDTCPSPLF.  Here's what the command looks like: SNDTCPSPLF RMTSYS(LOCALHOST) PRTQ('QUSRSYS/THISOUTQ') +                FILE(&SPOOLFILE) JOB(*) SPLNBR(*LAST) +                 DESTTYP(*AS400) TRANSFORM(*NO) DLTSPLF(*NO) Where...

    Dcantwell470 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:
  • Answer a monmsg from within CL?

    I have a clp that calls on a prog that sometimes issues a error message. manually i would respond with an I to ignore and all is well. Now my question, can I use monmsg msgid(mycpfmsg)to auto reply to this message. I have it monitoring inside the cl for this message since i thought that by...

    lotofbad205 pointsBadges:
  • CLP parameters overwritten

    Hi.  When I call a CLP, either from command line or from a sbmjob with alpha parameters, if I don't fill up the whole string length it's trailing blanks are overwritten by the next parameters.  Example:  PGM PARM(&P1 &P2 &P3)  DCL VAR(&P1) TYPE(*CHAR) LEN(50)  DCL VAR(&P2) TYPE(*CHAR)...

    Jsebastians15 pointsBadges:
  • OPNQRYF HOW?

    HI Everyone,  i need a idea, i have on CL program (pgm parm) a field wndate(8,0) and i need make a opnqryf (file1) compare wndate with mvdatl(8,0), but i only wanted the first 6 position (yyyymm) of both . Anyone give a idea how can i made this? OS/400 in V5R4M1 thanks in advanced.  

    BUG68235 pointsBadges:
  • what mon msg would i use in my CLP when checking for modules under my SBS?

    I have a clp that checks modules/jobs that run under my subsystems.  I'm not sure what mon message it is giving me since none is shown if the job is not active. Only thing that is shown to me is the wrkactjob screen with (No active jobs to display). I would like for when this event occurs, to...

    lotofbad205 pointsBadges:
  • SBMJOB command

    hi, I have a CLP which calls two programs A and B. A is submitted using SBMJOB command. My requirement is that after sucessfull completion of A i would like to condition program B. Is this possible? Thanks, Siddharth

    Sangay635 pointsBadges:
  • CL AS400 iSeries ILE Retrieve Source

    Is there any way to retrieve source for an ILE CL program? I'm looking for a function equivalent to the RTVCLSRC command we use for retrieving the source for a CLP ?

    RIRedCheryl0 pointsBadges:
  • How to run a command within a CLP only during a specific time frame

    I have a pgm that perfroms verious system checks and alerts me if there is a problem.  I would like to add an If statement to exclude some of the checks that fall between a certain time period and have it jump to a specific lable in the script to continue. thus skipping over the commands that do...

    lotofbad205 pointsBadges:
  • using SQL statements…………..

    Hi All, I have a problem. I have a string variable STR which contains SQL statements...... Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable...means I update the values of library and files at run time...in the variable STR.. I want to execute the SQL statements contained...

    navinnegi45 pointsBadges:
  • Stored Procedures called from RPG programs

    I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account. We have a excel report and subfile screen that runs off a green screen that needs to retreive this same data. My...

    nu40400 pointsBadges:
  • AS/400 file field usage

    is there a way to determine what fields of a file are used in an RPG and CLP program?

    Dhaloo25 pointsBadges:
  • Automate iSeries Backup Checking using CLP

    Hi there, I have created a CLP (I'm not really good at CL) that will run on request via scheduler after a backup has completed. It will check through the Hist Log looking for specific failure msgs. If it finds them it should email oncall support. Not sure if there is a better way to do it but I...

    Stefche20 pointsBadges:
  • Journal

    How can i retrieve a record from a journal so that i can update the said record to another physical file. Because i want to retrieve the record created or updated from the journal so that i can update the other file. Thank you.

    102219790 pointsBadges:
  • CL Program to vary off Network Servers (*NWS)

    Hello Can someone please help me with the following. We have an iSeries with an xSeries attached. The issue is that when we perform a scheduled IPL using the GO POWER menu, the xSeries is not being ended correctly prior to all other subsystems ending and then performing the IPL. What I am looking...

    Malcolm410 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