DSXchange

Smith,Vincent

Thanks for your replies.

But i dont see Pivot Stage in my Palette/processing category in desinger?
Does that come automatically installed with DS or do i need to install any library file ?

Thanks

Hi, Please guide me to handle the following situation.. I have a table with the following structure. Src Table : X Columns : key1,key2,User_type1,UserQy1,User_type2,User_Qy2 My requirement is to split this to Target table: Y key1,key2,seqno,user_type1,user_qy1 key1,key2,seqno,user_type2,user_qy2 Her...

It Worked. Thanks Kim.

Hi i am new to Ascential and these Routines. I am trying to implement DSjobReport job that i downloaded from Ascential Developernet site. I got an error saying dsjob not found. I tried this couple of ways. First ,I selected ExecSH in before subroutine and used this follwing command dsjob -report pro...

That helps.

Thanks Craig

Craig, i got couple of questions.please correct me if i am getting anything wrong here. We got PURGE options in DSParam file at project level and job level. And using the routine you mentioned we are setting these purge options at job level. how different are they? Suppose if have purge interval set...

Thanks for you reply Craig,
Does that work for DS 7.1?

Craig, I am also having an issue with these log files.When we created our jobs to test we didn't had AutoPurge option enabled.so log files are building. Today we got FileSpace issue on out test box.i could not start our dspcr. We have one project running with these same options on Production and i a...

Hi, When i am trying to import tables/run a job i am getting this error.. DSR.MetaGeta(GET.TABLES)(SQLConnect('DBName','dbuser')): BCI Error: SQLSTATE=S1000,CODE=80,[DataStage][SQL Client][ODBC] Somebody please explain me what this error means. I was able to import tables/run these same jobs till ye...