DSXchange

i have a query which returns 1 or blank i want to run a sequence job if the query returns result 1 else datastage job will need to go back to sleep for 15 minutes and then wake up to check again the result when query returns 1 result it starts running

how can i do that..

Thanks

I tried both with single quote and double quote around all_v1
still not working

Hi,

1)i am doing grep in execute command activity
getting
Output from command ====>
"all_v1"

2) Using nested condition
to load table_a

Activity.$CommandOutput = 'all_v1'

table_a not getting loaded any idea what should be nested condition.

What i am asking is if constraint is not met how can i prevent it from
initializing the database table .

i have source-->lkup-->transf--> 2 target tables table_a and table_b in transf i am giving condition if condition met for table_a load table_a else if condition meet for table_b load table_b (Condition is a constraint) In both target tables i have before condition to truncate table so if condition f...

i can't use server job as i need multiple nodes to load data to db
i tried loading data in dataset and then did Execute Command stage to
read data from dataset problem is grep don't work on ds files

let me ask this i run that select and peek the output which
looks like Peek colum_1:a1 can i call this a1 in to nested if not
what will be syntax for Execute Command activity to call column_1 a1

what will be syntax for Execute Command activity

Hi,
How can i do this in nested condition

call select stmt select active_table into active from your_control_table;

if active =1 then load table_a if active =2 load table_b

can we call select stmt in nested condition?

IF you can explain step 2 bit in detail it will help 1) have two jobs which load to table_a and table_b both tables have same ddl and same datasource 2) which transformer should i use to give below condition (If you can explain this step bit in detail) SELECT max(row_date) as t1_date FROM table_a an...

Can you please post a design who will this work

Hi, How can i do this Two tables table_a1 and table _a2 both tables have same table structure first time etl runs do count on table_a1 and _a2 and just populate table_a1 second time it runs do count on both tables find _a2 null so load _a2 after load _a2 delete _a1 third time it runs do count on bot...

I want to do sumthing like this in sql so that records for _Req and _Joi not pass.i tried and suggested by ray its not working

SELECT *
FROM aa
where "ID" NOT like '___Req%' AND
"ID" NOT like '___Joi%'

Hi,
I want to filter any records which has ___Req% or ___Joi%
i am putting constraint in transformer its not working

Index((to_transf._ID), "___Req",1)
or Index((to_transf._ID), "___Joi",1) = 0

Thanks

ok i guess i want to know opposite i can see all file sets on aix box
i just want to take that fileset name from unix and then find which job
create it and which jobs uses it as lookup