DSXchange

Thank you all for your responses! I am trying a different approach, to test a few things out. I have been successful in loading the contents of a CSV file through a Transformer stage to an ODBC Connector target. All columns insert the data as expected, except for the date information that is within ...

Thank you all for your responses. I found the location where to change the array size ... it is in the ODBC connector within the DS job. I have a lookup table and a target table within my DS job, so each will need to be updated with the array size of 1. I am now able to insert new records, but when ...

Hi, Unfortunately, I do not have access to the server to check that specific ODBC connection. I have checked the ODBC connection that I configured on my PC and I do not see any setting for "array size" to set it to "1". Would this setting only be on the server's ODBC connection? ...

Here are the error messages that I am seeing after attempting to run the DS job: source,0: The array size must be set to 1 when reading LOBs (CC_OdbcDBRecordDataSetProducer::dbsAllocateBindBuffers, file CC_OdbcDBRecordDataSetProducer.cpp, line 587) source,0: The runLocally() of the operator failed. ...

Hello, I am somewhat new to DataStage and am running into an issue. Unfortunately, I am not able to find any helpful information regarding this issue, and I wanted to post here to see what kind of help I can get. I have a job that is reading from a SQL Server table. Unfortunately, some of the dataty...