DSXchange

I tried with both the options -- UNIX and UV...

Both are not working.

Hi All, I have a sub routine which retrieves data from a table and inserts into another table along with other job statistics info. When i used this as a after subroutine in a job, it executes successfully, but the data is not getting inserted. the routine used is : $INCLUDE DSINCLUDE JOBCONTROL.H E...

To get the list of jobs in use... select the project and select command and type :

LIST.READU

This gets the Inode of the process I want to clear.

Then unlock the job using the Code:

UNLOCK INODE #node_number# ALL

Hi All,

Iam trying to write data to an hash file.It sucessfully writes data into it but when i try to view data its throwing error

Warning: Data that exceeds the maximum display length has been truncated.

can any one help me to resolve this issue.

Thanks
Harish

Just use to_date function as given below

to_date(column,'YYYY-MM-DD HH24:MI:SS')

I have the source data.I have to load the complete data from source to target using the bulk load(manual).Everytime when we load, the previous data should be delete and then enter the complete new data.Using bulk load manual strategy I have to delete and insert the data into oracle table. For this I...

I have the source data.I have to load the complete data from source to target using the bulk load(manual).Everytime when we load, the previous data should be delete and then enter the complete new data.Using bulk load manual strategy I have to delete and insert the data into oracle table. For this I...

The strategy is DELETE. I have to daily delete the previous day's records and insert the records(bulk loading) into the table

Which bulk loading is better in performance
1. Oracle 7 Load
2. Oracle OCI Load

I have to every time delete the table and insert the records. In #2 we don't have the option to delete the table in oracle.

We are updating 8lakh records based on 4 keys. we are also using a lookup and then updating into the target. Sofar the records are getting updated at a rate of 13 rows/sec. In order to increase the performance we have created an index with those 4 keys. yet the performance is too slow (13 rows/sec)....