DSXchange

User Aggregator to the each dataset and the max for each stream. And answering to the other question of yours, if you need use the second column in where caluse, try using WHERE FIELDNAME = :2.

When I give a blank filename or blank folder name, it got aborted. But interestingly with different error message Sequential_File_0,0: Source subproc: awk: Input line  cannot be longer than 3,000 bytes. The input line number is 4. The file is /. The source line number is 1. What is your server flav...

What DSguru2B was referring is to stop the job after 'n' warning. Which is similar to DSJ_LIMITWARN option available in DSSetJobLimit function.

Is these columns still char(10) when entering in to Sort stage?
Try to convert it into Date using the preceeding transformer and then pass it to Sort stage.
You cannot do type conversion in Sort stage.

Changing in Adminstrator will affect your whole project. Sourcing that variable in your job and assigining a different variable will affect only that particular job. You need to decide on how it should reflect. In the variable, you can simple give a space ' ' rather than giving it in Hex value.

Thanks for sharing this.

Search for "Editing Multiple Derivations" under transformer section in the Parallel Job Developer's Guide. There is something mentioned for Regular expression. I haven't gone through it fully.

My Bad!!! Its "File=?" and not File Name. I gave File = /dev/null and Filter = awk -F'\t' '{if( FILENAME != " #FileDirectory#/ " ) {print $0} else {exit 1}}' #FileDirectory#/#Filename# And when I give a file name which doesn't available, it gave out the error Sequential_File_0,0: Source subproc: awk...

If first line of the file contains the file names and all you need is just report whether its different or not, then just read the first line alone (either using "Read first n rows" option in sequential file or using Head stage or using pre processed file, and use the Change capture to find the chan...

Have you solved your own query? If so, do mind sharing it for the further searchers.

jhmckeever, you mean you have created a BuildOps?

And for the second, turn off the RCP.

What is the exact issue now?
As trobinson and I mentioned, it gave out error when there is no file.
You might have entered the awk command in option provided for "Filter". What did you mentioned under the option provided for "File name"?

What is the exact issue now?
As trobinson and I mentioned, it gave out error when there is no file.
You might have entered the awk command in option provided for "Filter". What did you mentioned under the option provided for "File name"?

Hi Purushotham,
Welcome aboard :D !!!
Are you sure this is the only error or warning message you got?
Check the postwith the very similar error.