Category:Format Specifications - Revision history

GomezL at 16:27, 11 April 2023

2023-04-11T16:27:00Z

← Older revision		Revision as of 16:27, 11 April 2023
Line 7:		Line 7:
	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.		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		== '''Common SQL Fields and BR Equivilants''' ==


	<TABLE BORDER="1" CELLSPACING="1" CELLPADDING="3" WIDTH="100%" ALIGN="Center">		<TABLE BORDER="1" CELLSPACING="1" CELLPADDING="3" WIDTH="100%" ALIGN="Center">

2023-04-11T16:26:21Z

← Older revision		Revision as of 16:26, 11 April 2023
Line 9:		Line 9:
	Common SQL Fields and BR Equivilants		Common SQL Fields and BR Equivilants

	<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="3" WIDTH="100%" ALIGN="Center">		<TABLE BORDER="1" CELLSPACING="1" CELLPADDING="3" WIDTH="100%" ALIGN="Center">

2023-04-11T14:23:26Z

← Older revision		Revision as of 14:23, 11 April 2023
Line 57:		Line 57:
	<TD>SMALLINT</TD>		<TD>SMALLINT</TD>
	<TD>BH</TD>		<TD>BH</TD>
	<TD>VH 2</TD>		<TD>BH 2</TD>
	</TR>		</TR>

Line 69:		Line 69:
	<TR>		<TR>
	<TD>DECIMAL</TD>		<TD>DECIMAL</TD>
	<TD>N</TD>		<TD>N or PD</TD>
	<TD>N 12.2</TD>		<TD>N 12.2 or PD 6.2</TD>
	</TR>		</TR>

Line 79:		Line 79:
	<TD>Typically Stored as separate fields</TD>		<TD>Typically Stored as separate fields</TD>
	</TR>		</TR>



	<TR>		<TR>
Line 87:		Line 85:
	<TD>C 8 or D</TD>		<TD>C 8 or D</TD>
	</TR>		</TR>

			<TR>
			<TD>CHAR</TD>
			<TD>C</TD>
			<TD>C 30</TD>
			</TR>



	</TABLE>		</TABLE>

2023-04-11T14:22:16Z

← Older revision		Revision as of 14:22, 11 April 2023
Line 6:		Line 6:

	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.		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="0" 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>VH 2</TD>
			</TR>

			<TR>
			<TD>FLOAT</TD>
			<TD>L</TD>
			<TD>N 6</TD>
			</TR>


			<TR>
			<TD>DECIMAL</TD>
			<TD>N</TD>
			<TD>N 12.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>

			</TABLE>

	<noinclude>		<noinclude>

2013-07-22T17:47:52Z

← Older revision		Revision as of 17:47, 22 July 2013
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.

	<noinclude>		<noinclude>

2013-07-22T17:44:48Z

← Older revision		Revision as of 17:44, 22 July 2013
Line 5:		Line 5:
	<noinclude>		<noinclude>
	[[Category:Field Specifications]]		[[Category:Field Specifications]]
			[[Category:All Parameters]]
	</noinclude>		</noinclude>

2013-02-21T15:16:49Z

← Older revision		Revision as of 15:16, 21 February 2013
Line 2:		Line 2:

	See also [[Format specifications]] for a chart comparing their uses.		See also [[Format specifications]] for a chart comparing their uses.

			<noinclude>
			[[Category:Field Specifications]]
			</noinclude>

2013-02-21T03:08:39Z

← Older revision		Revision as of 03:08, 21 February 2013
Line 1:		Line 1:
	See the following format specifications for more details:		See the following format specifications for more details on each:

			See also [[Format specifications]] for a chart comparing their uses.

2013-02-20T23:43:05Z

Created page with "See the following format specifications for more details:"

New page

See the following format specifications for more details: