DSXchange

Thanks for your feedback Eric. We are actually using odbc stage connecting to a non-dpf db2 database. IBM suggests us to use odbc connector to replace odbc stage. This is a reasonable solution. This job is a simple one so it is easy to change. However, the job is a multiinstance job and is used to l...

Thanks for suggestion Craig.

I lodged a client request for IBM to investigate. Will publish the result if any.

Hi there I recently migrated a job from v7.5 to v8.7 on AIX system. The job simply loads a file to a DB2 table through a parallel ODBC stage. It runs ok for some tables and fails for other tables. Usually if a file has more than 2000 lines, after loading 2000 lines, the job fails and gives the error...

We did not install Analyzer or Business Director.
Thanks for letting me know that Ray.
Cheers

Hi
We just upgraded to datastage 8.7. The document mentioned that "ibm infosphere information server console" can be opened from Start - All Programs - IBM Inforsphere Information Server. But it is not there in my case.
Is my client installation not complete? My version is 8.7 fix pack 2.

Thanks for Ray's comments.
I could not solve these issues and have not got more comments, so I am close this line as workaround.
Cheers

Hi When I use AT.exe to display scheduled jobs, it displayed all. But, it has tow problems: 1. if a job is scheduled to run on a date of each month, eg, the 3rd of each month, it only display "Each " (ie blank after Each), instead of displaying "Each 3". Our server is windows 200...

Thank you all guys.
I found that by padding the file to say length of 255, a simple sequencial stage will be able to process the result file as fixed length, either as a dos or unix style in my case.

I could use a job to reorganize the lines in the file but I did not try yet because I thought it might be a complex one. I think there could be two difficulties. One is that a line in the file may have a few job entries and the last entry in the line usually is not completed, ie, info for a job entr...

Hello
As we have many jobs scheduled and the schedule changes from time to time, I want to fetch information from the scheduler and process it. When I use AT > result.txt, I have unformated lines in the file.
Any idea how to get a file with 1 line for each scheduled job?

iDomz
Thanks a lot for your reply. I tend to believe the DS engine should free the memory from the function. Your expirement enhances my believing.
Cheers

Hi I begin to write parallel routine/functions with my rust c++ knowledge. By looking through this forum, I am still not sure if DS engine is handling memory deallocation. For example, if my function is returning a char*, and the DS engine does not free the memory for that pointer, how can I free fr...

Hi To update table set col1 = variable1 where col1 < variable1, I get the value1 in a transform stage and out put to a DB2 stage. In db2 stage the sql looks like: update table_name set col1 = ? where a < ?; The problem is in transform stage, I can only map value1 to col1 once, ie, only one ? has bee...

We delete files in &PH& folder regularly when there are no jobs running. Dose anybody have idea how to automate this process under windows environment? How to prevent a job to start running while deleting the files in the folder?
Thanks in advance.

Hi We use datastage to load data from DB2 to Oracle incrementally. From time to time, we compare db2 tables with their oracle equevalence to make sure they are identical. My approach is convert a db2 table to a flat file, convert its equivalant oracle table to another falt file, then use some compar...