Use SQL to get long text

[Former Member]

Hi,

Is it possible to retrieve the long text in STXH and STXL by SQL instead of READ_TEXT FM?? How can i covert the HEX text back to normal text??

Regards,

Kit

[abdul_hakim]

Hi,

You should use the READ_TEXT Function Module.You cannot use SELECT clause for this!!

Cheers,

Hakim

[Former Member]

Hi,

1. Only the way to Read long text is use the function module ‘READ_TEXT’ for which u need to pass TEXTOBJECT, TEXTID, TEXTLANGUAGE AND ONEMORE(I FORGET).

Because the STXL and STXH these tables are cluster tables in which data stored in ‘LRAW’ field which is in RAW format which u can not understand and our normal SQL can also.

2. so u can read most of cluster tables by Function modules only.

3. u can modify or saved by ‘save_text’

[former_member156446]

using the FM is easy.. but I suppose it possible.. from the table Stxh.