DSXchange

I am trying to code the following logic in DataStage Transformer; Field A Field B Value 1 A 1 1 A 2 1 A 3 1 B 1 1 B 2 2 C 1 2 C 2 As you see once the key value changes, I recommence the value. I tried writing an if then else but I believe that there must be a more efficient way. Isn't there a system...

Thanks for the Data Management answer. It has resolved the problem

Yes, we are a Windows OS. The answer someone gave me was Unix. I am looking for the Windows answer.

I thought this was a Unix command.

We had the same problem. De-install DS and install the C++ compiler first. Then install DS. It will find the C++ compiler and set it up during the install.

I am not 100% sure but when we installed DS on our Windows server, the install doc told us that NLS for PX was not available. I would check with your IBM tech contact.

Can someone please tell me the command I could use to cleanly delete datasets.

Thanks.

Also, no I can't get the microseconds from the system clock. I spoke with IBM and they said there may be a fix somewhere down the road. Hopefully, a simpler solution is created.

The input comes from DB2 mainframe. I modified the field attributes with extended equal to microseconds. I can get the microseconds from DB2. What I was hoping to accomplish was write a routine or BuildOp that would take the start and end timestamps and provide the difference in seconds. I started t...

Hi all, I searched the forum for an answer and still I have not found one. My problem is, I want to find the difference (right down to the microsecond) between two timestamps. I can see the timestamp and microseconds from the input but I can't seem to find a function that will allow me to do this. I...

Yes. When entering the DB2 File Stage, we don't know what the original count is. Normally, update will replace the original value and not accumulate it. Can I manually code the update where Update ....Where... Set Count = Count + Previous_stage.count

When updating a DB2 file, is there a way to accumulate a count for a field in place of updating the count. i.e. Key 1 Count = 2 Update Key 1 Count = 5 Updated record Key 1 Count = 7 Is there a quick way to do this without reading the DB2 file, doing a lookup, if it exist, calculate the new value and...

Sorry. I followed the previous post instructions and loaded a sequential file layout from the input data and everything worked fine. I didn't follow up on the post because I assume the previous posters answer solve my problem. I will follow up on future posts.

Thanks

The data looks like this,

9999,1,2006-11-24 00:00:00,"Person",2000-04-01-00.00.00.0000002,9999-12-31-00.00.00.000000,"Person","Person","Person","Person","JXS166",2006-11-24-00.00.00.000000,"I","JXS166"

Yes, I searched for comma delimited, DOS linefeed etc. I am not trying to bash the Parallel DS. I am frustrated because I created a sequential comma delimited file, enter my schema representation and voila, I could view and work with it in the server world. I tried to do the same in the parallel wor...