on 07-04-2012 7:52 PM
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
hi,
you can use xsd:string, which will accepts all kind of datatype.
Regards
Amar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 |
smallint | xsd:short |
datetime | xsd:dateTime |
char | xsd:string |
varchar | xsd:string |
bit | xsd:boolean |
money | xsd:decimal |
Regards
Lucho
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.