Outfile printing
In CL, I’ve created a outfile out of dspobjd cmd. To this file, i’ve filtered a column using opnqryf. I’ve copied the output (cpyqryf) to a new file. While doing this, i’m getting the error data option was not allowed with open option’ The log shows :The first file is created-> added to library. Seqonly [...]

Answer Question   |  October 16, 2012  7:14 AM
CL, cpyqryf, OPNQRYF, RPG, RPGLE

Need to replace Data transfer RXFERPCB.
Hi All, Have an old program using data transfer. It works fine from the green screen. New Mapics Software in IDF Level 1 does not like the transfer and stops it with a client error. What is the best way to replace this? Tried CPYTOIMPF and sent the physical file to a folder on the [...]

Answer Question   |  October 15, 2012  8:14 PM
CPYTOIMPF, File Transfer, FTP

How to create Report on WRKOBJ’s output using a pf?
Hi gotta develop a pf which will show all the objects under all user’s library. Please suggest

Answer Question   |  October 15, 2012  8:21 AM
iSeries, iSeries AS/400, RPG, RPG Code

AS400 i series – command/field for qry report “last payment date” and during scheduling – how to flag appts
I am new to using AS400 i series/applications and am becoming familiar with creating/working with existing qry reports.   I am attempting to tweak an existing qry report so that it will also pull (from field needed) data  to include a customer’s “last payment date”.  I realize that this can be done in the Acct. [...]

Answer Question   |  October 15, 2012  10:13 PM
AS/400 queries, AS400 iseries

transfer problem on iseries
How do I transfer up a record upto 500 long and not have it wrap on the AS400 ? It will only handle 300

Answer Question   |  October 12, 2012  6:50 PM
Transfer Data To iSeries

AS/400
How to change the field name in PF?

Answer Question   |  October 12, 2012  12:19 PM
AS/400, AS/400 administration, PF

sqlcmd :0 rows updated
When I run exec dbo.subprogram from sql server management studio, it executes and returns result as many rows affected: But when I run from cmd C:Usersmssadmin>sqlcmd -S servername -d databasename-q “EXIT( exec dbo.subprogram)” it retunrs as 0 rows affected. What could be the problem

Answer Question   |  October 11, 2012  9:55 AM
SQLCMD

How to omit one IFS file from BRMS on AS400.
Please let me know how to omit one particular IFS file from daily backup. The IFS ( /QIBM/UserData/OS400/ResourceMonitoringControl/var/vpd/Hardware.xml) is not being saved on daily backup due to job lock. Hence user requests us to omit this file from backup. Please assist me to omit the IFS file.

Answer Question   |  October 10, 2012  6:38 PM
AS400 backups, BRMS

Strange DNS resolution.
Hello. This week one of our AS400 got me all surprised. I do not know what to do, where to look, so I would like to ask here…just in case. On this AS400, among others there are four host table entries. These entries are set to 2.xxx.xxx.xxx addresses. The DNS has 9.xxx.xxx.xxx addresses. Customer does [...]

Answer Question   |  October 11, 2012  4:55 PM
AS/400, DNS, Host table, PTF, TCP/IP

Problem with CMD/CL and *PNAME type (Path name contains embedded nulls.)
So I am giving a good effort into writing a CL/CMD pair to start one of our programs from the command line, but I’ve hit a snag.  Here is my CMD source: CMD PROMPT(‘Start Engine’) PARM KWD(PGM)      TYPE(*NAME)  LEN(10) DFT(‘TRAN_ENGV2′) PROMPT(‘Engine Program Name’) PARM KWD(PATH)     TYPE(*PNAME) MIN(1) PROMPT(‘IFS Directory’) PARM KWD(PORT) [...]

Answer Question   |  October 10, 2012  3:30 PM
CL, CMD Source, i7, V7R1

Using cursor in SQLRPGLE
Can i use single cursor for multiple SQL statements? ex:  declare c1 cursor for select * from ……. also declare c1 cursor for select * from xxx

Answer Question   |  October 10, 2012  11:37 AM
SQL statement, SQLRPGLE

AS400 object authority
How can we restrict a particular user to the newly created objects in a particular library. By default the objects creating as *public with *CHANGE authority and this user having the access for newly created objects, so please let me know the steps or procedure to restrict this user for newly created in objects. By [...]

Answer Question   |  October 10, 2012  8:01 AM
AS/400, AS/400 objects

iseries printing problems
We have boca printer for printing tickets , when we disconnect and connect printer it appears to be connected but we have lots of messages say “unable to obtain lock on prtxx device prtxx” in the message Q.. we tried lots of commands such vrycfg , wrkobjlck , wrkwtr … it never response giving the [...]

Answer Question   |  October 9, 2012  10:05 PM
Printing AS/400 performance

problems with printer in s36
we have boca printers for printing tickets … when we disconnect printers and reconnect it again a lots of messages appears in the message q say “unable to obtain lock on device” we tried vrycfg , wrkwtr , and other commands we tries also to change the writer configuration it says ” prtxx not eligible [...]

Answer Question   |  October 9, 2012  2:43 PM
Printing AS/400 performance

Getting error messages from qsysopr
Need to gain access to qsysopr error messages coming from custom apps written. Do NOT want an agent on box. Any thought son how to gain access to these error messages?

Answer Question   |  October 8, 2012  5:16 PM
QSYSOPR, SNMP

Converting amount in character field to numeric in rpgle
Hi, How to convert the amount value in character field(Eg: ‘ 5,000- ‘) to numeric in rpgle. I used %DEC built in function, it shows decimal data error. Is there any bulit in function or opcode to convert ‘ 5,000- ‘ to numeric field in rpgle ?

Answer Question   |  October 8, 2012  11:04 AM
RPGLE

Retreving source file names of a library
Hi guys, I need to copy all the objects(both DB file and PGM) from a library to another library except the source file(PF-SRC). I tried DSPFD FILE([file library]/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE([outfile library]/[outfile]) then selecting those records where ATDTAT = ‘S’. But the outfile consists of only DB files. But I need RPGLE/CLLE program names also. [...]

Answer Question   |  October 8, 2012  9:20 AM
CLLE, iSeries V5R4MO

Expand Counter Size in WRKQRY
I use WRKQRY to produce a summary file. I use ’5′ to indicate the counting on a special field. The counts is larger than 9,999,999. I got field overflow. How to expand the counter field?

Answer Question   |  October 8, 2012  9:25 PM
AS400 -WRKQRY, WRKQRY

How to move tapes from I/O slot to storage slot via BRMS
How to move tapes from I/O slot to storage slot via BRMS

Answer Question   |  October 5, 2012  6:48 PM
AS/400 backup

IBMi iAccess (client access) ‘Run The Same’
Hello, What is the purpose of the iSeries Access for Windows’ RUN THE SAME? It is found on the FILE drop down menu in iSeries Access for Windows. I have a user who opens session 1 by clicking as normal on the desktop icon. Then uses File-Run The Same to open session 2. Continuing to [...]

Answer Question   |  October 5, 2012  5:38 PM
Client Access, IBMi, iSeries, iSeries Access for Windows, run the same