AS/400 Administration

AS/400 command to find Object relationships

I have one object named "Pgm1" and i want to know in system in how many programs it may used or reffered ? Is there any command to find out the things like program name and all ?

AS/400 printing sends file to HLD status every time

Hi, When i m trying to print the file from as/400 printer it is going into held status. writer started,printer outq is in release mode,printer device is varried on and ip address of the printer is pingable but when trying to print the file is going to PND status after some time it is going into HLD...

Job logs on AS/400

Hi! How can I know if a group of jobs were executed successfully in specific dates?

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

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

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 ?

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...

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

AS/400 to AS/400 online transactions transfer

I NEED A WAY/PROGRAM TO TRANSFER TRANSACTIONS ONLINE FROM AS400 TO AS400 THX

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

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

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. The...

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...

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

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.

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 ?

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

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).

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

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 but I...