Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Need to Query based on dynamic array of input as query condition

  1. #11
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    799

    Default

    Okay: try this <grin> My apoligies for the trial and error.. I'm not all that familiar with Teradata.
    sqlSelect(1, "select * from XXXXXX.v_dataspellxxxxx where Date_of_transaction = :date_of_transaction",date_of_transaction)

  2. #12

    Default

    Also tried this one before and the error code is below. And my apoligies as I didn't mention my previous trials.

    Code:
    ERROR initializing expert output:
    Length 0 is not allowed for a CHAR, VARCHAR, BYTE, VARBYTE column.
    2014-10-01 18:09:03.000; WARN: Length 0 is not allowed for a CHAR, VARCHAR, BYTE, VARBYTE column.
    	id: 0 chain: 0 group: 0
    	cppDetail: context:  build/linux-x86-64/release/code/source/jigsaw/db/teradata/TDParcels.cpp@88
    
    2014-10-01 18:09:03.000; WARN: ...handling expression #1 in file
    	id: 0 chain: 0 group: 0
    	cppDetail: context: Salmon::NED::ExprTableIo::initialize() build/linux-x86-64/release/code/source/brain/node/ExprTableIo.cpp@86
    
    2014-10-01 18:09:03.000; WARN: ...exception seen
    	id: 0 chain: 0 group: 0
    	cppDetail: context: Salmon::NED::NodeControl::initializeExpert() build/linux-x86-64/release/code/source/brain/node/NodeControl.cpp@1331
    
    2014-10-01 18:09:03.000; ERROR: ERROR initializing expert output:
    Length 0 is not allowed for a CHAR, VARCHAR, BYTE, VARBYTE column.
    	id: 0 chain: 0 group: 0
    	cppDetail: context: Salmon::NED::NodeMain::errorMsg() build/linux-x86-64/release/code/source/brain/node/NodeMain.cpp@28


    Thank you

    Özgün

  3. #13
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    799

    Default

    Okay: try this <grin> My apoligies for the trial and error.. I'm not all that familiar with Teradata.
    sqlSelect(1, "select * from XXXXXX.v_dataspellxxxxx where Date_of_transaction = :date_of_transaction",date_of_transaction)

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
  •