DSXchange

Can you access other projects?

A Copy stage that makes an identical copy of its output will be optimized out of the job design (it's not needed) when the score is created. Setting Force=True prevents this from occurring, forces the copy operator to be retained in the step design.

pandeesh wrote:The logs get stores in RT_LOGxxx hashed file.

Not necessarily. It depends on how RTLogging and ORLogging are set.

You're overwriting Ans each iteration of the loop. You need to accumulate perhaps a delimited list of values in Ans. Use a different variable to test the comparison between Arg2 and Arg1.

Search for CENTURYPIVOT.

Inputs to match specifications MUST be Data Sets. Not sequential files, not DB2 tables, not anything else.

All this information is stored in database tables, which obviates "looking at them" using operating system utilities. Job names, types, numbers and alias are stored in DS_JOBS while all other design-time objects are stored in DS_JOBOBJECTS - at least this is the case in versions 5.2 and la...

Try ISO8859-6 for DataStage, which is the setting used for Oracle.

Welcome aboard. If you have the software, you have the manual. Try Start > All Programs > IBM InfoSphere Information Server > Documentation

You do this (what Eric suggested) using "derivation substitution". Select all the columns that you want to change in the output link of the Transformer stage (the ones that are CHAR coming in and VARCHAR going out), right click, choose Derivation Substitution, enter "Trim($1)" as...

What else is in logfile?

What function do you think it will perform that DSXchange does not already perform? Or DSXchange and DeveloperWorks in combination?

Have you ever edited the UV.ACCOUNT table?

You can always copy-paste link names.

Definitely possible.