Print job looks like green bar and really light!
We have a print job that is created using a print file and it works great but only when printing it manually. When the job is run from batch using QSYSOPR as the user the page looks like green bar paper and for some reason it also prints very light.

Answer Question   |  November 13, 2012  6:23 PM
AS400 iseries, QSYSOPR

Printer Authorization iSeries
What on the iSeries uses the Printer Authorization List and what criteria depicts what we are supposed to add into it?

Answer Question   |  October 17, 2012  7:35 PM
AS400 iseries, iSeries printing

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

AS/400 How to create mulitiple user account profiles
I have to create 200 user profiles in AS400. How do I create multiple user profiles in batch mode or command line? I can do this on other operating systems such as UNIX. How can this be done on AS400?

Answer Question   |  August 28, 2012  5:01 PM
AS/400, AS400 iseries

how to see the order of users libraries in the job description on iseries
how to see the order of users libraries in the job description on iseries

Answer Question   |  June 28, 2012  9:19 PM
AS400 iseries, iSeries job

Hold spool files during CRTLF
I’ve just discovered that CHGCMDDFT CMD(OURSYS/CRTLF) NEWDFT(‘OPTION(*NOSRC *NOLIST)’) will not work. This is due to the OPTION parameter not having a default assigned. Is there a way to have the resultant spool file, during the creation of a file. default to a non-print outq?  

Answer Question   |  May 26, 2012  2:46 PM
AS/400 Spool Files, AS400 iseries, CHGCMDDFT

Get MYSQL data on iSeries
Datas are on a Linux server = mysql database and I want to transfert some datas to a DB2 database on iseries. At this time, I go throw Excel but sure we can do better !!…

Answer Question   |  May 14, 2012  8:10 AM
AS400 iseries, Linux, MySQL

arrays in rpg
can we sort a character array in descending order?(compile time array)

Answer Question   |  May 11, 2012  1:19 AM
AS400 iseries, AS400. RPG

pass array to clle
i created RPGLE,within that i defined compiled time array now i want to pass that array (at a time only one insex) to cllle but while i run this rpgle its give me run time error ..that  Error occurred while calling program or procedure *LIBL/practcl8 Message ID . . . . . . :   [...]

Answer Question   |  April 16, 2012  4:44 AM
AS/400 DB2, AS400 iseries, iSeries RPGLE

Sending eMail from iSeries
I’ve Configured something on my AS400 to send email to receipients. ,Then i tried to send mail using SNDDST command ,getting “Send distribution completed successfully”message ,but the email is not going out. Usually once we send mail,It shuld also show its presence here.. WRKLNK ‘/QTCPTMM/MAIL’ If any has idea,Pls help me in finding clue to [...]

Answer Question   |  April 11, 2012  5:22 AM
AS/400 v6r1, AS400 iseries, SNDDST

How to get caller program list by Calle program
Let assume that I have a program TESTR but i dont know how many program is calling to TESTR program. Is there any API or System file to get this. Thank You.

Answer Question   |  April 3, 2012  8:02 AM
AS/400 V6r1m0, AS400 iseries

OPNDBF then CLOF – the joblog indicates that the file was closed but it still appears in dspjob #14
                                 Member/    Record     File    I/O  —-Open— File            Library    Device     Format     Type       Count Opt Shr-Nbr B99FL161   XYZISDTA   B99FL161   B99FX161   LGL        4 IO  YES  3   When the NBR is > 1 the close only reduces the NBR by 1 – and the file still appears in the joblog. When the OPNDBF is used to actually [...]

Answer Question   |  March 30, 2012  8:07 PM
AS400 iseries, CLOF, OPNDBF

batching qsh sftp fails when using a variable for script
Hi all ! this works – SBMJOB CMD(QSH CMD(‘/QOpenSys/usr/bin/sftp -v -b  +                        /home/account/sftpcmd.txt +                               remote_user_account’))              +                                    JOB(SSHJOB) USER(WIRM5501) this does not SBMJOB CMD(QSH CMD( &CMDSHL ))   JOB(SSHJOB) USER(WIRM5501) where &CMDSHL is the exact quoted command in the working script I get this error qsh: 001-0014 Command /QOpenSys/usr/bin/sftp -v -b /home/… not found [...]

Answer Question   |  March 30, 2012  4:13 PM
AS400 iseries, iSeries Commands

as/400 INFDS
by using INFDS i do not want to write duplicate record into PF what is the requirements for that? 

Answer Question   |  March 19, 2012  7:29 AM
AS400 Data Definitions, AS400 iseries, INFDS

CPYFRMIMP inserting quotation marks
I am trying to use CPYFRMIMPF to copy a tab delimited file to a physical file.  The problem I have is that the file has commas (,) in the text and  CPYFRMIMPF automatically inserts quotation marks around the text whenever there is a comma in the field. For example, if my tab delimited file has 2 [...]

Answer Question   |  March 30, 2012  3:33 PM
AS400 iseries, CPYFRMIMPF, iseries v5r4

iSeries: Restore a file from TAPE to IFS DIR
I’m trying to restore a file (.nsf file) from a backup tape to IFS DIR,the source path name is much longer than command string size…not able to provide the fullname…I tired * at the end of path ,RST command restore coupld of .nsf files..but i need to restore only one. Does anybody experienced this ever? [...]

Answer Question   |  March 17, 2012  6:04 AM
.NSF files, AS400 iseries, iSeries V6R1

Ques Regarding Date in Iseries cobol.
Hi Group, I have a date field declared as packed field of 9, and date is declared as mmddyyyy format. My requirement is such that i need to pick the date field and 1 day to it. For example if the date is ’02142012′ i need to add 1 day to it and end result [...]

Answer Question   |  March 17, 2012  9:43 PM
AS400 iseries, COBOL, PGM

AS/400
i have two fields defined in RPGLE PGM one is in O spec as  O BCENTH Z   and one is in D spec as  D DS  D TCALC 10 0  when i done eval Statement   EVAL BCENTH = TCALC  it gives me compiler Error that *RNF7416 30 1002 053200 The types of the right and left [...]

Answer Question   |  March 17, 2012  9:32 AM
AS400 Data Definitions, AS400 iseries, AS400 RPGLE

As400/CLLE issue
can we load subfile through clle?

Answer Question   |  March 17, 2012  7:45 AM
AS400 iseries, CLLE

IBM I-series Data Download
I run a query in query/400 and tried to download that file using IBM Iseries. in the downloaded file, the column headers are in field ids and not the descriptions i have given in Query/400 report column formatting. Is there any way to download a file with column descriptions given in query? Please suggest.

Answer Question   |  March 17, 2012  4:25 AM
AS/400 Query, AS400 iseries, Query/400