DSXchange

@DATE and @TIME are in a DataStage internal format. In the user variable expressions use Oconv() function to convert them to whatever format you require.
For example:

Not directly. Somewhere the qsMatchID field is coming into a stage as uint64 but the output side maps it as int64. Look at the score; there is a Copy stage in the composite operator CA_Match_Freq, and it is here that the first problem is occurring. Check the column definitions on your Match Frequenc...

Another thought. When you issue a nohup command, the PID of that process is reported to stdout, and therefore could be captured via the $CommandOutput activity variable of the Execute Command activity.

You can get the PID in a number of ways, for example enabling APT_PM_SHOW_PIDS. But this gives the PIDs of the player processes; their parents are the section leader processes, and their parent is either the conductor process or its rsh agent. And only the parent process of that will be the PID of t...

To clarify, an Exception Handler itself cannot access user variables, since it has no use for them. It can only have an Unconditional trigger. Activities downstream of the Exception Handler cannot access user variables defined outside that stream, since there is no direct connection. If there is a U...

Trying to perform cross project compare. I have (apparently) succeeded in importing the certificates from the two machines on which the projects exist. I can browse for the job on the attached project. But when I click OK in the Cross Project Comparison Tool to effect the comparison, an error is thr...

No, to do that we would have to guess, and possibly (probably) waste time.
How about some additional specifiations?

Agreed. However the system variables @DATE and @TIME are set when the job starts, so they could be used to assign values to user variables, as could the DataStage macros such as DSJobStartDate, DSJobStartTime and DSJobStartTimestamp. All of the SDK functions are also available too, via DSRoutines.

I guess we need to wait to see how kumarjit reacts.

Looking at the original post, isn't this simply a rows-to-columns pivot?

My approach achieves the expected output. I couldn't read any further requirement in the SQL provided.

priyadarshikunal wrote:Open table metadata in developer and click on parallel radio button.

Right click and choose Save As... to create the schema file.

Create and compile your parallel job. Open the generated OSH and copy the relevant schema from there before pasting into a file. Name the file with a ".osh" suffix.

If the number of decimal places is always the same, I'd try using Trim() or Convert() to get rid of the ".". If the number of decimal places is not always the same, I'd try multiplying the numbers by a sufficiently large power of ten before getting rid of the ".". And I'd probabl...

User variables are only available if they are in the same "timeline" - that is, if there is a direct path in the sequence between the User Variables activity and the activity in which you want to use them. To use a user variable downstream of the Exception Handler you will need a User Vari...