Testing the stage with this. Exactly the same job:
SeqFile_0 ---> EF ---> SeqFile_1
The external filter contains a "sed" instruction. It executes fine in Project A, but does absolutely nothing in Project B, which was based on Project A.
In the job log from Project A, I see that external filter stage was executed, but in the log from Project B, there is not mention of the stage, like it was bypassed. There is no error running both jobs.
Is there a setting I might have forgotten when creating Project B?
Edit: Well, another detail I just found. Here's the sed command I use:
sed 's/#PS_ORA_JDE_SRC.SCH_CTL#/PRODCTL/g'
In Project B, it looks like the "#" character is causing the problem. Works fine in Project A. If I do this in Project B:
sed 's/PS_ORA_JDE_SRC.SCH_CTL/PRODCTL/g', the string will be substituted correctly, but with the "#" characters left intact, which I don't want.
External Filter - Run in one project, not the other
Moderators: chulett, rschirm, roy
Chulett, the parameter set exists in both projects as well, so that's not the issue. Could have been a good clue though so thanks.
I have another way of going about it with different stages, but the external filter would have made it simpler.
All this because the "read select statement from file" option doesn't work with parameters.
I have another way of going about it with different stages, but the external filter would have made it simpler.
All this because the "read select statement from file" option doesn't work with parameters.
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
True but not insurmountable. We had the same need years ago so developed a small routine to take the original sql file statement (with parameters) and substitute in the current runtime values to a new version of the file. The stage always used the modified version.IASAQ wrote:All this because the "read select statement from file" option doesn't work with parameters.
Just an FYI.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers