All Forums Tools
kiran_terydata 13 posts Joined 09/09
10 Sep 2009
I am unable to load data using SQL Assistance

Hi FriendsI 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.KIRANkiran_teradata@ymail.com

ChikaBoom 1 post Joined 09/09
10 Sep 2009

Dear Kiran.If you want to express string in teradata sql, YOu need to use quotation mark 'not dobule quotation mark ".Thank you.

kiran_terydata 13 posts Joined 09/09
14 Sep 2009

Thanks for Your Help, I used only single quotes, not double qoutes, even the same problem

techiesourav 1 post Joined 09/09
17 Sep 2009

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

kiran_terydata 13 posts Joined 09/09
18 Sep 2009

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 DISPLAYEDThe 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 DISPLAYEDI am usign V2R5 Please help me to solve the problem

Jimm 298 posts Joined 09/07
18 Sep 2009

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.

kiran_terydata 13 posts Joined 09/09
19 Oct 2009

But c the Help in tool bar and c the api, it says it support

You must sign in to leave a comment.