Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2015
    Posts
    1

    Unanswered: need to convert mssql query to db2 query

    Hi..
    I need to convert MSSQL query to DB2 query. Pls help me..

    Query :
    select distinct 'update transactionstatus set uniqueId='''+cast(ec.uniqueId as varchar) +'''
    where mapkey='''+cast(mapkey as varchar)+''''
    from transactionstatus a, details d,customer ec
    where a.mapkey=d.certSerialNo and d.id=ec.id;

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    select distinct 'update transactionstatus set uniqueId='''||cast(ec.uniqueId as varchar) ||'''
    where mapkey='''||cast(mapkey as varchar)||''''
    from transactionstatus a, details d,customer ec
    where a.mapkey=d.certSerialNo and d.id=ec.id;



    Andy

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •