DSXchange

This post appears to duplicate this issue. Please delete the duplicate post. Meanwhile, still waiting to see the COBOL FD that you loaded into the Complex Flat File stage.

sshettar wrote:Well i did check and the foreign key value is same as the primary key value of the other table.

The Oracle database server seems to think not.

Can you please post the COBOL File Definition? There's something you're not telling us, which is making it impossible to guess accurately.

Maybe "i" isn't very tall?

So you can mark this thread as resolved?

Do the five-way join (or union, if that's what's needed) in Oracle. Use CAST functions to match up the data types, and NVL if necessary to handle null-valued items. You can even dump it into a text file directly from Oracle.

Or a Lookup from a three row table, allowing multiple row return. Create a Lookup File Set with "X" as the key for all three columns (you will need to set "allow duplicates" to true). Then lookup against the key value "X", with the drop down list allowing multiple row returns from that reference lin...

Are you typing in the environment variable name or using the Expression Editor? I have seen folks have this problem when typing in the name, and it works fine when they insert the name from the Expression Editor's oeprands menu.

Do you (the user ID under which the DataStage job executes) have write permission to the /ds_data/METL/JOBS/WBTKEY/OUTPUT directory?

Job type is marked as server. Thread is now marked as resolved, but without any information as to how it was resolved. We share here. Please post how you resolved your problem, to help others in future. It's OK to tell us, for example, that your constraint expression was actually incorrect, but do l...

When DataStage compoents are exported, the person performing the export specifies the pathname of the export file (whether DSX or XML format). That is where it (the export file from which you need to import) is stored.

Almost all plug-in (= optionally installed) stages in server jobs belong to the class CCustomStage. It's simply an internal mechanism that allows them to inherit their fundamental methods and properties.

Nobody has been playing; they are delivered thus from the vendor.

A fourth synonym is ><

What query did you issue against the DS_AUDIT table? How did you issue the query (from what environment)?

Do the individual jobs that generate the "job control process has failed" message include job control code? Are they reported as being run under control (that is, is DSJobController reported in the detailed Status view or in the "job starting" and "job finishing" log events? If not, I have to disagr...