sequential stage filter command
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 296
- Joined: Sun Nov 16, 2008 7:41 pm
sequential stage filter command
HI
I have a file with 2 rows and 1 columns
ex file:
qwerty
asdfgh
these are stored in filename test
Now i want to read only second row.
So i have enabled filter command and input the command as
tail -1 test.
It says filter command error
What should i input ?
I have a file with 2 rows and 1 columns
ex file:
qwerty
asdfgh
these are stored in filename test
Now i want to read only second row.
So i have enabled filter command and input the command as
tail -1 test.
It says filter command error
What should i input ?
Re: sequential stage filter command
Loose the filename, and put only tail -1 as your Filter Commandreachmexyz wrote: tail -1 test.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Premium Member
- Posts: 296
- Joined: Sun Nov 16, 2008 7:41 pm
Re: sequential stage filter command
I did but still its not workingnarasimha wrote:Loose the filename, and put only tail -1 as your Filter Commandreachmexyz wrote: tail -1 test.
in the filter command i just put tail -1 also i have tried 'tail -1',`tail -1'
Nothing is working
Please find the error message below:
DSBrowser..Sequential_File_0.DSLink2: ds_seqopen() - Error in filter command "tail -1" -
DSBrowser..Sequential_File_0.DSLink2: ds_seqopen() - Error in execv() - No such file or directory
DSBrowser..Sequential_File_0.DSLink2: DSD.SEQOpen GCI $DS.SEQOPEN error 11.
Commands Used:
Filename:
<full path>/Test.txt
Filter command:
tail -1
I am able to view the data from the file when the filter command is not used.
Please help
DSBrowser..Sequential_File_0.DSLink2: ds_seqopen() - Error in filter command "tail -1" -
DSBrowser..Sequential_File_0.DSLink2: ds_seqopen() - Error in execv() - No such file or directory
DSBrowser..Sequential_File_0.DSLink2: DSD.SEQOpen GCI $DS.SEQOPEN error 11.
Commands Used:
Filename:
<full path>/Test.txt
Filter command:
tail -1
I am able to view the data from the file when the filter command is not used.
Please help
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I've already noted that and they've shown they are using a full path to the file:
Trying to remember if there were issues with the filter option in 'earlier' versions...![Confused :?](./images/smilies/icon_confused.gif)
They've also noted that removing the filter and just using the full path works fine and reads all records. So hopefully we're past the invalid path and/or filename and/or permissions part of this problem.Commands Used:
Filename:
<full path>/Test.txt
Filter command:
tail -1
Trying to remember if there were issues with the filter option in 'earlier' versions...
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, you can't do it that way. The file pathname must appear in the filter command itself, the actual File Name property is ignored, and DataStage reads stdout of the actual (given) filter command.
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.
No, that's not true and I believe we've had this conversation before. The filename property is required, is not ignored and it works just fine as I posted as the stage automatically combines the two. Come on, give it a try, you'll see.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers