SQL QUERY NODE outputData

 2 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Magus
Basic Member
Posts: 6
Basic Member
    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
    Veteran Member
    Posts: 84
    Veteran Member
      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
      Veteran Member
      Posts: 84
      Veteran Member
        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?