Updated PSFCFG Exit Program
Does anyone have any information on a new way to write an exit program for the IBM PSFCFG writer???  I found one in an IBM manual about 5 years ago (2006 or 7).  Just wondering if any new code is out there to create a mapping exit program. Thanks  

Answer Question   |  May 25, 2011  5:42 PM
Exit programs, IBM, InfoPrint, InfoPrint Mapping Exit Program, User Exit Program FTP

Single commitment control in RPGLE program
I have a rpgle program that uses 3-4 sql statements to update and insert data in 3-4 tables . Now what i want is that when program runs successfully then only these changes in tables should reflect else roll back . So for this is there any way to provide a single commitment control for [...]

Answer Question   |  May 17, 2011  4:18 PM
RPGLE Program, SQL statements, SQLRPGLE, V6R1

On overflow in Unix IBM COBOL
stringing a name into a field with a area causing overflow. area is defined as using linkage, but no linkage size defined. overflow only happens with a VERY LONG name. Routine has existed in production for several years, never had too long of name before.

Answer Question   |  May 13, 2011  3:04 PM
COBOL, Overflow Error CPF5004, RPG overflow, Unix, Unix administration

Completed IT Knowledge Exchange Profile? Earn points!
What’s a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward our current contest! [...]

Answer Question   |  May 18, 2011  2:26 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Twinax AS/400 printer failure
Hi, I have a fault with my AS400. Current setup includes 4 twinax consoles connected to 4 twinax printers. I’m having a problem with PRT02. It suddenly stopped printing. The device status shows ‘Powered off or not available’. I tried to ‘Start’ the device under the Work with Printers menu but I get a message [...]

Answer Question   |  May 20, 2011  2:44 PM
AS/400, AS/400 print errors, AS/400 printers, AS/400 printing

Design 2 Column DFU Screen
I have 37 fields in the data records and I would like to display input dfu screen using two columns as input.

Answer Question   |  May 12, 2011  6:15 PM
AS/400 administration, AS/400 Data Reports, AS400 DFU, DFU

Client Access printer setup
I replaced the parallel cable to my Epson FX-880 printer with a D-Link 311P print server, and ever since then my Client Access printer sessions start with “Windows Default Printer” even though the .ws file specifies the Epson printer.  I never had this problem until I installed the DP-311P. I am using CA v6.1 on [...]

Answer Question   |  May 17, 2011  6:08 PM
Client Access, Client Access Printing, D-Link, Windows XP

Embedded SQL in RPGLE hdr, dtl fetch for subfile build
I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr      E DS                  EXTNAME(wtchdr) D dswtcdet      E DS                  EXTNAME(wtcdet) C     $CreateCsr    Begsr C/EXEC SQL C+ prepare S1 from :sqlstmt C/end-exec  * C/EXEC SQL C+ declare C1 scroll cursor for S1 C/end-exec C                   EndSr [...]

Answer Question   |  May 12, 2011  4:46 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE

Can we change length of CSV File
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]

Answer Question   |  May 11, 2011  11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format

use Data connection wizard / Microsoft query to get data from as400 to excel 2007
Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don’t know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database, [...]

Answer Question   |  May 12, 2011  6:33 AM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC

Fault tolerance on a web server
What is the best way to have fault tolerance on our web server? We have a few backup machines all identical that get replicated via scripts every 10 minutes. How cab we automatically fail over to another already configured box if the primary production machine fails? Is this some DNS magic?

Answer Question   |  May 22, 2011  7:41 PM
DNS, DNS server, Fault tolerance, Scripting, Web Server, Web server administration, Web servers

Hard drive formatting
When formatting a hard drive of a server that is going to be donated how can I be certain that the data is gone? Is there a program or application I can run? Is there a standard procedure for this? Or does everyone remove the hard drives?

Answer Question   |  June 6, 2011  7:11 PM
Data Security Program, Format Data command, Hard Drive Installation, Server Backup, Server Database, Server Security

How can I list users whose status is disabled on AS/400 ?
Hello everybody ! I have to make a cl program in order to list users whose status is disabled. I wanted to know if someone had  tips for me. Thanks

Answer Question   |  May 17, 2011  4:50 PM
AS/400 programming, AS/400 Reports, AS/400 user profiles, CL programs

Process Execution error – CD
Receive the below CD error: from one of the process when tried NDM CD error CDE0200    Escape                  40 Message . . . . :   Process execution not allowed.                       The Process Manager is not allowing execution of processes at this time.   Session limits may have been met, or process execution may have been     explicitly [...]

Answer Question   |  May 13, 2011  1:25 PM
Business Process Execution Language, Process Manager, V6R1

Find/Replace/Reformat Text in COBOL or CL400
As part of a rebranding exercise I need to create a program to find/replace variable length text within a file. I know I can do this easily enough via INSPECT/REPLACE (or maybe QCLSCAN in a CL) but has anybody got ideas about how to reformat afterwards (data in the file is stored typically in multiple [...]

Answer Question   |  May 9, 2011  10:17 AM
CL programming, CL programs, CL/400, COBOL/400

How to handle Null value in COBOL/400.
I have created a view that have Null value.I have populated this field on the basis of some conditions.But when i am reading this view in COBOL program it is going in infinite loop & reading the same record.

Answer Question   |  May 12, 2011  5:49 AM
COBOL, COBOL Programs, COBOL/400, COBOL/400 Errors

SAPMMC All Settings Gone after running CCCleaner , How to get all settings
Hello All SAPMMC All Settings Gone after running CCCleaner , How to get all settings back . I donot know what is SID ( System ID ), Instance etc. If this is not relevant to this forum plz let me know which forum …. Regards Rohit Running on Windows server 2003

Answer Question   |  May 10, 2011  6:05 AM
CCSID, SAPMMC, SID, Windows Server 2003

Is anyone user Mantis/400 bug tracker / help desk software?
I would be interested in hearing from anyone who is using Mantis/400 on an IBM i running i5/OS 6.1. There is a good article on the topic but is is from 2007.  We sure would like to hear from someone who has had recent experience with Mantis.

Answer Question   |  December 21, 2011  11:05 PM
AS/400, i5/OS, I5/OS updates, Mantis400, Zend

V6R1 on web box
Are there any known issues for going V5R4 to V6R1 on a web server 400 ? We did the update on our “normal” 400′s already with no major issues. Next week we do it on the 400 that hosts many of our web sites … so fear of the unknown that we might find trouble [...]

Answer Question   |  June 9, 2011  8:50 PM
AS/400, iSeries Upgrades, V5R4, V5R4 Upgrades, V6R1

Error Msg Clean Tape in AS/400 backup
Our backup is failing due to an error message that states we need to clean TAP01. We used a tape cleaner, also tried a solvent on swabs, tried a brand new tape and still get the error message. Any suggestions?

Answer Question   |  April 20, 2012  7:59 PM
AS/400 backup, AS/400 backup and recovery, Backup, Tape Backups