Toad World® Forums

Toad Data Point not returning all columns in Summary or Duplicates Tab

Toad Data Point not returning all columns in Summary or Duplicates Tab. I have over 30 columns. Summary only shows 2 columns and Duplicates doesn't show any columns.

Hi, can you give us little bit more infos? At first we need to know what provider are you using and what version of TDP do you have?
If it is possible can you post screen of your table definition? I need to know what type of columns do you have and if you have some special option on your columns (encryption, compression etc).
Just open detail of your table with View Details and screen from Column tab.
Filip

I am using TDP 5.1.2.166 (64bit) and the provider is an ODBC Generic for iSeries Access ODBC Driver.

Table Definition:
CREATE TABLE S36FILES.SAMFILE
(
RECID CHAR (2) NOT NULL,
DELCOD CHAR (1) NOT NULL,
"CONT#" CHAR (7) NOT NULL,
CNAME CHAR (30) NOT NULL,
CADDRS CHAR (30) NOT NULL,
CADDR2 CHAR (30) NOT NULL,
CCITY CHAR (20) NOT NULL,
CSTATE CHAR (2) NOT NULL,
CZIPC CHAR (10) NOT NULL,
DOP CHAR (6) NOT NULL,
TERM CHAR (1) NOT NULL,
BLANK1 CHAR (9) NOT NULL,
OLDSER CHAR (15) NOT NULL,
RENPR CHAR (4) NOT NULL,
"DEAL#" CHAR (7) NOT NULL,
REPNUM CHAR (5) NOT NULL,
CINHME CHAR (4) NOT NULL,
BLANK2 CHAR (2) NOT NULL,
CNTCOS DECIMAL (7, 2) NOT NULL,
EFFDAT CHAR (6) NOT NULL,
PAREXP CHAR (6) NOT NULL,
LABEXP CHAR (6) NOT NULL,
MFGWAR CHAR (15) NOT NULL,
MFGDAT CHAR (6) NOT NULL,
MFGPEX CHAR (6) NOT NULL,
MFGLEX CHAR (6) NOT NULL,
PDATE CHAR (6) NOT NULL,
BLANK3 CHAR (11) NOT NULL,
AREAC CHAR (3) NOT NULL,
PHONE1 CHAR (3) NOT NULL,
PHONE2 CHAR (4) NOT NULL,
MFGCD CHAR (6) NOT NULL,
PCODE CHAR (8) NOT NULL,
MCODE CHAR (8) NOT NULL,
DATCML CHAR (6) NOT NULL,
EXPDAT CHAR (6) NOT NULL,
COMMEN CHAR (20) NOT NULL,
MANDES CHAR (20) NOT NULL,
PRODES CHAR (20) NOT NULL,
"FM#AR" CHAR (7) NOT NULL,
MODNUM CHAR (20) NOT NULL,
SERNUM CHAR (20) NOT NULL,
CONTMO CHAR (1) NOT NULL,
CONTYR NUMERIC (1, 0) NOT NULL,
DSNFCD CHAR (2) NOT NULL,
RTCOAS NUMERIC (5, 2) NOT NULL,
FORMNO CHAR (9) NOT NULL,
RECDAT CHAR (6) NOT NULL,
BLANK4 CHAR (51) NOT NULL,
SRVMDS CHAR (1) NOT NULL,
VODDAT CHAR (6) NOT NULL,
USERID CHAR (8) NOT NULL,
WKSTAT CHAR (2) NOT NULL,
ENTRTM CHAR (6) NOT NULL,
ENTRDT CHAR (6) NOT NULL
);

I am guessing it has to do with "#" in the column name but when I run for 1 million rows it returns all of the information.

Tried to run it without the "#" and returned the same way.