Reading CLOB into JDE form

[DaveBarber]

I need to read a clob field off the database into a JDE form. The clob has data in excess of 5000 characters.
I tried the following dd item changes for the value to be read into in the form via a table IO.

In all cases the data was truncated and could not be read in from the database:

- data item of legnth 16384, type string.
- data item of legnth 16384, type variable string.
- data item of legnth 16384, type clob.

The max size the form variable can retrieve in is 2000. Above this the table IO fails with the following message in the JDE.LOG:

2336/3592 Fri May 16 09:03:11 2008 dbfetch.c166
OCI0000056 - Unable to fetch - SELECT * FROM PRODDTA.F5555288 WHERE ( SC55WID1 = :KEY1 AND SCUSER = :KEY2 AND SCJOBN = :KEY3 AND SCUKID = :KEY4 )

2336/3592 Fri May 16 09:03:11 2008 dbfetch.c172
OCI0000057 - Error - ORA-01406: fetched column value was truncated

Any ideas of how to get around this problem?

Dave

JDE XE SP22 on Oracle 9.2.0.7

 

[Chan Rana]

Dave,
i think this will be too big for the screen to handle.

Best bet would b to convert those CLOB into mediaobject text and dump it into MO table using a link to the document you will read it for.

hope this helps.

Thanks,
Chan

 

[DaveBarber]

Hi Chan,

I agree MO text is the best for viewing this sort of size of data.
However, there is a necessity to use a standard data item.
The data will hold comma seperated values - the user will want to do a search on one of the values in the string using the QBE line.
This works fine on values < 2000 long but obviously nothing bigger.
Any ideas how you might go about pulling in data that is that long? I have only ever handled string of 2048 or less.

many thanks

Dave

 

[Larry_Jones]

Dave,

describe the DD item you're using for this. What are its characteristics?
Are you using Data Type Variable String?

 

[Zoltan_Gyimesi]

Hi Dave,

Larry's question is right, as usual.

More years ago I experienced, that QBE does not work on VARLEN data type field (this was on XE too) - and I had to replace my custom field with a large fixed length field in my custom table, making available QBE on this for the users.

Regards,

Zoltán

 

[Larry_Jones]

Oops - sorry - you DID describe the data types ... my bad

I have used Variable String types successfully in the past - but the largest was only 1200 characters in size. QBE has worked on these.

 

[jacobw123]

Do you mean BLOB(Binary Large Object)?

 

[DaveBarber]

Hi Zoltan,

Thanks for the reply on this.
What size did you use successfully on QBE? Was it more than 2000?

 

[Zoltan_Gyimesi]

Hi Dave,

As far as I remember, the size was less than 2000.

You can make a try with a large fixed length string variable, if it is feasible in your scenario.

I you do it, than let us know your results. Thanks.

Regards & Good Luck,

Zoltán