Performance issue
Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method...
Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method...
5 pts.
compile commands in RPG
hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can i achieve...
hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can i achieve...
command execution
thanks a lot!! for the help... but meanwhile i have got another problem...in my project- i have to use COMPILE commands such as CRTPF, CRTCLPPGM, CRTRPGPGM and so on...in a program and this has to be transparent to the user. in CL these programs cannot be used... how can i do this? plz help me...
thanks a lot!! for the help... but meanwhile i have got another problem...in my project- i have to use COMPILE commands such as CRTPF, CRTCLPPGM, CRTRPGPGM and so on...in a program and this has to be transparent to the user. in CL these programs cannot be used... how can i do this? plz help me...
Program Status Data Structure
Hi All, For position 191 - 198 in the SDS, is this always the Date the Job Entered the system? For example, we have a CL that starts at 23:50 on say 5/10, it does some processing and on the way out it calls an RPG at say 0:35 on 5/11. Will the date in positions 191-198 reflect 5/10 or 5/11...
Hi All, For position 191 - 198 in the SDS, is this always the Date the Job Entered the system? For example, we have a CL that starts at 23:50 on say 5/10, it does some processing and on the way out it calls an RPG at say 0:35 on 5/11. Will the date in positions 191-198 reflect 5/10 or 5/11...
souce file listing
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File...i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me...
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File...i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me...
Web (HTML) command prompting utilizing the QCDRCMDD output
I would like to prompt OS/400 commands on the web using HTML (or any other web tool). I assume the best way to do it is by generating the XML file using the QCDRCMDD (Retrieve Command Definition) API and utilizing it using some kind of prompting tool. I know how to generate the XML file. I wonder...
I would like to prompt OS/400 commands on the web using HTML (or any other web tool). I assume the best way to do it is by generating the XML file using the QCDRCMDD (Retrieve Command Definition) API and utilizing it using some kind of prompting tool. I know how to generate the XML file. I wonder...
Communication between 2 AS/400s
We have the Softlanding product Turnover to do our change management. Our development machine is in a different building and we distribute our software using that tool via FTP. From development to production machine we use a VPN tunnel (note this is controlled by network people). The software...
We have the Softlanding product Turnover to do our change management. Our development machine is in a different building and we distribute our software using that tool via FTP. From development to production machine we use a VPN tunnel (note this is controlled by network people). The software...
Record locking (or lack of it)
Bare with me a minute before you throw rocks, but is there a difference in record locking between a Chain and Read? Here's what I'm looking at. We have a control file that contains the next note number. In all our applications we either chain or setll/read the control file, get the number, add...
Bare with me a minute before you throw rocks, but is there a difference in record locking between a Chain and Read? Here's what I'm looking at. We have a control file that contains the next note number. In all our applications we either chain or setll/read the control file, get the number, add...
AS400 Console
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to disconnect it...
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to disconnect it...
Delete files from IFS based on last used age
I need a non-C program that will delete files from a directory and its subdirectories in the IFS based on a user specified number of days since the last time it was used. Does anyone have such a program or product (or a suggestion for the easiest way to accomplish this)?
I need a non-C program that will delete files from a directory and its subdirectories in the IFS based on a user specified number of days since the last time it was used. Does anyone have such a program or product (or a suggestion for the easiest way to accomplish this)?
opnqryf problem with grouping
This is my code. I keep getting an error that says the hours field cannot be used. I don't know why it is any different than my other nemeric fields. The field is defined as 12 with 2 dec positions.It is packed. Any suggestions? 11200 - OVRDBF FILE(ELE728PF3) SHARE(*YES) ...
This is my code. I keep getting an error that says the hours field cannot be used. I don't know why it is any different than my other nemeric fields. The field is defined as 12 with 2 dec positions.It is packed. Any suggestions? 11200 - OVRDBF FILE(ELE728PF3) SHARE(*YES) ...
Number of records in the Flat file
I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!
I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!
Generating Excel spread sheets from Sequel on the iseries
I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter 013, the...
I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter 013, the...
Monitoring Tape Drives
Hello everybody, Well, I'm trying to write in C or CL a program that will monitor the different Tape Drives to know when and by who the drives are vary on and vary off. Does anyone as an example or can give me some infos to start because I'm really lost... Thanks in advance, Pierre.
Hello everybody, Well, I'm trying to write in C or CL a program that will monitor the different Tape Drives to know when and by who the drives are vary on and vary off. Does anyone as an example or can give me some infos to start because I'm really lost... Thanks in advance, Pierre.
Update Client Access Automatically
I want to automatically update iSeries Access for Windows on each of our users PC (70) with new updated versions. I have found some documents that help to some extent. I have been able to create a response file that contains all of the commands/prompts needed to update. When I go into Client Access...
I want to automatically update iSeries Access for Windows on each of our users PC (70) with new updated versions. I have found some documents that help to some extent. I have been able to create a response file that contains all of the commands/prompts needed to update. When I go into Client Access...
AS400 files created using DDS
Is there a way of creating specific non-display fields within an AS400 physical file created via DDS SRC?
Is there a way of creating specific non-display fields within an AS400 physical file created via DDS SRC?
Determine Java Version from RPG
I have multiple solutions dependent upon the version of java or the lack of java on an iSeries, all controlled from RPG. From RPG,how can I determine if java is installed on the machine and if installed, what version? Any ideas?
I have multiple solutions dependent upon the version of java or the lack of java on an iSeries, all controlled from RPG. From RPG,how can I determine if java is installed on the machine and if installed, what version? Any ideas?
Sending pcn files to the iseries
I have excel files on our server that I pass to the iseries as physical files. I do this through Client access ustn the data transfer to ISeries utility. I provide the PC location and file name, the system I wnat to go to and the library and file in the Iseries I want to wind up in. Does anyone...
I have excel files on our server that I pass to the iseries as physical files. I do this through Client access ustn the data transfer to ISeries utility. I provide the PC location and file name, the system I wnat to go to and the library and file in the Iseries I want to wind up in. Does anyone...
iseries, application degv, change control or management
Look for some input in to best ways of handling change control change management on iseries. segregation of duties compliance, best way to move development changes from test environement in to prodcution, without having to have devlopement team having access to both. Maybe using a software...
Look for some input in to best ways of handling change control change management on iseries. segregation of duties compliance, best way to move development changes from test environement in to prodcution, without having to have devlopement team having access to both. Maybe using a software...
Dynamically declaring files in RPGLE
I want to declare files in rpgle depending on the user choice entered from a display screen Is it possible to dynamically declare files.
I want to declare files in rpgle depending on the user choice entered from a display screen Is it possible to dynamically declare files.
