I don't know if there is something wrong with the Teradata import capabilities or what.I have created a table with only 2 rows:member_idssnI have exported 2 columns from another table - only 1 row!data looks like this:02251219 |381646195If a value is null it is set to spaces.I go to import the exported file into my temp table.The delimeter for import is set to | also and a space for a null value (as this is what I found searching as to why this is not working).I go to import the file I just exported and I continually get using this syntax:INSERT INTO CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3 (ID_MEMBER, SSN) VALUES (?,?)I have also tried:INSERT INTO CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3 VALUES (?,?)I continually get:wrong number of data values in import file.I have changed the delimeter, put quotes around the values and anything else I can possibly think of to no avail.Can someone please let me know what I am doing wrong?Thanks for all your help.If I dont get this to work I have to write an mload which I do not want to do.This real file will have about 1000 records in it.Thanks in advance for any helpSamantha
Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?
input output putput
"Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?"
Sorry, the forum told me my message could not be added, that's why I have it posted 4 times.
Results of show table below: CREATE SET TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3 ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( ID_MEMBER CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, SSN CHAR(9) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL) PRIMARY INDEX ( ID_MEMBER );Thanks!Samantha
02251219 |381646195I have noticed than you have a space after the first number.I had to set the delimiter in Queryman Export Option to | and also asked to enclose the values in "."02251219 "|"381646195"Please try if it works this way. Otherwise you might want to use trim() function before you export.I _guess_ there happens an implicit type conversion if your values are not enclosed in quotes.
OMG Thank you!That worked great!You don't know how much time you have just saved me!Thanks againSamantha
Hi Samantha,The sample information you have posted in this public forum for “ssn” seriously disturbs me.(try to unravel what the “ssn” acronym means)http://en.wikipedia.org/wiki/Social_security_number#Identity_TheftData professionals are obligated to maintain a much higher level of common sense when working with information that is at this level of sensitivity.But on the bright side, at least you didn’t choose a professional career as a doctor.
I made up that number..for crying out loud relax.