DSXchange

How to clear &PH& files, Please help me.

Thanks for your input. Sad part is i am not using Oracle 7, It's Oracle 10. I could able to connect the new oracle db server & Oracle DB from Unix Server(Where DS is installed). I could able to do write select,insert commands from Unix Server.

Hi, I wanted to connect to a new DB Server, so i added the entries in UVDOBC.config and .odbc.ini files and got the following error. ODBC_2: DSD.BCIConnect connecting to ictp, call to SQLConnect failed. SQLSTATE=08004, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol d...

Hi,

Since you are converting NULL values to 0 in your query setting up the Null property at aggregator doesn't have any impact. Hence you are getting the same result.

Lookup is ODBC stage, How about source? Is it again ODBC?If so, can you join both table in source ODBC through SQL query (Make sure performance is not affected), if so no need to have the look up.

When you are adding environmental variable in job, directly it will apply the value set from environmental variable. To reflect the change, instead of having value of environmental variable, mention this $PROJDEF. it will take directly the value from environmental variable. Please see the below defi...

Remove the routine from transformer stage, let the job complete. Change the routine to pass the file name as parameter and in the routine write the result (row count) in the file. Call the routine after completion of job through After-Job subroutine. Hope it will help you.

It could be either Data Base or Network. Check with Database, Call a Stored Procedure which runs for more than 20 minutes (Since you speicified 20 Minutes) through toad or sql plus, after 20 minutes if SP is running still (You can use DBA to check the process), then talk with your network admin. If ...

No need to issue Commit while Truncating. So check with some other process when it happens as well check with your DBA.

Chulet is right. One process might require exclusive access to the table (Might be for truncate table) but another process might have hold the table for inserting record. So the first process waits for the table for the specific period, if it didn't get the acess then it will result to your error. S...

Write a Stored Procedure and check for the existence of record for current day, if it's available throw an exception else insert a record in control table then it proceed as you want. Call the Stored Procedure from job. Hope it satisfies your requirement.

Please correct me if i am wrong, You are not able to see the value of one column through toad but the length of the column gives the correct value. If so try to see the data from SQL prompt. As well view the data from sequential file from Data Stage Designer (Sequential File --> View Data) and check...

I didn't say you are referring Version 7. I just told the difference. Load will work as Oracle Bulk Loader. Hope it clears.

What are the info you are passing from Sequential File to Transformer and then to STP. Just curious, Are you passing any db details (Login, Password, Schema) from sequential file?

Login to Data Stage Administrator and Enable the property which is at Project level.