database
if i have one pf (pf009) and one logical file (lf009) on pf009. how we can add one more field after compalisation of logical file ?  

Answer Question   |  June 8, 2012  5:17 PM
AS/400 database

As400
i need to convert folling rpgle code into rpg EVAL      CMDKEY = %TRIMR(CMDKEY) + ‘ ‘ + F6COM 

Answer Question   |  June 7, 2012  2:14 PM
AS400 Data Definitions

Recompile CL program
Hi, We added few new fields to an exising Physical file. When I check for the dependents for the changed Physical file in ALDON it shows 250 dependent objects. Do I need to recompile all 250 objects? Thanks, Elan

Answer Question   |  June 6, 2012  1:18 PM
AS/400, CL Program

CL/QMQRY
i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]

Answer Question   |  June 7, 2012  12:16 PM
AS/400, QMQRY, SQL procedure

CL Programming
PGM                    DCL VAR(&TIME) TYPE(*CHAR) LEN(6)                    DCL VAR(&DATE) TYPE(*CHAR) LEN(6)                    DCL VAR(&YEAR) TYPE(*CHAR) LEN(2)                    RTVSYSVAL SYSVAL(QTIME) RTNVAR(&TIME)          [...]

Answer Question   |  June 7, 2012  9:36 AM
AS/400, PGM

How do you code footers in DDS Print File?
I need to print a footer on every page of a report. Thought it would be simple like headers. If anyone has the answer let me know. Thx.

Answer Question   |  June 5, 2012  11:56 PM
AS400 RPGLE, DDS Printer files

Printer Overlays
What is the simplest way to create an overlay for a printer file? I’d prefer to go generic, rather than buy a package.

Answer Question   |  June 6, 2012  6:36 PM
iSeries, iSeries 720

CPYTOIMPF .txt file shows garbage on IFS when viewing on windows
CPYTOIMPF .txt file shows garbage on IFS when viewing on windows but when using wrklnk it looks fine, please help.Below is the query I am using CPYTOIMPF FROMFILE(BIN815PA) TOSTMF(&PATHDAT) + MBROPT(*ADD) FROMCCSID(*FILE) + STMFCODPAG(285) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) CPYTOIMPF FROMFILE(BIN815PB) TOSTMF(&PATHDAT) + MBROPT(*ADD) FROMCCSID(*FILE) + STMFCODPAG(285) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) CCSID of the file (BIN815PA) [...]

Answer Question   |  June 8, 2012  5:35 PM
AS/400, CPYTOIMPF

Security and QSECOFR number of sign-ons
For security purposes, the number of sign-on attempts can be *NOMAX or as few as one. I configured for 3 maximum sign-ons. Does anyone know if the OS/security sums the total number of sign-on attempts from the device only before it disables the device, or does the OS not count total from the device, but [...]

Answer Question   |  June 4, 2012  10:21 PM
QSECOFR, Security, sign-on

CPF3309 error message
While executing CPYSPLF command I get the error CPF3309 with the error description , ” No files named &1 is sctive”,Please let me know your thoughts and advice solution for the same

Answer Question   |  June 6, 2012  7:17 AM
CPYSPLF

RPGLE opcode similar to SNDF in CL
Is there any way we can display a message “Processing” while the program is building the data in a subfile. In CL we can use the SNDF command to send such message to the display. Please help.

Answer Question   |  June 1, 2012  10:43 AM
CL, RPGLE, SNDF

Clear a logical file
Is there any command to clear a Logical File?

Answer Question   |  May 31, 2012  5:30 AM
Logical File

Upgrade from V5R4M0 to V6R1
Hi, We have 9406-520 machine with V5R4M0 OS. We are planning to update with V6R1 os by this month end. I want to know, is there any CUM PTF required for updating OS or I can Update directly.Please suggest. Thanks, GK

Answer Question   |  June 7, 2012  4:12 PM
AS/400 administration, AS/400 Upgrade Assistant, AS/400 upgrades

Field reference file
2. Can I delete a field reference file if I have other files which refer this field reference file?

Answer Question   |  May 29, 2012  11:50 AM
Field Reference File

Dumb Terminal on iOS V6R1
Hi, Is it true that dumb terminal connection on V6R1 iOS removed? We planning to upgrade to V6R1 and we have existing Dumb terminals connected on our current machine OS V5R3. What should we consider before and during the upgrade? Thank you.

Answer Question   |  June 11, 2012  2:38 AM
iSeries, iSeries application development tools, iSeries applications, iSeries data center, iSeries networking

AFP report to PDF (20bytes naming convention for PDF)
Hi All,  I have a requirement to save my splf (reports with overlays – AFP format) in an IFS folder.  I need to store them with a custom 20 byte name and in a PDF format.  I tried SPL2PDF and it works as long as there are no overlays. So is there anyway to convert [...]

Answer Question   |  June 1, 2012  7:19 AM
AFP, PDF

As/400 to lexmark printer,print on hold
Trying to print from my AS/440 to lexmark 540n,when I release the file from the AS/400 a message appears saying the printer the lexmark has put the file on hold and cancelled the printing

Answer Question   |  May 28, 2012  5:16 PM
AS/400 Transfer

level check error
I currently have a DSPF & a CL that work. I added a field to the DSPF and added logic to the CL to use the new field. Both compiled successfully (DSPF and then CL). When I run the CL, I am getting a CPF4131 (level check). The CL is pointing to the correct DSPF. [...]

Answer Question   |  May 29, 2012  1:06 PM
AS/400, CL, DSPF, iSeries

AS/400 question
how can we see records in a physical file without using run query?

Answer Question   |  May 30, 2012  7:53 PM
AS/400, AS/400 Query

iSeries number of Web users
How can I find out who is logged into the system via an applications web interface?  i.e. Lawson, Jgo, etc.

Answer Question   |  June 5, 2012  7:50 PM
AS/400 applications, AS/400 v5r4