RPG400 Sample Program
SEE THIS CODE WHERE &PERIODO COULD BE YOUR SCREEN VAR &SELECT IS THE SQL STATMENT THE CALL AT THE END IS A RPG PROGRAM WHICH SWEEP THE RESULT FILE. ******************************************************** PGM PARM (&PERIODO) DCL VAR(&PERIODO) TYPE(*CHAR) LEN(6) DCL ...
SEE THIS CODE WHERE &PERIODO COULD BE YOUR SCREEN VAR &SELECT IS THE SQL STATMENT THE CALL AT THE END IS A RPG PROGRAM WHICH SWEEP THE RESULT FILE. ******************************************************** PGM PARM (&PERIODO) DCL VAR(&PERIODO) TYPE(*CHAR) LEN(6) DCL ...
7550 pts.
The most-watched IT questions this week: Nov. 24, 2009
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov.... just wondering!
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov.... just wondering!
Schedule bi-weekly job.
You could use a data area to hold the next date to be run. If the job runs every two weeks, you could add 14 to the data area as the last step in the process. The job would compare the system date against the data area and execute if it's the correct date. If the job runs on specific dates in...
You could use a data area to hold the next date to be run. If the job runs every two weeks, you could add 14 to the data area as the last step in the process. The job would compare the system date against the data area and execute if it's the correct date. If the job runs on specific dates in...
installing DDM link between two as400, problem when using DDM through IP
I guess DDM/SNA is still supported. You should be able to use SNA over IP. However, IP is preferable. You may have security issues. Check CHGDDMTCPA and check for the password required parameter. Beni ========================================================= If "a remote host refused an...
I guess DDM/SNA is still supported. You should be able to use SNA over IP. However, IP is preferable. You may have security issues. Check CHGDDMTCPA and check for the password required parameter. Beni ========================================================= If "a remote host refused an...
OVRDBF in JAVA
Execute command OVRDBF MYFILE OTHERMBR where OTHERMBR is the one you wish to insert records into. Do this before doing anything with SQL. ========================================================== An ALIAS might be a good idea, but be aware that it creates a permanent (SQL) object. An OVRDBF...
Execute command OVRDBF MYFILE OTHERMBR where OTHERMBR is the one you wish to insert records into. Do this before doing anything with SQL. ========================================================== An ALIAS might be a good idea, but be aware that it creates a permanent (SQL) object. An OVRDBF...
JDBC connection to DB2/400
There is no maximun number of connections. If your running the application now, then the question is are you have any performance issues? If you are, then you need to to the analysis to determine the cause and cure.
There is no maximun number of connections. If your running the application now, then the question is are you have any performance issues? If you are, then you need to to the analysis to determine the cause and cure.
How to list Journaled files to an Outfile
Here are two options: WRKJRNA JRN(xxxxxx) OUTPUT(*OUTFILE) DETAIL(*JRNFILE) OUTFILE(QTEMP/JRNPFS) DSPFD FILE(ICULIB/*ALL) TYPE(*ATR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFI.LE(QTEMP/JRNPFS) ==================================================== (Just in case...) WRKJRNA has OUTPUT(*OUTFILE) beginning...
Here are two options: WRKJRNA JRN(xxxxxx) OUTPUT(*OUTFILE) DETAIL(*JRNFILE) OUTFILE(QTEMP/JRNPFS) DSPFD FILE(ICULIB/*ALL) TYPE(*ATR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFI.LE(QTEMP/JRNPFS) ==================================================== (Just in case...) WRKJRNA has OUTPUT(*OUTFILE) beginning...
2 subfiles side by side
Only one subfile can be active at a time. In your case it is the last one written to the screen. You need to set up some way to toggle between them.
Only one subfile can be active at a time. In your case it is the last one written to the screen. You need to set up some way to toggle between them.
as/400 query printing with DBCS data
What software did you upgrade? If it was working before and not now, check with the vendor of the software.
What software did you upgrade? If it was working before and not now, check with the vendor of the software.
How do I download posted RPG Code to my own system?
I copy the code to my PC as a text file and then FTP it into my source code. I usually put the .txt file into my C:/ root directory. From my PC, I bring up "Run" and at the command prompt, I key in ftp '111.111.111.111' to get to my iSeries. Once in ftp, I key "put xyzsource.txt...
I copy the code to my PC as a text file and then FTP it into my source code. I usually put the .txt file into my C:/ root directory. From my PC, I bring up "Run" and at the command prompt, I key in ftp '111.111.111.111' to get to my iSeries. Once in ftp, I key "put xyzsource.txt...
Iseries Ftp Server
I don't think your going to be able to do this using native os/400 commands. However I think there might be away to install an open FTP server into QP2TERM(PASE) or QSH, as long as you set the server to answer on a different port ex not port 21. Check out http://www.openssh.com/ and you would...
I don't think your going to be able to do this using native os/400 commands. However I think there might be away to install an open FTP server into QP2TERM(PASE) or QSH, as long as you set the server to answer on a different port ex not port 21. Check out http://www.openssh.com/ and you would...
Delete and Update in Query Magager
I do not believe QM supports updates. You should switch to use the RUNSQLSTM. ======================================================= Run STRQM and take option 10 (Work with Query Manager profiles). Position to the user profile running the QM queries; select option 2=Change. Scroll to the end of...
I do not believe QM supports updates. You should switch to use the RUNSQLSTM. ======================================================= Run STRQM and take option 10 (Work with Query Manager profiles). Position to the user profile running the QM queries; select option 2=Change. Scroll to the end of...
Field exit keyword is not working
What do you mean by "it is not happening"? Are you getting an error in your compile? Are you able to leave the field without using the field exit key? What version of the O/S are you using?
What do you mean by "it is not happening"? Are you getting an error in your compile? Are you able to leave the field without using the field exit key? What version of the O/S are you using?
iSeries Internal Battery Power unit failure, will this impact the system ?
If you are talking about a failed cache battery on a RAID card anf the SRC code is 8009 then it is a 90 day warning so you have time. If the SRC code is 8008 then the cache battery is failed already and your disk is running is degraded mode. Look at WRKDSKSTS and press F11 once and you will see...
If you are talking about a failed cache battery on a RAID card anf the SRC code is 8009 then it is a 90 day warning so you have time. If the SRC code is 8008 then the cache battery is failed already and your disk is running is degraded mode. Look at WRKDSKSTS and press F11 once and you will see...
To retrieve data from a remote system
One of my clients used to use Sockets for communicating between an AS400 and a Unix box and that worked very well. I keep meaning to "have a go" with socket programming and have seen a lot of good press on Scott Klement's tutorial at http://www.scottklement.com/rpg/socktut/index.html Hope it...
One of my clients used to use Sockets for communicating between an AS400 and a Unix box and that worked very well. I keep meaning to "have a go" with socket programming and have seen a lot of good press on Scott Klement's tutorial at http://www.scottklement.com/rpg/socktut/index.html Hope it...
Automatic refresh of display screen
Hi, There is a facility to link the display of data on a display to a data queue. The system will then notify you through the data queue if data was received from the display device. Have a look at the OVRDSPF command where you specify the data queue name. Your main display program will wait for...
Hi, There is a facility to link the display of data on a display to a data queue. The system will then notify you through the data queue if data was received from the display device. Have a look at the OVRDSPF command where you specify the data queue name. Your main display program will wait for...
IBM: Another money-grabbing company?
While I agree with you that it's silly to put a cap on the processing power of the iSeries, it is neither immoral nor inethical. On the side of stopping this sort of thing, yes, I believe that the iSeries would be a more attractive buy. IBM is putting up barriers to purchase on the machine. ...
While I agree with you that it's silly to put a cap on the processing power of the iSeries, it is neither immoral nor inethical. On the side of stopping this sort of thing, yes, I believe that the iSeries would be a more attractive buy. IBM is putting up barriers to purchase on the machine. ...
Upgrading from V5R1 to V5R2: What should we watch out for?
You can upgrade to V5R3 directly from V5R1 if you want to save some headaches... If you have software support, there should be no additional cost to order V5R3 and just skip V5R2... Both new releases take up more disk space and V5R3 takes up even more than the older one... Plus there are some...
You can upgrade to V5R3 directly from V5R1 if you want to save some headaches... If you have software support, there should be no additional cost to order V5R3 and just skip V5R2... Both new releases take up more disk space and V5R3 takes up even more than the older one... Plus there are some...
Source for a the DSPPGMMSG command
To my knowledge, this is not an IBM command. I would suggest that you do DSPOBJD DSPPGMREF *CMD. Take option 8 which will tell you the library, file, and member that created the object. ========================================================= Without any description of what DSPPGMMSG deoes,...
To my knowledge, this is not an IBM command. I would suggest that you do DSPOBJD DSPPGMREF *CMD. Take option 8 which will tell you the library, file, and member that created the object. ========================================================= Without any description of what DSPPGMMSG deoes,...
Interactive Tax on the iSeries
it is certainly a sore spot with the tech support group at my shop... but not a reason to move away from iSeries... It is a good excuse to purchase higher Int CPU processors (or the Enterprise editions) as it is quite difficult to estimate the growth potential for some of our distributed sites......
it is certainly a sore spot with the tech support group at my shop... but not a reason to move away from iSeries... It is a good excuse to purchase higher Int CPU processors (or the Enterprise editions) as it is quite difficult to estimate the growth potential for some of our distributed sites......
