DSXchange

Does any1 knows how 2 discover whether a particular sequential or hash file is use in which jobs in datastage? I only know that can trace it from Table Definition Usage Analysis in Manager. Any1 know any other way?

I tried to loader some data(numeric/decimal) into rebrick table using bulk loader and found some unusual scenario here. what I did:: Input data Output(numeric 13, scale 2) -850.00 -8.50(wrong) 50500.00 50500.00(right) -470.22 -470.22(right) from redbick table, the first numeric data give the wrong r...

I just created a new project(proj2) in another directory. Now I need to create/view tables in that proj2 localuv from my working project, says proj1. Is that possible? Anyway to do that?

Tq all for replying but I had finally found the solution. :D Now I enter onli 1 table name into the "Table names:" field of the DB2 plug-in stage, it can run successfully.So whenever I need to join 2 or more table I would need to use user defined SQL as the generated SQL cant have more tha...

I would like to know what are the steps in creating a new universe account that store its tables in my chosen directory, instaed of the default datastage projects directory. Also would I need to setup any user/password?

I have a DB2 plugin stage that select from a table which join to a view. Theres no error when validate. But it get aborted after extracting 1500 records. Here's the error: JobGetClientNum01..Transformer_16: SQLExtendedFetch: Error retrieving results from server. JobGetClientNum01..Transformer_16: [I...

Tq for all ur replys.... :D

I got some jobs that show in the Designer and Manager but not in Director. I tried to delete it but it prompt

"Cannot open executable job file RT_CONFIG192"

Anyone knows?