ERPRef.com

20 COLUMNS | 4 INDICIES 910 | H98 | F986110 Job Control Status Master

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
910	F986110	JC	20	4	Job Control Status Master	Master Files	H98: Internet	System Tables

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

20 COLUMNS | TOP 910 | H98 | F986110 Job Control Status Master

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

4 INDICIES | TOP 910 | H98 | F986110 Job Control Status Master

1: Job Control Master Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	EXEHOST	Execution Host Name	Ascending
2	JOBNBR	Server Job Number	Ascending

2: Job Control Status_Type

Element	Alias	Description	Sequence
1	JOBQUE	Job Queue	Ascending
2	JOBSTS	Job Status	Ascending
3	FUNO	Object Type	Ascending
4	JOBPTY	Job Priority	Ascending

3: Job Control Status_Priority

Element	Alias	Description	Sequence
1	JOBQUE	Job Queue	Ascending
2	JOBSTS	Job Status	Ascending
3	JOBPTY	Job Priority	Ascending

4: Job Conrol Status Priority+A

Element	Alias	Description	Sequence
1	EXEHOST	Execution Host Name	Ascending
2	USER	User ID	Ascending
3	JOBQUE	Job Queue	Ascending
4	JOBPTY	Job Priority	Ascending
5	JOBSTS	Job Status	Ascending