Problem using Teradata import - making me crazy!!

Tools

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_id
ssn

I have exported 2 columns from another table - only 1 row!
data looks like this:

02251219 |381646195

If 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 help

Samantha

13 REPLIES
N/A

Re: Problem using Teradata import - making me crazy!!

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

Re: Problem using Teradata import - making me crazy!!

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

Re: Problem using Teradata import - making me crazy!!

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

Re: Problem using Teradata import - making me crazy!!

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

Re: Problem using Teradata import - making me crazy!!

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

Re: Problem using Teradata import - making me crazy!!

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

N/A

Re: Problem using Teradata import - making me crazy!!

02251219 |381646195
I 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.

Re: Problem using Teradata import - making me crazy!!

OMG Thank you!
That worked great!

You don't know how much time you have just saved me!

Thanks again

Samantha

Re: Problem using Teradata import - making me crazy!!

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_Theft

Data 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.