DSXchange

Hi Nbdbzv4. Please try the below one, hope it will work, acctlvl = ' ' and srvtype <> 'S' and caasrvnbr <>132 and (srvstatus <> 'X' or srvstatus<>'W' or srvstatus<>'F' ) and acctlvl_1 = ' ' and (acctchg_1 <> 'A' or acctchg_1<>'C' ) Find the changes in Bold. Thanks, Senthil P

Thanks Arndw for your support.

Sorry if my question was not clear.

I used Sed in seq file filter options. Its working good.


Thanks,

Senthil P

Hi Arndw,

I tried with the ur approach convert(char(10),'',In.String) , But it is not resolving my problem. it gives the output as it is in the input.

Eg:

Inp data: Exce\nllent
O/P Data: Exce\nllent

Theres no change in the output. Seems it works for the line feed character.

Thanks ,

Senthil P

Thanks Arndw and Minhajuddin, Convert function replaces all the characters - as Minhajuddin said. So i should not use Convert funtion for my case. we can easily do this thro unix, but wont there be any other way to replace the literal \n with " " thro Datastage? Please let me know if there...

Hi Friends, I want to replace the char \n with "" from my inp data. I tried it using the convert function. But it takes the unix end of line as \n and replace with " ". Inp Data: qwerbv\nqewtt\n Required O\P data: qwerbvqewtt I tried using the external filter with sed 's/\\n/ /'....

Thanks Ray, I got your point. But I find difficult in getting the every other character apart from the allowed, 1. Alphabets a-z 2. Numbers 0-9 3. Spl Chars " !#$%&'`\"()*+,-.:;?<=>/@[\\]^_{|}~"; If i have to use convert funtion, I should know what all are the other characters tha...

Hi Friends, I want to check whether my input field should contain only the following character set , 1. Alphabets a-z 2. Numbers 0-9 3. Spl Chars " !#$%&'`\"()*+,-.:;?<=>/@[\\]^_{|}~"; If the inp field have any other characters than the above mentioned list, then it should be repl...

Thanks Ray, My input data set has: col datatype Key integer (10) ColA varchar(10) ColB varchar(10) ColC varchar(10) Make SubRec Stage: Under stage properties, i have given non key cols as vector column for subrecord and the "parent" as the subrecord output column. In Input Stage, col datat...

Hi Friends, I want to use the Make Subrecord Stage, I have my flow like, Seqfilestage->Makesubrecordstg->seqfilestg I have four inp cols, one is key col and the rest are char field. In Make sub rec stg, i have given non key cols as vector column for subrecord and the "parent" as the subrec...

Hi All, I installed 8i successfully..Thanks a lot Trokoz and Thanks everyone for your help. The only thing i have done is, I precreated the users in my local machine with admin rights and then created the same users in web console. Now am able to connect to the server well. Thanks, Regards, Senthil P

Hi, I created the webadmin and infoadmin with admin rights before installing. Now both the server and clients are installed successfully. Then i logged into webconsole with the credentials and created the new users with all permissions and roles. I saved it and logged out. While connecting the Desig...

HI Trokosz, Thanks for your input. I have precreated userid with admin rights only for db2admin. Not for web sphere application server such as webadmin...while installing i gave webadmin with password but that is not precreated. so let me try precreating the webadmin with admin rights and start inst...

HI Trokosz, Thanks for your input. I have precreated userid with admin rights only for db2admin. Not for web sphere application server such as webadmin...while installing i gave webadmin with password but that is not precreated. so let me try precreating the webadmin with admin rights and start inst...

Hi Satya, I am instllaing the IBM websphere datastage v 8.0 in my machine with following configuration: windows 2003 enterprise edn with service pack 2. Java sdk, .net v 3, Ms Visual studio 2005 are the addn softwares installed. Enough memory space in C drive. I have given the required credentials a...

Hi chucksmith, Thanks for the info. I referred the doc and started installing.. I got the error message after 50% of installing as " An error occured while installing the domain components . For information see the log file" In the qsdomainasbapplication.log, i got WARNING: WebSphere Quali...