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
Search found 24 matches
- Tue Jan 25, 2005 8:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple rows from a single row
- Replies: 8
- Views: 4674
- Mon Jan 24, 2005 4:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple rows from a single row
- Replies: 8
- Views: 4674
Multiple rows from a single row
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...
- Tue Jan 18, 2005 4:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSjobReport error
- Replies: 6
- Views: 4959
- Tue Jan 18, 2005 3:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSjobReport error
- Replies: 6
- Views: 4959
DSjobReport error
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...
- Thu Dec 16, 2004 1:09 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cleaning out Director log entries
- Replies: 16
- Views: 7082
- Thu Dec 16, 2004 12:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cleaning out Director log entries
- Replies: 16
- Views: 7082
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...
- Thu Dec 16, 2004 11:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cleaning out Director log entries
- Replies: 16
- Views: 7082
- Thu Dec 16, 2004 10:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cleaning out Director log entries
- Replies: 16
- Views: 7082
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...
- Fri Dec 10, 2004 4:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC issue
- Replies: 1
- Views: 729
ODBC issue
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...