DSXchange

Hi All, There is a requirement in my Project, we have source Oracle and Target SQL server. In both tables metadata same. Say in Oracle table 1 having columns Table 1 ------------------- A NUM 10 B Varchar 20 ------------------ Table 2 -------------- A Num 10 B Varchar 20 C Char 10 --------------- an...

Please let us know how to configure MS Access DataBase using ODBC connecter. is it possible to connect MS Acces using ODBC?
This is a new requirment in my project.

Hi All, Is it possbile to move files from Host server source to Host server target in datastage execute command stage or before or after subroutine. i am trying in my project but no luck. below is the code. mv source server path/*.txt Target server path | sftp -o StrictHostKeyChecking=no User@server...

Hi All, receivng below error when running from ABAP stage --> Tans -->FTP(stage). DataStage Job 1 Phantom 28984 Program "JOB.141697444.DT.1531745292.TRANS1": Line 134, Exponentiation overflow, zero returned. Program "JOB.141697444.DT.1531745292.TRANS1": Line 135, Exponentiation o...

Hi All, Is it possible to compare two records in DataStage, then decide what value to add to a new field on each record? For example, if Record 1 has an 'A' and Record 2 has a 'B' then, add a new field with 'Z' for Record 1 and 'Y' for Record 2. But, if Record 1 has an 'A' and Record 2 has a 'C', th...

Thanks.

Got this problem, the problem is with Userid. Id is Locked in SAP part.

Hi All, My job is like ABAP stage --->Trans'r--->FTP stage when running this part running fine in Dev, but when iam running in QA got following error. "IntransitShpmntSKU..XIntransitShpmntSKU: Internal error: function 'row_to_external()' failed" Any one have any idea please share. Thanks

Hi All, In my project, i am extracting records from SAP- with ABAP stage. when i am running job failed with error as below. Please help on this error to resolve. APT_CombinedOperatorController(1),0: Fatal Error: Fatal: ABAP_E_00007`:`Error while retrieving link property ABAP_E_00598`:`DSSAP Logical ...

Hi All, I have a requirement like, haveing three operations 10,20,30(3 inputs) i want funnel and store into target. o/p is row1: 10,material number,-,-,-.......... row2: 20,material number,-,-,-............ and 30 operation will include when certain Material Number will match and o/p will be otherwi...

Not yet... not sure whats going wrong in QA.. other jobs of same format are running fine in QA....

Thanks..

DS is 8.1 and parallel . server is in UNIX.

Hi All, For me also getting this issue but when iam running in Dev its working, but in QA giving below error, Please suggest... ABAPExtr_R3_MAST,0: Warning: ECC6_Extract_MAST_Dset.ABAPExtr_R3_MAST: ABAP_W_00220`:`CPI-C Login Error ABAPExtr_R3_MAST,0: Info: ECC6_Extract_MAST_Dset.ABAPExtr_R3_MAST: AB...

Please let me know , how to proceed , its urgent.. thanks in advance

will get data from source daily around 500k records.

Thanks your replay ArndW,

But we can't say what is MAX,small numbers.. any numbers will get from input file... this is main problem to solve..