Search found 12 matches
- Thu Apr 08, 2010 9:10 am
- Forum: IBM QualityStage
- Topic: QualityStage Job aborts intermittently
- Replies: 4
- Views: 4108
Re: QualityStage Job aborts intermittently
Hi, We are seeing that a particular job is aborting intermittently when run individually and as well as from Sequencer level. This job is a parallel job running on 12 nodes. When the job is run repeatedly without changing anything it runs fine sometimes and also fails it is very inconsistent. Howev...
- Thu Apr 08, 2010 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Heap Allocation Error with XML output stage
- Replies: 9
- Views: 9617
Hello pradkumar, As you said Datastage couldn't handle huge data > 200MB . Instead of using XML stage , write the data into a flat file. Use Java/C code to convert into XML file . Using Execute command , implement the code in the Datastage job In 8.x version , we can use Java based stage we are hand...
- Fri Feb 26, 2010 5:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: one file with multiple layouts
- Replies: 9
- Views: 5400
Re: one file with multiple layouts
I have one text file with 3 different layouts. content of the file: the first 5 lines contain header information (layout 1) line 6 to 20 contains detail record information (layout 2) line 21 to the end contain trailer information. (layout 3) how can I read all three formats from the same sequential...
- Sat Aug 15, 2009 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Splitting the row
- Replies: 10
- Views: 5004
Re: Splitting the row
Hello I have a requirement where i will be getting the row such as 1234^;abcdefgh^;bc^;d^;efg^;rghu^;klmn^;bcd each field delimited by ^; Is there a way that i can extract each field by using Field function. I tired using the Field function but it didnt work .Earlier they used the single Field sepa...
- Sat Aug 15, 2009 10:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Invalid character(s) ([xA9]) codpage warning in DS 8.1
- Replies: 4
- Views: 6182
Re: Invalid character(s) ([xA9]) codpage warning in DS 8.1
Hi, I am reading a sequential file, performing lookup and wrting into a table. In the process I am calling a shared container to do the otherlookups and get values I am getting this warnning main_program: Invalid character(s) ([xA9]) found converting string (code point(s): IBM Confidential, OCO Sou...
- Sat Aug 15, 2009 10:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to retain preceeding zeros in a decimal field?
- Replies: 10
- Views: 5420
Re: How to retain preceeding zeros in a decimal field?
Hari,hari4dsx wrote:Input field is a decimal (eg. 00012.)..
This is to be converted into integer, with the preceeding zeroes retained.
Does anyone have any solution for this...?
Thanks in advance.
Do you want to retain the preceding zero's in the output ?
if so use FMT function of BASIC Transformer
- Sat Aug 15, 2009 9:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS description in the Schema File
- Replies: 1
- Views: 1724
NLS description in the Schema File
Hello,
I have to parse Spanish Characters in the incoming flat file. We are using RCP with details described in the schema file . Can you please advice how to add NLS properties while describing the String in schema file and the encoding Spanish characters set to used?
Thanks in advance
I have to parse Spanish Characters in the incoming flat file. We are using RCP with details described in the schema file . Can you please advice how to add NLS properties while describing the String in schema file and the encoding Spanish characters set to used?
Thanks in advance
- Thu Aug 13, 2009 6:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to use XMLinput stage DS
- Replies: 3
- Views: 2620
Hi Craig, Thanks a lot for the documents that you sent and one more thing is that it is working fine for Server jobs,but when it come to parallel jobs we are getting the message which i posted below in the director. XML_Input_1,0: Warning: XML_Input_1: Xalan fatal error (publicId: , systemId: , lin...
- Wed Jul 22, 2009 12:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Parameters from a file
- Replies: 6
- Views: 2886
Reading Parameters from a file
Dear Members,
The requirement is to read the parameters defined in file and pass it to the sequence
Can you please suggest a possible solution
Thanks in advance
The requirement is to read the parameters defined in file and pass it to the sequence
Can you please suggest a possible solution
Thanks in advance
- Tue Jul 21, 2009 6:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove leading zeros in decimal field in sequential file
- Replies: 26
- Views: 78265
- Mon Jul 20, 2009 6:00 am
- Forum: General
- Topic: how to Run DSjobs on command prompt on Unix machine
- Replies: 7
- Views: 6773
Re: how to Run DSjobs on command propmt and Unix machine
Hello Monaz, First Set the path of DSEngine , PXEngine and APT_CONFIG_FILE dsjob -run -jobstatus -wait [ -param Parametername=value] $PROJECT $DSJOB The datastage job run based on the project and not based on the folders hi All, Can anyone please guide me how to run DS jobs on command prompt and Uni...
- Fri Jul 17, 2009 12:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance problem while processing xml file
- Replies: 11
- Views: 6482
Hello HemaV, XML stage can't handle huge volume of input data and they are not efficient. The workaround is to parse the XML into a txt file using XSLT Parser Such as Xalan or JAXB .you have to design the XSL file to parse the XML Your can read the flat file easily through Sequential file stage We h...