CPYTOSTMP
I’m copying to a stream file and if the object exists it works. The help says if it does not exist it will create it. Here is the error msg Message ID . . . . . . : CPFA0A9 Severity . . . . . . . : 40 Message type . . . [...]

Answer Question   |  May 1, 2009  3:49 PM
AS/400, AS/400 error messages, CPYTOSTMP

Display “No records found” in a QMQRY
I have a QMQRY that selects data from several files using left joins. Based on my “where” clause there is a possibility that no records will be selected. In this case, I want to be able to print “NO RECORDS FOUND” on the report. I have not been able to figure out how to get [...]

Answer Question   |  April 10, 2009  1:38 PM
AS/400 error messages, AS/400 printing, QMQRY

AS/400 remore access
Hi, I am having a static IP configured to the AS/400 at the client site.But I can’t able to connect to the AS/400 using iseries navigator from my site locally. But when I am using the TN3270 plus as telnet mode I ma able to connect it. So please help me in resolving this issue. [...]

Answer Question   |  April 8, 2009  1:34 PM
AS/400 Client Access, AS/400 error messages, AS/400 remote access, TCP/IP

AS/400 Navigator
Hi , Can anyone tell me what is this problem when i try to click on the database tab in AS/400 navigator. Navigation: -> login to machine id->click on the machine-id->click on the database tab-> ERROR reported Function did not complete successfully. AS/400 Message ID: PWS0001 Cause . . . . . : An error [...]

Answer Question   |  April 9, 2009  11:38 AM
AS/400 error messages, AS/400 errors, AS/400 Navigator, CALL statement, SQL/400

STRWCH and CPF0607
Hi, I want to know if you have used the STRWCH command to prevent the CPF0607 (serious storage condition). I’m looking for a way to prevent the operators miss the error message (it is not requesting reply and sometimes they press enter and the message dissapears from the screen). Thank you in advance for your [...]

Answer Question   |  March 18, 2009  2:36 AM
AS/400 error messages, CPF0607, Start Watch, STRWCH

tcp/ip
Hi, while connecting to the AS/400 from my local system its throwing the error socket error function error CWBC01003 in as/400, how can I be able to resolve the problems.

Answer Question   |  April 2, 2009  2:30 PM
AS/400 Client Access, AS/400 error messages, CWBC01003, TCP/IP

Error while calling an AS/400 stored procedure
I created a stored procedure as below CREATE PROCEDURE devbidta.POC_ENROL9(IN compid INT) DYNAMIC RESULT SETS 1 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA BEGIN DECLARE c1 CURSOR WITH RETURN TO CLIENT FOR SELECT LEAD_NUMBER,MAX(ENROLLMENT_FLAG) AS ENROLLMENT_FLAG, MIN(COLLECTOR_TRAIL_SEQ) AS CODE_POSITION FROM UATBIDTA.F_LEAD WHERE RECORD_TYPE = ‘ ‘ AND COLLECTOR_TRAIL = ‘ ‘ AND COLLECTOR_COMPONENT_ID = compid [...]

Answer Question   |  March 17, 2009  9:13 AM
AS/400 error messages, AS/400 SQL, AS/400 stored procedures

iSeries Access for Web
I just read the ‘iSeries Access for Web tutorial’ I followed the instructions and it seems that I was able to configure everything successfully. However when I try to access the URL I get a ‘Error 404′ Can someone please tell me what I may have done wrong.

Answer Question   |  March 7, 2009  4:56 PM
AS/400 error messages, iSeries Access, iSeries error messages

FTP to AS/400 connection closed
We switched from cable to Fios internet and FTP to 400 stopped working – getting “connection closed by remote host” – checked netstat and joblogs – what’s wrong??

Answer Question   |  March 6, 2009  2:12 PM
AS/400 connection error, AS/400 error messages, AS/400 FTP

QZDASOINIT job?
Hi , am recieving the following error messages Message . . . . : Error occurred while calling program or procedure *LIBL/NBCUNQSN (C G D F). caused by the QZDASOINIT job. I presume this is a ODBC job that runs in QSERVER, any ideas as to what has to be done. The backup is running [...]

