SNDDST sending to some but not other email addresses
I am using the SNDDST command to to send an attachment of size 500 kb to a user in a particular domain say daydreamer@media.com I also ensure that an additional recipient is included and this recipient would be a private email address eg ihdcsl.hotmail.com I am receiving the email to the personal address but not [...]
Answer Question
| March 17, 2006 7:13 AM
Application development, AS/400, CLP, Email, RPGLE
I am using the SNDDST command to to send an attachment of size 500 kb to a user in a particular domain say daydreamer@media.com I also ensure that an additional recipient is included and this recipient would be a private email address eg ihdcsl.hotmail.com I am receiving the email to the personal address but not [...]
Answer Question
| March 17, 2006 7:13 AM
Application development, AS/400, CLP, Email, RPGLE
Open List of Spooled Files (QGYOLSPL) API Filter Information Format OSPF0200
Our company has more than 85,000 spoolfiles to be filterd in different ways. I use List API QGYOLSPL with Filter Information Format OSPF0100 which was very qick. But to aply for a date range you have to use Format OSPF0200 where I got errors. Can anybody give a code example to flter usernames userid1 and [...]
Answer Question
| November 15, 2010 6:53 AM
DataCenter, RPGLE, Security
Our company has more than 85,000 spoolfiles to be filterd in different ways. I use List API QGYOLSPL with Filter Information Format OSPF0100 which was very qick. But to aply for a date range you have to use Format OSPF0200 where I got errors. Can anybody give a code example to flter usernames userid1 and [...]
Answer Question
| November 15, 2010 6:53 AM
DataCenter, RPGLE, Security
Robot – Change object security of fle REPPF in RBTREPLIB library
I am planning to read file REPPF from RBTREPLIB library from a program. The security of this object is setup as the following: User Object Authority *PUBLIC *EXCLUDE RBTUSER *ALL Because the way the security is setup, the program only will work for those users that complies with this security. Can I change the object [...]
Answer Question
| December 1, 2009 2:27 PM
Application development, AS/400, Development, Printing, RPG, RPGLE, Security, Software, Tech support
I am planning to read file REPPF from RBTREPLIB library from a program. The security of this object is setup as the following: User Object Authority *PUBLIC *EXCLUDE RBTUSER *ALL Because the way the security is setup, the program only will work for those users that complies with this security. Can I change the object [...]
Answer Question
| December 1, 2009 2:27 PM
Application development, AS/400, Development, Printing, RPG, RPGLE, Security, Software, Tech support
numeric field check
i have a file that has a numeric field that is being cleared early in a program if certain conditions are meet as the file is being made…i need to check later before that file is printed to see if those conditions have changed….the numeric field is the key….it’s not having zeros put in it..but [...]
Answer Question
| December 1, 2009 9:31 AM
AS/400, Data analysis, RPG, RPGLE
i have a file that has a numeric field that is being cleared early in a program if certain conditions are meet as the file is being made…i need to check later before that file is printed to see if those conditions have changed….the numeric field is the key….it’s not having zeros put in it..but [...]
Answer Question
| December 1, 2009 9:31 AM
AS/400, Data analysis, RPG, RPGLE
GDDM on V5R4
Can I display graphics on the screen Or print the graphics using GDDM on V5R4?
Answer Question
| December 1, 2009 2:24 AM
Application development, AS/400, Printing, RPG, RPGLE
Can I display graphics on the screen Or print the graphics using GDDM on V5R4?
Answer Question
| December 1, 2009 2:24 AM
Application development, AS/400, Printing, RPG, RPGLE
Search for missing Semi-colon in Free format
Is there a way in either SEU, Code400 or the LPEX editor to do a search by exclusion? I’m looking for an easy way to identify lines of code, in Free format, that are missing the semi-colon at the end.
Answer Question
| December 4, 2009 10:45 AM
RPGLE
Is there a way in either SEU, Code400 or the LPEX editor to do a search by exclusion? I’m looking for an easy way to identify lines of code, in Free format, that are missing the semi-colon at the end.
Answer Question
| December 4, 2009 10:45 AM
RPGLE
Retrieving Job Info
I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than [...]
Answer Question
| December 1, 2009 5:19 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE, Web development
I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than [...]
Answer Question
| December 1, 2009 5:19 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE, Web development
Hexadecimal
Can someone please tell me the hex value of the [TAB] key Thanks
Answer Question
| December 1, 2009 7:17 AM
Application development, AS/400, Development, PC/Windows Connectivity, Printing, RPG, RPGLE
Can someone please tell me the hex value of the [TAB] key Thanks
Answer Question
| December 1, 2009 7:17 AM
Application development, AS/400, Development, PC/Windows Connectivity, Printing, RPG, RPGLE
User Auditing/Journaling
I’m new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I’ve read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark
Answer Question
| November 30, 2009 9:39 AM
Application development, Application security, AS/400, AS/400 careers, Backup & recovery, Biometrics, CLP, Compliance, configuration, CRM, Database, DataCenter, DB2 Universal Database, Digital certificates, Disaster Recovery, Email, Encryption, Exchange, IBM Marketing Sound Off, Identity & Access Management, Instant Messaging, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Printing, provisioning, Risk management, RPG, RPGLE, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, vulnerability management, Web development
I’m new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I’ve read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark
Answer Question
| November 30, 2009 9:39 AM
Application development, Application security, AS/400, AS/400 careers, Backup & recovery, Biometrics, CLP, Compliance, configuration, CRM, Database, DataCenter, DB2 Universal Database, Digital certificates, Disaster Recovery, Email, Encryption, Exchange, IBM Marketing Sound Off, Identity & Access Management, Instant Messaging, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Printing, provisioning, Risk management, RPG, RPGLE, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, vulnerability management, Web development
cursors left open in embedded SQL
I have a problem with SQL cursors being left open, even after the “close cursor” instruction has been executed successfully (SQLSTT = ’00000′) from within an RPGIV program. There are 2 cursors within the program: 1 cursor is used for fetching the count of selected records, the other is a dynamic scroll cursor for fetching [...]
Answer Question
| November 14, 2010 5:32 PM
RPGLE
I have a problem with SQL cursors being left open, even after the “close cursor” instruction has been executed successfully (SQLSTT = ’00000′) from within an RPGIV program. There are 2 cursors within the program: 1 cursor is used for fetching the count of selected records, the other is a dynamic scroll cursor for fetching [...]
Answer Question
| November 14, 2010 5:32 PM
RPGLE
Reading a File of unknown name, format, etc.
I need advice on reading a data file in RPG where I will only know the file name, the file format, etc. at run time. I would like to use an API or something to read the file into a buffer; I could then use the QUSLFLD API to get field definitions and parse the [...]
Answer Question
| November 30, 2009 1:41 PM
DB2 Universal Database, RPGLE
I need advice on reading a data file in RPG where I will only know the file name, the file format, etc. at run time. I would like to use an API or something to read the file into a buffer; I could then use the QUSLFLD API to get field definitions and parse the [...]
Answer Question
| November 30, 2009 1:41 PM
DB2 Universal Database, RPGLE
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 [...]
Answer Question
| November 14, 2010 10:27 AM
AS/400, CLP, RPG, RPGLE
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 [...]
Answer Question
| November 14, 2010 10:27 AM
AS/400, CLP, RPG, RPGLE
How can I split job by determine no. of records ?
I have a problem. My transaction file is about 20,000 records. This file is used as input/update file. It uses a long time when we run job in day end. I want to use less time. How can I split job to 4 job and each job run only 5000 records? How can I determine [...]
Answer Question
| November 29, 2009 3:55 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
I have a problem. My transaction file is about 20,000 records. This file is used as input/update file. It uses a long time when we run job in day end. I want to use less time. How can I split job to 4 job and each job run only 5000 records? How can I determine [...]
Answer Question
| November 29, 2009 3:55 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Command Prompt Override for CL Commands
Hi, I am managing a very large project that has morphed time and time again. Presently a new release of a third-party application that requires tight coupling with various aspects of the primary application was introduced. Instead of the Jr. Programmers going back time and time again to substitute parameters in the CL Commands for [...]
Answer Question
| November 26, 2009 10:20 PM
Application development, CLP, RPG, RPGLE
Hi, I am managing a very large project that has morphed time and time again. Presently a new release of a third-party application that requires tight coupling with various aspects of the primary application was introduced. Instead of the Jr. Programmers going back time and time again to substitute parameters in the CL Commands for [...]
Answer Question
| November 26, 2009 10:20 PM
Application development, CLP, RPG, RPGLE
synchronize jobs
Hi! How can I synchronize two or more RPGLE/CL programs that are executed via SBMJOB command, in order to avoid conflicts in using files and dataareas? If you could send me an example, it’ll be greatly appreciated. Thanx in advance, Meli
Answer Question
| November 27, 2009 6:02 PM
CLP, RPG ILE, RPGLE
Hi! How can I synchronize two or more RPGLE/CL programs that are executed via SBMJOB command, in order to avoid conflicts in using files and dataareas? If you could send me an example, it’ll be greatly appreciated. Thanx in advance, Meli
Answer Question
| November 27, 2009 6:02 PM
CLP, RPG ILE, RPGLE
deal with microsoft access data base file from RPG program or clp
hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy
Answer Question
| November 28, 2009 12:45 PM
Application development, AS/400, CLP, DB2 Universal Database, RPGLE
hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy
Answer Question
| November 28, 2009 12:45 PM
Application development, AS/400, CLP, DB2 Universal Database, RPGLE
triggers
i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance
Answer Question
| November 26, 2009 12:11 PM
AS/400, CLP, Data analysis, RPG, RPGLE
i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance
Answer Question
| November 26, 2009 12:11 PM
AS/400, CLP, Data analysis, RPG, RPGLE
Insert record in subfile
How to code insertion on a new receord between 2 existing recods in a subfile ? I want to code something like a expand tree : I READC my subfile and when option code value is … I want to add some records between current & next subfile record
Answer Question
| February 3, 2006 4:01 AM
RPG, RPGLE
How to code insertion on a new receord between 2 existing recods in a subfile ? I want to code something like a expand tree : I READC my subfile and when option code value is … I want to add some records between current & next subfile record
Answer Question
| February 3, 2006 4:01 AM
RPG, RPGLE
Synon/Cool:2E – internal/external func performance question
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external function call it, [...]
Answer Question
| April 28, 2009 5:52 PM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external function call it, [...]
Answer Question
| April 28, 2009 5:52 PM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE
ftp error codes
Hi! I’m writing a program that needs to execute the FTP command n times (where n is determined by the value of some field in a DDS table), only if there is an error during one of those executions. The question is: how can I determine if the execution failed? Thanks a lot! Meli
Answer Question
| March 28, 2006 2:25 PM
CLP, RPG ILE, RPGLE
Hi! I’m writing a program that needs to execute the FTP command n times (where n is determined by the value of some field in a DDS table), only if there is an error during one of those executions. The question is: how can I determine if the execution failed? Thanks a lot! Meli
Answer Question
| March 28, 2006 2:25 PM
CLP, RPG ILE, RPGLE
