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

Working with the CHKDLO command
Betty wrote in with this question recently: “I am using the CHKDLO command, and then doing a MONMSG. Is there any way to capture the different messages (since there are five possibilities)? I?d like to be able to send the user a friendly message that would reflect the actual message that I get.” Do you [...]

Answer Question   |  March 27, 2006  5:50 PM
Application development

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

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

Check FTP
Hi, We have a situation where the external Vendor wants us to test if a site is live and then transmit data. This needs to be done via FTP. We cannot use PING. Is there some sort of Check FTP connection command that is available so we can issue the command, check the return code [...]

Answer Question   |  March 17, 2006  1:25 PM
Application development, Security

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

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

QTXTSRC wrap commands
I am trying to enter in a command for FTPing that will execute a command on a remote system but I get cutoff at 80 characters. How do you wrap to the next line ? here is my command that is missing the last ‘)’: quote RCMD RSTOBJ OBJ(*ALL) SAVLIB(R36MODSDTA) DEV(*SAVF) SAVF(DISASTER/DISASTER Thanks, Andy

Answer Question   |  March 9, 2006  10:16 AM
Application development, Career development, DataCenter, Development

Robot – Change object security of fle REPPF in RBTREPLIB library
I am planning to read file REPPF from RBTREPLIB library from a program. The security of this object is setup as the following: User Object Authority *PUBLIC *EXCLUDE RBTUSER *ALL Because the way the security is setup, the program only will work for those users that complies with this security. Can I change the object [...]

Answer Question   |  December 1, 2009  2:27 PM
Application development, AS/400, Development, Printing, RPG, RPGLE, Security, Software, Tech support

Printing Typographic/monospaced
I’m using the IBM Server iSeries to generate spoolfiles. I want to use typographic fonts (some characters use more space than others) eg helvetica. If I have columns of figures this is not good. For this it would be better to use a monospaced (uniformly spaced) font. Do you know two fonts, one typographic und [...]

Answer Question   |  March 26, 2006  7:51 AM
Application development, Printing

GDDM on V5R4
Can I display graphics on the screen Or print the graphics using GDDM on V5R4?

Answer Question   |  December 1, 2009  2:24 AM
Application development, AS/400, Printing, RPG, RPGLE

Retrieving Job Info
I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than [...]

Answer Question   |  December 1, 2009  5:19 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE, Web development

Hexadecimal
Can someone please tell me the hex value of the [TAB] key Thanks

Answer Question   |  December 1, 2009  7:17 AM
Application development, AS/400, Development, PC/Windows Connectivity, Printing, RPG, RPGLE

Mapping a drive from QNTC
I have to have a drive from a Windows server permanently mapped to my ISerie for batch FTP purposes. When I issued the command MKDIR QNTC/servername, it worked fine. The problem is that at IPL time, the link is broken, What’s the best way to keep the connection with the Windows server? Should include the [...]

Answer Question   |  November 30, 2009  4:35 PM
Application development, AS/400, DataCenter

Move Date field to numeric field in COBOL
Is there a function in COBOL to move a Date field to a numeric field (yyyymmdd)?

Answer Question   |  March 2, 2006  1:58 PM
Application development

XLS integration to Iseries
I am looking for information on getting XLS data to the Iseries. Specifically would like to get XLS into XML format so an EDI/XML translator can pick it up and send through our existing EDI processes. The XLS will come from e-mail clients.

Answer Question   |  March 3, 2006  10:51 AM
Application development, CLP, E-business

SDA design field
Edwin wrote in with this question recently: “We have created a PF with six fields; one field has a 500 character length. How can I put or display the field in SDA with a 500 field length? And can we design a overlapping field with subfile?” – Deb Tart, associate editor

Answer Question   |  February 28, 2006  10:42 AM
Application development

Retrieving data into a COBOL/400 program
Cynthia wrote in with this question recently: “How can the contents of a data area be retrieved into a COBOL/400 program?” – Debra Tart, associate editor

Answer Question   |  March 3, 2006  10:34 AM
Application development