iSeries SQL ISNULL Equivalent
What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

Answer Question   |  January 27, 2011  10:28 PM
AS/400, iSeries Access, iSeries Navigator, iSeries SQL, T-SQL

Sign out RPG users after certain amount of time
RPG Screen Timeouts. We need to sign-off our users automatically after a certain period of time.  I was wondering if anyone has the code to do this? Since we are using JDE world, it would be nice to have RPG III, but can also call an ILE program. Lenny

Answer Question   |  January 31, 2011  2:13 PM
AS/400, Connection timeout, RPG Code, RPG III

AS400 POWER6: Unable to Run Program
Hello,  We have multiple IBM AS400 machines (150, 250, 520) which run various programs. Recently we purchased a new Power 6 machine for the 1st time. However when running a particular program we get the following error:     Job 016561/QSECOFR/DSP01 started on 01/20/11 at 15:42:40 in subsystem QBASE  CPF1336 received by JOBPRT at 5000 (C [...]

Answer Question   |  May 10, 2011  2:11 PM
AS/400, AS/400 error messages, AS/400 errors

Problems with DB2 program
I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve [...]

Answer Question   |  January 26, 2011  3:49 AM
AS/400 Parameters, COBOL, DB2, DB2 administration

AS/400 to Linux Box
ITKE,  I saw where in 2009 you had an AS/400 box and I believed you had changed it over to Linux?  I have a iseries 270.  it is running fine except I dont know much of the AS/400 command language.  I’d like to learn the language so what books would you suggest also, i like [...]

Answer Question   |  January 26, 2011  3:35 AM
AS/400 administration, AS/400 to Linux OS, iSeries 270, Linux, Linux administration

Direct program in a different LPAR
If I have 3 LPAR’s. IF1, IF2 and IG3. IF1 and IF2 are primary and IG3 is backup LPAR. Now if I have to clear and restore libraries on IG3 from IF2 but my program is on IF2. Now how can I go straight in to the command CLRLIB right after tenet from IF2. But my program in [...]

Answer Question   |  January 28, 2011  11:46 PM
LPAR, MIMIX, MIMIX on iSeries, Telnet

Add library to jobD library list
Does anyone have a utility that can add a library to the exsiting libraries in a jobD? I would like to avoid executing CHGJOBD over and over.

Answer Question   |  February 7, 2011  9:33 PM
AS/400 jobs, AS/400 Library, Job Description, JOBD

How to convert spool file to programs in AS/400
i have a file accidentally delete that file but I have contain spool file how to convert spool file to source file please give Example code in cl or rpg

Answer Question   |  January 25, 2011  2:26 PM
AS/400, AS/400 Source Files, AS/400 Spool Files, Spool files

How to retrieve the jobq in which my current job is running in CL?
I have a CL program which will run as a SBMJOB. Now I want to see whether it is running in QBATCH jobq. If not in QBATCH, I have to resubmit it into QBATCH. How I can do it in CL?

Answer Question   |  January 27, 2011  2:04 PM
CL Program, JOBQ, QBATCH, SBMJOB

File Transfer from PC to iSeries
How do I transfer a file from the PC to the iSeries?

Answer Question   |  January 27, 2011  11:34 PM
File transfers, iSeries, iSeries FTP

Print MICR code on iSeries AS/400
I have the micr code fonts resident on my AS400 V5R4 but I can’t figure out how to print micr code fonts for bank checks using XOAE13. How do you call the font from a Printer file DDS and is there anything unusual about the RPG program used to print checks? I can’t find any [...]

Answer Question   |  January 26, 2011  10:08 PM
AS/400 printing, AS400 printing jobs, iSeries RPG programming, MICR, MICR code

How to include a signature on a spooled rpt to be emailed
Hello We want to email letters that we currently are printing off the I5..We have scanned the signature on to the I5..how can we include this signature at the bottom of each letter to be emailed? Thanks

Answer Question   |  January 29, 2011  8:40 PM
AS/400 printing, AS/400 Signatures, AS/400 Spool Files, i5

Office Vision on AS/400
I can not edit (Change) an existing office vision document. My as/400 profile is in teh WRKDIRE. I can 3-Copy, 4-Delete & 7-Rename. But no other document options are available for me. Any ideas?

Answer Question   |  January 25, 2011  4:04 PM
AS/400 command functions, AS/400 commands, Office Vision, WRKDIRE

iSeries Access Macro to run from a program.
I think I’ve asked the same question some months ago but didn’t get any answer and couldn’t be able to find one myself. The issue is: i have an iseries access macro that i run every day, but I do it from the Play button in the access menu. I would like to put this [...]

Answer Question   |  January 25, 2011  2:38 AM
iSeries Access, iSeries macros, Macros, V5R4

AS/400 query security
I have a library we will call liba. In liba i have files for different companies. For eg: files [strong]aa01.itm[/strong] is an inventory file for co# 01 and[strong] bb01.cms[/strong] is a customer file for co# 01. I also have files[strong] aa07.itm[/strong] and [strong]bb07.cms[/strong]. These files are for co# 07.I want to grant someone access to only [...]

Answer Question   |  January 24, 2011  3:41 PM
AS/400 Query, AS/400 Query Security, AS/400 security

How do you write to a source file .TXT in rpg?
I am using a .TXT file in QCLSRC for FTP input. Instead of having the 4 records sitting there all the time. I want to be able to write to the .TXT file when a program is called.

Answer Question   |  February 1, 2011  7:19 PM
AS/400, AS/400 FTP, QCLSRC, txtsetup.sif

Batch Scheduling Of Jobs
Currently, we are creating 80-100 jobs for a complete batch schedule to execute against individual db2 regions (1 entire batch schedule per region). Is there a way to create one series of batch jobs and use that set against all regions? I apologize if this makes absolutely no sense.

Answer Question   |  February 3, 2011  1:59 AM
AS/400 batch jobs, Batch jobs, DB2, z/OS configuration

AS400 – Physical Files
Hi I have some qusetion in AS400 How can we convert rows into columns and columns into row for a PF in AS400. Please send me the coding for this requirement. Thanks

Answer Question   |  January 22, 2011  11:01 AM
AS/400, AS/400 DB2, Physical Files

APPN session initiation attempt has failed
I get this message when someone or something is trying to connect to a system that has since long been Obsolete. My question is : is there a way to get to the job that is trying to get a connection to that location?

Answer Question   |  January 25, 2011  9:26 AM
APPN, AS400 APPN Location, OS/400, V5R4M0

Procedure imported in AS/400
Can any one tell me, how to get the list of procedures Inpoterd by a program which ic reated by CRTBNDRPG.

Answer Question   |  January 21, 2011  9:26 AM
AS/400, AS/400 stored procedures, CRTBNDRPG