DSXchange

You can do an outer join user a merge.

But you need both source for merge in form of a seq file.

Can you post the error message in full. It will provide more info.

Craig's idea is the best if you cannot code batch control and include the timings as parameters.

Otherwise, you can also include them as cron entries.

Please do not post the same info more than once.

Your previous post is answered.

Search the forum for DSGetJobInfo.

You can find the details from 'About DataStage' option.

You need to create a sequencer or batch control job.

Before that you need to ensure that they will finish within the hour.

Try
LIKE '9999999999%'

Is it an user-defined sql?

You may be including more variables than the columns into the link.

What I meant was to obtain the sql loader control and data created seperately (search forum for details) and then load them externel to your job.

You will also be able to tune and enhance performance by that way.

Include a apostrophe comma just before the field value.

The details of lookup is provided in the docs that come with the software. Try it and if you have any doubts or problems, do let me know.

1.) You can schedule a sequencer and include your jobs in the sequencer
2.) You need to define the schedule user-id and pass in the DS Admin.

You can do that will a lookup itself.

You can import by selecting all to be char field.