Search hard code values

kannan_ayyanar · Post by **kannan_ayyanar** » Sat Oct 27, 2012 9:01 pm

Hi All,

i would like to find the list of jobs where certain hard code values are entered in transformer (in derivation and constraint) and source db2/odbc (in queries) stages..

jobs impacted : server and parallel.

version : both 7.5(windows) and 8.1(unix)

how can i get the list of job names just by giving my hard code values..

Thanks in advance...

ray.wurlod · Post by **ray.wurlod** » Sun Oct 28, 2012 4:13 am

A query on DS_JOBOBJECTS joined to DS_JOBS should do it. There are plenty of examples here. Use a LIKE operator to check against EVAL "@RECORD" and constrain OLETYPE to 'CTransformerStage'.

kannan_ayyanar · Post by **kannan_ayyanar** » Sun Oct 28, 2012 4:53 pm

Hi Ray,

Thanks a lot. could you please send me the query.

how could we find from SQL queries. what would be the OLETYPE for ODBC, DB2 and Oracle stages.

shall we describe the tables (i.e column definition) in the universe database? so that it would be easy for me to explore a bit. Thanks again.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 29, 2012 12:35 am

As noted, search DSXchange for examples. They've been published many times. I prefer to teach you to fish than to give you a fish.

chandra.shekhar@tcs.com · Mon Oct 29, 2012 2:11 am

@Kannan,
How are you ?

If your jobs are not big, then you can export the jobs in .dsx format and open them in a notepad and you can search for your string there..

kannan_ayyanar · Post by **kannan_ayyanar** » Mon Oct 29, 2012 10:13 am

Ray,

i searched in DSXchange, but most of the contents are blocked.

Hi chandra,

i am fine. how r u?

i have around 1000 of jobs in one project, we have around 8 projects. its very difficult.

yes even i tried to export the job in xml and open it in excel, it was easy to apply filter and find. but we can use this for very small number of jobs. we have around 10000 jobs... that s the problem...

so i want to fire the universe tables and get all the details. problem is i am not able to explore the tables in universe database.

do u have any details about those tables?

ray.wurlod · Post by **ray.wurlod** » Mon Oct 29, 2012 10:40 am

If you get a premium membership the content will not be blocked.

At less than Rs12 per day it is a worthwhile investment if you purport to be a developer in any of the Information Server suite products.