# I-DUMP / S-DUMP

Updated: 11/30/2021, 7:00:45 PM
Created: 11/30/2021, 7:00:45 PM
Last Updated By: Jake Tuttle
Read Time: 1 minute(s)

Tags: value mark jql attribute

# Description

The command displays the entire contents of items in a file, including the system delimiters. It takes the general form:

I-DUMP file-specifier {record-list} {selection-criteria} {sort-criteria} {USING file-specifier}  {(options}
1

# Note

The S-DUMP command can be used to produce sorted output.

System delimiters are denoted as follows:

Attribute mark ^
Value mark ]
Sub value mark \

# Example 1

I-DUMP EMPLOYEE WITH EMP.JOB = "SALESREP"
1

The following output is generated:

8499^HARRIS^TAMMY^SALESREP^8698^5400^250000^30000^90030^^^^^]11588^
8654^MCBRIDE^KEVIN^SALESREP^8698^5620^215000^140000^90030^^^^^]11639\^
8521^TAYLOR^MAVIS^SALESREP^8698^5402^219000^50000^90030^^^^^3]11500^
1
2
3

# Example 2

S-DUMP EMPLOYEE BY EMP.HIREDATE WITH EMP.TITLE "SALESREP"
1

The following output is generated:

8499^HARRIS^TAMMY^SALESREP^8698^5400^250000^30000^90030^^^^^]11588^
8521^TAYLOR^MAVIS^SALESREP^8698^5402^219000^50000^90030^^^^^3]11500^
8654^MCBRIDE^KEVIN^SALESREP^8698^5620^215000^140000^90030^^^^^]11639\^  
1
2
3

Back to jQL

Back to jQL Cross Reference