DSXchange

Hi, I have a requirement where XML file will be provided with full information (with all the tags) and this file may come as EMPTY file as well. In case of Empty XML file only file header will be present and XML body part will not be present in file (even tags will not be there). Could you please ad...

Record type will be recognised by the values in RDW field. Each record type have different length so the value of RDW field. There is no record delimiter. I have got a workaround using CFF stage using pure TEXT file. Now I will perform this test using the HEX and packed values. In real file RDW have...

Hi, I have a requirement to read the variable length file (ASCII - having packed decimals in each record type) which does not have any record delimiter. There are different types of records present in file and all they have different length. Each record has 2 byte field (RDW) which has record length...

Thanks James,
so if I want to make datatype like 'S9(7)v99 Comp -3', Could you please confirm what are the peoperty I needs to set in Sequential file stage.
Column -> Decimal(7,2)
Packed -> Yes

What setting is required to define 'Comp -3'?
Please confirm.

Thanks for the reply.

I just wanted to know whether we can compress the data as part of packed decimal in sequential file stage. I know we can write packed decimal in sequential file stage but I am not sure whether we can define 'comp -3' or 'comp -2'.

s9(7)v99 comp-3
s9(7)v99 comp-2

Hi, I have to write some of the packed decimal fields in Sequential file. Source data is unpacked number and target (sequential file) is packed. PIC S9(8 ) C-3 PIC S9(9)v99 C-3 Is there any way I can use Sequential file stage as target stage and write these kind of packed decimals OR I have to use C...

Hi, I gone through the documentation and I read how to handle errors or return values from routine using exclusive triggeres etc. But here the issue is when we restart sequence after some failure point then it re-run this routine though it is already finished. Since DataStage does not get it's expec...

It only automatically handles the routine if it thinks you did not, this is explained in the documentation. Run two links from the Routine, one "OK" and one "Otherwise" to a Sequencer set to "any" and ... Thanks Craig. But I am not able to see entire content. Could you...

Hi, I have a scenario where I am running few routines and these routines are calling oracle sql execution utility (this utility just submits the SQL what ever we passed to oracle with proper credentials and return back the value by oracle). Using this utility I am submitting INSERT or MERGE commands...

There is one more post with the same issue. http://www.dsxchange.com/viewtopic.php?t=148786 We have server routine which submits Oracle SQL. These routines need to run in parallel/together and after each server routine we get return value from the corresponding routine. The reason of collecting retu...

Hi, We have a situation where we are using a routine (which takes SQL statement and submits to database - Oracle) to insert some of the data in 5 different tables. Sample SQL; INSERT INTO TABLE TARGET SELECT COL1, COL2 .. from SOURCE WHERE... Query 1: ---------- I have 5 different instances (with di...