# 6.7.15 SHOW STORAGE DIMENSION

Part of: [6 Language](6-language.md) › [6.7 Data Introspection Language (DIL)](6-7-data-introspection-language-dil.md)

### Syntax

**SHOW** **STORAGE** **DIMENSION** [_file_name_] _dataset_name_\
[_post_processing_option_]\
[_output_redirecting_option_]

### Description

Show (i.e. get) the storage dimensions of an HDF5 dataset named _dataset_name_.

### Parameter(s)

_file_name_ – optional string that specifies the name of the HDF5 file storing the dataset whose storage dimensions are to be obtained. If _file_name_ is specified, the file is opened on the fly, the storage dimensions of the dataset are obtained, and the file is subsequently closed. If not specified, the file currently in use is used instead.

_dataset_name_ – mandatory string that specifies the name of the HDF5 dataset whose storage dimensions are to be obtained.

_post_processing_option_ – optional option that transforms the result set according to the programmer’s needs, such as ordering or truncating (please refer to the section [PROCESSING](6-2-processing.md) for additional information).

_output_redirecting_option_ – optional option that specifies the cursor in use, an HDF5 object (i.e. dataset or attribute), a (text, binary, or Excel) file, or memory (i.e. user-defined variable) to write the result set into (please refer to the subsection [INTO](6-3-2-into.md) for additional information). If not specified, the cursor in use is populated with the result set instead (please refer to the chapter [CURSOR](4-cursor.md) for additional information).

### Return

The storage dimensions of an HDF5 dataset as an [HDFQL_BIGINT](5-1-constants.md#hdfql_bigint) or nothing (in case the dataset is not chunked – i.e. its storage type is not [HDFQL_CHUNKED](5-1-constants.md#hdfql_chunked)).

### Example(s)

```hdfql
# create an HDF5 dataset named "my_dataset0" of data type unsigned int 
CREATE DATASET my_dataset0 AS UNSIGNED INT

# show (i.e. get) storage dimensions of dataset "my_dataset0" (should return nothing) 
SHOW STORAGE DIMENSION my_dataset0

# create an HDF5 dataset named "my_dataset1" of data type int of two dimensions (size 5x7) 
CREATE DATASET my_dataset1 AS INT(5, 7)

# show (i.e. get) storage dimensions of dataset "my_dataset1" (should return nothing) 
SHOW STORAGE DIMENSION my_dataset1

# create an HDF5 dataset named "my_dataset2" of data type double of one dimension (size 8) 
CREATE CHUNKED DATASET my_dataset2 AS DOUBLE(8)

# show (i.e. get) storage dimensions of dataset "my_dataset2" (should return 8) 
SHOW STORAGE DIMENSION my_dataset2

# create an HDF5 dataset named "my_dataset3" of data type float of three dimensions (size 3x5x20)
CREATE CHUNKED(1, 2, 10) DATASET my_dataset3 AS FLOAT(3, 5, 20)

# show (i.e. get) storage dimensions of dataset "my_dataset3" (should return 1, 2, 10) 
SHOW STORAGE DIMENSION my_dataset3
```
