topic Re: Convert input structure into String and Store it in DB2 in Application Development and Automation Discussions

Convert input structure into String and Store it in DB2

Former Member — Tue, 29 Jul 2008 15:50:51 GMT

Hello All

My requirement is I want to convert total input structure into string then stored into database single field as clob. Can anyone suggest me how will i retive input structor, is there any user defined function will i write or is there any inbuilt functionality in SAP PI. Plese suggest me

Thanks&Regards,

VenkatK

Re: Convert input structure into String and Store it in DB2

Former Member — Tue, 29 Jul 2008 15:54:11 GMT

data:string(100).

than concatenate str-field1 str-fiels2......into string.

than use insert command where ever you want to insert.

Amit.

Re: Convert input structure into String and Store it in DB2

Former Member — Tue, 29 Jul 2008 16:10:22 GMT

Hi Amit,

Can you explain little bit more step by step. I have to send Total input structure of xml message(not onely values). Please guide me step by step.

Thanks&Regards

VenkatK

Re: Convert input structure into String and Store it in DB2

Former Member — Tue, 29 Jul 2008 16:13:15 GMT

say if you have any structure with field 10.than you may concatenate their each field like a suggest above and collect in one string field and finally pass this to DB2.

Re: Convert input structure into String and Store it in DB2

Former Member — Wed, 30 Jul 2008 04:42:07 GMT

Hi,

You can do by making an internal table using that structure then fill that internal table with the values and then concatenate all the values into a single string then update the ztable from this internal table..

here is a piece of code which may be helpful to u..

LOOP AT it_empdetail.

CONCATENATE it_empdetail-r_type

it_empdetail-ssn

it_empdetail-dob

it_empdetail-fname

it_empdetail-lname

it_empdetail-r_code

it_empdetail-stras

it_empdetail-locat

it_empdetail-ort01

it_empdetail-state

it_empdetail-pstlz

it_empdetail-land1

it_empdetail-dat

INTO wa_enrollee SEPARATED BY ' '.

append wa_enrollee INTO it_enrollee .

ENDIF.

ENDLOOP.

here it_enrollee is the final internal table having all the values in a string form and the wa_enrollee is the work area of type string,,,

Now from this internal table u update ur ztable

I hope this help u..

Thanks & Regards

Ashu Singh.