I’m still new to TDP. How do I see the entire error message? Messages are too often truncated. Below is what I see. Right clicking and chosing ‘Select All’ and pasting to a text editor doesn’t work, nor does ‘Send to Editor’ and ‘Text Output’. Thanks in advance for the help.
Teradata exception: [Teradata Database]  Syntax error, expected something like an integer or a decimal number or a floating point number or a ‘WHEN’ keyword between the
FYI, This is what’s creating the error. I figured out I have to pull the sample as a sub-query and it must have an alias. (Where in the world might this sort of thing be documented? I couldn’t evem find sample in TD’s online docs.)
This fails-- select count(*) as nrecs from WFPDMHM.V_HM_ACCT_BAP sample .25;
This works-- select count(*) from (select * from WFPDMHM.V_HM_ACCT_BAP sample .25) as A;