DSXchange

Welcome aboard.

Yes it works. You will need the Eclipse plugin for SubVersion. Once you have that you're pretty much up and running.

Manage your artefacts through the Team menu in Information Server Manager.

I assume that you actually have a string field, since time fields don't have a format (they are stored as binary numbers). Simply prefix the string with a "0" character and use the rightmost six characters of the result, with "%hh%nn%ss" as the format string. Right("0" ...

The amount of time you've wasted trying to figure out an "automatic" solution you could have manually edited the jobs directly.

Apparently the header line does not contain the string "HEADER".

One feasibility that comes to my mind is to specify a value file at the design time but change the values in "that" value file, on the run-time. But this is not a good one for my needs. Why not? This is a technique I use frequently. You should be able to specify a parameter in the sequenc...

What is the data type in DataStage?

Does not the SCD stage allow one to specify some columns for Type 1 handling and others for Type 2?

I gave up on Craig and grammar many moons ago.

<grammar nazi>
It would be best if there were three or more options. Here, however, there were only two options (to fix, or not to fix, that is the question), so the comparative adjective "better" should be used.
</grammar nazi>

Actually "squib" originates in the UK.

Change from a Record Delimiter property of "UNIX Style" to a Record Delimiter String property of "DOS Style".

The 0d on the end of each record is the carriage return of the DOS style line terminator.

Better practice is to identify the causes of the warnings and to try to eliminate them.

When you run a job from Director or Designer the Job Run Options dialog allows you to set a non-default limit on the number of warnings.

There is something like a file list in DataStage Sequential File stage; you can specifically name each file (multiple File properties), you can use a wildcard (File Pattern), you can use a Filter command to pre-read the files. The Filter command could even be constructed dynamically in a UNIX script...

Adding FILLER is neither difficult nor time consuming.

Eleven years later - is that a DSXchange record?