DSXchange

The actual_Sequence will only be executed once. You need to process the BU within the loop, passing the BU value via activity variable StartLoop_BU_Processing.$Counter

Does the order actually matter?

There is no looping capability in the Transformer stage in server jobs. Further, you can't assume that times will always begin with 23:05. You must learn to create general solutions. For example, the number of time/string pairs in the string is one quarter of the number of colon-delimited fields ass...

You can create the table via the Table Action property in the Connector stage.

You will get some idea by downloading some of the other Connector stage types from developerWorks - some of them even include source code.

From memory, the DB2 API is very similar to the ODBC API.

It's probably easiest - assuming an arbitrary number of time/string pairs and arbitrary string lengths - to pre-parse this string into a text file in a before-stage subroutine (making use of MatchField() function), then have your job read from that file.

You do not need to re-compile. Environment variables are read when the job starts. An entry is placed into the job log to report their values.

Check that the ODBC driver being used to connect to 11g is valid, and validly referred to in tnsnames.ora file.

Are you missing running the job that populates the hashed file from the target table?

ssnegi wrote:Since you want 0 before the input value :

str('0',4-len(DSLink.COL)):DSLink.COL

... which is exactly the expression that the original poster used.

Try changing the Data Element for this column to Date.

The values in //PURGE.SETTINGS might be the same as default, which are stored in DSParams file in the project. It would be easy to check.

... or UniVerse manuals.

Each RT_LOGnnn hashed file that has non-default purge settings will have a record called //PURGE.SETTINGS. You can view this with or, from the command line

I have checked (in version 8.7) and verified that, indeed, it is NOT possible to use a Complex Flat File stage as a target in a server job.