Search found 200 matches
- Tue Oct 21, 2014 9:46 am
- Forum: General
- Topic: HTTP listener process to receive the responses
- Replies: 2
- Views: 3026
HTTP listener process to receive the responses
Requestors of the Sync Contact service can initiate the service via MQ Series or HTTP(S) via the FxHub ESB based on the requestor's preference. In either case, the service will act asynchronously. The FxHub ESB will pass the request to the Routing Adapter Service and to the CRM Siebel environment an...
- Tue Mar 25, 2014 5:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: calling export from db2 stage
- Replies: 2
- Views: 1894
calling export from db2 stage
Hi,
i used after sql in db2 stage to call below export its giving errors any idea
if i can do this in datastage.
EXPORT TO C:\Datastageexports\emea\test.ixf
OF IXF MESSAGES "C:\Datastageexports\emea\test.msg" select * from SYSIBM.SYSDUMMY1
i used after sql in db2 stage to call below export its giving errors any idea
if i can do this in datastage.
EXPORT TO C:\Datastageexports\emea\test.ixf
OF IXF MESSAGES "C:\Datastageexports\emea\test.msg" select * from SYSIBM.SYSDUMMY1
- Mon Mar 10, 2014 3:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: concat issue
- Replies: 5
- Views: 2790
concat issue
Hi,
FISCAL_YEAR_NUMBER is decimal 4
JE_PERIOD_NUMBER is decimal 2
i want to get SORT which is decimal 8 as 20141 20142
i am doing as below its just giving me 2014 no period number
FISCAL_YEAR_NUMBER : JE_PERIOD_NUMBER
Any idea what is wrong
FISCAL_YEAR_NUMBER is decimal 4
JE_PERIOD_NUMBER is decimal 2
i want to get SORT which is decimal 8 as 20141 20142
i am doing as below its just giving me 2014 no period number
FISCAL_YEAR_NUMBER : JE_PERIOD_NUMBER
Any idea what is wrong
- Thu Mar 06, 2014 7:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Override default 50 warning message
- Replies: 1
- Views: 1239
Override default 50 warning message
Hi,
Is there any parameter which we can use to Override default 50 warning message in sequence.
Thanks
Is there any parameter which we can use to Override default 50 warning message in sequence.
Thanks
- Wed Feb 12, 2014 8:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate a sequence based on Alphabetical order:
- Replies: 3
- Views: 2052
- Wed Feb 12, 2014 7:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate a sequence based on Alphabetical order:
- Replies: 3
- Views: 2052
Generate a sequence based on Alphabetical order:
Hi,
i have data as below
CODE
421
BD
AA
AA
CD
KK
MM
i Want to create sequence based on Alphabetical order
CODE seq
421 1
AA 2
AA 2
BD 3
CD 4
KK 5
MM 6
Thanks
i have data as below
CODE
421
BD
AA
AA
CD
KK
MM
i Want to create sequence based on Alphabetical order
CODE seq
421 1
AA 2
AA 2
BD 3
CD 4
KK 5
MM 6
Thanks
- Wed Feb 05, 2014 7:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert varchar to decimal
- Replies: 4
- Views: 3543
Convert varchar to decimal
Hi,
I am trying to convert varchar(05) to decimal(5) my doing as below but i am still getting 05
Thanks
I am trying to convert varchar(05) to decimal(5) my doing as below but i am still getting 05
Code: Select all
Trim(Stringtodecimal(link.AA),"0","L")
- Wed Jan 22, 2014 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stage variable question
- Replies: 5
- Views: 3150
- Tue Jan 21, 2014 8:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stage variable question
- Replies: 5
- Views: 3150
Parent_code child_code CHILD_SK PARENT_SK 00.1 1 ABC.20 ABC 2 null ABC.20 CDE.20 3 null ABC.20 EFG.20 4 null BDE.20 ABC.20 5 null i want to update parent_sk as below based upon join from parent_code with child_code: Parent_code child_code CHILD_SK PARENT_SK 00.1 1 null ABC.20 ABC 2 5 ABC.20 CDE.20 ...
- Tue Jan 21, 2014 4:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stage variable question
- Replies: 5
- Views: 3150
stage variable question
Input_Lnk Parent_code child_code CHILD_SK PARENT_SK 00.1 1 ABC.20 ABC 2 ABC.20 CDE.20 3 ABC.20 EFG.20 4 BDE.20 ABC.20 5 I am using stage varaible to get parent_sk like below in stage varaible i said Input_Link.child_code StageVar In Transformer to populate PARENT_SK i said IF (Input_Lnk.Parent_code=...
- Tue Dec 31, 2013 12:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can i do update in SCD stage if record is delete from source
- Replies: 1
- Views: 2253
Can i do update in SCD stage if record is delete from source
Hi, Can i do below scenario using SCD emp_no and emp_date is business key Day 1: in dimension sk emp_no emp_date eff_dt end_dt 7 123 9999-12-31 2013-12-01 9999-12-31 Day 2: in dimension sk emp_no emp_date eff_dt end_dt 7 123 9999-12-31 2013-12-01 2013-12-31 --this row is delete in source and i want ...
- Fri Sep 06, 2013 8:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date format issue
- Replies: 2
- Views: 2927
date format issue
Hi, My date is in varchar 8 format like 20010431 when i do conversion its coming as 4444-01-01 any idea what can be wrong Note: some dates are coming good but above conversion have issue EMP_START_DT_ORIGINAL:20010431 IF IsValid("date", to_transf.EMP_START_DT_ORIGINAL, "%yyyy%mm%dd&qu...
- Wed Aug 28, 2013 9:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date issue
- Replies: 4
- Views: 2597
- Wed Aug 28, 2013 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date issue
- Replies: 4
- Views: 2597
date issue
Hi, I am trying to convert varchar(8) to date and also doing DateOffsetByDays below is syntax but transformer not liking DateOffsetByDays Thanks IF IsValid("date", DateOffsetByDays(to_trans4.S_AAA, "%yyyy%mm%dd",1)) THEN StringToDate(to_trans4.S_AAA,"%yyyy%mm%dd") ELSE ...
- Thu Aug 22, 2013 8:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data transformation based upon date range
- Replies: 3
- Views: 1948
Hi, Let me rephrase the question i have record with range 2003-1-10 to 2012-12-31 from table A and i have two records from table B 1)2003-1-10 to 2005-1-31 2)2013-1-1 till 9999-12-31 i want to compare table A with B 1) if table B range within 2003-1-10 to 2005-1-31 A range the Arange =Brange 2) if t...