DSXchange

Hello all, I do have a job where I am reading data from DB2 table, and writing into SQLServer table, configured in Write mode so I get better performance. While running, job aborts always after having processed same number of rows (around 2 million) with following error: Escribe_MSSQL,1: 42000 : [Mi...

ray.wurlod wrote:Both UNIX and Windows are happy with "/" as the pathname delimiter character - at least those versions of Windows that support DataStage engine.

great, thank you!

Hi all, I just realized that I may be facing an important issue with jobs I am currently designing. We do have a DEV environment, in a Windows platform. Our PROD environment will be running over a UNIX platform. I do have a parameter set where I store all my paths, for example: input --> d:\input ou...

chulett wrote:Have you involved your official support provider yet?

Not, as I expected to get solution here, I thought it should be easy to obtain, as View Data works perfectly

nobody can help?

chulett wrote:What version of 8.x? Are you current on your patches / fixpacks?

I do have Version 8.1.2, with last fix pack

Hello, I just got from DBA grants on system tables required to use DB2 Connector stage. I configured the stage, and the Test Connection button, as the "View Data" button are working fine. But when I run the job, I am getting the following error: main_program: Fatal Error: An error occurred...

ArndW wrote:yimwai - that's a simple and elegant solution

I agree, I guess I will do this!

I am sure this must be something already discussed, but I just cant find any posts in the forum. Is not possible to count rows and sum columns in the same Aggregator stage? Due to Aggregation Type property, you always have to choose between 'Calculation' (where there is no calculation for counting, ...

Just for the record, I built a server job using a Folder stage and I could perfectly read the XML file, but I want to do it with Parallel job

Thanks again!

Thanks for the help! Getting closer, but still unable to read file Now I got this error message: APT_CombinedOperatorController,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeExcepti...

Hello guys, I am very new to XML handling in Datastage, but I found some tutorials that showed how to do it and it did not seem that difficult As a start, I took a valid XML file (validated @ xmlvalidation.com). My job just consists on: - Sequential file stage - Input XML stage - Peek I defined Sequ...

Hello all, I have been looking around the forum, and other webs , and it seems that new range lookup in Lookup stage will not help me to solve my problem, but I still do a try here. I do have a table with a date, and a second one where I do have date intervals where I need to locate the key in the f...

battaliou wrote:Try changing your target metadata setting to varchar size 10 even though its a date

Thanks for your answer, but it did not work either

battaliou wrote:Try changing your target metadata setting to varchar size 10 even though its a date

Thanks for your answer, but it did not work either