DSXchange

smallint to string conversion in modify stage

Will the modify stage implicitly converts smallint to string ?or do we need to manually do it?

i dont find any smallint to string conversion function in parallel job developer's guide

use surrogate key generator and parametrize the key value
pass the key value as parameter
run a script that takes the value

StringToDecimal(%string%,[%rtype%])

try this in transfromer
hope it works

StringToDecimal(%string%,[%rtype%])

try this in transfromer
hope it works

StringToDecimal(%string%,[%rtype%])

try this in transfromer
hope it works

we can read them using sequential file stage as well as complex flatfile stage in sequential file stage in format tab , ---->typedefaults -------->characterset as EBCDIC and you can set the byte order as well. according to your input file format ,you can choose number of options

i didnt understand your question
still trying to understand........


In lookup stage conditions,
job aborts if
1.if you specify the option "conditions not met" as fail
if your specified condition is not met


2."lookup condition" as fail
if your lookup on link fails

thanks keshav

can you suggest any method using system variables in a transformer?

thanks ray

kumar:
can you please elaborate on this?how can we do that in transformer?

Is there any way to find a maximum value of a group without using aggregator?

the error is :

"RNANDIP" does not have the privilege to perform operation "SELECT"
on object "MR3402.INB_BRKG_CUST". SQLSTATE=42501

my job design looks like this

seq file--->copy--->DB2 stage


any idea??

my design looks like this DB2-- 71000records -------------> JOIN-------->DB2 ---SORT---->- DB2-- 11million records the error is Sort_11,3: Fatal Error: Tsort merger aborting: Scratch space full [sort/merger.C:874] what does this error mean.. Help me................ :(

thanks bkumar

why lookup reference link requires entire partition method and the master link ,hash partitioning method?

thanks john smith