DSXchange

May be you can think in another way.

1) left join the source(LEFT) and reference with keys store and sku
2) filter out those records with soure_date < reference_date
3) get the max(reference_date)
4) join with reference data to get the price

list the info of dataset:
orchadmin ll xxx.ds

show the data in dataset:
orchadmin dump xxx.ds

Thank you for all your reply.
I have write a dos batch file to export job by job and concat the file into one.

I have another problem, I can export one job now but how can I export just one table def? I have search around and find no place talking about export just one table def. Please help.

chulett wrote:Seems odd that you 'must include' an optional command line switch like /exec but it's been a long time since I've played with that. What happens when you leave it off?

If I remove the /exec then I cannot use /append. The second command would replace the previous dsx file.

Dear all, I want to export serveral datastage jobs in one file with following commands in windows. "C:\Program Files\Ascential\DataStage7.5.1\dsexport" /h=host /u=user /p=password /exec /append PROJECT /job=JobName1 export.dsx "C:\Program Files\Ascential\DataStage7.5.1\dsexport" ...