DSXchange

I have tested the same senario , created table called SAPSLP./GKV/CM00_PROCU with one field REG_NO. It is working fine using this command in Oracle Stage : select REG_NO from "SAPSLP./GKV/CM00_PROCU" and one more created table /GKV/CM00_PROCU assume SAPSLP is schema name than use below com...

Yes. It is possible using schema file (this is for reading seq file to writing into table). Only one DS job is enough for that you need to pass schema file name and tablename and anyother parameters.

can you able to view data in seq file .?

Make sure Database (Oracle) should be up and running while DS jobs are running.

Transformer stage you might be using wrong calculation or tryning to stror different datatype value in target.

Using below command you can get machine name who is loggin in datastage:

netstat -a | grep servername.dsrpc

Sample :

netstat -a | grep UATDS.dsrpc

Tony , You are correct. There is no other reason to make it slow.

Might be below reason:
1. Check TABLE is getting lock while loading in case.
2. Please provide what kind of operation performing in Transformer stage.

Do pre-Sorting in oracle itself before creating dataset and then try.

Based on any condition you can do it. For example this 7 jobs is reading file and writing into table means you can put condition if the table is empty you can continue otherwise come out.

You can put all the jobs in one Parallel job if job parameters are common and the run this job. So all the jobs will run concurrently.

There will not be any problem. Because Jobs are already exported from Production and now importing to DEV. But jobs are running in Production.

We can check from Director for the particular job.

Try this :

StringToDate(DSLink100.PalanedDeliveryDate,'%yyyy-%mm-%dd')

Please provide what is error message are you getting?

Try like , Pass date param as string and then chagne your query like this. to_date(#Start_Date#,'YYYYMMDD')