DSXchange

Thanks for your reply. i tried by converting into UTF8 file, its working fine .

For the first time itself ,i tried that ISO-8859-1 nls it's not working.

Is there any option to read that file without converting into UTF8 file?

Thanks a lot........

Here is the way i did, From the database itself, i took one more column which contains the number generated by row_number () function limited to the length of the column data. id, data, no 1, ad|fh|ju, 1 1, ad|fh|ju, 2 1, ad|fh|ju, 3........... then i took count of the data column with respect to th...

I need to call week day from date function in Job Sequence [Not in parallel job transformer stage,server job and server routines].Is there any way to perform this in sequence?

Thanks in advance.

Thanks a lot for your reply.

Yesterday itself, i found that it is data issue only. i forgot to think in that way previously. Sorry for the late reply.

Hi, I tried to load data by simple direct mapping. source column a (decimal(17,2))-12121212121212121.66 target column b (decimal(17,5)) The data are rejected to peak stage if i mapped directly. So i used DecimalToDecimal function , but that one also not worked.The data got loaded into DB2 target tab...

hi, there is a good news. i solved that problem. thanks for all who replied for me. ray , i couldn't able to see the full content as i am not a member of that. Here is the way i did, From the database itself, i took one more column which contains the number generated by row_number () function limite...

hi, I need a solution for one of my scenario. it describes below. My input columns are id,data and its value are id , data 1, ad|fh|ju i have to split this data as like below id, data 1,ad 1,fh 1,ju I am using datastage parallel , so kindly give me the solution in respect of that. Thanks in advance ...

ok ray, thank you.

Thanks ray, Is it possible to register in premium membership for one day. If possible which link i have to use for register?

Yes , it have to return "found" with respective job name if the given string is present in that job. Could you help me in this scenario.

I tried with that also." SELECT DS_JOBS.NAME AS JOB_NAME, EVAL DS_JOBOBJECTS."if @RECORD = '#StringLike#' then 'found' else 'no'" AS STATUS FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO and status='found' GROUP BY JOB_NAME, STATUS". It throws error like ...

I am using this query "SELECT DS_JOBS.NAME AS JOB_NAME, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),upcase('#StringLike#'),1) > 0 then 'FOUND' else ''" AS STATUS FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO and STATUS = 'FOUND' GROUP BY JOB_NAME, STATUS &qu...

If we used index function in the sql query of universe stage , it will list which are all having that string. But i want to list the exact match of the string. For example, if we give the string like app, index function list app,apple,application,apply. But i want to list app only. could you please ...

The job ran successfully with the following warning "Invalid character(s) ([xBF]) found converting string (code point(s): Burnsville [xBF] Plymouth Ave & Hwy 42 (150th St. W)) from codepage UTF-8 to Unicode, substituting." The stage shows this warning contains varchar(30) datatype colu...

Ya, i already saw the developer's guide, in that only they mentioned uint64 to decimal conversion is default one.