• 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:
  • Add more than one parameter in URL called from AS400

    i have a probelm which when my CLP use STRPCCMD to open the URL it pass one parameter only and when i add & to another one , it always read first parameter only, how can i add the secound parameter with using & so HTML can read it

    Yadel5 pointsBadges:
  • Limiting User Abilities

    We have an administrator here that we are trying to limit access on and I wanted to know if anyone else has solved this issue. I spoke with IBM and we have restricted the access to ADDUSRPRF and DLTUSRPRF commands and we have also restricted access to certain user profiles like QSECOFR and QSYSOPR....

    Rayne42710 pointsBadges:
  • DB2 Stored Procedure V4R4 without ILE C/400

    We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we've run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we've been...

    MODMOD0 pointsBadges:
  • Calling CL program fron a C/400 program?

    Dear, I'm very new in C/400 developement and I'm facing an issue. I've some CL program that I would like to call in my C/400 program... Well, ok, I can use the function "error=system(...)"... but my CL program as to return me some information. Here is my CL prgram: PGM PARM(&queue &queue_lib &sens)...

    PierreLG45 pointsBadges:
  • command execution

    thanks a lot!! for the help... but meanwhile i have got another problem...in my project- i have to use COMPILE commands such as CRTPF, CRTCLPPGM, CRTRPGPGM and so on...in a program and this has to be transparent to the user. in CL these programs cannot be used... how can i do this? plz help me out!

    Sairolla0 pointsBadges:
  • Retreive program atrributes and save information in a file

    I need to create a program that will check the activation group for all our ILE programs. I know that using DSPPGM command I can see the activation group for a specific object. Is there a way that I can have similar results but have the information stored in a file? Then I can read the file and...

    MayraPR5 pointsBadges:
  • How do I read a File to end active jobs within my CLP?

    First I would like to say thanks to Tom for always helping. Info: I performed a wrkactjob job(joblog*) and created a spool file based on the results, then I copied that to a pf file call myfile (all within a CLP). I would like to end the jobs that show up in myfile, but im a little lost again. I...

    lotofbad205 pointsBadges:
  • Debug batch job

    hi all,     how to debug batch job please give me in details... thnx

    chakramdhar60 pointsBadges:
  • Reorganization of V5R4 while active

    We are currently on operating system V5R4. We are a 24/7 shop and as a result, I have not had the opportunity to do a lot of reorgs. I just discovered there is a reorg while active command. Can someone tell me how to use this? Does this come with the operating system or is it a separate module we...

    GHENDER190 pointsBadges:
  • Passing parameter to Query Manager

    I have the following query manager that errors with the following statement that is being placed in the CLP program: Type a value for variable "SELECT" and press Enter. This value should have been passed by the CLP program: *************** Beginning of data ************************************ PGM...

    a1maida150 pointsBadges:
  • Retrieving system name using a CLP

    How to retrieve the iseries or AS400 SYSTEM NAME USING A clp program?

    MELINDAD5 pointsBadges:
  • Is there a way to automate the ‘Receive Files from Host’ command’?

    I need to automatically run the Receive Files from Host command after business hours. Is there a CLP command to accomplish this with an example? Thanks, LWK

    Lwk25 pointsBadges:
  • Using the command RCVMSG

    There are numerous reports which automatically print throughout the day. Often there may be a message waiting on the printer and because no one was expecting any reports, no one discovers the problem until hours later. (By this time there may be quite a few reports waiting to print) I was...

    GHENDER190 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