DSXchange

Hello All, I am using Sybase OCI stage for database connectivity in our jobs. After searching through the earlier posts and queries I could not get a satisfactory answer to the following questions : :?: 1. How does the Sybase OCI stage internally connects to the server. Are named pipes used in the O...

Hi All, I'm facing an issue to perform a validation in my job. The job reads an input file and validate one of its fields against a look-up table. While validating I need to see if this value exists in the look-up table and if so, I need to fetch other column's value from the lookup table and mark t...

Thanks very much Ray and lstsaur to provide me the necessary information.

Hi Everyone, I am wondering where the table 'MetaStage_Loc_Info' resides.There's no such table existing on the database. I had a look on earlier discussions for the same where Ray Wurlod suggests that "The job is running in MetaStage proxy mode, and DataStage is attempting to determine informat...

Hi, I'm executing a job on DS 7.5 migrated from DS 7.1. Issue : One particular job is unable to load the data from a file kept at some specific path. The file has got the required access permissions. However, the file data can be viewed from the Designer by specifying the file name and the same path...

Abby, what stage are you using to write to which database and what is teh warning message you are getting? I am using SybaseOC stage for database insertion into the Sybase Database and the warning message looks like : "Sybase Server message 0 (severity 10) from stored procedure 'ti_counties', ...

Hi All, I'm observing a strange problem to handle the return value from one of the insert triggers. I'm trying to insert some records in a table with key column having auto-incremented Id value. So, for each insert the insert trigger returns the next Id value which I'm not aware how to capture in th...

Hi folks, I am trying to execute a simple update query like : Update <tablename> Set <column_name> = <new_value> where <column_name> = <old_value> But, I am stuck up when the column to be changed is a part of composite key for that table. Since, the generated query for Update statement will pass onl...

Hi, Placing a @NULL as the derivation of a column in a transformer stage should work, if the column is nullable by DB definition. When you say a mandatory coulmn I assume the column is defined as not null in the DB which won't allow this kind of data, or rather lack of data in the column. So if you...

Thanks for the prompt help !!!!

It really worked....and the problem seems to be rectified now.

Hi, I have been struggling to insert a Null value into one of the mandatory column(which allows Char data only) when no value is passed to it. The problem area is : I am trying to load data from a sequential file to the Sybase database. The last column in the row is mandatory but if no value is pass...

Hello ArndW, Thanks very much for the inputs!!! Well, as far as locks are concerned there were no locks on any of the tables in use. Also, the Director logs does not provide any information on the number of rows processed. Apart from this, there are no capture files created against the required user...

I have encountered one issue wherein an insert job(in the sequence) kept executing for a long time (abt 5 hrs) without actually affecting the table. Before this insert operation, a delete operation(in the same sequence job) was successfully done on the same table. I am not sure as to why this insert...