DSXchange

A server routine with ReadBlk statements may prove to be even more efficacious.

If there is no line terminator then there must exist some indicator of the length of the variable part. I don't believe the CFF stage can deal with these as yet. However, you can read with a Sequential File stage as a single string per line and parse subsequently with a Transformer stage.

You (everyone) should review the score more often, especially when new functionality creeps in. It can be quite revealing!

Look at the file with a hex viewer (UltraEdit is good) and determine what the line terminator actually is. It can't be NONE, because of the short records.

Just make certain that you don't max out on memory first. All those buffers have to BE somewhere.

Did the job actually get exported? Do a "partial" import and view the contents of the file.

Are you using stage variables? These are currently implicitly not nullable. News from IOD 2009 is that they're going to be a bit less strict with some of the things in the Transformer stage in a future release, one of those things will be better tolerance of nulls in functions, expressions and stage...

DataStage schemas support variable vectors, and you can promote subrecords using a Promote Subrecord stage. Just an idea.

Check the default limit in Tools>Options in Director client.

The message may simply be caused by your string being defined longer that absolutely necessary to store a date of the format specified in your job. But, without the details we've already requested, it's impossible to say.

Can you compile/run jobs with Transformer stages?

Range lookups are rewritten as transform operators (that is, as Transformer stages) and therefore have the same compiler and linker requirements as Transformer stages.

PX checks more thoroughly. Try removing the "Key" property from the unused column in the metadata in your job, though I will make no guarantees that this will solve your problem.

Go back into the stage and select the Index Type property. Text will appear indicating the available options and what each does for you.

The orchadmin command is the main one. If all you want is a count of the records in the Data Set there is also a dsrecords command available.

As noted your question is not really clear. You may get some idea from my answer from your other question - otherwise check the manuals. The main difference between a Data Set and a File Set is that the former stores data in the internal format that DataStage uses while the latter exports the data i...