DSXchange

ganesh123

Ok then I guess you should do everything in Shell script itself.
first check the filename if it exists continue else send email.

ganesh123

If its same hardcore it in parameter in job properties and then select the before jobsubroutine "DSwaitfofile".

Add this job in seqencer with Email notificaiton activity.

ganesh123

Is the sorce filename same all the time ?

ganesh123

Your can find your answer from this thread -

viewtopic.php?t=108355

As Craig suggested, yes you can do if you have Ora9i client on DS server.

ganesh123

I guess you have already posted the thread.

ganesh123

Why you want to do custom SQL ?

Use generated SQL and use a constraint in TX..

Code: Select all

sv1=right(in.week_code,2)
sv2= if sv1>38 and sv1<53 then 1 else 0

Use this as constraint in output link.

ganesh123

The condition is col1 = col2

ie: if col1 <> col2 then ABORT JOB

Thats why we gave you that soln.

make a stage variable

Code: Select all

sv=if @INROWNUM<>@OUTROWNUM then UtilitytoAbort("Message") else 1

use that in constraint in TX

ganesh123

DHANYAVAD SIRJI :D

ganesh123

I guess I am not hacking the topic

So Craig something like this in Shell script ?

Code: Select all

count= wc -l bad.file
if ($count>0)
then
ABORT
else
continue
fi

Which utility or function of DS has to be called in ABORT in above code?

ganesh123

Craig is there any option that if we want to collect all the rejected rows in a separate file and then do ABORT later after collecting all rows ?

In this way we can know how many and which rows are bad....

ganesh123

Use a reject link in your job going to a Seq file. If data comes in Seq file abort job using UtilityAbortToLog(%AbortMessage%) in TX

ganesh123

use:

Code: Select all

sed '1,3 d' f | sed -e :a -e '$d;N;2,4ba' -e 'P;D'

ganesh123

DSGuru2B can you show it using RowProcCompareWithPreviousValue I am doing the following but not getting : 1)current=read.ST:read.CITY:read.ZIP 2)sv1=RowProcCompareWithPreviousValue(current) 3)sv2=if sv1 then RowProcCompareWithPreviousValue(read.SALES) else Rank=1 4)Rank=if sv2 then sv2 else Rank+1

ganesh123

Use a stage variable to remember the concatenated string State:City:Zip of the previous row and compare it with the current row's concatenated value. You will use the RowProcCompareWithPreviousValue function available in the SDK to achieve this. In that case also concate SALES_NUMBER and compare wi...

ganesh123

You need to give some more information about how you give RANKS ? Like based on what conditions ? The output you shown is confusing. We cannot guess the requirement.....

Search found 69 matches