Search found 63 matches
- Tue Jan 13, 2015 9:48 pm
- Forum: General
- Topic: Getting the list of IS users along with last logged-in time
- Replies: 11
- Views: 6656
Hi, from this topic its seems like there is no way we can accurately identify active users, but do we have anyway just to list all users, their role and which project they have access too. We do audit of all users, their roles and access to project. Currently we are retriving the userlist manually b...
- Sat Jul 04, 2009 9:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NULL replace with junk and empty string
- Replies: 3
- Views: 2994
- Tue May 05, 2009 12:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Environment Variable passed to Shared Container
- Replies: 2
- Views: 1982
- Mon May 04, 2009 11:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Environment Variable passed to Shared Container
- Replies: 2
- Views: 1982
Environment Variable passed to Shared Container
I am trying to call a Shared container from a job. The job design is File - > SharedContainer - > File the design of the container is -> Transformer -> File The job has a Env Param $FilePath = $PROJDEF. The shared contaiiner also has a parmater: Path = #$FilePath#/subdir. In the shared container the...
- Tue Apr 07, 2009 10:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Not progressing with Shared Containers
- Replies: 3
- Views: 2166
- Tue Apr 07, 2009 10:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Not progressing with Shared Containers
- Replies: 3
- Views: 2166
Job Not progressing with Shared Containers
I am trying to run a job but do not process any rows if shared container is present but if i remove the container its starts working, the container is working fine in other jobs. Details of the job Dataset | File -> Lookup - > sortstage - > dataset |(reject link) Transformer - > (shared conatiner) W...
- Fri Mar 20, 2009 12:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transaction in the After-SQL of Teradata MLOAD stage
- Replies: 0
- Views: 1025
Transaction in the After-SQL of Teradata MLOAD stage
Hi, I am trying to exceute two SQL statments in the after SQL of MLOAD stage. First SQL is insert into a table and the second SQL is update of a saparate table. I want to excute both statements in transaction. But BEGIN TRANSACTION, END TRANSACTION , BT and ET doesn't work the report file say unreco...
- Sat Feb 28, 2009 7:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Teradata Fastload issue
- Replies: 5
- Views: 3019
Thanks guys for the solution but the problem is a bit different, its a migration project, i have changed the code to Teradata for more then 2000 jobs. now when i am testing the data i face this problem, i thought if there is some global setting that i can do which will fix the problem else i have to...
- Fri Feb 27, 2009 11:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Teradata Fastload issue
- Replies: 5
- Views: 3019
Teradata Fastload issue
I am trying to extract data from a teradata table with the defination CREATE SET TABLE decimalerror ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( Col1 DECIMAL(5,2)) PRIMARY INDEX ( Col1 ); The following data is then inserted 50.00 124.00 12.00 167.09 When i try to retrieve...
- Sat Feb 21, 2009 3:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom 7524
- Replies: 4
- Views: 2873
- Fri Jan 09, 2009 12:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Table name to After SQL file in Teradata Connector
- Replies: 0
- Views: 1124
Passing Table name to After SQL file in Teradata Connector
I am calling SQL file from After SQL of Teradata Connector stage, one of the table name is dynamic, is it possible to pass table name to the file from the connector stage
- Sat Dec 13, 2008 1:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hash partition not working in Join stage
- Replies: 5
- Views: 3353
- Fri Nov 07, 2008 4:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find PX jobs in sequences
- Replies: 1
- Views: 1292
Find PX jobs in sequences
I Have names of PX jobs about 400, and i want to find out the names of sequences that call these jobs, My question is
1)Is it possible to find out this information through some Unix script?
2) Is it possible use the advance search facilty of Datastage from command line?
1)Is it possible to find out this information through some Unix script?
2) Is it possible use the advance search facilty of Datastage from command line?
- Mon Nov 03, 2008 2:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding New Job Parameter from PX routine
- Replies: 9
- Views: 4751
- Mon Nov 03, 2008 2:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding New Job Parameter from PX routine
- Replies: 9
- Views: 4751
Unique per shared container call, i think Creating table name from Timestamp or from job PID will work, but the only place where i can write a routine to generate unique names is transfer stage but even after creating a unique name in the transformer how will i use it in place of tablename? You have...