DSXchange

There are no limits. The original UniVerse database storage concept allowed for completely arbitrary stucture sizes (limited only by machine resources).

Some log messages, particularly those returned from Microsoft ODBC data sources, are thousands of characters long.

COUNT does not list them. LIST does. Or you can use SQL.

U is one of our posters, and is not involved in this thread. The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange; it helps those whose first language is not English. There's no need to ...

Don't assign the third argument to Ans; assign the fourth argument.

Are other QualityStage stages active? If not, I would suspect that you have licensed DataStage but not QualityStage on that particular server.

If you do use OpenSeq please take the trouble to use CloseSeq. OpenSeq sets a lock on the file which CloseSeq releases.

There's nothing wrong with your English.

Alas, there is no way to include cross-project dependencies, other than to design it in, as you have done.

Have you configured the four compiler/linker-related environment variables correctly?

Did you create System DSNs or User DSNs? DataStage can not work with User DSNs.

In the Connect to DataStage dialog. I'm trying to take name resolution out of the picture as a potential point of failure here.

You don't need to open the files to use FC. Prefer DSExecute() to DSU.ExecDOS to eliminate the "no output from command" report as a routine result. Command = "FC /B file1 file2" Call DSExecute("DOS", Command, CommandOutput, ExitStatus) All of the output is captured into...

Can you try changing the file definition so that the field definitions are in correct positional order?

(Clutching at straws a bit, I admit, but it's been a long time since I used QS version 7.)

0xB3 is a single byte. ISO8859-1 maps should be able to handle it. So, given the other diagnostic work that you've done, I cannot see why it should be generating "incomplete row" only because of that character. Can you check to see that every row in the file contains the correct number of ...

The routine needs to attach the job (to get a job handle), invoke DSGetLinkRowCount() with appropriate stage and link names, then detach the job.

There are many examples posted on DSXchange.