Newline in Basic Routine (calling Teradata bteq)

shershahkhan · Post by **shershahkhan** » Tue Sep 02, 2008 2:15 am

Hi,
I am trying to do the following in Routine

sFirst = '.logon server/user, password;'
sSecond = 'Select Date;'
sThird = '.logoff;'

sFinal = sFirst : [newline] :sSecond : [newline] : sThird

How can i make a string so that i can insert a newline character inb between, and then i can pass it to Teradata.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 02, 2008 2:45 am

Code: Select all

vNL = Char(10)

sFinal = sFirst : vNL :sSecond : vNL : sThird

harish_s_ampeo · Post by **harish_s_ampeo** » Wed Jan 07, 2009 10:33 am

I am also facing the same issue... the nVL is not working for me..
In the unix, the input command just logs me in but doesnt execute the sql as nVL is not working...

Please can u tell me the resolution for this

chulett · Post by **chulett** » Wed Jan 07, 2009 10:39 am

By going back to your own post on the topic and not jumping into anything you can find where Teradata is mentioned. Post there what you are trying and what isn't working about it.