Prev
Next
Forums IPA/ProcessFlow

Spooling Delimited pipe text output file

Sort:
You are not authorized to post a reply.
Author
Messages
HDAustin13
Advanced Member
Posts: 31
Advanced Member
1/9/2019 10:13 PM
    Hello everyone,

    I am trying to create an IPA flow that generates an output as the "delimited text" output file (as shown below) but keep having an issue of it does not spool the output file even thought it said so in the log file.

    Sample Delimited text which begin and end of each with double tildes (~~) and separate each column with the pipe (|): 
    ~~ContractNumber|ContractName|Location~~

    Does any one know if this possible to get done in IPD version 10.1.1.78 ?

    Here is how I did:  Start > SetFileName > File (store the SQL query) > SysCmd (Execute SQL) > End.

    Can you please advise. Thanks in advance,
    Han
    Jason Beard
    Veteran Member
    Posts: 124
    Veteran Member
    1/26/2019 5:29 PM
      Han -
      Are you using IPA to output the file or is your stored procedure outputting the file? If you are using a syscmd to execute the SQL then it seems that the SQL is responsible for outputting the file? In which case it's not an IPA issue but rather a SQL issue. You can put your SQL into an IPA SQL node and then use a message builder to accumulate the data and then file access to create create the file itself...
      Jason Beard
      617-548-5568
      jabeard3@gmail.com
      HDAustin13
      Advanced Member
      Posts: 31
      Advanced Member
      1/28/2019 12:09 PM
        Hi Jason,

        I am using IPA with a syscmd to execute the SQL for generating the file. The issue was a spooling syntax and I got it fixed. Thank you for the hints, Jason.

        Han
        You are not authorized to post a reply.