DSXchange

Hi All, Thanks for your responses, The problem was resolved and wanted to share the same with you'll, 1. I have check for the Monitor window and everything is closed.There was no one except me working on the Job. 2. I check in the Director for the Process ID and nothing was allocated so I checked in...

Hi All, I am trying to Delete a job which I have created and I am getting the following error message:- Message : Cannot get exclusive access to log for job <jobname> Could anyone let me know what's the issue about,This is the first time I am getting this error. I have checked by releaseing the job ...

At the end of a job, I want to clean a temporary table in oracle. I need to keep this table but a cleaning is necessary. Indeed, If we need to start again the job, data will be add to the table and data of my job of front are too old. Help me please!!! Hi , If your talking about a temporary table a...

Could we get a write up / documnet regarding the same.


Thanks
SMK

Hi,

You could a Sort Stage and set the required column as descending and then USE @OUTROWNUM = 1 in the constraint and get the data populated.

Hope this helps.

Thanks
SMK

Hi Roy, Thanks for your response. I have configured the .ODBC.INI file for the INFORMIX set up that is Data Direct 4.2 and not Wired Protocol Data Direct. After creating teh connection I have tested the connection and configured the same in uvodbc.config file. I donot have the INFORMIX Client instal...

Hi All, I have just strated using the INFORMIX database,I am working on DS 7.1 , I am facing a problem with creatinga Table on the INFORMIX db, I have Flat File which needs to be ported into the INFORMIX Db where I need to create the table,I am using the INFORMIX CLI Stage ,I have created the INFORM...