Category:Format Specifications: Difference between revisions

From BR Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
See the following format specifications for more details on each:
See the format specifications below for more details on each.


See also [[Format specifications]] for a chart comparing their uses.
See also [[Format specifications]] for a chart comparing their uses.
Format specifications tell Business Rules the form that a particular data field will be in. A format specification is required whenever data is input into or output from a program. It is also required with the full screen processing statements. Format specs are not required in the following situations: with unformatted internal files, with all display files, and when unformatted PRINT statements are used.
Not all format specifications are alike in their uses. Some can be used with internal and external files, but not with display files. Some can be used only with full screen formatting. And some format specifications behave differently depending on whether they are used for input or output.
== '''Common SQL Fields and BR Equivilants''' ==
<TABLE BORDER="1" CELLSPACING="1" CELLPADDING="3" WIDTH="100%" ALIGN="Center">
<TR>
<TH>SQL Field</TH>
<TH>BR Equivilant</TH>
<TH>Example</TH>
</TR>
<TR>
<TD>COUNTER</TD>
<TD>N</TD>
<TD>N 6</TD>
</TR>
<TR>
<TD>INTEGER</TD>
<TD>N</TD>
<TD>N 6</TD>
</TR>
<TR>
<TD>LONG INTEGER</TD>
<TD>N</TD>
<TD>N 12</TD>
</TR>
<TR>
<TD>SINGLE</TD>
<TD>S</TD>
<TD>S</TD>
</TR>
<TR>
<TD>DOUBLE</TD>
<TD>D</TD>
<TD>D</TD>
</TR>
<TR>
<TD>BINGINT</TD>
<TD>N/A</TD>
<TD>N 10</TD>
</TR>
<TR>
<TD>SMALLINT</TD>
<TD>BH</TD>
<TD>BH 2</TD>
</TR>
<TR>
<TD>FLOAT</TD>
<TD>L</TD>
<TD>N 6</TD>
</TR>
<TR>
<TD>DECIMAL</TD>
<TD>N or PD</TD>
<TD>N 12.2 or PD 6.2</TD>
</TR>
<TR>
<TD>DATETIME</TD>
<TD>N/A</TD>
<TD>Typically Stored as separate fields</TD>
</TR>
<TR>
<TD>DATE</TD>
<TD>C or D</TD>
<TD>C 8 or D</TD>
</TR>
<TR>
<TD>CHAR</TD>
<TD>C</TD>
<TD>C 30</TD>
</TR>
</TABLE>


<noinclude>
<noinclude>

Latest revision as of 16:27, 11 April 2023

See the format specifications below for more details on each.

See also Format specifications for a chart comparing their uses.

Format specifications tell Business Rules the form that a particular data field will be in. A format specification is required whenever data is input into or output from a program. It is also required with the full screen processing statements. Format specs are not required in the following situations: with unformatted internal files, with all display files, and when unformatted PRINT statements are used.

Not all format specifications are alike in their uses. Some can be used with internal and external files, but not with display files. Some can be used only with full screen formatting. And some format specifications behave differently depending on whether they are used for input or output.

Common SQL Fields and BR Equivilants

SQL Field BR Equivilant Example
COUNTER N N 6
INTEGER N N 6
LONG INTEGER N N 12
SINGLE S S
DOUBLE D D
BINGINT N/A N 10
SMALLINT BH BH 2
FLOAT L N 6
DECIMAL N or PD N 12.2 or PD 6.2
DATETIME N/A Typically Stored as separate fields
DATE C or D C 8 or D
CHAR C C 30

Pages in category "Format Specifications"

The following 33 pages are in this category, out of 33 total.