CODEWITHSUNDEEP
informaticainformatica-powercenter
Maciejg
Maciejg

Reputation: 3378

Command as source backslash issue

I tried reading source via command and came across an issue. The command tested in bash shell worked fine. In Command Task it was working fine as well. However, when put into the Source Qualifier as Command property on a session, it kept crushing.

Looking at the logs I've discovered, that the command has been altered. Original command:

ll ./* | awk -F\  '{if ( NF==1 ) title=$1} else if ( NF>2 ) print title ","$NF"," strftime("%Y"), $6, $7, $8}'

Fetched from log:

ll ./* | awk -F/  '{if ( NF==1 ) title=$1} else if ( NF>2 ) print title ","$NF"," strftime("%Y"), $6, $7, $8}'

The difference is in awk switch changed from -F\ to -F/.

Upvotes: 1

Views: 128

Answers (2)

Daniel Machet
Daniel Machet

Reputation: 630

Found this gem which sounds like it should sort it for you https://kb.informatica.com/solution/23/Pages/51/299665.aspx

Upvotes: 1

Maciejg
Maciejg

Reputation: 3378

Never found any solution. Posting here for future reference. Following the advice found at Informatica KB I've created a script to invoke the command indirectly.

KB entry says: This is a known issue and a CR 108604 has been submitted to be addressed in the future release of PowerCenter. Last Modified Date:8/2/2008 8:05 PMID:1947, - seems it's over 10 years old... Not sure if it's going to be fixed anytime soon. It refers PowerCenter 8.1 and still exists in 10.2

Please share if you know any clever solution.

Upvotes: 0

Related Questions