DSXchange

DSLink8.val[ Len(Trim(DSLink8.val )),1]

Hi, When I use Sybase OC with multiple read links ( to read data from mltiple tables with same Database ), Job is running successfully with this warning Warning Sybase_OC_642: When checking operator: Passive stages should have either one input link or one output link. Other configurations may run, b...

try
dssearch -ljobs -matches -subcategories sub -oc -oj dstage Job*

at UNIX command level....

Try this
IsValid("date", StringToDate(DECTOSTRNGAC,"%yyyy%mm%dd"))

try this one

IsValid("date",Str)

Hi,

First if the input str length <> 7 ... throw an exception else IsValid () works fine.....

Use Start loop and End loop stages in your job sequence and set loop for 10 times i.e from 1 to 10.... and wait stage for 30 minuters... Curious how this is any different from simply setting the timeout to 5 hours and waiting once? :? Input file may appear any time between 0 to 5 hrs.... Let us say...

Use Start loop and End loop stages in your job sequence and set loop for 10 times i.e from 1 to 10.... and wait stage for 30 minuters...

Try this

datestr="2008002"

IsValid("date",StringToDate(datestr,"%yyyy%ddd"))

first parameter is "date"

Dates can be like this 2000-00-00 ....Isvalid is expeting in this yyyy-mm-dd format........

First convert the string to yyyy-mm-dd format and use Isvalid("date",string)... returns 1 or 0

First convert the string to yyyy-mm-dd format and use Isvalid("date",string)... returns 1 or 0

/opt/dataste/prod to /opt/datastage/dev

Hi ,

try this one

for i in `ls *.ksh`
do
sed 's/\/opt\/datastage\/prod/\/opt\/datastage\/dev/g' $i > ${i}_new
mv ${i}_new $i
done

hope this helps.....

Albasir,

There is one External Filter stage in PX... use that stage to replace string with the following sed command

sed 's/AND/\) AND \(/g'

hope this helps...

Can be implemented in a C routine and call it from the transformer..