DSXchange

I think it is possible... But how I can do it? How I can to fill parameter from dataset? Can you say about that step by step?

Hi Ok. So... I have very big table and I want to copy records from table which correspond my parameters. I want to put my parameters in SQL request (select a, b, c from d where a = #param#) for reducing number extracted records and reducing time of job. But parameters is not constant value. It shoul...

Hi

Yes, I mean that I have a job parameter (job properties->Parameters...). And I have dataset with one colunm. I have it from db2_udb_api for example. And I want to add the values to the list from my dataset. Is it possible? Please tell me as.

Hi All

I have job parameter as list. How I can put dataset with onest colum to my job_parameter?

Thenx.

Hi All I have very simple job: DB2_UDB_API-Copy-DB2_UDB_API. And onest field in DB2 with date type. After copy I checked target table and.... O my god.. All dates copied but it less dates on source table with a day! I checked came stage in server job and all ok. Hmm Why my parallel job is wrong? The...

Hi 2kumar_s it`s statistics shows and rows count after transfer data. Hmmm I think that is duplicates... But why it`s extacted and copied to target table? I`m sure... That happen if Source DB2_UDB_API and copy stage have "parallel" in execution mode. And all be ok if I set sequentioal for ...

Thenk you for replay. But I need use datastage for that task!

Thank you

But can I don`t use HashFile to store my date?

So.. I created parameter with list dates. This is dates which don`t exist in secont table. I receive this dates from my stage. Can I copy data from dataset to parameter directly? And then use it in LoopActivity and as parameter to other job.

Hi I have 294886 rows for PRCSS_WK_ENDING_DT 10.11.2006. But If I set parallel then datastage extract 1474430 rows. Job consist of only 3 stages (DB2_UDB_API for extract, Copy stage with parallel by default and DB2_UDB_API with parralel for load). This is SQL request to DB2: SELECT UTILDM_EMP_GEO_SP...

Hi All

So... If I set Execution mode in "Default (Sequental)" DB2_UDB_API correct extract the datas. But if I set Execution mode in "Parrallel" Stage etract more data then have in table. But extracting is faster..

Why that is possible? What I do incorrect?

Hi All I found solution :roll: I dont set any environment variables. In this case We need define next parameters to connect: 1. Use Defualt Database = False 1.2. Database = <Your database> 2. Use default server = False 2.1. Server = <DB2 instance name for the table, overriding the setting of the DB2...

Yes. I type password in parameter. And I sure that password is correct.

Sorry... haw I can hardcore the values?

Hi All I try to use DB2_UDB_Enterprice. And can`t connect to my database. I give client instancw name, database name, user name, password and receive error:##E TNDB 000000 13:54:10(000) <DB2_UDB_Enterprise_1,0> Error Idx = 1; >DB2 Driver Embedded SQL message: SQL30082N Attempt to establish connectio...

Thank you. But DB2 can`t join tables from different databases as I know. So. Can I use variables or parameters in Where clauses of the SQL request?

Hello, All I have 2 identical tables stored in different db2 database servers. I should be replicate data from first table to another. I need copy records only added after last replication. So.. In second table I have field with date and I need copy records from first table where date is greater. In...