Search found 17 matches

by saini
Sat Apr 24, 2010 12:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bapi Stage
Replies: 2
Views: 1428

Yes It returns value. The problem was with the input.txt file format. Since the SAP is unicode on our server so the input file need to be saved in the UNICODE BIG ENDIAN FORMAT, now it works fine. Now another issue came i.e If I actvate 2 parameters in the Output BAPI tables tab, the job runs for ev...
by saini
Wed Apr 21, 2010 10:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bapi Stage
Replies: 2
Views: 1428

Bapi Stage

Hi, I am using RFC call inside the BAPI Stage to extract the data. On the Output BAPI page I activated the parameter which I am passing to the RFC. Provided the Input file name(In this I am passing the parameter which is activated in the Output BAPI Import tab) in the Output Read Logs Page.I activat...
by saini
Mon Feb 22, 2010 1:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Xml stylesheets
Replies: 4
Views: 2048

I want the processed elements in italics. Its not in the database. IT will be in the xml only. I will parse the xml and copy the 5 elements to database and from one copy read the complete xml and put the processed elemnts in italics in that. So that after looking into the xml i can differentiate bet...
by saini
Mon Feb 22, 2010 12:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Xml stylesheets
Replies: 4
Views: 2048

Xml stylesheets

Hi, I am parsing a XML with the xml input stage. There are 20 elements in the xml. Currently I am taking only 5 elements from xml and loading in the database. At the end I want that in the current xml those elements which I have processed come in bold or italic. How can we use xml stylesheets to do ...
by saini
Wed Jan 07, 2009 10:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove duplicate from a file on local
Replies: 4
Views: 2145

remove duplicate from a file on local

I have a huge '|' separated data file. I want to remove duplicate from Sequential File. The file is on my local machine I donot want to put it on the server. Is there any way we can remove duplicate from a file in local.
by saini
Wed Jul 16, 2008 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find the max of a Timestamp field
Replies: 8
Views: 11535

Is this function in the Transformer Stage as I am unable to find it Use the TimetFromTimestamp function to convert the timestamp to a number, then run through agg to get max, then use TimestampFromTimet to convert it back to the timestamp. Need to mess with conversion using DecimalToDfloat, I think,...
by saini
Wed Jul 16, 2008 11:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find the max of a Timestamp field
Replies: 8
Views: 11535

How to find the max of a Timestamp field

Hi I have a requirement to find the max of a column. Its datatype is Timestamp. I am trying to get the max of that column through aggregator Stage. I get the following error: Aggregator_94: Error when checking operator: When binding input interface field "ADJUST_DT" to field "ADJUST_D...
by saini
Wed Jun 25, 2008 7:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: For Loop in sequence
Replies: 3
Views: 2018

For Loop in sequence

Hi I am having a for loop in the sequence. The job flow is as follow Job1--------->Job2--------->LoopStart--------->Job3--------->Job4--------->Job5-------->ExecuteCmdStage--------->LoopEnd--------->Job6 In the ExecuteCmdStage I am checking the checking the wordcount of a file (wc -l abc.txt ) and t...
by saini
Wed May 28, 2008 11:28 am
Forum: General
Topic: Unable to login to dataStage Director
Replies: 3
Views: 1937

We are using 7.5.2 version
by saini
Fri May 23, 2008 10:57 am
Forum: General
Topic: Unable to login to dataStage Director
Replies: 3
Views: 1937

Unable to login to dataStage Director

Hi, I am facing a strange :? problem. I am able to login to DS Designer but when I try to connect to DS Director or DS Manager, It takes 99% CPU utilisation and the aplication status shows as NOT RESPONDING. I tried Uninstalling and Installing the client again but didnot get any luck. Please suggest...
by saini
Wed May 14, 2008 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence error code -14
Replies: 3
Views: 2506

job sequence error code -14

Hi I have 2 multiple instances job. These jobs are running in a sequencer one after another. when I run these jobs individually they run fine but with I try to run the Seq it gives the following error. Please suggest Invoicejobseq..JobControl (@Invoicejob1): Controller problem: Error calling DSRunJo...
by saini
Fri May 09, 2008 12:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Instances of a job
Replies: 4
Views: 2163

Then If require to give the invocation id for each job in the JOb Activity Stage in Sequencer.
What should we give in the Invocation ID. Is theer any particular value or name for Invocation Ids
by saini
Fri May 09, 2008 12:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Instances of a job
Replies: 4
Views: 2163

Multiple Instances of a job

Hi

I have a Sequence which allows multiple instances.
Is it required that the jobs which are put in the job sequence should also allow multiple instances.


Thanks
by saini
Fri May 09, 2008 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NULL values in the output
Replies: 2
Views: 1223

Thanks it worked
by saini
Fri May 09, 2008 8:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NULL values in the output
Replies: 2
Views: 1223

NULL values in the output

Hi, I am fetching col1,col2,col3 from database. In the database col1 and col2 aur not-nullable but when I import the metadata in DS it says these fields are nullable and when I try to write these coloums in a seq file along with the col value its inserting nulls(|) also in the flat file. The datatyp...