Mandatory Field on Display File in AS400
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 13, 2013 2:28 PM
DDS, Display File, DSPATR, mandatory fiels
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 13, 2013 2:28 PM
DDS, Display File, DSPATR, mandatory fiels
RPG Code for reading a particular record
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 14, 2013 11:02 AM
RPG
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 14, 2013 11:02 AM
RPG
Looking for a db2/400 class in canada
This one is web-based , but IBM also has some courses offered in Canada
View Answer
| August 24, 2012 2:12 PM
DB2/400
This one is web-based , but IBM also has some courses offered in Canada
View Answer
| August 24, 2012 2:12 PM
DB2/400
AS/400
I might recommend wrkmbrpdm. You can view or edit if you so desire.
View Answer
| August 27, 2012 7:46 AM
As/400 Object
I might recommend wrkmbrpdm. You can view or edit if you so desire.
View Answer
| August 27, 2012 7:46 AM
As/400 Object
AS/400
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Fgencmddoc.htm
View Answer
| August 24, 2012 7:11 AM
AS/400 - CL Command, COMMANDS
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Fgencmddoc.htm
View Answer
| August 24, 2012 7:11 AM
AS/400 - CL Command, COMMANDS
AS/400
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Finzpfm.htm
View Answer
| August 24, 2012 5:55 AM
keyword, Physical File
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Finzpfm.htm
View Answer
| August 24, 2012 5:55 AM
keyword, Physical File
RUNRMTCMD will not run SQLCMD
I think I may have stumbled across the answer myself. Somewhere I got, apparently incorrect, info that OSQL would not run on SQL Server 2008, so I switched to SQLCMD, which is worthless. Switched back to OSQL and it works fine.
View Answer
| August 22, 2012 7:18 PM
RUNRMTCMD
I think I may have stumbled across the answer myself. Somewhere I got, apparently incorrect, info that OSQL would not run on SQL Server 2008, so I switched to SQLCMD, which is worthless. Switched back to OSQL and it works fine.
View Answer
| August 22, 2012 7:18 PM
RUNRMTCMD
Looking for Old PTF’s
I am under the impression (maybe incorrectly) that V3R7 was an intrim release. only used to migrate from a CISC box to a RISC box. we operated v3r5 and one of the procedutes of the CISC/RISC upgrade was to upgrade to v3r7 (on a CISC) as an intrim step to v4r2 (on a RISC). in another [...]
View Answer
| August 28, 2012 6:01 PM
AS/400, PTF, V3R7
I am under the impression (maybe incorrectly) that V3R7 was an intrim release. only used to migrate from a CISC box to a RISC box. we operated v3r5 and one of the procedutes of the CISC/RISC upgrade was to upgrade to v3r7 (on a CISC) as an intrim step to v4r2 (on a RISC). in another [...]
View Answer
| August 28, 2012 6:01 PM
AS/400, PTF, V3R7
Read the data from PF between dates
Create an LF by date YYYYMMDD and use that
View Answer
| August 22, 2012 1:07 PM
AS/400, AS/400 programming, DB2/400, RPGLE
Create an LF by date YYYYMMDD and use that
View Answer
| August 22, 2012 1:07 PM
AS/400, AS/400 programming, DB2/400, RPGLE
QDBSRV04/05 reorg running for 31 hours and still going…
I agree with Tom. Call IBM now. You do not have the time to “try” something.
View Answer
| August 22, 2012 10:02 PM
EDTRBDAP, QDBSRV04, Reorganize Physical File Member
I agree with Tom. Call IBM now. You do not have the time to “try” something.
View Answer
| August 22, 2012 10:02 PM
EDTRBDAP, QDBSRV04, Reorganize Physical File Member
AS400
You can use the same SQL statement in your RPG program.
View Answer
| August 21, 2012 4:54 PM
AS400 RPGLE
You can use the same SQL statement in your RPG program.
View Answer
| August 21, 2012 4:54 PM
AS400 RPGLE
Multiple display file in CL program
Is it the same field name on each screen? Do you have two different display files or just one with multiple formats?
View Answer
| August 21, 2012 3:31 PM
CL
Is it the same field name on each screen? Do you have two different display files or just one with multiple formats?
View Answer
| August 21, 2012 3:31 PM
CL
BRMS Entire System Backup using 2 tapes.
if that tape is added to BRMS database remove that. then INZTAP in native not through BRMS. before firing backup take DSPTAP and make sure no data is there. then move the tape to drive. then fire the backup.
View Answer
| September 12, 2012 3:43 AM
BRMS
if that tape is added to BRMS database remove that. then INZTAP in native not through BRMS. before firing backup take DSPTAP and make sure no data is there. then move the tape to drive. then fire the backup.
View Answer
| September 12, 2012 3:43 AM
BRMS
Title changing
I would go along with what Phil suggests. Store the value outside of the program. Does not make that much of a differerence if it is a *DTAARA, PF, or Msg file. I ususally us a PF. Also if you center the field, that would be the best option. This method has another adjavtage. You [...]
View Answer
| August 20, 2012 6:02 AM
AS/400, CL/400, DB2/400, DSPF, ILE, Printer files
I would go along with what Phil suggests. Store the value outside of the program. Does not make that much of a differerence if it is a *DTAARA, PF, or Msg file. I ususally us a PF. Also if you center the field, that would be the best option. This method has another adjavtage. You [...]
View Answer
| August 20, 2012 6:02 AM
AS/400, CL/400, DB2/400, DSPF, ILE, Printer files
We had a security audit and one of the requirement was to raise an alarm whenever any user does a data extract.
Hi, I am not sure if it works. But had you tried Physical Trigger?
View Answer
| August 21, 2012 6:15 AM
Alert, AS/400, cl 400, DTF, iSeries
Hi, I am not sure if it works. But had you tried Physical Trigger?
View Answer
| August 21, 2012 6:15 AM
Alert, AS/400, cl 400, DTF, iSeries
Foxpro
In foxpro there are two files one is DBF (DATABASE) and other file in .txt file. for printing Database you may import them in excel using import option and for txt file you may open in notepad and copy paste to word.
View Answer
| August 22, 2012 6:26 AM
FoxPro, print
In foxpro there are two files one is DBF (DATABASE) and other file in .txt file. for printing Database you may import them in excel using import option and for txt file you may open in notepad and copy paste to word.
View Answer
| August 22, 2012 6:26 AM
FoxPro, print
iSeries system purchase date
I believe you will have to fine the PO. I could have an AS400 and sell it to you today. You could own it for any period of time and never turn it on; then sell it to someone else.
View Answer
| August 14, 2012 2:50 PM
AS/400 hardware
I believe you will have to fine the PO. I could have an AS400 and sell it to you today. You could own it for any period of time and never turn it on; then sell it to someone else.
View Answer
| August 14, 2012 2:50 PM
AS/400 hardware
comparing the reports
If you copy the spool files to PFs, then you can use CMPPFM to compare the data. If you print TIME in your headings, be sure to exclude those records from the PFs. those lines will never match.
View Answer
| August 14, 2012 2:24 PM
AS/400
If you copy the spool files to PFs, then you can use CMPPFM to compare the data. If you print TIME in your headings, be sure to exclude those records from the PFs. those lines will never match.
View Answer
| August 14, 2012 2:24 PM
AS/400
Synon-Action daigram comment color can be changed?
Hi, you can do the same thing by just insert some extra line and add your comments there as your name and teg no. to identify your code.Insert simple line by I= and * +enter to insert comments there.
View Answer
| February 28, 2013 11:54 PM
Synon
Hi, you can do the same thing by just insert some extra line and add your comments there as your name and teg no. to identify your code.Insert simple line by I= and * +enter to insert comments there.
View Answer
| February 28, 2013 11:54 PM
Synon
how to prevent laptop from accessing my network
HI, A couple ways a pc policy that bites if violated. That takes upper management involvement. Have upper management sign a memo – distribute it – place it on a shared drive and re-educate the users on pc policy. Eliminate excuses. We have strict rules about bringing in thumb drives/laptops. We also monitor contractors/vendors. If [...]
View Answer
| August 23, 2012 8:11 AM
SECURE
HI, A couple ways a pc policy that bites if violated. That takes upper management involvement. Have upper management sign a memo – distribute it – place it on a shared drive and re-educate the users on pc policy. Eliminate excuses. We have strict rules about bringing in thumb drives/laptops. We also monitor contractors/vendors. If [...]
View Answer
| August 23, 2012 8:11 AM
SECURE
