DSXchange

If you need to pad leading zeros, look for fmt function.

Just to make sure, did you load these environment variables before restarting datastage?

You can check the current env settings from administrator or manager.

As Craig suggested, loading user bulk-loader from DataStage is not efficient. You can also improve performance of bulk load when you perform that externally.

You may also need to alter any user-defined SQL to adhere to the syntax of new RDBMS.

You need to 'call' the stored procedure.

Can you check whether you can import any objects from the SQL Server to confirm the connectivity.

Did you check the format and content of source and reference data?

You can try to set default value to test the lookup working fine.

You can try to delete and re-create your hash-file in case of any dictionary problems.

If you are creating batch jobs, the invocation id prompt will appear when you add the multi-instance jobs to your job control.

I was asking whether you can run sqlplus from your DataStage server machine to connect to the Oracle instance you wish to see from DataStage.

You can do a
if num(yourvalue) then 'number' else 'not number'

Can you do a
'sqlplus user/pass@sid'
from your datastage server using its configuration settings?

It is the log of lock deamon. You can empty.

You can do an usage analysis to obtain the jobs where the stage is used.

You need a real-time mechanism. Check the real-time options and let us know if you need any assistance.

When the data contains delimiter char, use a different delim char.

When the data contains line terminator, use convert to replace to blank.

Simplest is to do an 'Usage Analysis' from Manager.