DSXchange

Hi The file i am using in the ETL job is created by mainframes. I need to read a data in a particular column as decimal (15,2). The sample data is like 000000006043315. I need the data to be read as 0000000060433.15. But datastage is reading the same as 0000006043315.00 Please provide some valuable ...

Hi
I have a file available in UNIX box. There are many columns in it. I want datastage to read only selected columns from the file. How can this be done? It is tedious process to load the metadata of the file to Sequential file stage. Please post me the answer as soon as possible

Hi
I am using a server job. I need to read a file that is comma seperated, but the data in one of the field contains comma. The data is not quoted. datastage interprets this comma as a delimiter and is not readin the data properly. How to overcome this?

Hi all

I need to subtract few days from a given date. How can i do this? Pls guide me through the steps.

Hi all

thanks for all ur valuable answers. my req is bit diff,,, i need to find the no of mondays for a given month and the month value cums from a seq file say (20080701) 07 here represents the month of july,.. from here i hav to find the no of mondays for the month of july...

ok... but routines are written n basic lang and am new to them.can u suggest me any forums to learn the basic terms in them..also explain a bit more algorithm of yours.

Will i not be able to do it in a transformer... ??

Hi How can we find the no of months in a given month in datastage parallel job. The date is not hardcoded,

HI all

I need a find the no of mondays each month has got using datastage, The month differs and is not a hardcoded one. Please help me out in finding the count

Hi

I need to get the count of the file and then send a mail if a file contains data. i tried using the execute command in the sequencer to find if the file has data. [ -s filename ] how to proceed further to send a mail??