DSXchange

I think 'all' is a reserve keyword you are trying to assign to count(*)...
Please try some other name like

Select count(*) as A from ABC.X_CONTACTS where XID = 'RVH'

Thanks,
Anupam

When i rename jobs by updating DS_JOBS... I got new name jobs in designer but i think when i complie jobs i got those problem..
any suggestion to rename jobs ..

Thanks,
Anupam

I deleted rename jobs CATEGORY from DS_JOBS...
now i able to view all old jobs from desginer but i lost old rename jobs...

Thanks,
Anupam

I tried to excute SELECT DISTINCT CATEGORY FROM DS_JOBS

i found last record with

Attempted WRITE with NULL record ID
Aborting!

Thanks,
Anupam

Do you mean to say, Old jobs, still exist along with new names :shock: Can you provide the update statement used? Have you reindexed only DS_JOBS or ALL after renaming DS_JOBS. Rename jobs are not in DS_JOBS but Old jobs that are not rename are still in DS_JOBS UPDATE DS_JOBS SET NAME = 'Prefix':NA...

Ouch... there's more than one place to change that, doing it only in DS_JOBS blew your RI in the project. First off, I'd suggest you undo that change to get everything back... However, with all the other monkey shines like reindexing, I wonder if that is even possible anymore. I'm not sure what thi...

kumar_s wrote:Have you updated DS_JOBOBJECTS accordingly?
You reduilt indices for ALL or for DS_JOBS?

I updated DS_JOBS to rename jobs acording to CATEGORY column as i tried for only one category.

I reduilt indices for ALL

Thanks,
Anupam

Hi all, There was requriment to add prefix job name I updated DS_JOBS with that prefix When i open first time from designer i got error with file name not in DS_JOBS but all jobs got rename and i was able to open but when i tried open jobs next time all jobs vanish I was not able to create new jobs ...

I think DTS package is better option if there is direct tranformation without any cleansing operation as it comes with database.....

Thanks,
Anupam

Error is related to oracle database please check with your DBA.


Thanks,
Anupam

rafidwh wrote:I need only to delete matching columns

It will delete matched row as you can see in sql view ...

Why dont you try in test enviroment....

Thanks,
Anupam

rafidwh wrote:But I want to delete that row completely from the table

yes it will delete....

If you see query in view sql there you can see that whatever column you made as key come under where clause of delete statement. and insert is as usual ....


Thanks,
Anupam

rafidwh wrote:Hi Anupam,
you mean to say that I should define the non key columns in the table as keys in the job and select the delete option from the update action from oci ,with out putting any logic?

Regards,
Saik

Yes with Update action as replace existsing row

Thanks,
Anupam

Please make rest of column col1, col2,col3 and col4 as key column also in datastage column defination tab...... I'm not sure what you mean by this suggestion - it won't affect the actual DELETE command at all. I mean to say use update action as replace existing row ..... in ODBC and make rest of col...

Please make rest of column col1, col2,col3 and col4 as key column also in datastage column defination tab......


Thanks,
Anupam