LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Getting null values with DB query node and normal values with JDBC Query node

    Employee
    Posted 05-09-2012 19:06

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: alyon

    Hi,

    While running the following query in JDBC query and DB query nodes, I get two different results:

    SELECT BSC.Accnt_Num,
    BSC.Party_Id,
    BSC.AR_Invc_Id,
    BSC.Invc_Dt,
    BSC.Bill_Sttmt_Chrg_Sqnc_Num,
    BSC.Bllng_Strcr_Id,
    BSC.Bill_Sttmt_Chrg_Amt,
    BSC.Prdct_Id
    from EDWPRDE_WORK_ANLYT.d393248_{{^DataMonth^}}_ADJ_REP ORT RPT,
    EDWPRDE_VW40_PUB.T02104_BLLNG_STTMT_CHRG BSC

    WHERE BSC.Accnt_Num = RPT.Acct_no and
    BSC.AR_Invc_Id = CAST(RPT.Invoice_id AS INTEGER)




    JDBC query node returns normal values for Bllng_Strcr_Id,
    while DB query node return null values.

    I am attaching both the outputs for your reference. Check the Bllng_Strcr_Id

    Is this a known issue? What is the work around?
    If this is a bug, is the GNATS entry created for the same?

    Thanks
    Anshul
    Attachments:
    JDBCvsDB.doc


  • 2.  RE: Getting null values with DB query node and normal values with JDBC Query node

    Employee
    Posted 05-09-2012 23:55

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: alyon

    Just an update. I have been informed me that this issue is related to outdated teradata CLI drivers.
    I will upgrade CLI drivers when i get some time and update this thread with the results.

    No need to respond for now...

    Regards
    Anshul