DSXchange

... or just stick with the if-then-else logic posted.

Only other thing you might want to account for are values outside the 1-7 range. Justin Case.

I would imagine they are like any "core" files and are created when one of the client tools aborts/abends/falls over dead. Is that really happening to you daily?

Good to know and now that we know that, feel free to edit your post and replace it. I sent you what I removed in a personal message so you shouldn't even have to dig it up again.

I'm going to leave this post in the General forum for now, as it applies equally across products but may move it if this goes all PX only on us... stay tuned...

:idea: First bit of advice is to not use abbreviations unless you are sure it is common enough that everyone will know what it means. Otherwise, it's always prudent to spell it out so there's no confusion or wrong turns made on your road to a solution. Second bit is to have some patience. PII is som...

1. Yes, they are numbered bind parameters that correspond to the column numbers.
2. Why? Using 'anonymous block', i.e. BEGIN/END syntax is the proper way to be doing this. Assuming Oracle here, btw.

OK, sorry, not sure where I got the impression you were reading one. Unless there's a setting that overrides this, as previously noted you can't create a "fixed width" file from variable character fields - use CHAR instead. And let us know all of the settings you are using in your target S...

sri75 wrote:Thanks anbu for your reply.It did work, but I need to truncate leading zeros. when I tried with decimaltostring function it is truncating both leading and trailing zeros.

You might want to post the syntax you were using for this.

ray.wurlod wrote:

kerpal_dog wrote:Tried setting the APT_AUTO_TRANSPORT_BLOCK_SIZE to True (as per documentation suggestion) and same old stuff.

That can't be right - it would give you a block size of 1, where you really need it to me much higher, maybe 1MB or more.

It seems you missed the 'auto' part of the parameter.

Of course, it can matter but not in this specific case.

I don't know either. If you really want to find out, you'd have to involve your official support provider, me thinks.

Just curious why this is marked as Server and in the Server forum. Are you licensed for PX? FastTrack only generates PX jobs...

You can run any valid script or UNIX command as long as it is in your PATH or properly pathed. Not sure what's up with your leading "dot", that's certainly not needed, though.

No, you don't, they'll know all about it as it has nothing to do with DataStage and it's all in their home court.

You probably saw ExecSHSilent rather than 'Client' and that just suppresses log messages. ExecTCL let's you execute Universe / TCL queries, typically against the repository.