DSXchange

I have created some jobs in my my folder under jobs category. currently my jobs can be openend by other developers and they can copy my job to their folders. I want that noone can open my job. How do I make my jobs password protected so that it cannot be opened by other developers, not even read onl...

Can anyone tell, for what purpose the folder /dev/fstst/ is being used? Is it used for some temporary loading by lookup stage?

Could you explain this in more detail? What I understood is, I have to create one job wherein I have to write a query something like select max(key) from table1, then I will put this into one flat file. In the second job, what should I do. How can I fetch this value into some job parameter and use t...

I have one job which is loading 50000 records in my target table and I am using surrogate key generator stage in the job to generate values for my surrogate key. In my second job again I have to load some 10,000 records into the same target table, but now I have to look what is the max(surr_key) in ...

I have a scenario wherein I have some 2000 records in target table. There is one source table in which only one field is there (say 10 random values). There is no joiing condiiton between these tables. I have to poplulate one of my taget columns with this source field and have to run the job as many...

But I don't want to hard code the limits, but have to pick them from source table. How can I achieve this by using column/row generator?

I have a scenario wherein I have to generate date values within some limit. I have to fetch min(cal_date) and max(cal_date) from my source table and generate date values within these values in my target table. How can I pick these dates and generate the date values from min(cal_date) and max(cal_dat...

Yes those were 2 separate values(just exmaple values). Used trim function, which is working just perfectly. Thanks a ton.....

Thanks, its working

I have a varchar field, which contains values like 00234,00980,.....

I have to remove all the 0's from the left of this value. my result should be 234,980,......
which function should I use in Datastage to achieve this?

I have 2 tables to join, in which the column names are not same and the condition is not simple. I have a condition like this:
where table1.a>table2.b and table1.a<=table2.c(in between condition). How can I do this in parallel job.

Could you please explain this in detail, as how to change the shared library from 64 bit to 32 bit?

Thanks a ton. Its working..... :D

I have to generate date values from 1975-01-01 to 2007-31-12. How can I do this using row generator. Where can I specify initial value and last value in row generator?

I am calling procedure using syntax---db2 "call test_proc()". But its giving following error: TEST_PROC..JobControl (@Execute_Command_0): Executed: db2 "call svsods.test_proc()" Reply=255 Output from command ====> exec(): 0509-036 Cannot load program db2 because of the following ...