DSXchange

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...

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...

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>...

It can be done in a transformer as well using AsInteger(%number%) function

Use GetEnvironment(%envvar%) in transformer stage

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.

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...

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...

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...

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...

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...

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...

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...

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...