IBM Mainframe Forum

by **sri_mf** » Fri Feb 26, 2016 5:27 pm

while executing select query on d2 sample table getting an aend error

select * from DSN8910.EMP;

by **NicC** » Fri Feb 26, 2016 8:19 pm

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.

by **sri_mf** » Sat Feb 27, 2016 7:34 am

tried thru SPUFI and QMF

result was same

by **sri_mf** » Sat Feb 27, 2016 11:40 am

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

Select all

 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;

by **NicC** » Sat Feb 27, 2016 7:08 pm

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.

IBM Mainframe Forum

Aend 0C4000 hex

Aend 0C4000 hex

Re: Aend 0C4000 hex

Re: Aend 0C4000 hex

Re: Aend 0C4000 hex

Re: Aend 0C4000 hex