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;