|
Archives of the TeradataForumMessage Posted: Thu, 14 Nov 2002 @ 16:42:05 GMT
I was using Queryman and Bteq... then i did following on Queryman and bteq... the it's showed proper one... sel * from xxx where phoneno is null; One more question is in below mail.......
I loaded the rows into a table using multiload script... and the input table contains few columns NULL like fillowing NOTE: i didn't used INDICATOR field in mload script Raji;;Calif here phone number is null in first record..... After loading data into table, when i did a sel * from queryman or Bteq i am getting '?' in phoneno filed in first record...... That means, without using INDICATOR filed it storing NULL as NULL in table...... pls..correct me if i am wrong...... I just want to test following......
pls..let me know if anyone tried similar one.... THANX -madhu
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||