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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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