SQL Command help

• SAROSH SHETTY

  SSC Journeyman

  Points: 87

  More actions

  March 3, 2006 at 3:10 pm

  #70293

  I am running this code in the ETL Filter of Source Qualifier of Informatica. It's like a filter while importing data.

  UNIT is one of the columns in my table.

  The line of code is

  SUBSTR(TO_CHAR(UNIT),5,1) = '0'.

   

  We dont specify Where in the Source Qualifier as it assumes it.

  But I get a error messge saying that

  SQL0204 - TO_CHAR in *LIBL type *N not found.].

  Is there any other way I can achieve this filter .

• sjdMem

  Valued Member

  Points: 71

  More actions

  March 6, 2006 at 12:10 am

  #624818

  Hi! By seeing the error message, I think there is no To_Char function. . .  if it is T SQL command try using Convert function

  ---

  Regards,

  SJD
  

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  March 6, 2006 at 10:47 am

  #624969

  That's ORACLE syntax. This website is for Microsoft's SQL Server which uses Transact-SQL as its language.

  Also, please post in an appropriate forum...the "Question of the Day" forum is specifically for responding to the Question of the Day quiz.

  -SQLBill