Hello,
Using PB 2022 R2 Build 2819, PostGRESql 15
Need to retrieve string values into a datawindow, whose length varies from 50000 to 100000 characters. Currently it retrieves only 10000 characters with the following settings.
Using DSN-Less connection, [ @ runtime ]
SQLCA.DBParm="ConnectString='Driver=PostgreSQL Unicode(x64);Database=one;Server=localhost;Port=<Port>;UID=<username>;PWD=<pass>;',DisableBind=1"
Design Mode [ Datawindow ]. It shows a length of 32766, with the following settings in DB Profile [ Driver specific parameters ]
MaxVarcharSize=100000;MaxLongVarcharSize=100000;
Still it retrieves only 10000 characters.
Database field got complete value. Only in datawindow we get only 10000 characters, and not the complete value [ which ranges from 50000 - 70000 characters].
What setting we need to do for PB to read full value(s) ?
Happiness Always
BKR Sivaprakash
Those long values we get from GSTN Portal and were storing in the database for later retrieval. Since we had issues in retrieving long character values, we stopped storing such long values ( length > 10000 ) in the database and if required, fetch again from GSTN portal. That way we by-passed this issue. After that we haven't tried again.