DSXchange

hi deepak, Iam able to attach file in mail. Iam receiving that mail with file attached. But the problem is all records are being sequentially placed instead of writing 1 record on each row. And in b/w the records, there is one speical character(a square). appering in the text file.I tried with all d...

Hi , Iam able to send mails using DSSendMail routine. I have a requirement of attaching a file which contains rejected records and send mail to clients ID. The file is getting attached, but it is not in readable format. It is just showing some squares as data. I am writing the rejected records to a ...

Hi, I also faced the same problem of not receiving mails even though the job runs successfully. You need not specify server name(since it is on unix).When I tried sending mials to my company ID, it dint work. But when I sent mail to my Client ID,it worked(meaning the mail was sent successfully). So,...

Hi,
Is there any logic to upsert data from data stage into teradata table with out using teradata multiload stage.If so, please help me.

Hi All, Creating sequences in teradata(using IDENTITY) was not possible, as Database structure changes was not allowed in our case. Hence we went with the following approach. Input file contains empnames. Into target table, unique numbers for empno should be inserted. we used a column generator to g...

Hi

Hi Craig,

I checked teradata related information.

By creating a sequencer in teradata,I wanted to access it in teradata-multiload stage , by writing a custom query ( insert into temp values(sequencer.nextval) ) .

But now using different appraoch , I got a solution.

Thanks,
ssunda.

Hi Ray, I tried creating a sequencer in teradata. It is not identifying the syntax "create sequence". So, may be it has some other syntax or I am not sure if we can create a sequencer in teradata. Iam not able to read the whole content posted by you, Ray.(Iam not a charter memeber). So , I...

Hi, In oracle, we can create a sequence(eg., myseq) and use it in any sql-query as insert into ttest values( myseq.nextval ,'abc'); Can we create a sequence similarly in teradata also? if so please let me know how. I want to use that sequencer in user-defined sql statement in teradata-multiload stag...

Hi, I want to use a teradata multiload stage in my job to store the data into the table.My reading the data from a sequential file.Can anyone tell me what are the different types of settings that are to be done while updating the table.(any option Insert, Update, Upsert) i have used the following th...

Hi all, i want to remove additional zeros from records using a transformer. I have tried with Trim function but it is not working .Also, please give the format in which this has to be done. I have tried with Trim function Trim("columnname","0","L") but this is not worki...

How precisely have you specified your Trim() function? ... Hi, I have tried with Trim function Trim("columnname","0","L") but this is not working.The data type is Char in input and output.Let me know if there is any other format which i need to give.With the above func...

Hi all,
i want to remove additional zeros from records using a transformer. I have tried with Trim function but it is not working .Also, please give the format in which this has to be done.

Thanks for the replies. I will check with the options and update you again.

regards,
ssunda.

Hi KrazyKoolRohit, In the teradata stage, we have options insert,append etc. But by default, the query is auto-generated. If I want the following operation to be done, insert into emp_table(empno_dim,empname,email) values ( empnoseq.nextval ,empname,email). empnoseq is a sequencer, how can we menti...