Finding the duplicate job
Remember you can only get information about jobs that are running or in a queue. If you submitted a job and it ran and there is no spool file left on the system, it will not show up.
View Answer
| October 29, 2012 8:04 AM
AS/400
Remember you can only get information about jobs that are running or in a queue. If you submitted a job and it ran and there is no spool file left on the system, it will not show up.
View Answer
| October 29, 2012 8:04 AM
AS/400
Good book to learn SQL in AS400?
Go to http://www.mcpressonline.com/ In addition to books on SQL, you will find good “free” articles and forums All books there are excelent
View Answer
| October 29, 2012 4:50 AM
AS/400
Go to http://www.mcpressonline.com/ In addition to books on SQL, you will find good “free” articles and forums All books there are excelent
View Answer
| October 29, 2012 4:50 AM
AS/400
Server Name
Not sure why a sotware is asking for a server name, except maybe if you are joining something in a network. You just go to the Computer icon, right click-t, go to Properties, System Settings, then Computer Name.
View Answer
| October 29, 2012 1:40 AM
PHP, Server
Not sure why a sotware is asking for a server name, except maybe if you are joining something in a network. You just go to the Computer icon, right click-t, go to Properties, System Settings, then Computer Name.
View Answer
| October 29, 2012 1:40 AM
PHP, Server
Add In function in Excel 2010 to download file from iSeries v7.1 exceeding limit, is there something we need to do to up the limit of records from 64K
We did just now add Service Pack SI42424 to Iseries Access V7.1 and now the million records will transfer using the ADD In’s Transfer Data From Iseries off of Excel 2010. thank you
View Answer
| October 31, 2012 2:56 PM
iSeries AS/400, Microsoft Excel 2010
We did just now add Service Pack SI42424 to Iseries Access V7.1 and now the million records will transfer using the ADD In’s Transfer Data From Iseries off of Excel 2010. thank you
View Answer
| October 31, 2012 2:56 PM
iSeries AS/400, Microsoft Excel 2010
DB2/400
Logical file, we can say as a mirror image or the view of the physical file. using logical file: . We can view , insert, update, delete data of a physical file without any worry about deleting the data while compiling, hence provides security to data. . We can have multiple physical file view in [...]
View Answer
| October 27, 2012 3:18 PM
AS/400 DB2, AS/400 logical file
Logical file, we can say as a mirror image or the view of the physical file. using logical file: . We can view , insert, update, delete data of a physical file without any worry about deleting the data while compiling, hence provides security to data. . We can have multiple physical file view in [...]
View Answer
| October 27, 2012 3:18 PM
AS/400 DB2, AS/400 logical file
File read
I need all accounts from File1. My file2 has account number, security and quantity. For account number A there can be security X with Qty1 again for same account security X with Qty 3. In the summary file, I need to show Account A , Security X and Qty 4(3 + 1). When ever the security [...]
View Answer
| October 19, 2012 6:59 AM
AS/400
I need all accounts from File1. My file2 has account number, security and quantity. For account number A there can be security X with Qty1 again for same account security X with Qty 3. In the summary file, I need to show Account A , Security X and Qty 4(3 + 1). When ever the security [...]
View Answer
| October 19, 2012 6:59 AM
AS/400
List of objects
What do you mean “the server gets stuck”? What options have you tried for the *LIB parameter on the DSPOBJD command?
View Answer
| October 19, 2012 5:46 AM
DSPOBJD, object, Outfile, RPG, RPGLE
What do you mean “the server gets stuck”? What options have you tried for the *LIB parameter on the DSPOBJD command?
View Answer
| October 19, 2012 5:46 AM
DSPOBJD, object, Outfile, RPG, RPGLE
How to capture decimal value of numeric fld
What do you need to do with it? That may determine the best technique to use. One way would be to use a data structure, another would be to z-add it to a field with with length/dec positions.
View Answer
| October 18, 2012 6:50 PM
RPG
What do you need to do with it? That may determine the best technique to use. One way would be to use a data structure, another would be to z-add it to a field with with length/dec positions.
View Answer
| October 18, 2012 6:50 PM
RPG
Disaster recovery exercise steps for AS400
The company must determine how long they can be without the computer. Then you can start developing a plan. For instance, If they can only be down for minutes, they you need to be replicating your data on another machine. If days, then you need to make sure you have access to another machine to load data [...]
View Answer
| October 18, 2012 3:28 PM
AS400 admin
The company must determine how long they can be without the computer. Then you can start developing a plan. For instance, If they can only be down for minutes, they you need to be replicating your data on another machine. If days, then you need to make sure you have access to another machine to load data [...]
View Answer
| October 18, 2012 3:28 PM
AS400 admin
Authority to some objects in a library to which user already has access
First you need to check the values you are using when creating objects; else you can clean this up and still have problems. Is there a reason that a user needs authority ot everything in a library? You need to determine what you want for you master security plan before you just start making changes. [...]
View Answer
| October 18, 2012 3:20 PM
AS400 Access, AS400 admin, iSeries AS/400
First you need to check the values you are using when creating objects; else you can clean this up and still have problems. Is there a reason that a user needs authority ot everything in a library? You need to determine what you want for you master security plan before you just start making changes. [...]
View Answer
| October 18, 2012 3:20 PM
AS400 Access, AS400 admin, iSeries AS/400
RPGLE day, month and year calculation
I’ll do something similar to get the last day of a month. For your issue … Get *DATE as ccyymmdd and load it to a data structure with DD specified in positions 7-8. Set DD=01. Put that ccyymmdd value into a Date (type) field and SUBDUR by 6 months. The result should be what you [...]
View Answer
| October 19, 2012 7:16 AM
RPGLE code, RPGLE Program
I’ll do something similar to get the last day of a month. For your issue … Get *DATE as ccyymmdd and load it to a data structure with DD specified in positions 7-8. Set DD=01. Put that ccyymmdd value into a Date (type) field and SUBDUR by 6 months. The result should be what you [...]
View Answer
| October 19, 2012 7:16 AM
RPGLE code, RPGLE Program
Outfile printing
The log is: output file file1 created file1 added to library mmember of file1 is opened in library. data option was not allowed with opn option error reading member file1 in file1 0 records copied to file2.
View Answer
| October 16, 2012 7:14 AM
CL, cpyqryf, OPNQRYF, RPG, RPGLE
The log is: output file file1 created file1 added to library mmember of file1 is opened in library. data option was not allowed with opn option error reading member file1 in file1 0 records copied to file2.
View Answer
| October 16, 2012 7:14 AM
CL, cpyqryf, OPNQRYF, RPG, RPGLE
AS/400
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 12:19 PM
AS/400, AS/400 administration, PF
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 12:19 PM
AS/400, AS/400 administration, PF
Getting error messages from qsysopr
In a CL program, you can use the RCVMSG command to read the messages in QSYSOPR. A simple program to monitor for messages would be something like this: PGM DCL &MSG *CHAR 128 LOOP: RCVMSG QSYSOPR WAIT(*MAX) MSG(&MSG) your logic here – Either within this CL or call a program with &MSG as a parm. [...]
View Answer
| October 8, 2012 5:16 PM
QSYSOPR, SNMP
In a CL program, you can use the RCVMSG command to read the messages in QSYSOPR. A simple program to monitor for messages would be something like this: PGM DCL &MSG *CHAR 128 LOOP: RCVMSG QSYSOPR WAIT(*MAX) MSG(&MSG) your logic here – Either within this CL or call a program with &MSG as a parm. [...]
View Answer
| October 8, 2012 5:16 PM
QSYSOPR, SNMP
Converting amount in character field to numeric in rpgle
You need two %Dec statements. Amount$ = %Dec(%subst(iRec:1:1) + (%subst(iRec:3:04)) : 11 : 2);
View Answer
| October 8, 2012 11:04 AM
RPGLE
You need two %Dec statements. Amount$ = %Dec(%subst(iRec:1:1) + (%subst(iRec:3:04)) : 11 : 2);
View Answer
| October 8, 2012 11:04 AM
RPGLE
IBMi iAccess (client access) ‘Run The Same’
Run the Same is used to open a new session with the same setting as the current one. http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzaii/rzaii.pdf
View Answer
| January 17, 2013 5:38 PM
Client Access, IBMi, iSeries, iSeries Access for Windows, run the same
Run the Same is used to open a new session with the same setting as the current one. http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzaii/rzaii.pdf
View Answer
| January 17, 2013 5:38 PM
Client Access, IBMi, iSeries, iSeries Access for Windows, run the same
Excel to AS/400 PF
CPYFRMIMPF + FROMSTMF(&IFSFILE) + TOFILE(&tofile) MBROPT(*REPlACE) + RCDDLM(*ALL) FROMRCD(2) RPLNULLVAL(*FLDDFT) Set the &IFSFILE to the path/filename.ext of the .csv. Set the &tofile to the library/filename you want the data in. FromRcd(2) tells the copy to start at record number 2 thus skipping the header line in the .csv and leaving it intact. [...]
View Answer
| October 5, 2012 12:27 PM
.CSV files, AS/400, Microsoft Excel
CPYFRMIMPF + FROMSTMF(&IFSFILE) + TOFILE(&tofile) MBROPT(*REPlACE) + RCDDLM(*ALL) FROMRCD(2) RPLNULLVAL(*FLDDFT) Set the &IFSFILE to the path/filename.ext of the .csv. Set the &tofile to the library/filename you want the data in. FromRcd(2) tells the copy to start at record number 2 thus skipping the header line in the .csv and leaving it intact. [...]
View Answer
| October 5, 2012 12:27 PM
.CSV files, AS/400, Microsoft Excel
Different files same fields, can’t I use them without renaming?
Your subject line and the text do not seem to match.Subject lines indicates it does not work, but the text says it does. If is difficult to answer you question without more information about the process. But, if it is working, I would say it is a fair approach.
View Answer
| October 4, 2012 11:37 AM
AS/400, AS/400 file field usage
Your subject line and the text do not seem to match.Subject lines indicates it does not work, but the text says it does. If is difficult to answer you question without more information about the process. But, if it is working, I would say it is a fair approach.
View Answer
| October 4, 2012 11:37 AM
AS/400, AS/400 file field usage
how to enabled account
are you talking about user profile? if yes. then you should try typing WRKUSRPRF (user account) then you can see there if it is disabled and then you can enable it. hope this is the answer your looking for.
View Answer
| October 9, 2012 11:02 PM
AS/400
are you talking about user profile? if yes. then you should try typing WRKUSRPRF (user account) then you can see there if it is disabled and then you can enable it. hope this is the answer your looking for.
View Answer
| October 9, 2012 11:02 PM
AS/400
AS/400 saved fax cleanup
You should be able to treat this just like any other spool file. You can use EXPDATE & DAYS options on the printer file. If the printer file name is constant you change just do a CHGPRTF, Else, you will may need to go int CL programs and do OVRTPRT. === The above steps will [...]
View Answer
| October 3, 2012 7:17 PM
AS/400 Faxing
You should be able to treat this just like any other spool file. You can use EXPDATE & DAYS options on the printer file. If the printer file name is constant you change just do a CHGPRTF, Else, you will may need to go int CL programs and do OVRTPRT. === The above steps will [...]
View Answer
| October 3, 2012 7:17 PM
AS/400 Faxing
