DSXchange

Patonp,

You won't need to recompile the jobs, the rounding is called/done at runtime.

the README on the CD should go a long way to answering those questions.

The input buffer overrun just means that while parsing this column's value the engine went past the end of string and got an overrun. Is the value "0"or "0."? There are decimal specific attributes that allow all zero values or certain string combinations, plus if I recall there are also APT_ environ...

I think that you cannot have a date field that contains only spaces - what sort of a value is that? It's like having a numeric field that you want to put all 'X' into. The date field should contain a valid date or a null value. I think you would also need to add a TRIM(inputfield) to your formula to...

You can avoid this by only having valid date values in the dataset. Having all *'s means a data formatting error has occurred. You can use a default value in the column description, or check for a valid date - perhaps you want to have a null value in that column instead of a space.

Emilio, are you looking to remove duplicates on just the first column, that is what your sample seems to be doing. In that case if your data is sorted then you can do it with a stage variable. The prerequisite of doing this in a normal stage is that the data is sorted by the columns you want to use ...

Amos, about 10 years ago I remember trying to parse the format (for a AutoCad to CADDs conversion) and I gave up as it was too complex. But if you export the files in VRML format I think that is quite close to the syntax of XML - it is certainly worth a try since the VRML is a text-based format that...

No, Ascential does not document any other method for moving objects across projects.

Thanks Ray - I did enable file caching for public sharing at this site, but assumed that it applied only to job runs and not to system files. If the functionality is part of the engine then I think we might have a winner after all.

Another method would be to use a transformer and check for INDEX(In.Column,CHAR(000),1) being zero or nonzero. The ICONV(String,'MCP') will replace nonprintable characters with '.' Since you don't know which column contains these values you could try reading the whole record as jut one column, strip...

It would seem that the segmentation violation happens with increased size in your job, although normally it shouldn't. Does it happen at the same input record and player each time - if not then there might be system conditions affecting the run as well. At about which record does this happen (i.e. 1...

I plan on firing up a daily job to check for RT_STATUS files without indices. But I am not sure that this is really going to work all that well overall. I think I need to research what other files are used and, as you surmised, not SELECTed with indices. Too bad that we don't have memory files, or t...

AutoCAD files are sequential ones with very specific formats; you would need a specific driver to parse the file contents; but nothing special to just read in the binaries. This is the same things as asking about reading MSMoney or Excel files - they can be read but not necessarily understood.

I am not sure of Version 6, but at least from 7 onwards you can specify to DataStage that a sequential file is a pipe and you will have the option of specifying read and write timeouts explicitly. Before that was in place, the only signal a reader would get is if the writer closes the pipe; and some...

I did a couple of tests today, amongst which I put AK's on all 2000 RT_STATUS file field F1 and that did make a difference, but not enough. I'm doing timing tests and file I/O (converted the dynamic files to static hashed so I could FILE.STATUS them). The system seems to be doing very many file open...