Re: Any Documentation on ACS's DTFXs?

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Robert

Have you looked at the help in the Data Transfer interface? There might 
not be direct information about DTFX, but it might get you started. I 
did discover that there is an option to use native SQL or Data Transfer 
syntax in Properties, I think, in the interface.

As I don't use Data Transfer anymore but have to support some of it, I 
wonder, how do you prompt for user input? With TTO files, people here 
open them in the interface and change what they need to - like date 
ranges or account codes.

HTH
Vern

On 7/25/2022 1:55 PM, Robert Santuci wrote:
> I can find nothing on how to use the
>
> SELECT=
> SQLSelect=
> WHERE=
> JOIN=
>
> statements and how they interact.
>
> We have plenty of simpler examples, but the one I am working on is joining
> 4 files, some with conditions, and also prompting for user input as 
> part of
> the selection.
>
> Thanks.
>
> Bob