DSXchange

Read the documentation on Trim(). It does not remove internal spaces; it reduces multiple contiguous occurrences to a single occurrence. Perhaps you need Convert() instead?

Welcome aboard.

Go to the Columns grid and double-click on the row number of the Date field. Find Field Width in the Available properties to add, select it, and specify the width required in the output file.

Go to the stage properties. There are two useful tabs there.

Trigger allows you to add before/after parallel (C++) routines.
Build allows you to override the compiler flags set in APT_COMPILER_OPTIONS when the Transformer stage code is compiled.

Hey, bigpoppa, welcome back!

Did I miss something with my suggestion to use an Aggregator stage? It looks very much like SELECT Key, Min(EffDt), Max(EndDt) FROM input GROUP BY Key to me.

It's the format of the output. Difference stage yields regular columns; Change Capture puts the input rows into subrecords.

Which login ID were you using when issuing the command? Under which login ID was DataStage installed?

Hay.... 1: if the error is "Job being accessed by another user"that means same job is opened in another session.Please close that session or close dat job from datastage canvas. 2:if your job is hanged up and nothing is working then restart the server. but before doing dat please try to kill that p...

Welcome aboard.

What operating system?
Can you open the other client tools?
How far do you get with Designer? Is it the splash screen that disappears, the login dialog, what?
Can you open Designer from the Tools menu of one of the other clients?

I'm not a lawyer and therefore hesitate to comment on the licensing agreement.

Nor can I suggest any strategy for determining, from what's on the server, which QualityStage Designer deployed it, other than to check them one at a time.

Yes, and we've seen why it can behave that way. So you need more rigorous checking than is possible relying upon defaults. What do you want to happen for source data of this kind? How about a check such as Index(InLink.TheString, "/", 2) > 0 in addition to the IsValid() check?

Let's do the math. 1,73,37,22,784 bytes divided by 300 lakh rows = 58 bytes per row (approximately). That seems reasonable.
So how much free disk space do you have in the file system on which /dsetlsoft/datastage/Ascential/DataStage/Datasets exists?

Any messages generated?
What is the exit status of dsjob?
Include -jobstatus option and post whether that makes a difference.

The "0" and "5" are ignored because your date format string specifies delimiters in these positions.

The first question is what should be the result from this number?

<color=blood>
Premium membership helps to pay for the bandwidth costs of DSXchange. It only costs a few cents per day, and it's definitely worth it, not least because it helps to ensure that DSXchange remains alive.
</color>

Welcome aboard. Curiously you are not the first to encounter this, not even the 1000th. It results from the defunct process (the agent process whose connection was broken) no longer being accessible to be told to free the lock. If you look at the menu at the top of this page you will see a Search op...