DSXchange

Here is a composite key ( combination of 3 keys).

Here is the requirement

Table 1 has it's own sequence number.
Table 2 need to get table 1 sequence number + it's own sequnce number (+ few other coulmns)
Table 3 need to get table 1 sequence number + table 2 seqence number + it's own sequnce number (+ few other coulmns)

Hope this is some what beter

There are no such rules, just selecting from two different sources and have to populate in the output there after we have to process...

Sorry about that. I might not able to explain in a proper way.

Thanks

In your case i need all 15 records. Yes it might be Cross Join. can you please explain how can i do that. Appreciate your help.

Thanks

I need to get both columns A and B are in the target. Column A is coming from one table,Column B is coming from from different table. Column A is coming by executing a lengthy sql. i have taken Column A in one source stage and Columb B is with one more source stage. eventually i need to populate Col...

I need to merge two different columns. those two columns are coming from two different tables. there are no such options like join or match or any keys to them. two columns are entirly different columns. have to take two stages for two columns of two source tables,need to get those two columns in ta...

Hi, First job is inserting 10 records in one table with increment of Temp_Id like 1,2,3.......10
The second job need to insert 20 more records in the same table with increment of Temp_Id by taking the last value of the first insert like 11,12,......30

Appreciate your help on this.Thanks

Sure I am using only CFF stage to read files. is there any second thought!

Thanks

Hi

I am getting this error Internal error: function 'utf_to_row()' failed when executing the job which was designed to read a dataset from Mainframe server to unix with ascii mode in 8.1. any help is appreciated. Thanks

Any sugession to start second line. I need to store two lines on one field. how can i close the first line and start second line. any function is there to use! Just i am hard coding the text in the transformer.Please advise.Thanks

which version of the datastege are you using?

Let me know if it is 8.1. Thanks

Hi Guys

I have noticed sql input reference in odbc stage.May i know what is the difference between user defined sql and sql reference input. i have noticed both of them in odbc stage. can anybody help me to know the difference. i am not able to find in documentation much.Thanks

Some how we uninstalled datastage8.1. now we are not able to install it back again. The error we found in websphere is starting and not able to stop by the information server while installing through information server.

can any body experience like this before! please advise. Thanks

we are unable to open any job and getting this error in 8.1. any advise regarding this Unable to open the Job Unable to load RID - c2e76d84.43058877.1e08d0b6.a31812a3-6e4f-4f40.9862.6e8de56e6259 com.ibm.datastage.exception.DSException: Unable to load RID - c2e76d84.43058877.1e08d0b6.a31812a3-6e4f-4f...

I need to get xml structure at the output. output is a DB.