DSXchange

Note - prefix and suffix each char in pattern file with space. Or make another sed to do it.

What have you made out of it so far?

Does the source file have any record in it?

Maybe you have a sleep in the script.

Check the Finished and Starting times for jobs.

Also can you log messages from script to see when it really finishes.

How many people and working / running ds jobs?

A and B within quotes may be taken a literal.

Display the FileBack before executing.

What are the resulting values for out and Return?

Create a new job with
one Oracle input stage with
one column 'testCol' which is Varchar2(10) and
sql is 'user-defined'
with SQL statement as

select 'x' testCol from dual
UNION ALL
select 'y' testCol from dual
UNION ALL
select 'z' testCol from dual

and try to view data.

Does the query (with unions) run successfully in the db outside DataStage?

Is there any blank lines or special characters embedded within the SQL?

Did you try opening the jobs and see its properties, view data etc?

There are some issues where 8.1 does not have few oracle stages and they are to be installed separately.

...then run

search for getlinkinfo

What about 20th job?

Maybe they have fixed the issue in the past 2 years !!??

Use DSLogInfo

What is the datatype for target column ?

The format must not be dependant on the version.