Page 1 of 1

Aend 0C4000 hex

PostPosted: Fri Feb 26, 2016 5:27 pm
by sri_mf
while executing select query on d2 sample table getting an aend error

select * from DSN8910.EMP;

Re: Aend 0C4000 hex

PostPosted: Fri Feb 26, 2016 8:19 pm
by NicC
So? Good for you! Hope you managed to read up about it and fix it.

In other words - explain a lot more! We are not mind-readers. What is the data? What is the query? How is the query being executed - SPUFI or program? If a program what language? Show the relevant bits of code.

Re: Aend 0C4000 hex

PostPosted: Sat Feb 27, 2016 7:34 am
by sri_mf
tried thru SPUFI and QMF

result was same

Re: Aend 0C4000 hex

PostPosted: Sat Feb 27, 2016 11:40 am
by sri_mf
hope this post will give more clarity on my question

while i was trying to retrieve data from a table of an exixsting db2 sample database

select * from DSN8910.EMP;

its giving an error Aend 0C4000 hex

similar error occurred on spufi aswell as QMF

but if i retrieve only empno its giving results(select empno from DSN8A10.EMP)

table discription

CREATE TABLE DSN8A10.EMP
      (EMPNO     CHAR(6)                          NOT NULL,
       FIRSTNME  VARCHAR(12)                      NOT NULL,
       MIDINIT   CHAR(1)                          NOT NULL,
       LASTNAME  VARCHAR(15)                      NOT NULL,
       WORKDEPT  CHAR(3)                                  ,
       PHONENO   CHAR(4)         CONSTRAINT NUMBER CHECK
                 (PHONENO >= '0000' AND
                  PHONENO <= '9999')                      ,
       HIREDATE  DATE                                     ,
       JOB       CHAR(8)                                  ,
       EDLEVEL   SMALLINT                                 ,
       SEX       CHAR(1)                                  ,
       BIRTHDATE DATE                                     ,
       SALARY    DECIMAL(9,2)                             ,
       BONUS     DECIMAL(9,2)                             ,
       COMM      DECIMAL(9,2)                             ,
       PRIMARY KEY (EMPNO)                                ,
       FOREIGN KEY RED (WORKDEPT) REFERENCES DSN8A10.DEPT
                 ON DELETE SET NULL                       )
  EDITPROC  DSN8EAE1
  IN DSN8D10A.DSN8S10E
  CCSID EBCDIC;

Re: Aend 0C4000 hex

PostPosted: Sat Feb 27, 2016 7:08 pm
by NicC
Try retrieving the numeric columns - one at a time. Possibly someone has updated the table with invalid information so you may have to reload it (or jave someone reload it for you). These sample tables are used the world over and only you seem to have the problem so it is probably your table that is corrupt. You would need to speak to the DB2 DBA once you have discovered which column is corrupted.

p.s. it is abend (ABnormal END) - not aend.