DSXchange

An indexed work table with a commit_grp_id and row_Seq_no may work? Have one time job to do a parametrized select . For partitioned loads limit the number of partitions to 4 or 8 , use a modulus partitioning on the row_seq_no field ( if possible) , and select based on the minimum common record loade...

I was also thinking of any environment variables that may affect handling of NULLs, apart from the compiler+linker & its options .

will any datastage env variable settings affect the compiler generated code ?

what about the resources and time consumed in doing the lookup operation itself? Im assuming the source data is itself a load ready file or dataset or a 'load ready' work table .

What is the datatype definition of the Oracle COlumn that holds the XML data ? Are you writing the entire field directly to a seq file /datastet stage ? What is the column length you defined ? If an oracle column is defined as SYS.XMLTYPE it can reach upto 4 GB for each row. Can you parse the XML ? ...

You will need to fork(split) your data into 2 streams - using filter stage or transformer stage with constraints - the rows selected for oracle processing will go through oracle stored proc stage and form one input to a funnel stage The other rows that dont need oracle function to be executed will b...

Is there any stage in Datastage Server v 7.51A that supports reading from Oracle databases using the 'light weight' Oracle Instant Client ?

We also have mainframe edition - but mainframes say 'Oracle ? What ? '

The documentation for OCI stage precludes this option.

The best sites to learn about Xpath. XSLT and XML are the w3 websites. Tutorials will help , but w3 gives you an understanding that surpasses all else ( at least to my knowledge) - since all explanations are detailed and verbose - though not everyone likes it that way . The XML pack reference in dat...

Are you using a stage variable for these derivations ? use NullToValue or NullToEmpty in case of string fields or NullToZero for numeric fields in your stage var derivations - it can help.

I assume you can use 2 seperate queries and combine them with a funnel , parse the clob data and remove duplicates from resolved fields if that was ever an option. I really do not know at this moment if you can set the entire clob data column as a key for removing duplicates though . Was the CLOB da...

The COBOL metadata spec ( Usage) in edit row dialog box allows me to define COMP-3 - in the Fixed width flat file stage on the mainframe job canvas. As I expected ( or rather feared) this feature is disabled in the delimited flat file stage and the external target stage .

Rather than hijack this thread, can I write output data in COMP-3 using mainframe job stages ? We have a mainframe job license - but rarely use that otherwise valuable 'feature'.

Cool . Ray's suggestion works- - I disabled Show Categories in director ( under View Menu) , and then sorted the display list by the "At Time " column - all scheduled jobs can be made to display at the top of this list.

Thanks Ray.

Im curious , if a director report can be printed listing all scheduled jobs . The only way i know is to peek all folders carefully when the schedule view is enabled

Yes , the deadlock daemon is enabled

cfg file settings