CLOB columns not showing in RSE>Show in Table>Data

I see that RSE>Show in Table>Data fails as well. And I think you might be right about the CLOB.
Feel free to open a PMR (or Case as it it called today) on this situation.



(For internal folks, you can find the reproducing materials in library PAYLIBF on P8ADT05)
The necessary SQL to create this is
create schema Paylibf;

create or replace table Paylibf.ng000001t (
ClassCode varchar(50) not null,
EstablishedDate varchar(10) not null,
ClassTitle varchar(300) not null,
TextField2 clob(8000) not null,
TextField3 clob(8000) not null,
TextField4 clob(8000) not null,
TextField5 clob(8000) not null,
TextField6 clob(8000) not null,
TextField7 clob(8000) not null,
SalaryMin varchar(20) not null,
SalaryMax varchar(20) not null,
BillableHours varchar(10) not null,
SalaryPaidCode varchar(20) not null,
SalaryBreakdownHourly char(1) not null,
SalaryBreakdownDaily char(1) not null,
SalaryBreakdownWeekly char(1) not null,
SalaryBreakdownBiweekly char(1) not null,
SalaryBreakdownSemiMonthly char(1) not null,
SalaryBreakdownMonthly char(1) not null,
SalaryBreakdownAnnually char(1) not null,
BargainingUnitCode varchar(50) not null,
PhysicalClassCode varchar(50) not null,
BenefitCode varchar(50) not null,
OccupationalGroupCode varchar(50) not null,
FLSA varchar(50) not null,
EEO varchar(50) not null,
AcceptJobInterestCards char(1) not null,
Notes varchar(50) not null,
TextField1 clob(8000) not null
);

Thanks for bringing this to our attention, David.

Edmund Reinhardt
905-413-3125

Showing and editing data in RDi