Pervasive

Browse by Tags

• DataTools HowTo: Transpose Data from Vertical to Horizontal Orientation

  Question: I have a source text file that contains two fields/columns. In the first column there are product SKUs, each of which is repeated on multiple rows. The second column contains the SIZEs of each of the products that I have in stock. For example... Posted Mar 05 2010, 05:22 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Solve an "Overflow (6)" Error

  Question: For the past 2 days I get an "Overflow (6)" error message when I launch my DataTools product for the first time each morning. What is causing the error, and how can it be fixed? Answer: The Cause The error is usually the result of... Posted Mar 03 2010, 03:59 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Manually Parse a C-ISAM Data File

  Question: I have a C-ISAM file that contains packed and binary data. How can I parse and define the structure of the file and export the unpacked data to a CSV text file format? Answer: Using the Data Parser for C-ISAM , you can define the structure of... Posted Jun 18 2009, 04:28 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Manually Parse a Btrieve Data File

  Question: I have a Btrieve data file that contains packed and binary data. How can I parse and define the structure of the file and export the unpacked data to a CSV text file format? Answer: Using the Data Parser for Btrieve , you can define the structure... Posted Jun 16 2009, 01:39 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Manually Parse a Binary Data File

  Question: I have a source file that contains packed and binary data. How can I parse and define the structure of the file and export the unpacked data to a CSV text file format? Answer: Using the Data Parser for Binary , you can define the structure of... Posted Jun 15 2009, 04:45 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Standardize Various Date Formats

  Question: I have a source text file that contains a field in which there are dates stored in five different character string date formats. How can I standardize the dates to a single format? Answer: Using Map Designer in any of the Pervasive DataTools... Posted Jun 11 2009, 12:42 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Write Rejected Records to a Reject File

  Question: There are records in my source file that I do not want to convert to my target file because they do not meet specific requirements. I know I can filter these records out completely, but can they be written to a different target file in the same... Posted May 14 2009, 02:46 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Use a COBOL Copybook to Define Fields

  Question: Can I use a COBOL copybook (FD) to define the fields in my COBOL data file? And if so, how? Answer: Yes, each of the following DataTools Data Parsers includes a feature that allows you to use a COBOL copybook to parse COBOL data. Detailed steps... Posted May 13 2009, 01:17 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Transpose Data From Horizontal to Vertical Orientation

  Question: Is there a way to change the orientation of my data from rows to columns? Answer: This "DataTools HowTo" contains an example of a data transformation showing how data stored in a row format in your source data file can be transposed... Posted May 01 2009, 12:21 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Resolve Btrieve Error 161

  Question: When I try to connect to a Btrieve data file, I get an error 161. Answer: A Btrieve Error 161 indicates that the Pervasive.SQL user Count exceeded. You may need to check with the DBA and request that any "duplicate" login(s) be shutdown... Posted Mar 09 2009, 11:12 AM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Find DataTools Error Codes

  Question: How do I find the meaning of error code numbers that are returned in the error log file? Answer: The following is a list of error messages that you may encounter while using Map Designer. The messages are listed in numerical order and include... Posted Sep 29 2008, 04:25 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Resolve an Error in the Btrieve Parser - Client Missing

  Question: I get the following error when I try to connect to my Btrieve data file in the Data Parser for Btrieve. "Connector (Btreive v6) is not available for use. It is either not licensed with the product or the product associated with the connector... Posted Apr 25 2008, 01:47 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Use an External Dictionary File to Define Fields

  Question: Can I use a Btrieve DDF (Data Dictionary File) to define the fields in my Btrieve data file? And if so, how? Answer: Yes, the Data Parser for Btrieve includes a feature that allows you to use Btrieve Data Dictionary Files to parse Btrieve data... Posted Apr 25 2008, 01:20 PM by Pervasive DataTools Weblog Filed under: HowTos

• DataTools HowTo: Connect to MS CRM with the Data Loader to MS CRM

  Question: When trying to connect to Microsoft CRM with the Data Loader to MS CRM I get the following error message: ============================================== Unable to create MS CRM COM object. in ConnectTargetandResolve (spectab.bas) (25519) NOTE... Posted Feb 21 2008, 10:25 AM by Pervasive DataTools Weblog Filed under: HowTos