DSXchange

Hi All,
I have to create a audit file with the following details in xml format.
filename, file size, number of recs.
how can i know these details without using unix.
is there a way for this or have to do with unix only.

Regards,
Pranay

Thanks everybody for the reply.
if someone has the xml guide, can u send it to me.

Hi All, This is the first time i am trying to create a xml file using datastage. For testing i tried making the following job txt file ------> Transformer ---------> XML Output stage. I just gave one column in the input as well as in the XML output stage. The job ran fine with no errors or warnings,...

Thanks Ramesh for the valuable suggestions. you can send the dsx to me at kpranay81@gmail.com. Also i need to have one output file per year with 12 month fields. At DSXchange we dont guarantee that solutions to problems will be given , helpful suggestions and hints are somethings that you can look f...

Hi ramesh, Could you please send me the stored proc for the same.

rameshrr3 wrote:easier to process using rdbms stored procedures.

Hi All, I need to implement something like this : I have a table that contains empid, monthyear and salary. the primary key is the combination of empid and monthyear. Here's the data in the table 101 Jan 07 5000 101 Feb 07 4850 101 Mar 07 4850 101 Apr 07 4850 101 May 07 4850 101 July 07 4850 102 Feb...

yes u need to give arguments to the procedure, let it be dummy. Also it won't display logs in the director, the logs pertaining to proc can be viewed by database dba and not through datastage. Hi, I am using oracle enterprise stage as the source to Oracle. I have to excute a stored procedure before ...

i also have faced this problem before, what i did is used a If condition something like this to test for the null value, u might use a compare function or a len(trim(col_name) function. Let me know if it solved your problem or else i can provide u the exact if condition. if len(trim(Lnk_Concat_Xfm4....

Which of these approcahes is better and would give good performance. And also would be as per the standards. Any experts who has worked on such a type of project please provide ur inputs. Eagerly waiting for your inputs. Thanks, pranay Hi You can use aither of the approach :idea: 1. Provide Flatfile...

we just have to load the FI data for GL not for FA, MM and etc.. and data needs to be loaded for just on BAPI. Now my question is should i give flat files to SAP developer and they can load it using ABAP code or should i use datastage pack for sap r/3 and using bapi load stage to load data. The code...

Hi All, This is the first time i am working on SAP. I have to load the General ledger module data of SAP from flat files. What's the best way of doing it. I in consultantion with SAP developers found there are 2 options. 1. Datastage can create the Flat files in the format as required by the SAP and...

is ur problem resolved. you need to create the stored proc in the database first and then call it through datastage. the first stage would be a ODBC stage with a user defined SQl. The SQL can be anything that returns atlest one row and can trigger teh job. Lets say it can be select 1 from Dual. The ...

is ur problem resolved. you need to create the stored proc in the database first and then call it through datastage. the first stage would be a ODBC stage with a user defined SQl. The SQL can be anything that returns atlest one row and can trigger teh job. Lets say it can be select 1 from Dual. The ...

you need to create the stored proc in the database first and then call it through datastage. the first stage would be a ODBC stage with a user defined SQl. The SQL can be anything that returns atlest one row and can trigger teh job. Lets say it can be select 1 from Dual. The column defination can be...

the first stage would be a ODBC stage with a user defined SQl. The SQL can be anything that returns atlest one row and can trigger teh job. Lets say it can be select 1 from Dual. The column defination can be a single column temp. Pass thsi column to the next stored procedure stage. in the stored pro...