DSXchange

Why do you think there's an error? One possibility is that there are no rows in the Data Set. More likely, though, is that you are trying to read the Data Set with a configuration file that is incompatible with the one with which the Data Set was written. Can you access the Data Set with the Data Se...

What you posted is not the licensing score, as yours has a Transformer stage mentioned.

DSDexter's analysis is correct. The score is an optimized variant of the osh that was generated by compiling the job design.

Orchestrate (via orchdbutil) is usually to be preferred, as it is more accurate.

Can you execute the same SELECT statement via any other client (not DataStage)?

Hi all, How to generate schema file definition from oracle tables?. for ex: i have table with table field information ie., table_name field start_lenght end_lenght t1 col1 1 4 t1 col2 5 10 t2 col1 1 2 i need to pickup this info and generate a ds schema file can any one help with ideas/clues.. Thank...

You need a "fork join" design. Use a Copy stage to send the first column through an aggregator to get counted, then join back to the detail rows with a Join stage. You will have the count along with each detail row. Then filter based on the value of the count.

Did you try what bala_135 suggested, opening the file definition window first?

If it's VARCHAR2(60) in Oracle and you import it, you are likely to see that it imports as VarChar(180) or even VarChar(240). Use whatever imports.

Surprisingly???

There is a long and comprehensive document on configuring DB2, which was prepared by the Ascential support group. It is available through your support provider.

What error message is logged when the job aborts?

Try using wc -l filename as the Filter command.

As soon as you choose File Pattern as the read mode, First Line is Column Names property becomes invalidated. You even get an advisory message box telling you that this is the case. On that basis I don't believe you can call it a bug. Add a reject link to the Sequential File stage to capture the hea...

Depends what "the file names are all different" actually means. If they are sufficiently different that no suitable wildcard pattern can be found, then multiple File properties with a mode of Specific File is likely to be preferred.

The error message suggests that there is a value in your data that has more than five significant digits.

Include the DataStage bin directories in your PATH (command search list) environment variable if you want to avoid typing in full pathnames.

And, if the system reports that APT_ORCHHOME is not set, you can be fairly confident that this is the case.

That is my understanding also. The settings have to be compatible - Output with reject link, or something other than Output and no reject link.