Re: Data load
CREATE PROCEDURE chtodt(par_chdate CHAR(8))
RETURNING DATE;
DEFINE ret_date DATE;
LET ret_date = MDY(par_chdate[5,6],par_chdate[7,8],par_chdate[1,4]);
RETURN ret_date;
END PROCEDURE;
USAGE EXAMPLE :
1. EXECUTE PROCEDURE chtodt ("19980919");
2. In a select statement.
SELECT chtodt(19880919)
FROM systables
WHERE tabid = 1;
Try to work further on it and have your own customised library.
HTH
Harinath Venkata
Svenska Handelsbanken,
New York.
l_nadella@yahoo.com on 04/21/99 12:31:15 PM
Please respond to l_nadella@yahoo.com
To: informix-list@iiug.org
cc: (bcc: Harinath Venkata/HAVE01/SHB)
Subject: Data load
Hello all, I am trying to import data from a SAP database (A) on Informix to
a datawarehouse (B) I am building on a seperate instance of Informix. SAP
stores the date fields as FLOAT datatype, format yyyymmdd.I need to import
these fields into the datawarehouse as DATE datatypes, format mm/dd/yyyy. I
am loading the data as INSERT INTO table1 SELECT col1, col2 FROM TABLE2;
Any ideas!!!
TIA,
Lak Nadella
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own