DSXchange

Thanks for your anwers.
As Datastage is generating BASIC code, I was hoping that there would be a tool which scans the BASIC code. These kind of tools are very popular on the mainframe (good old IBM, COBOL, ...) .

Regards
GuidoMarcel

Hi, I am interested on a tool which allows to help me answer the following questions: * which job is reading which table / view * which job is manipulating a certain data element * which job is updating a table /view Is there any tool on the market to perform such cross reference analysis? Many than...

Thanks for your answer. I will run a DB2 stored procedure without any in, inout, out parameters. I will try to do it with the DB2 API stage in the before section.

Regards
GuidoMarcel

Hi,
is it possible to call a UDB / DB2 stored procedure with Datastage v7? It seems that the stored procedure stage is only foreseen for the database vendor ORACLE.

Regards
GuidoMarcel

also thanks! :D

thanks :D

Hi,
thank you very much. Knowing that it is not possible with the built-in functions is already of great help. My compan has no premium account. So, I can not read the rest of your answer. I will try myself!

Thx!
GuidoMarcel

Hi, I have the following situation: I selected records from a table. The record contains a field called option_string which may contain 0-n time a 4byte option. This means the field option_string may look like this: 471 DC12AS21RT 65T5FGV3 or like this: LK12L23 DE3 SW2 AQ1 FR4 DE34RF45 Now, I have t...

Hi,
what is with the option "Multiple Line Output" in the XML Writer stage? This option turned to "0" will avoid carriage returns

Regards
Guido

Hi, does anybody know if (and how) Datastage can store data in DB2 CLOBS?. We have an XML file and want to store the data "as received" in a DB2 CLOB. We define the XML-string as SQLtype=Varchar or LongVarchar, or Char, but the only answer we get from the DB2 stage is "invalid convers...