DSXchange

No. PDF does not support this functionality.

You might consider, too, whether there is any limit on the length of a SELECT statement.

Can you use user-defined SQL and, if so, does it exhibit the same behaviour?

My guess would be one of the bazillion conf files under WebSphere/AppServer.

This is not a Cognos forum. You might have better luck with your "refresh button" in the DeveloperWorks site (IBM) for Cognos. I suspect there's no such thing, but always happy to learn. Certainly you would need to re-import in DataStage, and use impact analysis as I mentioned before to de...

Draw a graph of what? Using which tool? Your questions seem very vague.

If I recall correctly, you can create and catalog your UniBASIC or create a PAragraph and call either as a stored procedure. You probably need to re-run VSG over the account. You should then be able to import the stored procedure definition into DataStage. (This is a pre-requisite to being able to c...

Does your Unidata stage have, as one of its methods, "Call Stored Procedure"?

(It's not a stage I've ever worked with, despite having extensive U2 experience.)

No, Char(0) is an actual character. Unfortunately, in ASCII it's called "NUL". It's the character used in C programming to terminate a string. It's not the same as NULL, which represents "value unknown". You can only test IsNull() or IsNotNull(), or handle null with functions suc...

That is, we're more here to help you to learn than to provide solutions. That's called "consulting" and comes at a price.

Could you write a UniBASIC program or a PAragraph and call it from DataStage as if it were a stored procedure?

Nothing changes my previous answer. The dscmdimport command is executed from the operating system.

Port 9105 is not a default port for Information Server. Review the install log to determine whether someone performing the installation set this rather than the default port number.

In Cognos or in Information Server?

I'm not aware of any in Information Server, you do need to re-import. It's also wise to perform an impact analysis (in Metadata Workbench and, if desired, within DataStage) to determine where the changed table is touched or relied upon.

Stage variables are not cleared between rows. When a stage variable is yet to be evaluated for the current row it contains its value from the previous row (or its initial value if the row being processed is row number 1 on its node).

No, because dscmdimport is not executed from within dssh. It is executed from the operating system shell.