CL opnqryf question
In my CL program, I have an Opnqryf and a Rcvf following that. It reads the file till EOF has reached. Now I have another opnqryf on the same file. I have closed the file just before the opnqryf but since the first loop has reaced eof, my second opnqryf is not retrieving any records. [...]

Answer Question   |  May 21, 2013  12:12 PM
AS400 Command

Message ID
If we deleted a message queue,we will have a message ID.Could you please tell the message ID

Answer Question   |  May 3, 2013  1:53 PM
AS400 Command

ALCOBJ on a Data area
Hi , I have one program which starts a job , I do ALCOBJ on a dataarea so that if the job is already running and someone tries to start the job again i can show the error that job is running ALCOBJ OBJ((&LIBLDTAQ/&DTAAA *DTAARA *EXCL)) WAIT(0) MONMSG MSGID(CPF1002) EXEC(DO) SNDPGMMSG MSG(‘Mikaodo Job Schedular is [...]

Answer Question   |  March 18, 2013  12:07 PM
Allocate Object, AS400 Command, Data Area

Set a Variable in Hexadecimal Value RPG or CL
Hi everybody, I would like to use variable value for settin color on display, I usually do as follow: D $color S 1A INZ C eval $color = X’28′ and obtain color red ! Now my user would like to change it and type 38 into the numeric variable $V1. $v1 = 38 . It [...]

Answer Question   |  January 11, 2013  6:37 PM
AS/400, AS400 Command, Hexadecimal values

action diagram.
HELLO FRIENDS, I have recently got a project in which i have to code the modules through synon. As I m new to this platform, i need a little help regarding the coding which is done in an action diagram. and how to use the built in functions in an action diagram and how to [...]

Answer Question   |  December 26, 2012  4:27 AM
AS400 Command, Synon, Synon 2E

AS400 to Oracle query
Can I query a Oracle database directly from AS400 using interactive SQL.Will I need to install any driver or is there a way around?

Answer Question   |  December 4, 2012  3:03 PM
AS400 Command, Oracle, SQL

CPYF
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]

Answer Question   |  November 17, 2012  7:47 PM
AS400 Command, CPYF, DB2

How to create a Spool file
I queried on a file it gives me hundreds of records. Is it possible to create a spool file with these record? If yes then please tell me how?

Answer Question   |  October 22, 2012  11:39 AM
AS/400 Spool Files, AS400 Command

How to create an EXCEL
I queried on file and fetch nearly 10000 records.I want these recrods in the excel,however I dont want to copy and paste.It will take a lot of time. Is there any method or command in AS400 which can do this task,

Answer Question   |  October 20, 2012  11:33 AM
AS400 Command

scheduled job
how to check the user that changed a scheduled job from held to release?? because we have a backup job in WRKJOBSCDE that is in held and being submitted daily manually. but what happen is that it run it self in QBATCH and we are also submitting the job again. so it create a duplicate [...]

Answer Question   |  October 20, 2012  1:30 AM
AS400 Command

what happens when you forgot to transfer job to qctl then you ipl
i forgot to issue the command TFRJOB (QCTL) to our system after i ended all subsystem. then i tried to issue it. but i did receive an error. so i did panic and thought that IPL will solve it. and so I did. what could be its complication for i was to go for a [...]

Answer Question   |  October 9, 2012  2:46 AM
AS400 Command

AS400 system time and date.
What is the command or procedure for changing the system as400 date. Please be very specific.

Answer Question   |  October 4, 2012  8:41 PM
AS400 Command

How to reduce the time taken to select the records from huge keyed physical file having 180 Million records
Hi All, I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file. I am accessing keyed logical file based on [...]

Answer Question   |  October 2, 2012  3:23 PM
AS400 Command, DB2/400, Physical File

Automatic DASD
Hi everyone,   I was how can i have an hourly display of DASD in our system. I want to use this for monitoring purposes   Thanks in advance Jose

Answer Question   |  September 12, 2012  1:18 PM
AS400 Command

How to add Mulitple DNS Suffix
I need to add more than one DNS suffix in (CFGTCP+12) Domain name filed…but it looks,i can only add one suffix…does anybody has any idea in overcoming this limit? Thanks

Answer Question   |  August 20, 2012  10:41 AM
AS400 Command, CFGTCP, DNS, iSeries, Network

Using CL to COPY text files to QNTC share
I have tried to use CPY to copy file from the AS400 to a QNTC windows share and I get an error that the command is not supported. What command can I use to copy these file over?

Answer Question   |  October 8, 2010  2:19 PM
AS400 Command, CL Commands, QNTC File System

Sorting thru FMTDTA QFMTSRC
 In my application FMTDAT is used for sorting. FMTDTA     INFILE((*abcdef) +                            (*abcdef) +                                (*avbgrf) +                                (*abcdef) +                               (*abcdef) +                                 (*abcdef)) +                                OUTFILE(abcdef) +                   SRCFILE(QFMTSRC) [strong]SRCMBR(abcdef[/strong]) +              OPTION(*NOPRT)   Code in SRCMBR   [strong]abcdef1[/strong]:     HSORTRE   69A        3X 256  I P    1   2NEC139            IAP   1   2NEC135            IAP   1   2NEC136            FNP   1   2       [...]

Answer Question   |  July 5, 2012  6:55 AM
AS/400 command functions, AS/400 commands, AS400 Command, FMTDTA