“Command prompting ended when user pressed F12″
I have a CL that calls a RPG selection subfile pgm. If the user presses F12 during the selection process, I want to send a message to the user similar to the one shown in the subject line of this post. I have experimented with various settings of a SNDPGMMSG command from the CL but [...]

Answer Question   |  December 3, 2009  10:39 AM
CLP, RPG

Copy and pasting cell in Excel 2002 to AS/400 application
I am trying to copy a cell with multiple lines of information in Excel 2002 and pasting it to input fields (horizontal input lines) in our AS/400 application. The problem I am experiencing is that the information will not paste or wrap correctly onto the lines (area) that I have selected. Only the first line [...]

Answer Question   |  April 3, 2006  12:36 AM
AS/400, PC/Windows Connectivity, Printing, Software

QBNLPGMI api examples
Hello! Can anyone please help me? I didn’t work with api’s, and try to get information about bounded modules in ILE C programs. And I try to use QBNLPGMI api. Does anyone have some examples of using this api in C or CL programs? Thanks in advance. Dalibor

Answer Question   |  December 3, 2009  11:16 AM
Application development, AS/400, CLP, Printing

5250 user gets another’s session
We have a user (5250 emulation) whose green screen gets an Input Inhibited(II) in lower left of screen. After pressing various keys (on screen) he gets another user’s screen. He cannot reproduce at will . This happens infrequently. Has anyone seen this problem where the 5250 session is not terminating completely/properly (or not fast enough) [...]

Answer Question   |  March 30, 2006  11:30 AM
AS/400, DataCenter

Overlay creation from a color image using an AFP driver
We want to send PDF files from our iSeries using a color overlay. We have installed Infoprint Server (evaluation version) for the PDF conversion. We are trying to use an AFP Printer Driver to create an AFP file that we upload to the iSeries to create an overlay. Our problem is that the quality of [...]

Answer Question   |  March 28, 2006  9:19 AM
Application development, AS/400, Printing

Client Access truncating blanks
I have some files that I have transfered from a AS400 with client access and it is truncating the blanks at the end. How can I not have this done.I need the blanks to stay there.

Answer Question   |  December 2, 2009  5:08 PM
AS/400, PC/Windows Connectivity

Opening a physical/member file on a Windows Systems
I am trying to open a file on my 400 on a Windows XP machine. I have mapped a drive to the file using Netserver and can navigate to the file fine. However, when I try to open in on a Windows PC, I get ‘invalid function’. I tried turing on the auto convert in [...]

Answer Question   |  December 2, 2009  3:08 PM
AS/400

CBT AS400/iSeries Training courses
Hello, Our company is looking for a vendor that has current offering for i5 training courses (V5R3M0)and that could provide me with best available that might suit our Operations Dept. I’ve contacted one vendor but their training courses were developed before the i5 series. They do not cover the new features the i5 offers. We [...]

Answer Question   |  March 24, 2006  2:44 PM
AS/400, Training

ISeries ODBC Error SQL0104 using DB2 UDB (Replicating Notes data to AS/400)
Does anyone know why I get these ODBC errors or what these errors mean while trying to replicate some fields in Notes to a db on the AS/400 Rel 5.2? Starting Replication: REP_POTEST101 03/23/2006 08:00:34 AM Replicating Documents from <LNK_PURCHREQ.NSF: test POReq> to <LNK_POComments_AS400: SUPLIB.PODTLCMT> …… 03/23/2006 08:00:48 AM 2 Documents remaining to be processed [...]

Answer Question   |  March 23, 2006  9:27 AM
AS/400, Lotus Domino, SQL

Transfer / Copy OS/2 files with Extended data attributes to iSeries
We have 1,000′s of files that were originally created in OS/2. These files were created (OCR) from an image file so we could do text searches on them. OS/2 created these files with Extended Data attributes. We now need to copy these OS/2 files from an XP workstation to an iSeries networked drive. The problem [...]

Answer Question   |  December 2, 2009  4:39 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, PC/Windows Connectivity

System Setting For Created Libraries
Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.

