All Forums General
S_Banerjee 15 posts Joined 02/09
21 May 2012
Teradata Functions

Is there any function called NULLIFSPACES invoked in Teradata 13 version? If yes or it present before please explain how it works,syntax,uses etc..

dnoeth 4628 posts Joined 11/04
21 May 2012

There is an old function NULLIFZERO(col), which is the same as a NULLIF(col, 0).

NULLIFSPACES doesn't exists, but this should be NULLIF(col, '')

Dieter

Dieter

S_Banerjee 15 posts Joined 02/09
21 May 2012

Thnx Dieter for explaining...

in the format function why we always use this format --

SELECT CAST ((545458874489 (FORMAT '99-999-999-9999')) AS CHAR (15)) AS Format_Cast_PhoneNum

and not this --

SELECT CAST ((545458874489 (FORMAT '11-111-111-1111')) AS CHAR (15)) AS Format_Cast_PhoneNum

Banerjee

ToddAWalter 316 posts Joined 10/11
25 May 2012

9 is the formatting character representing a numerical digit - stolen from COBOL oh so long ago.

S_Banerjee 15 posts Joined 02/09
27 May 2012

Thanx Todd

newcommer 1 post Joined 06/12
04 Jun 2012

hello there

 

i have got an offer as teradata developer as fresher..

 

i would like to know how the real time environment would be like.. please help me with this..

 

i want to know atleast how to work on it before entering into the organization

 

thanks in advance

Adeel Chaudhry 773 posts Joined 04/08
29 Jun 2012

If you are joining as a fresher, am sure the organization will guide you through it.

 

Cheers.

-- If you are stuck at something .... consider it an opportunity to think anew.

yaragalaramesh 20 posts Joined 06/12
03 Jul 2012

Hi,  masters

 

can please haelp me

i have a scenario like

 

col1  col2  col3........col37is like(sam,xyz,abc,cdef,xxxxx)..........col50............col247

 

here i need to use delimeter   ', ' but  if i taking that it is dividing the 37th column into different columns but i need that entire column as one not diff  can please help me how to do this problem

 

 

Thanks in advance

Ram

yaragalaramesh 20 posts Joined 06/12
03 Jul 2012

Here

 

The column name itself has the delimiter as  ','  not data

Ram

Adeel Chaudhry 773 posts Joined 04/08
03 Jul 2012

Please post your question in a seperate thread and be more descriptive.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.