DSXchange

For starters, it's C++, not C. You will potentially see lots of classes mentioned that are not part of standard C. The C++ source code is retained within the project directory, in a sub-directory called RT_SCnnn (RT = runtime, SC = source code, nnn = the job number from DS_JOBS).

The tag value is how a variable subrecord implements different structures. For example the subrecord may contain a US-format phone number (3-digit area code) if the tag value is "US" but a French-format phone number (2 digit area code) if the tag value is "FR", and so on. How is ...

Can you please show how you call the function?

Given your data types this is a spurious error ("they" are being over-cautious). Use a message handler to demote it.

You need to execute this in sequential mode.

You can't use the DataStage SQL directly. You could use an Execute Command activity to invoke the DataStage shell (dssh) to execute the command. $DSHOME/bin/dssh "UPDATE SDKSequences USING DICT VOC SET F1=1 WHERE F0 = 'MySequenceName';" If you don't have $DSHOME set, hard code the full pat...

You can also use a cat command, even though you are on Windows. You have MKS Toolkit (a UNIX emulator) installed.

I go, I come back. You can't invoke the key management routines from an Execute Command activity but you can invoke them from a Routine activity. It should work OK even if the Routine activity is within a loop. Note, however, that sequences treat non-zero return values from routines as failures, so ...

Ans. Not nAns.

DSAttachJob()
DSSetParam()
DSRunJob()
DSWaitForJob()
DSGetJobInfo()
DSDetachJob()

and probably others.

Welcome aboard.

There are three panes in the Customize Palette dialog - try to drag from the one that you are not yet using. If that doesn't work, select stage types and use the arrow button.

Try typing in the routine name in User Variable expression. If that doesn't work use a Routine activity.

Where is the Ans variable in DSLogInfo() assigned its value?

Try removing the link sort settings. At best they are redundant. Just hash partition on id column (modulus partition would be slightly more efficient). Please post the output under this scenario.

Hash partition specifying id as the key? Sort specifying id as the first sort key then the other input column (col1) as the second sort key?