Answer Question   |  November 15, 2010  2:29 PM
Application development, AS/400, Backup & recovery, DataCenter, DB2 Universal Database, RPG, RPGLE

Cursor Progression on protected fields
I want to use FLDCSRPRG to control the cursor movement on fields I have protected. The fields are protected because I need the user to prompt a lookup window and enter only correct selections from a specific table in these filds. However, If I protect the field with DSPATR(PR), the FLDCSRPRG does not work, the [...]

Answer Question   |  March 22, 2006  11:48 AM
AS/400, RPG, RPGLE

Maping AS/400 shared folders in windows Xp
Hi, I am unable to explore the AS/400 shared folders on the PC having Windows XP Sp2, but printers are visible. There is no issue as such on OS windows 95/98. Can any one help me in this regard… Thanks satish

Answer Question   |  December 2, 2009  12:06 AM
AS/400, DataCenter, PC/Windows Connectivity, Security

using QDBRTVFD to find SQL view create statement
Hello all. Just wanted to know if anyone out there knows how to use QDBRTVFD to retrieve the SQL view create statement. For our update process, I am scanning the customer’s libraries to find buisiness views. When I find them, I want to extract the SQL view create statement (like in DSPFD) and place it [...]

Answer Question   |  December 2, 2009  12:20 PM
Application development, AS/400, CLP, DB2, DB2 Universal Database, RPGLE, Tech support

Mainframe to SAP
Hi, I’m a cobol programmer working on Mainframes with a work exp. of 2 yrs. I’ve worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the Industry, do you think [...]

Answer Question   |  October 31, 2011  6:40 AM
390, ABAP, Application development, AS/400, AS/400 careers, Backup & recovery, Basis, Billing and customer care, Billing Support Systems, Career development, Certifications, CLP, CO, Database, DB2, DB2 Universal Database, Development, ED, Email, Enterprise Desktop, FI, Financials, IBM Marketing Sound Off, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, Linux, Mainframe, MySAP, MySQL, NetWeaver, Oracle, PC/Windows Connectivity, RIVA, RPG, RPGLE, SAP, SAP APO, SAP careers, SEM, TR, Training, Upgrades / implementations, Windows, zSeries

BRMS – displaying how much data is saved to a cart
Guys, is there a simply and accurate way to display how much data is saved to a cartridge using BRMS, or native OS/400?? We have 800GB capacity carts and need to work out how much of the cart is being used per backup. Things I have tried: * WRKMEDBRM opt.5 (after STRMNTBRM RTVVOLSTAT(*YES)) * PRTMEDBRM [...]

Answer Question   |  December 3, 2009  10:41 AM
AS/400, Backup & recovery, DataCenter

Activation Groups
I am changing some CL programs and COBOL/400 programs to ILE and ran into problems with OPNQRYF. I think it is due to the fact that the default activation groups when compiling these 2 different types of programs are different, so the results of OPNQRYF are not available to COBOL program. Can I compile all [...]

Answer Question   |  December 1, 2009  10:37 AM
Application development, AS/400, CLP

Can Linux be used on a PC acting as the iSeries system console?
I have a 9406 model 810 with a primary and one secondary partition (both running OS/400 V5R2). Currently there are 2 PCs running Windows XP set up to act as the system console (one for each partition). I’d like to know if these PCs can run Linux instead of Windows and still run Operations Console [...]

Answer Question   |  March 15, 2006  1:16 PM
AS/400, DataCenter

SNDDST sending to some but not other email addresses
I am using the SNDDST command to to send an attachment of size 500 kb to a user in a particular domain say daydreamer@media.com I also ensure that an additional recipient is included and this recipient would be a private email address eg ihdcsl.hotmail.com I am receiving the email to the personal address but not [...]

Answer Question   |  March 17, 2006  7:13 AM
Application development, AS/400, CLP, Email, RPGLE

BCC Disk drives
Does anyone know how to get to BCC to make a purchase of their disk drive?…..any feedback for or against these drives Thank you in advance….

Answer Question   |  March 14, 2006  12:48 PM
AS/400, IBM Marketing Sound Off