DSXchange

Hi All, Yesterday when i was modifying datastage job the sever became down, today when i am trying to open the same job its showing message as "the job is locked by my id", but when i am checking in the web console, there wont be any seesion id which is active, but still i am not able to o...

i am not sure if any separate function for achiving your result but try the below
use the substring function
column[(len(column)-1),1]:column[1,(len(column)-1)]

Thanks,
Ram.s

what is meant by linked sort..? any diff b/w sort & linked sort....? External sort stage we have more options like "create a KeyChangeColumn" where as we cant do it in link sort, and we can change the default memory size in "Sort Stage" it is always better to go external sor...

Hi Ray,

Thanks for your valuable tip, i will check on this in my job!

i am getting the exact output as what you required, find my specification for conversion UPC:string[20] = string_from_decimal [suppress_zero](UPC) and the output is Peek_24,0: UPC:49049716 check your column definition in the output tab of modify stage, and before modify stage also, am not sure why y...

can you tell what is your input decimal field length?

way246 wrote:

yimwai wrote:but why null value or default value can be '01/01/1900'

It is due to insert/update statements run with "" value for datetime field

the datastage will assign the "1900-01-01" as default(null) value for date field,

while loading dataset how many files are created internally? and what is default path of dataset ...? you need to derive your dataset path,whatever path you have defiend the dataset will reside on that path. while laoding the dataset based on the nodes (you have defined in the configuration file) t...

Hi All, Just wanted to follow up on the same if any body can help me out on this? If you want aviod by doing with lookup way, then i have one solution Extract records which are loaded in the previous run , funnel the previous run records with new records and do the aggregation(find the count) then ...

balaya.ds wrote:any body tell me the path of configuration in datastage..?

Hi,
you can find the configuration file in the following path "opt\IBM\InformationServer\Server\Configurations"

Thanks,
Ram.s