Please enable JavaScript to view this site.

itgendoc001X

xMsg javascript has not been loaded.

Windows Data Model

Navigation: » No topics above this level «

csv_split_row: Windows Split Row as CSV

Contents Previous Home Next More

Catalog: FileSystem

Label: Split Row as CSV

This is a read-only table function. The Windows API may not support changing the data or the Invantive SQL driver for Windows does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Windows API.

Table Function Parameters

The following parameters can be used to control the behaviour of the table function csv_split_row. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

csv

string

 

Text in comma-separated format to split into individual rows.

max_entries_per_row

int32

 

Maximum number of individual rows to return from the text. Remaining content is included in the last row. Defaults to null (no limit).

 

Table Function Columns

The columns of the table function csv_split_row are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

text_content_1

string

 

 

 

text_content_10

string

 

 

 

text_content_11

string

 

 

 

text_content_12

string

 

 

 

text_content_13

string

 

 

 

text_content_14

string

 

 

 

text_content_15

string

 

 

 

text_content_16

string

 

 

 

text_content_17

string

 

 

 

text_content_18

string

 

 

 

text_content_19

string

 

 

 

text_content_2

string

 

 

 

text_content_20

string

 

 

 

text_content_21

string

 

 

 

text_content_22

string

 

 

 

text_content_23

string

 

 

 

text_content_24

string

 

 

 

text_content_25

string

 

 

 

text_content_26

string

 

 

 

text_content_27

string

 

 

 

text_content_28

string

 

 

 

text_content_29

string

 

 

 

text_content_3

string

 

 

 

text_content_30

string

 

 

 

text_content_31

string

 

 

 

text_content_32

string

 

 

 

text_content_33

string

 

 

 

text_content_34

string

 

 

 

text_content_35

string

 

 

 

text_content_36

string

 

 

 

text_content_37

string

 

 

 

text_content_38

string

 

 

 

text_content_39

string

 

 

 

text_content_4

string

 

 

 

text_content_40

string

 

 

 

text_content_41

string

 

 

 

text_content_42

string

 

 

 

text_content_43

string

 

 

 

text_content_44

string

 

 

 

text_content_45

string

 

 

 

text_content_46

string

 

 

 

text_content_47

string

 

 

 

text_content_48

string

 

 

 

text_content_49

string

 

 

 

text_content_5

string

 

 

 

text_content_50

string

 

 

 

text_content_6

string

 

 

 

text_content_7

string

 

 

 

text_content_8

string

 

 

 

text_content_9

string

 

 

 

 

17-05-2021 11:56 Version 20.1.419-BETA+3191