All the Sage X3 developers may come across the requirement where we need to handle the sequential file (.dat file). Sage X3 has the simple commands which help us in easily reading or writing into file.
- Reading Sequential File: To read any sequential first it needs to be open the file in read mode. Following are the command which can be used to read the file.
Openi: is used to open and close a sequential file.
e.g.
a. Opening a file
Openi filepath (‘tmp’,’rdfile’,’’)
b. Closing the last file opened to read
Openi
c. Opening two files
Openi filpath(‘tmp’,’rdfile1’,’’) Using[YYY]
Openi filpath(‘tmp’,’rdfile2’,’’) Using[ZZZ]
d. Closing the two previously opened file.
Openi Using[YYY]
Openi Using[ZZZ]
Adxifs : Contain the field separator used for the read or write of sequential file.
Rdseq: Is used to read the data of the file.
New Stuff: Adding Styles to Screen Fields in X3
Refer to the below sample code for reading the sequential file.
- Writing into Sequential File: To write into sequential it needs to be open the file in write mode. If the specified file does not exist then this command automatically creates the file in the specified directory with the mentioned name. Following are the command which can be used to write the file.
Openo: is used to open and close a sequential file.
e.g.
a. Opening a file
Openo filepath (‘tmp’,’rdfile’,’’)
b. Closing the last file opened to write
Openo
c. Opening two files
Openo filpath(‘tmp’,’rdfile1’,’’) Using[YYY]
Openo filpath(‘tmp’,’rdfile2’,’’) Using[ZZZ]
d. Closing the two previously opened file.
Openo Using[YYY]
Openo Using[ZZZ]
Adxifs : Contain the field separator used for the read or write of sequential file.
Wrseq: Is used to write the data to the files.
Refer to the below sample code for writing into sequential file.
About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage CRM, Salesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight and Letter of Credit for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.
Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.
For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.