DSXchange

Author will feel the relevance.

And I feel that there is no need to say any post as offtopic for no cause.

Bifurcate means cutting into halves. That means two parts. and so bifurcate into 4 makes no sense and the word is used out of context. Ray is pointing it out. Nothing related to the actual topic i guess. ray.wurlod - Is this you wanted to convey? please confirm. I dont think that he might mean this...

ray.wurlod wrote:<pedantic>
You can't bifurcate into four.
</pedantic>

I hardly understand what you said, ray.wurlod. Would you like to explain it further?

Correct. But the Server side tracing messages like this while deleting a Job. 2006-06-13 00:17:04: DSR_MESSAGE =Deleting file RT_BP5.O Deleting file RT_BP5.O DELETEd "RT_BP5.O", Type 19. Field 2 in file definition record "RT_BP5.O" has been set to nothing. The correponding record...

If the default value is not given for $APT_CONFIG_VALUE and the default config file(config.apt) is not found in the Working directory and in $APT_ORCHHOME/etc, DataStage will throw an error message like below if we attempt to even compile the Parallel Job having Transformer Stage. A configuration f...

ray.wurlod wrote:<pedantic>
You can't bifurcate into four.
</pedantic>

Could you please let me stay in the meaning of your words here?

Can you ensure that Null in the table does have a reprentation in the text file too(as at least empty string)?

Better output the rejected records from Sequentila File Stage to an another file and see that unfit.

Could you enable Server Side tracing and look at the tract file to find which internal BASIC Subroutine calls these programs while resetting?

That output looks correct, you have found that the JOBNO for that job is number "6". What do you think your problem is? Is that true that If we delete a Job through Designer, the corresponding record entries in DataStage files DS_JOBS, DS_JOBOBJECTS would be deleted and all respective run...

Minhajuddin wrote:If you have more than one column and you want other columns to be intact, you need to split it using a copy stage aggregate it on COL1 and then join it back with the original stream on COL1

Didn't see that Job type is Server, Minhajuddin.

Minhajuddin wrote:These work even from the server :D

Only if the server has a Windows OS and has Datastage client installed on it

They do exist and work only from Client, though they(Server and Client) run on same machine.

No Sravani,

The problem is NOT because of IsNull() funtion, either. And teh suggestion you provided is not correct and not needed at first.

The header IS a row, and therefore is properly included in the row count. The header is NOT counted as a row if we set "First Line is column names" true. is it enviormrnt issue or something else. It would NOT be an environment issue. Please check that option in the Sequential File Stage w...

But while compiling the job it is giving the following error message : "A configuration file(APT_CONFIG_FILE) must be set up to compile a Parallel transformer stage." Please let me know if there is any resolution for this error or do we need to modify the design like below Please check wh...

The problem is NOT because of SetNull() being used there. There is no need to substitute this implementation with default value.

We can not take any immediate conclusion of what problem is until author(jaysheel ) comes up with more error messages.