DSXchange

I have one doubt. When I run my job with prev logic which mentioned in above post, I am getting records into Hash file(With Only 1col(OU_ID) but not passing those records to transformer stage. Do we must have Key col in output link in hash file to get the data into next stage(Transf stage)? Thanks i...

Hi all, I have a problem with my lookup logic. I am not able to implement the lookup logic in the job. The lookup code is given below. Lookup OU to get OU_ID by condition If Mid(FI_HOST_YYYYMMDD.TO,6,3) = 'นท.' Then Concatenate('บน.', Concatenate(Mid(FI_HOST_YYYYMMDD.MORP,2,1), '.', Right((FI_HOST_Y...

Thanks Chulett,

I got the solution.. able to load the date into db2.

Hi, I have a column of char(8)(format is like : DDMMYYYY) coming from Seq file and I need to convert it into Date(Date format is: YYYY-MM-DD) and load into DB2 db. When I tried convert the src column into internal format using Iconv in Trnsf stage and used Oconv in another Trnsf stage and load it in...

Hi my dear DataStage gurus, I have come up with the new issue now. I have date col(ex: DDMMYYYY) of type Char. Now I want to convert that date into YYYY-MM-DD format and load that col of Date type into DB2 Database. When I used Substrings and converted the date(DDMMYYYY) into required format(YYYY-MM...

Ray thanks for your reply. I could solve that problem by converting the Date column into internal format. But now I got new issue. After aggregation I converted the Date column into external format(Date format like: YYYY-MM-DD) and loading into DB2 database as the Date Column is Key column inthe tar...

sorry, I don't have time in my Date column. Its like DD/MM/YYYY. Can I do inthis way. My source Date column is Integer datatype(YYYYMMDD) and my target column is Date datatype(YYYY-MM-DD). Can I use substrings function to make my src col(YYYYMMDD) into date format(YYYY-MM-DD) and insert into tgt dat...

There is no null Date record coming as Input, but after the aggregation I am not able to find any value inthe Date column. Just now I gone through the search that I found Date columns cannot be passed through as Group by columns. If to pass convert into internal then pass to output and then use ocon...

Hi, I am combining three inputs using Link Colletor stage and want to aggregate two columns group by three columns in the Aggregator Stage. In group by columns I have Date column and other two are smallint columns. When I run the job I getting the values for the smallint columns but getting no data ...

Hi, As my source file is in Tab dilited format, I have to use TAB as delimiter in Sequential file. How to enter the TAB as delimiter in the delimiter field. when I tried in search, I am getting the error like this: [/quote]Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to alloca...

Hi, Actually I need to subtract one month from the date parameter(business date ex: YYYYMM or 200702) in WHERE clause in DB2 stage. We have written USER DEFINED SQL in the db2 stage. The code is like: WHERE ACG_CGY_CODE in ('31520001', '31520002') and DOC_TP = 'SV' and MSR_PRD_ID = <business date YY...

Hi, Actually I need to subtract one month from the date parameter(business date ex: YYYYMM or 200702) in WHERE clause in DB2 stage. We have written USER DEFINED SQL in the db2 stage. The code is like: WHERE ACG_CGY_CODE in ('31520001', '31520002') and DOC_TP = 'SV' and MSR_PRD_ID = <business date YY...

Sorry Ray, I searched in the forum but I could not find any help in search... Please help me to solve this issue.

I appreciate your help

Hi,

I am passing the business date through parameter to retrieve the data from DB2 db. Now I need to subtract 1month from the date(format is like YYYYMM, Ex: 200701).

Is there any way to calculate the above one?

Thanks in advance.

Hi,

I want to calculate the no. of days between two dates. Is there any built in function in DataStage server edition for that?

Thanks in advance.