All Forums Tools
Samantha-3071 4 posts Joined 08/06
15 Aug 2006
Problem using Teradata import - making me crazy!!

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

DiEgoR 33 posts Joined 08/06
16 Aug 2006

Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?

input output putput

DiEgoR 33 posts Joined 08/06
16 Aug 2006

Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?

input output putput

DiEgoR 33 posts Joined 08/06
16 Aug 2006

Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?

input output putput

DiEgoR 33 posts Joined 08/06
16 Aug 2006

"Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?"

input output putput

DiEgoR 33 posts Joined 08/06
16 Aug 2006

Sorry, the forum told me my message could not be added, that's why I have it posted 4 times.

input output putput

Samantha-3071 4 posts Joined 08/06
16 Aug 2006

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

DiEgoR 33 posts Joined 08/06
18 Aug 2006

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.

input output putput

Samantha-3071 4 posts Joined 08/06
22 Aug 2006

OMG Thank you!That worked great!You don't know how much time you have just saved me!Thanks againSamantha

TagSoup 1 post Joined 08/06
27 Aug 2006

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.

Samantha-3071 4 posts Joined 08/06
31 Aug 2006

I made up that number..for crying out loud relax.

Surendhar Reddy 7 posts Joined 11/11
14 Nov 2013

I have also facing same problem but that same solution is not working in case me ? :(
 

Raja_KT 1246 posts Joined 07/09
14 Nov 2013

Hi,
Did you  check your file and data? Also you can have a look at the menu:  Tools>Options and then check your import/export. There is a drop-down of delimiters. Select one appropriately. 
Hope you have your insert query handy.
Cheers,
Raja
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

M.Saeed Khurram 544 posts Joined 09/12
15 Nov 2013

Hi Sure,
Can you please paste some sample data from the file you want to import?
 

Khurram

You must sign in to leave a comment.