DSXchange

Hi, I have a query with join 3 Tables(eg : A,B,C).I defied it as User Defined Qyery in the Db2 Enterprise Stage.The job run slow as the default method of "User Defied Query" is sequential.I am trying to use the PARTION Table option to make this qury work in parallel mode.I provided value P...

The JOb should initiate every 45th Day.
There is a date parameter which can be used to keep a track of the count.

Please let me know if you want more info.

Hi,

I have to design 2 jobs in such a way that on the 45th successful completion on first job I have to kick start the second job. This job will run one time and will again wait for 45 completions of Job one.

How can I implement this.

Thanks

TRY THIS :
DecimalToDecimal(Column name,[2])
This should do it.

HI Abhi,

Decimal[4,2] will give output 1024.00.
But String 10 will only give '1024' if its a VarChar or '1024 ' if its a Char.

OSH is generated when the job get compiled.
You can see the generated OSH in the Job Properties.

Hii,

Can anyone tell me where to write the Code for a Parallel Routine.I want to wite a routine for caracter to Integer Decoder.

I can create the routine through the manger but I am not able to figure out where to write the code.(In server there is a tab as CODE).

Is it somewhere in Parallel Also.

Thanks 4 reply !!!
That was just an example.
I am learning how to write a transform.
Can you give me a generic method to write it .

I have written a Built In Transforms to convert Null to Zero in the designer.
But i am not able to see it in the transformer Stage Functions.
Do we have to compile it Somewhere in Director or Manager ??

Ray,

I have figured that thing out.....
Sorry to confuse you.
You can skip the third part .
Can you tell me how to get the Start time & Termination Time ??

Hii,

I need to fetch the job Start time,Job Termination Time and Number of times job ran into a db2 Table.
Can anyone tell me how to do that ??

Thanks

Hi,
Can anyone give me a Schema File Templete which is used in the Sequential file Stage .Please give a exaple of what type of file is there.
Is it a csv file or what & where to store that file.

cheers,
Jayant

Hi Amarpreet, In the final Transformer Stage you can concate all key columns to a long String and Store it into a Stage Variable named STG1. Now another variable STG2 = STG1. Compare the two.by this you will capture the rows in the two variables.Check them and put the constaint accordingly on the li...

Hi Anshuman,

On your unix box you have to find the Datastage Directory where all these stuff is stored.

I am gettin this fatal error in my Job when i m tring to load in Db2 Enterprise Stage. DB2 Driver Embedded SQL message: SQL0311N The length of string host variable number "3" is negative or greater than the maximum. SQLSTATE=22501 ; sqlcode = -311; sqlstate = 22501 Execute failed. just a i...