List of IBM midrange servers
Is there a document, listing all midrange servers from IBM? Are pSeries Server included in this category? Thank You!

Answer Question   |  August 24, 2010  1:44 PM
AS/400, IBM Servers, iSeries, pSeries, RS/6000

What should I expect when installing a terminal server?
in my company have 230 employes i want to install a terminal server. what is the function of terminal server and what is basic requirement and how to install this how many terminal connect with them

Answer Question   |  December 3, 2010  1:11 PM
Advanced Peer-to-Peer Networking, HCL, Peer-to-Peer, Terminal Server, Windows Terminal Server

HAl.dll file deleting from computers
Hi All, I am facing problem with our laptops (35 nos)hal .dll and few other .dll files are deleting from the laptops on a random basis.now i am managing by doing a windows repair.i need to find the cause for this.how can i stop this issue? the appalication installed in our laptops are . Lotus [...]

Answer Question   |  August 24, 2010  12:01 PM
AS/400 Client Access, HAL.dll, Hard drive repair, Lotus Notes 7, Windows errors

MQ depth through CLLE Or RPGLE programs
am trying to search is there a way to know the MQ depth in RPGLE or CLLE programs using some set of MQ API’s or MQ command.

Answer Question   |  August 24, 2010  10:08 AM
AS/400, CLLE, MQ, MQ depth, RPGLE

AS/400 to excel
How to download an AS/400 file in an excel format. I want to create a tool for this in my system. Please give your guidance.

Answer Question   |  August 24, 2010  6:08 AM
AS/400 File Transfer, excel, Excel Formatting

Problem on retrieve print queue information by API CPF3330 error
I got a problem during retrieve print queue information by API. The error message is “CPF3330 Necessary resource available”. Does any body have idea on it?   Thanks Sam      

Answer Question   |  August 24, 2010  5:56 AM
AS/400 print errors, AS/400 print jobs, AS/400 printing

STRSBS for single environment in AS/400
Dear Friends, I want to know about STRSBS for single Environment, in my System 3 different environment like A) Development (DVP) B) Testing (TST) C) Production 1 (510) D) Production 2 (710) Now I want STRSBS for 510 Environment only and rest of all Environments will be work but not 510 it should be hold, [...]

Answer Question   |  August 25, 2010  3:28 AM
AS/400, AS/400 development, STRSBS

Problems running AS400 stored procedure from SQLServer 2005 SSIS execute SQL task
I need to run a stored procedure (with two input parameters ) that has no output, on an AS400. When I try using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider, I get the following error [Execute SQL Task] Error: Executing the query “CALL TPSDTA50GQ.PMCTESTTP(‘PETER’, 4)” failed with the following error: “TPSDTA50GQ.PMCTESTTP is [...]

Answer Question   |  August 24, 2010  8:09 PM
AS/400 SQL, AS/400 SSIS, AS/400 stored procedures, SQL Server 2005

Do you have an IT blog or website and want to earn 100 knowledge points?
We hope you find this community helpful in answering all your questions. But we want everyone to get every answer they need and wthat means more experts are always welcome. That’s why we’re asking you to tell your friends about IT Knowledge Exchange (ITKE). If you have a blog or website that is geared towards the topics [...]

Answer Question   |  November 8, 2010  8:00 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Receiving result sets in RPG (prior to release 7.1) from an SQL SP
I have read through the IBM manual “Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries” for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this as it cannot access the result set [...]

Answer Question   |  August 26, 2010  5:45 PM
i5, RPG, SQL, SQL stored procedures, Stored Procedures

Trying to run BRMS and getting error CPF8971
BRMS getting error CPF8971

Answer Question   |  August 23, 2010  2:33 PM
Backup, BRMS, BRMS Backup, BRMS Tape error, Error CPF8971

Changing authority to access /qntc files
Hello. i have written an rpg/iv program that allows users to maintain certain network pc files from a greenscreen. it uses the /qntc file system to access those pc files. the problem i ran across is: unless the i5 userid and password is identical to the network userid and password, the program is unable to [...]

Answer Question   |  October 22, 2010  2:26 PM
AS/400, authority issue, QNTC File System, RPG Program, RPGILE, USRPRF, V5R4

Can I hot-swap hard drives on AS400?
I have a failed drive on 9406-620.  This leaves me with 4 drives unprotected. I’m concerned if I shut the system down it will not come back up.  Is there a way to hot swap a drive or to deactivate the 5 drives (moving date to other drives).  Ihave plenty of unused space on remaining drives. [...]

Answer Question   |  August 19, 2010  8:51 PM
AS/400, Hard Drive Installation, OS/400, V5R1

What does this mean when SQLCOD = -206? I need to write 2 sets embedded SQL statement in my program.
what does this mean when SQLCOD = -206. I need to write 2 sets embedded SQL statement in my program. first one is one and I was able to fetch data but the 2nd one has error just right after I declare cursor. Here are the statements EVAL SQLSTMT2 = SELECT_H_2 + WHERE_H_2; + AND_H_A; [...]

Answer Question   |  August 19, 2010  7:06 PM
iSeries SQL, SQL statements, SQLRPGLE, System i

Sending an email with a link to a .csv file that’s too large to email
My program creates a .csv that is copied to the IFS. It is too large to attach to email. I want to send an email with a link to the file. How do I do that?

Answer Question   |  August 19, 2010  5:18 PM
AS/400 development, CSV file format, IFS, iSeries, V5R4

Handle Position to With Load All Subfile?
How to handle position to with load all subfiel? (I know this concept  with single pg subfile)

Answer Question   |  August 20, 2010  6:52 AM
RPG/400, RPG/400 Subfile, RPGLE

My AS/400 can not find the time sync server. I have the correct server name but I can not ping it either.
My AS/400 can not find the time sync server. I have the correct server name but I can not ping it either.

Answer Question   |  August 19, 2010  11:04 PM
AS/400, Network Time Synchronization, Time Sync

Setting Up Another AS400 Console
Anyone has a documentation for setting up another AS400 console. We have a QCONSOLE setup on a machine but the machine broke down and i am trying to setup another on a different PC. Console is connected via LAN. I have set it up but could not get to the part where i have to [...]

Answer Question   |  August 19, 2010  9:32 PM
AS/400, AS400 Console, LAN, LAN Connections, SST

Link Outlook to AS/400
When I send mail from AS400 to Outlook 2003. I need hyperlink in mail on Outlook 2003 to AS400 green screen. I don’t know how to use hyperlink.

Answer Question   |  August 18, 2010  3:15 PM
AS/400, Hyperlink, Outlook 2003

find physical files with large record counts that are unused
How can I capture the number of records (not file size) for numerous physical files via a cl command in order that I may download the information and find the ones with the largest number of records? I need to free up disk space so I need to find the files that have records but [...]

Answer Question   |  August 20, 2010  3:13 PM
AS/400, AS/400 Database File, CL programming, CL/400, iSeries, Physical Files