AS400 Single Sign On – Windows Server 2008
I am attpemting to athenticate using kerberos on Active Directory – Windows Server 2008. The System i configuration planning documentation maps the user account to the principal on Windows 2000 using ktpass. Published documentation for Windows server addresses Windows server 200 and 2003. How is this accomplished using Windows 2008?

Answer Question   |  March 10, 2011  4:05 PM
AS/400, AS/400 Single Sign On, Authentication, Kerberos, Windows Server 2008, Windows Server 2008 Installation

Subtracting Date/Time AS400 V5R4
I am familiar with the subdur command. I have used it to get the # of days between 2 dates and the number of minutes between 2 times. How do I get the difference in minutes when the times fall on separate days. I guess I need to know how to calculate the interval between [...]

Answer Question   |  September 8, 2010  12:37 PM
RPG, RPG Date Formatting, RPGLE, V5R4

Is there a limit to the relative record number(RRN) for physical file on system i , we are on V5R4 version of OS400
Is there a limit to the relative record number(RRN) for a physical file on system i , we are on V5R4 version of OS400. If yes, what are the likely issues we would have to face?  

Answer Question   |  August 5, 2010  11:49 AM
i570 MMA, LIMIT, OS/400, OS400 Upgrade, Relative Record Number, V5R4

RPG/400
Hi,  What is the use of QCMDEXC?who will handle this.what purpose we use?can we call it is a command?  what is the usd of *INZSR?what is the relation with RETURN?  What are the input opcodes and output opcodes and I/O(combined) opcodes available in RPG/400?can any body list please Thanks malavika   

Answer Question   |  August 5, 2010  4:11 AM
*INZSR, ILE RPG, QCMDEXC, RPG/400

SIgnon to a different AS400 via menu
HOw to I allow a user to signon and than select from a menu to signon to a different AS/400.

Answer Question   |  August 5, 2010  1:20 AM
AS/400, AS/400 administration, iSeries, TCP/IP CONNECTION

Function PGM-QWASSTRSVR In JVAW using 95% of CPU, how to reduce it?
We have a WAS Job using 95% of our CPU ( got it from wrkactjob) we tried to tunning garbage collection and appeared that worked cause it (after restart) the job went down and was working with 25% OF cpu.Suddenly it started to use amonge 95 to 99 % of CPU again, any solution to [...]

Answer Question   |  August 4, 2010  4:41 PM
AS/400, i5, iSeries, Java, WAS, WebSphere Application Server

Starting SMTP in AS/400
I have problem on starting of SMTP. I already start the smtp using STRTCPSVR SERVER(*SMTP) but it does not start and no joblogs. I also try this on navigator. Righclick the SMTP then start but it does not started also. How to fix this problem? anyone? Thanks

Answer Question   |  October 18, 2011  9:19 AM
AS/400, SMTP, STRTCPSVR

Can we specify Dynamic SQL statements through CL program
Hi Friends, I am using I Series V5R4 and I have question about Dynamic SQL running in CL program. Can we run dynamic SQL in CL program instead of RUNSQLSTM command? Thanks in advance…… Regards, Raghuveer

Answer Question   |  August 5, 2010  8:14 AM
CLPROGRAM

Integration with AS/400 database
we have a web application build on struts and need to connect with the existing AS/400 database, what should be the feasible and easy approach for the same, please suggest on priority. Any suggestions are appreciated.

Answer Question   |  August 4, 2010  7:48 AM
Application and Web development, AS/400 integration

Passing Parameters to submitted job
The CL runs online, displays a prompt screen for report options and then submits itself with the parms now containing the report options from the user’s display input.  It uses RTVJOBA JOBTYPE to determine if it’s running online or in batch.  In either batch or online mode, depending on how the user wants to run it, it [...]

Answer Question   |  August 5, 2010  2:38 AM
AS/400, OPNQRY

how do i get a valid user list for the as-400
how do i get a valid user list for the as-400

Answer Question   |  August 3, 2010  12:11 PM
AS/400, AS/400 Userlist

