Search found 22 matches
- Fri Mar 06, 2009 11:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Header and Detail record
- Replies: 2
- Views: 1734
XML Header and Detail record
Hi, For the following xml as source file, i need to import data in dataset. <IDOC> - <ZCOMMHDR> <ZCOMPANY>8206</ZCOMPANY> </ZCOMMHDR> - <ZCOMMDET> <ZARTICLE>T816028NY00100</ZARTICLE> </ZCOMMDET> - <ZCOMMHDR> <ZCOMPANY>8293</ZCOMPANY> </ZCOMMHDR> - <ZCOMMDET> <ZARTICLE>T816028NY0E0200</ZARTICLE> </ZC...
- Thu Feb 26, 2009 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage
- Replies: 4
- Views: 2748
Sorry for confusion caused chulett :oops: Below job design may make my point clear Row gen(with Zero rows) --->Transformer (1 column Filepath containing file location and name) ----> XML input (1 Column having Concatenated data ZARTICLE) ----> Dataset ( 2 columns Col1 and Col2 having ZARTICLE data s...
- Thu Feb 26, 2009 5:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage
- Replies: 4
- Views: 2748
XML Input Stage
Hi, I am using xml source file in which entity ZARTICLE has following derivation and description respectively ZCOMMIT01.ZCOMMIT01.ZARTICLE /ZCOMMIT01/IDOC/Z1COMMDET/ZARTICLE/text() Assuming my XML tag input is as follows, <ZARTICLE>ABCDEF<\ZARTICLE> In target i want <COL1>ABC<\COL1> <COL2>DEF<\COL2>...
- Fri Oct 31, 2008 1:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Coversion of double to Int
- Replies: 7
- Views: 12542
Re: Coversion of double to Int
It can be done in a transformer as well using AsInteger(%number%) function
- Fri Oct 24, 2008 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Environment variables issue
- Replies: 1
- Views: 2134
Re: Environment variables issue
Use GetEnvironment(%envvar%) in transformer stage
- Fri Oct 24, 2008 1:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to extract Header and Detail Records separately
- Replies: 5
- Views: 2791
Re: How to extract Header and Detail Records separately
looking at the data it feels like your header is an record that starts with an value "ID" check for that and then move it to an different link using an transformer, do the same with your Trailer record.Could be done using a Transformer and defining appropriate constraints in it.
- Thu May 31, 2007 11:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance statistics Not Shown
- Replies: 4
- Views: 4998
Hi , I think this is the probable solution.. :x the APT_NO_JOBMON parameter was disabled thus the job was not showing the performance statistics. Regarding APT_Monitor_Mintime,APT_Monitor_Size,APT_Monitor_Time parameters should these values be set as default or did we require to change them.. Please...
- Thu May 31, 2007 8:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance statistics Not Shown
- Replies: 4
- Views: 4998
Performance statistics Not Shown
Hi :) , I am facing a issue related to performance statistics,when i am running a job for ex. preparing a Dataset from a DB2 data base table it is loading the data from the table to dataset but the performance statistics are not shown for the particular job,even when i try to monitor that job via Di...
- Tue May 15, 2007 4:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execution problem related to sequence
- Replies: 1
- Views: 1435
Execution problem related to sequence
Hi All I am having a main sequence A in which i am calling a subsequence B,the subsequence has a job that calls to the Quality Stage Component 'C'. Whenever i execute the main sequence A, before that i have to compile the Sequence A and Sub Sequence B the Main sequences gets executed successfully.Du...
- Wed Jan 17, 2007 2:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: insert a db2 sequence generated value
- Replies: 1
- Views: 1510
insert a db2 sequence generated value
Hi all :) , I have to insert a db2 sequence generated value into a field for a table(say ABC),the sequence name is IA.INDIV_EN_ID_SEQ INSERT INTO #TgtDB#.ABC (IDENTITY_ID, INDIVIDUAL_ENTITY_ID) VALUES (ORCHESTRATE.IDENTITY_ID, NEXTVAL FOR IA.INDIV_EN_ID_SEQ) But while doing this i am getting the fo...
- Wed Dec 13, 2006 1:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can We calculate the no. of Alpha Char. in a string
- Replies: 6
- Views: 3604
Can We calculate the no. of Alpha Char. in a string
Hi All :D , I have to do a validation on a Varchar field as follows.... 1) First Char must be Alpha---i got this using function Alpha(Left(inxfmLoadData1.DFSNAM,1)) = 1 2) Valid char.. r Alphabets,Blanks,Hypens and Apostrophes... 3) Blanks,Hypens and Apostrophes must not be adjacent Can anybody Hel...
- Mon Dec 11, 2006 7:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: conversion warning :---decimal_from_string data lost
- Replies: 4
- Views: 4378
- Mon Dec 11, 2006 6:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: conversion warning :---decimal_from_string data lost
- Replies: 4
- Views: 4378
conversion warning :---decimal_from_string data lost
Hi All :D , I am getting the following warning during conversion of a string(9) to decimal(9)....I am using StringToDecimal(colName) function in transformer Stage. :!: t3xfrmIIINQ0,2: Conversion error calling conversion routine decimal_from_string data may have been lost. Can anybody suggest a work...
- Mon Oct 16, 2006 10:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DecimalTochar Conversion
- Replies: 1
- Views: 2840
DecimalTochar Conversion
Hi all :) I am using the transformer stage for converting decimal[9] to char[9]. i used the char(%number%) function but it does not provide any solution(also no warning or error msg. is their :roll: in log ) Then i used decimalTosting() function but this also does not provide me the solution..in fa...
- Wed Oct 11, 2006 8:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error:--Scratch Space Full
- Replies: 3
- Views: 2338
Fatal Error:--Scratch Space Full
Hi all, I am joining a database table(db2) with a pre-build dataset in the join stage. I am getting the following error : Fatal error :- Tsort merger aborting .Scratch space full.. I also used modify stage before joining bcoz my dataset col. and table col. where different.Also while executing the j...