topic Use SQL to get long text in Application Development and Automation Discussions

Use SQL to get long text

Former Member — Tue, 01 Jan 2008 07:29:36 GMT

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

Re: Use SQL to get long text

abdul_hakim — Tue, 01 Jan 2008 07:39:51 GMT

Hi,

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

Cheers,

Hakim

Re: Use SQL to get long text

Former Member — Wed, 02 Jan 2008 05:14:43 GMT

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’

Re: Use SQL to get long text

former_member156446 — Wed, 02 Jan 2008 05:20:01 GMT

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