DSXchange

hi
thank you very much for your reply.i got the problem.
thks

Hi I am still anable to track the problem.it is almost 2 days i spent for this problem.do you mean to say that this problem occurs in first transformer of tha job.how to go to project directory.please share your thoughts. thks -Inside your Project directory there will several directories for this jo...

Hi Thanks for your reply.i am not usiing link collector in my job.my job i am using sort stage,seq file and loading into OCI STAGE.this error is comming after insert sql in target. The input data is sorted and i used hash file for look up.if match found then load data into target. Is it possible tha...

Hi I am getting following error.i am wondering where i have to check in my job.error information is not clear to me. pl share your thoughts. thks DataStage Job 937 Phantom 8446 Program "JOB.2087327993.DT.1400364087.TRANS1": Line 343, Nonnumeric data when numeric required. Zero used. Progra...

hi thanks for reply. But in my input column is like 1234 | 2345| 234 |...... and i want my o/p as (pre 123) (pre 2345) (pre 234) ...... i think first i have to count for delimitors then can you tell me how to use feild function. thks have a feild xxxxx!yyyyyy .I want to format this string to (pre xx...

hi
I have a feild xxxxx!yyyyyy .I want to format this string to
(pre xxxxx) (pre yyyy) as output.where ! is my delimitor.
pl share your thoughts.
thks

Hi
I am wondering is there any scan or search function which searches for perticular key word .
Like i want to populate all data which matches with 'ADDED XXX' in a column.
THKS

HI
I want to convert ASCII value to decimal .which function i have to use.
thks

Hi
I have a MSC text column and i have to to parscing based on following conditions.

1.search for ( ) and then data in ( ) have intch code,PNO,text.if found populate this data in seperate columns .

can you share your toughts .
thanks
sai

Hi I dont have any delimitors between each feild in order to use the DS functions. can any one please share your idea for problem solving. thks sai I have a MSC text column and i have to to parscing based on following conditions. 1.search for ( ) and then data in ( ) have intch code,PNO,text.if foun...

Hi I dont have any delimitors between each feild in order to use the DS functions. can any one please share your idea for problem solving. thks sai I have a MSC text column and i have to to parscing based on following conditions. 1.search for ( ) and then data in ( ) have intch code,PNO,text.if foun...

Hi
I have a MSC text column and i have to to parscing based on following conditions.

1.search for ( ) and then data in ( ) have intch code,PNO,text.if found populate this data in seperate columns .

can you tell how i can do in datastage.
thks

Hi I designed a simple job to sort 2 columns from hash file to seq file. columns 1 key decimal(5) ex : 12345 column 2 varchar(9) ex 33510501U OR 33510501space. i want to sort column 2 .i used sort stage and tried different options.but it was not sorting correctly.can you share your thoughts. thks sai

hi
I want to take last 10 char from a input string and add 00000 before it to make 15 character length.i just appendbed 00000:input column.is there any better way.
thks
sai

Hi
This are not part of SAP BW.I want to know how it effects.
thks
sai