DSXchange

Hello Everyone, I have below requirement in one of my job, can someone please let me know the efficient way to work on this. Column1 Column2 123 First 123 Test1 123 Test2 123 Test3 Column1 Column2 Column3 123 First Test3 If only one record with key value then Column3 is null I thought of using 2 rem...

I can't do the inner join as I need to get all records from the left table.
There will be multiple records in the right table for one perticular key value.

Thanks
Suresh

Hi All, In datastage job I reading a file using the SEQ file stage. file has Header and Footer in it along with column names. 1st record is Header 2nd record is column names last record is Trailer record I'm using sed command in the filter comand of the sequential file. Previously we use to read the...

I'm having "_" in the passwd.
passwd is : bwcm_ws_etl

Thanks and Regards
Suri

Hi, In one of my jobs Source, lookup and target are Oracle Enterprise stages. Job is getting filed for the lookup stages (Oracle Enterprise stage) because of below error. I able to connect with same user_id and passwd from database tools. Is there any do I need to cofigure for doing lookup. Please l...

Hi All, I have created a job which is loading into a file. I am getting the required output but in couple of records from column 3 it is moving one column a head. ie 3rd column is becoming null and 4 col will have 3rd column value, 5 will have 4th value and soon. Column 1 and 2 are hardcode values. ...

rpc services are running and I am able to run dsapi_server. I am getting error when trying to run dsapi_slave.


Thanks
Suri

Hi All,

I am getting following error when i try to connect to Datastage Director.

(The connection was refused or the RPC daemon is not running (81016)

Can explain me how to resolve it

Thanks
Suri

Hi All,

Can any one explain me the difference between Sequential File stage and Dataset stage in parallel extender.


Thanks in Advance
Suri

Hi All,
Can we call server routines in paralle. I know they use different languages and different compliers. I am wondering is there any way to use server routines in parallel.

Thanks in Advance
Suresh

Thanks for the help,
Here I need to do the comparision between each and every column of the source table with each and every column of the target table and if there is any difference in atleast column also ,the whole record should be rejected .

Hi ,
Does anybody tell me to how to do compare the source and target data and reject the records into a file which does not fond a match and also the count of the number or records matched and the count of the records that are not matched.
Thanks

Hi,
I want to move(stright move) Sybase data to Db2. Do i need to write SQL at Sybase stage (since sybase support 23 lenth of timestamp where as DB2 26) or shall i move directly, is datastage take care of padding with 0.


Thanks
Suri

Hi,

I am new to this tool and I need some help.I want convert the Rows to Columns and Columns to Rows, I need to write Routine or is there any other way in Datastage.


Thanks
Suresh

Hi
I woud like to know what is the difference between lookup stage in mainframe and Hash stage in server.


Thanks
Suresh