DSXchange

Have you tried a column generator cycling from 1 to 10000 generating a random number? It could be inserted directly downstream of the Transformer.

grep ^1 <filename>

the carat means the beginning of a line
$ means the end of a line.

I thought this was a post on how to score with chicks.

Join Stage

Have you analyzed the hashed files' structure? The Modulo and separation? Does your Create File being checked still create the default dynamic hashed files or have you tuned it?

I see nothing in Chapter 53 in the Parallel Job Developer's Guide that documents anything about generating filepaths. I also don't see a filepath column in the column grid of the output tab of the Row Generator stage. Ray - Can you elaborate?

What is everybody on vacation today? Where's Kumar? Go to the Input tab of the Sequential file stage you are writing to. Go to format tab. Select Field Defaults folder. Select the Null Field Value Property and assign it a value of "" (double quote double quote). In other words a field valu...

When this checkbox is checked and the job compiled, one can run more than one copy of the job at a time. It means exactly what is says. Multiple instances (copies) of a DataStage job can be run simultaneously. The Engine can do this by appending an invocation id to each running instance.

Wasn't there a 20 page article on the dump score in last month's issue of Maxim? Or was it Sports Illustrated?

I think it must be the FILENAME != "#FileDirectory#/". Ever. How come? Did you try to hard code the condition (ex. && 1 != 2 ) to exercise the else {exit 1} in order to see if the overall flow will work? When I tested it I deleted the value of the file parameter. I didn't blank it ...

My bad. My awk WAS slightly different then yours. I changed mine and added double quotes. Here's the error when it works correctly; Sequential_File_0,0: Filter status 256; filter process failed: 1; import error at record 0. Here is my awk; awk -F'\t' '{if( FILENAME != " #PATH#/ " ) {print ...

It worked for me both within DS and from the command line. Perhaps FILENAME = #FileDirectory#/ will never equal #FileDirectory# (without the slash). I would suspect a snytax problem if the awk with the condition worked before. Perhaps you need to enclose the && (condition) in parens to ensur...

Havoc wrote: awk -F'\t' '{if(<condition>) {print $0}}' #FileDirectory#/#Filename#

Try
awk -F'\t' '{if(<condition> && FILENAME != #FileDirectory#) {print $0} else {exit 1}}'

I am very interested in the outcome of this post. I have looked in the documentation and I cannot find the reference but I believe I read somewhere that the Teradata Enterprise Stage will create a work table when an append to a Teradata table is selected for the job. I believe this is because a Fast...

I see no hi-jack. I assume the inability to get content is becasue of the error cited in the post. A 3000K XML row will not fit in a 256K buffer.