DSXchange

Are you able to connect to HIVE using JDBC connection?

You are enabling bulk mode in odbc driver definition EnableBulkLoad=1 This will enable bulk load utilities.... While using DRS Connector make sure you use ODBC drivers . Basically it will enable bulk load but based on the record count and array size it will push blocks of data to database. I tried i...

Hi, Here are few steps i followed to use bulk load in SQL server. Results looked awesome. Datastage: Use DRS connector stage and Write Mode = "insert rows". Array size 50000 Record Count - 200000 Odbc Drivers Definition: Enable Bulk load Driver=/...../IBM/InformationServer/Server/branded_o...

Give a try with these changes to parameters in teradata connector:
client character set -ASCII
Automap characterset encoding - No
NLS Map Name - ASCL_ISO8859-1(same NLS using at job level)
Maximum bytes per character -1

Thanks,
Vinay.

Found the solution. I figured out that the EBCDIC values using on mainframes is of IBM037. I used IBM037 as NLS in datastage FTP stage and Used UNICODE. Sequential file NLS setting is ISO8859-1. All charecters are FTP'ed as is.

Thanks.

ray.wurlod wrote:No-one has marked it as Resolved. ...

I used "if" in my question as it is not marked as "resolved" .

If this issue is resolved, could you please post what have you done to fix this?

Thanks,
Aditya.

Hi All, I am FTP'ing a file from mainframes to datastage(v8.5) server(linux) which have some special characters in it. '[' in mainframe file, when FTP'ed are translating to '->' . Have anyone faced any issue with FTP'ing special characters? In my mainframe file the ebcdic value for '[' is defined as...

DataStage error is: APT_CombinedOperatorController,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 1): Invalid document structure Xalan fatal error (publicId: , systemId: , line: 1, column: 1): Invalid document structure ...

Use XML Stage(XML Parser) instead of XML input..
XML Input stage works only if you have open and close tags in one record.(it assumes to process record by record)
If your XML data is allover in a file.. XML parser is the stage that can parse the data for you.

I changed array size and record count. It worked.

As Craig suggested use Char datatype and make sure your $APT_STRING_PADCHAR is set to space(0x20).

Hi All, I am looking for some suggestions on doing a bulk load to SQL Server. I did searched this forum and found few results , most of them say the same what i am implementing. I used DRS Connector stage(bulk insert) - tweaked record count multiple times (25 - 100000) ODBC connector stage - tweaked...

Yes Keith, Its straight Insert. We activated Bulk mode in DSN, but is there some thing to do in ODBC Connector/DRS Connector(bulk INsert).

I just switched one of my client's loads from the classic driver to native wire utilizing bulk load (DataStage 8.5.2, datadirect 6.0). Job went from 1 hour 15 minutes to 10 minutes. The target box is severely undersized, so bulk probably helps here more than it would in most cases Hi Williams, How ...