SQL Assistant Displays <Error> in answer

Tools & Utilities
JR
Teradata Employee

SQL Assistant Displays <Error> in answer

One of our users is experiencing an issue with the display of the Answer set in SQL Assistant.  It is showing <Error> where the values are null.  The SQL Assistant settings for "Display this string for null data values" is ? (i.e. question mark).

Any idea what causes this display of <Error> and how to resolve it?  

 

Customer_NbrProcess_DateComplete_Date
161084222<Error>8/5/2017
1612637557/29/2016<Error>
1874239987/30/20178/15/2017
189235611<Error><Error>

 

 

2 REPLIES
Supporter

Re: SQL Assistant Displays <Error> in answer

Hi JR,

 

Is it possible for you to share the query as well?

 

Thanks,

Rohan Sawant

JR
Teradata Employee

Re: SQL Assistant Displays <Error> in answer

The query is a simple "select * from cust_tbl".