Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 161
	Members: 0
	Total: 161

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Spooling Delimited pipe text output file

2 Replies

2 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

HDAustin13

Advanced Member

Posts: 31

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

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...

HDAustin13

Advanced Member

Posts: 31

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