Limiting WRKMSGQ from WRKWTR
We have some remote non technical users use the CL command WRKWTR and op 7 to restart printers. Inside that option the user can select F16=Remove all except unanswered. Sometimes they do this and it makes problem resolution somewhat difficult. Any advice on restricting the F16 option or any other...
We have some remote non technical users use the CL command WRKWTR and op 7 to restart printers. Inside that option the user can select F16=Remove all except unanswered. Sometimes they do this and it makes problem resolution somewhat difficult. Any advice on restricting the F16 option or any other...
0 pts.
"Command prompting ended when user pressed F12"
I have a CL that calls a RPG selection subfile pgm. If the user presses F12 during the selection process, I want to send a message to the user similar to the one shown in the subject line of this post. I have experimented with various settings of a SNDPGMMSG command from the CL but can't seem to...
I have a CL that calls a RPG selection subfile pgm. If the user presses F12 during the selection process, I want to send a message to the user similar to the one shown in the subject line of this post. I have experimented with various settings of a SNDPGMMSG command from the CL but can't seem to...
QBNLPGMI api examples
Hello! Can anyone please help me? I didn't work with api's, and try to get information about bounded modules in ILE C programs. And I try to use QBNLPGMI api. Does anyone have some examples of using this api in C or CL programs? Thanks in advance. Dalibor
Hello! Can anyone please help me? I didn't work with api's, and try to get information about bounded modules in ILE C programs. And I try to use QBNLPGMI api. Does anyone have some examples of using this api in C or CL programs? Thanks in advance. Dalibor
Transfer / Copy OS/2 files with Extended data attributes to iSeries
We have 1,000's of files that were originally created in OS/2. These files were created (OCR) from an image file so we could do text searches on them. OS/2 created these files with Extended Data attributes. We now need to copy these OS/2 files from an XP workstation to an iSeries networked drive....
We have 1,000's of files that were originally created in OS/2. These files were created (OCR) from an image file so we could do text searches on them. OS/2 created these files with Extended Data attributes. We now need to copy these OS/2 files from an XP workstation to an iSeries networked drive....
using QDBRTVFD to find SQL view create statement
Hello all. Just wanted to know if anyone out there knows how to use QDBRTVFD to retrieve the SQL view create statement. For our update process, I am scanning the customer's libraries to find buisiness views. When I find them, I want to extract the SQL view create statement (like in DSPFD) and...
Hello all. Just wanted to know if anyone out there knows how to use QDBRTVFD to retrieve the SQL view create statement. For our update process, I am scanning the customer's libraries to find buisiness views. When I find them, I want to extract the SQL view create statement (like in DSPFD) and...
Mainframe to SAP
Hi, I'm a cobol programmer working on Mainframes with a work exp. of 2 yrs. I've worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the...
Hi, I'm a cobol programmer working on Mainframes with a work exp. of 2 yrs. I've worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the...
Activation Groups
I am changing some CL programs and COBOL/400 programs to ILE and ran into problems with OPNQRYF. I think it is due to the fact that the default activation groups when compiling these 2 different types of programs are different, so the results of OPNQRYF are not available to COBOL program. Can I...
I am changing some CL programs and COBOL/400 programs to ILE and ran into problems with OPNQRYF. I think it is due to the fact that the default activation groups when compiling these 2 different types of programs are different, so the results of OPNQRYF are not available to COBOL program. Can I...
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...
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...
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 one job out there (1...
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 one job out there (1...
Replicating data between I-series and Ms-CRM using Scribe?
We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used...
We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used...
XLS integration to Iseries
I am looking for information on getting XLS data to the Iseries. Specifically would like to get XLS into XML format so an EDI/XML translator can pick it up and send through our existing EDI processes. The XLS will come from e-mail clients.
I am looking for information on getting XLS data to the Iseries. Specifically would like to get XLS into XML format so an EDI/XML translator can pick it up and send through our existing EDI processes. The XLS will come from e-mail clients.
COMMAND - parameter title
What is the way to define parameters in a command so they will be indented and displayed under a title like: Inline Options:: . Inliner . . . . . . . . . . . *OFF *OFF, *ON . Mode . . . . . . . . . . . . . *NOAUTO *NOAUTO, *AUTO . Threshold . . . . . . . . . . 250 1-65535, *NOLIMIT . Limit ....
What is the way to define parameters in a command so they will be indented and displayed under a title like: Inline Options:: . Inliner . . . . . . . . . . . *OFF *OFF, *ON . Mode . . . . . . . . . . . . . *NOAUTO *NOAUTO, *AUTO . Threshold . . . . . . . . . . 250 1-65535, *NOLIMIT . Limit ....
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
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
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 the file and...
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 the file and...
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 as follows ? job 1 process data...
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 as follows ? job 1 process data...
CL programming, command keys
In a CL program, if I use a command like DSPUSRPRF that presents a screen to the user, and has F3 and F12 keys active, how do I detect the keys the user has pressed upon exiting the command? If I am using a display file in a CL program, I know I can check indicators IN03 or IN12, but this does not...
In a CL program, if I use a command like DSPUSRPRF that presents a screen to the user, and has F3 and F12 keys active, how do I detect the keys the user has pressed upon exiting the command? If I am using a display file in a CL program, I know I can check indicators IN03 or IN12, but this does not...
Parsing spooled File.
Dear, I have to write a program to parse and analyse a spooled file on a daily basis. In other words, I have to extract some datas from the spooled file and work on those datas. Well, I would like to write this program in C or CL (not RPG) 'cause I'm from the Unix world... :-( Any ideas, or help ?...
Dear, I have to write a program to parse and analyse a spooled file on a daily basis. In other words, I have to extract some datas from the spooled file and work on those datas. Well, I would like to write this program in C or CL (not RPG) 'cause I'm from the Unix world... :-( Any ideas, or help ?...
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...
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...
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 :)
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 :)
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
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
