I have a SQL (2008) table which has fields with data type "date". The adapter generated the master with USAGE=YYMD, ACTUAL=DATE for those fields. I can use MODIFY to load data into this table without issue, but when I use WebFOCUS TABLE FILE to query this table, it gave error message (FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD for those date fields. However the data looks good through SQL select statement.

I am using WebFOCUS 7.7.03M in Windows Server 2008, SQL server 2008. Any help is appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,

Strange. Does the same happen if you open the synonym definition with the Synonym Editor and click the "Sample data" button?

Perhaps you can try using SQL passthru to read and temporarily hold your data to further analyze what WebFOCUS is "seeing":

SQL SQLMSS
select your_date_field 
  from your_table 
 where <any_filter_here>
;
TABLE ON TABLE HOLD AS HTEMP
END
-RUN
? HOLD HTEMP

I'd be interested to see:

1. If any errors are still raised when getting the data
2. If not, which field definition was created for the date field in the masterfile associated with the HOLD file you just created (it will be visible in your browser right away).

Did you do the TABLE command with or without IF/WHERE statement on the date field?
If would help if you included the code you used that produced the error message ...

I resolved the issue. We have a FOCUS database with a same name resides in the SU machine, though that file was NOT in the app path. However we have USE command in eda profile to use databases in SU machine. That seems OK for MODIFY FILE, but not for TABLE FILE. MODIFY FILE seems to search file based on APP PATH, but USE command seems to have higher priority than APP PATH in TABLE FILE. Once I issued USE CLEAR * before that TABLE FILE, it works and it picks the file from APP PATH.

Thanks for all your responses!

Glad you figured it our. Would you please edit your post and prefix it with [CLOSED]? Thanks.