Job logs on AS/400
Hi! How can I know if a group of jobs were executed successfully in specific dates?

Answer Question   |  March 4, 2009  5:36 AM
AS/400 administration, AS/400 job logs

How to use font sizes and graphic tools in AS/400 V5R4 series
In as/400 v5r4, so many tools are their for fonts. how to use the font sizes and how to allow graphic tools in display files

Answer Question   |  August 25, 2009  8:32 AM
AS/400 3rd party tools, AS/400 administration, AS/400 Display File, V5R4

AS/400 certification for System Administration
I am working in saudi arabia as AS400 System Administrator, I want to know about the Online certificate exams for AS400 Administrations and web sites for reading materials. Thanks Syed Muneer

Answer Question   |  September 20, 2010  9:07 AM
AS/400 administration, AS/400 Administrator, AS/400 certification

How to add one Module to the existing Service Program
Hi, I want to add or append one new module called ‘C’ to the already existing service program(SRVPGM) For Example: I have one service program called SRVPGM consits of 2 Modules are A, B. Now i want to add one new Module called ‘C’ to SRVPGM. how can i do this ?

Answer Question   |  March 3, 2009  12:18 PM
*SRVPGM, AS/400 administration, RPG, RPG/400, RPGLE

CPYTOIMPF – PC .TXT file displaying as ‘garbage’
Hi, We are using a simple CPYTOIMPF command to move a Physical file to the IFS in a .TXT format. CPYTOIMPF FROMFILE(S4CMREP) TOSTMF(&TOIMPTF) + MBROPT(*REPLACE) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) Where &TOIMPTF is a IFS Folder & file name. This was working correctly until we recently applied operating PTF’s to the AS400. Now when we try [...]

Answer Question   |  February 7, 2011  10:52 AM
AS/400 administration, Copy To Import File, CPYTOIMPF, IFS, Physical File

FTP in AS/400
I want to FTP some date from a PF in one system to another as400 box, Is thre an API which can help me out

Answer Question   |  February 25, 2009  11:28 AM
AS/400 administration, AS/400 FTP, iSeries FTP, RPGLE

AS/400 to AS/400 online transactions transfer
I NEED A WAY/PROGRAM TO TRANSFER TRANSACTIONS ONLINE FROM AS400 TO AS400 THX

Answer Question   |  April 29, 2009  2:37 AM
AS/400 administration, AS/400 database connectivity, AS/400 interoperability

AS/400 operational console connection problem
Dear helper, we have 150 model as400 server, while we trying to connect system console( operational console direct), we are not able to get the connection from the server to pc.. all the answer are welcome

Answer Question   |  March 4, 2009  7:10 AM
AS/400 administration, AS/400 connection error, AS/400 connectivity, AS/400 model 150, Operations Console

Query for users that have not signed on in 60 days or more?
I need to write a query for users that have not signed on in 60 days or more. I used DSPUSRPRF to an outfile (field) uppsod gt ’60′ ? i think that is wrong. Thank you

Answer Question   |  February 18, 2009  1:50 AM
AS/400 administration, Display User Profile, DSPUSRPRF, UPPSOD, User Profile Name

Need a 3rd party AS/400 utility for converting to .CSV files
Hello there, I’m hoping somebody can point me in the right direction. I need a 3rd party software which will be able to integrate with the AS400 to download 4 files & then convert them into .CSV files. This software will then need to save the exported data files to a server on our network. [...]

Answer Question   |  February 16, 2009  1:27 AM
AS/400 3rd party tools, AS/400 administration, AS/400 import/export, CSV file format

How to block AS/400 users from using WinSQL
How can I block AS/400 users to modify data using WinSQL from the PC? Already I have some users that have insalled into their PCs iSeries Access and WinSQL, they run WinSQL that uses an ODBC to change data using SQL sentences. *** WinSQL is universal database management tool that can be used with any [...]

Answer Question   |  November 4, 2009  6:40 AM
AS/400 administration, AS/400 security, AS/400 user permissions, iSeries Access for Windows, ODBC, WinSQL

AS/400 Query – How to combine 2 fields but delete the null space?
fields a: School , in the fileld a there are 3 null space after school, field b: I choose , now I want to combine filed a and field b by using “||” as a new field, how to delete the null space

Answer Question   |  February 6, 2009  3:50 AM
AS/400 administration, AS/400 queries, AS/400 Query

DSPLOG and all security error msg related
Hi, how can I display all the security errors (not authorized, user profile disabled, etc) from the qhst, I know some cpf but not all of them. Thank you guys in advance.

Answer Question   |  October 21, 2009  3:58 AM
AS/400 administration, AS/400 error messages, AS/400 security, Display Log, DSPLOG, QHST

Retrieving data for IFS files via the RTVDSKINF command
How would I OBTAIN FILE SIZE, ETC ON IFS FILES BY UTILIZING THE RTVDSKINF COMMAND ON AN AS/400 SYSTEM ?

Answer Question   |  January 29, 2009  3:23 AM
AS/400 administration, IFS, Retrieve Disk Information, RTVDSKINF

Max active jobs in a subsystem using an AS/400 command
Can i find the max active jobs in a subsystem using an AS400 command

Answer Question   |  March 6, 2009  11:20 AM
AS/400 administration, AS/400 subsystems

Create .csv file on IFS folder in AS/400
Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).

Answer Question   |  September 25, 2009  8:11 AM
AS/400 administration, AS/400 import/export, Comma Separated Values, CSV file format, IFS, V4R3

AS/400 printing
How can I have one of my users to hold an as/400 job in one of our network printers, then whenever she wants to, she can released them !!! she doesn’t have as/400 authority to access the to the command entry. thanks

Answer Question   |  January 26, 2009  11:28 PM
AS/400 administration, AS/400 print jobs, AS/400 printing, Network printing

How do I setup a printer on an AS/400 system?
I have the following scenario: - System AS400 running on V4R5 - An Okidata printer connected to a D-Link print server via USB - A D-Link print server which running TCP/IP on the network I’m able to ping and connect to the D-link print server. I can connect the printer via a remote out queue [...]

Answer Question   |  January 27, 2009  10:16 PM
AS/400 administration, AS/400 printer configuration, AS/400 printers, AS/400 printing

How to check if email option is enabled on a AS/400 server
How to check if email option is enabled on a AS400 server

Answer Question   |  January 24, 2009  10:15 AM
AS/400 administration, AS/400 email, CL, CL/400

How to export data from AS/400 into Microsoft Excel
Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege [‘Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.

Answer Question   |  January 26, 2009  7:58 AM
AS/400 administration, AS/400 error messages, AS/400 import/export, Microsoft Excel, Microsoft Excel import/export