Search found 106 matches
- Thu Mar 23, 2017 4:30 pm
- Forum: General
- Topic: Finding jobs that uses particular Transformer funtion
- Replies: 2
- Views: 2473
Finding jobs that uses particular Transformer funtion
Hi, How do I find the list of jobs that's uses particular Transformer function. EG: AsInteger() I don't see Transformer function being part of the object type in the standard or the advanced find. Should we hit the UV and search for it? If so, may I know the exact table and the column to look into t...
- Mon May 16, 2016 12:28 pm
- Forum: General
- Topic: Xmeta query to get list of all assets changed or modifed
- Replies: 2
- Views: 2468
Xmeta query to get list of all assets changed or modifed
Greetings DSxcians! I wanted to collect the list of all components including (*.pjb, *.qjb, *.sjb, *.prt, *. srt, *.tbd etc) which got Created or Modified within the last 24 hours. I am able to see few options here but all provide for only Jobs. I would like to get it for all the components, includi...
- Thu May 05, 2016 4:53 pm
- Forum: General
- Topic: How to list the component using istool?
- Replies: 7
- Views: 4312
- Wed May 04, 2016 5:31 pm
- Forum: General
- Topic: How to list the component using istool?
- Replies: 7
- Views: 4312
- Thu Apr 28, 2016 1:14 pm
- Forum: General
- Topic: How to list the component using istool?
- Replies: 7
- Views: 4312
How to list the component using istool?
I wanted to export all Jobs / Table definitions / Routines / Shared containers individually to its corresponding folder in Unix. So that I can do the version control. If get the list, I can export using istool export command. dsjob -ljobs gives me just the list of jobs and not the other component. H...
- Thu Jul 23, 2015 1:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Range Lookup in Main Stream Flow
- Replies: 1
- Views: 1895
Range Lookup in Main Stream Flow
I have Main date field in Main stream of the lookup and I have Begin_DT and END_DT field in reference table. How do I do range lookup based on the these date field (Begin_DT < Main_Dt < END_DT)? Range lookup options in the stage gives me only Main stream fields for the Begin and End value. Let me kn...
- Mon Jun 08, 2015 11:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Preserver Partion - Clear + Same partition
- Replies: 2
- Views: 3159
- Mon Jun 08, 2015 11:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key Generation
- Replies: 2
- Views: 2724
Surrogate Key Generation
Hi, This is very basic question. I know, this must have been discussed already. I tried searching the forum, but couldnt find the right link. I need to generate Surrogate key using Surrogate key Gen stage. This is what I did. I created a job with a Row Gen and Surroage Key stage and created a Surrog...
- Wed Apr 15, 2015 12:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple messages at project level Message handler
- Replies: 3
- Views: 2676
Multiple messages at project level Message handler
Perhaps Iam missing something here. In Admistrator Client, under Prallel tab, under under Message handler for parallel jobs, Iam able to select one of the named Message handler from the drop down list. That particular message handler is getting applied to all the jobs project wide. But I wanted to a...
- Thu Apr 02, 2015 12:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Preserver Partion - Clear + Same partition
- Replies: 2
- Views: 3159
Preserver Partion - Clear + Same partition
I have the Looup stage with Reject to a Sequential file stage. I get the follwing warning. A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. I can 'Clear' the Preserver Partition of the Lookup. But other stages that are connected to Lookup, would need t...
- Tue Nov 15, 2011 11:55 am
- Forum: General
- Topic: Xmeta vs Hashed files
- Replies: 6
- Views: 3851
- Tue Nov 08, 2011 10:24 am
- Forum: General
- Topic: Xmeta vs Hashed files
- Replies: 6
- Views: 3851
- Mon Nov 07, 2011 11:31 pm
- Forum: General
- Topic: Xmeta vs Hashed files
- Replies: 6
- Views: 3851
Xmeta vs Hashed files
In Datastage 8.5, There is Xmeta in Database and the Repository (DS_JOBS / DS_JOBOBJECTS etc) in hashed files also. Locks can be still cleared using DS.TOOLS. And aswell using Datastage Admin Webconsole. May I know why is there two different places the metadata is been maintained? Or what is maitain...
- Thu Apr 07, 2011 1:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: rsh issued, no response received
- Replies: 3
- Views: 7563
rsh issued, no response received
I have alredy set up SSH for Server1 and Server2 from Engine node. Iam able to do the SSH for the servers manaully. Where as not run the jobs from Datastage. Which gives me Section Leader died error. Server1 is a ETL resourse node, Server2 is a Database server. The ID used is part of dstage group. O...
- Mon Feb 14, 2011 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 API vs Enterprise based on Authentication?
- Replies: 1
- Views: 1648