Hi, I have a requirement to modify/remove invalid data in dynamic columns Result Set. As I don't know the Data Type of column how can I achieve this functionality?
Thanks SandhyaThis message has been edited. Last edited by: FP Mod Chuck,
WEBFOCUS 8202/Windows PDF/HTML/XML
July 07, 2018, 12:52 AM
pav
Hi, Can you please provide some more information on this.
July 07, 2018, 07:38 AM
Sandhya j
Hi, MY Stored Proc returns varied number of columns (depends on the user selection). It can have min 1 column to maximum 50 columns in the output. Order also can change. Once I read data into webfocus table, I need to modify data in some columns. For ex: I might have date columns in the output. I need to check invalid dates and replace it with blank. For this purpose I need to know data type of column (A/I/D etc.). How can I get it?