synchronize jobs
Hi! How can I synchronize two or more RPGLE/CL programs that are executed via SBMJOB command, in order to avoid conflicts in using files and dataareas? If you could send me an example, it’ll be greatly appreciated. Thanx in advance, Meli

Answer Question   |  November 27, 2009  6:02 PM
CLP, RPG ILE, RPGLE

deal with microsoft access data base file from RPG program or clp
hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy

Answer Question   |  November 28, 2009  12:45 PM
Application development, AS/400, CLP, DB2 Universal Database, RPGLE

triggers
i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance

Answer Question   |  November 26, 2009  12:11 PM
AS/400, CLP, Data analysis, RPG, RPGLE

Synon/Cool:2E – internal/external func performance question
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external function call it, [...]

Answer Question   |  April 28, 2009  5:52 PM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE

ftp error codes
Hi! I’m writing a program that needs to execute the FTP command n times (where n is determined by the value of some field in a DDS table), only if there is an error during one of those executions. The question is: how can I determine if the execution failed? Thanks a lot! Meli

Answer Question   |  March 28, 2006  2:25 PM
CLP, RPG ILE, RPGLE

CPYTOPCD
I can successfully copy data from a PF to a PC doc (via CPYTOPCD) and I can successfully e-mail the resultant PC DOC from the AS400 (via SNDDST) However, when I try to e-mail a large PC Doc (2 meg) I receive about 20 e-mails with *.DTF attachments, which are virtually unreadable. Any ideas?

Answer Question   |  January 31, 2006  10:36 AM
Application development, AS/400, CLP, DataCenter, Email, PC/Windows Connectivity, RPG, Web development

Printing AS/400 ouptputs in diffrent printers,results in different outcome.
Our server is model 810 running on V5R2. We have a cheque printing program which outputs a spool which is used to print cheques.When the spool file is sent to a LEXMARK 2380/81 2390/91 series printers for print, the data is positioned perfectly in to the cheques. But we have some users who wants to [...]

Answer Question   |  March 17, 2012  4:08 AM
AS/400, CLP, DataCenter, Printing

OVRDBF in JAVA
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

Answer Question   |  November 25, 2009  6:25 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development

OVRDBF in Java
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

Answer Question   |  November 25, 2009  11:47 PM
Application development, AS/400, CLP, DB2 Universal Database, Java

To retrieve data from a remote system
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can’t be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series either [...]

Answer Question   |  November 23, 2009  11:11 AM
390, Application development, AS/400, AS/400 careers, Backup & recovery, Billing and customer care, Billing Support Systems, CLP, DataCenter, DB2, DB2 Universal Database, Development, Email, IBM Marketing Sound Off, Mainframe, Mobile, Mobile security, Network protocols, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, VoIP, Web development, Wireless, zSeries

Additional options for spool files
I would like to add an option to the Work with Job Spooled Files and Work with All Spooled Files screens that will perform exactly like option 2, except that the default for the DUPLEX parameter is (*YES). TIA for all replies.

Answer Question   |  November 23, 2009  11:54 AM
CLP, DataCenter, Printing

how to get the location of the User Options (updated usinf PF18 from PDM)
How can I access the Defaults information from Rexx / CL ? PF18 from PDM. I am looking for the values of Option file/lib/member. thanks Change Defaults Type choices, press Enter. Object library . . . . . . . *SRCLIB Name, *CURLIB, *SRCLIB Replace object . . . . . . . N Y=Yes, [...]

Answer Question   |  January 5, 2006  4:59 AM
Application development, CLP, DataCenter, RPG

ANNOUNCEMENT ? MORE NEW CATEGORIES ADDED TO THE ISERIES CATEGORY
UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security Printing & Output Web Development – Debra Tart, associate editor, Search400.com

Answer Question   |  December 23, 2005  6:47 AM
AS/400, Backup & recovery, CLP, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development

Source for a the DSPPGMMSG command
Dan wrote in with this question recently: “I’m trying to find the source for a command called: DSPPGMMSG. I have version 3.2 RPG & CL. I’m trying to run on a 5.2 box and this command is used extensively throughout the CL’s. Any info would be greatly appreciated.” Can you help Dan out? – Debra [...]

Answer Question   |  November 22, 2009  4:16 PM
CLP, RPG

Time Stamp Issues
Two questions about time stamp: 1. Is there a way to copy members/files etc so that the new member/file will still have the original time stamp (change date etc.) 2. Is there a way to update the member/file change date/time to a specific date/time (without actually saving it) ? thanks !!

Answer Question   |  November 22, 2009  3:53 AM
AS/400, CLP

verify data file
Hi everyone! I’ve a CL program that copies a spool file into a PF file. Is there any way to compare both files, in order to assure they have the same information? Thanx in advance Meli

Answer Question   |  November 22, 2009  7:24 PM
CLP, RPG ILE, RPGLE

SNDDST with .csv or .xls attachment
Can someone tell me how to send an attachment with a .csv or .xls? When I try, it sends it as .txt and when you open it up, it’s all garbage! Also, how can I add headings to an .xls or .csv when using cpytoimpf. All I’m getting now is just data. Thanks!

Answer Question   |  November 22, 2009  1:06 PM
CLP

Anyone ever use the SNDRPY command in CL?
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply “I” to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change [...]

Answer Question   |  December 14, 2005  4:56 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE

Special characters
I’ve got a situation where the users are entering characters into fields on the screen that I do not want them to enter. In COBOL, I can check these fields for alphabetic and numeric but I am under the impresion that this would not allow certain special characters that I do want to allow. Is [...]

Answer Question   |  December 8, 2005  4:35 PM
CLP, COBOL

SET verb in COBOL
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE ‘A’, ‘B’, ‘C’. 88 NOT-VALID-VALUES VALUE ‘D’, ‘E’, ‘F’. If I want to set the value of WS-SWITCH as ‘A’, we can do as [...]

Answer Question   |  December 3, 2005  3:36 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE