DSXchange

kcbland/chulett
It worked . Thank you

thanks
nivas

Using ExecDOS before job routine concatenate all the files using DOS command , then with in the job use the sequential stage to read the concatenated file.

Respected Everybody

I need to create and use Account Name for hashed file. Please suggest on it.

thanks
nivas

thank you very much.

The number of distinct values will dynamically change.So the number of files to be created dynamically change. Even the distinct values itslef are not same. They change dynamically. So I can not use them in constraints. As chulett said I need to do that through routine. I am looking for code help to...

The number of distinct values will dynamically change.So the number of files to be created dynamically change. Even the distinct values itslef are not same. They change dynamically. So I can not use them in constraints. As chulett said I need to do that through routine. I am looking for code help to...

I have a table with columns for example COL1, COL2, COL3 and COL4. In that COL1 have for example 10,20,30 and 40 distinct values. Now Ineed to create four files with names file_10, file_20, file_30 and file_40. All records which has COL1=10 should go to file_10 All records which has COL1=20 should g...

Hi

Could you please provide some more help in code for the routine.
Once the file is opened ,
commands for insert the records into the file or how do we insert records into the file and how the loop will go

thanks
nivas

Hi Chullet

We are still using 5.X version.
Thanks for the reply. Could you please through some sample code for the basic routine or some more hints. I am looking for some help in the routine.

thanks
nivas

The sqlserver 2005 table has few columns. In it one column say for example has 10 distinct values. Then I need to create 10 files. The records from the Table should go to these 10 files based on the distinct column value. If the distinct values are 20 then I should create 20 files.

thanks
nivas

Hi

I am in need of generating sequential files based on the distinct value of one source table column which is in sqlserver. Please advice me .
thanks allot in advance.

thanks
nivas

Hi
Can anybody suggest how to set up de deadlock in the system.

thanks
Nivas

[quote="Then I set up de deadlock in my system and the error message of "cannot open RT_xyz file" disappear. (time=600)[/quote]

The problem got solved. The issue is there is no enough space in the unix box and also i rebuild the repository indexes using DS.TOOLS and now it's working fine. Thanks for all your help. Hi Could any body please tell at which node we should have sufficient memory and what is the minimum %of memory...

Thanks everbody. Actually we did run the jobs with version 7.5 without recompiling them. After we did recompile the jobs with version 7.5 we are getting the status code.

thanks
Nivas

Hi Kris_r

Could you tell me what is your target database?
thanks
Nivas