filter command truncates...is this issue ever resolved ?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

filter command truncates...is this issue ever resolved ?

Post by kaps »

Hi

I read somewhere in this forum that filter commands truncates charecters when we use pipe symbol in version 7.1.

I am using version 7.5 and am facing the same problem.
Is this issue ever resolved ? If so do we need to install any patch for this ?

Please let me know.

Thanks
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Kaps,

I did a search of "filter" and "truncate" and didn't come up with any matches, so I don't know what you read and where you read it - what is the actual problem you are getting with filter?

The filter does nothing more than call an OS command, so there isn't much that can go wrong there - this hasn't stopped developers from proving me wrong, but at least it makes problems easy to reproduce here.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I posted something in the past on the issue - I don't recall the exact character, seems to me to have been a single quote or comma rather than a pipe. :? What I see in 7.0.1 is you put in a long filter command, close the stage and reopen it and the command has been truncated at the offending character.

No clue if it's been fixed in later versions.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

Post by kaps »

Thanks Arnd and Craig...

Try to search using the keyword " filter command "....

This is the original post I was talking about...posted by Craig on Tue Jun 07, 2005 11:52 am...
============
The Filter can take any O/S command that handles Standard In and Standard Out well. Sort should be one of them.

There is a bug in the version I am running (7.0.1) where filter commands with quotes or pipes get stripped after the first occurance. You can see this by typing a filter command in the stage, closing it and reopening it. If you are a victim of this, you'll see your truncated command the next time you open the stage. For me it means I have to make sure the record delimiter matches the default for sort as I can't pass in a "-t" with mine.
=============
Post Reply