topic Re: Can we retrieve data for long text directly by database sql query? in Application Development and Automation Discussions

Can we retrieve data for long text directly by database sql query?

Former Member — Sat, 15 Feb 2014 08:58:28 GMT

Hello,

I am trying to find a way to write some SQL statement to query in database to retrieve the long text for item master data.

What I knew is that long text is stored in the table STXH and STXL, but the raw data need to be processed via the ABAP function READ_TEXT.

Is there a way to process the CLUSTD (SAPscript: STXL LONG RAW)?

i.e. looks like the following:

SELECT some_sql_server_function(CLUSTD) FROM STXL WHERE ....

thanks.

Re: Can we retrieve data for long text directly by database sql query?

Former Member — Thu, 20 Feb 2014 10:48:11 GMT

Hi,

have a look at this thread and look out code given by

Re: Can we retrieve data for long text directly by database sql query?

ThomasZloch — Thu, 20 Feb 2014 12:25:15 GMT

The actual decryption of the data cluster is done by ABAP statement IMPORT (used in READ_TEXT and also in my approach as mentioned by Hitesh).

I understand you want to read STXL via Native SQL statements, I have no idea at this point how to do this, to be honest. You might want to ask in the SCN space for your database system named "SAP on <dbname>."

Thomas