Hi,
1)i am doing grep in execute command activity
getting
Output from command ====>
"all_v1"
2) Using nested condition
to load table_a
Activity.$CommandOutput = 'all_v1'
table_a not getting loaded any idea what should be nested condition.
commandoutput
Moderators: chulett, rschirm, roy
Command Output is a dynamic array so there a Field Marks included that are causing your comparison to fail. Try array notation:
Or strip them:
And see if either one works for you.
Code: Select all
Activity.$CommandOutput<1> = 'all_v1'
Code: Select all
Convert(@FM,"",Activity.$CommandOutput) = 'all_v1'
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Changing quotes won't make any difference.
There must be something here we are missing (or at least I am), some vital piece of information left unspoken. Can you expand on your job design, specifically what "using nested condition to load table_a" and "not getting loaded" mean? I've been making some assumptions, perhaps the issue is there. Log messages may help as well, like what you posted for 1).
There must be something here we are missing (or at least I am), some vital piece of information left unspoken. Can you expand on your job design, specifically what "using nested condition to load table_a" and "not getting loaded" mean? I've been making some assumptions, perhaps the issue is there. Log messages may help as well, like what you posted for 1).
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 20
- Joined: Tue Feb 02, 2010 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
An alternative is to strip the line terminator in the command itself.
Code: Select all
grep string file | tr -d '\n'
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.