Search found 17 matches
- 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...
- 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...
- 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...
- 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 ...
- 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.
- 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,...
- 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...
- 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...
- Wed May 28, 2008 11:28 am
- Forum: General
- Topic: Unable to login to dataStage Director
- Replies: 3
- Views: 1937
- 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...
- 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...
- 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
- 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
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
- 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
- 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...