DSXchange

I figured it, the layout is PIC S9 and works fine SDK provided with DS. The mistake I was running was with Fixed width definition. There were some extra characters in the length while defining. Srinivasan and Chuck thanks for u r time and help. Chuck u r approach is to create a dump file, which will...

The data looks like +0000079.600{0 +0000407.085{0 +0000078.840{0 +0000075.240{0 +0000129.240{0 definition is PIC S9(7)V9(5) Is there any avlb. SDK to make the Tran. into decimal that can readily loadable into Oracle? Immedaite help req. and highly appreciated. Unable to use DataTypePicS9(Link) Trans...

Hello all... I am looking for a trail version or something like that for QualityStage, MetaStage and ProfileStage... Anyone who can gives some leads will be of very great help...

regards,
kommven

I have faced a similar scenario and I used same ID which is the target table key column name. and it solved my problem. Editing jobs and changing the key sequencer ID is much easier.

I guess one that takes longer time have more keys for updating, check that out...

Will also depend
What are the prefetch row size you are using
Array and Transaction size
Are there any lookups?

Adding 3 columns before Pivot stage with constant value and deriving them in Pivot stage worked fine,,,

Thanks for your advice...

Hard coding is of no use. I have came up with a solution, I am appending the name of column before every data (as Varchar) and after pivoting, I am again doing a if then else condition and seperating char and digits and using appro...

If anyone knows better solution please send it to me...

Hello all, I am trying to get "Column name" in derivation using Pivot stage. How can this be done? Kommu Eg: SOURCE Name, dept,sub1,sub2,sub3 joe,eng,5,5,7 Jim,dep,6,4,5 leo,gen,4,4,4 TARGET Name,Dept,Sub,Marks joe,eng,sub1,5 joe,eng,sub2,5 joe,eng,sub3,7 jim,dep,sub1,6 jim,dep,sub2,5 jim,...

How to get a column name or a hard coded value in derivation.

Kommu

Hi all,

I am in Urgent need for pivot.pdf, missing in my documents can anyone send it to me viz. Email to kommven@yah ASAP

thanks a lot...

Kommu

I think doing SQL will retard my process. I will try with reset thing, Thanks Keith.

Any more suggestions? PLEASE

I like KeyMgtGetNextValue.
Can you tell me how to reset it?

I will create a flat file and then bulk load that flat file using a load utility script file.

if any one knows any more information. appreciated

Lucky

How can I get source file name as target field
Lucky

I am trying to bulk load a seq file into DB2 and avoid inserts, can you tell me how to manage this.

Lucky-