Forum: CLP/CLLE

I need to automate my month end process and one of the areas is to put the jobs on hold in the work job scheduler(WRKJOBSCDE). Does oneone have a suggestion on how I do that. Put the jobs on hold in the work job scheduler during the month end and then releasing the jobs? Thanks, DAC

Hi, I have a cl (not clle) in which I need to read the same file twice. During the conception phase, I thought I could use posdbf to reposition the file after the first go through so I said "no problem" to the powers that be but, I later found out that that is only for opnqryf, ugh! How do I...

How do I retrieve the IP address of a machine via a CL program? I checked RTVJOBA but it's not there, so I checked RTVNETA and it's not there either.

Hi All, How to put job date ( RTVJOBA) to dataare(length 6 of *DEC) using clprogram.? Many thanks in advance!! Sudha..

Hi All, How we can achieve FTP using CLLE. Basically I want to transfer library from one system to other by CLLE program. I want FTP to be automated. Please let me know if anyone having knows this. That would be great if sample code is there. Thanks in advance....

I am looking for a way to send an email with the title having a potentially different color based on a condition. I have a cobol program that calls a Cl that does the following command SNDDST TYPE(*LMSG) TOINTNET((&EMAIL)) + DSTD(&SUBJECT) LONGMSG(&MSGLNE)) The...

hi to everyone..... i am generating report daily....we need to give the FROM and TO date through the display file,then it was moved to the file from and to date...using this file we ran one program and the report was generated....and extract the report we send it to clients....it is possible to...

Hi Guys, Hope you all are doing good.. I found a link in the net which has a program to Output WorkActive Jobs to file. Clicky PGM PARM(&SBS &JOB) DCL VAR(&SBS) TYPE(*CHAR) LEN(10) ...

I have to modify a CL program to check if a user space(UR5301SPC) still exists after an RPG program runs. I know I can use the ALCOBJ command in CL but what is the CPF indicator I use if the user space still exists. In my CL book I have CPF1002 which is cannot allocate object , CPF1040...

We are reading a physical file in CL using RCVF. Assume we have 10 records in the physical file, we want to read 1 records at a time and delete the record after processing. We want to skip this loop after 5 records and copy the remaining 5 records to another backup file for next day process....

Hi Does anyone know how to code the equivalent of STRPCCMD so that it can be run in batch? I need to execute a pc command from an AS/400 job running in batch. Many thanks

Hi i had one problem here. Iam having one file in 4 libraries.i need to do file operations( write.update,delete) as per the curlib concepts we get the changes in one library.is it possible to get the changes in all the four libraries?

Every one of us familiar with the CPYF command. We use MBROPT as *REPLACE to replace the records of the To file with the From file records. We use MBROPT as *ADD to add the records of the From File to the To File. There is one less used option called *UPDADD. This option updates the duplicate...

hi When I am trying to change password on V5R3M0 I am getting CWBSY1008 error. Error details - CWBSY1008 - General security error occured rc=8007 can some one help with this? I tried many ways but not helping out.

Hi, I thought I was being creative when someone said they wanted to see an image of an entry screen for each project and I said: "I'll just capture the screen print and make it a member in a file". (We have an application of Projects with who's working on them, what they're doing and any documents...

Hi, I'm trying to send a user, whom has requested a particular function, a message and my program needs to receive the response so I'm using RCVMSG but, which parameter of this command will the response be in?

I know you can call QSH from a CLLE command and have it redirect the output to a .TXT file in the IFS, etc... But, what if I'm just needing a "count" of records based on a where clause to determine if I need to process a file or not? Something like ... QSH( cmd "Select count(*) from XXX" ) >...

Hi, A stupid question, but I can't find an answer : How can one display OVRDBF (and PRTF/DSPF...) issued inside an activation group (OVRSCOPE = *ACTGRPDFN) of any job ? WRKJOB/DSPJOB option 15 shows only Overrides at *JOB scope. DSPJOB is able to show overrides of a given ACTGRP... but......

I wish to retrieve the job details of a submitted batch with the same CL. Any idea how I can capture that information? For example, SBMJOB CMD(X) Retrieve the Job details for the submitted job above. I want to avoid using the RTVJOBA in the job that is submitted ..

Hi All, I want to get the number of records processed by a query in CL. How can I get it? I am executing below query through RUNSQLSTM in CL. I want to get the number of records deleted by the query from file ABC. DELETE FROM ABC WHERE DATE =20091112 ; Any idea?

Hi, What is the way to read/manipulate the contents of a MEMBER in a SRCPF in a CL or Some other language program?.

Hi all, I want to know in CL language when use OPNQRYF there is any keyword that is similar to DISTINCT in SQL. I have a file with so many duplicate records and I only want to select one. Can anyone help me? Thanks so much.

Buenas, deseo en un CL, cambiar el usuario que lo esta ejecutando por otro usuario con mas derechos , al final regresar con el usuario inicial

:duh Help I am not getting the filtering from the opnqryf when it executes the runqry. Also my OVRPRTF does not work either. But, hey, it runs the query. RUNQRY QRY(MCHOBJ/DTMSGFTEMP) OVRDBF ...

How can we differentiate the OS/400 with CL/400 ?