Display the scheduler on iSeries system
How can I remove access to WRKJOBSCDE,CHGJOBSCDE, ADDJOBSCDE and leave a user with access to a browse command?

Answer Question   |  March 5, 2013  4:24 PM
AS/400, iSeries, iSeries Access

Strengthen QSECURITY level 30
Hi, Any tips and tricks on how could i strengthen QSECURITY 30 to patch the loophole in this level (without going to QSECURITY 40)? Thank you

Answer Question   |  October 23, 2012  4:08 AM
iSeries, iSeries 820, iSeries Access

iSeries Access *.OWS File
We are changing the iSeries IP address in company with 3000+ users connecting with different versions of iSeries Access for Windows. Most of these configurations were done with system IP rather than host name. Can all of these be changed with LAN Desk and if so how?

Answer Question   |  April 10, 2012  1:49 PM
iSeries Access, LAN Desk

Where do I download IBM iSeries ACCESS 6.1 x32 bit for Windows 7
Can anyone please give me the link to download IBM iSeries ACCESS 6.1 x32 bit for Windows 7?

Answer Question   |  April 18, 2013  2:21 PM
AS/400, iSeries Access

Client Access Disconnect
I have the latest version of iSeries Access running on a Windows 7 Prof PC and connection to a AS400 running V7.1 through a VPN connection. After establishing a 5250 session I can run any file inquiry RPG program, WRKACTJOB, WRKSPLF etc without a problem. If I run a query400 query, the session disconnects before [...]

Answer Question   |  March 19, 2012  4:05 PM
AS400 V7.1, iSeries Access, Windows 7 Professional

Start Monitor from Command line
I would like to be able to start an iSeries Monitor from the command line. I have a program to check if the monitor is running and would like the program to start the monitor if not running. Found the information about the monitor in file QMGTC/QAYPSJDS.

Answer Question   |  March 31, 2012  9:46 PM
iSeries Access, iSeries administration, iSeries command line, QAYPSJDS, QMGTC, V5R4

Restore System 38 file to iSeries V5R3
I’ve been trying to restore a file from our old system. The backup was taken by reel tape then migrated to another media format (e.g. 3590) now I am trying to restore the file, unfortunately I cannot. What command should I use to restore? Screenshot from DISPLAY TAPE                     File       Block   Recg  Record  Block   File        [...]

Answer Question   |  June 13, 2011  8:13 AM
iSeries, iSeries Access, iSeries data center, V5R3

IBM iSeries V5R2 and Windows 7
Does Windows 7 have any hope of working with IBM iaccess to this old operating system level V5r2?

Answer Question   |  May 6, 2011  5:59 PM
iSeries Access, V5R2, V5R2M0, Windows 7

ODBC connection to the SQL server from the iSeries
Is there a way on the iSeries to establish an ODBC connection to the SQL server?

Answer Question   |  May 5, 2011  6:14 PM
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity

iSeries and Windows 7 shared drives
Why is it that when my iSeries password is “ABC” my shared drives connect when I signon to Windows 7, but when I change my iSeries password to “XYZ” the shared drive do not connect? I then have to go into Windows Explorer, click on one of the drives and re-enter my password. Neither of [...]

Answer Question   |  May 3, 2011  3:13 PM
AS/400, iSeries Access, iSeries passwords, iSeries security, Shared drives, Windows 7

iSeries SQL ISNULL Equivalent
What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

Answer Question   |  January 27, 2011  10:28 PM
AS/400, iSeries Access, iSeries Navigator, iSeries SQL, T-SQL

iSeries Access Macro to run from a program.
I think I’ve asked the same question some months ago but didn’t get any answer and couldn’t be able to find one myself. The issue is: i have an iseries access macro that i run every day, but I do it from the Play button in the access menu. I would like to put this [...]

Answer Question   |  January 25, 2011  2:38 AM
iSeries Access, iSeries macros, Macros, V5R4

Management Central running but cannot open.
Management Central is running but when I try to open it I get “An unhandled win32 exception occurred in cwbunnav.exe” It opens a Visual Studio Just-In-Time debugger. Selecting Yes to debug doesn’t work because the source is unavailable. Selecting No (and when exiting the debugger), the iNavigator terminates. So far every thing I’ve read leads [...]

Answer Question   |  January 31, 2011  5:36 PM
Debugger, iSeries Access, Management Central, V6R1, Visual Studio

Quick iSeries Access Codes
I try to use several Quick Access codes, but I can only get DCKH to work. Why won’t UZZ or DEED work for me?  DEED brings me to emergency data not update employee data, which is what my code list says to use.  I use ISeries Access for windows, version 5.8. 

Answer Question   |  December 21, 2010  3:14 PM
iSeries, iSeries Access, iSeries Access Codes

Access iseries via Shared Drive and network
So I have a user that needs to be able to map a shared drive to an Iseries share, and also browse the iseries folders via explorer. When he tries to login he uses servernameusername but it comes back with a error claming to be invalid and or wrong username. he’s able to login via [...]

Answer Question   |  April 12, 2012  5:19 AM
iSeries, iSeries Access, iSeries error messages, Shared Drive, Windows

Network Issues Only Dropping PC5250 Sessions That Are Not Frequently Used
    We currently have a site that is occasionally having a network issue(PING commands shows connection verification stats of 2 of 5, 3 of 5, etc. or round trip speed in the 150 – 300 range instead of normal 50 – 80 range).     In this scenario User A uses the AS/400 all the time and doesn’t get dropped.   [...]

Answer Question   |  October 29, 2010  4:33 PM
AS/400, IBM PC5250 Emulator, iSeries Access, PC5250 Emulator, V5R3

how to limit data access on AS400 through ODBC, client access or Sequel viewpoint product
[strong]User profiles are assigned a group on our iSeries, and the group has object authority to the data files. What data they can actually see and update is controlled by the application, limited by menu travel and other security parameters built into the system. My issue is with Client Access, ODBC or 3rd party SEQUEL [...]

Answer Question   |  September 1, 2010  2:03 PM
AS/400, Data access, iSeries Access, ODBC, SEQUEL ViewPoint

iseries access windows 7 compliance
Is IBM iseries access compatible with Windows 7(x64)

Answer Question   |  August 27, 2010  7:48 AM
iSeries Access, iSeries Access for Windows, iSeries interoperability, Windows 7, Windows 7 64-bit, windows 7 compliance

Problem with iSeries printer output
Hi All, We have installed Iseries Access for Windows V6R1M0. But when we go to printer Output, it’s very slow when we click any file, very slow, it’s seem suspend. Please tell me how to slove that.

Answer Question   |  August 27, 2010  4:35 AM
iSeries Access, iSeries printer output, iSeries printing, iSeries V6R1, V6R1

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