Did anyone use DATA structures In CL
As of V5R4 it is possible to use Data structures in CL similar to RPG. The most useful thing to use is for qualified commands where the qualifie parameter is a File and Libraray. but itl looks to me that it does not work when the parameter is a data structure and the program is CLLE. in CL it...
As of V5R4 it is possible to use Data structures in CL similar to RPG. The most useful thing to use is for qualified commands where the qualifie parameter is a File and Libraray. but itl looks to me that it does not work when the parameter is a data structure and the program is CLLE. in CL it...
60 pts.
CPYTOIMPF 'To File' problem
The following command: ===> CPYTOIMPF FROMFILE(LTCLIB/WPELG01P) TOFILE(LTCLIB/WPELGCSV) MBROPT(*REPLACE) STRDLM(*NONE) produces error To-file WPELGCSV in LTCLIB not allowed. The explanation says the To file must be an externally defined PF, which it is. I need to remove the double quote...
The following command: ===> CPYTOIMPF FROMFILE(LTCLIB/WPELG01P) TOFILE(LTCLIB/WPELGCSV) MBROPT(*REPLACE) STRDLM(*NONE) produces error To-file WPELGCSV in LTCLIB not allowed. The explanation says the To file must be an externally defined PF, which it is. I need to remove the double quote...
Virtual Tape CL Program
Does anyone have an example cl using virtual tape for backup. I have tested with this but am looking for a way to incorporate into a custom cl backup procedure.
Does anyone have an example cl using virtual tape for backup. I have tested with this but am looking for a way to incorporate into a custom cl backup procedure.
ISeries ODBC Connection to Microsoft Word
Does any one know how to create an CL or a script to run Microsoft Word Merge feature with Iseries ODBC Connection
Does any one know how to create an CL or a script to run Microsoft Word Merge feature with Iseries ODBC Connection
Nasty bug on new function of V5R4
as of V5R4 - DCL supports the STG (storage) keyword, which lets you designate how a variable's storage is to be allocated. STG(*DEFINED) tells the compiler that a variable overlays all or part of another variable. You'll also need to use the DEFVAR (defined on variable) keyword to tell which...
as of V5R4 - DCL supports the STG (storage) keyword, which lets you designate how a variable's storage is to be allocated. STG(*DEFINED) tells the compiler that a variable overlays all or part of another variable. You'll also need to use the DEFVAR (defined on variable) keyword to tell which...
How to end a batch job in CLLE program?
I tried to end a batch job in CLLE by retreiving the job attributes through RTVJOBA and ENDJOB,but it doesn't work.Can anyone tell me what is the other procedure?
I tried to end a batch job in CLLE by retreiving the job attributes through RTVJOBA and ENDJOB,but it doesn't work.Can anyone tell me what is the other procedure?
Retreiving current market price
We need to invoice our customers the cost of platinum used in some process, based on its usage in grams. I need to retreive the current market price of platinum from internet and use it in RPG program to do the calculations. How can we retreive the current market price of Platinum in a RPG/CL...
We need to invoice our customers the cost of platinum used in some process, based on its usage in grams. I need to retreive the current market price of platinum from internet and use it in RPG program to do the calculations. How can we retreive the current market price of Platinum in a RPG/CL...
command to delete a line in physical file
i want to delete the comment lines through cl program.i want to know the command for deleting a line in physical source file?
i want to delete the comment lines through cl program.i want to know the command for deleting a line in physical source file?
Determine TCP port used by a connection.
We have an application that has our iSeries(AS/400) connect to a remote IP address and port. If we have to end the application and restart it (IPL, error, end/start subsystem) the iSeries keeps the connection open. AFter the application is restarted, the TCP connections show two connections to the...
We have an application that has our iSeries(AS/400) connect to a remote IP address and port. If we have to end the application and restart it (IPL, error, end/start subsystem) the iSeries keeps the connection open. AFter the application is restarted, the TCP connections show two connections to the...
create user based on (not navigator- I know how in navigator.
How do I create a user based on another user from a cl program.
How do I create a user based on another user from a cl program.
Password reset by menu item
My help desk resets passwords through the command line and I would like to write a CL and give them a menu option and take away their command line access. Suggestions? (I am not a 400 guy)
My help desk resets passwords through the command line and I would like to write a CL and give them a menu option and take away their command line access. Suggestions? (I am not a 400 guy)
PTF exit program
I am about to write a PTF exit program in CL. I have gone through the infocenter docuementation but some questions: 1. If I have 10 PTFs and that is already been loaded using LODPTF, how many times PTF exit programs will be called if I issue APYPTF? If it is 10 times then in which sequence? I...
I am about to write a PTF exit program in CL. I have gone through the infocenter docuementation but some questions: 1. If I have 10 PTFs and that is already been loaded using LODPTF, how many times PTF exit programs will be called if I issue APYPTF? If it is 10 times then in which sequence? I...
File Size of a PF in AS/400
How to determine the file size of a a PF in AS/400. Is there a specific CL command which tells us as to how many records a file can store? Or how much more records it can accomodate before its 100% full?
How to determine the file size of a a PF in AS/400. Is there a specific CL command which tells us as to how many records a file can store? Or how much more records it can accomodate before its 100% full?
auto transfer of as400 to pc
Hi There How do I create a CL pgm to automatically transfer physical file to a PC server in csv format. Thanks for the help
Hi There How do I create a CL pgm to automatically transfer physical file to a PC server in csv format. Thanks for the help
Connection to relational database XXXX already exists.
I am trying to do a CPYFRMIMPF in a CL and am getting the following Error occurred in SQL Call Level Interface Error occurred in SQL Call Level Interface Error occurred in SQL Call Level Interface Connection to relational database XXXX already...
I am trying to do a CPYFRMIMPF in a CL and am getting the following Error occurred in SQL Call Level Interface Error occurred in SQL Call Level Interface Error occurred in SQL Call Level Interface Connection to relational database XXXX already...
Error received on CPYFRMIMPF command - SQL0842
Does anyone know what command should be run prior to the CPYFRMIMPF command to close what needs closed. Running this in a CL program.
Does anyone know what command should be run prior to the CPYFRMIMPF command to close what needs closed. Running this in a CL program.
Reading IFS file from CL program
I have a requirement of reading a IFS file from CL program. As far as I know there is no direct way of achieving this. I am planning ot use CPYFRMSTMF followed by CPYF to copy the IFS file first as a memeber and then as a database file. Is there any better way to achieve this? Regards Sudip
I have a requirement of reading a IFS file from CL program. As far as I know there is no direct way of achieving this. I am planning ot use CPYFRMSTMF followed by CPYF to copy the IFS file first as a memeber and then as a database file. Is there any better way to achieve this? Regards Sudip
Read a message Queue without loosing messages
I have developed a CL pgm, which monitors a message queue and in case a job ended abnormally message appears on that message queue, the system sends a email message to certain users. This is working fine, however the user whose message queue i monitor does not receive any message as my program...
I have developed a CL pgm, which monitors a message queue and in case a job ended abnormally message appears on that message queue, the system sends a email message to certain users. This is working fine, however the user whose message queue i monitor does not receive any message as my program...
CL - OPNQRYF
How to compare CL character field (year#) with packed decimal field(QRPS)of 3P0 length from file QRBT as equal. Please provide OPNQRYF statement for the same.
How to compare CL character field (year#) with packed decimal field(QRPS)of 3P0 length from file QRBT as equal. Please provide OPNQRYF statement for the same.
cl/400
Hi, Good morning my experts.Im kuppi.im working as a software trainee on AS/400 technology.i have also joined with ibmi5 team.im trying to convert date with cl/400 coding.I have taken 2 parameters(like date and date types). A. If suppose date type is j,Now i want to convert date to *MDY format...
Hi, Good morning my experts.Im kuppi.im working as a software trainee on AS/400 technology.i have also joined with ibmi5 team.im trying to convert date with cl/400 coding.I have taken 2 parameters(like date and date types). A. If suppose date type is j,Now i want to convert date to *MDY format...
