DSXchange

Hi , To understand the dump score, you should have the undestanding of the operators,processes ..you can say the advanced datastage concepts..! Generally it shows what are 1. What are the operateors datastage is using..and are there any additional operators are included .. 2.it shows keys used and t...

DSD_RUN is the process id of DS_JOBPID.. it means your job is not properly intialsed due to enviorment issue.. You mentioned the patch installed on your machine.however it seems that it is not working correctly.. Is there any other job on your production box which is working fine ? you can user the ...

In order to have better design of the job.. 1. There is join stage in the job...It is advised that is you are having huge unsorted data, u can use lookup stage.. ( of course ..here the other link where you are putting the join should have less rows which can fit in your physical memory or performanc...

what i will suggest you to write the unix scripts which can do all the operations what you are doing..! in that one session u can declare the temp table and all the operations that you want to perform and then u can close the session so that the table will not be available.. the error which is there...

i dont think..people are storing the backups for the .ds file..as they are only the intermediate files..! and ys..unix commands can be used to restore the deleted file.. I am not sure the what exact command is..! however it can be used to restore .ds file and then it can be deleted using ds manageme...

I read somewhere regarding the 'AC QUOTE ' which sends command using the FTP..dont have luck on any documentation! however word of caution :- ftp sessions are not to execute scripts ! Ftp is exactly that - (File Transfer Protocol). RSH (remote shell) may be what you are looking for. hope this helps ...

Tej.. are you trying to say that you want ot pass the values from one sequencer to other sequencer.. if the value are static one..then you can create a file which can be read by the both of the jobs and then these values can be used.. if the second sequncer is using the values that are depenedent on...

Some of the options u can think of..! 1. If you can FTP to the server, you are knowing the server ! :) why dont u logon on that server instead of the server and run the unix script from the server only..! this is just one of the option i am giving ..! :) 2. There is routine 'DSWaitForFile' which sus...

then there is one good option you are having.. delete the sequnce and re-create the new one and attach the job again ! :) anyways ..if you are creating the job again and it is working fine..it seems to be weird error then..! once job is failed using the sequence, have you tried running it independet...

Hi Colin.. whether you are having file which contain some data with the structure you had defined.. I had a file which is having txt sequential data struture and some data in it i had imported it structure... There is option while importing the structure, comma seprated... if you select that option....

i tried to delete from /Path1/datasetfiles/ even with the command and dataset Management in director and even dataset management in designer (ver 8.0) .it is giving error because the original file is not there which is deleted manually in unix command. If the .ds file is deleted, there is no way to...