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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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