DSXchange

Hi All, I want to use DB2 Enterprise stage. For this, I have copied db2nodes.cfg file in DB2 installation directory. From google, I found out that there should be DSN entry in .odbc.ini file and uvodbc.ini. I have created the entries, but still I am getting fatal error when running the DS job. [b]ma...

Thanks for your inputs.

My target is a DB2 table.

Can you pls elaborate on how can i set the derived colums as row in sequential file.

Thanks,
Shalini

Hi All, My requirement is like this. The input is : Col1 Col2 Col3 Site1 Attr1 1 Site1 Attr2 2 Site1 Attr3 3 The output should be like: Col1 Attr1 Attr2 Attr3 Site1 1 2 3 The number of values for Col2 in input dataset might change. So it should be dynamic Your response would be highly appreciated. T...

Hi All, I have a simple DS job which is extracting data from a join of some tables and loading it into target table. It is truncate and load. Cognos report fires query on the target table. The table is refreshed every 1/2 an hour. At the time when table is getting truncated and loaded with fresh dat...

Thanks for your reply.

I have mailed you my id. Kindly send me the doc.

Thanks for your support.

Hi All, The DS project is migrated from one server to another. Here when I am trying to compile jobs with transformer, i am getting compilation error: Startup error on db2node0 connecting with conductor on CDELEISZOTZT02 with cookie 1253599628.681429.1d4038: unable to connect to port 10002 on conduc...

Thanks for the reply. But i'll have to check for each date whether its a weekday or not. For every chk, there will be a call to unix, then to sqlplus. I think it will not be a feasable option. Can you suggest me how to write routine for calculating working days. I am totally messed up what to do. Th...

Hi All, I have to write a routine to find the number of working days within a given period excluding the weekends and the holidays. My question is that can SQL queries be used in creating routines.If yes then what will be the syntax. If anybody can help with an example, it would be of great help. Th...

Thanks for your response.

But why DRS stage is not working and throwing error. It should be able to load to any database.

The Enterprise stage is not working. It is giving some error like:

db2nodes.cfg file is not present

Is this an installation error?

Hi All, I have to load data from oracle to db2.Its a direct load without any transformations except TimestampToDate(). Data is getting loaded using DB2 API stage. It is taking around 5:30 hrs to load approx 1 billion records. So i thought of using Dynamic RDBMS to speed up the process. But this stag...

Thanks for your replies but sorry to say that I am not having a problem with table name lengths in DB2 database. The problem is with datastage. Database is having long names and it is working fine there but DS is not accepting long names. Is there any DS parameter which can be changed to that effect?

Hi All, I am having very long table names in the database which i want to use in DB2 stage in DS. I want to know that is there any constraint on the length of the table name? If i give a long table name, i get the buffer overflow error. I tried fixing the error by increasing the buffer size, by empt...

The columns are nullable in seq file and transformer. In Seq file, in Formats tab, I have given the Null Field Value as '' but now I have changed it to null.

I have tried NullToValue. All the columns are varchar. It is not working. Earlier I was giving "Null Field Value" in input Sequential file as '' then the records with nulls were getting rejected. So I changed the "Null Field Value" to null.Now records are not getting rejected but...