Find string in AS/400 library
my requirement is find out string and which file contain that string,file name,file type,source file name this information find

Answer Question   |  February 17, 2011  6:06 PM
AS/400, AS/400 Library, String

I have more than 1000 objects in one library need to segregate type wise.
I have more than 1000 objects in one library need to segregate type wise like Program, Report, CL, Display Screens & also we write some Report Programs in RPG.[o:p][/o:p] Anyone have idea to segregate objects without any manual efforts.[o:p][/o:p]

Answer Question   |  February 16, 2011  2:39 PM
AS/400 Library, AS/400 objects, CL Program

Need to display a PDF on i5
I need to display a PDF file that was created using OVRPRTF with WSCST(*PDF) on the user’s i5 screen. I have tried IFS command DSPF but only garbage displays. This program used to do a DSPSPLF but we had to change it to use an overlay and only the data shows (none of the text [...]

Answer Question   |  September 26, 2011  12:17 AM
i5, iSeries printing, OVRPRTF, PDF

Windows 7 and iSeries for Windows
Has anyone have this issue on the iSeries for Windows? after an hour of no use it seems to lock up one of my sessions. I have seven at once running on V5r8

Answer Question   |  February 22, 2011  6:36 PM
iSeries, Windows 7, Windows 7 support

D Spec on DS in AS/400
When do you use the DS on your D Spec instead of just S

Answer Question   |  February 15, 2011  4:02 PM
AS/400, AS/400 database administration, AS400 Data Definitions

Chain in RPG IV
What is your definition of CHAIN and when do you use it in your programming?

Answer Question   |  February 17, 2011  4:01 PM
AS400 Data Definitions, CHAIN, RPG IV

Free IT Book: AAA Identity Management Security
This week’s free IT book is your complete, authoritative guide to implementing, configuring, and managing AAA with CiscoSecure ACS. For a chance to win AAA Identity Management Security, answer one of the questions listed below and post the link to your answer in the discussion section of this question. Upgrade Exchange 2007 from 2003 (downgrade [...]

Answer Question   |  February 23, 2011  1:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

AS/400 via Access, update query
Hi all my db is on as/400 and i use ms access to run queries. however, whenever i try to run an update query i receive the following error message: “[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 – table in library not valid for operation. (#-7008)” any idea what is missing? thanx in advance

Answer Question   |  February 17, 2011  12:18 PM
Access query, AS/400, AS/400 database, AS/400 Query

Journal Receiver Deletion and CPF7024
Receiver is detached and saved.  Cannot delete.  Error code CPF7024  tells me fo force the changes to auxiliary storage before deletion.  I don’t have a clue.  I don’t see any problem with the setup. Had to get an exclusive lock on the objects in order to stop journalling and delete the receiver.  I need to [...]

Answer Question   |  February 14, 2011  9:10 PM
AS/400 journaling, Journal Receivers

Adding monmsg to backup through BRMS
how can I add monmsg’s to my backup thru brms

Answer Question   |  February 14, 2011  3:21 AM
AS/400, BRMS, BRMS Backup, MONMSG, Tape Backups

CPF8361 Error after V6R1 Upgrade
After upgrading from V5R4 to V6R1 we have begun to encounter CPF8361 errors related to Committment Control running embeded SQL.    Transactions get hung up in RDB and then processes get stuck.   Is this specifically related to the upgrade and is there a simple process to correct the issue. 

Answer Question   |  March 1, 2011  4:58 PM
iSeries Upgrades, RPG, SQL, V6R1

Contest Bounties: Last chance to win an iPad!
The end of the iPad contest is drawing near – next Wednesday, February 16th to be exact – and we want to see more of you in the final drawing. In order to help push you over the 500 knowledge point requirement, we assembled some last chance bounties to get you in the running: 1. [...]

Answer Question   |  February 15, 2011  3:48 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

PM400 screen to print
PM400 option Print performance report displays the screen (below) to allow the user to drill down.  This screen is a summary with interval of 15 minutes for a 24 hour period.  I would like to copy the data lines (all entries for 24 hour period) data down to an Excel file (or .csv).   Unfortunaltely, [...]

Answer Question   |  February 11, 2011  2:04 PM
CSV, iSeries, iSeries printing, PM/400, V5R4M0

File and Fields in RPG400
I have a file that contains the file and its’ respective field. In my RPG, I want to read the file as retreive from the database. And use the fields from the file for testing. For example: F Specs FILEAAA My database contains: Filename : FILEAAAA Field Name : FIELD1 Value = 30 In RPG, [...]

Answer Question   |  March 1, 2011  10:00 AM
AS400 RPGLE, RPG/400, RPG/400 field validation

Avoid Hard Coding in AS/400 RPGLE
Hi, I have a task to design a grouping rule engine that must be robust and flexible for future needs.  I have a customer file with relationship code and I need to group the customers according to group types.  Each group type have different criteria. For example: 1)  Group Type ABC  -  extract based on (1)  [...]

Answer Question   |  February 15, 2011  7:51 AM
AS400 RPGLE, Grouping, RPGLE

Mount_IFS — Does anyone know of this utility?
We recently heard reference to a MOUNTIFS command or utility.  Does anyone use this command or know where we can find more info? Our goal is to create linkage between the IBM i and a Wintel server to transfer spool files converted to PDF on the IBM i.  Customers can then view their files via [...]

Answer Question   |  February 14, 2011  12:34 AM
i5/OS, IFS, Mount IFS, Wintel Server

Modify SNDDST or equivalent so emails from iSeries are in RTF or HTML
Does anyone send emails from the iSeries using SNDDST or equivalent from within a program (this is not a question about emailing spooled files) and can get them to be RTF or HTML not plain text so they look nicer to recipient?

Answer Question   |  February 14, 2011  10:06 PM
iSeries, iSeries email, RTF, SNDDST

AS/400 Physical File update history
How can we find out the sequence of programs that have updated the fields of the given file. For eg. If I have a file ABC and 10 programs have updated the file ABC, then how can we find out in which sequence the programs have updated the file ABC and what was the value in [...]

Answer Question   |  February 15, 2011  9:15 AM
AS/400, AS400 physical file, Physical Files

Open IT Forum: Security Worst-Cases
Have you had rogue employees deploying to the cloud without your knowledge, that is, until something went wrong? Share your worst-case experiences including how you rectified the situation. We want to hear your security horror stories to help other members and potential rogue employees avoid the same pitfalls. The best stories get 200 knowledge points [...]

Answer Question   |  February 17, 2011  5:57 PM
AS/400, Channel, CIO, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Error in subfile programming
I am encountering a very annoying problem. I have a subfile program and i am writing both SFL and SFLCTL and then reading the subfile. But as soon as the my code read the subfile READ D123, it gives me an error saying “Session or device error occurred in file D123″ and then in DUMP [...]

Answer Question   |  February 10, 2011  5:19 PM
AS/400 Subfiles, AS/400-Subfile Programming, AS400 Subfile, OS/400