8 Replies Latest reply on Jul 16, 2019 2:02 PM by Nico Heinze

    unsupported data type issue while creating PDO from MS SQL SERVER

    Amit Bhartiya Active Member

      Hi All,

       

      I am trying to created a customized data object from MS SQL SERVER connection using a customized query.
      I am getting unsupported data type issue. so i tried to cast the columns to varchar.
      But i am also using a case statement and it is failing again at the below point.

      Select

      cast(Locator as nvarchar(20))

      ,cast(AppD as varchar(50))

      ,case

      when cast(Locator as varchar(20)) = 'Teradata' and AppD  not like 'Teradata%' then '111ThisIsValid111' else 'No Match_Found 0000000' end as 'SDB_Prefix'  from [abc].[Stage_table]

       

      Error:

      "column type SDB_prefix is not supported"

       

      How to overcome this.
      Also, when i am trying to use

      cast(Locator as nvarchar(20))  as Lct and using Lct in the following lines its throwing error.