Millenium Solution4 Question
We bought MS4 product and implemented year 2000 solutions in year 1999. We are renewing this software every year but looks like we are not using the support of this now and we do not need it anymore. Do we need to renew this?. What happens if we do not renew this?. I think it [...]

Answer Question   |  August 4, 2010  10:12 AM
AS/400

AS/400 Application Cloning
Hi Guys, My Client business taken over by another company. We did changes( branding changes, entity changes etc) to the application as per Buyer requirement. But now the Buyer wants to come out of transition period and for this he is planing to clone the application to thier own server. Can anyone please let me [...]

Answer Question   |  August 4, 2010  9:26 AM
AS/400

User to release & print spool file belonging to operator
In my environment, the AS400 operator runs the AS400 batch jobs generating reports. Hence, the spool files will be owned by AS400 operator. I need these reports owned by the AS400 operator to be released and printed by the user of the reports at a printer in the user’s overseas location instead of at the [...]

Answer Question   |  August 4, 2010  8:13 AM
AS/400, Spool files

RPG/400
  Hi, Good Morning.My team doing one maintenance program(BPCS) from the production deportment.That means Based on the daily claint assignment  i have to change the order no of the product,modifying the existing coding. Im also team member of that team.But i did not involve.My task is i want to give the daily status report and [...]

Answer Question   |  January 4, 2011  5:14 AM
AS/400

Finding remainder for decimal division in AS400 free format
Hi, I have come across a problem while coding in RPG free format. I need to find the remainder of  a decimal division. Consider an example below D Premium             S    11  2  Inz( 1230.10) D Instalments        S       2  0 Inz(12) D Remainder          S     11 2 how do I calculate the remainder when I divide Premium/Instalments. [...]

Answer Question   |  August 5, 2010  4:21 AM
AS/400, AS/400 administration

AS/400 unit testing
Hi, Im giri. IM DOING ONE PROJECT.IN THIS PROJECT THERE ARE 8 MODULES IS THERE.I HAVE DEVELOPED ONE MODULE.FOR EXAMPLE ’EMPLOYEE TASKS’.I HAVE COMPLETED THIS MODULE.BUT NOW I WANT TO TEST(UNIT TESTING).HOW CAN I DO THAT?WHAT TYPE OF ERROR I WANT TO CHECK? PLEASE CLARIFY MY DOUBT.   THANKS GIRI    

Answer Question   |  August 2, 2010  10:30 AM
AS/400, AS/400 errors, AS/400 testing, RPG/400

DB2 for Z/OS and DB2 for LINUX / WINDOWS/ AS400
I have around 5 years of IT experience in Mainframe and Midrange operations. As I’m more intersted in database administration, recently I did IBM DB2 9 Fundamentals certification and also IBM Mainframe application development course ( JCL,VSAM,COBOL,DB2,CICS) but it was 5 years back. I want to go for professional certification in DB2 for Z/OS as [...]

Answer Question   |  September 27, 2011  10:52 PM
AS/400, AS/400 DB2, DB2, IT career planning, z/OS

iSeries Update Values in a Table Based on Values in Two Tables.
I want to update a Client Category Code in the Client_Table where the Client has a specific Country Code AND and the Clients VAT No is Blank, Which is in The Client_Account Table in another Library. The Matched Records are [LIBRARY1]FILE1.CLLDRS and [LIBRARY2]FILE2.ADLDRS So Update [LIBRARY1]FILE1 SET CATCDE=’EXM’ where FILE1.CTRY = ‘US’ and [LIBRARY2]File2.VATNO =NULL. I know the above syntax isn’t correct. but can [...]

Answer Question   |  August 2, 2010  10:25 PM
AS/400 DB2, DB2 administration, i5/OS, iSeries, iSeries Access

cannot access using cisco vpn from win7 laptop to anything on the iseries
win7 laptop i take home to be able to get on our network to resolve issues away from work. everything works great except anything related to getting to the iseries. it tries but comes back with an iseries firewall or timeout message. cannot telnet either from a cmd prompt as it tries to go through [...]

Answer Question   |  July 30, 2010  7:03 PM
Cisco VPN, HTTP, iSeries, Windows 7, Windows 7 in 2010