DSXchange

Hi guys, I am getting XML message for my source data which has a TIME attribute with value like "2017-08-18T16:00:54.368+01:00" I have extracted this value from the XML and stored in a field in transformer with datatype as varchar and the value after peeking into it was "2017-08-1816:...

I tried loading the CLOB column with array size as 1 and I see that the entire xml is getting loaded into the field.

This works properly if I use an Oracle Connector to load the data whereas if I use DTS stage - the job aborts.

Error I get is - player terminated unexpectedly.

I checked the data in Toad and found that the xml data is truncated. So, it's not loading completely into database but it doesn't throw any size error or anything else. In my ETL the APT_DEFAULT_TRANSPORT_BLOCK_SIZE is set to 9999999. Still this issue happens.

Hello, I have a job design like below - MQ Connector -> Transformer -> DTS Here in DS, I have given the column datatype as LongVarchar with no length provided. I am reading a XML file coming from MQ and loading into a Oracle table with column datatype as CLOB. The job completes successfully and I se...

Hi guys, can someone tell me how exactly the write mode 'UPDATE' works in Oracle connector? Lets say i have a table with several columns and 2 columns (account_id and as_of_dt) are the PKs. Now if some new records come in which are not there in the table, will it insert them or drop? And if the data...

I/p - ID KEY VALUE 12 CBD XXX 12 GTI YYY 22 CBD 123 22 SC_ID 456 22 FUND 789 o/p - ID CBD GTI SC_ID FUND 12 XXX YYY null null 22 123 null 456 789 so, this is how my i/p and o/p should be. Current Design - I/P -> xfrmer -> Rem Dup -> xfrmer -> seq file in the first xfm, i am concatenating the KEY and...

hey guys, need your urgent help!!! i have an input column with data like - ABC,DEF,GHI (3 values concatenated with comma delimiter) In the output, I want the position of each values like - for ABC - o/p should be 1 for DEF - o/p should be 2 Any idea how can we do this in DS? I tried Index function b...

Hi Andy,
Thanks for the reply!!

1) i have the CLOB column listed last in the DS as well as in the table definition.
2) array size is 1 only.
3) and the file size is 8KB whereas i am specifying till 1MB. But if I go above 1MB then it fails or if I don't specify anything then it fails.

Thanks!!

Hey guys, I am trying to load a XML msg into a CLOB column. Job Design - MQ -> XML -> DTS I have provided the datatype as LongVarchar in DS for the column. But didn't specify any length. If so, it throws error that - Error in writeBlock - could not write 40 writeAllData() write failed. This is proba...

Hi Guys, I have created a job which looks like MQ -> XML -> Transformer -> DTS (Oracle). I am passing a XML file as the source from MQ and it correctly passes through as a single row and gets parsed and the data gets loaded into an Oracle Table. The above is happening correctly when i am running the...

Sounds like a question for the person/program who loaded the queue. Use DataStage to load your queue with test information, and ensure that you are loading ONE row (varchar with a long length). . ... Possible job design - External source stage -> mq stage If I do this to load the queue, its throwin...

Hi Guys, I am trying to read a 250KB file using MQ stage. The file has all the data in a single row. The MAXMSGL is defined as 4MB and hence I am expecting that this entire file should get accomodated in a single message. But after loading the file into MQ, i see that there are 3 messages created fo...

I am trying to read a XML file using MQ Stage. All the data in my XML file is in 1 line with no CR LF entries but when I load it into MQ stage, instead of displaying the file as a single message, its displaying it as several messages and because of which my job is getting aborted. Design - Mq -> XML...

Hi, Does the HPivot option in XML stage work in the same way as the pivot stage in DS? Because I tried the same with an example data and I am not getting similar output. Eg: ID Name M1 M2 M3 1 Nyk 4 5 6 2 Luv 7 8 9 Output: ID Name M 1 Nyk 4 1 Nyk 5 1 Nyk 6 2 Luv 7 2 Luv 8 2 Luv 9 This output I am no...

Thanks for the reply..I checked and indeed the column's type was String and hence the incorrect result.