DSXchange

or make it a sub-query.

What do you mean by "output" of an SQL query?

The query or the resulting rows ?

Don't install DS Admin client on their PC.

Select
File -> Print

Ray,

Wouldn't that make 100 "wait for file" spawing and grinding the machine to halt !!??

If the incoming file has different name parts (e.g. datetime attached to their name), all seq.s can be scheduled so it can be gathered at cob or periodic intervals.

If you open the designer in new env, can you see the buildop under its category?

If you open the designer in new env, can you see the buildop under its category?

Did you register in the new env ?

Doh!! Me and my PX !! In server, depending on volume, you can 1.) Use ODBC link 2.) Create db link 3.) Use hash file with combined rows 4.) Simulate multiple rows from rows so each with gather one reference row. There are other methods also. Need more information on what you are attempting, volume, ...

Use 'returns multiple rows' options.

Does it close to hide behind other window(s)?

Try minimising all other windows to check.

Did you attempt any network trace or doing the same from a fixed PC in the network (i.e. non-citrix) ?

If I understand correctly, are you saying that there can be variable number of columns ??

In that case, how do you intend to store in a db? The structure will be variable.

Also, you may be better-off using features in xls to change (pivot) the result.

If I understand correctly, are you saying that there can be variable number of columns ??

In that case, how do you intend to store in a db? The structure will be variable.

Also, you may be better-off using features in xls to change (pivot) the result.

Have you ticked on/off the nullable property in source?

Did you search?

This has been discussed loads of times.