DSXchange

Try this..

Trim(date column, """, "A")

Regards,
Solai

kavuri wrote:Hi,
I am having some of the fields Varchar and date fields are enclosed by double quotes in my terget csv files. I want to eliminate them. How can I do this?

Thanks
Kavuri

Hi,

We faced similar problem in our project,by changing NLS settings to UTF8 or ISO***** solved this issue.

Thanks

Hi,

Change datatype of this column to VarBinary in source/target stage then try.

Sai

Tai,

Change that column data type in DS input and output stage to VARBINARY.

Thanks
Solai.K

Hi, I am getting this warning message. I have used Pipe option in sequential file and around 300 columns in my table. DataStage Job 710 Phantom 24157 Program "JOB.219801040.DT.1406549881.TRANS10": Attempting to Cleanup after ABORT raised in stage DataStage Phantom Aborting with @ABORT.CODE...

Hi,

It is not problem with datastage. First execute dos command manually and check whether it is working fine or not.
In our project we faced same error while executing shell script.

It is an reusable component. It is also like job . You can use it in any job in project. Local container u can use in one particular job.
Edit - Construct container -Local/Shared

Hi,

Using vmdsrpos.dll how to run the jobs.

I know using "StartNow" function of "ExecJob", but pls let me know how to pass the param object to start the job. And I also like to know how to change the default values before running the job.

solai

We are calling shell script through ExecSH this routine in job control but that script is not running goes to next control.When i see in director shows "No command output". urgent.

Instead of sending all records through one transformer and loading to flatfile . Shall i use link partioner split rows to 2 or more transfomer then using link collector loading data to flatfile avoid this problem?.

Solai.

Thanx Arndw. I will try this options.
Solai

Hi,

When we loading data(29 million) from oracle to sequntial file it gives rollback segment error.if anyone faced this problem pls tell me the solution for this.

Solai[/i]