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
Answer Question
| September 9, 2008 3:31 PM
CL, Microsoft Word, Microsoft Word merge, ODBC, ODBC on i5
Does any one know how to create an CL or a script to run Microsoft Word Merge feature with Iseries ODBC Connection
Answer Question
| September 9, 2008 3:31 PM
CL, Microsoft Word, Microsoft Word merge, ODBC, ODBC on i5
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 variable this new variable is [...]
Answer Question
| September 14, 2008 10:55 AM
CL, CLLE, DEFVAR, STG, 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 variable this new variable is [...]
Answer Question
| September 14, 2008 10:55 AM
CL, CLLE, DEFVAR, STG, V5R4
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?
Answer Question
| September 16, 2008 6:10 AM
Batch job, CL, CLLE
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?
Answer Question
| September 16, 2008 6:10 AM
Batch job, CL, CLLE
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 [...]
Answer Question
| August 30, 2008 6:33 PM
CL, RPG
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 [...]
Answer Question
| August 30, 2008 6:33 PM
CL, RPG
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?
Answer Question
| August 26, 2008 9:55 AM
CL, 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?
Answer Question
| August 26, 2008 9:55 AM
CL, Physical 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 remote IP, and the application does [...]
Answer Question
| September 2, 2008 7:29 PM
CL, CLLE, iSeries networking, RPGLE, TCP
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 remote IP, and the application does [...]
Answer Question
| September 2, 2008 7:29 PM
CL, CLLE, iSeries networking, RPGLE, TCP
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.
Answer Question
| August 25, 2008 6:37 PM
CL, CL programs, User profiles
How do I create a user based on another user from a cl program.
Answer Question
| August 25, 2008 6:37 PM
CL, CL programs, User profiles
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)
Answer Question
| August 22, 2008 8:43 PM
AS/400, AS/400 user permissions, CL
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)
Answer Question
| August 22, 2008 8:43 PM
AS/400, AS/400 user permissions, CL
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 [...]
Answer Question
| August 22, 2008 5:32 AM
APYPTF, CL, CPF3638, Exit programs, LODPTF, PTF exit program, PTFs
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 [...]
Answer Question
| August 22, 2008 5:32 AM
APYPTF, CL, CPF3638, Exit programs, LODPTF, PTF exit program, PTFs
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?
Answer Question
| August 15, 2008 8:05 PM
CL, PF/LF
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?
Answer Question
| August 15, 2008 8:05 PM
CL, PF/LF
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
Answer Question
| August 12, 2008 9:29 AM
AS/400 import/export, CL, CSV format
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
Answer Question
| August 12, 2008 9:29 AM
AS/400 import/export, CL, CSV format
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 exists. Connection to relational database XXXX already exists. Error occurred in SQL Call [...]
Answer Question
| August 11, 2008 6:01 PM
CL, CPYFRMIMPF
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 exists. Connection to relational database XXXX already exists. Error occurred in SQL Call [...]
Answer Question
| August 11, 2008 6:01 PM
CL, CPYFRMIMPF
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.
Answer Question
| August 8, 2008 11:27 PM
CL, CPYFRMIMPF, Error 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.
Answer Question
| August 8, 2008 11:27 PM
CL, CPYFRMIMPF, Error SQL0842
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 [...]
Answer Question
| August 14, 2008 1:42 PM
CL, CL programming, CPYF, CPYFRMSTMF, IFS
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 [...]
Answer Question
| August 14, 2008 1:42 PM
CL, CL programming, CPYF, CPYFRMSTMF, IFS
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 removes the [...]
Answer Question
| August 5, 2008 12:01 PM
CL, CL/400
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 removes the [...]
Answer Question
| August 5, 2008 12:01 PM
CL, CL/400
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.
Answer Question
| August 1, 2008 7:58 AM
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.
Answer Question
| August 1, 2008 7:58 AM
CL, OPNQRYF
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 B. if date type is [...]
Answer Question
| March 27, 2011 5:37 AM
CL, CL/400, CVTDAT
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 B. if date type is [...]
Answer Question
| March 27, 2011 5:37 AM
CL, CL/400, CVTDAT
%SST
Hi, Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE(‘TCS AS/400′) DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2 after excuted of CHGVAR command.
Answer Question
| July 30, 2008 10:06 AM
AS/400 Client Access, CHGVAR, CL, CL/400, RPG, RPG/400, Variables
Hi, Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE(‘TCS AS/400′) DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2 after excuted of CHGVAR command.
Answer Question
| July 30, 2008 10:06 AM
AS/400 Client Access, CHGVAR, CL, CL/400, RPG, RPG/400, Variables
version
HI, This is ibmi5 fresher team.Please tell me what is difference between cl and rpg
Answer Question
| August 12, 2008 4:57 AM
CL, CL/400, RPG, RPG/400
HI, This is ibmi5 fresher team.Please tell me what is difference between cl and rpg
Answer Question
| August 12, 2008 4:57 AM
CL, CL/400, RPG, RPG/400
RPG/400 ,CL/400 lifecycle
Hi, Very good morning my friends.Can any body tell me rpg/400 and cl/400 life cycle.please
Answer Question
| July 30, 2008 4:54 AM
CL, CL/400, RPG, RPG/400, SDLC
Hi, Very good morning my friends.Can any body tell me rpg/400 and cl/400 life cycle.please
Answer Question
| July 30, 2008 4:54 AM
CL, CL/400, RPG, RPG/400, SDLC
