Loading Time Values Using OCI Stage
Posted: Sat Feb 03, 2001 11:38 pm
Fellow DS Users,
Just wondering how would I be able to load DATE+TIME values into my DW through the OCI 8 Stage.
I have got this working through the ODBC stage but unfortunately some of my tables have way too many columns for ODBC to handle, hence the need for OCI.
I would prefer to load data that looks like "YYYY-MM-DD HH24:MI" in my data file.
I would also prefer NOT to have to change my default NLS_DATE_FORMAT setting as it is going to affect a whole lot of other users. The error message I get from DS is that it cant convert the format given o a DateTime format.
-----------------
While we are here, how can I prevent the Oracle Bulk Loader from converting my blank character fields to NULLS when I really want to insert blanks or a space. My data will often have blank values for character fields (which is
OK) but the bulk loader insists on trying to convert these to NULL and my table schema is defined as having ALL fields defined as NOT NULL so it wont load !
eg, Data file looks like this after processing through DS (sqlldr converts
last field to NULL) ... "Field1","Field2",""
When the data looks like this "Field1","Field2"," " (Note the blank in the last field), it will load blanks into the third field.
P.S. We are using DS 4.0.1 on Win NT.
Help !!
Basil Privitera
DS Consultant
Altis Consulting
*******************Confidentiality and Privilege Notice*******************
This email is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply email. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you.
Just wondering how would I be able to load DATE+TIME values into my DW through the OCI 8 Stage.
I have got this working through the ODBC stage but unfortunately some of my tables have way too many columns for ODBC to handle, hence the need for OCI.
I would prefer to load data that looks like "YYYY-MM-DD HH24:MI" in my data file.
I would also prefer NOT to have to change my default NLS_DATE_FORMAT setting as it is going to affect a whole lot of other users. The error message I get from DS is that it cant convert the format given o a DateTime format.
-----------------
While we are here, how can I prevent the Oracle Bulk Loader from converting my blank character fields to NULLS when I really want to insert blanks or a space. My data will often have blank values for character fields (which is
OK) but the bulk loader insists on trying to convert these to NULL and my table schema is defined as having ALL fields defined as NOT NULL so it wont load !
eg, Data file looks like this after processing through DS (sqlldr converts
last field to NULL) ... "Field1","Field2",""
When the data looks like this "Field1","Field2"," " (Note the blank in the last field), it will load blanks into the third field.
P.S. We are using DS 4.0.1 on Win NT.
Help !!
Basil Privitera
DS Consultant
Altis Consulting
*******************Confidentiality and Privilege Notice*******************
This email is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply email. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you.