DSXchange

Hi All I have a DS Parallel job in (DS 11.7.1) with 3 Sequential file stage,3 Transformation Stage,1 Funnel and Output to a Dataset. 3 Sequential file has different layout. But using Transformation stage we got all Fields into one layout. Then sending those 3 outputs to Funnel. But the Funnel output...

SELECT CHAR(RTRIM(CHAR(293))|| RIGHT(RTRIM('0000000000'|| SUBSTR(CHAR(Column1),1,10-(POSSTR(CHAR(Column1),'.')))),10))

Hi Please could any one can help me in this i want equivalent DB2/sql query for the logic.This logic is in datastage so i want it as sql query: Logic: '12345': PadString('','0',(10-len(Field(trim(Column1),'.',1)))):Field(trim(Column1),'.',1). Note: Column1 has the datatype as BIGINT Column1 input da...

Hi

How do i copy a DataSets from old Project to New Porject they are on differen servers.

Please could any one help me in this

Thanks
k

Hi chulett

I am intersted to know what will be the steps it compar the difference betwwen the jobs in Version 8.x. Please could you help me.

Thanks
kumar

Thanks Ray

But we dont want to read the file in single VarChar field, is its possible to do it in different way.

Thanks

Hi please could any one help me in this following issue. Input file with || format a||b||c||d||e 1||2||3||4||5 g||g||e||6 in 3rd row after 6 there is missing || Following is small job Sequential File Stage---->Transformer------>Sequential File | | | Reject In Reject file i am able to see the 3rd row...

Hi Please help me in this, I know that match designer does not give the pass statistics for large amount of volume to get percentages for matches, clerical and residuals. Is there any way to calculate the percentages of matches, clerical and residuals for large amount of volume to get the pass stati...

We got solution for SIGBUS issue. we need to have oracle EE patch, this makes SIGBUS issue solved.

Solution installing the Oracle EE patch:
http://www-01.ibm.com/support/docview.w ... wg21395472


Thanks
k

We got solution for SIGBUS issue. we need to have oracle EE patch, this makes SIGBUS issue solved.

Solution installing the Oracle EE patch:
http://www-01.ibm.com/support/docview.w ... wg21395472


Thanks
k

We got solution for SIGBUS issue. we need to have oracle EE patch, this makes SIGBUS issue solved.

Solution installing the Oracle EE patch:
http://www-01.ibm.com/support/docview.w ... wg21395472


Thanks
k

Hi

Thanks for your reply, the New Oracle Database version is 10g and the Old Oracle Database is 9i. Please help me to fix this problem.

Thanks

Hi we are using a datastage job that loads the data into a table using OLD Oracle database, when we load the data into old Oracle database we dont have any issue with crating & loading the data into a table, but right now while we are trying to load the same job with same data pointing to New Or...

Hi we are using a datastage job that loads the data into a table, when we load the data into old database we dont have any issue with loading the data into a table, but right now while we are trying to load the same data into new database we are getting the SIGBUS error. i Tested to load a sample da...

is it safe to delete the log files from /opt/IBM/InformationServer/Server/Scratch, please help me

Thanks