DSXchange

Let us know what database you are using, the stage involved and the actual, unedited error message please.

Of course.

Well... you could always play the old game of setting the date to the first day of the next month and then subtracting one day from it. :wink: You could also build yourself a "DaysInMonth" routine... only four possible answers after all with some pretty well-known rules for the only one th...

using kill -9 Learn what that means. SIGTERM The SIGTERM (-15) signal is sent to a process to request its termination. Unlike the SIGKILL signal, it can be caught and interpreted or ignored by the process. This allows the process to perform nice termination releasing resources and saving state if a...

What database?

However, it should just be a "between" and then give the two full timestamps. Will you be parameterizing the two values or just have all of the logic built into the SQL? I tend prefer the former so you can decide what "today" means on the fly...

Guessing that it is corrupted but the View Data doesn't stress it enough to get to the problem spot...

Did you check the documention? From what I recall the differences between those two stages are a specific area of discussion there...

Oh... why didn't you say so. Not a typical 'grouping' task nor was your desire to group 'unmatched' records all that clear. So what's the problem? You posted an expression to generate what group they need to go it, what issue are you having with it?

(I am assuming all you need is two groups)

However, the above is an example of three groups when considering ID1 AND ID2. I have no idea how you 'group' when you OR columns... but it is early in my morning.

kuldeep165146 wrote:Is there a way to achieve batch read write in java transformer

Did you even read my post?

Accounting... yuck. As noted, check the first character to know if it is a debit or a credit, convert the rest to a number and divide by 10000. Assemble the results.

Read it in with varchar fields then write back out (to a new name) with CHAR fields. Make sure your PAD character is set to a space: 0x20. I'm curious why you are doing this. Also curious what this might mean: I have shell script for the above conversion, however, the converted file occupies more mo...

chulett wrote:Before we go any further down this rabbit hole, can you answer my first question please?

So I guess it's a secret.

I did... mostly.

Before we go any further down this rabbit hole, can you answer my first question please?

First... why? Are you thinking of 'doing something' with them from the command line? They aren't files, they are stored in tables and there's one table per job. In your version, they are hashed file tables in each Project directory, in the post-7.x world they can (at your option) be in your XMETA re...