PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/20/2016 7:55 AM by  TimC
SQL QUERY NODE outputData
 2 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:54 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..

    TimC
    Systems Analyst
    Private
    Veteran Member
    (220 points)
    Veteran Member
    Posts:84


    Send Message:

    --
    06/30/2016 9:25 AM
    check the QueryNode_RECORDCOUNT to see if its > 0.
    Would have to see what the SQL is doing to properly advise.
    Is there an error?
    Once there are records, put a MessageBuilding node in between the iterator. Connect the SQLQuery node to the MessageBuilder, then the MB to the EndQuery node. In the messagebuilder create a variable with an appropriate name 'queryOutput' (no quotes). Click in the message box and hit Control + Space bar to get a list of the SQLQuery nodes fields. Select the field then type the delimiter ("|" or "," or whatever). Then select a subsequent field. etc.
    Connect a FileChannel node to the end sql query node. Enter the file path and WriteFile action. In the Output, do a Control + Space and select your variable (queryoutput). Put a blank text file in the path to write to. Run the flow.
    TimC
    Systems Analyst
    Private
    Veteran Member
    (220 points)
    Veteran Member
    Posts:84


    Send Message:

    --
    12/20/2016 7:55 AM
    I am using a SQLQuery node to return user fields linked to an Employee biz class. I have processing going on outside of LAWSON (Landmark). What is the table relationship that ties the USERFIELD table to the EMPLOYEEEXPORT table. The userfield was associated with the export form for history. How do I fetch UDF changes to the export class?
    You are not authorized to post a reply.