DSXchange

Hi, Could any one address me the solution for the view of wrong log report Sorry for the delayed response. I am doing only update in one job, and this job has only one ODBC stage which has property setting as: Data source name : DSN1 Password: PWD User: USR we have deleted DSN2 now which was another...

Hi, The query i am using is SELECT Col1 from Table1 where ADD_MONTHS(Col2,6) <= SYSDATE ." Where Col2 can be null for mannny of the records, This query is taking lots of time...Where as "Select Col1 from table1" takes lesser time for view data however... this query reads alll the reco...

Hi, could any one help me understand ,what should be taken care while accessing few records from a bulk of lakhs of records from a table using ODBC stage. As when i tried to SELECT on a table with lots of records in it the view data takes lots of time making the job get hanged. Please suggest. Also ...

Sorry for the delayed response. I am doing only update in one job, and this job has only one ODBC stage which has property setting as: Data source name : DSN1 Password: PWD User: USR we have deleted DSN2 now which was another alternative ODBC definition for the same database which DSN1 points to , b...

Yes the sequential file has all 8 as expected. I could see the update and delete are double. can it be becouse of two odbc definitions one being the replica of the other... As i am using one data source name (DSN1) for update , and there is one more datasource name which is refering to the same data...

When i try to update the records manualluy into the data base it updates well.... It updates for the records for which the update is asked for ....but not double time... If you replace your output ODBC with a sequential file, you will see that 8 records get sent down that link. The same applies to O...

The report says It has updated 8 records intead of 4 records, but when seen in the database it shows that it has updated 4 records only...

even if the key on which it has been updated is unique.

ray.wurlod wrote:The DataStage log reports what DataStage did. ...

You mean the Log report has insignificant information.Which should not be considered as one of an issue The log reports the number of rows sent along the link. What happens to them is no concern of DataStage's, except to detect errors. That is, DataStage does NOT report the number of rows affected. ...

Please suggest a solution...we cannot ask for increase in the lock table size ...its limited to 5000 records... This is the lock table in Progress, not the lock table in DataStage. You can discern this by the square-bracketed entries in the message; [ODBC] is the ODBC driver manager and [ProgressSer...

If i send records with acno (2,3,4,5,6) through ORCHESTRATE, and the number of records in the table are 2,3,4,5 only then record with acno 6 goes into reject link leaving 2,3,4,5 as updated...BUT THE LOG SHOW RECORDS UPDATE:10 RECORDS REJECTED:1 Updates are never rejected. You can issue a statement ...

Hi, While deleting records from a table of progress when i give a query: the table Savedreport has millions of records... DELETE PUB.Savedreport WHERE ( ADD_MONTHS(saveddate,6) < SYSDATE ) I get an error of : Fatal Error: [Open Link][ODBC][ProgressServ]Lock Table Full Please suggest me a solution to...

NOTE: No records are getting rejected

ArndW wrote:Does that mean after you put a reject link *some* of the acno=2 or 3 or 4's are being updated? ...

Yes all of the records passed to orchestrate are getting updated,I could see in the Table. I.e if i send 2,3,4,5 into ORCHESTRATE then all of them are getting updated which could be justified lookin into the table....BUT the Log in the director shows Number of RECORDS UPDATED as more than 4. Note:2,...

Putting a reject link makes the log to show a different count of number of records getting updated.....but no record is geting rejected in that case

ArndW wrote:Put a reject link on your ODBC output to see what error might be occurring on your update. ...

We are trying to update a table called Savedreport in infodev datasource of progress DB (Application DB Which supports SQL 92) USING ETL. 1) We need the query to be : UPDATE PUB.Savedreport SET dmr_limbo_date = Saveddate where acno = ORCHESTRATE.Acno Issue: This query updates only acno=1 (where ORCH...