DSXchange

Why not use APT_STRING_PAD_CHAR (0x20) in your extraction job (the one that loads the DataSet) also? That should make the filter on the CHAR(6) field work as you expect.

Why not use the ExecSh built-in routine in the Routine activity from the sequence? This way you would be able check if the script executed successfully or not, based on which you can abort the job as well as the sequence.

Multiple recipients are possible. Email ids are to be comma separated.

In the custom BAPI how the actual BAPI name is passed i.e through import parameter or the custom BAPi was built only to call that BAPI.

Not possible to create a generic trigger BAPI. A custom BAPI would have to be written each time you want to trigger a BAPI from DataStage.

Aneesh

What's the datatype and the value of the "Run_Type_Parm" parameter that you are passing for the job run?

Concatenate a time component - say " 00:00:00" with the date value and then convert this entire string into a Timestamp and load into the target timestamp field. Make sure to put in a space between the date and time components.

This should do it!

Make sure that - when you do a view data from the Sequential File stage, set the Skip Count to 0 (zero) and Period to 1 (one), in the pop up box. The maximum rows that you can view from here is 9999. @ArndW i can see only the alternate rows... i.e 1,3,5 etc from the slection though the link is howin...

You can define the file name and file paths as Arguements in your routine. The output from the DSMakejob & dsjobreport can then be directed to this file.

Check out the DSJobReport routine code -available as a Built-in After/Before Job sub routine in DataStage - to get an idea.

Aneesh

We havent been able to do that succeffully till now, and I am not sure if this is possible through DataStage. When you call a BAPI in DataStage (to load a set of records) - for each of the input record the BAPI is called. This hits the performance very hard. Moreover - there is a time out period, wh...

How do you want to load it - only header? header and detail both? or only detail? In any case, you can use the Sequential Stage and choose the Stage uses filter command option to specify a filter command (using grep command) to read either the header or the detail. If you want both header and detail...

Compiler - APT_COMPILER Compiler Options - APT_COMPILEOPT Linker - APT_LINKER Linker Options - APT_LINKOPT You would have got these by looking in the Administrator or the Advanced Parallel Job Developer's Guide. Hi , I am looking for the enviroment variable names where compiler and linker options wi...

There is no built in function to check the validity of dates in Server jobs (parallel job have the IsValid function). But you can use the Oconv/Iconv functions for validating the incoming date. One way to go about this would be - If OConv(IConv(<inputDate>, <conversion code>), <conversion code>) <> ...

Thanks for the correction Ray!I totally missed out the Lookup FileSet and Sparse Lookup angles. Was just thinking of the normal Lookup. :( Aneesh Why not, thebird? Sometimes it must, for example when doing a lookup from a Lookup File Set or when doing a sparse lookup. The message about dropping a co...

scorpion wrote:Thanks For the reply ray,
main link column name is as same as reference link column name.

A look up stage should not have the key column names same in its input links (primary and reference).

Hi, Can someone please help me understand when ABAP stage should be used to extract data vs. BAPI? What is the main difference between these 2 techniques? ABAP Extract stage generates ABAP code from the SQL that you provide for extracting data from the R/3 tables. This ABAP program is then loaded o...