OVRPRTF not working in procedure that is called
Have an RPGLE program that calls a external procedure, which does an OVRPRTF (through a RunCL function), and then prints a report. The problem is, that the OVRPRTF doesn't seem to be doing it's job. Does this have something to do with the procedure? I originally had a CL that was called (from the...
Have an RPGLE program that calls a external procedure, which does an OVRPRTF (through a RunCL function), and then prints a report. The problem is, that the OVRPRTF doesn't seem to be doing it's job. Does this have something to do with the procedure? I originally had a CL that was called (from the...
85 pts.
SENDING A BREAK MESSAGE
I HAVE WRITTEN A CL PROGRAM WHICH USES QEZSNDMG TO SEND A BREAK MESSAGE TO SPECIFIC USERS. IT WORKS PERFECTLY EXCEPT IF THE USER ISN'T SIGNED ON, HE DOES NOT GET THE MESSAGE UNLESS HE DOES A DSPMSG. IS THERE A WAY TO MAKE THE MESSAGE AUTOMATICALLY POP UP AFTER THE USER SIGNS ON?
I HAVE WRITTEN A CL PROGRAM WHICH USES QEZSNDMG TO SEND A BREAK MESSAGE TO SPECIFIC USERS. IT WORKS PERFECTLY EXCEPT IF THE USER ISN'T SIGNED ON, HE DOES NOT GET THE MESSAGE UNLESS HE DOES A DSPMSG. IS THERE A WAY TO MAKE THE MESSAGE AUTOMATICALLY POP UP AFTER THE USER SIGNS ON?
CL code to work on a spoolfile
Hi, I wish to create a database file from a spoolfile. I know how to do this using cpysplf. I don't want the user to have to track down and enter the parameters for this command because, it will always be the same printfile and user. The only variable parameter will be the spoolfile number. So...
Hi, I wish to create a database file from a spoolfile. I know how to do this using cpysplf. I don't want the user to have to track down and enter the parameters for this command because, it will always be the same printfile and user. The only variable parameter will be the spoolfile number. So...
CL coding for restart after abort
I am looking for examples of how to code a CL program to restart at the appropriate job step after an abort. The technique involves saving the last successfully completed step into a *DTAARA. This is done throughout the CL. Then when the CL job is restarted, the first thing the CL does is...
I am looking for examples of how to code a CL program to restart at the appropriate job step after an abort. The technique involves saving the last successfully completed step into a *DTAARA. This is done throughout the CL. Then when the CL job is restarted, the first thing the CL does is...
AS400 disk initialize info
Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of "COMLETED SUCCESSFULLY" I need more infomation like model, serial no, sectors or some proof that this particular disk...
Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of "COMLETED SUCCESSFULLY" I need more infomation like model, serial no, sectors or some proof that this particular disk...
OPNQRY Question
A user crashed when using a filter selection in an interactive program... The problem, it turns out, is that the program uses an OPNQRY (embedded in an RPGLE Pgm). One of the fields is skunumb, which in this case, the user entered a ' (apostrophe) and got this error: Character ''' not valid...
A user crashed when using a filter selection in an interactive program... The problem, it turns out, is that the program uses an OPNQRY (embedded in an RPGLE Pgm). One of the fields is skunumb, which in this case, the user entered a ' (apostrophe) and got this error: Character ''' not valid...
Access remote files from a CL program
Hi! I need to create a CL program that must be able to connect to another iSeries server, execute a query or something like that to filter a file from this server, and send this output file to the iSeries that's running the program. Is there any way I could do that? An example would be greatly...
Hi! I need to create a CL program that must be able to connect to another iSeries server, execute a query or something like that to filter a file from this server, and send this output file to the iSeries that's running the program. Is there any way I could do that? An example would be greatly...
Scheduling Batch Job (Files in Multiple Libraries)
Dear All, I need to schedule a batch job, In which I would call a program to run, it will call another program which exists in other library. And program updates the data in files in Multiple Libraries. If I schedule the Job, which calls main program, again while main program calling another...
Dear All, I need to schedule a batch job, In which I would call a program to run, it will call another program which exists in other library. And program updates the data in files in Multiple Libraries. If I schedule the Job, which calls main program, again while main program calling another...
SQL
I have a beginner SQL question. I'm new to using SQL on the iseries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to...
I have a beginner SQL question. I'm new to using SQL on the iseries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to...
Emailing from iSeries with multiple attachments
I am looking for a way to send an email from the iSeries with multiple attachements. The attachments are documents (.doc, .pdf, etc.) in the IFS not spool files. SNDDST only allows one attachment and most of the other options I have seen involve spool files. Does anyone know how this can be...
I am looking for a way to send an email from the iSeries with multiple attachements. The attachments are documents (.doc, .pdf, etc.) in the IFS not spool files. SNDDST only allows one attachment and most of the other options I have seen involve spool files. Does anyone know how this can be...
Stored Procedures called from RPG programs
I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account. We have a excel report and subfile screen that runs off a green screen that needs to retreive this same...
I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account. We have a excel report and subfile screen that runs off a green screen that needs to retreive this same...
Reg Data extraction from one environment to another
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data...
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data...
AS400 intreface with other platforms
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example
Getting job log info into RPGLE program
I'm looking for an easy way to get "error" information from the job log into my RPGLE Program. I'm "monitoring" a CHAIN to a file for an "unable to allocate" error, and would like to pop-up a window to display who is locking the record. How do I go about doing this? Thanks
I'm looking for an easy way to get "error" information from the job log into my RPGLE Program. I'm "monitoring" a CHAIN to a file for an "unable to allocate" error, and would like to pop-up a window to display who is locking the record. How do I go about doing this? Thanks
using SQL statements..............
Hi All, I have a problem. I have a string variable STR which contains SQL statements...... Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable...means I update the values of library and files at run time...in the variable STR.. I want to execute the SQL statements...
Hi All, I have a problem. I have a string variable STR which contains SQL statements...... Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable...means I update the values of library and files at run time...in the variable STR.. I want to execute the SQL statements...
Front End Development for AS400
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...
Using two same files from different libraries in a RPGLE program.
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I...
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I...
Is it possible to reorganize a very big transaction in one night?
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?
Renaming a file in the IFS directory
I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, for example it...
I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, for example it...
Never Ending Program
I have a program which updates several A/R balance files. This program needs to run continuously every so many seconds to update our customers' balances. How can I make this program a never ending program?
I have a program which updates several A/R balance files. This program needs to run continuously every so many seconds to update our customers' balances. How can I make this program a never ending program?
