Track user activity, transaction number on AS/400 to prepare for migration
As part of planning for a migration to a different platform, my boss has asked me if there is a way to count the number of transactions on the AS/400.  Essentially she wants a count of all user activity during the course of the day.  Any thoughts on if/how to obtain such a number on [...]

Answer Question   |  June 30, 2010  3:39 PM
AS/400, AS/400 migration

Releasing lock in AS/400
how to find which record is locked and who locked that record.how to release the lock by ourselves.please explain in detail.i’m new to as/400.

Answer Question   |  June 22, 2010  2:59 PM
AS/400, AS/400 administration, AS/400 DB2, AS/400 Locking

Display of Chinese Characters on AS/400 Using Client Access
Hi, I am trying to change and display the chinese characters on AS/400 Screen. I am using Client Access. I NEED TO PRINT INVOICE IN CHINESE CHARACTER

Answer Question   |  July 4, 2010  2:17 PM
AS/400 Client Access, AS/400 printing, Client Access Printing

AS/400 message queue
Hi dear All, I’m stuck up.. in my first message queue program. I read message on the *msgq (using RCVMSG) and write it in a PF. I’ve 2 (dumb) Questions. 1. I provide ‘message queue’ as a parameter to RCVMSG command. when the command is executed, it reads only one row at a time. so If I’ve [...]

Answer Question   |  June 17, 2010  1:29 PM
AS/400, AS/400 message queues, AS/400 Primary Language CL RPG

Copy spool file partially
Hi, I want to copy only the last 10 lines of a spool file. Can Anyone tell me how I can do it?  

Answer Question   |  June 18, 2010  12:46 PM
AS/400, CPYSPLF, Spool files copy

Need to write a CL program to track user logins
HI, I WANT HOW TO WRITE A CL PROGRAMME TO KNOW A USER IS LOGGED IN OR NOT.MEANS IN A SERVER NUMBER OF USERS OR THERE SO I WANT TO FIND OUT WHICH USER IS LOGIN STATE WHICH OR NOT LOG-OFF STATE.WHEN I RUN A PGM TO PROVIDE USER NAME IT WILL SHOW THE LOGIN [...]

Answer Question   |  July 3, 2010  5:59 AM
CL Program, CL programming, User Login Data

Best Web Browser for Use with Cisco Partner Tools
What is the best web browswer to use with Cisco Partner tools such as the config and order status tools?

Answer Question   |  June 17, 2010  7:47 PM
Application Compatibility, Cisco, Cisco Partner Tools, lenovo, Web browsers

Robot/SCHEDULE passing scheduled run date and time
Is there a way to get the [strong]scheduled[/strong] run date and time passed into the called program as parameters.  for example, it is supposed to run at 23:00 on 6/15, but due to a power outage, it is now 01:15 on 6/16.  Is there a way to setup the “Reserved Variables” so that the program receives the [...]

Answer Question   |  September 14, 2011  12:48 PM
iSeries, iSeries V6R1, V6R1

I’M UNABLE TO COMPILE RPGLE SOURCE
Hi All, In my application there is program in ILE source, code like bellow, I/COPY CMQGMOG                               ** note, sample uses defaults where it can  *                                           * misc fields added by me                  D INDX            S             10I 0       When i’m creating a module getting error beelow,”Compiler not able to open the /COPY or /INCLUDE file; “ Could you [...]

Answer Question   |  June 29, 2010  3:41 PM
AS/400, RPGLE, Source code

Improve performance on Insert rows into DB2 400 table from SQL server
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for [...]

Answer Question   |  October 29, 2010  2:58 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005

live & local NIC problem
I have two onboard NIC in windows server 2008 machine one LAN (LOCAL) IP & another has static IP that given by my ISP. I use this server as test web server. So it is connected with both NIC as same time with local & live public IP. This server is on local domain also. [...]

Answer Question   |  June 16, 2010  9:15 AM
LAN, Local area networks, NIC, NIC Problem, Web Server, Windows Server 2008

Trimming leading zeros in as/400
Hi, I have a character input parameter of length 8. I have a customer number which may vary according to a query that user enters. This customer number is searched in an input file where the key field is numeric. I want to change this input parameter to numeric without any trailing zeros/blanks. Anyone who [...]

Answer Question   |  June 18, 2010  8:17 AM
AS/400 Fields, OS/400, RPG Code

Spool file in DFR status
Hi, I have this spool file queued in a RMT printer but in DFR status. I already checked the output queue and the “Maximum spooled file size” is set to *NONE. How can I get rid of this DFR status and prevent it from coming back. . . . THANKS

Answer Question   |  June 16, 2010  1:05 AM
AS/400, iSeries, iseries v5r4, Output Queues, RMT printer, V5R4

Configure 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. How is this accomplished using Windows 2008?

Answer Question   |  June 14, 2010  7:17 PM
AS/400 security, iSeries V6R1, Single sign-on, Windows Server 2008, Windows Server configuration

BPCS ASSET user guide
I need to check BPCS Sources.  I know that they are in ASSET but don’t how to use it?  Could you provide me a user guide? Thanks   Pascal

Answer Question   |  June 14, 2010  12:42 PM
AS/400, Asset Tools, BPCS

AS/400 Password synchronization code examples?
Does anyone have any code examples of synchronizing passwords on multiple AS/400 systems? Thanks for your tiime!

Answer Question   |  June 14, 2010  9:36 AM
AS/400, AS/400 Password Length, AS/400 passwords, Password synchronization

Prevent record lock scenario with AS/400 ?
Suppose 2 users are accesssing the same record in a file.User 1 tried to update the record and while doing so he did not log-off from his update screen,while the user tries to do inquiry on that same record. As a result there will be a record lock situation.How to prevent this scenario ? i [...]

Answer Question   |  June 14, 2010  7:13 AM
AS/400 DB2, AS/400 Locking, AS/400 Records, Record lock

commands AS400 system
general commands working as developer on the AS400 IBM system

Answer Question   |  June 14, 2010  8:14 AM
AS/400 jobs, AS400 Job Status, COMMANDS, Developer

NOS Selection, use and performance
Sorry I first posted this in the wrong section but here goes: I am a student and confused about this. How is multithreading related to NOS selection, use, performance, and management?

Answer Question   |  June 13, 2010  9:33 PM
Multi-threading, Network Operating System

Inserting DB2 records on iSeries to SQL Server 2005 Table
I need to insert records from a DB2 file residing on an iSeries to a SQL Server 2005 table on a remote system. How can I do this in a CL or RPG ? Thanks

Answer Question   |  June 20, 2011  12:27 AM
DB2, iSeries, SQL Server 2005