Search found 26 matches
- Tue Jan 15, 2013 3:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file stage - Number of readers per node
- Replies: 2
- Views: 2327
Sequential file stage - Number of readers per node
Hi, In Sequential file stage - Number of readers per node property is set to 2 and filter property is also used. I am getting broken pipe issue and job is aborting when it is triggered with 15K data and no issue with less data. Job design : Sequentail file ---> Filter --->Column import ---> Target D...
- Tue Jan 15, 2013 12:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bulk Load option in Oracle Connector
- Replies: 0
- Views: 1451
Bulk Load option in Oracle Connector
Hi, There are constraints (ie., Check Constraints) on my tables so if i use Bulk Load option instead of "INSERT" will it improve performance or will it degrade the performance. Set Perform operations before bulk load to No. Set Disable constraints to No. Set Perform operations after bulk l...
- Fri Nov 02, 2012 12:42 am
- Forum: General
- Topic: How to change the date format in the job control
- Replies: 10
- Views: 3230
- Thu Nov 01, 2012 11:29 pm
- Forum: General
- Topic: How to change the date format in the job control
- Replies: 10
- Views: 3230
- Wed Oct 31, 2012 8:02 am
- Forum: General
- Topic: How to change the date format in the job control
- Replies: 10
- Views: 3230
How to change the date format in the job control
Hi, I have a file which has two fields.First field is the date column which is in 'yyyy-mm-dd hh24:mi:ss' format.But i need to change the format. Example : Data in the file is : 2012-03-23 10:11:11|abcd I need the output value as "Mar2012" Can anyone guide me how to do this.I have tried th...
- Tue Jul 03, 2012 12:54 am
- Forum: General
- Topic: Error while executing the sequence
- Replies: 3
- Views: 2434
Error while executing the sequence
In a master sequence i am calling a sub sequence. The sub sequence is executing successfully when i run it individually but when i am calling it in a sequence it aborting. Error message : CopyOfjs0301020Fiserv_Extract_SrcStm_to_File..JobControl (@Job_Activity_429): Will execute error activity: ehGen...
- Wed Mar 23, 2011 10:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output format
- Replies: 7
- Views: 4075
- Wed Mar 23, 2011 10:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output format
- Replies: 7
- Views: 4075
- Wed Mar 23, 2011 6:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output format
- Replies: 7
- Views: 4075
Hi, The tag can occur multiple times. I want to remove entire <SeqNum>..</SeqNum> from each line, regardless the values with in this tag. for each line value inside these tags could be different. So please suggest how to do this. Input: ---------- <Body><Profile><Id>123</Id><ContactMethods><Contacts...
- Wed Mar 23, 2011 3:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output format
- Replies: 7
- Views: 4075
XML Output format
Hi, I need to remove a tag in the xml which will have different values for different profiles but the thing is for each profile it will be in a single line. I want to remove entire <SeqNum>..</SeqNum> from each line, regardless the values with in this tag. for each line value inside these tags could...
- Tue Mar 22, 2011 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: xml output generaion
- Replies: 1
- Views: 6453
xml output generaion
Hi, I am generating xml output. Expected Output: <Body> <CustomerId>2345</CustomerId> <PartyContactMethod> <UsageCode>1</Usagecode> <ContacMethod> <Id>12345</Id> <MethodType>2</MethodType> </ContactMethod> </PartyContactMethod> <PartyContactMethod> <UsageCode>2</Usagecode> <ContacMethod> <Id>12345</...
- Fri Feb 25, 2011 12:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to create empty XML file?
- Replies: 3
- Views: 2526
How to create empty XML file?
Hi, I have create azero byte xml at the end if there is no data in the input datasets ,i cannot pass any dummy values till end because i am joining all the chunk xml's by using Join Stage so the output from join stage will be "zero records" ..Please suggest how u resolved ur problem. Thank...
- Wed Feb 16, 2011 12:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File Generation
- Replies: 4
- Views: 3369
Re: Xml File Generation
Hi, No i have not mentioned trigger column.. I get mutiple address from a dataset , from this dataset i have generated a xml output and this xml i am trying to join with the employee dataset and generate the xml with emp and address information. If i use Table instead of dataset its working :)..any ...
- Wed Feb 16, 2011 12:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while generating xml output
- Replies: 2
- Views: 1782
Issue while generating xml output
Hi, I am able to generate xml output with repeated elements in the profile using Tables but when i am replacing the tables with dataset the output is not proper. Expected Output : <Body> <profile> <EmpId>123</EmpId> <Addresses> <address> <AddrType>Main</AddrType> <City>ABC</City> </address> <address...
- Tue Feb 15, 2011 11:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File Generation
- Replies: 4
- Views: 3369
Xml File Generation
Output i am getting is below: <Body> <profile> <EmpId>123</EmpId> <Addresses> <address> <AddrType>Main</AddrType> <City>ABC</City> </address> </Addresses> </profile> <profile> <EmpId>123</EmpId> <Addresses> <address> <AddrType>Secondary</AddrType> <City>XYZ</City> </address> </Addresses> </profile> ...