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...
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...
0 pts.
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
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
RPG400 Sample Program
Hi, I am learning RPG/400 on my own. I am looking for a sample program which will be reading a database file and showing the records on a display file and update the records through display file. I would appreciate if anyone can provide me the same. Thanks & regrads, Rajsekhar
Hi, I am learning RPG/400 on my own. I am looking for a sample program which will be reading a database file and showing the records on a display file and update the records through display file. I would appreciate if anyone can provide me the same. Thanks & regrads, Rajsekhar
Modules and Program Dependancies
Is there any command or method to find, the Number of Programs that are created with a Specific Module? Using DSPPGM, we can find the modules used to create the Pgm. But is there any command or method to find out the No of Programs , that a specific module is being attached/bound?
Is there any command or method to find, the Number of Programs that are created with a Specific Module? Using DSPPGM, we can find the modules used to create the Pgm. But is there any command or method to find out the No of Programs , that a specific module is being attached/bound?
OVRDBF in JAVA
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
How do I download posted RPG Code to my own system?
I'm new to this forum. I've found RPG code in the programmer tips area that I'd like to use on my system but can't figure out how to get it on my system other than typing it all in by hand! One topic had a clipboard function but I don't understand how to get it from the clipboard to the Qrpgsrc....
I'm new to this forum. I've found RPG code in the programmer tips area that I'd like to use on my system but can't figure out how to get it on my system other than typing it all in by hand! One topic had a clipboard function but I don't understand how to get it from the clipboard to the Qrpgsrc....
To retrieve data from a remote system
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series...
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series...
Automatic refresh of display screen
I need to have a screen refresh the data after being displayed for 30 seconds on the screen. I am displaying a subfile and need the ability to page up and down. I have tried several options, such as building the subfile, writing the control record, waiting for 30 seconds then reading the control...
I need to have a screen refresh the data after being displayed for 30 seconds on the screen. I am displaying a subfile and need the ability to page up and down. I have tried several options, such as building the subfile, writing the control record, waiting for 30 seconds then reading the control...
Detail FNTCHRSET lost with variable line in POSITION
We have varying fonts used on a form. When we specify the POSITION exactly, the FNTCHRSET is used for printing as requested. However, if we use a variable for the line in POSITION, the FNTCHRSET seems to be ignored. Example which prints fine using Helvetica Italic Bold: ------------ A R...
We have varying fonts used on a form. When we specify the POSITION exactly, the FNTCHRSET is used for printing as requested. However, if we use a variable for the line in POSITION, the FNTCHRSET seems to be ignored. Example which prints fine using Helvetica Italic Bold: ------------ A R...
ANNOUNCEMENT ? MORE NEW CATEGORIES ADDED TO THE ISERIES CATEGORY
UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security...
UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security...
SQL taking the lead?
Lately there has been a lot of talk about the number of people seeking an SQL education. Are you an RPG guru that?s interested in learning a little more about SQL? Let us know. -- Debra Tart, associate editor, Search400.com
Lately there has been a lot of talk about the number of people seeking an SQL education. Are you an RPG guru that?s interested in learning a little more about SQL? Let us know. -- Debra Tart, associate editor, Search400.com
Program-described Printer file in RPG ILE
1. Why can't I view all the columns in my report from my spoolfile? 2. Is there any way to view all columns in my report as defined in the RPG ILE program with the printer file being program-described? Inputs: -when I ran the report, only up to 132 columns can be viewed from my spoolfile. -This is...
1. Why can't I view all the columns in my report from my spoolfile? 2. Is there any way to view all columns in my report as defined in the RPG ILE program with the printer file being program-described? Inputs: -when I ran the report, only up to 132 columns can be viewed from my spoolfile. -This is...
verify data file
Hi everyone! I've a CL program that copies a spool file into a PF file. Is there any way to compare both files, in order to assure they have the same information? Thanx in advance :) Meli
Hi everyone! I've a CL program that copies a spool file into a PF file. Is there any way to compare both files, in order to assure they have the same information? Thanx in advance :) Meli
Using SQLRPG on a DDM File
Hi, I need to access a DDM file via SQLRPG -since SQL does not directly support DDM -can it be done by first using OVRDBF on the DDM file to override it to a local file and then use SQLRPG ? Help would be much appreciated for a project I am currently working on. Thank you! Ruwan
Hi, I need to access a DDM file via SQLRPG -since SQL does not directly support DDM -can it be done by first using OVRDBF on the DDM file to override it to a local file and then use SQLRPG ? Help would be much appreciated for a project I am currently working on. Thank you! Ruwan
Anyone ever use the SNDRPY command in CL?
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply "I" to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change it after hours. I found the SNDRPY command...
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply "I" to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change it after hours. I found the SNDRPY command...
Retrieve Job Lock (QWCRJBLK) thread ID
Does anyone know how I would get the thread ID of another job in order to retrieve the job lock info? This is the fifth parameter of QWCRJBLK. I will be using the QUSLOBJ API to retrieve all jobs on the system and then want to determine certain locks on those jobs. QUSLOBJ does not appear to...
Does anyone know how I would get the thread ID of another job in order to retrieve the job lock info? This is the fifth parameter of QWCRJBLK. I will be using the QUSLOBJ API to retrieve all jobs on the system and then want to determine certain locks on those jobs. QUSLOBJ does not appear to...
SET verb in COBOL
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE 'A', 'B', 'C'. 88 NOT-VALID-VALUES VALUE 'D', 'E', 'F'. If I want to set the value...
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE 'A', 'B', 'C'. 88 NOT-VALID-VALUES VALUE 'D', 'E', 'F'. If I want to set the value...
RPG/ILE re-entering workforce
I am 45 & want to re-enter workforce after 3 years out of IT. I used RPG for 15 years(not even ILE) and have BPCS experience. I have just picked up a couple of books (SQL and Free-format RPG) to study at home. I think it will be very difficult to get back in .... any ideas/hints/tips would be...
I am 45 & want to re-enter workforce after 3 years out of IT. I used RPG for 15 years(not even ILE) and have BPCS experience. I have just picked up a couple of books (SQL and Free-format RPG) to study at home. I think it will be very difficult to get back in .... any ideas/hints/tips would be...
write in a PF file
Hi everyone! I have an RPGLE program that creates four physical files (using the QCMDEXC program). These physical files have no DDS. In the same program, I read another physical file (that's a copy of a spool file). If the line (s) read met some specified criteria, it needs to be written to one of...
Hi everyone! I have an RPGLE program that creates four physical files (using the QCMDEXC program). These physical files have no DDS. In the same program, I read another physical file (that's a copy of a spool file). If the line (s) read met some specified criteria, it needs to be written to one of...
How to operating with Multiple Member PF in RPG ?
I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...
I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...
