|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/20/2009 1:44:00 AM
Posts: 7,
Visits: 10
|
|
Hi Friends
I am unable to load the data when inserting nulls or strings in the table using QUERY MAN.
insert into fact_current values(id, name, ,"expected",salary);
Wat is the problem?
Please tell me the solution.
KIRAN
kiran_teradata@ymail.com
KIRAN
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/23/2009 2:08:26 AM
Posts: 1,
Visits: 6
|
|
Dear Kiran.
If you want to express string in teradata sql, YOu need to use quotation mark '
not dobule quotation mark ".
Thank you.
Junior Officer, RDB/DW operation team, Technology Production Services , Korea
Standard Chartered First Bank
Email: YoungChang.Ryu@scfirstbank.com
______________________________
‘Hewitt Best Employer in Korea 2009’ Bringing you New Possibilities
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/20/2009 1:44:00 AM
Posts: 7,
Visits: 10
|
|
Thanks for Your Help, I used only single quotes, not double qoutes, even the same problem
KIRAN
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/9/2009 6:52:33 AM
Posts: 1,
Visits: 6
|
|
Hi Kiran,
Please use 'NULL' keyword to insert a null value in a Nullable field using insert into statement.
Use single quote to inset strings.
Ex:
insert into table1 values (123,NULL,'Hello');
Thanks,
Sourav
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/20/2009 1:44:00 AM
Posts: 7,
Visits: 10
|
|
insert into product (p_partkey, p_name, p_mfgr, p_brand,p_type,p_size, p_container, p_retailprice, p_comment) values
(?,?,?,NULL,?,?,?,?,?);
THEN THE O/P IS WRONG NO. OF DATA VALUES IS DISPLAYED
The no. of columns is same
instead of using null, if i am using any string constant the result is same i.e., WRONG NO. OF DATA VALUES IS DISPLAYED
I am usign V2R5 Please help me to solve the problem
KIRAN
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111,
Visits: 263
|
|
insert into product (p_partkey, p_name, p_mfgr, p_type,p_size, p_container, p_retailprice, p_comment) values
(?,?,?,?,?,?,?,?);
Assuming there is no default on the p_brand. If the column is not mentioned,it puts null in it, like any SQL select.
When you are importing data, you cannot have a mix of values and constants (null or anything else). SQL Assistant cannot work out whether you are trying to skip a column from your input or not.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/20/2009 1:44:00 AM
Posts: 7,
Visits: 10
|
|
But c the Help in tool bar and c the api, it says it support
KIRAN
|
|
|
|