Dstage Sahayam

[tharun057]

Bhayyas chinna help kavali

 

Datastage logic kavali ee Employee any table ki

 

 

Employee_NAme     Employee_ID

vvvv                 12345

 

yyyy                 67890

 

 

xxxx                 45674

 

 

naaku output lo employee_id column (values reverse lo kavali)

 

  Employee_ID

    

   54321

   09876

 47654 

 

 

 

[iTeachSAP]

Hello Bayya

for this you can build a datastage subroutine to reverse the string.

take a varibale Str and initilize it to '', then write this routine

Str = ''
For i=1 to Len(Arg1)
Str = x[i,1] : Str

Next

Ans = Str

and use the same routine in your DS job

[tharun057]

Hello Bayya

for this you can build a datastage subroutine to reverse the string.

take a varibale Str and initilize it to '', then write this routine

Str = ''
For i=1 to Len(Arg1)
Str = x[i,1] : Str

Next

Ans = Str

and use the same routine in your DS job

Thanks Bhayya. But nenu try chesanu work avvatle..vere alternative undha

[iTeachSAP]

Thanks Bhayya. But nenu try chesanu work avvatle..vere alternative undha

 

source database enti ? 

[tharun057]

source database enti ? 

 

source oracle target db2

[iTeachSAP]

mari inkem.. 

 

oracle source sql lo reverse function use cheyi .... 

 

SELECT REVERSE ( column) from  <TABLE> 

[Johny]

pillakayalu screenshare sesukoni problem solve seukondi silent ga..

[Johny]

babu iteach sap neeku Basis vaccha??

[iTeachSAP]

babu iteach sap neeku Basis vaccha??

 

 

basic gaa nenu basis side kaadhu .. kavalante cheppu .. frnd unnaduu ..what ur wants..