DSXchange

Ohk. So you mean to say, that module should be installed at SAP side. And during installation of that SAP package in DS administrator will import that facility to DS. We will simply use that in the ABAP Extract stage in our datastage, is my understanding correct? You told about searching for the nam...

Hi All I am developing a DS parallel job. There I am trying to extract from SAP R/3 table using ABAP Extract stage. There in the OUTPUT page in General tab I have defined the valid SAP connection and Logon details. Then on Data transfer method tab I have used CPI-C as the method. Then on ABAP Progra...

Hi My requirement is to ftp a sequential file to mainframe from datastage. Where the file has been created in datastage and stored in unix folder location. I tried with FTP stage. But not much aware about the properties and activities of this stage. Can some body please help to under stand how does ...

Include the environment variables in your job design as job parameters (click the Add Environment Variable command button). Insert the job parameter reference where required in your Connector. ... Ray .... we have tried the same in our job but it has not worked. The job has not run with those param...

I have worked in a parallel job where I have included some environmental veriables as the job parameters. Then in the job I have added one ODBC Connector stage. Now in the connector stage we have options to include the environmental veriables instead of hardcoding them. So I included the environment...

Hi All I have written a parallel job in datastage where it will read one sequential input file and will generate an XML output file. In the seqn file I have three records SKU, SellYear and RIF. Now the scenario could be for two different SKU the SellYear and the RIF could be same in the input file. ...

Hi

I got your point.......but the thing is how can I incorporate the logic that each file will have 60000 records, can I code it any way in an automated fashion?

Or is there any stage available where I can code this out?


Thanking You



:D

Hi

I have tried with the solution but still it is not clear. It seems that XML Input stage does not have this trigger column and output mode......it is present in XML Output stage.

So while designing the stages how and where can I code that 60000 record length to split that file?

Hi All I am trying to create one job which will split one incoming xml file into several xml files depending on the record length and I need to do this job in an automated fashion. Can any body help me in this, how I can achive this? The scenario is, Say I have two text files.......... "test1&q...

Hi Friends

Thanks for Help.

It has been done successfully.

Thanks again for this enormous help.


Regards,

:D

Hi I have tried with External Source stage. There it is able to read the input xml file and feeding it to the XML Input stage. Then in the XML Input stage in Input tab I have selected XML source column as the column from External Source stage and Column Content as URL/File Path. But the point is how...

The External Source Stage has not worked......
does any body know any other solution around?

Hi I have tried to use External Source stage. There in Properties tab I used Source Method as Program Files and Source XML File as "test.xml" with path. Then in Format tab Record Type implicit and inside Field Defaults Delimiter as none. But in Column tab what column shall I use, Columns s...

Hi We are trying to create one parallel job where we will read one XML file as input into a XML input stage for further processing. In Datastage 8.0 version we do not have any Folder Stage option. So the trick which we have used is,we first used one sequential file stage where we read that entire XM...