{"id":20723,"date":"2020-09-18T14:26:00","date_gmt":"2020-09-18T14:26:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=20723"},"modified":"2020-09-18T14:26:02","modified_gmt":"2020-09-18T14:26:02","slug":"how-to-store-clob-variable-data-to-the-table-through-webservice","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/09\/18\/how-to-store-clob-variable-data-to-the-table-through-webservice\/","title":{"rendered":"How to store CLOB variable data to the table through webservice"},"content":{"rendered":"

CLOB stands for Character Large Object, CLOB stores large amounts of character data ,up to 4GB in size. CLOB data may be very large, some database management systems do not store the text directly in the table. Instead, the CLOB field serves as an address, which references the location of the data.<\/p>\n

New Stuff:- How to increase no. of characters in Line text entry using import template<\/a><\/p>\n

How to address CLOB in X3 Script file and Screen, tables and reports:<\/u><\/strong><\/p>\n

In X3,Clbfile is the keyword used to declare the variables of the type CLOB.<\/p>\n

Syntax:<\/u><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Local Clbfile Name_of_the_Variable(Length)<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Local Clbfile Name_of_the_Variable(Length)(Dimensions)<\/p>\n

Example:<\/u><\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Local Clbfile YMYCLOB(200)<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Local Clbfile YMYCLOB(200)(1..10)<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Dimension: having index range 1 to 10<\/p>\n

In X3 ,ACB is the data types that can be used in all the dictionaries where the CLOB data is defined\u00a0 in screen fields, table fields, report setups, etc.<\/p>\n

ACB data type stores the information more than 250 characters in the database.<\/p>\n

When saving file date to the field of table if you find any “Text file length too long error”, then declare the field as ACB to rectify the error.<\/p>\n

Create Subprogram based Web service:<\/u><\/strong><\/p>\n

STEP 1: Create a script with subprogram for storing input data to the table.<\/u><\/strong><\/p>\n

Create a table named YCLOBTAB with following fields<\/p>\n\n\n\n\n\n\n\n
\n

S.No<\/p>\n<\/td>\n

\n

Name of the Field<\/p>\n<\/td>\n

\n

Datatype<\/p>\n<\/td>\n

\n

Length<\/p>\n<\/td>\n<\/tr>\n

\n

1<\/p>\n<\/td>\n

\n

YLEG<\/p>\n<\/td>\n

\n

A<\/p>\n<\/td>\n

\n

10<\/p>\n<\/td>\n<\/tr>\n

\n

2<\/p>\n<\/td>\n

\n

YFILENAM<\/p>\n<\/td>\n

\n

A<\/p>\n<\/td>\n

\n

50<\/p>\n<\/td>\n<\/tr>\n

\n

3<\/p>\n<\/td>\n

\n

YFILESTR<\/p>\n<\/td>\n

\n

ACB<\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

4<\/p>\n<\/td>\n

\n

YSTA<\/p>\n<\/td>\n

\n

A<\/p>\n<\/td>\n

\n

50<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Click on Create and Validate the table in X3.<\/p>\n

Create the Script file name: YSAVEENCRYPT and write the subprogram below:<\/p>\n

Subprog\u00a0 YSAVECLOB(YLEG,YFILENAM,YFILESTR,YSTA)\u00a0<\/p>\n

Value\u00a0\u00a0\u00a0 Char\u00a0\u00a0\u00a0\u00a0 YLEG<\/p>\n

Value\u00a0\u00a0\u00a0 Char\u00a0\u00a0\u00a0\u00a0 YFILENAM<\/p>\n

Value\u00a0\u00a0\u00a0 Clbfile\u00a0\u00a0 YFILESTR<\/p>\n

Variable Char\u00a0\u00a0\u00a0\u00a0 YSTA<\/p>\n

##OPENING Table for storing CLOB data FILE<\/p>\n

If !clalev([F:YCLB]) Local File YCLOBTAB[F: YCLB] :Endif<\/p>\n

####ERROR HANDLING<\/p>\n

ONERRGO YCATCH<\/p>\n

\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0[F: YCLB]YLEG \u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0= YLEG<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [F: YCLB]YFILENAM = YFILENAM<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [F: YCLB]YFILESTR \u00a0= YFILESTR<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WRITE[F: YCLB]\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YSTA = “SUCCESS”<\/p>\n

ONERRGO<\/p>\n

#####<\/p>\n

Close File[F: YCLB]\n

End<\/p>\n

## ERROR HANDLING CATCH METHOD<\/p>\n

$YCATCH<\/p>\n

\u00a0\u00a0 YSTA = “FAIL”<\/p>\n

Resume<\/p>\n

STEP 2: Create Subprograms by referring script file and subprogram created on step 1<\/u><\/strong><\/p>\n

Navigational Path: Development>Script dictionary>Subprograms.<\/p>\n\n\n

\"Creating
Creating Subprograms<\/figcaption><\/figure>\n\n\n

Enter the Script file name in File field “YSAVEENCRYPT”<\/p>\n

Enter the subprogram name in Subprograms field “YSAVECLOB”<\/p>\n

Enter the appropriate description in Description field “Save CLOB data”<\/p>\n

Then click on Create button, then publication button gets enabled then click on publication button to create web service.<\/p>\n

<\/p>\n\n\n

\"Creating
Creating Webservices<\/figcaption><\/figure>\n\n\n

STEP 4:Invoking the Web service by XML input<\/u><\/strong><\/p>\n

For Invoking Webservices, Please refer the blog “How to invoke Import\/Export Template through Webservices”<\/p>\n

Place the below XML in\u00a0 Input XML\/JSON field<\/p>\n

<PARAM><\/p>\n

<GRP ID=”GRP1″><\/p>\n

<FLD NAM=”YSLEG”\u00a0 TYP=”Char”>AUS<\/FLD><\/p>\n

<FLD NAM=”YSFILENAM”\u00a0 TYP=”Char”>FIL002<\/FLD><\/p>\n

<FLD NAM=”YSFILESTR”\u00a0 TYP=”Clob”><\/p>\n

hQEMA\/KwatWd7FffAQf\/Zh\/GVgozLWaVOVzVrJT9KZvjJ0QKs4p698zA2oCb9LhK<\/p>\n

QRprExhgALKZp7qdtnK5LRC9P1VNt0lKduZ23BjxXWlaxY5V+TwxdAcVXEonWhB2<\/p>\n

3SbK9wDjgB1w0zItOC+dz5TEYvzXJMlb9mGqVKwVWqRYYaKgjg3AHF4+iu4VSUns<\/p>\n

sImvvOvnNDQ\/3KPX3NE3F3RS9XeTajU4zozbYkry+mcxGbj9wAsNASMLWqBTb2sN<\/p>\n

NGG5EAqkqTBxsIbHv+m5J8GZbpTrJgIkiek+shVrH0nNnIGyz6I7bedxIupFY5xQ<\/p>\n

lYAuupvuIuSK4DcOuiXazUvKx81kSFGvKTnsadMCcsnBHaOE6dEW9crEd5itDsWE<\/p>\n

yJflofoO2WR7B1vQ5O2Vd8pBLJ7xxtt3SVzQToO4921wRd99BROeMfUDVLXwqR5\/<\/p>\n

AGUbyw+Y383AFSfdjYvxK2XSW3Fit6JVNZ1SqXVVuMzpyA9+nchkffzL4WiI+p7m<\/p>\n

I7VnuAjrltUqTcC+7cd1viTVcH6GD9liaElQnbwVJt12FYOe0JYio9FWOdFPBeIJ<\/p>\n

Vhm0RjPm\/fDffbGhPm\/mzkbhJLskRFXek1e\/\/wt9SEmSgJ6U\/erYerfxwOYPDE2n<\/p>\n

y3qrP7Kz5ROQn15cU8Fh8zoTBJT53pvAH6GFvpzoQoPyv35Oy1YWulHTRkWoCRoG<\/p>\n

kJVbvL2pUftyxZBWc1tufQKZ9VO7s+WqiS1BJWvwj2U1JdbLgbt+1mQXU+T86KHg<\/p>\n

xfKTjMBnjZFLKXJxvyn+efx6zfQ5EDiaw7SmsLoQe4stA9RHQcYRuN0UAGR4qxVS<\/p>\n

Lm6QAPQImLnz+17Uqt449w5s9OEOlRAva+6aN9tJmp+roeQOT813Mn6BPz51KX65<\/p>\n

\/gbPUDRgPp30NQsEDbqusrqLVCCEikYGwLteNNShbz2+IR1mDtsEsDsRFJPNOaaL<\/p>\n

t05eLvB4DPjCZWL27lKkOXMeXuj3kzYdXDVyl0YHyw===Z1hp<\/p>\n

<\/FLD><\/p>\n

<FLD NAM=”YSTA”\u00a0 TYP=”Char”><\/FLD><\/p>\n

<\/GRP><\/p>\n

<\/PARAM><\/p>\n

The field YSFILESTR contains more than 255 characters.<\/p>\n

STEP 5: Response after invoking Web services<\/u><\/strong><\/p>\n

<RESULT><\/p>\n

<GRP ID=”GRP1″><\/p>\n

<FLD NAME=”YSLEG” TYPE=”Char”>AUS<\/FLD><\/p>\n

<FLD NAME=”YSFILENAM” TYPE=”Char”>FIL002<\/FLD><\/p>\n

<FLD NAME=”YSFILESTR” TYPE=”Clob”>hQEMA\/KwatWd7FffAQf\/Zh\/GVgozLWaVOVzVrJT9KZvjJ0QKs4p698zA2oCb9LhK QRprExhgALKZp7qdtnK5LRC9P1VNt0lKduZ23BjxXWlaxY5V+TwxdAcVXEonWhB2 3SbK9wDjgB1w0zItOC+dz5TEYvzXJMlb9mGqVKwVWqRYYaKgjg3AHF4+iu4VSUns sImvvOvnNDQ\/3KPX3NE3F3RS9XeTajU4zozbYkry+mcxGbj9wAsNASMLWqBTb2sN NGG5EAqkqTBxsIbHv+m5J8GZbpTrJgIkiek+shVrH0nNnIGyz6I7bedxIupFY5xQ lYAuupvuIuSK4DcOuiXazUvKx81kSFGvKTnsadMCcsnBHaOE6dEW9crEd5itDsWE yJflofoO2WR7B1vQ5O2Vd8pBLJ7xxtt3SVzQToO4921wRd99BROeMfUDVLXwqR5\/ AGUbyw+Y383AFSfdjYvxK2XSW3Fit6JVNZ1SqXVVuMzpyA9+nchkffzL4WiI+p7m I7VnuAjrltUqTcC+7cd1viTVcH6GD9liaElQnbwVJt12FYOe0JYio9FWOdFPBeIJ Vhm0RjPm\/fDffbGhPm\/mzkbhJLskRFXek1e\/\/wt9SEmSgJ6U\/erYerfxwOYPDE2n y3qrP7Kz5ROQn15cU8Fh8zoTBJT53pvAH6GFvpzoQoPyv35Oy1YWulHTRkWoCRoG kJVbvL2pUftyxZBWc1tufQKZ9VO7s+WqiS1BJWvwj2U1JdbLgbt+1mQXU+T86KHg xfKTjMBnjZFLKXJxvyn+efx6zfQ5EDiaw7SmsLoQe4stA9RHQcYRuN0UAGR4qxVS Lm6QAPQImLnz+17Uqt449w5s9OEOlRAva+6aN9tJmp+roeQOT813Mn6BPz51KX65 \/gbPUDRgPp30NQsEDbqusrqLVCCEikYGwLteNNShbz2+IR1mDtsEsDsRFJPNOaaL t05eLvB4DPjCZWL27lKkOXMeXuj3kzYdXDVyl0YHyw== =Z1hp<\/FLD><\/p>\n

<FLD NAME=”YSTA” TYPE=”Char”>SUCCESS<\/FLD><\/p>\n

<\/GRP><\/p>\n

<\/RESULT><\/p>\n

This blog helps us to understand what is CLOB, what is the keyword used in script and database in X3 and how to store the CLOB data to the table using subprogram based web service.<\/p>\n\n\n

About Us<\/strong><\/h2>\n\n\n\n

Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

Greytrix has some unique integration solutions developed for Sage CRM<\/a> with Sage ERPs namely Sage X3<\/a>, Sage Intacct<\/a>, Sage 100<\/a>, Sage 500<\/a>, and Sage 300<\/a>. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.<\/p>\n\n\n\n

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 \u2013 Sage CRM integration listed on Sage Marketplace<\/a> and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace<\/a>. The GUMU™ Cloud framework<\/a> by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n

For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

CLOB stands for Character Large Object, CLOB stores large amounts of character data ,up to 4GB in size. CLOB data may be very large, some database management systems do not store the text directly in the table. Instead, the CLOB field serves as an address, which references the location of the data. New Stuff:- How\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2796],"tags":[3093,3095,333,3096,2409],"class_list":["post-20723","post","type-post","status-publish","format-standard","hentry","category-technical","tag-acb","tag-clbfile","tag-clob","tag-subprogra","tag-webservice"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/20723","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=20723"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/20723\/revisions"}],"predecessor-version":[{"id":20747,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/20723\/revisions\/20747"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=20723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=20723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=20723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}