Performance tunning in iseries
Hi everyboby, How to do performance tunning in iseries ?Corrently we are using V5R3.Now a days system is going slow.anybody have CL program to do performance tunning.Or give same easy steps to do this. “Thanks in advance” Regards, Baskar M.
Answer Question
| May 7, 2010 10:45 AM
CL, iSeries performance, V5R3
Hi everyboby, How to do performance tunning in iseries ?Corrently we are using V5R3.Now a days system is going slow.anybody have CL program to do performance tunning.Or give same easy steps to do this. “Thanks in advance” Regards, Baskar M.
Answer Question
| May 7, 2010 10:45 AM
CL, iSeries performance, V5R3
Selecting a UserProfile
Friends, I have this CL and this CL select all users on this command: WRKSPLF SELECT(*ALL) OUTPUT(*PRINT) In a parameter (30 days) I retain all spooled files that users. I have a unique User to and this needs reatins Your spooled file by 90 dias. How can I select this condition on my CL ? [...]
Answer Question
| July 24, 2008 2:34 PM
CL, WRKSPLF
Friends, I have this CL and this CL select all users on this command: WRKSPLF SELECT(*ALL) OUTPUT(*PRINT) In a parameter (30 days) I retain all spooled files that users. I have a unique User to and this needs reatins Your spooled file by 90 dias. How can I select this condition on my CL ? [...]
Answer Question
| July 24, 2008 2:34 PM
CL, WRKSPLF
delete records from a directory with IFS root using CL
How to delete records from a directory with IFS root using CL based on the timestamp of the records.
Answer Question
| May 6, 2010 6:55 AM
CL, IFS, Timestamp
How to delete records from a directory with IFS root using CL based on the timestamp of the records.
Answer Question
| May 6, 2010 6:55 AM
CL, IFS, Timestamp
can Synon create a CL code
How CL code is implemented in Synon
Answer Question
| April 23, 2010 8:49 PM
CL, Synon
How CL code is implemented in Synon
Answer Question
| April 23, 2010 8:49 PM
CL, Synon
how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.
how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL
Answer Question
| August 15, 2008 6:09 AM
Batch job, CL, Flat files, PF/LF
how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL
Answer Question
| August 15, 2008 6:09 AM
Batch job, CL, Flat files, PF/LF
What is the best way to execute SQL statements in a CL program.
What is the best way to execute SQL statements in a CL program. We can run sql statements in a RPG program. I want to delete some records from a file using the sql delete statement then organize it.
Answer Question
| June 22, 2011 5:24 PM
CL, CLP, SQL statements
What is the best way to execute SQL statements in a CL program. We can run sql statements in a RPG program. I want to delete some records from a file using the sql delete statement then organize it.
Answer Question
| June 22, 2011 5:24 PM
CL, CLP, SQL statements
RTVDSKINF
Hi Friends, I have a Cl and this CL contains this lines: PGM PARM(&RTV) DCL VAR(&SISTEMA) TYPE(*CHAR) LEN(10) DCL VAR(&PFILE) TYPE(*CHAR) LEN(10) DCL VAR(&LFILE) TYPE(*CHAR) LEN(10) DCL VAR(&RTV) TYPE(*CHAR) LEN(4) RTVNETA SYSNAME(&SISTEMA) MONMSG MSGID(CPF0001) IF COND(&RTV *EQ ‘*YES’) THEN(RTVDSKINF) IF COND(&SISTEMA *EQ ‘GBO270I’) THEN(DO) CHGVAR VAR(&PFILE) VALUE(DSKUTILIZ) CHGVAR VAR(&LFILE) VALUE(DSKUTILLF) ENDDO The question is: How [...]
Answer Question
| August 18, 2008 1:22 PM
CHGDFTCMD, CL, RTVDSKINF
Hi Friends, I have a Cl and this CL contains this lines: PGM PARM(&RTV) DCL VAR(&SISTEMA) TYPE(*CHAR) LEN(10) DCL VAR(&PFILE) TYPE(*CHAR) LEN(10) DCL VAR(&LFILE) TYPE(*CHAR) LEN(10) DCL VAR(&RTV) TYPE(*CHAR) LEN(4) RTVNETA SYSNAME(&SISTEMA) MONMSG MSGID(CPF0001) IF COND(&RTV *EQ ‘*YES’) THEN(RTVDSKINF) IF COND(&SISTEMA *EQ ‘GBO270I’) THEN(DO) CHGVAR VAR(&PFILE) VALUE(DSKUTILIZ) CHGVAR VAR(&LFILE) VALUE(DSKUTILLF) ENDDO The question is: How [...]
Answer Question
| August 18, 2008 1:22 PM
CHGDFTCMD, CL, RTVDSKINF
how to pass DATA AREA to RPGLE PROGRAM
hi, I have one data area called ABC of type *CHAR length is 10 in that i have some data i want pass that data area to RPGLE program as parameter, with in RPGLE program how can i receive that data area values in my program as PLIST and i am just calling this program [...]
Answer Question
| May 4, 2010 1:05 PM
CL, CLPROGRAM, RPGLE
hi, I have one data area called ABC of type *CHAR length is 10 in that i have some data i want pass that data area to RPGLE program as parameter, with in RPGLE program how can i receive that data area values in my program as PLIST and i am just calling this program [...]
Answer Question
| May 4, 2010 1:05 PM
CL, CLPROGRAM, RPGLE
Generic rename object
Hi, I’m trying to work out a way of generically renaming objects (files in specific) on an iseries. I have a large number of files which have names that begin with a letter which needs to be changed and end in a number which also needs to be changed, for example :- Axxxxx01 Ayyyyy01 Azzzz01 [...]
Answer Question
| July 17, 2008 1:02 PM
CL, iSeries, RPG
Hi, I’m trying to work out a way of generically renaming objects (files in specific) on an iseries. I have a large number of files which have names that begin with a letter which needs to be changed and end in a number which also needs to be changed, for example :- Axxxxx01 Ayyyyy01 Azzzz01 [...]
Answer Question
| July 17, 2008 1:02 PM
CL, iSeries, RPG
results of CL commands
how can i see the result of a cl command which i execute. For example, if i executing a command runsqlstm and it says command failed. how do i see the detailed description for the same result like why the command failed
Answer Question
| July 11, 2008 7:09 AM
AS/400 errors, CL, RUNSQLSTM
how can i see the result of a cl command which i execute. For example, if i executing a command runsqlstm and it says command failed. how do i see the detailed description for the same result like why the command failed
Answer Question
| July 11, 2008 7:09 AM
AS/400 errors, CL, RUNSQLSTM
Job Information
I want to retrieve Job number & user name for a particular job name. I come to know that through ‘QUSLJOB’or ‘QUSRJOBI’ we can retrieve Job number & user name for a given job name.Is it possible ? I tried doing in the system through CL but it retrieves the current job name info running [...]
Answer Question
| May 3, 2010 6:52 AM
CL, QUSLJOB, QUSRJOBI
I want to retrieve Job number & user name for a particular job name. I come to know that through ‘QUSLJOB’or ‘QUSRJOBI’ we can retrieve Job number & user name for a given job name.Is it possible ? I tried doing in the system through CL but it retrieves the current job name info running [...]
Answer Question
| May 3, 2010 6:52 AM
CL, QUSLJOB, QUSRJOBI
EDTOBJAUT
I am no expert, but I would like to try and make my life easier. I need to find out if there is a way for me to add/edit/delete these authorities per user in a CL program for instance. I am sitting with the problem that multiple files need to be created in multiple libraries, [...]
Answer Question
| March 27, 2011 9:19 AM
CL, Edit Object Authority, EDTOBJAUT
I am no expert, but I would like to try and make my life easier. I need to find out if there is a way for me to add/edit/delete these authorities per user in a CL program for instance. I am sitting with the problem that multiple files need to be created in multiple libraries, [...]
Answer Question
| March 27, 2011 9:19 AM
CL, Edit Object Authority, EDTOBJAUT
Display from CL command?
What is the command to display something from CL?
Answer Question
| June 27, 2008 6:56 PM
CL, CL/400
What is the command to display something from CL?
Answer Question
| June 27, 2008 6:56 PM
CL, CL/400
Calling non-as/400 programs via an RPGLE or CL program
Can it be done? If so, how would I go about doing this? Let’s say I just have a small VB program I wrote that displays a picture. Can I let’s say somehow link the VB program call to a CF key, like CF08?
Answer Question
| April 29, 2010 3:44 PM
CL, RPG, RPGLE, VB
Can it be done? If so, how would I go about doing this? Let’s say I just have a small VB program I wrote that displays a picture. Can I let’s say somehow link the VB program call to a CF key, like CF08?
Answer Question
| April 29, 2010 3:44 PM
CL, RPG, RPGLE, VB
CPF1236
What would cause CPF1236 to be issued for an overnight job we submit via a CL program? CPF1236 is “Subsystem &1 cannot start prestart job &2.”
Answer Question
| June 20, 2008 1:24 PM
CL, CL programs, CPF errors, CPF1236
What would cause CPF1236 to be issued for an overnight job we submit via a CL program? CPF1236 is “Subsystem &1 cannot start prestart job &2.”
Answer Question
| June 20, 2008 1:24 PM
CL, CL programs, CPF errors, CPF1236
Rename the uploaded file….
hi all i want to rename the just uploaded file to a PC from AS400. Like what happening is that i have used some commands to upload a PF to a .txt file to a PC that are written in CLLE. now i just want to rename the file name with a longer name that [...]
Answer Question
| October 17, 2009 6:30 AM
AS/400, CL, CLLE, RPGLE
hi all i want to rename the just uploaded file to a PC from AS400. Like what happening is that i have used some commands to upload a PF to a .txt file to a PC that are written in CLLE. now i just want to rename the file name with a longer name that [...]
Answer Question
| October 17, 2009 6:30 AM
AS/400, CL, CLLE, RPGLE
CL/400 – I want to know about QRYSLT(Please see below explanation)
Hi, I am not well versed with code in CL/400, i know the concepts. I want to know what is he doing in the below code. e.g usibng the symbols ‘|>’ and ‘||’ and ‘<|’ IF COND(&TODUE7 *NE ’0000000′) THEN(DO) CHGVAR VAR(&QRYSL) VALUE(&QRYSL |> ‘ *AND (ODUDT *GE + ‘ || &FRDUE7 || ‘) *AND’) [...]
Answer Question
| April 25, 2010 3:45 PM
CL, CL/400, OPNQRYF, QRYSLT
Hi, I am not well versed with code in CL/400, i know the concepts. I want to know what is he doing in the below code. e.g usibng the symbols ‘|>’ and ‘||’ and ‘<|’ IF COND(&TODUE7 *NE ’0000000′) THEN(DO) CHGVAR VAR(&QRYSL) VALUE(&QRYSL |> ‘ *AND (ODUDT *GE + ‘ || &FRDUE7 || ‘) *AND’) [...]
Answer Question
| April 25, 2010 3:45 PM
CL, CL/400, OPNQRYF, QRYSLT
CPYF selecting a record by a variable
Hi friends, I have a CL and I dont know how making a cpyf selecting records with a variable, like this example: 5722SS1 V5R3M0 040528 Control Language DLTOLDSPLF/CARGA TDBSBC14 04/06/08 19:54:32 Page 1 Program . . . . . . . . . . . . . . . . . . . : CARGA [...]
Answer Question
| April 25, 2010 1:46 PM
AS/400, CL, CPYF
Hi friends, I have a CL and I dont know how making a cpyf selecting records with a variable, like this example: 5722SS1 V5R3M0 040528 Control Language DLTOLDSPLF/CARGA TDBSBC14 04/06/08 19:54:32 Page 1 Program . . . . . . . . . . . . . . . . . . . : CARGA [...]
Answer Question
| April 25, 2010 1:46 PM
AS/400, CL, CPYF
why we cant write data to pf using cl program?
y we cant write data to pf using cl program?
Answer Question
| June 29, 2010 6:31 AM
CL, PF/LF
y we cant write data to pf using cl program?
Answer Question
| June 29, 2010 6:31 AM
CL, PF/LF
reading values through data area except IN & RTVDTAARA ?
Is there any other way to read values through data area except Using ‘IN’Opcode in RPG and RTVDTARA command in CL? Pls. tell if it could be done in other ways in our RPG programme or in our Cl programme?
Answer Question
| May 11, 2012 6:00 AM
CL, Retrieve Data Area, RPG, RTVDTAARA
Is there any other way to read values through data area except Using ‘IN’Opcode in RPG and RTVDTARA command in CL? Pls. tell if it could be done in other ways in our RPG programme or in our Cl programme?
Answer Question
| May 11, 2012 6:00 AM
CL, Retrieve Data Area, RPG, RTVDTAARA
