can any one let me know the query that must be used to find out whether a particular field in a table is either numeric or not.
There is field called GROUP_NO.
I want to check whether this field is numeric or not with the help of a query.
It has been told that this field is of 10 bytes length. Is it possible to check whether the field is of 10 bytes length with the help of a query. please let me know if any one has the answers for both the questions.
Hi, I will have to check whether there is any function that can help us find out a column's datatype directly, but what I do know is that the table SYSIBM.SYSCOLUMNS contains information about each column and its dataype of all tables in your database. You can query this table with the table name and get the required information, assuming you have the required privilege. Pls let me know your finidings.