DSXchange

Hi, I have routine ErrID(0) with 0 as argument. The command that is mentioned is not resetting the value. The value is getting incremented. I gave the command mentioned in Before/after stage routine using ExecTCL and inputvalue UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = '0'; Please ...

Hi,
I wrote a routine to word wrap a string to 40 characters.
Initially it worked fine.
Recently I tried testing the routine.
Now I am getting error as 'Failed to Test Harness'
I am unable to find the root cause for this.
Can you give me a solution to resolve this issue.



Phani

Hi Nag,
Can you please let me know, if you are thru in ur logic.
Can you please provide me the solution, since i am also stuck up with this kind of logic.

Hi,
Empno can be in multiple rows, if the column is normalizing into multiple rows .

Hi, Actual problem in like this I have 1 lakh records with 10 fields per record. With in in one column i have 10 comma separated values. I need to transform these 10 comma separated values into 10 different rows in the target. Ex Empno| Empid |Remarks 1020|2034|8990,20608,4567,6789,56576,9876,4343,4...

Hi,
I need the output as u have mentioned

Hi,
I want to create multiple rows, by passing a single column as input.
Tried with pivot stage.but couldnt make it.
Any suggestions on this plz..

rgds
Phani

Hi All,
Thanks for the information in detail and helping me.

Hi,
Whats the functionality of unidata stage.
Can we use unidata stage for lookup.
whats the procedure for using that in the jobs where i need to use unidata stage as a lookupstage.Can any one give the solution in detail or refer me where can i get in detail about this.

rgds
pk