DSXchange

Change the format to one acceptable to SQL Server, particularly CCYY-MM-DD HH:MM:SS or CCYY-MM-DD HH:MM:SS.sss Split the input into date and time. Use Iconv() and Oconv() functions to reorganize b ... Find the date formate in squl server and use the Iconv() and Oconv() functions . example is Oconv(...

Are you talking about a NULL or an empty string? The former, in Server, can only occur if the input is already NULL! ... I am loading 50 records from file. I have data for begin date. If I am loading in to database I am getting the following err. I am using the following derivation : Oconv(Iconv(DS...

rsomiset wrote:Once again, you make sure that the incoming data is not null. If not, then use the iconv function with the format that your data is coming and oconv function in the format that you want.

Hi All,
date column have value. But while converting null is comming out.

use IConv and OConv datastage functions convert the input value appropriate to Oracle Date format. Look for Online document for IConv and OConv with different options. I am using the following function Oconv(Iconv(DSLink44.BEGIN_DATE , "D MDY"), "D4/MDY") it inserting nulls. its...

use IConv and OConv datastage functions convert the input value appropriate to Oracle Date format. Look for Online document for IConv and OConv with different options. I am using the following function Oconv(Iconv(DSLink44.BEGIN_DATE , "D YM"), "D4/MDY") it inserting nulls. its ...

Teej wrote:Please always paste the exact error message, not translate it or anything like that.

I am getting the follwoing error

Db_Insurance_Policy_Period..Risk_Tfm: DBMS.CODE=ORA-01861
Db_Insurance_Policy_Period..Risk_Tfm: ORA-01861: literal does not match format string

Hi ,
I am trying to load the data from file to database.

file have one date column begin_date its data type is timestamp(19), target database column type is timestamp (38). while loading the data I am getting the error, date for mante not supporting.

can any one suggetst on this.

I got the answer we have to use
Oconv(Iconv(Fac_in.COLL_EFFEC_MO: Fac_in.COLL_EFFEC_YR, "D YM"), "D4/")

Hi In Source I have two columns one is eff_month, eff_year. those data type is char. I want to load in target as due_date (data type date) as month/year. I am doing concadination using to_date. in oracle it is working but in data stage I am getting error. Can any one help me how to do this rek. we a...

Hi In Source I have two columns one is eff_month, eff_year. those data type is char. I want to load in target as due_date (data type date) as month/year. I am doing concadination using to_date. in oracle it is working but in data stage I am getting error. Can any one help me how to do this rek. Than...

Definitely a routine. What are the rules for establishing the dates and premium amount in the individual output records? It would be a Very Good Idea to document these business rules before designin ... we have to split the dates and premium amount based on the no of premiums. Can any one please pr...

Hi, I have one table the formate is idno, amount, begin_dt, end_dt, no.Premiums 1 4000 01-06-2005 31-06-2005 4 if i have no.Premiums are 4 I need o/p with 4 records from the above record , into target I have get 4 records based on the no of Premiums. required o/p is idno,instal_amt,due_date 1 1000 0...

Hi,
I have one requirement. While loading the data , based on the previous record we have to compare the current value. If its true I have to copy the previous column value in to current column.

How can I do this rek. I am using hash file to read the previous record.

please explain me.

Hi I am using one flat file. That file have 7 key columns. In that one key col name is cert_no. While loading the data I need to load only distinct cert_no. I am using hash file and passing all the columns (include 7 key cols) through hash file. If I did can I get distinct record? The link between h...

just to give u an example SQL> select * from tbb1; COL1 COL2 DT1 ---------- ---------- --------- 1 1 17-JAN-08 1 1 18-JAN-08 1 1 19-JAN-08 1 2 19-JAN-08 2 2 19-JAN-08 1 1 21-JAN-08 ---------------------------------------above is input -------------------------- you want an output like SQL> select c...