DSXchange

No, the delimeter is comma. If I use the normal code page, like ISO-8859, utf-8, windows-1252, then the same job will run without error, but the character appears like I mentioned, not as I'd like to have.

The DB2 colleague told me that the target db uses the IBM500 codepage. but If I use this in the job property, the job won't read any lines from the text file, because it can not find the delimeter in the file. So I can not use this code page.

The change of the variable APT_PHYSICAL_DATASET_BLOCK_SIZE in addition to the change of the APT_DEFAULT_TRANSPORT_BLOCK_SIZE has helped me to solve the problem, thanks a lot

actually I solved the problem. I setted the auto commit in ODBC property to on, then it works

Hi, All we upgraded our operation server SUSE Linux from version 10 to 11. After that our parallel jobs which use ODBC connections to write to DB2 tables get the message ODBC function "SQLConnect" reported: SQLSTATE = HYT00: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire ...

Hi, I got a problem writing data via ODBC connector to DB2 tables. I just used a Datasets and write the data to DB2 using ODBC, it aborted with the error Abnormal end unit of work condition occurred. If I limited the row count, the job did run successfully. But if I want to write all rows it failed ...

Hi,Chulett,

many thanks for your quick anwser.
I have found out by myself that the XPath expression was not there as it should be, ( the job was copied by someone else, I did not see that) as you have said. I added this and the xml was now created successfully.

Hi, I used a parallel job to read an input file and create a xml output file, nothing special, the job runs without error, but the output xml file is not created. Has somebody any idea why it is not created though the job ends without any error or warnings ? Now I found out why the file was not crea...

Hi, Roland, I think you misunderstood me. I'd like to know if the datasets is partitioned by which key, not how many nodes it uses. For example, if I partitioned the datasets by type/model, where can I identify that this ds is partitioned by type/model except in the job itself. If the job always use...

Hi, all

I'd like to know if there is a way to find out which partition a datasets is using ?

Hi, I read an article about performance comparison between DB2Connector and ODBC : http://www.dsxchange.com/viewtopic.php?t=128725&highlight=DB2+Connector+Stage It says DB2Connector has the best performance. We're using Datastage 8.5. I just tested both connectors, DB2Connector and ODBC to extra...

I have had the same problem as you and searched the forum for a solution but cannot find anything which did work. I made several tests by myself and have found out a solution which will work for keeping the zeros after decimal as well as the original digits after the decimal : Suppose we have 2 valu...

Hi, I have the same problem as we upgraded our 7.5 version to 8.0. We used the same user defined environment variables in 8.1. But one of this parameters didn't work, I got the message no such file, could not open the file like yours. If I hardcode the path for the file, it works fine. Then I delete...

Hi, I have the same problem as we upgraded our 7.5 version to 8.0. We used the same user defined environment variables in 8.1. But one of this parameters didn't work, I got the message no such file, could not open the file like yours. If I hardcode the path for the file, it works fine. Then I delete...