Reading SQL Server XML data type
Posted: Wed Jul 29, 2015 9:16 pm
On a DataStage Windows platform, a team memeber recently developed two jobs
1) Extracts xml files and via XML Hierarchical Data stage load into into a SQL server table where one of the target colums is defined as datatype XML in SQL Server (write from Datastage as SQL type LongNVarChar)
2) Read data from the SQl Server table, xml columns is read as LongNVarChar and witten to a SQL server table as LongNVarChar
Job was running without issue on the windows platform
The person has now migrated the two job to a new Linux DataStage installation
when the second job (Read and writes to SQL server via odbc) is run in linux environment we get the following warning
terminate called after throwing an instance of 'APT_BadAlloc'
If I remove the column associated with the data type XML - the job run without issues
Has anyone had this issue in a Linux/SQL Server installation and resolved the problem
Thanking you all in advance
1) Extracts xml files and via XML Hierarchical Data stage load into into a SQL server table where one of the target colums is defined as datatype XML in SQL Server (write from Datastage as SQL type LongNVarChar)
2) Read data from the SQl Server table, xml columns is read as LongNVarChar and witten to a SQL server table as LongNVarChar
Job was running without issue on the windows platform
The person has now migrated the two job to a new Linux DataStage installation
when the second job (Read and writes to SQL server via odbc) is run in linux environment we get the following warning
terminate called after throwing an instance of 'APT_BadAlloc'
If I remove the column associated with the data type XML - the job run without issues
Has anyone had this issue in a Linux/SQL Server installation and resolved the problem
Thanking you all in advance