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