Answer Question   |  March 5, 2009  10:59 AM
AS/400 backup, AS/400 error messages, QZDASOINIT

Iseries auto respond to error message
Is there a way for the Iseries to respond to an error message without user intervention?

Answer Question   |  February 24, 2009  1:48 PM
AS/400 error messages

DSPLOG and all security error msg related
Hi, how can I display all the security errors (not authorized, user profile disabled, etc) from the qhst, I know some cpf but not all of them. Thank you guys in advance.

Answer Question   |  October 21, 2009  3:58 AM
AS/400 administration, AS/400 error messages, AS/400 security, Display Log, DSPLOG, QHST

AS/400 QADBIFLD error Duplicate Record Key?
The AS400 job QDBSRVXR2 has system error message Duplicate Record in QADBIFLD. I am aware this is a system cross reference file. (System is doing an automatic reply of C and then tries again) Is this file now corrupt ? Would an IPL help ? Reclaim Storage ? What is causing this error. (System is [...]

Answer Question   |  February 3, 2009  11:56 AM
AS/400 error messages, AS/400 errors, Database Cross-Reference 2, Duplicate records, IPL, QADBIFLD, QDBSRVXR2, V5R2

iSeries – Client Access
Hi, Whilst trying to connect iSeries through 5250 i recieve the following error CWBCO1049 – The iSeries server application is not started. However when i try connecting through Console from the server am able to connect as normal. We have v5r3 and have recently applied 8267 CUM PTF’s, but was able to connect after applyiing, [...]

Answer Question   |  May 8, 2010  4:07 PM
AS/400 error messages, Client Access, iSeries 525

How to export data from AS/400 into Microsoft Excel
Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege [‘Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.

Answer Question   |  January 26, 2009  7:58 AM
AS/400 administration, AS/400 error messages, AS/400 import/export, Microsoft Excel, Microsoft Excel import/export

I RECECEIVED A CPPEA55 ERROR MESSAGE
MY TAPE DRIVE WENT DEAD PULLED IT OUT. I ISSUED A PWRDWNSYS COMMAND. IT WENT DOWN BUT I DID NOT UNPLUG THE BOX. AS SOON AS I BROUGHT THE BOX BACK UP I RECEIVED A CPPEA55 ERROR MESSAGE.

Answer Question   |  January 13, 2009  4:51 PM
AS/400 error messages, CPPEA55 Error Message, PWRDWNSYS, Tape drives

SRC error 67563200 when booting my AS/400e series
my system have not come up it is turning on 67563200. pls what can be wrong with my system

Answer Question   |  January 8, 2009  9:32 AM
AS/400 error messages, AS/400 errors, IP, MFIOP, SRC error 67563200

Regarding deletion of user profile from AS/400 system
While changing the owner of the objects of the user profile from the system i encountered an error ‘Ownership of 0 document library objects changed to profile XXXXXX; 1 not …’. I need to know how can i solve this error. Thanks,

Answer Question   |  January 8, 2009  6:43 AM
AS/400 administration, AS/400 error messages, AS/400 errors, AS/400 objects, AS/400 user profiles

Error code 10: Function sequence error using CPYTOIMPF on AS/400
I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The [...]

Answer Question   |  December 22, 2008  4:17 PM
AS/400 DB2, AS/400 error messages, CPYTOIMPF, SQL

Run time error when OPNQRY is executed
I’m getting a run time error when OPNQRY is executed. APGLDT field is numeric and & POST is *CHAR value retrieved from dtaara. Similar is the case with APINVDT. I tried without %DIGITS also and it still doesn’t work. OPNQRYF FILE((*LIBL/APH *FIRST *ONLY)) + QRYSLT(‘%DIGITS(APGLDT) *EQ “‘ *CAT &POST + *CAT ‘” *AND %DIGITS(APINVDT) *EQ [...]

Answer Question   |  June 18, 2013  4:38 PM
APGLDT, APINDVT, AS/400 error messages, AS/400 Runtime Errors, OPNQRY