DSXchange

I got a solution. It solved my purpose of removing ^M.

Use Iconv("Column where ^M is present", "MCP")

With MCP option ur problem will b solved ... :D

Regards,
Asish Koyya

Hi ray I tried the first method.. have set the Final Delimiter property to \R but didnt work out.. one morething i observed is ..when i used record delimiter strins as : DOS Format..it was working fine.. but im not sure whether if the source file is ftp'd from windows to unix..does it have unix new...

Hey Ray....

Basically i know nothing about SAP BW . So i dont understand what is 'row size of tranfer structure' means!

If that is some problem in from SAP then i could inform concerned people and get it corrected. Please some one let me know.

Thankz.

Use following script to gzip the .csv files..

for i in `ls -l *.csv |awk '{print $9}'`
do
gzip `echo $i`
done

and following script is to regenrate back all csv files to normal.


for i in `ls -l *.csv.gz |awk '{print $9}'`
do
gunzip `echo $i`
done

Hey jus use gzip *.csv

all .csv files will b zipped to *.csv.gz
Number of files will be the same..

then u can use gunzip *.gz to restore all files.
Check this.

Hi all, I am facing a problem while extracting the data from BW OPEN HUB Extract plugin. I have selected proper Connection and SourceSystem parameters. Also selected required process chain name and InfoSpoke. Following is the error which is shown in the logs: - "BWExt..BW_Extract_Stage_42_2: ER...

Hey kumar that was very useful to me..

U have mentioned abt

You also have option to retrive from UV.

I have following query running currently..

SELECT NAME, CATEGORY FROM DS_JOBS

Can I get Invocation list in the query itself??

Please help me in this regard..

Thanks once again...

Director. Status view. ... Thats really funny.. I forgot to mention one thing.. I need to view the information from unix level... Above procees is a manual intervention. I need this to be automated.. I cud get information about other jobs which are not multi-instanced.. but i m unable to fond infor...

How can i get status of a multi-instance jobs???


Thanks...

If i have jobs with the names Job1.1, Job1.2, Job2.1 and Job2.2 These are 2 Multi-instance jobs which are run with Instance numbers 1 n 2.. How can i retrieve thier names from universe?? i.e. I need the names Job1.1 , Job1.2 , Job2.1 n Job2.2 as output.. (I dont need output as formatted as i have po...