DSXchange

Thanks for your reply. multiple spaces will occur either first name,last name,middle name.some times multiple spaces may be occur at a time in middle and first,last names. I think your code will work where I will know particular names (middle or last or first) will occur multiple spaces. Please help...

Thanks kryton

If there are multiple spaces in first name,lastname can you plese let me know how to handle this.

Hi my source is teradata and target is sequential file. source data: vekat raJU VENKAT RAM Raju narayana output: firstname=venkat secondname=raju middle name=null firstname=venkat secondname=ramraju middle name=narayana. based on the delimeter(space) I have to divide into three parts. Some times mid...

hi,

I am new to perl script. could you please explain below code
my $string = shift || q{};

if ($string =~ m{\A (?: ([^/,]+) /)? ([^/,]+) (?: , ([^/,]+))? \z}xms) {
$dbsys = $1 if (defined $1);
$dbuser = $2 if (defined $2);
$dbpass = $3 if (defined $3);
}

My user id is not working. I am given reply from my friend userid

Sorry ,Yes you are right
My job does not contains RT_CONFIG63, RT_STATUS63 files in my project path(/opt/IBM/InformationServer/Server/Projects/project_name).

I created this files(config and status) in project path. I have taken this files from some other RT_config.

Hi,

we are using multiload as load type in teradata connector stage. There is no value in the insertcount column in sync table. it is having <error> value. But we use fast load sync table data contains proper values.

Please help me.

sorry, my target datatype is smallint

source value: 978972
But I am getting in the output= -4,068
Please help us

HI, MY JOB : TDSTAGE -----> XFM---> TDSTAGE MY SOUCE COLUMN DATATYPE IS VARCHAR TARGET COLUMN DATATYPE IS BIGINT I went through dsxchange forum. some body is telling that no conversion is required.But in my case it is not working. I want to change the target datatype in datastage level. Is it right ...

yes, Is there any best approach apart from this?

In my job I have one STG_CSPR_RECON_HAND table which contains rslt_1,rslt_2,rslt_3,rslt_4,rslt_5.......rslt_25(source columns) For each record I need check rslt_1<>0.0 then "ohlbr" assign to result_cd out put column and "rslt_1"(hard coded value) assign to rslt_fld_cd column For ...

we have standard template given by client to load into the audit table.There is no problem in the template

I can not change the template. My question is there is no records in the dataset.why it is showing records in the datastage designer.

my dataset does not contain any rows. When I am tried to view data it is not showing any records. My problem is my sequencer will take count of the links and loaded into the audit table. that is problem.

two month back only we installed datastage software.

Hi, dataset1 dataset2 my job: teradata connector stage---> lookup------->td stage. IN my job I am doing the look up with two datasets.But in two datasets are empty(no records). After runing the job dataset link is showing source count. That means If source is 10 records two dataset are showing 10 re...

Hi, my job: shared container teradata connector stage ---> look up -> transformer-----> teradata conne In the above job I am doing look up with shared container.But there is no key column for this look up. I have used dammy key. in shared container is haveing four columns. these four columns data wi...