PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/22/2016 3:31 AM by  Magus
SQL QUERY NODE outputData
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Magus
SSE
Private
Basic Member
(10 points)
Basic Member
Posts:6


Send Message:

--
04/19/2016 4:55 AM
    Hello All,

    Am using a SQL QUERY NODE to query a table..But, the SQL QUERY NODE _ outputData is blank..



    Please anyone guide me to fetch the results of that query and send them to a directory..

    Lawson_Kid
    Application Analyst
    Private
    Basic Member
    (31 points)
    Basic Member
    Posts:13


    Send Message:

    --
    04/19/2016 3:55 PM
    Would you mind posting the SQL?
    Magus
    SSE
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:6


    Send Message:

    --
    04/20/2016 12:04 AM
    Have no issues with Query..Its working fine and can see the results in log..

    my concern here is with , "SQLQuery2440_outputData = " ..
    Its blank here but i can see the results in log.

    SQLQuery2440_errorCode = 0
    SQLQuery2440_informationCode = 0
    SQLQuery2440_returnMessage = SQL query SQLQuery2440: Execution complete.
    SQLQuery2440_outputData =
    Activity completed: SQLQuery2440
    SQLQuery2440_RETURN_MSG = Success
    SQLQuery2440_RETURN_CODE = 0
    SQLQuery2440_errorCode = 0
    SQLQuery2440_informationCode = 0
    SQLQuery2440_returnMessage = SQL query SQLQuery2440: Execution complete.
    SQLQuery2440_outputData =
    SQLQuery2440_RECORD_COUNT = 66

    Basically i want to export the results in log , using msgbuilder or file access to a directory..when i used "SQLQuery2440_outputData = " in msgbuilder its getting errored out.

    Any way to export entire results without specifying individual variables in "SQLQuery2440_outputData = " ..?
    JimY
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    04/21/2016 12:42 PM
    Did you check the box to Enable Sql result values outside the loop?
    Magus
    SSE
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:6


    Send Message:

    --
    04/22/2016 3:31 AM
    Yes Jimy..But still no luck :crazy::cry:
    You are not authorized to post a reply.