Db2 - L

We wrote our own tool using opensource .NET CSV libraries and Progress .NET DB2 Provider. A simple app that you drop SQL into and it assumes all columns in the returned datatable become delimited output. Usually, pipe delimited but it can generate ...

Some of the queries are reasonably complex e.g. RIGHT OUTER JOINs or CTEs, so would DSNTIAUL will cope with them (I haven't used it for ages)? What do you mean by "windows client" in this case? As I said, we don't allow direct ODBC connections (e.g. ...

Well, I use DSNTIAUL or a windows client for large unloads. I write SQL that generates a comma delimited file. Basically, using functions to convert everything that isn't character to character and concatenating them all together with commas. Once you ...

We often get asked by the business to run ad-hoc queries to extract data for incidents / problems / whatever, where the result set can be hundreds of thousands or even millions of rows. The tools we have at our disposal are basically mainframe programs ...

That's downright sneaky. Me 'at's off to ya. :-) Philip Sevetson Computer Systems Manager FISA-OPA 5 Manhattan West New York, NY 10001 psevetson@fisa-opa.nyc.gov 917-991-7052 m 212-857-1659 f