• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Spooling Delimited pipe text output file

 2 Replies
 2 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
HDAustin13
Advanced Member Send Private Message
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 Send Private Message
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 Send Private Message
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