DSXchange

I am using the logic which has mentioned above. Now I am facing one m more challenge. Can you please let me know how to avoid truncation of decimal fields / check lenght of decimal fields (Precision and scale) to fit the exact target definition?

Thanks I have mentioned the column size VARCHAR(30) in sequential File. Also I can view data (with Truncated data) in sequential file. Both Source and Target has same data type. Also Can you please let me know which function I can use to check the len of decimal, varchar etc... Please let me know if...

Hi I am using a comma seperated sequential file as a source. One the columns called "A" in this file has a datatype VARCHAR(30). The target is database and Column "A" is populating Column "B" of Database.(Size of B: Varchar(30)). If the length of the incoming field is m...

Thanks Girija. However we can set this Environmental Variable at project Level.

Is there any way to set the commit vaiable at each table / for Specific Oracle Enterprise Stage?

Thanks
bob

Hi

Can I specify commit interval (Rows per Transaction) in Oracle Enterprise Stage in Parallel Job?

If yes, can you please let me know how to set the number of rows before commit

Thanks
Bob

Hi I need to suppress the warning from sequence. I am reading a file using grep command. Warning is " SEQ_NAME..JobControl (EXECUTE_COMMAND_NAME): Command grep -v '^#' did not finish OK, reply = '1'" During testing our seq, this warning comes when the file is empty. Is there any method / c...

Hi VMC,

The option that you provided sounds good.

Thanks
bob

Thanks ray. I was thinking in different way.... :D

Hi Ray, Thanks for the reply. The resolution that you have provided is working fine. However I didn't understand if I define a field say "XXXX" as a KEY then how datastage allows us to make it NULLABLE. Because as per my understanding (Consider Primary Key) key should not containt null. Ca...

Hi, Can you please let me know how to use the HASH function / HASH algoritham in DataStage Parallel? Requirement: Pass 10 digit string to the function and the function will generate the UNIQUE number based on the input string. Example : Input Data Expected Output ABCD 1512 PQRS 7894 ABCD 1512 QWER 4...

Hi My job is designed below: Source (ODBC) --- LOOKUP --- TRASFORMAER -- FLATFILE (FIXED WIDTH). Warning : When binding output interface field "XXXX" to field "XXXX": Converting a nullable source to a non-nullable result; I am using a view as a source. 1) If I make the field &quo...