DSXchange

Could any one please help in understanding what alt_call_name,alt_u_call_name are in DSParams function specifications Below is a syntax for function specification in DSParams /* Each line consists of: FunctionName\NumberOfArgs [ - MaxNumberOfArgs ]\Description\FunctionCategory\returntype\argtype:arg...

Hi After going through the documentation it was my understanding that, when a loop condition is specified the transformer reads input records and processes stage variable then evaluates the looping condition and if true evaluates loop variables and flushes the record to output link and if the loopin...

The upsert mode in any database stage has trasaction count which defines how many records are bundled in one upsert operation also in some cases we have the flexibility of defining "update then insert" or "insert then update" Having said the above I was wondering if a record fail...

When in Designer , this property can check/uncheck ? I assume the when of above is where. Well just go to the properties page and you will find the option at the bottom go ahead and remove the property. And I still hold on to saying, the property is not a default and should have been explicitly set.

Well another intresting thing which I noticed is that, in general when we keep a sequentail file stage and either if we are reading from or writing into, the link parition symbol will be "specific parition marker" . But the jobs which got hang were having "Auto paritition" blue ...

I was wondering if a "WITH UR" clause is put in the user defined query section of DB2 connector stage while reading from table and Isolation level is set to "Cursor stability" which would be given the priority?

Please share your thoughts.

Thanks

what is the tr command used for ? Better practice is to read the fixed width record as single column without filter command on multiple readers per node and then use filtering options followed by parsing the single record into multiple columns using substring functions. The added advantage would be ...

The log shows that pid's are created and then the log doesn't get updated so you can take the player pid's and go to the node where they are running and run ps command to see if all those pid's keep running or did the player pid's finish after execution and then check if the section leader finish to...

If transformer is replaced with copy and database with dataset would the job still behave the same ? Also track the player processes pid's to see if all of them on both nodes keep running or if any finish

I have seen cases where operator combination causes job to hang, try running with APT_DISABLE_COMBINATION=TRUE

Is there any documentation that details the activities performed when indexes are rebuilt (DS.TOOLS ----> option 2)

And also which repository tables are reindexed.

Thanks

Yes Paul, I too feel sequencer.sh is not a good option if the downstream jobs are bulky and the documentation also mentions the same that sequencer.sh to be used when the sequence has multiple light weight jobs to reduce the startup time which for light jobs might be comparable to run time. As of no...

If it is somehow pulling information of upstream tsort operator just wondering what if the source is a sorted sequential file.

pretty nice !!! but just curious how

Below is taken from help window of Datastage If the argument specified is the secondary or other sorted key, then LastRowInGroup() returns TRUE if the value of the specified column is about to change, or if any of its higher level of key columns are about to change. For example, if the primary sorte...