DSXchange

What are your source and target stages? Do you have inter-process row buffering enabled?

Is there a "temporary directory" setting in the DSN definition in .odbc.ini?

Welcome aboard.

You could do this with a server job (rather than a parallel job) using the UtilityRunJob function. By this means you could pass the record, or some part if it, to a job parameter.

If you recompile the job(s) in question that should reset the wave numbers.

Typically that error message means that you've left one of the Precision fields in the Columns grid empty when the data type requires a precision value. Start by looking in the tenth row of each Columns grid, since the error message refers to the tenth (bound) parameter (or field).

That will be entirely driven by business requirements. A business analyst will have analyzed the business requirements and produced one or more source-to-target mapping specifications. The file designs fall naturally out of such documents.

There is no "one size fits all" answer.

I think the big Convert() remains the best bet. FUNCTION LoseThem(TheString) COMMON /NonPrintable/NonPrintable Ans = TheString If NonPrintable = 0 Then NonPrintable = "" For i = 1 To 31 NonPrintable := Char(i) Next i For i = 128 To 255 NonPrintable := Char(i) Next i...

A 101-row hashed file lookup table mapping mark to grade would perform best. You could use an expression with three nested levels of If..Then..Else. You could create a routine that does the same thing.

Try "D-MBYL[A3,2]" as the second argument of Oconv().

I was not able to see the complete message and if i can get the details of it. I would subscribe to premium membership now. "If you give me a dollar for a hamburger today, I will gladly repay you next Tuesday." J. Wellington Wimpy Premium membership, as I am sure you have already read, is about pay...

There are quite a few sites doing this. Get in touch with IBM, who have a group dedicated to supporting grid implementations of Information Server.

You will need to open a new Director after changing the Administrator setting. You should not need to restart the services.

JobMonApp has its own start up program, from memory JobMonAppInit. Search the forum - it's here somewhere.

Partitions are independent. Uniqueness across partitions is not possible. That's why you need to partition your data on the same keys that you need to group, sort or remove duplicates.

Padding is done with 0x00 (ASCII NUL) characters, not space characters, because this is the value of the APT_STRING_PADCHAR environment variable. Change this to space if you want padding to use the space character.

On what basis do you claim 45 rows/sec is slow? Could YOU do it faster? There can be a heck of a lot of work involved in generating XML from a rows-and-columns format; this means many CPU cycles, and this means time. TAANSTAFL