Topic Options
#36786 - 05/06/13 05:31 AM Data Dictionary / Data Structure
Brian Puddington Offline
Adagio Ace

Registered: 06/09/08
Posts: 225
Loc: Montreal, Canada
I am working with a software developer who has a vertical market cargo program. We will be importing customer & vendor profiles as well as transactions into Adagio. During this exercise the question came up as to the difference between Adagio’s CHAR and RCHAR data types as specified in the Data Dictionary.
I am very familiar with the difference between CHAR and VARCHAR data types in SQL. In the Adagio environment are CHAR data fields fixed length, right padded and VARCHAR variable length with trailing spaces?
_________________________
Brian Puddington
Geneva Financial Systems
Montreal

Top
#36787 - 05/06/13 06:03 AM Re: Data Dictionary / Data Structure [Re: Brian Puddington]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Brian,

RCHAR fields are right justified, zero trimmed and blank filled. CHAR fields are left justified and usually blank trimmed.

The easiest way to get data into Adagio is to set up an Import template and import the master file or transaction information from either a text file (CSV or blocked records) or an Excel spreadsheet. The import process can delete the file on successful processing of the import. Imports can be automatically process on module start up.
_________________________
Andrew Bates

Top
#36790 - 05/06/13 07:16 AM Re: Data Dictionary / Data Structure [Re: Retired_Guy]
Brian Puddington Offline
Adagio Ace

Registered: 06/09/08
Posts: 225
Loc: Montreal, Canada
I am very familiar with importing into Adagio. The other guy is an SQL tekkie and he was curious about the described data structures. Thanks for the info.
_________________________
Brian Puddington
Geneva Financial Systems
Montreal

Top
#36795 - 05/06/13 02:46 PM Re: Data Dictionary / Data Structure [Re: Retired_Guy]
Brian Puddington Offline
Adagio Ace

Registered: 06/09/08
Posts: 225
Loc: Montreal, Canada
Another question that he raised that had never occurred to me - date fields are listed in the AR data dictionary as being 3 characters. I have never had a problem importing using the Adagio import templates, but this did arouse my curiosity. Are they really 3 characters?
_________________________
Brian Puddington
Geneva Financial Systems
Montreal

Top
#36796 - 05/06/13 02:54 PM Re: Data Dictionary / Data Structure [Re: Brian Puddington]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
yy/mm/dd stored in individual bytes. Each byte can hold a number between 0 and 255. NULL dates are stored as 0/0/0.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (AudreyQuick), 71 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14471 Topics
70679 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30