DSXchange

Hi Sant, I must copy the data in a new file named Balance_CG_yyyymmdd.csv and empty the first file. You can copy the data into a new file by simply using a transformer after you read the old file and then write to a new file called Balance_CG_yyyymmdd.csv in a sequential file stage. By emptying the ...

Hi Tom,

You can use the Index function.

Hi NaveenD,

Good that it worked out for ya :D

Hi Vinay, If you are using SAP R/3 Pack to extract data from SAP 3.1. Then it will not work. It seems that the SAP R/3 pack is not compatible with SAP 3.1. However, it works well with the higher version SAP 4.7. This problem was reported to the Ascential Support and they did confirm the incompatibil...

Welcome Aboard :D ,

Yes, user defined routines can be called from other routines. This topic has been covered in this Forum many times. Please search the form using keyword "Deffun".

Hi,

This topic has been covered several times in this Forum. Please search for shell script output.

Here is one such link viewtopic.php?t=93768&

Hi,

Try running the same SQL in oracle and see whether it still selects that 2003 record ?

Welcome Aboard :D ,

Try to use VarBinary or VarChar to read it.

There are a lot of posts dealing with the topic you have asked, please search the forum for more details.

Hi,

What database are you extracting the records from?

Hi,

Can you tell me which version of SAP that you are trying to extract from?

Hi Vinay, I believe that your SAP R/3 Plugins are not properly installed. Try to reinstall the SAP R/3 Plugins. When its properly installed, the ABAP extract plugin should have a bulding icon with the words "ABAP Extract" written on it. Also make sure there is an output link from the ABAP ...

Hi,

If you dont want the ID field in the ouput, pass your merged output thru a transformer and eliminate the ID field in it and then write to your final output.

Hi NaveenD, I wasn't able to reply earlier as I was busy with my work. Anyway, here is your solution 1) Declare two Stage Variables and in their derivation column, inlcude the below condition Derivation Stage Variable InLink.InCol NEWVAL If @INROWNUM =1 OLDVAL Then "" Else NEWVAL:OLDVAL 2)...

Hi Vinay,

The @INROWNUM =1 condition that he used prevents from sending the email 10 times.

Hi Munish, Hopefully, if you have any metadata column in the reject table, that can uniquely identify the reject records inserted in a particular job session. You can use an user defined sql in an Oracle DB stage and get the counts of the number of reject records inserted into the reject table, for ...