DSXchange

More efficient. No overhead in calling the library created by compiling the Transformer stage, which would be significant in a one-row job.

I think the echo approach would be the most efficient of all.

You actually have PSEMNUM of these public semaphores

Specify the Missing Column rule (in the Columns grid) as Error or Warning.

A Row Generator stage would be more efficient. Again specify to generate one row. Put zero into each column. You don't need an input file, null or otherwise.

Why not just as a command?

Are there indexes on ROLE and CYCLE_MONTH?

No.

It's a registry entry, and it remembers the most recently used file path.

Which is pretty much what you're asking for, isn't it?

Welcome aboard! :D

Basically the answer is no. Saved does not necessarily mean complete.

There are third party multi-compile tools around - search this forum for more information.

But automatic? I think that is basically a Bad Thing.

Good that you have a working solution. You could have done it with one Pivot stage.

There is no Trim() function in a Modify stage, but there is substring. However your assertion that you can not use any other stage type is simply incorrect - you could follow your Modify stage with any other stage type, such as a Transformer stage, and effect the Trim() function there. However, Trim...

What exactly do you mean by "a null file"?

The design is easy enough, but needs a specification of what must be in the one row of your output file. For example you could use a Row Generator stage to produce that. But what should be done with the "null file", whatever that is?

Are you missing an underscore in CURRENT_DATE ?

Beware that the function name will depend on where you are executing. For example the equivalent in a Modify stage is called date_from_julian_day (all lower case, with underscores). You have found a function that is for a Transformer stage. Yes, that will give you the ordinal day number in the year,...

When you export do you check the box to include the routine binaries? The routine binaries are the compiled version of the routine.

any one i want real help man not suggestions why you people dont understand i gone through the manual but when implementing its different . so pls help me You want "real" help. Then you go to your support provider and pay for it. Everyone here volunteers their time and their ideas. If you don't lik...

Even easier is to treat the incoming date as a string. You can do this in server edition. Then another possible answer is