CL400 parameters
hi, i would like to know how to copy a physical file and its corresponding logical file from one library to another by and these four paramaters &filnam,&fromlib,&tolib,&status should be used ?

Answer Question   |  March 31, 2012  2:03 PM
AS/400, AS/400 Parameters, CL/400

Hold parameter in batch job
why should we give the hold paramater (*yes) in a batch job? please let me the what is a a batch job?

Answer Question   |  March 31, 2012  4:32 AM
AS/400 batch jobs, AS/400 Parameters, V5R3

SELECT with LIMIT in AS/400
Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT DISTINCT                  (substring(FILE1, 1, [...]

Answer Question   |  June 14, 2011  6:40 PM
AS/400 Parameters, AS/400 Records, SQL, SQL Select

AS/400 Triggers: Batch programs don’t write to trigger file
I have some triggers set up on our AS/400. A record gets written to a physical file each time one of the triggered files has an add, update or delete performed against it. The problem is that we have a few batch programs that do not write to the trigger file when run (and update [...]

Answer Question   |  June 18, 2013  7:58 PM
AS/400 administration, AS/400 Parameters, AS/400 triggers, CL batch program, TRIGGER, Trigger failure

OVRDBF without any parameters specified
Can we specify an overide statement without actually specifying any parameters to be overridden. In one of the exisiting codes (in a CL)I saw a line as follows: OVRDBF             File(ZFT00981)     ToFile(ZFT00981) No parameters were specified. The file name is exactly same. The program is being used since ages. Hence I know this will not result [...]

Answer Question   |  May 30, 2011  9:54 AM
AS/400, AS/400 Parameters, CL, CL Parameters, iSeries, OVRDBF

Can CL Programming language can have level check error
 hi friends in CL Program is it possible that we can get Leve Check Parameter…

Answer Question   |  May 10, 2011  5:19 PM
AS/400 Parameters, CL Procedure, CL programming, CLLE, CLP, Level Check

RPG Net pgm with dataq
Hi. I need some help with net pgm. This is my stuff: 1- ADDPJE SBSD(LIBINO/INOSBS) PGM(LIBINO/TST44R) 2- TST44R read a InoDtaq 3- In WrkActJob I can view the INOSBS with TST44R 3 times (default) 4- I have a pgm TST43R that write a LIBINO/INODTAQ. I run it. 5- I run TST44R and in WorkActJob its [...]

Answer Question   |  March 28, 2011  7:27 PM
AS/400 Parameters, RPG, RPG Program

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

Call a program and send parameters in WRKJOBSCDE
I want to schedule a job to run. It needs to call the program and send 20 parameters. Is this a good way to do through Job Schedular on the AS400?

Answer Question   |  January 18, 2011  3:52 PM
AS/400 job scheduler, AS/400 Parameters, Job scheduling, WRKJOBSCDE

Hide AS/400 Parameter
How can we hide the parameter from user view and pass with some default value.

Answer Question   |  January 13, 2011  7:34 AM
AS/400 administration, AS/400 Parameters, PARM

Add more than one parameter in URL called from AS400
i have a probelm which when my CLP use STRPCCMD to open the URL it pass one parameter only and when i add & to another one , it always read first parameter only, how can i add the secound parameter with using & so HTML can read it

Answer Question   |  December 9, 2010  11:48 AM
AS/400 Parameters, CLP, CLPROGRAM, STRPCCMD

How to prevent parameter 2 from getting into parm 1 in iSeries
I have a command that calls a RPGLE program. One of the parms has a max of 6 but if using less than the 6, I get info from the next parm in that field. How do I prevent that? Here are the 2 parms as defined in the Command: PARM       KWD(EXCLUDE) TYPE(*CHAR) LEN(1) RSTD(*YES) [...]

Answer Question   |  December 3, 2010  4:13 AM
AS/400 Parameters, COMMANDS, iSeries, RPGLE

On Line Help Program – RPGLE
Hi Is there a way to invoke a program when pressing the F1 key, without adding the Call statement to the program that is doing the calling ? I would also need to pass parameters, or LDA to the program that I would be calling. Thanks, Nick

Answer Question   |  December 9, 2010  10:02 PM
AS/400 Parameters, LDA, RPGLE

How to find the average processor and Main Memory usage of iSeries?
For a report, how to find the average processor and Main Memory usage in iSeries. is it through Performance tools? If so which parm? or how. Thanks

Answer Question   |  November 12, 2010  8:26 AM
AS/400 Parameters, AS/400 performance, AS/400 reporting, iSeries, iSeries performance

Using .net gridview control with AS/400
I am tiring to update a table in the as400 with the .net gridview control and I am having trouble binding the parameters to the sql query. My select query work if I use a liked server but it is slow. Next I tried the odbc driver but my select query is not working with [...]

Answer Question   |  November 15, 2010  7:01 PM
.NET 2.0, AS/400, AS/400 Parameters, GridView, GridView Control, SQL Query

Returning AS/400 parameters from procedures
If I have a sub procedure :- P SUBP B D SUBP PI X(10) D Parm1 X D Parm2 X D Parm3 X(10) value options(*nopass) D Data_item X(10) C /free C [some][/some]C If %parm < 3 C Return Data_item C Else C Parm3 = Data_item C Return C Endif C /end free P SUBP E [...]

Answer Question   |  November 11, 2010  10:36 AM
AS/400 Parameters, Parameters, RPG ILE subprocedure, RPG Programming

Calling C ILE Procedure from COBOL 400 Program
I cannot get the parameters correct on this. I created a module for both the C and the COBOL, then used CRTPGM. My COBOL has WS-FIRST-COBOL-NUM PIC S9(2), WS-SECOND-COBOL-NUM PIC S9(2), WS-NUM-TOTAL-COBOL PIC S9(3) defined in WORKING-STORAGE.                Then I use those for my call to the C procedure as: CALL PROCEDURE “TESTC” USING WS-FIRST-COBOL-NUM WS-SECOND-COBOL-NUM [...]

Answer Question   |  October 20, 2010  8:49 PM
AS/400 Parameters, COBOL, COBOL/400, ILE Program

Can RPG call a VB script
I know very little about anything on a PC. Is there some kind of interface that could be used to execute a VB script which performs a function which returns a parm and get that parm returned back to the RPG pgm.

Answer Question   |  September 7, 2010  6:56 PM
AS/400 Parameters, RPG, VBScript, Visual Basic Script

How many parameters can be used in as400 wrkqry?
how many parameters can be used in as400 wrkqry

Answer Question   |  August 31, 2010  1:13 PM
AS/400 Parameters, AS/400 Query, V5R4, WRKQRY

How can you pass the parameter to the pf in RPG/400?
How can you pass the parameter to the pf?(using function key 4)

Answer Question   |  December 2, 2009  4:58 AM
AS/400 Parameters, Physical Files, RPG/400