DSXchange

Thanks for your suggestions, at last its working fine for me, but only select statement is working delete statement is not working ,

sorry my datastage server installed in windows server , can you just tel me where to execute hash queries

My datastag mission installed in Windows server

i set the properties as Datasourcename as localuv and the tablename i specifie the hash file name , when i view the data i got this error message DSBrowser..UniVerse_0.DSLink2: DSD.BCIOpenR call to SQLExecDirect failed. Statement was:SELECT AcctIDHash.BANK_NUMBER, AcctIDHash.APPL_CODE, AcctIDHash.AC...

Yes i got that but i have an issue when i view the data i got a error message like Datastage/SQl : Syntax Error . unexpected symbol. can you help me to resolve this [/code]

Am really sorry i never worked with hashed file bu i have few knowledge and am not sure where to write SQL in Hashed stage

is it possible to read hash file data through UV stage in datastage canvas?

How can i use Universe or ODBC to delete records in hash fiels.

Hi , am working on Datstage 7.5 server jobs, my requirement is need to remove some records (let say storenum = 123) in a 30 hashfiles. i design a job like hash-->Trn-->Seq--->Trns--->Hash the first transformer have some filter condition to remove storenum and then write into a seq file and then writ...

Just simply do a sort test with some huge data on both server and parallel jobs , then you can easily idnetifie which works faster

There is no Direct mechanism to Migrate datastge code form server edition to Enterprise edition, need to use some intermediate tools like dotnet to migrate code and also not sure which will give hundred percent results just half part only it will do remaining things will be done manually

Any Suggestions to resolve this issue

Version 7.5.2

Hi .. when i opend some jobs in my project its saying "job is acessed by another user" , i tried to relese the locks through designer and administrator but its not useful for me still jobs in same state. is there any other way to release job, please note that datastge installed in windows ...

yes, thanks for updates