DSXchange

Hi Reddy, I dont know much about the chemistry between SAP R/3 Pack and DataStage 7.5 Px, as I am a software engineer :wink: . In the SAP R/3 Pack, there is a stage called ABAP Extract Pack 1) This has a SQL builder, which will help you build the SQL query to extract from the various SAP Tables. 2) ...

Hi Ketfos, Here is some Info regarding an IDOC An IDoc (intermediate document) is a report, that is, a hierarchal package of related records, generated by SAP R/3 in an SAP proprietary format. An IDoc, whose transmission is initiated by the source database, exchanges data between applications. It pr...

Hi dhiren, Your requirement needs to be more specific, for us to be able to help you more. Can we assume that the number you want to extract is always at the end of the string? Now if i make the Code to answer most likeliest of possibilities, then the numeric string will be last one or two character...

Hi dhiren, Do you know the maximum size of the numeric value that is embedded in the string?. Can two numbers occur next to each other? If you dont know how big the number can be, it is not possible to extract it. For Example COROMN13198POIUT1234 If you dont know the size, what would you expect to b...

Hi Joshen, Are you using the ABAP Extract Pack to extract data from SAP tables?. If so, check whether the ID that you are using has authorization to do a select on that particular table. In which stage exactly are you getting this error?. If you tell us your job flow, it would be easier to troublesh...

Hi Pavan,

In that case, you can still use Craig's solution, but instead of just sorting on UPC alone, you need to sort on both venue column and then the UPC column.

Thanks a lot Ken. :D

Hi Guys,

Could any of you please enlighten me on the various differences between DS Tranforms, DS Routines and Functions in Datastage?.

Hi dslearner,

Its always a good practice not to abort a job. Instead you can use two jobs, first job to check your condition and second job to actually process the data. In a job sequence, you can run the first job and depending upon the result, either run the second job or not.

Hi Emilio, If you want to remove duplicates in each column, then you need to make all of them as key columns, before you write them to a hash file. But, you need to keep in mind, that in this method follows destructive write and only the last one wins. After you get all the unique keys into a hash f...

Hi Emilio, In the aggreagtor what I meant by this "You can use the aggregator and the count > 1" was the below For each key column you need to define a dummy column and group on the key column and use the count aggregate function to populate the dummy column. After you do that, you need to...

You can also use some sort of sleep statement to delay the execution of that particular stage.

Hi Emilio, There are several methods to remove the duplicates. Below are some sample approaches 1) You can define all the columns that you want to remove duplicates from as key columns and write them into a hash file. 2) You can use the aggregator and the count > 1 to filter duplicates 3) You can al...

Hi,

You can use the below transformation.
Where 16 is the total size of the column

Hi,

After you insert some rows into a DB2 table and commit the changes. You should not have any problem reading the commited changes in further stages. Whether you are doing this inside a shared container or not, will not make any difference in the above behavior.