DSXchange

Thank you - I was able to get it formatted correctly - thanks for the help.

I edited my post and added '0''s where the spaces would be in the amount field - for some reason, spaces weren't displaying. Yes, it would be a fixed width file - but the input -the amount fields are different depending on the dollar amount if it is in the thousands or hundreds, for instance. In the...

I need to format a file - the input looks like: 2008-12-31 223.00 PL0921870976 2008-12-31 3432.00 PL0922928729 I need it to look like: COL1 COL2 COL3 2008-12-200000000223.00PL1234567 2008-12-200000003432.00PL3456788 The zeroes above would actually be spaces, but they weren't appearing for some reaso...

Ok, after trying a couple different things - I decided to change the counter to an integer - just to see what happened - and of course, that worked! I don't fully understand what went wrong, but after pointing out that it shouldn't be adding 1 to a varchar field, I thought i'd try it as an int. Ever...

I double checked and the COUNTER variable is definitely a VARCHAR. Is it possible it did an implicit conversion when I add 1 to it? 'COUNTER + 1' is done in the derivation of the stage variable area. Then another derivation is done. Str('0', 7-Len(COUNTER)):COUNTER Is it possible that in any of thes...

Hi Ray - The datatype is varchar. The field originates as a stage variable - which I increment by one for every record. The precision is set to 255 in the stage variable properties. Just to give you all the details I can - another step is padding the 7 character field with 0's Str('0', 7-Len(COUNTER...

I JUST tried the escape key and it worked!!! THANK YOU!

My job contains a counter - the counter was up to 1450955

Once it hit the following number it converted it to the following number in what I believe is scientific notation. Is there a setting or option that would stop DS from doing this?

1.45096e+06

Hi there - yes it is ONLY the Sequential File stage. I haven't been able to ask another DS developer to try it - since its a holiday today - but as soon as I get the chance, I will. I'm hoping the issue is resolved either by restarting the DS server, but if necessary, I will re-install when all else...

I have an input file and I was trying to improve performance so I tried the 'Readers per node' property. Let's say for instance, I specify '4' Readers per Node - each time I run the file - if it is the same file, will it read the records in the same order every time? I am asking because the job abor...

Yes, I did try making a copy - that was one of the first things I tried. But then I also tried a totally different job that was fine previously, and when opening the sequential file stage - it froze up again. So, yes, I think you're right - I'll request that the admins restart the DS server as soon ...

I am passing data to a web service. The service has an array object called FormInfo and there are 2 strings that can be null or can have values. From my understanding, the only values you can set in the WSDL are the elements that end with 'text()' the xpath for the string is below. /ns1:saveForm/for...

As far as I know, no new software was installed. Tomorrow or Tuesday (no one is available now), I will ask another developer to login from their machine and see if it is happening to them as well. Ray, are you thinking this is related to my machine as opposed to the DS server? It seemed to happen im...

Of course this happens when I am working on loading an important file for a high profile project! Basically, I started loading a file with many records and I'm assuming this is related to a memory issue possibly?? Once this job ran and then aborted, everytime I try to open ANY sequential File stage ...

Thanks so much - i'll give it a try - so there is no way to subscript in the xpath description? such as /ns1:saveForm/form/additionalTaxpayerInfo/FormTaxpayerInfo/externalTaxpayerID[2]/text() - although I did try this and I received an error - so something must be incorrect :? Also, there are other ...