DSXchange

Hi All, We are using datastage 8.5 ,and using oracle connect stage we are reading data ,and have one CLOB datatype colum which is taken as longvarchar(4000).but still i face error as below The OCI function OCIStmtExecute returned status -1. Error code: 1,461, Error message: ORA-01461: can bind a LON...

we can also use remove duplicate stage for refernce link to avoid the duplicates

As indicated by Guru-- Andrw, Sorting & partioning are the pre-requisites for Join stage.

Note:If there is more than one join key used, make sure that the order of the keys defined in the both input links should be same order ,else it might give inconsistent results.........

Thanks ray..

Hi, Iam using the DRS stage for delete and insert process to oracle table with update action as "Insert New rows Only" .In before tab , i need to delete based upon the incoming values . Is it possible in DRS stage. When i mention harcoded values ,it works properly.Please let me know how to...

I is googd to do trim on varchar columns too.Recenlty i faced a problem while inserting the data into oracle table which shows error "Statement parsed".Once after doing trim on varchar columns,the insert job finished successfully.

write to the text file...

Hi All,

How do pull the source and target meta data from all jobs across the project.Is there any option and method to do this


Thanks in Advance!

While the data is loading into DB2,convert it to Integer in query by cast function...

Use modify stage and keep the column sql code and write it to the file..

It throws warnings in the job for sequential file to handle nulls...

Datastage Enterprise edition have the facility to specify the nodes on which the process has to be carried out. Node pool constraint is the Datastage property used to restrict stages to use particular nodes only. For example, Datastage parallel job having basic transformer will fail in the distribut...

1)check weather the column metdata is correct in the seqfle

2) give dos format for "record delimiter string" inseq file options

try this once

hello,

Convert the decimaltype to varchar to avoid the zeor's

you need to bring the date format asyyyy-%mm-%dd' by using to_char option in query. Giva a try