IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
 View Only

  • 1.  error related DBQuery function

    Posted Tue August 12, 2008 11:11 AM

    Originally posted by: muralee


    I have written the following code

    DBQUERY ( "SELECT * from CLM_HDR_FACT where CLMID= " + CLMID Column:Row:CLM_HDR + " " , " -MDQ C:\Documents and Settings\I30053C\My Documents\Database\Access.mdq -DBNAME Access " )
    when i try to build the map its giving me the below error

    M120 ERROR:
    Map: POC Output: Field1 Field:Record:determineClaimExists
    CLMID Column:Row:CLM_HDR is an invalid operand
    can anybody tell me whats wrong with this code.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: error related DBQuery function

    Posted Tue August 12, 2008 11:15 AM

    Originally posted by: janhess


    is CLMID a text value?
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: error related DBQuery function

    Posted Tue August 12, 2008 11:24 AM

    Originally posted by: muralee


    clm id is a number , i have converted that to text using NUmberToTEXT() and its working fine now .
    thanks for the clue , and thanks for resolving the problem
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 4.  Re: error related DBQuery function

    Posted Tue August 12, 2008 11:27 AM

    Originally posted by: janhess


    You also need a single quote arount the CLMID

    DBQUERY ( "SELECT * from CLM_HDR_FACT where CLMID= '" + CLMID Column:Row:CLM_HDR + "'" , " -MDQ C:\Documents and Settings\I30053C\My Documents\Database\Access.mdq -DBNAME Access " )
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


Related Content