DSXchange

I'm able to figure out how to read, adjust some data, and reconstruct in the same format an XML using the new XML stage which has a repeating element(list) of values for a parent by mapping the lowest level which is <style> to the link and working my way up. Example of XML below: <promotions> <promo...

In the end what we did was sequence each tag to get to a normal XML like so: <contact> <contactField1 name="firstname">Joe</contactField1> <contactField2 name="lastname">Smith</contactField2> <contactField3 ... </contact> Then we feed the XML through another job doing a Change() ...

I'm used to creating xml's with predefined tags for example <contact> <firstname>Joe</firstname> <lastname>Smith</lastname> </contact> but this latest is different. The tag is generic and uses and attribute or label so the above needs to be: <contact> <contactField name="firstname">Joe</co...

That worked thanks. I see the %aa is not compatible with %hh which means 24 hour clock while %HH means 12 hour clock. thanks again

Running 8.5 on unix Input Strings coming in as: 1/1/2007 10:05:00 PM 12/10/2007 1:00:00 AM Running this: StringToTimestamp(DSLink2.timestamp,"%(m,s)/%(d,s)/%yyyy %(h,s):%nn:%ss") outputs the data as: 01/01/2007 10:05:00 12/10/2007 01:00:00 I'd like the first timestamp since PM to be 01/01/...

So ray, in my example where I have a key which has multiple date ranges and I want to add the start and end date to the incoming records whose date comes in and must be within the range how would I go about this? Because of the dupes would you suggest breaking this out into two separate lookups? For...

This has me really confused and hopefully someone can explain the difference as I'm not sure if it's a parttion issue or something else. I have a Dataset as input with two fields (code, timestamp(key)). I have another Dataset going into a lookup stage with (code(key), start_timestamp, end_timestamp)...

Hi Ray, Can you expand on how you are using subversion and DataStage, partically in regards to are you doin gthe check in and check out through Information Server Manager or are you doing it outside of it where you are importing and exporting .dsx files? Assuming you use it via Information Server Ma...

Now that Version 8.1 does not have Version Control as the older versions of 7x have had I need to come up with a solution for Versioning jobs. I assume from what I have read that most people are exporting their .dsx files into some third party type software like clear case, cvs, vss, etc. I know the...

Hey Ernie, Yeah you are right the perils belong under the LOB. I really don't need a chunk here. The problem I was having was that after merging the two(LOB and Perils) when I created the XML I did not have the repeating eliminate in the Perils column marked as a key. I had it in the first column of...

I having a lot of issues trying to create a correct XML and hopefully someone can help me. The XML should look something like this. -<master> -<lineofbusiness> <field_one></field_one> <field_two></field_two> etc..... -<perils> <field_x></field_x> <field_y></field_y> etc.... </perils -<perils> <field...

Thanks Craig - so if I understand correctly:

0 = true "Then TrimF(TrimB(svINPUTFIELD))"
1 = false "Else svINPUTFIELD"

Just started a new job and looking over an IF statement that in my 7 years I've never seen before. Can someone explain to me what's going on in this statement. I never knew you can end an IF statment with a then and else then do another statement then else. I've always seen If then Else If then ... ...

so it looks like IsValid('Date',StringToDate(stgAcctDate, '%1950yy%mm%dd')) worked I just get the annoying warning: Conversion error calling conversion routine date_from_string data may have been lost: which I'll have to ignore in the message handler for each date that I have in the transformmer. Ot...

I'll try the latest two examples and let you guys know. regarding am I writing to a stage variable, no. You are correct in that you can't write a null to a stag variable. This code is simply using a stage variable in the calc to write to an output. In the stage variables I check for Null first, if i...