Way to filter files in IFS?
Michael recently wrote Search400.com with this question: “Every day we have hundreds of very small 1K to 100K files written to a directory (JDEB7333) on our IFS. All the files have the same extension of .log. Is there a native command or a utility (free or subscription) that you are aware of that will search [...]

Answer Question   |  August 11, 2005  9:03 AM
AS/400, i5, iSeries, OS/400, Security

Need help restoring spooled file in BRMS
A Search400.com member needs your help. He has an i825 iSeries and is trying to restore a spooled file saved in BRMS. The problem is the tape backup was on an old 620 machine. Does anyone have any advice? Michelle Davidson Editor Search400.com mdavidson@techtarget.com

Answer Question   |  August 17, 2005  8:57 AM
AS/400, Backup & recovery, i5, iSeries, OS/400

Binding Directory Signatures
I’ve been researching implementing ILE RPG in our office versus OPM style coding. I’ve read through the ILE RPG Reference as well as the Concepts and Programmer’s Guides. I now have *SRVPGMs moderately well figured out and I’ve defined Binding Directories for compiling my *SRVPGMS. I discovered the hard way that inserting a new procedure [...]

Answer Question   |  October 31, 2009  7:56 AM
RPG

UPDPGM
Hi, Is there a way to accomplish program updates automatically after module or service program changes. How can we find which programs are bounded with that module or service program?

Answer Question   |  October 31, 2009  4:02 AM
i5, iSeries, OS/400

program updates
Hi everyone! I need to modify an RPG program that is called from a menu (a *MENU object). If I modify this program, do I need to recompile my menu?

Answer Question   |  October 31, 2009  2:32 PM
RPG

journal entry’s entry specific data
Hi, I am trying to extract fields from security audit events. The problem comes when dealing with entry specific data field. This field contains lot of info which varies according to the entry type. Is there any API which returns information present in the entry specific data portion in a convenient format? Any suggestions or [...]

Answer Question   |  October 31, 2010  11:15 AM
Backup & recovery, i5, iSeries, OS/400, PC/Windows Connectivity, Security, tips and tricks, Tools

as400 v4r5 to pc win2k pro ethernet connection
i connect to my as400 150 via a mini-hub. pc IP adddress is assigned by as400 DHCP. i have installed a cable modem for broadband. pc IP address now being assigned by my ISP. my connection to as400 no longer works. can i reconfigure as400 to solve this problem? can i install a 2nd pc [...]

Answer Question   |  October 31, 2009  5:33 AM
AS/400, Network protocols, Networking

how to read records from Externally Described file into data structure
FAAAL21 UF A E K DISK F RENAME(REC:arec) D jkdata E DS extname(aaal21) c read arec jkdata after compiling, the error message is : RNF7701 20 The data structure is not allowed for the operation according to the book <ILE RPG Reference?SC09-2508-4?>, the above operation should be allowed. I want to know WHY. Thank you [...]

Answer Question   |  October 31, 2009  11:49 PM
Development, RPG

unzipping a file on the iseries
I know this question has already been asked but I need to know how to unzip a file on the iseries?

Answer Question   |  September 14, 2010  9:30 AM
AS/400, Hardware

STRSST User ID Disabled.
How do you re-enable the user id for STRSST when it has been disabled?

Answer Question   |  July 9, 2010  8:42 AM
i5, iSeries, STRSST

V5R3 Upgrade – RJE – BSC
After Upgrading from V5R2 to V5R3 an old style BSC RPG program no longer functions. Does anyone know if a Licensed Program is missing or a PTF is required. Have not been able to find much info. Thanx in advance

Answer Question   |  July 29, 2005  6:50 AM
i5, Installation, iSeries, OS/400, PTFs, RPG

Check for active jobs
Does anyone have a simple CL to check for active jobs in a subsystem before ending it?

Answer Question   |  October 31, 2009  4:07 PM
AS/400, iSeries, Tech support

Line feed problems
I am trying to create a file on the IFS and then ftp this to our client. He requires a line feed between certain fields and Cr/LF (x’25′) at the end of the record. I do not have a problem with the end of record requirement. I am using codepage 437 on the as400 and [...]

Answer Question   |  October 31, 2009  7:19 AM
RPG

RTVQRYF (Back in time)
Hi, I have recently joined a company which hasn’t moved on since I was there last in 1990 !!! We still use RPG3 and Query (no ILE or SQL for us) Anyway my question. We need to create a utility which will find all queries that use or write to a file. I have downloaded [...]

Answer Question   |  November 21, 2009  10:01 AM
RPG

AS/400 Full Back-up
hi, I have installed an iseries 9405-520 i5/OS V5R3M0 and the informatician have done all the aplication in B-boot mode. Has this any impact in the machine. Can i reboot in the A-boot mode???? And the last : i want to do a full back-up of the machine. Can you help me with some instructions……

Answer Question   |  May 6, 2012  4:58 PM
AS/400, Help Desk, Tech support

timestamp value
Hi, I am receiving TIMESTAMP value from the iSeries system as an unsigned 64 bit integer value. Is it possible to convert this timestamp into a readable format in windows machine? The iSeries timestamp value is an unsigned 64 bit integer value. All the time management routines which I can use on a windows machine [...]

Answer Question   |  July 21, 2005  9:39 AM
Backup & recovery, i5, iSeries, OS/400, tips and tricks, Tools

iSeries Access ODBC Driver Error
I’m trying to run a stored procedure on MS SQL Query Analyzer but continue to get the following error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider ‘MSDASQL’ reported an error. [OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0005 – Error occurred in the OS/400 database server code.] OLE DB [...]

Answer Question   |  October 30, 2009  4:41 PM
AS/400, Data analysis, Data mining/analysis, DataCenter, Tech support

5733SC1; ability to sftp to a Unix box
I have a need to get information from an i5 to a Unix box. And it has to be unattended. Catch; Unix is allowing only SFTP (not i5′s definition of secure ftp, the Unix definition. Port 22). So, FTP isn’t an option. In all IBM & everyone else’s ‘documentation’ about all can find out is [...]

Answer Question   |  May 25, 2010  3:11 PM
i5, iSeries, OS/400

system date in RPG
We have a dataq job that runs constantly. There are trigger programs on some files that control what is sent to the dataq which in turn prints certain forms at the correct outq. is there a ‘date’ variable that will reflect NOW? Udate and *date gives the same thing – the job start date. i [...]

Answer Question   |  November 9, 2010  11:21 AM
RPG

STRDSKRGZ, TRCASPBAL, and STRASPBAL commands.
Are any of you familiar with using these commands, the amount of time it takes to perform these commands, the requirements (restricted system or not, etc.), or where I can obtain some documentation on these commands so I can read up on them? I appreciate the info and help.

Answer Question   |  October 25, 2010  9:17 AM
STRASPBAL, STRDSKRGZ, TRCASPBAL