Stored Procedure
I’ve to use stored procedure in RPGLE program. my code is CallP     OESP_PORD_001(IPAT#:OPNXT#:PRJUK) I get error name or indicator not defined…i checked the library, parameters and everything are in place….Am I calling the SP with the right syntax? i tried to then change this whole using SQL…execute statement however my program is RPGLE and not SQLRPGLE… [...]

Answer Question   |  September 3, 2009  3:08 PM
AS/400, AS/400 Library, RPGLE

Defining a sort variable (ORDER by) in RPG SQL
I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the [...]

Answer Question   |  September 22, 2009  2:12 PM
RPG, RPGSQL, SQL, V5R4, V5R4M0

Disk space clean-up.
What is the process to clean up after PTF or CUM installs? Is there a file to delete or work area? Thanks.

Answer Question   |  November 4, 2011  1:48 PM
AS/400, Disk space, Program Temporary Fix

Number of Weeks Between Dates
How do you get the number of weeks between two dates in RPG ?

Answer Question   |  September 4, 2009  1:10 PM
AS/400, AS/400 programming

AS/400 Tool
i want 2 create as/400 tool in my prj which will save time Could anybody gimme some idea reagrding as/400 tools.

Answer Question   |  September 4, 2009  12:43 PM
AS/400 3rd party tools, AS/400 development, Software development

Number of lines of code in a program
hi, I’ve 50 programs to find the number of lines of code in it… is there any smart way? Thanks, N.

Answer Question   |  September 4, 2009  9:50 PM
AS/400, RPG

sending Z/OS output to a Zebra printer
Anyone know of a print converter to allow direct printing from z/os to a zebra thermal printer? 

Answer Question   |  September 3, 2009  9:34 PM
z/OS, Z/OS Zebra Converter, Zebra printers

RCLSTG – estimate on how long it might take
After an unplanned power off event (long story) I am advised to run a full RCLSTG on my largest partition, which has about 5.5 TB storage and several million objects. I have only ever run RCLSTG(*DBXREF) and am wary of running RCLSTG itself to get the estimate. Any thoughts on what parameters I can use [...]

Answer Question   |  September 9, 2009  8:58 PM
AS/400 backup and recovery, RCLSTG

search or sort output queue
Is there any way to search an AS/400 output queue for a specific report? or at least alphabetically sort entries under FILE ? thanks

Answer Question   |  September 3, 2009  4:15 PM
AS400 output queue sort search

SQL Help needed
In what way, using SQL could a statement be written in that it would not allow any duplications of a particular text in a column? How would it be set up? Also if you have three different tables, lets call them A, B, and C., and there may be multiple matches in each of the [...]

Answer Question   |  September 8, 2009  1:16 PM
AS/400, Deduplication, SQL

OVRDBF
In CL program, declared a file FILE01 and read some records, later using OVRDBF accessed another file FILE02. Still I’m getting records of FILE01 only but not FILE02. Why? Thanks Venkat

Answer Question   |  September 2, 2009  12:08 PM
CL programs, OVRDBF

From sourcefile to IFS and back..
I want to use CPYTOSTMF and CPYFRMSTMF commands to copy sourcemember to and fro the IFS. To test functionality, I created the following test: Sourcemember A_1.TXT :    FMT ** ...+... 1 ...+... 2 ...+... 3 ...+...              *************** Beginning of data **** 0001.00 123456789_line number 1 0002.00 123456789_line number 2 0003.00 123456789_line number 3 [...]

Answer Question   |  September 3, 2009  7:28 AM
CPYFRMSTMF, CPYTOSTMF, IBM 9407 M15, IFS, V6R1

Asset tools in as400
Hi all please tell me what is Asset tools in as400, & why we use it. how many types of asset tols are available . Thanks

Answer Question   |  September 2, 2009  4:53 AM
AS/400, Asset Tools

client access 32 bit ODBC drivers
where can i download 32bit client access ODBC drivers onto my windows(XP) system so that i wanna migrate my access files to AS/400 files.Plz guide

Answer Question   |  September 2, 2009  8:31 PM
AS/400 database, Client Access

retreiving Job information (command String) for jobs waiting in job queues on an Iseires
When we submit a job on an Iseries to a job queue, it gets submitted with a command string. I have a process where I am using APIs to go out and get information on jobs that are on our job queues that are waiting to run. The APIs that I use work great but [...]

Answer Question   |  May 14, 2010  7:11 PM
iSeries, iSeries programming commands

AS400 User profile
One user PQR7ABC has been deleted from my AS400 on dated 08/25/09 as per his complaint …I just want to know who has deleted this profile. I am doing DSPLOG but not getting the results…Must be log deleted   Now how can i check and varify  ?

Answer Question   |  September 3, 2009  6:56 PM
AS/400, AS/400 logs, AS/400 user administration

Duplex Printing
I’m trying to duplex print to an HP 2430TN with the ovrprtf duplex(*yes). The ovrprtf command is issued in a clp and I’ve tried other printers with no luck. Thank You, DLM

Answer Question   |  September 2, 2009  3:18 PM
AS/400, Printing

SNDTCPSPLF
Why do spool files go on hold when using sndtcpsplf?

Answer Question   |  September 1, 2009  2:44 PM
AS/400, AS/400 printing, Attributes, Spool files

How to get IP address of as400 machine in CL pgm
Hi CAn any 1 tell me how to get the IP address of the AS400 machine in CL program.Are there any API for this.I need  to pass this IP to run a java program thrugh CL.. Thankx in advance Supriyob  

Answer Question   |  October 22, 2009  11:00 AM
API, AS/400 Management, CL, CL programs

TCP/IP Timeout
I am using Client Access 5250 emulation connecting to a model 270 at V5R2. The host has a public IP address so there is no VPN, etc. After 5 minutes of no keyboad activity my job is disconnected. Does anyone have any ideas on what I can do to keep my job active? Thank you.

Answer Question   |  January 6, 2010  10:43 PM
AS/400, Client Access, TCP/IP