DSXchange

Well, technically, you are not using either of the twin insert/update statements. You are using User Defined sql. Maybe thats why your not experiencing the same behaviour.

Handle it in the last lookup, before loading your target hashed file.

Did you recompile the SChild before firing off the SParent?

Ok nevermind. Does the config file exist. Does it have read permissions to your id?

Get rid of the dollar sign.

pxr87 wrote: Does the hash files DS_JOBS , DS_JOBOBJECTS which are in project directory is supported and loaded in DS 8.X , as is done in 7.5 ( both server and PX editions ) ?.

Not in hashed files any more. What is your underlaying repository database.

Search reveal this,

I see that your a premium member. You should be available to view premium content.

Is'nt that always the challenge
Good Luck.

You can write a small shell that checks for the existence of each of these files. If any one of them is missing, it creates an empty file so that your job executes. You can call this script in the before job subroutine.

if target column is varchar,it's not a problem.it works fine and when i look data,data format is ok.But i cant change target column from timestamp to varchar because Business objects' reports will be effected. Your change will only be at the datastage level. Not at the database level. How will that...

Make your job multiple instance. Read a subset for each instance. Depending upon the resources available, run as many instances simultaneously.
A much faster approach, bulk load the file into a work table and write a sql query to extract the data. Again two sets of 12 months each.

I agree with Kim. Not uncommon at all. I implemented something along those lines at one of my client's. Ken can definately throw some more light on it. We all love his in depth answers.

So, this topic is resolved then ???

Well actually, if the update the insert or its twin is used with an array size greater then 1, and if it sets it to 1, a warning will be logged telling you about it. As Ray asked, please let us know for what stage did you read about in the manual.