DSXchange

Dear all, Is there any function in Data stage which will convert the integer data type to double data type. I am loading data to a sequential file from a set of input Hashed files , the data type in input hashed files is int , i want that data in the output sequential file to be double data type. Wi...

Thanks guys for your insight into the problem

I have enclosed SMTP server name in single quotes
I removed the quotes and its working fine now.

Hi all, I created a new sequence and using an email notification activity to email 2 csv files which are generated in previous job , but i am getting the below errors. Interesting thing is there are already some sequences which are using email stage and they are able to successfully send the email b...

Thanks Ray,

I converted the input date to YEAR-MONTH-DAY format and applied the
ICONV(date,'DYMD') and its working fine.

Thanks all,

The simple way to know ourselves how a particular function works is to write a test routine with it and test it

Sorry , I tried but couldn't able to draw the reject link

Another output link is drawn from the Tfm to a Hashed file(reject file)

A constraint is put for the Hashed file in Tfm like
LinName(of DB2).REJECTED

I even tried with simple REJECT , but of no use.

Please advice

Thanks,

Hi all, I am loading a seq file to a DB2 db. I have a date field column in the table when i try to load the value in this column "cannot able to convert sting to date" warning is coming. I have been using the below function but of no use OConv(IConv(FM_FLEETS_HASH_FILE.START_DT,"D&quo...

Hi Chulet,

I am using a seq file --> tfm ---> db2 stage.
I am using a hashed file to capture the rejected records which were failed to insert into the db.

I tried with simple reject but of no use

Thanks,

Dear all,

I have a job to insert the data into DB2 DB.
Problem is the rejection file is not capturing the rows which are failed to
insert in the DB even when LinkName.REJECTED is used.

The above procedure is working fine for Sybase db.

Could you please help me in this regard.

Thanks

In your job sequencer is there any significant time difference in triggering the next job activity ?
If so please clear your &PH& folder except .uvnlsmap when no job is running

There must be some key by which you are updating the target table..
Check for few records which are failing to update
if the record exists and it fails to update , probably you dont have update permission..if the record doesn't exits then no problem..

Hi all,

The suggestions have been working successfully..
Thanks again.
Next time i will come up with a more apt subject line ...

Hi all,

Thanks for your suggestions , i will give a try and get back

Hi all, I need to load around 20 tables , i have separate jobs for each one of them. Daily some of the records are rejected in one or all jobs and i have an error file to capture them with different user defined error messages ( a single file for all jobs) Each record will have an unique no. Now my ...

As per masters order ...