DSXchange

Hi my requirment is to convert decimal to character by Truncating decimal.How to implement this..

For Example
Input is Decimal(17,4)
as 128119000.000


OUTPUT should be Char(4)
1281


Can i do it in Sybase database itself or Datastage.
Please advice me on this... ASAP

I need to remove duplicates for example I am gettin this as the output aaa bbb ccc aaa bbb ccc aaa ddd fff aaa ddd fff Actuall output file should look like aaa bbb ccc aaa ddd fff I have used the following stages database1->Hash file - - - database2-> Sorter-> Transformer-> OUTPUT File.. Still i am ...

Hi there is requirement for the job i created.. They need a config file for the job.. Can any one suggest me how to create config file and what's the purpose.

Please help me on this...

for example i am running a job(25th) and i need to extract data of 24th from the table AB with field lst_updt is a timestamp field.

How can i proceed with this

Hi all is there any way which i can get previous timepstamp for the field. Example In a table i have a field Last_upt_tmpst with this field i need to put constraint in my job as last_upt_tmpst> @previous_upt_tmpst But i dont want to declare variable as @previous_upt_tmpst.. Is there any way which i ...

Sorry, The job creteria is Abort the job if no records exist for the day... I am scheduling this job daily which will run at 4am eveyday.. so job should be aborted if no records exists. my job will pick account numbers and name everyday. So my question was that can i include any creteria to do this...

Thanks Guru's .... Okey let me make my requirement clear... I want to abort the job if no record exists for the day. So i wanted to know how can i proceed this:- 1) I have already used after job subroutine for cancatenating the header, body and foooter file. So can i include in the same after job su...

How can i abort the job. if no records exist for the day... my job is daily delta basis . 1) i can do this in after job subroutine..? also my after job subroutine is already have query for concatenating all the sequential file present in the job. Can i include the query for job abort in same after j...