DSXchange

Hi Guys,

After executing a shell script using Execute Command stage in job sequencer, How do I capture the output value returned by the shell script and pass it on to a server job, without writing it to a sequential file and again reading it? Is there a direct way to do it?.

Thanks,
Naveen

Hi srikanth,

Even in PX jobs, the sequential file stage has an item under options ( First Line is Column Names ). It can be either set to TRUE or FALSE. In your case, you would set it to TRUE.

Hi Guys,

Thanks for all your inputs and ideas.

Naveen

Hi Guys, I have a sequential file, that can contain variable number of rows. While processing the input data in the transformer. Is there any way, by which I can tell that the row I am currently processing is the last row in the input source file or not ?. Any help would be appreciated. Thanks Naveen

Hi Mahesh, 1) I need to summarize (sum total) 1 column and get record count of input data using a transformer (BASIC or PARALLEL).I want to avoid using Aggregator.Also since I need to call a server routine, I need to use BASIC transformer. To sum 1 column using a transformer, you can use stage varia...

Hi Vinay, You need to give the sort column values like 1,2,3 depending upon how the records are sorted before you feed them to aggregator. 1 - stands for the first key that the records have been sorted on 2 - stand for the secondary key that the records have been sorted on etc......... The sort orde...

Thanks sai, I will send a mail to my admin to take care of this.

Hi Guys, I am trying to export datastage job design and i am trying to select it based on category and it is giving me the following error Error calling subroutine:*DataStage*DSR_SELECT (Action=7);check DataStage is setup correctly in the project R3CPSDEV (Subroutine failed to complete successfully ...

Hi Reddy,

Didnt we answer the same post on 06/24/05 in a different thread?. Is this problem a different one?

Here is your old thread viewtopic.php?t=93631

Hi Guys, I created job like this ODBC -----------> Trabsformer ------------> Hash file (Output stage) ODBC -------------> Tranformer -------------> Hash File ------------> L1 is the link between ODBC and Tranformer L2 is the link between Transformer and Hash File L3 is the link from the Hash file t...

Hi Venu,

I noticed that you are talking about ftp to SAP server. Are you using any SAP plugins like ABAP extract plugin etc... in your jobs?.

Hi Vinay, 1) Try to do view data for the link between the flat file and the transformer. It is a possibility that you are not able to read all the records from the flat file, for some reason. If you dont have any constraints in the transformer, then you should see all the 40 records in its output. 2...

Hi Amith,

I have personally used about 160 columns, I dont think that there is any limit to the number of columns, to the best of my knowledge. If there is any limit, maybe the Dsx Gurus will be able to tell us.

vinaymanchinila wrote:Pivot Stage , can it be used with server jobs ?

Yes, pivot stage can be used with server jobs.

Just like saravanan pointed, there will be a file called Datastage Release Notes file in the Ascential Datastage folder. If you open that, you will find a section called Whats new?. You will find all the new features in it.