google.com, pub-6526244334439036, DIRECT, f08c47fec0942fa0

Methods to retailer CLOB variable information to the desk by the use of webservice

CLOB stands for Character Huge Object, CLOB retailers large portions of character information ,as a lot as 4GB in dimension. CLOB information is also very large, some database administration strategies do not retailer the textual content material instantly inside the desk. Instead, the CLOB self-discipline serves as an deal with, which references the state of affairs of the information.

New Stuff:- How to increase no. of characters in Line text entry using import template

How one can deal with CLOB in X3 Script file and Show, tables and opinions:

In X3,Clbfile is the important thing phrase used to declare the variables of the kind CLOB.

Syntax:

          Native Clbfile Name_of_the_Variable(Dimension)

          Native Clbfile Name_of_the_Variable(Dimension)(Dimensions)

Occasion:

          Native Clbfile YMYCLOB(200)

          Native Clbfile YMYCLOB(200)(1..10)

          Dimension: having index fluctuate 1 to 10

In X3 ,ACB is the information types that may be utilized in the entire dictionaries the place the CLOB information is printed  in show fields, desk fields, report setups, and lots of others.

ACB information type retailers the information higher than 250 characters inside the database.

When saving file date to the sector of desk in case you occur to find any “Textual content material file dimension too prolonged error”, then declare the sector as ACB to rectify the error.

Create Subprogram based totally Web service:

STEP 1: Create a script with subprogram for storing enter information to the desk.

Create a desk named YCLOBTAB with following fields

S.No

Establish of the Space

Datatype

Dimension

1

YLEG

A

10

2

YFILENAM

A

50

3

YFILESTR

ACB

 

4

YSTA

A

50

Click on on on Create and Validate the desk in X3.

Create the Script file title: YSAVEENCRYPT and write the subprogram beneath:

Subprog  YSAVECLOB(YLEG,YFILENAM,YFILESTR,YSTA) 

Value    Char     YLEG

Value    Char     YFILENAM

Value    Clbfile   YFILESTR

Variable Char     YSTA

##OPENING Desk for storing CLOB information FILE

If !clalev([F:YCLB]) Native File YCLOBTAB[F: YCLB] :Endif

####ERROR HANDLING

ONERRGO YCATCH

         [F: YCLB]YLEG           = YLEG

          [F: YCLB]YFILENAM = YFILENAM

          [F: YCLB]YFILESTR  = YFILESTR

          WRITE[F: YCLB]

          YSTA = “SUCCESS”

ONERRGO

#####

Shut File[F: YCLB]

End

## ERROR HANDLING CATCH METHOD

$YCATCH

   YSTA = “FAIL”

Resume

STEP 2: Create Subprograms by referring script file and subprogram created on step 1

Navigational Path: Enchancment>Script dictionary>Subprograms.

Creating Subprograms
Creating Subprograms

Enter the Script file title in File self-discipline “YSAVEENCRYPT”

Enter the subprogram title in Subprograms self-discipline “YSAVECLOB”

Enter the appropriate description in Description self-discipline “Save CLOB information”

Then click on on on Create button, then publication button will get enabled then click on on on publication button to create web service.

Creating Webservices
Creating Webservices

STEP 4:Invoking the Web service by XML enter

For Invoking Webservices, Please refer the weblog “How one can invoke Import/Export Template by the use of Webservices”

Place the beneath XML in  Enter XML/JSON self-discipline

<PARAM>

<GRP ID=”GRP1″>

<FLD NAM=”YSLEG”  TYP=”Char”>AUS</FLD>

<FLD NAM=”YSFILENAM”  TYP=”Char”>FIL002</FLD>

<FLD NAM=”YSFILESTR”  TYP=”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>

<FLD NAM=”YSTA”  TYP=”Char”></FLD>

</GRP>

</PARAM>

The sphere YSFILESTR contains higher than 255 characters.

STEP 5: Response after invoking Web suppliers

<RESULT>

<GRP ID=”GRP1″>

<FLD NAME=”YSLEG” TYPE=”Char”>AUS</FLD>

<FLD NAME=”YSFILENAM” TYPE=”Char”>FIL002</FLD>

<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>

<FLD NAME=”YSTA” TYPE=”Char”>SUCCESS</FLD>

</GRP>

</RESULT>

This weblog helps us to know what’s CLOB, what’s the important thing phrase utilized in script and database in X3 and simple strategies to retailer the CLOB information to the desk using subprogram based totally web service.

About Us

Greytrix – a globally acknowledged and considered one of many oldest Sage Enchancment Companion is a one-stop reply provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we supply full end-to-end assist in your technical consultations, product customizations, information migration, system integrations, third-party add-on enchancment and implementation competence.

Greytrix caters to a wide range of Sage X3, a Sage Enterprise Cloud Decision, selections. Our distinctive GUMU™ integrations embrace Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Assist worldwide for Sage X3. Presently we’re Sage X3 Implementation Companion in East Africa, Heart East, Australia, Asia, US, UK. We moreover provide best-in-class Sage X3 customization and development services, built-in features resembling POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons resembling Catch – Weight  and Letter of Credit and India Legal guidelines for Sage X3 to Sage enterprise companions, end prospects and Sage PSG worldwide.

Greytrix is a acknowledged Sage champion ISV Companion for GUMU™ Sage X3 – Sage CRM integration moreover listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For additional data on Sage X3 Integration and Firms, please contact us at x3@greytrix.com, We’ll prefer to hearken to from you.

Leave a Reply

%d bloggers like this: