Search found 91 matches
- Tue Jul 22, 2014 6:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Column Value as constraint or filter in datastage
- Replies: 2
- Views: 3385
Column Value as constraint or filter in datastage
Hello Gurus, Need your expertise idea to crack below requirement. I have lookup table where i have maintained condition or constraints Like E.g Table1 Key V_SQL 1 Name = 'P' 2 Name = 'Q' So I will join the main data with lookup table based on the key and pass the value has constraint or condition in...
- Thu May 29, 2014 2:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create Sequence Number for the Duplicate Enteries
- Replies: 4
- Views: 2814
Create Sequence Number for the Duplicate Enteries
I have requirement to generate the sequence number for the duplicate enteries.
For Example
ID,Seq_number
10,1
10,2
20,1
20,2
30,1
30,2
30,3
30,4
Any suggestion Appreciated
Thanks In Advance
For Example
ID,Seq_number
10,1
10,2
20,1
20,2
30,1
30,2
30,3
30,4
Any suggestion Appreciated
Thanks In Advance
- Fri Sep 20, 2013 11:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to divide the xml value in Datastage without xml input
- Replies: 5
- Views: 2655
Re: Xml
Hi Chulett, Yeah your are right ,So going with experts words i have designed job ExternalSource--->Xmlinput---->Peak ,The job is succesful and providing me the acrute results. Before i mark this post a resolved, Can you please share me how to handle rejected record in Xml Input stage to peek stage ,...
- Fri Sep 20, 2013 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to divide the xml value in Datastage without xml input
- Replies: 5
- Views: 2655
Xml
Hi Chulett, It will cumbersome to write derivation for each tag,because we have more tags. Noted:The only reason i opted to perform above because xml input stage requires XSD stored some where and results the warning stating "The primary document entity could not be opened". Can u suggest ...
- Fri Sep 20, 2013 8:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to divide the xml value in Datastage without xml input
- Replies: 5
- Views: 2655
How to divide the xml value in Datastage without xml input
Hi, My source record is as below: <POLICY_COVERAGE_ROW><REPORT_DT>201302</REPORT_DT><POLICY_NO>130201LD01</POLICY_NO></POLICY_COVERAGE_ROW> How do i generate pieline delimiter file only with tag value as shown below using datastage. 201302|130201LD01 Noted:I dont want to use Xml input stage to do th...
- Mon Jun 20, 2011 3:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reg:Passing sql at the run time
- Replies: 1
- Views: 2196
Reg:Passing sql at the run time
Hi All, I want to pass the sql statement in the runtime using parameters property in datastage.How to achieve this? For Eg: I want run the below sql. delete from <Table_name> where <batch_load> = <date> in a parameters in runtime How to perform the above,Please let me know. Thanks for your help in A...
- Mon Mar 07, 2011 12:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delimiter representation
- Replies: 1
- Views: 1566
Delimiter representation
Hi All,
How we can represent ASCII-127 Character (HX-7F) as a delimiter in datastage.
"I Mean what value i have pass in the delimiter String"
Thanks for your help in advance.
How we can represent ASCII-127 Character (HX-7F) as a delimiter in datastage.
"I Mean what value i have pass in the delimiter String"
Thanks for your help in advance.
- Mon Nov 22, 2010 1:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: AGE BAND lookup
- Replies: 5
- Views: 2596
U can directly check the value in a particular range. Indeed, anyone can, not just U (one of our posters). The descriptions in the manual are quite clear. Show us what you have attempted. Hi Ray, I have drived the Table1 has my primary and while i perform look up with Table2(which is reference),I c...
- Mon Nov 22, 2010 1:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: AGE BAND lookup
- Replies: 5
- Views: 2596
- Mon Nov 22, 2010 12:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: AGE BAND lookup
- Replies: 5
- Views: 2596
AGE BAND lookup
Hi All, I have Requirement to reterive the id based on the range of value,Please help to resolve this. Eg: Table1: Date1 Date2 AGE_Diff 20-01-2010 20-10-2010 9 Table2: id MIN_VALUE MAX_VALUE 1 1 5 2 6 10 3 11 100 How to loookup Table1.AGE_DIFF to Table2.MIN_VALUE,MAX_VALUE(based on the range) i have...
- Mon Jun 28, 2010 5:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg:Warning while Exporting in to sequential file
- Replies: 4
- Views: 3304
- Mon Jun 28, 2010 5:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg:Warning while Exporting in to sequential file
- Replies: 4
- Views: 3304
- Mon Jun 28, 2010 5:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg:Warning while Exporting in to sequential file
- Replies: 4
- Views: 3304
Reg:Warning while Exporting in to sequential file
Hi All, can any one help me,How to eliminate the below warning. "Exporting nullable field without null handling properties" Note : I have handled nullability to all the Char fields . Even i am using column export stage to export all the fields to to single field. Thanks for your reply. reg...
- Mon May 10, 2010 10:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg:How to use field function
- Replies: 2
- Views: 2048
Reg:How to use field function
Hi all,
I have requirement,Please help me how to Achieve these
Input Output
AD-ADE-0000000001 0000000001
AF-ADF-0000000002 0000000002
Thanks for your help in Advance.
I have requirement,Please help me how to Achieve these
Input Output
AD-ADE-0000000001 0000000001
AF-ADF-0000000002 0000000002
Thanks for your help in Advance.
- Sat Apr 17, 2010 2:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup Space
- Replies: 3
- Views: 2680
Lookup Space
Hi All
How to resolve the issue.
lookuptable.20100417.stsv13d": No space left on device.
Can we do any tuning in the job.since we cannot increase the resource space for this job alone
This job is having single lookup holding 5 reference.
Thanks for your help
How to resolve the issue.
lookuptable.20100417.stsv13d": No space left on device.
Can we do any tuning in the job.since we cannot increase the resource space for this job alone
This job is having single lookup holding 5 reference.
Thanks for your help