Post reply

OPENQUERY

  • June 4, 2003 at 1:01 pm

    #80347

    Select * from openquery(DB24,

    'select t_cprj, t_seak from BAAN5TAM.ttppdm600577 where t_psts LIKE '2'')

    Anyone know the syntax for open query if you need to do comparison in quotes - Does not like '2'

  • June 4, 2003 at 2:17 pm

    #459822

    Try putting 2 single quotes around the 2.

    ... where t_psts LIKE ''2'' ')

    Darren


    Darren

  • June 4, 2003 at 2:17 pm

    #459821

    Try two quotes instead of one:

    Select * from openquery(DB24,

    'select t_cprj, t_seak from BAAN5TAM.ttppdm600577 where t_psts LIKE ''2''')

  • June 4, 2003 at 3:56 pm

    #459833

    Turns out my pass through query in SQL Server to DB2 requires an = 2 syntax instead of LIKE '2'

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply