cancel
Showing results for 
Search instead for 
Did you mean: 

PI Data types for DataType fields in SQL DB- Proxy to JDBC scenario

Former Member
0 Kudos

How do we define data types in PI target data type structure for below data type fields in SQL DB.

numeric(14, 2)

decimal(18, 4)

smallint

datetime

char

varchar

bit

money

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

hi,

you can use xsd:string, which will accepts all kind of datatype.

Regards

Amar    

Former Member
0 Kudos

Hi.

According the DMBS you need to check on documentacion the equivalence with XML DataType.

Bellow the list equivalence with MSSSQL.

SQL XML
numeric(14, 2)xsd:decimal
decimal(18, 4)xsd:decimal
smallintxsd:short
datetimexsd:dateTime
charxsd:string
varcharxsd:string
bitxsd:boolean
moneyxsd:decimal

Regards

Lucho