We were using Help Table to get table info and recently started using column 20 instead of column 1 as column 1 only shows max 30 characters.
I am confused so as to whats the difference in "Column Dictionary Name" and "Column SQL Name" and which one to use to always get a full column name. I have seen when using "Column SQL Name" column names comes escaped sometimes. Example if columns name was used "MYCOL" then in the Column SQL Name it comes as "MYCOL" with quotes.
Any description available about the columns in the Help Table output?
Not sure about 'where a description is', but...
My understanding is that "Column SQL Name" is a value that can always be used in SQL. This is why it is sometimes surrounded by quotes etc.
As an example I created the following table:
CREATE TABLE t1 (col1 INTEGER ,"_col2" CHAR(3) ,"2col3" INTEGER ,a234567890b234567890c234567890d234567890e234567890 INTEGER );
A HELP TABLE command then gives the following output:
Column Name Column SQL Name col1 col1 _col2 _col2 2col3 "2col3" a234567890b234567890c234567890 a234567890b234567890c234567890d234567890e234567890